protected void btnAdd_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (!Regex.IsMatch(hidePlanID.Value, @"^[+-]?/d*$")) { hidePlanID.Value = hidePlanID.Value.Substring(hidePlanID.Value.LastIndexOf(',') + 1); } foreach (GridViewRow row in GridView2.Rows) { if (((TextBox)row.FindControl("txtPlanNo")).Text.Substring(11, 4) == "TEMP") { string[] subseg = { "plan_no", "MONTH_PLAN_ID", "plan_Sort", "prod_code", "plan_output" }; string[] subvalue = { ((TextBox)row.FindControl("txtPlanNo")).Text, hidePlanID.Value, ((TextBox)row.FindControl("txtOrder")).Text, ((DropDownList)row.FindControl("listProd")).SelectedValue, ((TextBox)row.FindControl("txtOutput")).Text }; opt.MergeInto(subseg, subvalue, 1, "HT_PROD_MONTH_PLAN_DETAIL"); } } string planno = opt.GetSegValue("select nvl(Max(substr(PLAN_NO,16,2)),0)+1 as CODE from ht_prod_month_plan_detail where month_plan_ID = '" + hidePlanID.Value + "'", "CODE"); string mtr_code = "PD" + txtYear.Text + listMonth.SelectedValue + "000TEMP" + planno.PadLeft(2, '0'); string order = opt.GetSegValue("select nvl(max(plan_sort),0)+1 as ordernum from ht_prod_month_plan_detail where month_plan_id= '" + hidePlanID.Value + "'", "ordernum"); string[] seg = { "plan_no", "MONTH_PLAN_ID", "plan_Sort", "is_del", "is_valid" }; string[] value = { mtr_code, hidePlanID.Value, order, "0", "0" }; opt.MergeInto(seg, value, 1, "HT_PROD_MONTH_PLAN_DETAIL"); string query = " select t.plan_Sort as 顺序号, t.plan_no as 计划号, t.prod_code as 产品名称,round(t.plan_output,3) as 计划产量,t.path_code as 路径编码,r.name as 生产状态,(case t.mater_status when '1' then '要料中' when '2' then '己出库' when '3' then '己到料' else '' end) as 原料状态,(case t.coat_status when '1' then '要料中' when '2' then '己出库' when '3' then '己到料' else '' end) as 回填液状态,(case t.FLAVOR_STATUS when '1' then '要料中' when '2' then '己出库' when '3' then '己到料' else '' end) as 香精香料状态 from ht_prod_month_plan_detail t left join ht_inner_prodexe_status r on t.exe_status = r.id where t.is_del = '0' and t.MONTH_PLAN_ID = " + hidePlanID.Value + " order by plan_Sort"; DataSet set = opt.CreateDataSetOra(query); if (set != null) { DataTable data = set.Tables[0]; databindGrid2(data); } }
protected void btnGrid2Save_Click(object sender, EventArgs e) { Button btn = (Button)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "SHIFT_MAIN_ID", "mater_code", "PLAN_NO", "mater_vl", "bz_unit", "remark" }; string[] value = { hdID.Value, ((DropDownList)row.FindControl("listMater")).SelectedValue, listPlanno.SelectedValue, ((TextBox)row.FindControl("txtAmount")).Text, ((TextBox)row.FindControl("txtUnit")).Text, ((TextBox)row.FindControl("txtDescpt")).Text }; string log_message = opt.MergeInto(seg, value, 3, "HT_PROD_SHIFTCHG_DETAIL") == "Success" ? "保存生产交接班信息成功" : "保存生产交接班信息失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); string[] seg1 = { "PLANNO", "PROD_CODE", "SECTION_CODE", "TEAM", "TIME", "PARA_CODE", "CREATOR", "VALUE", }; string paravalue = ((DropDownList)row.FindControl("listMater")).SelectedValue; string paracode = ((DropDownList)row.FindControl("listMater")).SelectedValue; if (((TextBox)row.FindControl("txtParavalue")).Text != "") { string[] value1 = { listPlanno.SelectedValue, listPlanno.SelectedValue.Substring(8, 7), paracode.Substring(0, 5), listTeam.SelectedValue, txtDate.Text, paracode, txtEditor.Text, paravalue }; opt.MergeInto(seg1, value1, 6, "HT_PROD_REPORT_DETAIL"); } }
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(); System.Diagnostics.Debug.WriteLine(System.DateTime.Now.Month.ToString()); string month = System.DateTime.Now.Month.ToString().Length < 2? "0" + System.DateTime.Now.Month.ToString():System.DateTime.Now.Month.ToString(); prodAssignPlan[] pb = service.getProdAssignForGS(System.DateTime.Now.Year.ToString(), month); prodAssignVO[] pvo = service.getProdAssignListForGS(System.DateTime.Now.Year.ToString(), month); string[] seg = { "id", "PLAN_NAME", "B_FLOW_STATUS", "ISSUED_STATUS", "PLAN_TIME", "IS_DEL", "REMARK", "CREATE_ID" }; string[] seg2 = { "month_plan_id", "plan_no", "prod_code ", "plan_year", "prod_month", "plan_type", "plan_output", "plan_sort", "exe_status", "is_del", "is_valid", "create_id", "path_code" }; if (pb == null || pvo == null) { System.Diagnostics.Debug.WriteLine("无数据"); return; } string monthid = ""; string cid = ""; foreach (prodAssignPlan p in pb) { if (p.planNo.ToString().Substring(0, 2) != "GS") { continue; } monthid = p.id; string sqllog = "select id from ht_svr_user where loginname = '" + pvo[0].planNo + "'"; if (pvo[0].createId != null) { cid = opt.CreateDataSetOra(sqllog).Tables[0].Rows[0][0].ToString(); } string[] value = { p.id, p.planName, "2", p.issuedStatus, p.planNo.Substring(2, 4) + "-" + p.planNo.Substring(6, 2), "0", p.remark, cid }; // string[] value2 = { p.id }; opt.MergeInto(seg, value, 2, "HT_PROD_MONTH_PLAN"); // opt.getMergeStr(seg2, value2, 1, "HT_PROD_MONTH_PLAN_DETAIL"); // dt.Rows.Add(paras); } foreach (prodAssignVO p in pvo) { //if (p.planNo.ToString().Substring(0, 2) != "GS") //continue; // string sql = "select xy_prod_code from ht_pub_prod_design where prod_code = " + p.prodCode; // DataSet ds = opt.CreateDataSetOra(sql); //string xy_prod_code = ds.Tables[0].Rows[0][0].ToString(); if (p.prodCode.Substring(0, 3) != "703") { continue; } string path_code = opt.GetSegValue("select path_code from ht_pub_prod_design where prod_code = '" + p.prodCode + "'", "path_code"); string[] value = { monthid, p.planNo, p.prodCode, p.jobYear, p.jobMonth, p.planType, p.jobOutput, p.jobSort, Convert.ToInt32(p.status).ToString(), "0", "1", cid, path_code }; opt.MergeInto(seg2, value, 2, "HT_PROD_MONTH_PLAN_DETAIL"); insertSectionPath(path_code, p.planNo); } bindGrid1(); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('同步完成');", true); return; }
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 btnAdd_Click(object sender, EventArgs e) { if (!Regex.IsMatch(hidePlanID.Value, @"^[+-]?/d*$")) { hidePlanID.Value = hidePlanID.Value.Substring(hidePlanID.Value.LastIndexOf(',') + 1); } MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); foreach (GridViewRow row in GridView2.Rows) { if (!(((TextBox)row.FindControl("txtAmount1")).Text == "" && ((TextBox)row.FindControl("txtAmount2")).Text == "" && ((TextBox)row.FindControl("txtAmount3")).Text == "")) { if (((TextBox)row.FindControl("txtAmount1")).Text == "") { ((TextBox)row.FindControl("txtAmount1")).Text = "0"; } if (((TextBox)row.FindControl("txtAmount2")).Text == "") { ((TextBox)row.FindControl("txtAmount2")).Text = "0"; } if (((TextBox)row.FindControl("txtAmount3")).Text == "") { ((TextBox)row.FindControl("txtAmount3")).Text = "0"; } ((TextBox)row.FindControl("txtOutput")).Text = (Convert.ToDouble(((TextBox)row.FindControl("txtAmount1")).Text) + Convert.ToDouble(((TextBox)row.FindControl("txtAmount2")).Text) + Convert.ToDouble(((TextBox)row.FindControl("txtAmount3")).Text)).ToString("0.000"); string[] seg = { "QUARTER_PLAN_ID", "ID", "prod_code", "TOTAL_OUTPUT", "plan_output_1", "plan_output_2", "plan_output_3", "IS_DEL" }; string[] value = { hidePlanID.Value, GridView2.DataKeys[row.RowIndex].Value.ToString(), ((DropDownList)row.FindControl("listProd")).SelectedValue, ((TextBox)row.FindControl("txtOutput")).Text, ((TextBox)row.FindControl("txtAmount1")).Text, ((TextBox)row.FindControl("txtAmount2")).Text, ((TextBox)row.FindControl("txtAmount3")).Text, "0" }; opt.MergeInto(seg, value, 2, "ht_prod_season_plan_Detail"); } } string mtr_code = opt.GetSegValue("select seasondt_id_seq.nextval as id from dual", "id"); string[] subseg = { "QUARTER_PLAN_ID", "ID", "IS_VALID" }; string[] subvalue = { hidePlanID.Value, mtr_code, "0" }; opt.MergeInto(subseg, subvalue, 2, "ht_prod_season_plan_Detail"); string query = "select r.prod_code as 产品,round(r.TOTAL_OUTPUT,3) as 计划数量,round(r.plan_output_1,3) as month1,round(r.plan_output_2,3) as month2,round(r.plan_output_3,3) as month3,r.id from ht_prod_season_plan_Detail r where r.is_del = '0' and r.QUARTER_PLAN_ID = " + hidePlanID.Value + "order by r.id"; DataSet set = opt.CreateDataSetOra(query); if (set != null) { datagrid2Bind(set.Tables[0]); } }
protected void btnSave2_Click(object sender, EventArgs e) { string suc = "保存成功"; for (int i = 0; i < GridView2.Rows.Count; i++) { GridViewRow row = GridView2.Rows[i]; string mtr_code = ((TextBox)row.FindControl("txtCodeM")).Text; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); { string[] seg = { "PARA_CODE", "TECH_CODE", "VALUE", "UPPER_LIMIT", "LOWER_LIMIT", "EER_DEV", "UNIT", "IS_DEL" }; string[] value = { ((TextBox)row.FindControl("txtCodeM")).Text, txtCode.Text, ((TextBox)row.FindControl("txtValueM")).Text, ((TextBox)row.FindControl("txtUlimitM")).Text, ((TextBox)row.FindControl("txtLlimitM")).Text, ((TextBox)row.FindControl("txtDevM")).Text, ((TextBox)row.FindControl("txtUnitM")).Text, "0" }; string log_message; if (opt.MergeInto(seg, value, 2, "HT_TECH_STDD_CODE_DETAIL") == "Success") { log_message = "保存参数成功"; } else { log_message = "保存参数失败"; suc = "部分参数保存失败,请检查!!"; } log_message += ", 保存数据:" + string.Join(",", value); InsertTlog(log_message); } } bindGrid(txtCode.Text, hideprc.Value); bindGrid2(txtCode.Text, hideprc.Value); ScriptManager.RegisterStartupScript(UpdatePanel5, this.Page.GetType(), "alert", "alert('" + suc + "')", true); }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "QLT_CODE", "QLT_NAME", "STANDARD_VOL", "B_DATE", "E_DATE", "CREATE_ID", "CREATE_DATE", "REMARK" }; string[] value = { txtCode.Text, txtName.Text, txtVersion.Text, txtExeDate.Text, txtEndDate.Text, ((MSYS.Data.SysUser)Session["User"]).id, txtCrtDate.Text, txtDscpt.Text, }; string log_message; if (opt.MergeInto(seg, value, 1, "HT_QLT_STDD_CODE") == "Success") { log_message = "保存质量考核标准成功"; opt.bindDropDownList(listVersion, "select QLT_CODE,QLT_NAME from ht_qlt_STDD_CODE where is_valid = '1' and is_del= '0'", "QLT_NAME", "QLT_CODE"); opt.bindDropDownList(listtech, "select QLT_CODE,QLT_NAME from ht_qlt_STDD_CODE where is_valid = '1' and is_del= '0'", "QLT_NAME", "QLT_CODE"); opt.bindDropDownList(listtechC, "select QLT_CODE,QLT_NAME from ht_qlt_STDD_CODE where is_valid = '1' and is_del= '0'", "QLT_NAME", "QLT_CODE"); listAprv.SelectedValue = "-1"; } else { log_message = "保存质量考核标准失败"; } log_message += "--数据详情:" + string.Join(",", value); InsertTlog(log_message); }
protected void btnSave_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "INSPECT_CODE", "INSPECT_GROUP", "INSPECT_NAME", "INSPECT_TYPE", "REMARK", "CREATE_ID", "CREATE_TIME", "UNIT" }; string[] value = { txtCode.Text, listSection2.SelectedValue, txtName.Text, listType2.SelectedValue, txtRemark.Text, listCreator.SelectedValue, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtUnit.Text }; string log_message = opt.MergeInto(seg, value, 1, "ht_qlt_inspect_proj") == "Success" ? "保存工艺检查项目成功" : "保存工艺检查项目失败"; if (log_message == "保存工艺检查项目成功") { string[] procseg = { }; object[] procvalues = { }; if (listSection2.SelectedValue == "4") { opt.ExecProcedures("Create_Sensor_Report", procseg, procvalues); } else if (listSection2.SelectedValue.Length == 1 && listSection2.SelectedValue != "4") { opt.ExecProcedures("Create_phychem_Report", procseg, procvalues); } else { opt.ExecProcedures("Create_process_Report", procseg, procvalues); } } log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindGrid(); ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", " $('.shade').fadeOut(100);", true); }
protected void btnSave_Click(object sender, EventArgs e) { try { Button btn = (Button)sender; int Rowindex = ((GridViewRow)btn.NamingContainer).RowIndex;//获得行号 if (Rowindex >= 0) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "PZ_TYPE", "INDEX_NO", "ROLE", "FLOW_NAME" }; string[] value = { ((DropDownList)GridView1.Rows[Rowindex].FindControl("listType")).SelectedValue, ((TextBox)GridView1.Rows[Rowindex].FindControl("txtOrder")).Text, ((DropDownList)GridView1.Rows[Rowindex].FindControl("listRole")).SelectedValue, ((TextBox)GridView1.Rows[Rowindex].FindControl("txtFlowname")).Text }; string log_message = opt.MergeInto(seg, value, 2, "ht_pub_aprv_model") == "Success" ? "模板流程表保存成功" : "模板流程表保存失败"; log_message += ",保存参数:" + ((DropDownList)GridView1.Rows[Rowindex].FindControl("listType")).SelectedValue + " " + ((TextBox)GridView1.Rows[Rowindex].FindControl("txtOrder")).Text; InsertTlog(log_message); bindData(txtCode.Text); } } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnGrid2Save_Click(object sender, EventArgs e)// { Button btn = (Button)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; if (((DropDownList)row.FindControl("listGridarea")).SelectedValue == "" || ((DropDownList)row.FindControl("listGridEq")).SelectedValue == "" || ((TextBox)row.FindControl("txtGridExptime")).Text == "") { ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "alert('请将信息填写完全后再保存');", true); return; } int rowIndex = ((GridViewRow)btn.NamingContainer).RowIndex; string id = GridView2.DataKeys[rowIndex].Value.ToString(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (id == "0") { id = opt.GetSegValue("select rpdetail_id_seq.nextval as id from dual", "id"); } string[] seg = { "ID", "mech_area", "equipment_id", "reason", "content", "exp_finish_time", "remark", "CREATE_TIME", "MAIN_ID", "STATUS" }; string[] value = { id, ((DropDownList)row.FindControl("listGridarea")).SelectedValue, ((DropDownList)row.FindControl("listGridEq")).SelectedValue, ((TextBox)row.FindControl("txtGridReason")).Text, ((TextBox)row.FindControl("txtGridcntnt")).Text, ((TextBox)row.FindControl("txtGridExptime")).Text, ((TextBox)row.FindControl("txtGridremark")).Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtCode.Text, "0" }; string log_message = opt.MergeInto(seg, value, 1, "HT_EQ_RP_PLAN_detail") == "Success" ? "新增维修明细成功" : "新增维修明细失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindGrid2(txtCode.Text); }
protected void btnGrid2Save_Click(object sender, EventArgs e) { try { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (txtPzcode.Text == "") { txtPzcode.Text = "PK" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select nvl(max(substr(PZ_CODE,3,11)),0) as ordernum from HT_EQ_STG_PICKUP where substr(PZ_CODE,1,10) ='PK" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0'); } Button btn = (Button)sender; int Rowindex = ((GridViewRow)btn.NamingContainer).RowIndex;//获得行号 string ID = GridView2.DataKeys[Rowindex].Value.ToString(); if (ID == "0") { ID = opt.GetSegValue("select sub_pickup_id_seq.nextval as id from dual", "ID"); } string[] seg = { "ID", "MAIN_CODE", "STORAGE", "Sp_Code", "sp_name", "sp_standard", "sp_model", "sp_unit", "pickup_num", "own_section", "remark" }; string[] value = { ID, txtPzcode.Text, ((DropDownList)GridView2.Rows[Rowindex].FindControl("listGridstrg")).SelectedValue, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridCode")).Text, ((DropDownList)GridView2.Rows[Rowindex].FindControl("listGridName")).SelectedItem.Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridSpec")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridModel")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridUnit")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridAmount")).Text, ((DropDownList)GridView2.Rows[Rowindex].FindControl("listGridSection")).SelectedValue, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridDscprt")).Text }; string log_message = opt.MergeInto(seg, value, 1, "HT_EQ_STG_PICKUP_DETAIL") == "Success" ? "保存备品备件领退明细成功" : "保存备品备件领退明细失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindGrid2(); } catch (Exception ee) { Response.Write(ee.Message); } }
}//绑定GridView2数据源 protected void btnGrid2Save_Click(object sender, EventArgs e)// { try { 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(); string[] seg = { "ID", "OLDVALUE", "POINTVALUE", "SAMPLE_TIME", "remark", "STATUS" }; string[] value = { id, ((TextBox)row.FindControl("txtGridOldvalue")).Text, ((TextBox)row.FindControl("txtGridNewvalue")).Text, ((TextBox)row.FindControl("txtGridClbrtime")).Text, ((TextBox)row.FindControl("txtGridremark")).Text, "2" }; string log_message = opt.MergeInto(seg, value, 1, "HT_EQ_MCLBR_PLAN_detail") == "Success" ? "自动校准成功" : "自动校准失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); string alter = opt.GetSegValue("select case when total = done then 1 else 0 end as status from (select count(distinct t.id) as total,count( distinct t1.id) as done from HT_EQ_MCLBR_PLAN_detail t left join HT_EQ_MCLBR_PLAN_detail t1 on t1.id = t.id and t1.status >= '2' and t1.is_del = '0' where t.main_id = '" + txtCode.Value + "' and t.is_del = '0')", "status"); if (alter == "1") { opt.UpDateOra("update HT_EQ_MCLBR_PLAN set TASK_STATUS = '2' where PZ_CODE = '" + txtCode.Value + "' and TASK_STATUS = '1'"); bindGrid1(); } } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnModify2_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (txtCode_2.Text.Length == 8 && txtCode_2.Text.Substring(0, 5) == listSection_2.SelectedValue) { string[] seg = { "IDKEY", "CLS_CODE", "EQ_NAME", "SECTION_CODE", "REMARK", "CREATOR", "CREATE_TIME", "IS_CTRL" }; string[] value = { txtCode_2.Text, listSort_2.SelectedValue, txtName_2.Text, listSection_2.SelectedValue, txtDscpt_2.Text, ((MSYS.Data.SysUser)Session["user"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), Convert.ToInt16(ckCtrl_2.Checked).ToString() }; string log_message; if (opt.MergeInto(seg, value, 1, "HT_EQ_EQP_TBL") == "Success") { log_message = "保存设备成功"; tvHtml = InitTree(); ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('保存成功');", true); } else { log_message = "保存设备失败"; ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "alert('保存失败');", true); } log_message += "--数据详情:" + string.Join("-", value); InsertTlog(log_message); } else { ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "message", "alert('请确认设备所属工艺段是否正确')", true); } }
protected void btnGrid2Save_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (txtCode.Text == "") { txtCode.Text = "SC" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select count(ORDER_SN) as ordernum from HT_STRG_COAT where substr(ORDER_SN,1,10) ='SC" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0'); } Button btn = (Button)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; string ID = GridView2.DataKeys[row.RowIndex].Value.ToString(); if (ID == "0") { ID = opt.GetSegValue("select STRGCOAT_ID_SEQ.nextval as id from dual", "ID"); } string[] seg = { "ID", "STORAGE", "unit_code", "mater_code", "ORIGINAL_DEMAND", "MAIN_CODE" }; string[] value = { ID, ((DropDownList)row.FindControl("listGridstrg")).SelectedValue, ((TextBox)row.FindControl("txtGridUnit")).Text, ((TextBox)row.FindControl("txtGridcode")).Text, ((TextBox)row.FindControl("txtGridAmount")).Text, txtCode.Text }; string log_message = opt.MergeInto(seg, value, 1, "HT_STRG_COAT_SUB") == "Success" ? "保存原料领用明细成功" : "保存原料领用明细失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); update_MainAmount(txtCode.Text); bindGrid2(); }
protected void btnModify1_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); { string[] seg = { "SECTION_CODE", "SECTION_NAME", "REMARK", "IS_PATH_CONFIG", "CREATE_ID", "CREATE_TIME" }; string[] value = { txtCode_1.Text, txtName_1.Text, txtDscrp_1.Text, Convert.ToInt16(rdValid_1.Checked).ToString(), ((MSYS.Data.SysUser)Session["user"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; string log_message; if (opt.MergeInto(seg, value, 1, "HT_PUB_TECH_SECTION") == "Success") { log_message = "保存工艺段成功"; tvHtml = InitTree(); opt.bindDropDownList(listSection_2, "select section_code,section_name from ht_pub_tech_section where is_del = '0' and is_valid = '1' order by section_code", "section_name", "section_code"); opt.bindDropDownList(listSection, "select section_code,section_name from ht_pub_tech_section where is_valid = '1' and is_del = '0' order by section_code", "section_name", "section_code"); string[] procseg = { }; object[] procvalues = { }; opt.ExecProcedures("Create_Online_month_Report", procseg, procvalues); ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('保存成功');", true); } else { log_message = "保存工艺段失败"; } log_message += "--数据详情:" + string.Join("-", value); InsertTlog(log_message); } }
protected void btnSave_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] subseg = { "ID", "EDITOR", "EDITTIME", "REASON", "COMMENTS" }; string[] subvalue = { hideEventID.Value, txtEditor.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtReason.Text, txtDescrpt.Text }; opt.MergeInto(subseg, subvalue, 1, "HT_TECH_EVENT"); }
protected void btnSave_Click(object sender, EventArgs e)// { if (txtName.Text == "" || listEditor.SelectedValue == "" || txtExptime.Text == "") { ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "alert('请将信息填写完全');", true); return; } try { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "PZ_CODE", "MT_NAME", "CREATE_ID", "CREATE_DEPT_ID", "EXPIRED_DATE", "REMARK", "CREATE_TIME" }; string[] value = { txtCode.Text, txtName.Text, listEditor.SelectedValue, listApt.SelectedValue, txtExptime.Text, txtdscrpt.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; string log_message = opt.MergeInto(seg, value, 1, "HT_EQ_RP_PLAN") == "Success" ? "新增维修计划成功" : "新增维修计划失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindGrid1(); } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string userPwd; if (txtPswd.Text == "") { userPwd = opt.GetSegValue("select password from ht_svr_user where id= '" + txtID.Text + "'", "password"); txtPswd.Text = opt.GetSegValue("select psd from ht_svr_user where id= '" + txtID.Text + "'", "psd"); } else { userPwd = MSYS.Security.Encrypt.GetMD5String(txtPswd.Text); } string[] seg = { "ID", "NAME", "WEIGHT", "PARENTID", "MOBILE", "PHONE", "RTXID", "GENDER", "LOGINNAME", "PASSWORD", "EMAIL", "LEVELGROUPID", "IS_LOCAL", "IS_SYNC", "IS_DEL", "DESCRIPTION", "ROLE", "PSD", "TEAM_CODE" }; string[] value = { txtID.Text, txtName.Text, txtWeight.Text, txtPrt.Text, txtPhone.Text, txtCallNO.Text, txtFax.Text, getGender(), txtUser.Text, userPwd, txtEmail.Text, listApt.SelectedValue, Convert.ToInt16(rdLocal.Checked).ToString(), Convert.ToInt16(rdAsyn.Checked).ToString(), "0", txtDscp.Text, listRole.SelectedValue, txtPswd.Text, listTeam.SelectedValue }; string log_message = opt.MergeInto(seg, value, 1, "ht_svr_user") == "Success" ? "修改用户成功" : "修改用户失败"; value[9] = ""; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindData(); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", " $('.shade').fadeOut(200);", true); }
protected void btnGrid2Save_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (txtCode.Text == "") { txtCode.Text = "SC" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select count(ORDER_SN) as ordernum from HT_STRG_COAT where substr(ORDER_SN,1,10) ='SC" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0'); } foreach (GridViewRow row in GridView2.Rows) { string ID = GridView2.DataKeys[row.RowIndex].Value.ToString(); if (ID == "0") { ID = opt.GetSegValue("select STRGCOAT_ID_SEQ.nextval as id from dual", "ID"); } string[] seg = { "ID", "mater_code", "STORAGE", "unit_code", "ORIGINAL_DEMAND", "MAIN_CODE" }; string[] value = { ID, ((TextBox)row.FindControl("txtGridcode")).Text, ((DropDownList)row.FindControl("listGridstrg")).SelectedValue, ((TextBox)row.FindControl("txtGridUnit")).Text, ((TextBox)row.FindControl("txtGridAmount")).Text, txtCode.Text }; string log_message = opt.MergeInto(seg, value, 1, "HT_STRG_COAT_SUB") == "Success" ? "保存原料领退明细成功" : "保存原料领退明细失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); } //////计算出入库单总各类型总量 DataSet res = opt.CreateDataSetOra("select sum(t.original_demand) as amount ,t.mater_flag from HT_STRG_COAT_SUB t where t.main_code = '" + txtCode.Text + "' group by t.mater_flag"); if (res != null && res.Tables[0].Rows.Count > 0) { double CABOSUM = 0, PEICESSUM = 0; foreach (DataRow row in res.Tables[0].Rows) { if (row["mater_flag"].ToString() == "HT") { CABOSUM += Convert.ToDouble(row["amount"].ToString()); } if (row["mater_flag"].ToString() == "LY") { PEICESSUM += Convert.ToDouble(row["amount"].ToString()); } } txtStemSum.Text = CABOSUM.ToString("0.00"); txtChipSum.Text = PEICESSUM.ToString("0.00"); string[] seg1 = { "ORDER_SN", "CABOSUM", "PEICESSUM" }; string[] value1 = { txtCode.Text, txtStemSum.Text, txtChipSum.Text }; opt.MergeInto(seg1, value1, 1, "HT_STRG_COAT"); } bindGrid2(); bindGrid1(); }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); string log_message; if (txtPrdctdate.Text == "" || txtValiddate.Text == "" || listPrdctPlan.SelectedValue == "" || listPrdct.SelectedValue == "" || DropDownListShift.SelectedValue == "" || DropDownListTeam.SelectedValue == "") { ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "alert", "alert('请输入必要信息!!')", true); return; } //生成领用主表记录 string[] seg = { "ORDER_SN", "OUT_DATE", "EXPIRED_DATE", "MODIFY_TIME", "WARE_HOUSE_ID", "DEPT_ID", "CREATOR_ID", "MONTHPLANNO", "BATCHNUM", "STRG_TYPE", "team_code", "shift_code" }; string[] value = { txtCode.Text, txtPrdctdate.Text, txtValiddate.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listStorage.SelectedValue, listApt.SelectedValue, listCreator.SelectedValue, listPrdctPlan.SelectedValue, txtBatchNum.Text, "0", DropDownListTeam.SelectedValue.ToString(), DropDownListShift.SelectedValue.ToString() }; commandlist.Add(opt.getMergeStr(seg, value, 1, "HT_STRG_COAT")); commandlist.Add("delete from HT_STRG_COAT_SUB where MAIN_CODE = '" + txtCode.Text + "'"); //根据生产计划对应的配方明细生成原料领用明细 // commandlist.Add("insert into HT_STRG_COAT_SUB select '' as ID, g3.mater_code as MATER_CODE,g4.data_origin_flag as STORAGE,g3.batch_num*" + txtBatchNum.Text + " as ORIGINAL_DEMAND, '' as REAL_DEMAND,'' as Remark,g4.unit_code as UNIT_CODE , '0' as IS_DEL,g3.coat_flag as mater_flag,'" + txtCode.Text + "' as MAIN_CODE,'' as PACKNUM ,'' as SUBSTANCE, '' as ODDQTY ,g3.CLASS_NAME as cls_code from ht_prod_month_plan_detail g1 left join ht_pub_prod_design g2 on g1.prod_code = g2.prod_code left join HT_QA_COAT_FORMULA_detail g3 on g3.formula_code = g2.COAT_FORMULA_CODE and g3.is_del = '0' left join ht_pub_materiel g4 on g4.material_code = g3.mater_code where g1.plan_no = '" + listPrdctPlan.SelectedValue + "' and g3.mater_code is not null"); //commandlist.Add("insert into HT_STRG_COAT_SUB select '' as ID, g3.mater_code as MATER_CODE,g4.data_origin_flag as STORAGE,g3.batch_num*" + txtBatchNum.Text + " as ORIGINAL_DEMAND, '' as REAL_DEMAND,'' as Remark,g4.unit_code as UNIT_CODE , '0' as IS_DEL,g3.coat_flag as mater_flag,'" + txtCode.Text.Trim() + "' as MAIN_CODE,'' as PACKNUM ,'' as SUBSTANCE, '' as ODDQTY , '' as cls_code, '' as REMNANT, ''as PIECE_NUM from ht_prod_month_plan_detail g1 left join ht_pub_prod_design g2 on g1.prod_code = g2.prod_code left join HT_QA_COAT_FORMULA_detail g3 on g3.formula_code = g2.COAT_FORMULA_CODE and g3.is_del = '0' left join ht_pub_materiel g4 on g4.material_code = g3.mater_code where g1.plan_no = '" + listPrdctPlan.SelectedValue + "' and g3.mater_code is not null"); commandlist.Add("insert into HT_STRG_COAT_SUB select '' as ID, g3.mater_code as MATER_CODE,g4.data_origin_flag as STORAGE,g3.batch_num*1 as ORIGINAL_DEMAND, '' as REAL_DEMAND,'' as Remark,g4.unit_code as UNIT_CODE , '0' as IS_DEL,g3.coat_flag as mater_flag,'" + txtCode.Text.Trim() + "' as MAIN_CODE,'' as PACKNUM ,'' as SUBSTANCE, '' as ODDQTY , '' as cls_code, '' as REMNANT, ''as PIECE_NUM from ht_prod_month_plan_detail g1 left join ht_pub_prod_design g2 on g1.prod_code = g2.prod_code left join HT_QA_COAT_FORMULA_detail g3 on g3.formula_code = g2.COAT_FORMULA_CODE and g3.is_del = '0' left join ht_pub_materiel g4 on g4.material_code = g3.mater_code where g1.plan_no = '" + listPrdctPlan.SelectedValue + "' and g3.mater_code is not null"); log_message = opt.TransactionCommand(commandlist) == "Success" ? "生成原料领用主表记录成功" : "生成原料领用主表记录失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); //////计算出入库单总各类型总量 DataSet res = opt.CreateDataSetOra("select sum(t.original_demand) as amount ,t.mater_flag from HT_STRG_COAT_SUB t where t.main_code = '" + txtCode.Text + "' group by t.mater_flag"); if (res != null && res.Tables[0].Rows.Count > 0) { double CABOSUM = 0, PEICESSUM = 0; foreach (DataRow row in res.Tables[0].Rows) { if (row["mater_flag"].ToString() == "HT") { if (row["amount"].ToString() != "") { CABOSUM += Convert.ToDouble(row["amount"].ToString()); } } if (row["mater_flag"].ToString() == "LY") { if (row["amount"].ToString() != "") { PEICESSUM += Convert.ToDouble(row["amount"].ToString()); } } } txtStemSum.Text = CABOSUM.ToString("0.00"); txtChipSum.Text = PEICESSUM.ToString("0.00"); string[] seg1 = { "ORDER_SN", "CABOSUM", "PEICESSUM" }; string[] value1 = { txtCode.Text, txtStemSum.Text, txtChipSum.Text }; opt.MergeInto(seg1, value1, 1, "HT_STRG_COAT"); } bindGrid1(); bindGrid2(); }
protected void btnSave_Click(object sender, EventArgs e) { Button btn = (Button)sender; int rowIndex = ((GridViewRow)btn.NamingContainer).RowIndex; string id = GridView1.DataKeys[rowIndex].Value.ToString(); GridViewRow row = GridView1.Rows[rowIndex]; string mapID, RightID; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); ///在映射表中插入URL映射 if ("NoRecord" == (mapID = opt.GetSegValue("select * from ht_inner_map where URL = '" + ((TextBox)row.FindControl("txtURL")).Text + "'", "MAPID"))) { mapID = id; opt.MergeInto(new string[] { "MAPID", "URL" }, new string[] { mapID, ((TextBox)row.FindControl("txtURL")).Text }, 1, "HT_INNER_MAP"); } //在权限表中插入菜单权限 if ("NoRecord" == (RightID = opt.GetSegValue("select * from ht_svr_sys_menu where F_MENU = '" + ((TextBox)row.FindControl("txtMenu")).Text + "'", "F_ID"))) { RightID = (Convert.ToInt16(opt.GetSegValue("select Max(F_ID) as ID from ht_svr_sys_menu ", "ID")) + 1).ToString().PadLeft(5, '0'); } string[] seg = { "F_ID", "F_MENU", "F_MAPID", "F_PID", "F_DESCRIPT", "F_TYPE" }; string[] value = { RightID, ((TextBox)row.FindControl("txtMenu")).Text, mapID, ((DropDownList)row.FindControl("listPrt")).SelectedValue, ((TextBox)row.FindControl("txtDscrp")).Text, "0" }; //插入操作权限 if ("Success" == opt.MergeInto(seg, value, 1, "ht_svr_sys_menu")) { value[0] = (Convert.ToInt16(RightID) + 1).ToString().PadLeft(5, '0'); } value[5] = "1"; if (value[1] == "") { value[1] = "子框架" + ((DropDownList)row.FindControl("listPrt")).SelectedItem.Text; } string log_message = opt.InsertData(seg, value, "ht_svr_sys_menu") == "Success" ? "插入操作权限成功" : "插入操作权限失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindData(); }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); { string[] seg = { "PROCESS_CODE", "PROCESS_NAME", "REMARK", "IS_VALID", "CREATE_ID", "CREATE_TIME" }; string[] value = { txtCode.Text, txtName.Text, txtDscrp.Text, Convert.ToInt16(rdValid.Checked).ToString(), ((MSYS.Data.SysUser)Session["user"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; opt.MergeInto(seg, value, 1, "HT_PUB_INSPECT_PROCESS"); } }
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 void btnSave_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); foreach (GridViewRow row in GridView3.Rows) { string[] seg = { "ID", "FIRST", "SECOND", "THIRD" }; string[] value = { ((TextBox)row.FindControl("txtOrder")).Text, ((DropDownList)row.FindControl("listTeam1")).Text, ((DropDownList)row.FindControl("listTeam2")).Text, ((DropDownList)row.FindControl("listTeam3")).Text }; opt.MergeInto(seg, value, 1, "ht_inner_team_schedule"); } }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "PROD_CODE", "PROD_NAME", "PACK_NAME", "HAND_MODE", "TECH_STDD_CODE", "MATER_FORMULA_CODE", "FLA_FORMULA_CODE", "COAT_FORMULA_CODE", "QLT_CODE", "INSPECT_STDD", "SENSOR_SCORE", "REMARK", "CREATE_TIME", "PATH_CODE" }; string[] value = { txtCode.Text, txtName.Text, txtPack.Text, listType.SelectedValue, listTechStd.SelectedValue, listMtrl.SelectedValue, listFla.SelectedValue, listcoat.SelectedValue, listqlt.SelectedValue, listisp.SelectedValue, txtValue.Text, txtDscpt.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listPathAll.SelectedValue }; string log_message = opt.MergeInto(seg, value, 1, "HT_PUB_PROD_DESIGN") == "Success" ? "保存产品信息成功," : "保存产品信息失败,"; log_message += ",产品信息:" + string.Join(",", value); InsertTlog(log_message); bindGrid(); ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", " $('.shade').fadeOut(100);", true); }
protected void btnSave_Click(object sender, EventArgs e) { foreach (GridViewRow row in GridView1.Rows) { string[] seg = { "INSPECT_CODE", "PROD_CODE", "TEAM_ID", "RECORD_TIME", "SHIFT_ID", "INSPECT_VALUE", "CREAT_ID", "CREATE_TIME" }; string[] value = { GridView1.DataKeys[row.RowIndex].Value.ToString(), listProd.SelectedValue, listTeam.SelectedValue, txtProdTime.Text, listShift.SelectedValue, ((TextBox)row.FindControl("txtPara")).Text, listEditor.SelectedValue, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string log_message = opt.MergeInto(seg, value, 4, "HT_QLT_INSPECT_RECORD") == "Success" ? "保存过程检测结果成功" : "保存过程检测结果失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); } }
protected void btnGrid2Save_Click(object sender, EventArgs e) { try { Button btn = (Button)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; int Rowindex = row.RowIndex;//获得行号 string mtr_code = GridView2.DataKeys[Rowindex].Value.ToString(); if (!Regex.IsMatch(hidePlanID.Value, @"^[+-]?/d*$")) { hidePlanID.Value = hidePlanID.Value.Substring(hidePlanID.Value.LastIndexOf(',') + 1); } MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string log_message; if (!(((TextBox)row.FindControl("txtAmount1")).Text == "" && ((TextBox)row.FindControl("txtAmount2")).Text == "" && ((TextBox)row.FindControl("txtAmount3")).Text == "")) { if (((TextBox)row.FindControl("txtAmount1")).Text == "") { ((TextBox)row.FindControl("txtAmount1")).Text = "0"; } if (((TextBox)row.FindControl("txtAmount2")).Text == "") { ((TextBox)row.FindControl("txtAmount2")).Text = "0"; } if (((TextBox)row.FindControl("txtAmount3")).Text == "") { ((TextBox)row.FindControl("txtAmount3")).Text = "0"; } ((TextBox)row.FindControl("txtOutput")).Text = (Convert.ToDouble(((TextBox)row.FindControl("txtAmount1")).Text) + Convert.ToDouble(((TextBox)row.FindControl("txtAmount2")).Text) + Convert.ToDouble(((TextBox)row.FindControl("txtAmount3")).Text)).ToString("0.000"); string[] seg = { "QUARTER_PLAN_ID", "ID", "prod_code", "TOTAL_OUTPUT", "plan_output_1", "plan_output_2", "plan_output_3", "IS_DEL", "IS_VALID" }; string[] value = { hidePlanID.Value, GridView2.DataKeys[row.RowIndex].Value.ToString(), ((DropDownList)row.FindControl("listProd")).SelectedValue, ((TextBox)row.FindControl("txtOutput")).Text, ((TextBox)row.FindControl("txtAmount1")).Text, ((TextBox)row.FindControl("txtAmount2")).Text, ((TextBox)row.FindControl("txtAmount3")).Text, "0", "1" }; log_message = opt.MergeInto(seg, value, 2, "ht_prod_season_plan_Detail") == "Success" ? "保存季度生产计划明细成功" : "保存季度生产计划明细失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); if (hideAdjust.Value == "1") { opt.UpDateOra("update HT_PROD_SEASON_PLAN set ADJUST_STATUS = '1',MODIFY_ID = '" + ((MSYS.Data.SysUser)Session["User"]).id + "' where ID = '" + hidePlanID.Value + "'"); } } bindGrid2(hidePlanID.Value); bindGrid1(); } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "F_CODE", "F_NAME", "F_PARENTID", "F_PRITYPE", "F_WEIGHT", "F_KEY", "F_ROLE" }; string[] value = { txtCode.Text, txtName.Text, listParent.SelectedValue, txtType.Text, txtWeight.Text, txtSapID.Text, listRole.SelectedValue }; string log_message = opt.MergeInto(seg, value, 1, "HT_SVR_ORG_GROUP") == "Success" ? "保存部门信息成功" : "保存部门信息失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindData(); ScriptManager.RegisterStartupScript(updtpanel1, this.Page.GetType(), "", " $('.shade').fadeOut(200);", true); }
protected void btnSaveS_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "SHIFT_CODE", "SHIFT_NAME", "WORKSHOP_ID", "BEGIN_TIME", "END_TIME", "CREATE_TIME", "INTER_DAY", "IS_DEL" }; string[] value = { txtCodeS.Text, txtNameS.Text, listLineS.SelectedValue, txtStarttime.Text, txtEndtime.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), Convert.ToInt16(ckInter.Checked).ToString(), "0" }; string log_message = opt.MergeInto(seg, value, 1, "ht_sys_shift") == "Success" ? "班时配置保存成功" : "班时配置保存失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindGrid2(); }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (hdType.Value == "1") { string[] seg = { "RECORD_ID", "SORT", "STATUS", "REASON", "SCENE", "DEAL", "REMARK" }; string[] value = { txtEventID.Text, listStyle.SelectedValue, "3", txtReason.Text, txtScean.Text, txtDeal.Text, txtPlus.Text }; string log_message = opt.MergeInto(seg, value, 2, "HT_QLT_AUTO_EVENT") == "Success" ? "处理工艺质量事件成功" : "处理工艺质量事件失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindgrid1(); } else { string[] seg = { "RECORD_ID", "INSPECT_CODE", "STATUS", "REASON", "SCENE", "DEAL", "REMARK" }; string[] value = { txtEventID.Text, listStyle.SelectedValue, "3", txtReason.Text, txtScean.Text, txtDeal.Text, txtPlus.Text }; string log_message = opt.MergeInto(seg, value, 1, "HT_QLT_INSPECT_EVENT") == "Success" ? "处理工艺质量事件成功" : "处理工艺质量事件失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindgrid2(); } ScriptManager.RegisterStartupScript(updtpanel1, this.Page.GetType(), "", " $('.shade').fadeOut(200);", true); }