做的一小部分东东,由于是菜鸟,基本就是原地打转,什么都不懂的感觉真糟糕,完全靠老大指点在做.
先考样式表和动态DLL文件到自己机器上,拿到需求在ORACLE做几张表,然后开始干活
第一个页就是一个GridView,加上俩按扭,其中用到一个日期控件PopCalender是网上找的后老大改了改拿来用,比软件自带好使一点,差别不太大
<
head runat
=
"
server
"
>
< title > 无标题页 </ title >
< link href = " ../css/StyleSheet1.css " rel = " stylesheet " type = " text/css " />
</ head >
< body >
< form id = " form1 " runat = " server " >
< table >
< tr style = " height:30px " >
< td align = " center " colspan = " 10 " >
< asp:Label ID = " Label1 " runat = " server " Text = " 运行日分析 " CssClass = " TitleStyle1 " ></ asp:Label ></ td >
</ tr >
< tr >
< td style = " width:80px;text-align:right " > 起止日期: </ td >
< td style = " width:80px;text-align:left " >
< cc1:PopupCalendar ID = " PopupCalendarBegin " runat = " server " txtWidth = " 70 " />
</ td >
< td style = " width:30px;text-align:center " > → </ td >
< td style = " width:80px;text-align:left " >
< cc1:PopupCalendar ID = " PopupCalendarEnd " runat = " server " txtWidth = " 70 " />
</ td >
< td style = " width:60px;text-align:right " > 类别: </ td >
< td style = " text-align:left " >
< asp:DropDownList ID = " DropDownListDayType " runat = " server " >
</ asp:DropDownList ></ td >
< td style = " width:60px;text-align:right " > 值别: </ td >
< td style = " width:80px;text-align:left " >
< asp:DropDownList ID = " DropDownListZhiBie " runat = " server " >
</ asp:DropDownList ></ td >
< td style = " width:80px;text-align:left " >
< asp:Button ID = " Button1 " runat = " server " Text = " 查询 " CssClass = " ButtonStyle1 " OnClick = " Button1_Click " /></ td >
< td style = " width:80px;text-align:left " >
< asp:Button ID = " ButtonAdd " runat = " server " Text = " 添加 " CssClass = " ButtonStyle1 " OnClick = " ButtonAdd_Click " /></ td >
< td ></ td >
</ tr >
</ table >
< table style = " width:100% " >
< tr >
< td >
< asp:GridView ID = " GridView1 " runat = " server " AutoGenerateColumns = " False " Width = " 100% " OnRowDataBound = " GridView1_RowDataBound " >
< Columns >
< asp:BoundField DataField = " DAYDATE " HeaderText = " 日期 " >
< HeaderStyle Width = " 80px " HorizontalAlign = " Left " />
< ItemStyle HorizontalAlign = " Left " />
</ asp:BoundField >
< asp:BoundField DataField = " DAYTYPE " Visible = " False " />
< asp:HyperLinkField DataNavigateUrlFields = " DAYDATE,DAYTYPE " DataNavigateUrlFormatString = " RunAnalyseDayRec.aspx?daydate={0}&daytype={1}&actionname=View "
DataTextField = " daytypename " HeaderText = " 类别 " >
< ItemStyle HorizontalAlign = " Left " />
< HeaderStyle HorizontalAlign = " Left " />
</ asp:HyperLinkField >
< asp:BoundField DataField = " DAYNUM " HeaderText = " 值别 " >
< HeaderStyle Width = " 80px " HorizontalAlign = " Left " />
< ItemStyle HorizontalAlign = " Left " />
</ asp:BoundField >
< asp:BoundField DataField = " USERNAME " HeaderText = " 填报人 " >
< HeaderStyle Width = " 80px " HorizontalAlign = " Left " />
< ItemStyle HorizontalAlign = " Left " />
</ asp:BoundField >
< asp:BoundField DataField = " STATUS " HeaderText = " 状态 " >
< HeaderStyle Width = " 80px " HorizontalAlign = " Left " />
< ItemStyle HorizontalAlign = " Left " />
</ asp:BoundField >
< asp:HyperLinkField DataNavigateUrlFields = " DAYDATE,DAYTYPE " DataNavigateUrlFormatString = " RunAnalyseDayRec.aspx?daydate={0}&daytype={1}&actionname=Modi "
Text = " 修改/删除 " HeaderText = " 操作 " >
< ItemStyle HorizontalAlign = " Left " />
< HeaderStyle HorizontalAlign = " Left " Width = " 80px " />
</ asp:HyperLinkField >
</ Columns >
</ asp:GridView >
</ td >
</ tr >
</ table >
</ form >
</ body >
</ html >
< title > 无标题页 </ title >
< link href = " ../css/StyleSheet1.css " rel = " stylesheet " type = " text/css " />
</ head >
< body >
< form id = " form1 " runat = " server " >
< table >
< tr style = " height:30px " >
< td align = " center " colspan = " 10 " >
< asp:Label ID = " Label1 " runat = " server " Text = " 运行日分析 " CssClass = " TitleStyle1 " ></ asp:Label ></ td >
</ tr >
< tr >
< td style = " width:80px;text-align:right " > 起止日期: </ td >
< td style = " width:80px;text-align:left " >
< cc1:PopupCalendar ID = " PopupCalendarBegin " runat = " server " txtWidth = " 70 " />
</ td >
< td style = " width:30px;text-align:center " > → </ td >
< td style = " width:80px;text-align:left " >
< cc1:PopupCalendar ID = " PopupCalendarEnd " runat = " server " txtWidth = " 70 " />
</ td >
< td style = " width:60px;text-align:right " > 类别: </ td >
< td style = " text-align:left " >
< asp:DropDownList ID = " DropDownListDayType " runat = " server " >
</ asp:DropDownList ></ td >
< td style = " width:60px;text-align:right " > 值别: </ td >
< td style = " width:80px;text-align:left " >
< asp:DropDownList ID = " DropDownListZhiBie " runat = " server " >
</ asp:DropDownList ></ td >
< td style = " width:80px;text-align:left " >
< asp:Button ID = " Button1 " runat = " server " Text = " 查询 " CssClass = " ButtonStyle1 " OnClick = " Button1_Click " /></ td >
< td style = " width:80px;text-align:left " >
< asp:Button ID = " ButtonAdd " runat = " server " Text = " 添加 " CssClass = " ButtonStyle1 " OnClick = " ButtonAdd_Click " /></ td >
< td ></ td >
</ tr >
</ table >
< table style = " width:100% " >
< tr >
< td >
< asp:GridView ID = " GridView1 " runat = " server " AutoGenerateColumns = " False " Width = " 100% " OnRowDataBound = " GridView1_RowDataBound " >
< Columns >
< asp:BoundField DataField = " DAYDATE " HeaderText = " 日期 " >
< HeaderStyle Width = " 80px " HorizontalAlign = " Left " />
< ItemStyle HorizontalAlign = " Left " />
</ asp:BoundField >
< asp:BoundField DataField = " DAYTYPE " Visible = " False " />
< asp:HyperLinkField DataNavigateUrlFields = " DAYDATE,DAYTYPE " DataNavigateUrlFormatString = " RunAnalyseDayRec.aspx?daydate={0}&daytype={1}&actionname=View "
DataTextField = " daytypename " HeaderText = " 类别 " >
< ItemStyle HorizontalAlign = " Left " />
< HeaderStyle HorizontalAlign = " Left " />
</ asp:HyperLinkField >
< asp:BoundField DataField = " DAYNUM " HeaderText = " 值别 " >
< HeaderStyle Width = " 80px " HorizontalAlign = " Left " />
< ItemStyle HorizontalAlign = " Left " />
</ asp:BoundField >
< asp:BoundField DataField = " USERNAME " HeaderText = " 填报人 " >
< HeaderStyle Width = " 80px " HorizontalAlign = " Left " />
< ItemStyle HorizontalAlign = " Left " />
</ asp:BoundField >
< asp:BoundField DataField = " STATUS " HeaderText = " 状态 " >
< HeaderStyle Width = " 80px " HorizontalAlign = " Left " />
< ItemStyle HorizontalAlign = " Left " />
</ asp:BoundField >
< asp:HyperLinkField DataNavigateUrlFields = " DAYDATE,DAYTYPE " DataNavigateUrlFormatString = " RunAnalyseDayRec.aspx?daydate={0}&daytype={1}&actionname=Modi "
Text = " 修改/删除 " HeaderText = " 操作 " >
< ItemStyle HorizontalAlign = " Left " />
< HeaderStyle HorizontalAlign = " Left " Width = " 80px " />
</ asp:HyperLinkField >
</ Columns >
</ asp:GridView >
</ td >
</ tr >
</ table >
</ form >
</ body >
</ html >
用了几个超连接,填充下拉菜单用了一个类文件,这个后面再说.DataNavigateUrlFormatString=.......actionname用来控制下一个页面的按扭状态,view,del,modi(修改),add
using
Application.SystemBase;
using BW.Pub;
public partial class RunAnalyse_RunAnalseDayQuery : System.Web.UI.Page
... {
protected void Page_Load(object sender, EventArgs e)
...{
if (!Page.IsPostBack) //页面初始化
...{
RunAnalyseDay.FillDayTypeList(this.DropDownListDayType, true, ""); //填充下拉菜单
RunAnalyseDay.FillZhiBieList(this.DropDownListZhiBie, true, "");
this.PopupCalendarBegin.Text = DateTime.Now.ToString("yyyy-MM-01"); //popcalender显示当前年当前月1号
LoadData();
}
}
private void LoadData()
...{
string strSql;
strSql = "select distinct to_char(a.daydate,'yyyy-mm-dd') daydate,a.daytype,(select daytypename from brn_analyse_daytype b where a.daytype=b.daytype ) daytypename,a.daynum,a.username,a.status from brn_analyse_day a where (1=1)"; //构建查询语句,用语句联系俩个表,yyyy-mm-dd是popcalender的格式
if (this.PopupCalendarBegin.Text != "")
...{
strSql += " and trunc(a.daydate)>=to_date('" + this.PopupCalendarBegin.Text + "','yyyy-mm-dd')"; //查询时间段起始
}
if (this.PopupCalendarEnd.Text != "")
...{
strSql += " and trunc(a.daydate)<=to_date('" + this.PopupCalendarEnd.Text + "','yyyy-mm-dd')"; //查询时间段结束
}
if (this.DropDownListDayType.SelectedValue != "")
...{
strSql += "and a.daytype='" + this.DropDownListDayType.SelectedValue + "'";
}
if (this.DropDownListZhiBie.SelectedValue != "")
...{
strSql += "and a.conkind='" + this.DropDownListZhiBie.SelectedValue + "'";
}
strSql += " order by daydate desc,daytype";
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
PubClass.FMTStyle(this.GridView1); //GridView格式初始化
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
PubClass.FormatNoDataGridView(this.GridView1); //无数据的情况下,显示字样无数据,用的方法写在类文件里
}
protected void Button1_Click(object sender, EventArgs e)
...{
LoadData();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
...{
if (e.Row.RowType == DataControlRowType.DataRow)
...{
if (e.Row.Cells[5].Text == "未提交") //未提交显示红色
...{
e.Row.Cells[5].Style.Add("color", "Red");
}
if (e.Row.Cells[5].Text == "已提交") //已提交显示绿色
...{
e.Row.Cells[5].Style.Add("color", "Green");
e.Row.Cells[6].Text = ""; //修改删除项置空不显示
}
}
}
protected void ButtonAdd_Click(object sender, EventArgs e)
...{
Response.Redirect("RunAnalyseDayRec.aspx?actionname=Add");
}
}
using BW.Pub;
public partial class RunAnalyse_RunAnalseDayQuery : System.Web.UI.Page
... {
protected void Page_Load(object sender, EventArgs e)
...{
if (!Page.IsPostBack) //页面初始化
...{
RunAnalyseDay.FillDayTypeList(this.DropDownListDayType, true, ""); //填充下拉菜单
RunAnalyseDay.FillZhiBieList(this.DropDownListZhiBie, true, "");
this.PopupCalendarBegin.Text = DateTime.Now.ToString("yyyy-MM-01"); //popcalender显示当前年当前月1号
LoadData();
}
}
private void LoadData()
...{
string strSql;
strSql = "select distinct to_char(a.daydate,'yyyy-mm-dd') daydate,a.daytype,(select daytypename from brn_analyse_daytype b where a.daytype=b.daytype ) daytypename,a.daynum,a.username,a.status from brn_analyse_day a where (1=1)"; //构建查询语句,用语句联系俩个表,yyyy-mm-dd是popcalender的格式
if (this.PopupCalendarBegin.Text != "")
...{
strSql += " and trunc(a.daydate)>=to_date('" + this.PopupCalendarBegin.Text + "','yyyy-mm-dd')"; //查询时间段起始
}
if (this.PopupCalendarEnd.Text != "")
...{
strSql += " and trunc(a.daydate)<=to_date('" + this.PopupCalendarEnd.Text + "','yyyy-mm-dd')"; //查询时间段结束
}
if (this.DropDownListDayType.SelectedValue != "")
...{
strSql += "and a.daytype='" + this.DropDownListDayType.SelectedValue + "'";
}
if (this.DropDownListZhiBie.SelectedValue != "")
...{
strSql += "and a.conkind='" + this.DropDownListZhiBie.SelectedValue + "'";
}
strSql += " order by daydate desc,daytype";
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
PubClass.FMTStyle(this.GridView1); //GridView格式初始化
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
PubClass.FormatNoDataGridView(this.GridView1); //无数据的情况下,显示字样无数据,用的方法写在类文件里
}
protected void Button1_Click(object sender, EventArgs e)
...{
LoadData();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
...{
if (e.Row.RowType == DataControlRowType.DataRow)
...{
if (e.Row.Cells[5].Text == "未提交") //未提交显示红色
...{
e.Row.Cells[5].Style.Add("color", "Red");
}
if (e.Row.Cells[5].Text == "已提交") //已提交显示绿色
...{
e.Row.Cells[5].Style.Add("color", "Green");
e.Row.Cells[6].Text = ""; //修改删除项置空不显示
}
}
}
protected void ButtonAdd_Click(object sender, EventArgs e)
...{
Response.Redirect("RunAnalyseDayRec.aspx?actionname=Add");
}
}
操作页面:popcalender,下拉菜单,四个按钮,需要动态生成部分表格
<
head runat
=
"
server
"
>
< title > 无标题页 </ title >
< link href = " ../css/StyleSheet1.css " rel = " stylesheet " type = " text/css " />
</ head >
< body style = " overflow: visible " >
< form id = " form1 " runat = " server " >
< table id = " table1 " style = " width:100%; border-collapse: collapse;border-color:Black;border-style:solid;border-width:1px " align = " center " runat = " server " >
< tr style = " height:30px " >
< td style = " text-align:center; " colspan = 2 >
< asp:Label ID = " LabelTitle " runat = " server " Text = " 运行日分析 " CssClass = " TitleStyle1 " ></ asp:Label >
</ td >
</ tr >
< tr >
< td style = " width:30%;text-align:right;border-color:Black;border-style:solid;border-width:1px " > 日期: </ td >
< td style = " text-align:left;border-color:Black;border-style:solid;border-width:1px " >
< cc1:PopupCalendar ID = " PopupCalendarDayDate " txtWidth = " 110 " runat = " server " />
</ td >
</ tr >
< tr >
< td style = " text-align:right;border-color:Black;border-style:solid;border-width:1px " > 值别: </ td >
< td style = " text-align:left;border-color:Black;border-style:solid;border-width:1px " >
< asp:DropDownList ID = " DropDownListZhiBie " Width = " 120px " runat = " server " ></ asp:DropDownList >
</ td >
</ tr >
< tr >
< td style = " text-align:right;border-color:Black;border-style:solid;border-width:1px " > 类别: </ td >
< td style = " text-align:left;border-color:Black;border-style:solid;border-width:1px " >
< asp:DropDownList ID = " DropDownListDayType " Width = " 120px " runat = " server " AutoPostBack = " True " OnSelectedIndexChanged = " DropDownListDayType_SelectedIndexChanged " ></ asp:DropDownList >
</ td >
</ tr >
</ table >
< table style = " width:100%; " align = " center " >
< tr style = " height:30px " >
< td ></ td >
< td style = " width:80px " >
< asp:Button ID = " ButtonAdd " runat = " server " Text = " 添加 " CssClass = " ButtonStyle1 " OnClick = " ButtonAdd_Click " /></ td >
< td style = " width:80px " >
< asp:Button ID = " ButtonModi " runat = " server " Text = " 修改 " CssClass = " ButtonStyle1 " OnClick = " ButtonModi_Click " /></ td >
< td style = " width:80px " >
< asp:Button ID = " ButtonDel " runat = " server " Text = " 删除 " CssClass = " ButtonStyle1 " OnClick = " ButtonDel_Click " /></ td >
< td style = " width:80px " >
< asp:Button ID = " ButtonBack " runat = " server " Text = " 返回 " CssClass = " ButtonStyle1 " OnClick = " ButtonBack_Click " /></ td >
< td style = " width:80px " >< asp:CheckBox id = " CheckBoxSubmit " runat = " server " Text = " 提交 " ></ asp:CheckBox ></ td >
< td ></ td >
</ tr >
</ table >
</ form >
</ body >
</ html >
< title > 无标题页 </ title >
< link href = " ../css/StyleSheet1.css " rel = " stylesheet " type = " text/css " />
</ head >
< body style = " overflow: visible " >
< form id = " form1 " runat = " server " >
< table id = " table1 " style = " width:100%; border-collapse: collapse;border-color:Black;border-style:solid;border-width:1px " align = " center " runat = " server " >
< tr style = " height:30px " >
< td style = " text-align:center; " colspan = 2 >
< asp:Label ID = " LabelTitle " runat = " server " Text = " 运行日分析 " CssClass = " TitleStyle1 " ></ asp:Label >
</ td >
</ tr >
< tr >
< td style = " width:30%;text-align:right;border-color:Black;border-style:solid;border-width:1px " > 日期: </ td >
< td style = " text-align:left;border-color:Black;border-style:solid;border-width:1px " >
< cc1:PopupCalendar ID = " PopupCalendarDayDate " txtWidth = " 110 " runat = " server " />
</ td >
</ tr >
< tr >
< td style = " text-align:right;border-color:Black;border-style:solid;border-width:1px " > 值别: </ td >
< td style = " text-align:left;border-color:Black;border-style:solid;border-width:1px " >
< asp:DropDownList ID = " DropDownListZhiBie " Width = " 120px " runat = " server " ></ asp:DropDownList >
</ td >
</ tr >
< tr >
< td style = " text-align:right;border-color:Black;border-style:solid;border-width:1px " > 类别: </ td >
< td style = " text-align:left;border-color:Black;border-style:solid;border-width:1px " >
< asp:DropDownList ID = " DropDownListDayType " Width = " 120px " runat = " server " AutoPostBack = " True " OnSelectedIndexChanged = " DropDownListDayType_SelectedIndexChanged " ></ asp:DropDownList >
</ td >
</ tr >
</ table >
< table style = " width:100%; " align = " center " >
< tr style = " height:30px " >
< td ></ td >
< td style = " width:80px " >
< asp:Button ID = " ButtonAdd " runat = " server " Text = " 添加 " CssClass = " ButtonStyle1 " OnClick = " ButtonAdd_Click " /></ td >
< td style = " width:80px " >
< asp:Button ID = " ButtonModi " runat = " server " Text = " 修改 " CssClass = " ButtonStyle1 " OnClick = " ButtonModi_Click " /></ td >
< td style = " width:80px " >
< asp:Button ID = " ButtonDel " runat = " server " Text = " 删除 " CssClass = " ButtonStyle1 " OnClick = " ButtonDel_Click " /></ td >
< td style = " width:80px " >
< asp:Button ID = " ButtonBack " runat = " server " Text = " 返回 " CssClass = " ButtonStyle1 " OnClick = " ButtonBack_Click " /></ td >
< td style = " width:80px " >< asp:CheckBox id = " CheckBoxSubmit " runat = " server " Text = " 提交 " ></ asp:CheckBox ></ td >
< td ></ td >
</ tr >
</ table >
</ form >
</ body >
</ html >
这部分,完全是老大做的,偶还在学T_T
using
System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Collections.Specialized;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;
using Application.SystemBase;
public partial class RunAnalyse_RunAnalyseDayRec : System.Web.UI.Page
... {
protected void Page_Load(object sender, EventArgs e)
...{
if (!Page.IsPostBack)
...{
this.ViewState["actionname"] = Request.Params["actionname"] != null ? Request.Params["actionname"].ToString() : ""; //根据超连接里Actionname的值来初始化页面
this.ViewState["daydate"] = Request.Params["daydate"] != null ? Request.Params["daydate"].ToString() : DateTime.Now.ToString("yyyy-MM-dd");
this.ViewState["daytype"] = Request.Params["daytype"] != null ? Request.Params["daytype"].ToString() : "";
if (this.ViewState["daydate"].ToString() != "")
...{
this.PopupCalendarDayDate.Text = this.ViewState["daydate"].ToString();
}
RunAnalyseDay.FillDayTypeList(this.DropDownListDayType, false, "");
if (this.ViewState["daytype"].ToString() != "")
...{
this.DropDownListDayType.SelectedValue = this.ViewState["daytype"].ToString();
}
RunAnalyseDay.FillZhiBieList(this.DropDownListZhiBie, false, "");
LoadData(this.DropDownListDayType.SelectedValue,this.PopupCalendarDayDate.Text);
}
}
/**//****************初始页面状态****************/
private void InitPage()
...{
if (this.ViewState["actionname"].ToString() == "View") //按扭控制
...{
this.ButtonAdd.Enabled = false;
this.ButtonDel.Enabled = false;
this.ButtonModi.Enabled = false;
this.CheckBoxSubmit.Enabled = false;
this.DropDownListDayType.Enabled = false;
this.PopupCalendarDayDate.Enabled = false;
this.DropDownListZhiBie.Enabled = false;
}
else if (this.ViewState["actionname"].ToString() == "Modi")
...{
this.ButtonAdd.Enabled = false;
this.ButtonDel.Enabled = true;
this.ButtonModi.Enabled = true;
this.DropDownListDayType.Enabled = false;
this.PopupCalendarDayDate.Enabled = false;
}
else if (this.ViewState["actionname"].ToString() == "Add")
...{
this.ButtonAdd.Enabled = true;
this.ButtonDel.Enabled = false;
this.ButtonModi.Enabled = false;
}
else
...{
this.ButtonAdd.Enabled = false;
this.ButtonDel.Enabled = false;
this.ButtonModi.Enabled = false;
this.CheckBoxSubmit.Enabled = false;
}
//根据主键去记录信息,并设置相关字段的值
DataSet ds = RunAnalyseDay.GetDayRec(this.DropDownListDayType.SelectedValue, this.PopupCalendarDayDate.Text);
if (ds.Tables[0].Rows.Count > 0)
...{
this.PopupCalendarDayDate.Text = ((DateTime)ds.Tables[0].Rows[0]["daydate"]).ToString("yyyy-MM-dd");
this.DropDownListZhiBie.SelectedValue = ds.Tables[0].Rows[0]["daynum"].ToString();
this.DropDownListDayType.SelectedValue = ds.Tables[0].Rows[0]["daytype"].ToString();
this.CheckBoxSubmit.Checked = ds.Tables[0].Rows[0]["status"].ToString() == "未提交" ? false : true;
if (this.CheckBoxSubmit.Checked)
...{
this.ButtonAdd.Enabled = false;
this.ButtonDel.Enabled = false;
this.ButtonModi.Enabled = false;
this.CheckBoxSubmit.Enabled = false;
}
}
}
protected void ButtonBack_Click(object sender, EventArgs e)
...{
Response.Redirect("RunAnalseDayQuery.aspx");
}
//根据主键加载数据
protected void LoadData(string daytype,string daydate)
...{
string strSql;
if (!RunAnalyseDay.IfHasInit(daytype, daydate))
...{
strSql = "select a.conkind conkind,a.conname,'' daytopic from brn_analyse_daykind a where (1=1)";
strSql += " and a.daytype='" + daytype + "'";
strSql += " order by a.conkind";
}
else
...{
strSql = "select a.conkind,(select b.conname from brn_analyse_daykind b where b.daytype=a.daytype and b.conkind=a.conkind) conname,a.daytopic from brn_analyse_day a where (1=1)";
strSql += " and trunc(a.daydate)=to_date('" + daydate + "','yyyy-mm-dd')";
strSql += " and a.daytype='" + daytype + "'";
strSql += " order by a.conkind";
}
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows) //动态生成表格显示
...{
HtmlTableRow htr = new HtmlTableRow(); //动态生成行
HtmlTableCell htc = new HtmlTableCell(); //右侧行单元
htc.Align = "Right"; //对齐格式
htc.InnerText = dr["conname"].ToString(); //数据库提取内容
htr.Cells.Add(htc); //增加
htc = new HtmlTableCell(); //左侧行单元
htc.Align = "Left";
TextBox tb = new TextBox(); //插入TextBox
tb.ID = "daytopic_" + dr["conkind"].ToString(); //TextBox的ID
tb.TextMode = TextBoxMode.MultiLine; //多行显示
tb.Rows = 5; //默认行数
tb.Width = Unit.Percentage(100); //宽
tb.Height = Unit.Pixel(120); //高
tb.BorderStyle = BorderStyle.None; //??
tb.BackColor = Color.Azure; //背景颜色
tb.Style.Add("OVERFLOW", "visible"); //可溢出
tb.Text = dr["daytopic"].ToString(); //内容
htc.Controls.Add(tb); //自增加
htr.Cells.Add(htc);
this.table1.Rows.Add(htr);
foreach (HtmlTableCell cell in htr.Cells) //还是迭带下格式
...{
cell.Style.Add("border-style", "solid");
cell.Style.Add("border-width", "1px");
cell.Style.Add("border-color", "black");
}
}
InitPage();
}
//保存数据
protected void SaveData()
...{
NameValueCollection nvc = Request.Form;
NameValueCollection nvKind = new NameValueCollection();
string strSql="",username,status;
HttpCookie user = Request.Cookies["UserInfo"];
username = Request.Cookies["UserInfo"]["UserName"] == null ? "" : Request.Cookies["UserInfo"]["UserName"].ToString();
status = this.CheckBoxSubmit.Checked ? "已提交" : "未提交";
//提取各记录的主键
foreach(string s in nvc.AllKeys)
...{
if (s.StartsWith("daytopic_"))
...{
nvKind.Add(s.Substring(9),nvc[s]); //这个是难点..
}
}
//构造各记录SQL语句
if (this.ViewState["actionname"].ToString() == "Add")
...{
if (RunAnalyseDay.IfHasInit(this.DropDownListDayType.SelectedValue, this.PopupCalendarDayDate.Text)) //ifhasinit类文件方法
...{
Response.Write("<script>alert('记录已经填写,不能重复填写!')</script>");
LoadData(this.DropDownListDayType.SelectedValue,this.PopupCalendarDayDate.Text);
return;
}
foreach (string s in nvKind.AllKeys)
...{
strSql = "insert into brn_analyse_day(daydate,daytype,conkind,daytopic,daynum,username,status) values("; //看起来方便才这么分着写的
strSql += " to_date('" + this.PopupCalendarDayDate.Text + "','yyyy-mm-dd')";
strSql += ",'" + this.DropDownListDayType.SelectedValue + "'";
strSql += ",'" + s + "'";
strSql += ",'" + nvKind[s] + "'";
strSql += ",'" + this.DropDownListZhiBie.SelectedValue + "'";
strSql += ",'" + username + "'";
strSql += ",'" + status + "'";
strSql += ")";
DataBase db = new DataBase();
if (db.ExecSql(strSql) <= 0)
...{
Response.Write("<script>alert('添加过程中发生错误')</script>");
LoadData(this.DropDownListDayType.SelectedValue, this.PopupCalendarDayDate.Text);
return;
}
}
Response.Redirect("RunAnalseDayQuery.aspx");
}
else if (this.ViewState["actionname"].ToString() == "Modi")
...{
foreach (string s in nvKind.AllKeys)
...{
strSql = "update brn_analyse_day set";
strSql += " daydate=to_date('" + this.PopupCalendarDayDate.Text + "','yyyy-mm-dd')";
//strSql += ",daytype='" + this.DropDownListDayType.SelectedValue + "'";
//strSql += ",conkind='" + s + "'";
strSql += " ,daytopic='" + nvKind[s] + "'";
strSql += ",daynum='" + this.DropDownListZhiBie.SelectedValue + "'";
//strSql += ",username='" + username + "'";
strSql += ",status='" + status + "'";
strSql += " where daydate=to_date('" + this.ViewState["daydate"].ToString() + "','yyyy-mm-dd')";
strSql += " and daytype='" + this.ViewState["daytype"].ToString() + "'";
strSql += " and conkind='" + s + "'";
DataBase db = new DataBase();
if (db.ExecSql(strSql) <= 0)
...{
Response.Write("<script>alert('保存过程中发生错误')</script>");
LoadData(this.ViewState["daytype"].ToString(), this.ViewState["daydate"].ToString());
return ;
}
}
}
LoadData(this.DropDownListDayType.SelectedValue,this.PopupCalendarDayDate.Text);
}
protected void ButtonAdd_Click(object sender, EventArgs e)
...{
SaveData();
}
protected void DropDownListDayType_SelectedIndexChanged(object sender, EventArgs e)
...{
LoadData(this.DropDownListDayType.SelectedValue, this.PopupCalendarDayDate.Text);
}
protected void ButtonDel_Click(object sender, EventArgs e)
...{
string strSql;
strSql = "delete from brn_analyse_day where trunc(daydate)=to_date('" + this.ViewState["daydate"].ToString() + "','yyyy-mm-dd') and daytype='" + this.ViewState["daytype"].ToString() + "'";
DataBase db = new DataBase();
if (db.ExecSql(strSql) > 0) //判断是否成功
...{
Response.Redirect("RunAnalseDayQuery.aspx");
}
else
...{
Response.Write("<script>alert('删除过程中发生错误')</script>");
LoadData(this.ViewState["daytype"].ToString(), this.ViewState["daydate"].ToString());
}
}
protected void ButtonModi_Click(object sender, EventArgs e)
...{
SaveData();
}
}
using System.Data;
using System.Configuration;
using System.Collections;
using System.Collections.Specialized;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;
using Application.SystemBase;
public partial class RunAnalyse_RunAnalyseDayRec : System.Web.UI.Page
... {
protected void Page_Load(object sender, EventArgs e)
...{
if (!Page.IsPostBack)
...{
this.ViewState["actionname"] = Request.Params["actionname"] != null ? Request.Params["actionname"].ToString() : ""; //根据超连接里Actionname的值来初始化页面
this.ViewState["daydate"] = Request.Params["daydate"] != null ? Request.Params["daydate"].ToString() : DateTime.Now.ToString("yyyy-MM-dd");
this.ViewState["daytype"] = Request.Params["daytype"] != null ? Request.Params["daytype"].ToString() : "";
if (this.ViewState["daydate"].ToString() != "")
...{
this.PopupCalendarDayDate.Text = this.ViewState["daydate"].ToString();
}
RunAnalyseDay.FillDayTypeList(this.DropDownListDayType, false, "");
if (this.ViewState["daytype"].ToString() != "")
...{
this.DropDownListDayType.SelectedValue = this.ViewState["daytype"].ToString();
}
RunAnalyseDay.FillZhiBieList(this.DropDownListZhiBie, false, "");
LoadData(this.DropDownListDayType.SelectedValue,this.PopupCalendarDayDate.Text);
}
}
/**//****************初始页面状态****************/
private void InitPage()
...{
if (this.ViewState["actionname"].ToString() == "View") //按扭控制
...{
this.ButtonAdd.Enabled = false;
this.ButtonDel.Enabled = false;
this.ButtonModi.Enabled = false;
this.CheckBoxSubmit.Enabled = false;
this.DropDownListDayType.Enabled = false;
this.PopupCalendarDayDate.Enabled = false;
this.DropDownListZhiBie.Enabled = false;
}
else if (this.ViewState["actionname"].ToString() == "Modi")
...{
this.ButtonAdd.Enabled = false;
this.ButtonDel.Enabled = true;
this.ButtonModi.Enabled = true;
this.DropDownListDayType.Enabled = false;
this.PopupCalendarDayDate.Enabled = false;
}
else if (this.ViewState["actionname"].ToString() == "Add")
...{
this.ButtonAdd.Enabled = true;
this.ButtonDel.Enabled = false;
this.ButtonModi.Enabled = false;
}
else
...{
this.ButtonAdd.Enabled = false;
this.ButtonDel.Enabled = false;
this.ButtonModi.Enabled = false;
this.CheckBoxSubmit.Enabled = false;
}
//根据主键去记录信息,并设置相关字段的值
DataSet ds = RunAnalyseDay.GetDayRec(this.DropDownListDayType.SelectedValue, this.PopupCalendarDayDate.Text);
if (ds.Tables[0].Rows.Count > 0)
...{
this.PopupCalendarDayDate.Text = ((DateTime)ds.Tables[0].Rows[0]["daydate"]).ToString("yyyy-MM-dd");
this.DropDownListZhiBie.SelectedValue = ds.Tables[0].Rows[0]["daynum"].ToString();
this.DropDownListDayType.SelectedValue = ds.Tables[0].Rows[0]["daytype"].ToString();
this.CheckBoxSubmit.Checked = ds.Tables[0].Rows[0]["status"].ToString() == "未提交" ? false : true;
if (this.CheckBoxSubmit.Checked)
...{
this.ButtonAdd.Enabled = false;
this.ButtonDel.Enabled = false;
this.ButtonModi.Enabled = false;
this.CheckBoxSubmit.Enabled = false;
}
}
}
protected void ButtonBack_Click(object sender, EventArgs e)
...{
Response.Redirect("RunAnalseDayQuery.aspx");
}
//根据主键加载数据
protected void LoadData(string daytype,string daydate)
...{
string strSql;
if (!RunAnalyseDay.IfHasInit(daytype, daydate))
...{
strSql = "select a.conkind conkind,a.conname,'' daytopic from brn_analyse_daykind a where (1=1)";
strSql += " and a.daytype='" + daytype + "'";
strSql += " order by a.conkind";
}
else
...{
strSql = "select a.conkind,(select b.conname from brn_analyse_daykind b where b.daytype=a.daytype and b.conkind=a.conkind) conname,a.daytopic from brn_analyse_day a where (1=1)";
strSql += " and trunc(a.daydate)=to_date('" + daydate + "','yyyy-mm-dd')";
strSql += " and a.daytype='" + daytype + "'";
strSql += " order by a.conkind";
}
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows) //动态生成表格显示
...{
HtmlTableRow htr = new HtmlTableRow(); //动态生成行
HtmlTableCell htc = new HtmlTableCell(); //右侧行单元
htc.Align = "Right"; //对齐格式
htc.InnerText = dr["conname"].ToString(); //数据库提取内容
htr.Cells.Add(htc); //增加
htc = new HtmlTableCell(); //左侧行单元
htc.Align = "Left";
TextBox tb = new TextBox(); //插入TextBox
tb.ID = "daytopic_" + dr["conkind"].ToString(); //TextBox的ID
tb.TextMode = TextBoxMode.MultiLine; //多行显示
tb.Rows = 5; //默认行数
tb.Width = Unit.Percentage(100); //宽
tb.Height = Unit.Pixel(120); //高
tb.BorderStyle = BorderStyle.None; //??
tb.BackColor = Color.Azure; //背景颜色
tb.Style.Add("OVERFLOW", "visible"); //可溢出
tb.Text = dr["daytopic"].ToString(); //内容
htc.Controls.Add(tb); //自增加
htr.Cells.Add(htc);
this.table1.Rows.Add(htr);
foreach (HtmlTableCell cell in htr.Cells) //还是迭带下格式
...{
cell.Style.Add("border-style", "solid");
cell.Style.Add("border-width", "1px");
cell.Style.Add("border-color", "black");
}
}
InitPage();
}
//保存数据
protected void SaveData()
...{
NameValueCollection nvc = Request.Form;
NameValueCollection nvKind = new NameValueCollection();
string strSql="",username,status;
HttpCookie user = Request.Cookies["UserInfo"];
username = Request.Cookies["UserInfo"]["UserName"] == null ? "" : Request.Cookies["UserInfo"]["UserName"].ToString();
status = this.CheckBoxSubmit.Checked ? "已提交" : "未提交";
//提取各记录的主键
foreach(string s in nvc.AllKeys)
...{
if (s.StartsWith("daytopic_"))
...{
nvKind.Add(s.Substring(9),nvc[s]); //这个是难点..
}
}
//构造各记录SQL语句
if (this.ViewState["actionname"].ToString() == "Add")
...{
if (RunAnalyseDay.IfHasInit(this.DropDownListDayType.SelectedValue, this.PopupCalendarDayDate.Text)) //ifhasinit类文件方法
...{
Response.Write("<script>alert('记录已经填写,不能重复填写!')</script>");
LoadData(this.DropDownListDayType.SelectedValue,this.PopupCalendarDayDate.Text);
return;
}
foreach (string s in nvKind.AllKeys)
...{
strSql = "insert into brn_analyse_day(daydate,daytype,conkind,daytopic,daynum,username,status) values("; //看起来方便才这么分着写的
strSql += " to_date('" + this.PopupCalendarDayDate.Text + "','yyyy-mm-dd')";
strSql += ",'" + this.DropDownListDayType.SelectedValue + "'";
strSql += ",'" + s + "'";
strSql += ",'" + nvKind[s] + "'";
strSql += ",'" + this.DropDownListZhiBie.SelectedValue + "'";
strSql += ",'" + username + "'";
strSql += ",'" + status + "'";
strSql += ")";
DataBase db = new DataBase();
if (db.ExecSql(strSql) <= 0)
...{
Response.Write("<script>alert('添加过程中发生错误')</script>");
LoadData(this.DropDownListDayType.SelectedValue, this.PopupCalendarDayDate.Text);
return;
}
}
Response.Redirect("RunAnalseDayQuery.aspx");
}
else if (this.ViewState["actionname"].ToString() == "Modi")
...{
foreach (string s in nvKind.AllKeys)
...{
strSql = "update brn_analyse_day set";
strSql += " daydate=to_date('" + this.PopupCalendarDayDate.Text + "','yyyy-mm-dd')";
//strSql += ",daytype='" + this.DropDownListDayType.SelectedValue + "'";
//strSql += ",conkind='" + s + "'";
strSql += " ,daytopic='" + nvKind[s] + "'";
strSql += ",daynum='" + this.DropDownListZhiBie.SelectedValue + "'";
//strSql += ",username='" + username + "'";
strSql += ",status='" + status + "'";
strSql += " where daydate=to_date('" + this.ViewState["daydate"].ToString() + "','yyyy-mm-dd')";
strSql += " and daytype='" + this.ViewState["daytype"].ToString() + "'";
strSql += " and conkind='" + s + "'";
DataBase db = new DataBase();
if (db.ExecSql(strSql) <= 0)
...{
Response.Write("<script>alert('保存过程中发生错误')</script>");
LoadData(this.ViewState["daytype"].ToString(), this.ViewState["daydate"].ToString());
return ;
}
}
}
LoadData(this.DropDownListDayType.SelectedValue,this.PopupCalendarDayDate.Text);
}
protected void ButtonAdd_Click(object sender, EventArgs e)
...{
SaveData();
}
protected void DropDownListDayType_SelectedIndexChanged(object sender, EventArgs e)
...{
LoadData(this.DropDownListDayType.SelectedValue, this.PopupCalendarDayDate.Text);
}
protected void ButtonDel_Click(object sender, EventArgs e)
...{
string strSql;
strSql = "delete from brn_analyse_day where trunc(daydate)=to_date('" + this.ViewState["daydate"].ToString() + "','yyyy-mm-dd') and daytype='" + this.ViewState["daytype"].ToString() + "'";
DataBase db = new DataBase();
if (db.ExecSql(strSql) > 0) //判断是否成功
...{
Response.Redirect("RunAnalseDayQuery.aspx");
}
else
...{
Response.Write("<script>alert('删除过程中发生错误')</script>");
LoadData(this.ViewState["daytype"].ToString(), this.ViewState["daydate"].ToString());
}
}
protected void ButtonModi_Click(object sender, EventArgs e)
...{
SaveData();
}
}
呼!第一次写东西,好累,下面是类文件
using
Application.SystemBase;
/**/ /// <summary>
/// RunAnalyseDay 的摘要说明
/// </summary>
public class RunAnalyseDay
... {
public RunAnalyseDay()
...{
//
// TODO: 在此处添加构造函数逻辑
//
}
/**//**************填充<<日分析类别>>列表*************/
public static void FillDayTypeList(DropDownList ddl, bool bShowAll, string strDefault)
...{
string strSql;
strSql = "select daytype,daytypename from brn_analyse_daytype";
DataBase db = new DataBase();
DataTable dt = db.ExecQuery(strSql).Tables[0];
ddl.Items.Clear();
if (bShowAll)//是否显示全部选项
...{
ddl.Items.Add(new ListItem("全部", ""));
}
foreach (DataRow dr in dt.Rows)
...{
ddl.Items.Add(new ListItem(dr["daytypename"].ToString(), dr["daytype"].ToString()));
}
if (ddl.Items.FindByValue(strDefault) != null)
...{
ddl.SelectedValue = strDefault;
}
else
...{
ddl.SelectedIndex = 0;
}
}
/**//**************填充<<值别>>下拉列表*************/
public static void FillZhiBieList(DropDownList ddl, bool bShowAll, string strDefault)
...{
ddl.Items.Clear();
if (bShowAll)//是否显示全部选项
...{
ddl.Items.Add(new ListItem("全部", ""));
}
ddl.Items.Add(new ListItem("甲值", "甲值"));
ddl.Items.Add(new ListItem("乙值", "乙值"));
ddl.Items.Add(new ListItem("丙值", "丙值"));
ddl.Items.Add(new ListItem("丁值", "丁值"));
ddl.Items.Add(new ListItem("戊值", "戊值"));
if (ddl.Items.FindByValue(strDefault) != null)
...{
ddl.SelectedValue = strDefault;
}
else
...{
ddl.SelectedIndex = 0;
}
}
/**//**************判断某类日分析是否初始化数据*************/
public static bool IfHasInit(string daytype,string daydate)
...{
string strSql;
strSql = "select count(*) from brn_analyse_day where daytype='" + daytype + "' and trunc(daydate)=to_date('" + daydate + "','yyyy-mm-dd')";
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
if (int.Parse(ds.Tables[0].Rows[0][0].ToString()) > 0)
...{
return true;
}
else
...{
return false;
}
}
/**//**************判断某类日分析数据是否已存在*************/
public static bool IfDayDataExist(string daytype,string daydate,string daykind)
...{
string strSql;
strSql = "select count(*) from brn_analyse_day where daytype='" + daytype + "' and trunc(daydate)=to_date('" + daydate + "','yyyy-mm-dd') and conkind='"+daykind+"'";
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
if (int.Parse(ds.Tables[0].Rows[0][0].ToString()) > 0)
...{
return true;
}
else
...{
return false;
}
}
//
public static DataSet GetDayRec(string daytype, string daydate)
...{
string strSql;
strSql = "select distinct daydate,daytype,daynum,username,status from brn_analyse_day where daytype='" + daytype + "' and trunc(daydate)=to_date('" + daydate + "','yyyy-mm-dd')";
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
return ds;
}
}
/**/ /// <summary>
/// RunAnalyseDay 的摘要说明
/// </summary>
public class RunAnalyseDay
... {
public RunAnalyseDay()
...{
//
// TODO: 在此处添加构造函数逻辑
//
}
/**//**************填充<<日分析类别>>列表*************/
public static void FillDayTypeList(DropDownList ddl, bool bShowAll, string strDefault)
...{
string strSql;
strSql = "select daytype,daytypename from brn_analyse_daytype";
DataBase db = new DataBase();
DataTable dt = db.ExecQuery(strSql).Tables[0];
ddl.Items.Clear();
if (bShowAll)//是否显示全部选项
...{
ddl.Items.Add(new ListItem("全部", ""));
}
foreach (DataRow dr in dt.Rows)
...{
ddl.Items.Add(new ListItem(dr["daytypename"].ToString(), dr["daytype"].ToString()));
}
if (ddl.Items.FindByValue(strDefault) != null)
...{
ddl.SelectedValue = strDefault;
}
else
...{
ddl.SelectedIndex = 0;
}
}
/**//**************填充<<值别>>下拉列表*************/
public static void FillZhiBieList(DropDownList ddl, bool bShowAll, string strDefault)
...{
ddl.Items.Clear();
if (bShowAll)//是否显示全部选项
...{
ddl.Items.Add(new ListItem("全部", ""));
}
ddl.Items.Add(new ListItem("甲值", "甲值"));
ddl.Items.Add(new ListItem("乙值", "乙值"));
ddl.Items.Add(new ListItem("丙值", "丙值"));
ddl.Items.Add(new ListItem("丁值", "丁值"));
ddl.Items.Add(new ListItem("戊值", "戊值"));
if (ddl.Items.FindByValue(strDefault) != null)
...{
ddl.SelectedValue = strDefault;
}
else
...{
ddl.SelectedIndex = 0;
}
}
/**//**************判断某类日分析是否初始化数据*************/
public static bool IfHasInit(string daytype,string daydate)
...{
string strSql;
strSql = "select count(*) from brn_analyse_day where daytype='" + daytype + "' and trunc(daydate)=to_date('" + daydate + "','yyyy-mm-dd')";
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
if (int.Parse(ds.Tables[0].Rows[0][0].ToString()) > 0)
...{
return true;
}
else
...{
return false;
}
}
/**//**************判断某类日分析数据是否已存在*************/
public static bool IfDayDataExist(string daytype,string daydate,string daykind)
...{
string strSql;
strSql = "select count(*) from brn_analyse_day where daytype='" + daytype + "' and trunc(daydate)=to_date('" + daydate + "','yyyy-mm-dd') and conkind='"+daykind+"'";
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
if (int.Parse(ds.Tables[0].Rows[0][0].ToString()) > 0)
...{
return true;
}
else
...{
return false;
}
}
//
public static DataSet GetDayRec(string daytype, string daydate)
...{
string strSql;
strSql = "select distinct daydate,daytype,daynum,username,status from brn_analyse_day where daytype='" + daytype + "' and trunc(daydate)=to_date('" + daydate + "','yyyy-mm-dd')";
DataBase db = new DataBase();
DataSet ds = db.ExecQuery(strSql);
return ds;
}
}
整个东西写下来,自己搞定的东西少的可怜,把整个练习的内容分享出来,希望对大家有用.由于是练习成果,可能运行的时候会有好多错误,还得改改
数据库ORACLE9i
表名:
brn_Analyse_Day
|
表描述:
定期工作专业表
| |||
字段名
|
字段描述
|
数据类型
|
是否主键
|
可否为空
|
DayDate
|
日期(天)
|
Date
|
Y
|
N
|
DayType
|
日分析类别
|
Varchar2(10)
|
Y
|
N
|
ConKind
|
分析内容(类别)
|
Varchar2(10)
|
Y
|
N
|
DayTopic
|
存在的问题及措施
|
Varchar2(2000)
|
|
|
DayNum
|
值别
|
Varchar2(10)
|
|
N
|
UserName
|
填报人
|
Varchar2(20)
|
|
|
Status
|
记录状态
|
Varchar2(10)
|
|
|
备注:
日期(天):默认为当天日期
日分析类别:辅控主值、#1机组长、#2机组长、值长
值别:甲值、乙值、丙值、丁值、戊值
状态:未提交、已提交
|
表名:
brn_Analyse_DayType
|
表描述:
定期工作专业表
| |||
字段名
|
字段描述
|
数据类型
|
是否主键
|
可否为空
|
DayType
|
日分析类别编号
|
Varchar2(10)
|
Y
|
N
|
DayTypeName
|
日分析类别名称
|
Varchar2(20)
|
|
|
表名:
brn_Analyse_DayKind
|
表描述:
定期工作专业表
| |||
字段名
|
字段描述
|
数据类型
|
是否主键
|
可否为空
|
DayType
|
日分析类别编号
|
Varchar2(10)
|
Y
|
N
|
ConKind
|
分析内容类别
|
Varchar2(10)
|
Y
|
|
ConName
|
分析内容名称
|
Varchar2(30)
|
|
|
上天保佑啊,老大不要看到,啊门