protected void QueryData(object sender, EventArgs e) { string eng = (ENG_NAME.SelectedItem.Text!="") ? (" AND ENG_CODE = "+ENG_NAME.SelectedItem.Value) : ""; System.Diagnostics.Debug.WriteLine("eng_code is "+ ENG_NAME.SelectedItem.Value); string process = (PROCESS_NAME.SelectedItem.Text != "") ? ("AND PROCESS_CODE = " +PROCESS_NAME.SelectedItem.Value) : ""; System.Diagnostics.Debug.WriteLine("process_code is " + PROCESS_NAME.SelectedItem.Value); string unit = (UNIT_NAME.SelectedItem.Text != "") ? ("AND UNIT_CODE="+UNIT_NAME.SelectedItem.Value) : ""; System.Diagnostics.Debug.WriteLine("unit_code is " + UNIT_NAME.SelectedItem.Value); if (StartTime.Text == "" || EndTime.Text == "" || unit=="") { Response.Write("测试能否接收到数据"); } string query = "SELECT ID as 记录ID, ENG_NAME as 能耗点, PROCESS_NAME as 工序编码, TIME 日期, AMOUNT as 能耗总量, UNIT_NAME as 单位 FROM HT_ENG_MANUAL_DATA WHERE IS_DEL != 1 AND IS_VALID = 1 AND TIME >='" + StartTime.Text + "' AND TIME<='" + EndTime.Text+"'"; string querycount = "SELECT SUM(AMOUNT) FROM HT_ENG_MANUAL_DATA WHERE IS_DEL = 0 AND IS_VALID = 1 AND TIME >='" + StartTime.Text + "' AND TIME<='" + EndTime.Text+"'"; query = query + eng + process + unit; querycount = querycount + eng + process + unit; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); if (data == null) { System.Diagnostics.Debug.WriteLine("从数据库获取信息失败"); } else { GridView1.DataSource = data; GridView1.DataBind(); } data = opt.CreateDataSetOra(querycount); COUNT.Text = data.Tables[0].Rows[0][0].ToString(); return; }
protected void bindGrid2() { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet cols = opt.CreateDataSetOra("select distinct t.inspect_code,t.inspect_name||'('||r.minus_score||')' as inspect_name from ht_qlt_inspect_proj t left join ht_qlt_inspect_stdd r on r.inspect_code = t.inspect_code left join ht_qlt_sensor_record_sub s on s.inspect_code = t.inspect_code where t.inspect_group = '4' and t.is_del = '0' order by inspect_code"); string query = "select t.产品名称"; if (cols != null && cols.Tables[0].Rows.Count > 0) { foreach (DataRow row in cols.Tables[0].Rows) { query += ",t.\"" + row["inspect_name"].ToString() + "\""; } } query += ",t.总得分,t.产品基础分,t.实际得分,r.平均分 from hv_qlt_sensor_RealRec t left join (select g.产品名称,g.sensor_month,round(avg(g.实际得分),2) as 平均分 from hv_qlt_sensor_realRec g group by g.产品名称,g.sensor_month) r on t.产品名称 = r.产品名称 and t.sensor_month = r.sensor_month where t.sensor_month = '" + hideMonth.Value + "' order by t.产品 "; DataSet data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { GridView2.DataSource = data; GridView2.DataBind(); int avgcol = data.Tables[0].Columns.Count; if (avgcol > 5) { //合并产品名称列 TableCell oldtc = GridView2.Rows[0].Cells[0]; TableCell oldsc = GridView2.Rows[0].Cells[avgcol - 1]; oldtc.RowSpan = 1; for (int j = 1; j < GridView2.Rows.Count; j++) { TableCell newtc = GridView2.Rows[j].Cells[0]; TableCell newsc = GridView2.Rows[j].Cells[avgcol - 1]; if (newtc.Text == oldtc.Text) { newtc.Visible = false; oldtc.RowSpan = oldtc.RowSpan + 1; oldtc.VerticalAlign = VerticalAlign.Middle; if (newsc.Text == oldsc.Text) { newsc.Visible = false; oldsc.RowSpan = oldsc.RowSpan + 1; oldsc.VerticalAlign = VerticalAlign.Middle; } } else { oldtc = newtc; oldtc.RowSpan = 1; oldsc = newsc; oldsc.RowSpan = 1; } } } } }
protected void btnGrid1Edit_Click(object sender, EventArgs e) { Button btn = (Button)sender; int rowIndex = ((GridViewRow)btn.NamingContainer).RowIndex; string id = GridView1.DataKeys[rowIndex].Value.ToString(); hdID.Value = id; string query = "select g.work_date as 日期,g.shift_code as 班时,g.team_code as 班组,g1.create_id as 交班人,g1.modify_id as 接班人,g1.remark as 备注,g.date_begin as 开始时间,g.date_end as 结束时间,MAINTENANCE_TYPE from Ht_Prod_Schedule g left join HT_EQ_MT_SHIFT g1 on g1.ID = g.id where g.id = '" + id + "'"; if (rdElec.Checked) { query += " and g1.MAINTENANCE_TYPE = '0'"; } if (rdMchnc.Checked) { query += " and g1.MAINTENANCE_TYPE = '1'"; } MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow row = data.Tables[0].Rows[0]; txtDate.Text = row["日期"].ToString(); listShift.SelectedValue = row["班时"].ToString(); listTeam.SelectedValue = row["班组"].ToString(); listolder.SelectedValue = row["交班人"].ToString(); listnewer.SelectedValue = row["接班人"].ToString(); txtRemark.Text = row["备注"].ToString(); txtBtime.Text = row["开始时间"].ToString(); txtEtime.Text = row["结束时间"].ToString(); listtype.SelectedValue = row["MAINTENANCE_TYPE"].ToString(); } else { query = "select g.work_date as 日期,g.shift_code as 班时,g.team_code as 班组,g.date_begin as 开始时间,g.date_end as 结束时间 from Ht_Prod_Schedule g where g.id = '" + id + "'"; data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow row = data.Tables[0].Rows[0]; txtDate.Text = row["日期"].ToString(); listShift.SelectedValue = row["班时"].ToString(); listTeam.SelectedValue = row["班组"].ToString(); txtBtime.Text = row["开始时间"].ToString(); txtEtime.Text = row["结束时间"].ToString(); listtype.SelectedValue = (rdElec.Checked ? "0" : "1"); listolder.SelectedValue = ""; listnewer.SelectedValue = ""; txtRemark.Text = ""; } } bindGrid2(); }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (txtCode.Text.Length == 10 && txtCode.Text.Substring(0, 5) == listSection.SelectedValue) { string oldepath = opt.GetSegValue("select * from HT_PUB_TECH_PARA where PARA_CODE = '" + txtCode.Text + "'", "PATH_NODE"); string[] seg = { "PARA_CODE", "PARA_NAME", "PARA_UNIT", "PARA_TYPE", "REMARK", "IS_VALID", "CREATE_ID", "CREATE_TIME", "EQUIP_CODE", "SET_TAG", "VALUE_TAG", "BUSS_ID", "PATH_NODE" }; string[] value = { txtCode.Text, txtName.Text, txtUnit.Text, getType(), txtDscrp.Text, Convert.ToInt16(rdValid.Checked).ToString(), ((MSYS.Data.SysUser)Session["User"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listEquip.SelectedValue, txtSetTag.Text, txtValueTag.Text, listApt.SelectedValue, listPathnode.SelectedValue }; string log_message; if (opt.MergeInto(seg, value, 1, "HT_PUB_TECH_PARA") == "Success") { log_message = "保存参数点成功"; tvHtml = InitTree(); string[] procseg = { }; object[] procvalues = { }; opt.ExecProcedures("Create_Online_month_Report", procseg, procvalues); if (ckQuaAnalyze.Checked && oldepath != listPathnode.SelectedValue) { DataSet points = opt.CreateDataSetOra("select distinct path_code,path_name from ht_pub_para_weight t "); if (points != null && points.Tables[0].Rows.Count > 0) { foreach (DataRow row in points.Tables[0].Rows) { if (listPathnode.SelectedValue == "") { opt.UpDateOra("insert into ht_pub_para_weight(para_code,path_code,weight,path_name)values ('" + txtCode.Text + "','" + row["path_code"].ToString() + "','0.2','" + row["path_name"].ToString() + "')"); } else { DataSet paras = opt.CreateDataSetOra("select r.para_code,t.pathcode from ht_pub_path_prod t left join ht_pub_path_node s on s.is_del = '0' and s.section_code = t.section_code and substr(t.section_path,s.orders,1) = '0' left join ht_pub_tech_para r on r.path_node = s.id and r.is_del = '0' and r.para_type like '______1%' where t.pathcode = '" + row["path_code"].ToString() + "' and t.is_del = '0' and r.para_code = '" + txtCode.Text + "'"); if (paras != null && paras.Tables[0].Rows.Count > 0) { opt.UpDateOra("delete from ht_pub_para_weight where para_code = '" + txtCode.Text + "' and path_code = '" + row["path_code"].ToString() + "'"); } } } } } // opt.UpDateOra("delete from ht_pub_para_weight where PATH_CODE = '" + listPathAll.SelectedValue + "'"); // opt.UpDateOra("insert into ht_pub_para_weight ( select r.para_code,t.pathcode,'0',0.2,'test1' from ht_pub_path_prod t left join ht_pub_path_node s on s.is_del = '0' and s.section_code = t.section_code and substr(t.section_path,s.orders,1) = '1' left join ht_pub_tech_para r on r.path_node = s.id and r.is_del = '0' and r.para_type like '______1%' where t.pathcode = '" + listPathAll.SelectedValue + "' and t.is_del = '0' and r.para_code is not null union select r.para_code,'" + listPathAll.SelectedValue + "','0',0.2,'test1' from ht_pub_tech_para r where r.para_type like '______1%' and r.path_node is null and r.is_del = '0')"); } else { log_message = "保存参数点失败"; } log_message += "--数据详情:" + string.Join(",", value); ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('" + log_message + "');", true); InsertTlog(log_message); } else { ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "message", "alert('请确认工艺参数所属工艺段是否正确')", true); } }
protected DataSet sectionbind() { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (rdType1.Checked) { return(opt.CreateDataSetOra("select r.section_code,r.section_name from ht_pub_tech_section r left join ht_pub_tech_para t on substr(t.para_code,1,5) = r.section_code and t.para_type like '_______1%' and t.is_valid = '1' and t.is_del = '0' where r.is_del = '0' and r.is_valid = '1' and t.para_code is not null union select '' as section_code,'' as section_name from dual order by section_code")); } else { return(opt.CreateDataSetOra("select r.section_code,r.section_name from ht_pub_tech_section r left join ht_pub_tech_para t on substr(t.para_code,1,5) = r.section_code and t.para_type like '___1___1%' and t.is_valid = '1' and t.is_del = '0' where r.is_del = '0' and r.is_valid = '1' and t.para_code is not null union select '' as section_code,'' as section_name from dual order by section_code")); } }
protected void bindGrid() { string query = "select distinct g.section_name as 工艺段, '' as 路径选择, '' as 路径详情,g.section_code from ht_pub_tech_section g left join ht_pub_path_section h on h.section_code = g.section_code where h.section_code is not null and g.is_valid = '1' and g.is_del = '0' and g.IS_PATH_CONFIG = '1' order by g.section_code"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); GridView1.DataSource = data; GridView1.DataBind(); if (data != null && data.Tables[0].Rows.Count > 0) { string[] subpath = listPathAll.SelectedValue.Split('-'); for (int i = 0; i < GridView1.Rows.Count; i++) { DataRowView mydrv = data.Tables[0].DefaultView[i]; ((TextBox)GridView1.Rows[i].FindControl("txtSection")).Text = mydrv["工艺段"].ToString(); DropDownList list = (DropDownList)GridView1.Rows[i].FindControl("listpath"); opt.bindDropDownList(list, "select pathname,pathcode from ht_pub_path_section where section_code = '" + mydrv["section_code"].ToString() + "' and is_del = '0' ", "pathname", "pathcode"); list.SelectedValue = mydrv["路径详情"].ToString(); if (subpath.Length == GridView1.Rows.Count) { list.SelectedValue = subpath[i].Substring(5); } query = createQuery(mydrv["section_code"].ToString()); if (query != "") { query += " and pathcode = '" + list.SelectedValue + "'"; DataSet set = opt.CreateDataSetOra(query); if (set != null && set.Tables[0].Rows.Count > 0) { for (int j = 1; j < set.Tables[0].Columns.Count - 2; j++) { CheckBox ck = new CheckBox(); if (0 == set.Tables[0].Rows.Count) { ck.Checked = false; } else { ck.Checked = (set.Tables[0].Rows[0][j].ToString() == "1"); } ck.Text = set.Tables[0].Columns[j].Caption; GridView1.Rows[i].Cells[2].Controls.Add(ck); } } } } } ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "disable", " $(\"input[type$='checkbox']\").attr('disabled', 'disabled');", true); }//绑定GridView4数据源
protected void btnUpdate_Click(object sender, EventArgs e) { MSYS.Web.PlanService.WsPlanForGSInterfaceService service = new MSYS.Web.PlanService.WsPlanForGSInterfaceService(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); quarterPlanVO[] pb = service.getQuarterPlanList(System.DateTime.Now.Year.ToString(), GetQuarterNum(System.DateTime.Now)); if (pb == null) { return; } // prodAssignVO[] pvo = service.getProdAssignListForGS("", ""); string[] seg = { "id", "PLAN_NAME", "FLOW_STATUS", "ISSUED_STATUS", "PLAN_YEAR", "QUARTER", "IS_DEL", "REMARK", "CREATE_ID" }; string[] seg2 = { "QUARTER_PLAN_ID", "prod_code ", "plan_OUTPUT_1", "PLAN_OUTPUT_2", "PLAN_OUTPUT_3", "TOTAL_OUTPUT", "IS_DEL" }; foreach (quarterPlanVO p in pb) { //string plname = p.quarterPlan.planName == "" ? System.DateTime.Now.Year.ToString() + "-" + GetQuarterNum(new DateTime()) + "季度生产计划" :p.quarterPlan.planName; string plname = System.DateTime.Now.Year.ToString() + "-" + Convert.ToInt32(GetQuarterNum(System.DateTime.Now)).ToString() + "季度生产计划"; System.Diagnostics.Debug.WriteLine(plname); System.Diagnostics.Debug.WriteLine(p.quarterPlan.id); string sqllog = "select id from ht_svr_user where loginname = '" + p.quarterPlan.createId + "'"; string cid = opt.CreateDataSetOra(sqllog).Tables[0].Rows[0][0].ToString(); string[] value = { p.quarterPlan.pzCode, plname, "2", p.quarterPlan.issuedStatus, p.quarterPlan.planYear, Convert.ToInt32(GetQuarterNum(System.DateTime.Now)).ToString(), "0", p.quarterPlan.remark, cid }; // string[] value2 = { p.id }; opt.MergeInto(seg, value, 2, "HT_PROD_SEASON_PLAN"); foreach (tAmQuarterPlanDetail pd in p.subList) { System.Diagnostics.Debug.WriteLine(pd.prodCode); System.Diagnostics.Debug.WriteLine(System.DateTime.Now.Year.ToString()); System.Diagnostics.Debug.WriteLine(GetQuarterNum(System.DateTime.Now)); string sql = "select prod_code from ht_pub_prod_design where xy_prod_code = " + pd.prodCode; DataSet ds = opt.CreateDataSetOra(sql); if (ds == null || ds.Tables[0].Rows.Count == 0) { continue; } string xy_prod_code = ds.Tables[0].Rows[0][0].ToString(); if (xy_prod_code.Substring(0, 3) != "703") { continue; } // string[] value2 = { p.quarterPlan.id, pd.prodCode, pd.planOutput1.ToString(), pd.planOutput2.ToString(), pd.planOutput3.ToString(), pd.totalOutput.ToString(), pd.isDel }; string[] value2 = { p.quarterPlan.pzCode, xy_prod_code, pd.planOutput1.ToString(), pd.planOutput2.ToString(), pd.planOutput3.ToString(), pd.totalOutput.ToString(), pd.isDel }; opt.MergeInto(seg2, value2, 2, "HT_PROD_SEASON_PLAN_DETAIL"); } // opt.getMergeStr(seg2, value2, 1, "HT_PROD_MONTH_PLAN_DETAIL"); // dt.Rows.Add(paras); } bindGrid1(); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('同步完成');", true); }
protected void bindStatistic() { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string query; if (listTeam.SelectedValue == "") { query = "select a5.prod_name as 产品, a1.score as 在线考核分,a2.score as 理化检测得分,a3.score as 感观评测得分,a4.score as 过程检测得分, (select weight from ht_qlt_weight where id='1')*nvl(a1.score,100) + (select weight from ht_qlt_weight where id='2')*nvl(a2.score,100)+ (select weight from ht_qlt_weight where id='3')*nvl(a3.score,100) + (select weight from ht_qlt_weight where id='4')*nvl(a4.score,100) as 总得分 from (select distinct prod_code from ht_qlt_inspect_record r where substr(r.record_time,1,10) = '" + txtStartTime.Text + "' union select distinct prod_code from ht_qlt_data_record where substr(b_time,1,10) = '" + txtStartTime.Text + "') a left join ht_pub_prod_design a5 on a5.prod_code = a.prod_code left join (select sum(r.score * s.weight) as score,r.prod_code from (select a.section,sum(a.quarate * c.weight*100) as score,a.prod_code from (select r.prod_code, substr(r.para_code,1,5) as section,r.para_code,sum(r.quarate*r.count)/sum(r.count) as quarate from ht_qlt_data_record r where substr(r.b_time,1,10) = '" + txtStartTime.Text + "' group by r.para_code,r.prod_code) a left join ht_pub_tech_para b on b.para_code = a.para_code and b.para_type like '______1%' left join ht_qlt_weight c on c.id = a.para_code group by a.section,a.prod_code )r left join ht_pub_tech_section s on s.section_code = r.section group by r.prod_code )a1 on a5.prod_name = a.prod_code left join (select round(avg(得分),2) as score,产品 from hv_phychem_daily_report r left join ht_pub_prod_design t on r.产品 = t.prod_name where substr(r.检测时间,1,10) = '" + txtStartTime.Text + "' group by 产品)a2 on a5.prod_name = a2.产品 left join (select round(avg(得分),2) as score,产品 from hv_sensor_daily_report r left join ht_pub_prod_design t on r.产品 = t.prod_name where substr(r.检测时间,1,10) = '" + txtStartTime.Text + "' group by 产品)a3 on a5.prod_name = a3.产品 left join (select round(avg(得分),2) as score,产品 from hv_process_daily_report r left join ht_pub_prod_design t on r.产品 = t.prod_name where substr(r.检测时间,1,10) = '" + txtStartTime.Text + "' group by 产品)a4 on a5.prod_name = a4.产品 order by a5.prod_name"; } else { query = " select a5.prod_name as 产品,a6.team_name as 班组, a1.score as 在线考核分,a2.score as 理化检测得分,a3.score as 感观评测得分,a4.score as 过程检测得分, (select weight from ht_qlt_weight where id='1')*nvl(a1.score,100) + (select weight from ht_qlt_weight where id='2')*nvl(a2.score,100)+ (select weight from ht_qlt_weight where id='3')*nvl(a3.score,100) + (select weight from ht_qlt_weight where id='4')*nvl(a4.score,100) as 总得分 from (select distinct team_id as team, prod_code from ht_qlt_inspect_record where substr(record_time,1,10) = '" + txtStartTime.Text + "' union select distinct team, prod_code from ht_qlt_data_record where substr(b_time,1,10) = '" + txtStartTime.Text + "') a left join ht_pub_prod_design a5 on a5.prod_code = a.prod_code left join ht_sys_team a6 on a6.team_code = a.team left join (select sum(r.score * s.weight) as score,r.prod_code,r.team from (select a.section,sum(a.quarate * c.weight*100) as score,a.prod_code,a.team from (select r.prod_code,r.team, substr(r.para_code,1,5) as section,r.para_code,sum(r.quarate*r.count)/sum(r.count) as quarate from ht_qlt_data_record r where substr(r.b_time,1,10) = '" + txtStartTime.Text + "' group by r.para_code,r.prod_code,r.team) a left join ht_pub_tech_para b on b.para_code = a.para_code and b.para_type like '______1%' left join ht_qlt_weight c on c.id = a.para_code group by a.section,a.prod_code ,a.team)r left join ht_pub_tech_section s on s.section_code = r.section group by r.prod_code,r.team )a1 on a.prod_code = a1.prod_code and a6.team_code = a1.team left join (select round(avg(得分),2) as score,产品,班组 from hv_phychem_daily_report r left join ht_pub_prod_design t on r.产品 = t.prod_name where substr(r.检测时间,1,10) = '" + txtStartTime.Text + "' group by 产品,班组)a2 on a5.prod_name = a2.产品 and a6.team_name = a2.班组 left join (select round(avg(得分),2) as score,产品,班组 from hv_sensor_daily_report r left join ht_pub_prod_design t on r.产品 = t.prod_name where substr(r.检测时间,1,10) = '" + txtStartTime.Text + "' group by 产品,班组)a3 on a5.prod_name = a3.产品 and a6.team_name = a3.班组 left join (select round(avg(得分),2) as score,产品,班组 from hv_process_daily_report r left join ht_pub_prod_design t on r.产品 = t.prod_name where substr(r.检测时间,1,10) = '" + txtStartTime.Text + "' group by 产品,班组)a4 on a5.prod_name = a4.产品 and a6.team_name = a4.班组 where a6.team_code = '" + listTeam.SelectedValue + "'"; } GridAll.DataSource = opt.CreateDataSetOra(query); GridAll.DataBind(); query = "select * from hv_online_daily_report t where substr(时间,1,10) = '" + txtStartTime.Text + "'"; if (listTeam.SelectedValue != "") { query += " and t.班组 = '" + listTeam.SelectedItem.Text + "'"; } query += " order by t.产品,t.班组"; GridView1.DataSource = opt.CreateDataSetOra(query); GridView1.DataBind(); query = "select * from hv_process_daily_report t where substr(检测时间,1,10) = '" + txtStartTime.Text + "'"; if (listTeam.SelectedValue != "") { query += " and t.班组 = '" + listTeam.SelectedItem.Text + "'"; } query += " order by t.产品,t.班组"; GridView2.DataSource = opt.CreateDataSetOra(query); GridView2.DataBind(); query = "select * from hv_phychem_daily_report t where substr(检测时间,1,10) = '" + txtStartTime.Text + "'"; if (listTeam.SelectedValue != "") { query += " and t.班组 = '" + listTeam.SelectedItem.Text + "'"; } query += " order by t.产品,t.班组"; GridView3.DataSource = opt.CreateDataSetOra(query); GridView3.DataBind(); query = "select * from hv_sensor_daily_report t where substr(检测时间,1,10) = '" + txtStartTime.Text + "'"; if (listTeam.SelectedValue != "") { query += " and t.班组 = '" + listTeam.SelectedItem.Text + "'"; } query += " order by t.产品,t.班组"; GridView4.DataSource = opt.CreateDataSetOra(query); GridView4.DataBind(); }
protected void btnGridview_Click(object sender, EventArgs e)//查看领退明细 { Button btn = (Button)sender; int rowIndex = ((GridViewRow)btn.NamingContainer).RowIndex; txtCode.Text = GridView1.DataKeys[rowIndex].Values[0].ToString(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra("select * from HT_STRG_FLAVOR where ORDER_SN = '" + txtCode.Text + "'"); if (data != null && data.Tables[0].Rows.Count > 0) { txtPrdctdate.Text = data.Tables[0].Rows[0]["OUT_DATE"].ToString(); listStatus.SelectedValue = data.Tables[0].Rows[0]["AUDIT_MARK"].ToString(); listStorage.SelectedValue = data.Tables[0].Rows[0]["WARE_HOUSE_ID"].ToString(); listApt.SelectedValue = data.Tables[0].Rows[0]["DEPT_ID"].ToString(); if (listPrdctPlan.Items.FindByValue(data.Tables[0].Rows[0]["MONTHPLANNO"].ToString()) != null) { listPrdctPlan.SelectedValue = data.Tables[0].Rows[0]["MONTHPLANNO"].ToString(); txtPrdctPlan.Text = listPrdctPlan.SelectedValue; txtPrdctPlan.Visible = false; listPrdctPlan.Visible = true; } else { listPrdctPlan.SelectedValue = ""; txtPrdctPlan.Text = data.Tables[0].Rows[0]["MONTHPLANNO"].ToString(); txtPrdctPlan.Visible = true; listPrdctPlan.Visible = false; } string temp = opt.GetSegValue("select Prod_code from ht_prod_month_plan_detail where plan_no = '" + txtPrdctPlan.Text + "'", "PROD_CODE"); if (listPrdct.Items.FindByValue(temp) != null) { listPrdct.SelectedValue = temp; } else { listPrdct.SelectedValue = ""; } txtBatchNum.Text = data.Tables[0].Rows[0]["BATCHNUM"].ToString(); DropDownListShift.SelectedValue = data.Tables[0].Rows[0]["shift_code"].ToString(); DropDownListTeam.SelectedValue = data.Tables[0].Rows[0]["team_code"].ToString(); txtValiddate.Text = data.Tables[0].Rows[0]["EXPIRED_DATE"].ToString(); txtStemSum.Text = data.Tables[0].Rows[0]["CABOSUM"].ToString(); listCreator.SelectedValue = data.Tables[0].Rows[0]["CREATOR_ID"].ToString(); } if (listStatus.SelectedItem.Text == "未提交") { SetEnable(true); } else { SetEnable(false); } bindGrid2(); }
/// <summary> /// tab2操作 /// </summary> protected void bindGrid1() { string query = hideQuery.Value; if (query != "") { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet set = opt.CreateDataSetOra(query); DataTable data = new DataTable(); data = set.Tables[0]; object[] value = new object[data.Columns.Count]; value[0] = ""; for (int i = 1; i < value.Length - 2; i++) { value[i] = "0"; } value[data.Columns.Count - 2] = listSection1.SelectedValue; value[data.Columns.Count - 1] = ""; data.Rows.Add(value); attachData(data); } else { GridView1.DataSource = null; GridView1.DataBind(); } }
protected void createView() { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra("select * from ht_qlt_weight t where is_del = '0' order by ID "); if (data != null && data.Tables[0].Rows.Count == 4) { DataRowCollection Rows = data.Tables[0].Rows; StringBuilder str = new StringBuilder(); str.Append(" select nvl(r.产品,nvl(s.产品,nvl(t.产品,p.产品))) as 产品,nvl(r.班组,nvl(s.班组,nvl(t.班组,p.班组))) as 班组,nvl(r.时间,nvl(s.检测时间,nvl(t.检测时间,p.检测时间))) as 时间,r.总分 as 在线考核分,s.得分 as 过程检测得分,t.得分 as 理化检测得分,p.得分 as 感观评测得分,nvl(r.总分,100) *"); str.Append(Rows[0]["Weight"].ToString()); str.Append("+ nvl(t.得分,100) * "); str.Append(Rows[1]["Weight"].ToString()); str.Append("+ nvl(p.得分,100) * "); str.Append(Rows[2]["Weight"].ToString()); str.Append("+ nvl(s.得分,100) * "); str.Append(Rows[3]["Weight"].ToString()); str.Append(" as 总得分 from ("); str.Append(getOnlineScore()); str.Append(")r"); str.Append(" full join ("); str.Append(getProcessScore()); str.Append(") s on s.产品 = r.产品 and s.班组 = r.班组 and s.检测时间 = r.时间"); str.Append(" full join ("); str.Append(getPhycheScore()); str.Append(") t on (t.产品 = r.产品 and t.班组 = r.班组 and t.检测时间 = r.时间 ) or (t.产品 = s.产品 and t.班组 = s.班组 and t.检测时间 = s.检测时间 )"); str.Append(" full join ("); str.Append(getSensorScore()); str.Append(") p on (p.产品 = r.产品 and p.班组 = r.班组 and p.检测时间 = r.时间) or (p.产品 = s.产品 and p.班组 = s.班组 and p.检测时间 = s.检测时间 ) or (t.产品 = p.产品 and t.班组 = p.班组 and t.检测时间 = p.检测时间 ) "); opt.UpDateOra("create or replace view hv_QLT_daily_report as " + str.ToString()); } }
protected void btnGridView_Click(object sender, EventArgs e) { Button btn = (Button)sender; int Rowindex = ((GridViewRow)btn.NamingContainer).RowIndex;//获得行号 hdcode.Value = GridView1.DataKeys[Rowindex].Value.ToString(); string query = "select * from HT_EQ_FAULT_DB where id = '" + hdcode.Value.ToString() + "'"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow row = data.Tables[0].Rows[0]; txtName.Text = row["ERROR_NAME"].ToString(); listEq.SelectedValue = row["EQUIP_CODE"].ToString(); listEqType.SelectedValue = row["EQP_TYPE"].ToString(); txtEditor.Text = row["EDITOR"].ToString(); txtLocation.Text = row["SPECIFIC_LOCATION"].ToString(); listSection.SelectedValue = row["SECTION_CODE"].ToString(); listStyle1.SelectedValue = row["FAULT_TYPE1"].ToString(); listStyle2.SelectedValue = row["FAULT_TYPE2"].ToString(); listStyle3.SelectedValue = row["FAULT_TYPE3"].ToString(); listStyle4.SelectedValue = row["FAULT_TYPE4"].ToString(); listStyle5.SelectedValue = row["FAULT_TYPE5"].ToString(); listStyle6.SelectedValue = row["FAULT_TYPE6"].ToString(); txtScean.Text = row["SCEAN"].ToString(); txtDescpt.Text = row["ERROR_DESCRIPTION"].ToString(); txtReason.Text = row["FAILURE_CAUSE"].ToString(); txtSolution.Text = row["SOLUTION"].ToString(); } ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "treeClick();", true); }
protected void bindGrid() { string query = "select t1.eq_name as 故障设备, t.error_name as 故障名,t.specific_location as 故障位置,t.editor as 编制人,t.CREATE_TIME as 记录时间,t.ID from ht_eq_fault_db t left join ht_eq_eqp_tbl t1 on t1.idkey = t.equip_code where t.is_del = '0'"; if (listType1.SelectedValue != "") { query += " and t.FAULT_TYPE1 = '" + listType1.SelectedValue + "'"; } if (listType2.SelectedValue != "") { query += " and t.FAULT_TYPE2 = '" + listType2.SelectedValue + "'"; } if (listType3.SelectedValue != "") { query += " and t.FAULT_TYPE3 = '" + listType3.SelectedValue + "'"; } if (listType4.SelectedValue != "") { query += " and t.FAULT_TYPE4 = '" + listType4.SelectedValue + "'"; } if (listType5.SelectedValue != "") { query += " and t.FAULT_TYPE5 = '" + listType5.SelectedValue + "'"; } if (listType6.SelectedValue != "") { query += " and t.FAULT_TYPE6 = '" + listType6.SelectedValue + "'"; } query += " order by t.CREATE_TIME"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); GridView1.DataSource = data; GridView1.DataBind(); }
protected void bindData3(string paracode) { try { string query = "select * from HT_PUB_TECH_PARA where PARA_CODE = '" + paracode + "'"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow row = data.Tables[0].Rows[0]; txtCode.Text = paracode; txtName.Text = row["PARA_NAME"].ToString(); txtUnit.Text = row["PARA_UNIT"].ToString(); txtSetTag.Text = row["SET_TAG"].ToString(); txtValueTag.Text = row["VALUE_TAG"].ToString(); setType(row["PARA_TYPE"].ToString()); txtDscrp.Text = row["REMARK"].ToString(); rdValid.Checked = ("1" == row["IS_VALID"].ToString()); opt.bindDropDownList(listEquip, "select EQ_NAME,IDKEY from ht_eq_eqp_tbl t where t.section_code = '" + txtCode.Text.Substring(0, 5) + "'", "EQ_NAME", "IDKEY"); listEquip.SelectedValue = row["EQUIP_CODE"].ToString(); listSection.SelectedValue = paracode.Substring(0, 5); listApt.SelectedValue = row["BUSS_ID"].ToString(); opt.bindDropDownList(listPathnode, "select nodename,id from ht_pub_path_node t where section_code = '" + listSection.SelectedValue + "' and is_del = '0'", "nodename", "id"); listPathnode.SelectedValue = row["PATH_NODE"].ToString(); } } catch (Exception error) { ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "error", "<Script>alert('" + error.Message + "')</Script>", false); } }
protected void btnGrid2View_Click(object sender, EventArgs e) { Button btn = (Button)sender; GridViewRow Row = (GridViewRow)btn.NamingContainer; int rowIndex = Row.RowIndex; string ID = GridView2.DataKeys[rowIndex].Value.ToString(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra("select * from HT_EQ_RP_PLAN_DETAIL where id = '" + ID + "'"); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow row = data.Tables[0].Rows[0]; txtCodeS.Text = ID; listEq.SelectedValue = row["EQUIPMENT_ID"].ToString(); txtOpttime.Text = row["EXE_TIME"].ToString(); listOptor.SelectedValue = row["RESPONER"].ToString(); listArea.SelectedValue = row["MECH_AREA"].ToString(); txtRecord.Text = row["REASON"].ToString() + ";" + row["CONTENT"].ToString() + ";" + row["REMARK"].ToString(); string ftid = row["FAULT_ID"].ToString(); txtFalut.Text = opt.GetSegValue("select '故障名:'||t.error_name||';故障描述:'|| t.error_description||';故障场景:'||t.scean||';故障原因:'||t.failure_cause||';解决方案'||t.solution as faultinfo from ht_eq_fault_db t where t.ID = '" + ftid + "'", "faultinfo"); txtFeedback.Text = row["FEEDBACK"].ToString() + ";" + row["REMARKPLUS"].ToString(); } ScriptManager.RegisterStartupScript(UpdatePanel3, this.Page.GetType(), "", "$('.shade').fadeIn(200);", true); }
protected void btngrid1View_Click(object sender, EventArgs e) { Button btn = (Button)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; int index = row.RowIndex; hideEventID.Value = GridView1.DataKeys[index].Values[0].ToString(); txtPara.Text = row.Cells[2].Text; txtPlanno.Text = row.Cells[1].Text; txtStarttime.Text = row.Cells[3].Text; txtEndtime.Text = row.Cells[4].Text; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra("select * from ht_tech_event where id = '" + hideEventID.Value + "'"); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow dr = data.Tables[0].Rows[0]; if (dr["EDITOR"].ToString() == "") { txtEditor.Text = ((MSYS.Data.SysUser)Session["User"]).text; } else { txtEditor.Text = dr["EDITOR"].ToString(); } txtEdittime.Text = dr["EDITTIME"].ToString(); txtReason.Text = dr["REASON"].ToString(); txtDescrpt.Text = dr["COMMENTS"].ToString(); } }
public string InitTree() { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra("select g.section_code,g.section_name from ht_pub_tech_section g where g.IS_VALID = '1' and g.IS_DEL = '0' order by g.section_code "); if (data != null && data.Tables[0].Rows.Count > 0) { string tvHtml = "<ul id='browser' class='filetree treeview-famfamfam'>"; DataRow[] rows = data.Tables[0].Select(); foreach (DataRow row in rows) { // tvHtml += "<li ><span class='folder' onclick = \"treeClick('" + row["section_code"].ToString() + "')\">" + row["section_name"].ToString() + "</span>"; tvHtml += "<li ><span class='folder' value = '" + row["section_code"].ToString() + "'>" + row["section_name"].ToString() + "</span>"; tvHtml += InitTreeSectionPara(row["section_code"].ToString()); tvHtml += InitTreeEquip(row["section_code"].ToString()); tvHtml += "</li>"; } tvHtml += "</ul>"; return(tvHtml); } else { return(""); } }
protected void bindGrid2(string code) { string query = "select t.section as 工段,t.equipment_id as 设备名称,t.point as 数据点,t.OLDVALUE as 原值,t.POINTVALUE as 校准值,t.SAMPLE_TIME as 校准时间,t.STATUS as 状态,t.remark as 备注 ,t.ID from HT_EQ_MCLBR_PLAN_detail t where t.main_id = '" + code + "' and t.is_del = '0'"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); GridView2.DataSource = data; GridView2.DataBind(); if (data != null && data.Tables[0].Rows.Count > 0) { for (int i = GridView2.PageSize * GridView2.PageIndex; i < GridView2.PageSize * (GridView2.PageIndex + 1) && i < data.Tables[0].Rows.Count; i++) { int j = i - GridView2.PageSize * GridView2.PageIndex; DataRowView mydrv = data.Tables[0].DefaultView[i]; GridViewRow row = GridView2.Rows[j]; DropDownList list1 = (DropDownList)row.FindControl("listGridsct"); DropDownList list2 = (DropDownList)row.FindControl("listGridEq"); DropDownList list3 = (DropDownList)row.FindControl("listGridPoint"); list1.SelectedValue = mydrv["工段"].ToString(); opt.bindDropDownList(list2, "select IDKEY,EQ_NAME from ht_eq_eqp_tbl where section_code = '" + list1.SelectedValue + "' order by idkey", "EQ_NAME", "IDKEY"); list2.SelectedValue = mydrv["设备名称"].ToString(); opt.bindDropDownList(list3, "select para_code,para_name from ht_pub_tech_para where equip_code = '" + list2.SelectedValue + "' order by para_code ", "para_name", "para_code"); list3.SelectedValue = mydrv["数据点"].ToString(); ((TextBox)row.FindControl("txtGridOldvalue")).Text = mydrv["原值"].ToString(); ((TextBox)row.FindControl("txtGridNewvalue")).Text = mydrv["校准值"].ToString(); ((TextBox)row.FindControl("txtGridClbrtime")).Text = mydrv["校准时间"].ToString(); ((DropDownList)row.FindControl("listGrid2Status")).SelectedValue = mydrv["状态"].ToString(); ((TextBox)row.FindControl("txtGridremark")).Text = mydrv["备注"].ToString(); } } }//绑定GridView2数据源
protected string initLevel2Menu(string prtID, string roleID) { string resultHtml = ""; string query = "select distinct t.f_role ,t.f_right,q.name as prtName,q.menulevel ,q.ID as prtID from ht_svr_sys_role t left join ht_svr_sys_menu s on substr(t.f_right,to_number(s.f_ID),1) ='1' and s.f_type = '0' and s.is_del = '0' left join ht_svr_prt_menu q on q.id = s.f_pid and q.pid = '" + prtID + "' where q.menulevel = '2' and t.f_id = '" + roleID + "' order by q.ID"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); resultHtml += "<ul style='height: 300px;'>\r\n"; resultHtml += addChildMenu(prtID, roleID); if (data != null && data.Tables[0].Rows.Count > 0) { foreach (DataRow row in data.Tables[0].Rows) { resultHtml += " <li><cite></cite><a class='subhead'>" + row["prtName"].ToString() + "</a>\r\n"; resultHtml += "<ul>\r\n"; resultHtml += addChildMenu(row["prtID"].ToString(), roleID); resultHtml += "</ul>\r\n"; resultHtml += "</li>\r\n"; } } resultHtml += "</ul>\r\n"; return(resultHtml); }
protected void bindStatistic() { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string query; query = "select r.产品, t.output as 产量,t.output/s.output as 产量占比,r.* from hv_qlt_month_prod_report r left join (select t.PROD_CODE,substr(t.STARTTIME,1,7) as month, sum(decode(t.para_code,'7030500029',t.SEG_VALUE)) * sum(decode(t.para_code,'7030500030',t.SECTION_CODE)) as output from hv_prod_report t where t.SECTION_CODE = '70305' and t.starttime like '" + txtStartTime.Text + "%' group by substr(t.starttime,1,7),t.prod_code) t on t.PROD_CODE = r.prod_code and t.month = r.month left join (select substr(t.STARTTIME,1,7) as month, sum(decode(t.para_code,'7030500029',t.SEG_VALUE)) * sum(decode(t.para_code,'7030500030',t.SEG_VALUE)) as output from hv_prod_report t where t.SECTION_CODE = '70305' and t.starttime like '" + txtStartTime.Text + "%' group by substr(t.starttime,1,7)) s on s.month = r.month where r.month = '" + txtStartTime.Text + "'"; DataSet data = opt.CreateDataSetOra(query); GridAll.DataSource = data; GridAll.DataBind(); if (data != null && data.Tables[0].Rows.Count > 0) { labout.Text = opt.GetSegValue("select substr(t.STARTTIME,1,7) as month, sum(decode(t.para_code,'7030500029',t.SEG_VALUE)) * sum(decode(t.para_code,'7030500030',t.SEG_VALUE)) as output from hv_prod_report t where t.SECTION_CODE = '70305' and t.starttime like '" + txtStartTime.Text + "%' group by substr(t.starttime,1,7)", "output"); labout.Text = (labout.Text == "NoRecord" || labout.Text == "") ? "0" : labout.Text; if (labout.Text != "0") { double total = Convert.ToDouble(labout.Text); double score = 0; foreach (DataRow row in data.Tables[0].Rows) { score += Convert.ToDouble(row["产量"].ToString()) / total * Convert.ToDouble(row["产品得分"].ToString()); } labScore.Text = score.ToString(); } } }
protected void bindGrid2(string code) { string query = "select t.mech_area as 区域,t.equipment_id as 设备名称,t.reason as 维修原因,t.content as 维修内容,t.exp_finish_time as 期望完成时间,t.STATUS as 状态,r.name as 执行人,t.remark as 备注 ,t.ID from HT_EQ_RP_PLAN_detail t left join ht_svr_user r on r.id = t.responer where t.main_id = '" + code + "' and t.is_del = '0'"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); GridView2.DataSource = data; GridView2.DataBind(); if (data != null && data.Tables[0].Rows.Count > 0) { for (int i = 0; i <= GridView2.Rows.Count - 1; i++) { DataRowView mydrv = data.Tables[0].DefaultView[i]; GridViewRow row = GridView2.Rows[i]; DropDownList list1 = (DropDownList)row.FindControl("listGridarea"); DropDownList list2 = (DropDownList)row.FindControl("listGridEq"); list1.SelectedValue = mydrv["区域"].ToString(); opt.bindDropDownList(list2, "select distinct t.IDKEY,t.EQ_NAME from ht_eq_eqp_tbl t where t.is_del = '0' and t.is_valid = '1' and t.section_code = '" + list1.SelectedValue + "' order by t.idkey", "EQ_NAME", "IDKEY"); list2.SelectedValue = mydrv["设备名称"].ToString(); ((TextBox)row.FindControl("txtGridReason")).Text = mydrv["维修原因"].ToString(); ((TextBox)row.FindControl("txtGridcntnt")).Text = mydrv["维修内容"].ToString(); ((TextBox)row.FindControl("txtGridExptime")).Text = mydrv["期望完成时间"].ToString(); ((DropDownList)row.FindControl("listGrid2Status")).SelectedValue = mydrv["状态"].ToString(); ((TextBox)row.FindControl("txtGridremark")).Text = mydrv["备注"].ToString(); } } }//绑定GridView2数据源
protected void Page_Load(object sender, EventArgs e) { base.PageLoad(sender, e); if (!IsPostBack) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); opt.bindDropDownList(listApt, "select F_CODE,F_NAME from HT_SVR_ORG_GROUP", "F_NAME", "F_CODE"); opt.bindDropDownList(listRole, "select * from ht_svr_sys_role t", "F_ROLE", "F_ID"); opt.bindDropDownList(listTeam, "select team_code,team_name from ht_sys_team t where t.is_del = '0' order by team_code", "team_name", "team_code"); if (Session["User"] != null) { SysUser user = (SysUser)Session["User"]; txtID.Text = user.id; txtName.Text = user.text; listApt.SelectedValue = user.OwningBusinessUnitId; listRole.SelectedValue = user.UserRoleID; DataSet dt = opt.CreateDataSetOra("select * from ht_svr_user where ID = '" + txtID.Text + "'"); if (dt != null && dt.Tables[0].Rows.Count > 0) { DataRow row = dt.Tables[0].Rows[0]; txtPhone.Text = row["MOBILE"].ToString(); txtCallNO.Text = row["PHONE"].ToString(); txtFax.Text = row["RTXID"].ToString(); setGender(row["GENDER"].ToString()); listTeam.SelectedValue = row["TEAM_CODE"].ToString(); txtEmail.Text = row["EMAIL"].ToString(); txtDscp.Text = row["DESCRIPTION"].ToString(); } } } }
protected void bindGrid1() { string query = "select t.mt_name as 维修计划,t1.f_name as 部门, t2.name as 审批状态,t3.name as 执行状态,t.remark as 备注,t.pz_code from HT_EQ_RP_PLAN t left join ht_svr_org_group t1 on t1.f_code = t.create_dept_id left join ht_inner_aprv_status t2 on t2.id = t.flow_status left join ht_inner_eqexe_status t3 on t3.id = t.task_status where t.expired_date between '" + txtStart.Text + "' and '" + txtStop.Text + "' and t.IS_DEL = '0'"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra(query); GridView1.DataSource = data; GridView1.DataBind(); if (data != null && data.Tables[0].Rows.Count > 0) { for (int i = GridView1.PageSize * GridView1.PageIndex; i < GridView1.PageSize * (GridView1.PageIndex + 1) && i < data.Tables[0].Rows.Count; i++) { DataRowView mydrv = data.Tables[0].DefaultView[i]; GridViewRow row = GridView1.Rows[i - GridView1.PageSize * GridView1.PageIndex]; ((Label)row.FindControl("labAprv")).Text = mydrv["审批状态"].ToString(); ((Label)row.FindControl("labexe")).Text = mydrv["执行状态"].ToString(); if (!(mydrv["审批状态"].ToString() == "未提交" || mydrv["审批状态"].ToString() == "未通过")) { ((Button)row.FindControl("btnSubmit")).Enabled = false; ((Button)row.FindControl("btnSubmit")).CssClass = "btngrey"; ((Button)row.FindControl("btnGridview")).Text = "查看计划"; } else { ((Button)row.FindControl("btnSubmit")).Enabled = true; ((Button)row.FindControl("btnSubmit")).CssClass = "btn1 auth"; ((Button)row.FindControl("btnGridview")).Text = "编制计划"; } } } }//绑定gridview1数据源
private void fillFalutData(string id) { if (id == "") { SetBlank(); } else { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra("select * from ht_eq_fault_db where ID = '" + id + "'"); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow row = data.Tables[0].Rows[0]; txtFtID.Text = id; txtName.Text = row["ERROR_NAME"].ToString(); listEqType.SelectedValue = row["EQP_TYPE"].ToString(); txtLocation.Text = row["SPECIFIC_LOCATION"].ToString(); listSection.SelectedValue = row["SECTION_CODE"].ToString(); listStyle1.SelectedValue = row["FAULT_TYPE1"].ToString(); listStyle2.SelectedValue = row["FAULT_TYPE2"].ToString(); listStyle3.SelectedValue = row["FAULT_TYPE3"].ToString(); listStyle4.SelectedValue = row["FAULT_TYPE4"].ToString(); listStyle5.SelectedValue = row["FAULT_TYPE5"].ToString(); listStyle6.SelectedValue = row["FAULT_TYPE6"].ToString(); txtScean.Text = row["SCEAN"].ToString(); txtDescpt.Text = row["ERROR_DESCRIPTION"].ToString(); txtReason.Text = row["FAILURE_CAUSE"].ToString(); txtSolution.Text = row["SOLUTION"].ToString(); } } }
protected void btngrid2Deal_Click(object sender, EventArgs e) { Button btn = (Button)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; txtID.Text = GridView2.DataKeys[row.RowIndex].Value.ToString(); txtCodeZ.Text = txtCode.Value; string status = ((DropDownList)row.FindControl("listGrid2Status")).SelectedValue; if (status == "5") { btnModify.Visible = false; } else { btnModify.Visible = true; } MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra("select * from ht_eq_mt_plan_detail where ID = '" + txtID.Text + "'"); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow drow = data.Tables[0].Rows[0]; txtScean.Text = drow["FEEDBACK"].ToString(); txtPlus.Text = drow["REMARKPLUS"].ToString(); } else { txtScean.Text = ""; txtPlus.Text = ""; } ScriptManager.RegisterStartupScript(updtpanel1, this.Page.GetType(), "", " $('.shade').fadeIn(200);", true); }
protected void BindList(TreeNodeCollection ncTree, string pID) { ncTree.Clear(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string query = "select ID,Name,MenuLEVEL,PID from ht_svr_prt_menu "; if (pID == "") { query += " where pid is null "; } else { query += " where PID = '" + pID + "'"; } DataSet data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow[] Rows = data.Tables[0].Select(); foreach (DataRow row in Rows) { TreeNode pnode = new TreeNode(row["Name"].ToString(), row["ID"].ToString() + "_" + row["MenuLEVEL"].ToString() + "_" + row["PID"].ToString()); BindList(pnode.ChildNodes, row["ID"].ToString()); ncTree.Add(pnode); } } }
protected void btnSave_Click(object sender, EventArgs e) { try { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string ftID = ""; string query = "select * from HT_EQ_FAULT_DB where Error_name = '" + txtName.Text + "' and eqp_TYpe = '" + listEqType.SelectedValue + "' and SPECIFIC_LOCATION = '" + txtLocation.Text + "' and SECTION_CODE = '" + listSection.SelectedValue + "' and FAULT_TYPE1 = '" + listStyle1.SelectedValue + "' and FAULT_TYPE2 = '" + listStyle2.SelectedValue + "' and FAULT_TYPE3 = '" + listStyle3.SelectedValue + "' and FAULT_TYPE4 = '" + listStyle4.SelectedValue + "' and FAULT_TYPE5 = '" + listStyle5.SelectedValue + "' and FAULT_TYPE6 = '" + listStyle6.SelectedValue + "' and SCEAN = '" + txtScean.Text + "' and ERROR_DESCRIPTION = '" + txtDescpt.Text + "' and FAILURE_CAUSE = '" + txtReason.Text + "' and SOLUTION = '" + txtSolution.Text + "' and EQUIP_CODE = '" + listEq.SelectedValue + "'"; query = query.Replace("= ''", "is null"); DataSet data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { ftID = data.Tables[0].Rows[0]["ID"].ToString(); } else { ftID = opt.GetSegValue("select fault_id_seq.nextval from dual", "nextval"); string[] seg = { "ID", "ERROR_NAME", "EQP_TYPE", "SPECIFIC_LOCATION", "SECTION_CODE", "FAULT_TYPE1", "FAULT_TYPE2", "FAULT_TYPE3", "FAULT_TYPE4", "FAULT_TYPE5", "FAULT_TYPE6", "SCEAN", "ERROR_DESCRIPTION", "FAILURE_CAUSE", "SOLUTION", "CREATE_TIME", "EQUIP_CODE", "EDITOR" }; string[] value = { ftID, txtName.Text, listEqType.SelectedValue, txtLocation.Text, listSection.SelectedValue, listStyle1.SelectedValue, listStyle2.SelectedValue, listStyle3.SelectedValue, listStyle4.SelectedValue, listStyle5.SelectedValue, listStyle6.SelectedValue, txtScean.Text, txtDescpt.Text, txtReason.Text, txtSolution.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listEq.SelectedValue, ((MSYS.Data.SysUser)Session["User"]).text }; string log_message = opt.InsertData(seg, value, "HT_EQ_FAULT_DB") == "Success" ? "故障信息入库成功" : "故障信息入库失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindGrid(); } } catch (Exception ee) { Response.Write(ee.Message); } }
protected string getProcessScore() { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string query = "select inspect_code,inspect_name from ht_qlt_inspect_proj where INSPECT_TYPE = '0' and is_del = '0' order by inspect_code"; DataSet data = opt.CreateDataSetOra(query); StringBuilder sql = new StringBuilder(); StringBuilder str = new StringBuilder(); StringBuilder temp = new StringBuilder(); if (data != null && data.Tables[0].Rows.Count > 0) { int i = 1; temp.Append("100"); sql.Append("select g1.prod_code as 产品,g1.team_id as 班组,g1.record_time as 检测时间"); foreach (DataRow row in data.Tables[0].Rows) { string name = row["inspect_name"].ToString(); string code = row["inspect_code"].ToString(); temp.Append("-nvl(g"); temp.Append(i.ToString()); temp.Append(".score,0)"); if (i > 1) { str.Append(" left join "); } str.Append("(select a.prod_code,a.team_id,a.shift_ID,a.record_time ,nvl(b.score,0) as score, nvl(a.inspect_value,0) as "); str.Append(name); str.Append(" from ht_qlt_inspect_record a left join ht_qlt_inspect_event b on b.record_id = a.id where a.inspect_code = '"); str.Append(code); str.Append("')g"); str.Append(i.ToString()); if (i > 1) { str.Append(" on g1.prod_code = g"); str.Append(i.ToString()); str.Append(".prod_code and g1.team_id = g"); str.Append(i.ToString()); str.Append(".team_id and g1.record_time = g"); str.Append(i.ToString()); str.Append(".record_time "); } i++; } temp.Append(" as 得分"); sql.Append(","); sql.Append(temp); sql.Append(" from "); sql.Append(str.ToString()); return(sql.ToString()); } else { return(null); } }
protected void btngrid1Deal_Click(object sender, EventArgs e) { Button btn = (Button)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; hdType.Value = "1"; txtEventID.Text = GridView1.DataKeys[row.RowIndex].Values[0].ToString(); listStyle.SelectedValue = GridView1.DataKeys[row.RowIndex].Values[1].ToString(); if (((Button)row.FindControl("btngrid1Deal")).Text == "查看") { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra("select * from HT_QLT_AUTO_EVENT where RECORD_ID = '" + txtEventID.Text + "' and SORT = '" + listStyle.SelectedValue + "'"); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow drow = data.Tables[0].Rows[0]; txtScean.Text = drow["SCENE"].ToString(); txtReason.Text = drow["REASON"].ToString(); txtDeal.Text = drow["DEAL"].ToString(); txtPlus.Text = drow["REMARK"].ToString(); } } else { txtScean.Text = ""; txtReason.Text = ""; txtDeal.Text = ""; txtPlus.Text = ""; } ScriptManager.RegisterStartupScript(updtpanel1, this.Page.GetType(), "", " $('#craftdetail').fadeIn(200);", true); }
protected void btnAdd_Click(object sender, EventArgs e) { string query = "select section_code,seg_name,seg_info,unit,para_code from ht_inner_report_contrast where is_del = '0' "; if (listSection.SelectedValue != "") { query += " and section_code = '" + listSection.SelectedValue + "'"; } query += " order by section_code,para_code"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet set = opt.CreateDataSetOra(query); DataTable data = set.Tables[0]; if (data == null) { data = new DataTable(); data.Columns.Add("section_code"); data.Columns.Add("seg_name"); data.Columns.Add("seg_info"); data.Columns.Add("unit"); data.Columns.Add("para_code"); } object[] value = { "", "", "", "", "" }; data.Rows.Add(value); gridbind(data); }