protected void btnSave_Click(object sender, EventArgs e) { if (txtCodeS.Text.Split('-').Length >= GridView1.Rows.Count) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <String> commandlist = new List <String>(); string[] seg = { "PATHNAME", "SECTION_CODE", "PATHCODE", "SECTION_PATH" }; for (int i = 0; i < GridView1.Rows.Count; i++) { DropDownList list = (DropDownList)GridView1.Rows[i].FindControl("listpath"); string section = GridView1.DataKeys[i].Value.ToString(); string[] value = { txtNameS.Text, section, txtCodeS.Text, list.SelectedValue }; commandlist.Add(opt.getMergeStr(seg, value, 2, "HT_PUB_PATH_PROD")); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "保存全线路径成功" : "保存全线路径失败"; log_message += "--标识:" + listPathAll.SelectedValue; InsertTlog(log_message); commandlist.Clear(); commandlist.Add("delete HT_PUB_PARA_WEIGHT where PATH_NAME = '" + txtNameS.Text + "' or path_code ='" + txtCodeS.Text + "'"); commandlist.Add("insert into ht_pub_para_weight ( select r.para_code,t.pathcode,'0',0.2,'" + txtNameS.Text + "' 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 = '" + txtCodeS.Text + "' and t.is_del = '0' and r.para_code is not null union select r.para_code,'" + txtCodeS.Text + "','0',0.2,'" + txtNameS.Text + "' from ht_pub_tech_para r where r.para_type like '______1%' and r.path_node is null and r.is_del = '0')"); opt.TransactionCommand(commandlist); opt.bindDropDownList(listPathAll, "select distinct pathname,pathcode from ht_pub_path_prod t where t.is_del = '0' order by pathname", "pathname", "pathcode"); listPathAll.SelectedValue = txtCodeS.Text; bindGrid(); } }
public string InsertLocalFromMaster() { MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); productEntity[] prods = service.getAllProductList(new productEntity()); string[] matseg = { "ID", "PROD_CODE", "PROD_NAME", "PACK_NAME", "HAND_MODE", "MATER_FORMULA_CODE", "AUX_FORMULA_CODE", "COAT_FORMULA_CODE", "REMARK", "CREATEOR_ID", "CREATE_TIME", "MODIFY_ID", "MODIFY_TIME", "STANDARD_VALUE", "XY_PROD_CODE", "IS_VALID", "IS_DEL", "B_FLOW_STATUS" }; int SucCount = 0; foreach (productEntity prod in prods) { // if (prod.prodCode.Substring(0, 3) == "703") // { commandlist.Clear(); if (prod.xyProdCode.Substring(0, 3) != "703") { continue; } string mformcode = ((prod.materFormulaCode == null) || prod.materFormulaCode.Length <= 3) ? "" : "7030" + (Convert.ToInt32(prod.materFormulaCode) + 20).ToString(); string aformcode = ((prod.auxFormulaCode == null) || prod.auxFormulaCode.Length <= 3) ? "" : "703" + prod.auxFormulaCode; string cformcode = ((prod.coatFormulaCode == null) || prod.coatFormulaCode.Length <= 3) ? "" : "7030" + (Convert.ToInt32(prod.coatFormulaCode) + 3).ToString(); string[] value = { prod.id.ToString(), prod.xyProdCode, prod.prodName, prod.packName, Convert.ToInt32(prod.handMode).ToString() , mformcode, aformcode, cformcode, prod.remark,prod.createorId, prod.createTime.ToString("yyyy-MM-dd HH:mm:ss"), prod.modifyId, prod.modifyTime.ToString("yyyy-MM-dd HH:mm:ss"), prod.standardValue, prod.prodCode, "1", prod.isDel, "2" }; string temp = opt.getMergeStr(matseg, value, 2, "HT_PUB_PROD_DESIGN"); commandlist.Add(temp); if (opt.UpDateOra(temp) != "Success") { System.Diagnostics.Debug.Write(temp); } //getTechstdd_SQL(prod.techStddId, prod.xyProdCode); // java.math.BigInteger cannot be cast to java.lang.String getMaterFormalu_SQL(prod.materFormulaId, prod.xyProdCode); getAuxFormalu_SQL(prod.auxFormulaId, prod.xyProdCode); //java.math.BigDecimal cannot be cast to java.lang.Double getCoatFormalu_SQL(prod.coatFormulaId, prod.xyProdCode); if (opt.TransactionCommand(commandlist) == "Success") { commandlist.Clear(); //commandlist.Add("update ht_pub_prod_design t set tech_stdd_code = (select r.tech_code from ht_tech_stdd_code r where substr(t.tech_stdd_code,0,3)<>'TCH' and r.id = to_number( t.tech_stdd_code)),mater_formula_code = (select s.formula_code from ht_qa_mater_formula s where t.mater_formula_code is not null and s.id = to_number( t.mater_formula_code)),aux_formula_code = (select q.formula_code from ht_qa_aux_formula q where t.aux_formula_code is not null and q.id = to_number( t.aux_formula_code)),coat_formula_code = (select p.formula_code from ht_qa_coat_formula p where t.coat_formula_code is not null and p.id = to_number( t.coat_formula_code)) where t.prod_code = '" + prod.prodCode + "'"); commandlist.Add("update ht_qa_mater_formula_detail r set formula_code = (select t.formula_code from ht_qa_mater_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.materFormulaId + "'"); commandlist.Add("update ht_qa_aux_formula_detail r set formula_code = (select t.formula_code from ht_qa_aux_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.auxFormulaId + "'"); commandlist.Add("update ht_qa_coat_formula_detail r set formula_code = (select t.formula_code from ht_qa_coat_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.coatFormulaId + "'"); commandlist.Add("update ht_qa_Fla_formula_detail r set formula_code = (select t.formula_code from ht_qa_Fla_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.coatFormulaId + "'"); //commandlist.Add("update ht_tech_stdd_code_detail r set tech_code = (select t.tech_code from ht_tech_stdd_code t where t.id = r.tech_code) where r.tech_code = '" + prod.techStddId + "'"); //commandlist.Add("update ht_qa_mater_formula_detail t set t.mater_flag = (select r.mat_type from ht_pub_materiel r where r.material_code = t.mater_code)"); opt.TransactionCommand(commandlist); System.Diagnostics.Debug.Write("产品更新成功" + prod.prodCode + prod.prodName); SucCount++; } // } } return(SucCount.ToString() + "项产品更新成功,总记录条数:" + prods.Length); }
protected void btnDelSel_Click(object sender, EventArgs e) { try { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string planlist = ""; for (int i = 0; i <= GridView2.Rows.Count - 1; i++) { if (((CheckBox)GridView2.Rows[i].FindControl("chk")).Checked) { string mtr_code = ((TextBox)GridView2.Rows[i].FindControl("txtPlanNo")).Text; commandlist.Add("update HT_PROD_MONTH_PLAN_DETAIL set IS_DEL = '1' where PLAN_NO = '" + mtr_code + "'"); planlist += mtr_code + ","; } } if (commandlist.Count > 0) { if (hideAdjust.Value == "1") { commandlist.Add("update HT_PROD_MONTH_PLAN set ADJUST_STATUS = '1',MODIFY_ID = '" + ((MSYS.Data.SysUser)Session["User"]).id + "' where ID = '" + hidePlanID.Value + "'"); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除生产计划明细成功" : "删除生产计划明细失败"; log_message += "--标识:" + planlist; InsertTlog(log_message); bindGrid2(hidePlanID.Value); bindGrid1(); } } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnGridDel_Click(object sender, EventArgs e)//删除选中记录 { try { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); for (int i = 0; i <= GridView1.Rows.Count - 1; i++) { if (((CheckBox)GridView1.Rows[i].FindControl("chk")).Checked) { commandlist.Clear(); string order_sn = GridView1.DataKeys[i].Value.ToString(); commandlist.Add("update HT_EQ_RP_PLAN set IS_DEL = '1' where PZ_CODE = '" + order_sn + "'"); commandlist.Add("update HT_EQ_RP_PLAN_detail set IS_DEL = '1' where MAIN_ID = '" + order_sn + "'"); commandlist.Add("delete from HT_PUB_APRV_FLOWINFO where BUSIN_ID = '" + order_sn + "'"); string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除维修计划成功" : "删除维修计划失败"; log_message += "--标识:" + order_sn; InsertTlog(log_message); } } bindGrid1(); } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnGrid2Save_Click(object sender, EventArgs e) { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); foreach (GridViewRow row in GridView2.Rows) { string[] seg = { "INSPECT_CODE", "STDD_CODE", "UPPER_VALUE", "LOWER_VALUE", "MINUS_SCORE", "REMARK", "CREATE_ID", "CREATE_TIME" }; string[] value = { ((DropDownList)row.FindControl("listInspect")).SelectedValue, listVersion.SelectedValue, ((TextBox)row.FindControl("txtUpper")).Text, ((TextBox)row.FindControl("txtLower")).Text, ((TextBox)row.FindControl("txtScore")).Text, ((TextBox)row.FindControl("txtRemark")).Text, ((MSYS.Data.SysUser)Session["User"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; commandlist.Add(opt.getMergeStr(seg, value, 2, "HT_QLT_INSPECT_STDD_SUB")); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "保存过程检测标准成功" : "保存过程检测标准失败"; //if (log_message == "保存过程检测标准成功") //{ // string[] procseg = { }; // object[] procvalues = { }; // opt.ExecProcedures("Create_process_Report", procseg, procvalues); //} InsertTlog(log_message); bindGrid2(); ScriptManager.RegisterStartupScript(UpdatePanel5, this.Page.GetType(), "success", "alert('" + log_message + "')", true); }
protected void btnGrid2Apply_Click(object sender, EventArgs e) { try { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); Button btn = (Button)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; int Rowindex = row.RowIndex;//获得行号 string planno = GridView2.DataKeys[Rowindex].Value.ToString(); List <string> commandlist = new List <string>(); // commandlist.Add("update HT_PROD_MONTH_PLAN_DETAIL set EXE_STATUS = '4',MATER_STATUS = '1' where PLAN_NO = '" + planno + "' and EXE_STATUS = '2'"); commandlist.Add("update HT_PROD_MONTH_PLAN_DETAIL set MATER_STATUS = '1',COAT_STATUS = '1',Flavor_status = '1' where PLAN_NO = '" + planno + "' and EXE_STATUS <> '3'"); string log_message = opt.TransactionCommand(commandlist) == "Success" ? "申请物料成功" : "申请物料失败"; log_message += "--详情:" + planno; InsertTlog(log_message); bindGrid2(hidePlanID.Value); } catch (Exception ee) { Response.Write(ee.Message); } }
}//绑定GridView2数据源 protected void btnGrid2Save_Click(object sender, EventArgs e)// { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); foreach (GridViewRow row in GridView2.Rows) { int rowIndex = row.RowIndex; string id = GridView2.DataKeys[rowIndex].Value.ToString(); string status = ((DropDownList)row.FindControl("listGrid2Status")).SelectedValue; if ((status == "1" || status == "2") && ((TextBox)row.FindControl("txtGridNewvalue")).Text != "") { 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" }; commandlist.Add(opt.getMergeStr(seg, value, 1, "HT_EQ_MCLBR_PLAN_detail")); } } if (commandlist.Count > 0) { string log_message = opt.TransactionCommand(commandlist) == "Success" ? "人工校准录入成功" : "人工校准录入失败"; InsertTlog(log_message); bindGrid2(txtCode.Value); 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(); } } }
protected void btnGrid2Del_Click(object sender, EventArgs e) { try { Button btn = (Button)sender; int Rowindex = ((GridViewRow)btn.NamingContainer).RowIndex;//获得行号 string mtr_code = ((TextBox)GridView2.Rows[Rowindex].FindControl("txtPlanNo")).Text; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); commandlist.Add("update HT_PROD_MONTH_PLAN_DETAIL set IS_DEL = '1' where PLAN_NO = '" + mtr_code + "'"); if (hideAdjust.Value == "1") { commandlist.Add("update HT_PROD_MONTH_PLAN set ADJUST_STATUS = '1',MODIFY_ID = '" + ((MSYS.Data.SysUser)Session["User"]).id + "' where ID = '" + hidePlanID.Value + "'"); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除月度生产计划明细成功" : "删除月度生产计划明细失败"; log_message += "--标识:" + mtr_code; InsertTlog(log_message); bindGrid2(hidePlanID.Value); bindGrid1(); } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnGrid2Save_Click(object sender, EventArgs e)// { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); foreach (GridViewRow row in GridView2.Rows) { int rowIndex = row.RowIndex; string id = GridView2.DataKeys[rowIndex].Value.ToString(); string status = ((DropDownList)row.FindControl("listGrid2Status")).SelectedValue; if ((status == "1" || status == "2") && ((TextBox)row.FindControl("txtGridpos")).Text != "") { string[] seg = { "section", "equipment_id", "position", "pointnum", "luboil", "periodic", "style", "amount", "CREATE_TIME", "MAIN_ID", "STATUS" }; string[] value = { ((DropDownList)row.FindControl("listGridsct")).SelectedValue, ((DropDownList)row.FindControl("listGridEq")).SelectedValue, ((TextBox)row.FindControl("txtGridpos")).Text, ((TextBox)row.FindControl("txtGridnum")).Text, ((TextBox)row.FindControl("txtGridoil")).Text, ((TextBox)row.FindControl("txtGriPric")).Text, ((TextBox)row.FindControl("txtGridStyle")).Text, ((TextBox)row.FindControl("txtGridamount")).Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), hdcode.Value, "2" }; commandlist.Add(opt.UpdateStr(seg, value, "ht_eq_lb_plan_detail", " where ID = '" + id + "'")); } } if (commandlist.Count > 0) { string log_message = opt.TransactionCommand(commandlist) == "Success" ? "润滑记录录入成功" : "润滑记录录入失败"; InsertTlog(log_message); bindGrid2(txtCode.Value); 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_lb_plan_detail t left join ht_eq_lb_plan_detail t1 on t1.id = t.id and t1.status >= '2' and t1.is_del = '0' where t.main_id = '" + hdcode.Value + "' and t.is_del = '0')", "status"); if (alter == "1") { opt.UpDateOra("update ht_eq_lb_plan set TASK_STATUS = '2' where PZ_CODE = '" + hdcode.Value + "' and TASK_STATUS = '1'"); bindGrid1(); } } }
protected void btnDel1_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); commandlist.Add("update HT_PUB_TECH_SECTION set IS_DEL = '1' where SECTION_CODE = '" + txtCode_1.Text + "'"); //commandlist.Add("update ht_pub_inspect_process set IS_DEL = '1' where substr(PROCESS_CODE,1,5) = '" + txtCode.Text + "'"); commandlist.Add("update HT_PUB_TECH_PARA set IS_DEL = '1' where substr(PARA_CODE,1,5) = '" + txtCode_1.Text + "'"); string log_message; if (opt.TransactionCommand(commandlist) == "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 += ",工艺段ID:" + txtCode_1.Text; InsertTlog(log_message); }
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 == "" || (listStrgOut.SelectedValue == "" && txtStrgOut.Text == "") || listPrdct.SelectedValue == "" || DropDownListShift.SelectedValue == "" || DropDownListTeam.SelectedValue == "") { ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "alert", "alert('请输入必要信息!!')", true); return; } //生成领用主表记录 string relationcode = (listStrgOut.SelectedValue == "") ? txtStrgOut.Text:listStrgOut.SelectedValue; string[] seg = { "ORDER_SN", "OUT_DATE", "EXPIRED_DATE", "MODIFY_TIME", "WARE_HOUSE_ID", "DEPT_ID", "CREATOR_ID", "MONTHPLANNO", "RELATION_CODE", "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, txtPlanno.Text, relationcode, "1", 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 strgcoat_id_seq.nextval, r.mater_code,r.storage,r.original_demand,r.real_demand,r.remark,r.unit_code,'0',r.mater_flag,'" + txtCode.Text + "','','','',r.CLS_CODE,'','' from HT_STRG_COAT_SUB r where r.main_code = '" + relationcode + "'"); log_message = opt.TransactionCommand(commandlist) == "Success" ? "生成原料领用主表记录成功" : "生成原料领用主表记录失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindGrid1(); bindGrid2(); }
protected void btnDone_Click(object sender, EventArgs e)// { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); if (opt.GetSegValue("select flow_status from ht_eq_mclbr_plan where pz_code = '" + txtCode.Text + "'", "flow_status") != "2") { ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "$('#dspcthor').hide();alert('请在正确状态下确认完成');", true); return; } List <string> commandlist = new List <string>(); for (int i = 0; i <= GridView2.Rows.Count - 1; i++) { if (((CheckBox)GridView2.Rows[i].FindControl("chk")).Checked) { string ID = GridView2.DataKeys[i].Value.ToString(); commandlist.Add("update HT_EQ_MCLBR_PLAN_detail set STATUS = '5' where ID = '" + ID + "' and status = '4'"); } } if (commandlist.Count > 0) { string log_message = opt.TransactionCommand(commandlist) == "Success" ? "确认校准反馈成功" : "确认校准反馈失败"; 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 = '5' and t1.is_del = '0' where t.main_id = '" + txtCode.Text + "' and t.is_del = '0')", "status"); if (alter == "1") { opt.UpDateOra("update HT_EQ_MCLBR_PLAN set TASK_STATUS = '5' where PZ_CODE = '" + txtCode.Text + "' and TASK_STATUS = '4'"); bindGrid1(); } bindGrid2(txtCode.Text); } }
protected void btnDelSel_Click(object sender, EventArgs e) { try { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); for (int i = 0; i < GridView2.Rows.Count; i++) { if (((CheckBox)GridView2.Rows[i].FindControl("ck_sel")).Checked) { string mtr_code = GridView2.DataKeys[i].Value.ToString(); mtr_code = (mtr_code == "") ? " is null" :"='" + mtr_code + "'"; string prod_code = ((DropDownList)GridView2.Rows[i].FindControl("list_prod")).SelectedValue; commandlist.Add("delete from HT_QLT_SENSOR_RECORD_SUB where main_id = '" + hideID.Value + "' and PROD_CODE = '" + prod_code + "' and record_time " + mtr_code); } } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除感观评测原始记录详情成功" : "删除感观评测原始记录详情失败"; InsertTlog(log_message); bindGrid2(hideID.Value); } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnGridopt_Click(object sender, EventArgs e)//出库,调用接口,变更库存情况 { Button btn = (Button)sender; int index = ((GridViewRow)btn.NamingContainer).RowIndex;//获得行号 string id = GridView1.DataKeys[index].Values[0].ToString(); string aprv = ((Label)GridView1.Rows[index].FindControl("labAudit")).Text; string planno = GridView1.DataKeys[index].Values[1].ToString(); if (aprv == "己通过") { List <string> commandlist = new List <string>(); commandlist.Add("update HT_STRG_FLAVOR set ISSUE_STATUS = '1',ISSUER_ID ='" + ((MSYS.Data.SysUser)Session["User"]).id + "' where ORDER_SN = '" + id + "'"); commandlist.Add("update HT_PROD_MONTH_PLAN_DETAIL set FLAVOR_STATUS = '2' where PLAN_NO = '" + planno + "' and FLAVOR_STATUS = '1'"); MSYS.Web.StorageOpt st = new MSYS.Web.StorageOpt(); ////调用接口,变更库存//// string flag = st.XiangInOrOut(id, ((MSYS.Data.SysUser)Session["User"]).text, ((MSYS.Data.SysUser)Session["User"]).id); ///// if (flag.Length > 9 && flag.Substring(0, 9) == "notenough") { ScriptManager.RegisterStartupScript(GridView1, this.GetType(), "scriptKey", "alert(‘物料不足" + flag.Substring(9) + "’)", true); } MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string log_message = opt.TransactionCommand(commandlist) == "Success" ? "出入库成功" : "出入库失败"; log_message += "--标识:" + id; InsertTlog(log_message); bindGrid1(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('请通过审批后再出库');", true); } }
protected void btnCopy_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string query = "select * from HT_QLT_INSPECT_STDD_SUB where STDD_CODE = '" + listtech.SelectedValue + "' and is_del = '0'"; DataSet data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { List <string> commandlist = new List <string>(); foreach (DataRow row in data.Tables[0].Rows) { string[] seg = { "STDD_CODE", "INSPECT_CODE", "MINUS_SCORE", "UPPER_VALUE", "LOWER_VALUE", "REMARK", "CREATE_ID", "CREATE_TIME" }; string[] value = { listtechC.SelectedValue, row["INSPECT_CODE"].ToString(), row["MINUS_SCORE"].ToString(), row["UPPER_VALUE"].ToString(), row["LOWER_VALUE"].ToString(), row["REMARK"].ToString(), ((SysUser)Session["User"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; commandlist.Add(opt.getMergeStr(seg, value, 2, "HT_QLT_INSPECT_STDD_SUB")); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "复制标准成功" : "复制标准失败"; log_message += ",复制标准:" + listtechC.SelectedValue; InsertTlog(log_message); } initView(); bindGrid1(); bindGrid2(); }
protected void btnGridDel_Click(object sender, EventArgs e)//删除计划 { try { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); for (int i = 0; i <= GridView2.Rows.Count - 1; i++) { if (((CheckBox)GridView2.Rows[i].FindControl("chk")).Checked) { string id = GridView2.DataKeys[i].Value.ToString(); commandlist.Add("delete from ht_prod_schedule where ID = '" + id + "'"); } } if (commandlist.Count > 0) { string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除排班成功" : "删除排班失败"; InsertTlog(log_message); bindGrid2(); } } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnAdd_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string Btime = opt.GetSegValue("select begin_time from ht_sys_shift t where shift_name = '早班'", "begin_time"); DateTime startdate = Convert.ToDateTime(txtStartDate.Text + " " + Btime); DateTime enddate = Convert.ToDateTime(txtEndDate.Text + " " + Btime).AddDays(1); if (listPrdline.SelectedValue == "" || txtStartDate.Text == "" || txtEndDate.Text == "" || startdate - enddate > new TimeSpan(0) || enddate - System.DateTime.Now < new TimeSpan(0)) { ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "alert", "alert('请选择正确的排班车间与时间段!!')", true); return; } DateTime tempdate = GetMondayDate(startdate).AddDays(7); if (GridView1.Rows.Count > 0) { List <string> commandlist = new List <string>(); List <TeamSchedula> schedules = getTeamSchedule(); int h = 0; if (startdate - System.DateTime.Now < new TimeSpan(0)) { startdate = System.DateTime.Now; } while (startdate < enddate) { if (h == 3) { h = 0; } TeamSchedula schedule = schedules.ToArray()[h]; while (startdate < tempdate && startdate <= enddate) { for (int i = 0; i < GridView1.Rows.Count; i++) { string endtime = startdate.ToString("yyyy-MM-dd") + " " + ((TextBox)GridView1.Rows[i].FindControl("txtEndtime")).Text; if (((CheckBox)GridView1.Rows[i].FindControl("ckInter")).Checked) { endtime = startdate.AddDays(1).ToString("yyyy-MM-dd") + " " + ((TextBox)GridView1.Rows[i].FindControl("txtEndtime")).Text; } string[] seg = { "WORK_DATE", "WORK_SHOP_CODE", "SHIFT_CODE", "TEAM_CODE", "WORK_STAUS", "CREATE_TIME", "MODIFY_TIME", "DATE_BEGIN", "DATE_END", "is_del" }; string[] value = { startdate.ToString("yyyy-MM-dd"), listPrdline.SelectedValue, GridView1.DataKeys[i].Value.ToString(), schedule.team.ToArray()[i], "1", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), startdate.ToString("yyyy-MM-dd") + " " + ((TextBox)GridView1.Rows[i].FindControl("txtStarttime")).Text, endtime, "0" }; if (((CheckBox)GridView1.Rows[i].FindControl("ckInter")).Checked) { startdate = startdate.AddDays(1); } commandlist.Add(opt.getMergeStr(seg, value, 3, "HT_PROD_SCHEDULE")); } } h++; tempdate = tempdate.AddDays(7); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "排班成功" : "排班失败"; log_message += ",排班时间:" + txtStartDate.Text + "~" + txtEndDate.Text; InsertTlog(log_message); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "alert", "alert('" + log_message + "')", true); } bindGrid2(); }
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 btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); if (rd1.Checked) { if (listProd2.SelectedValue == "" || listPlanno.SelectedValue == "" || listTeam2.SelectedValue == "" || txtDate.Text == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "message", "alert('请录入完整的数据信息')", true); return; } else { MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; string[] seg = { "PLANNO", "PROD_CODE", "SECTION_CODE", "TEAM", "TIME", "PARA_CODE", "CREATOR", "VALUE" }; foreach (GridViewRow row in GridView2.Rows) { string paravalue = ((TextBox)row.FindControl("txtParavalue")).Text; string paracode = ((DropDownList)row.FindControl("listPara")).SelectedValue; if (((TextBox)row.FindControl("txtParavalue")).Text != "") { string[] value = { listPlanno.SelectedValue, listProd2.SelectedValue, paracode.Substring(0, 5), listTeam2.SelectedValue, txtDate.Text, paracode, user.text, paravalue }; commandlist.Add(opt.getMergeStr(seg, value, 6, "HT_PROD_REPORT_DETAIL")); } } } } else { if (listProd2.SelectedValue == "" || listPlanno.SelectedValue == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "message", "alert('请录入完整的数据信息')", true); return; } else { foreach (GridViewRow row in GridView2.Rows) { string paravalue = ((TextBox)row.FindControl("txtParavalue")).Text; string paracode = ((DropDownList)row.FindControl("listPara")).SelectedValue; string[] seg = { "SECTION_CODE", "PLANNO", GridView2.DataKeys[row.RowIndex].Value.ToString() }; string[] value = { paracode.Substring(0, 5), listPlanno.SelectedValue, paravalue }; commandlist.Add(opt.getMergeStr(seg, value, 2, "HT_PROD_REPORT")); } } } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "保存物料过程数据成功," : "保存物料过程数据失败,"; log_message += "--详情产品:" + listProd2.SelectedValue + "计划号:" + listPlanno.SelectedValue + "班组:" + listTeam.SelectedValue + "日期:" + txtDate.Text; InsertTlog(log_message); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", " $('.shade').fadeOut(100);", true); bindGrid(); bindGrid3(); }
protected void btnDelete_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <String> commandlist = new List <string>(); commandlist.Add("delete HT_TECH_STDD_CODE where TECH_CODE = '" + txtCode.Text + "'"); commandlist.Add("delete from ht_pub_aprv_flowinfo where BUSIN_ID = '" + txtCode.Text + "'"); string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除工艺标准成功" : "删除工艺标准失败"; log_message += "--标识:" + txtCode.Text; InsertTlog(log_message); initView(); }
protected void btnGrid2Modify_Click(object sender, EventArgs e) { try { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); foreach (GridViewRow row in GridView2.Rows) { int Rowindex = row.RowIndex;//获得行号 string mtr_code = ((TextBox)row.FindControl("txtPlanNo")).Text; string prod_code = ((DropDownList)row.FindControl("listProd")).SelectedValue; if (!Regex.IsMatch(hidePlanID.Value, @"^[+-]?/d*$")) { hidePlanID.Value = hidePlanID.Value.Substring(hidePlanID.Value.LastIndexOf(',') + 1); } string path_code = opt.GetSegValue("select path_code from ht_pub_prod_design where prod_code = '" + prod_code + "'", "path_code"); if (mtr_code == "" || mtr_code.Substring(8, 7) != prod_code) { if (mtr_code.Length >= 17 && mtr_code.Substring(8, 7) != prod_code) { opt.UpDateOra("delete from ht_prod_month_plan_detail where plan_no = '" + mtr_code + "'"); } 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"); mtr_code = "PD" + txtYear.Text + listMonth.SelectedValue + prod_code + planno.PadLeft(2, '0'); } List <string> commandlist = new List <string>(); string[] seg = { "plan_no", "MONTH_PLAN_ID", "plan_Sort", "prod_code", "plan_output", "path_code", "is_del" }; string[] value = { mtr_code, hidePlanID.Value, ((TextBox)row.FindControl("txtOrder")).Text, prod_code, ((TextBox)row.FindControl("txtOutput")).Text, path_code, "0" }; commandlist.Add(opt.getMergeStr(seg, value, 1, "HT_PROD_MONTH_PLAN_DETAIL")); if (hideAdjust.Value == "1") { commandlist.Add("update HT_PROD_MONTH_PLAN set ADJUST_STATUS = '1',MODIFY_ID = '" + ((MSYS.Data.SysUser)Session["User"]).id + "' where ID = '" + hidePlanID.Value + "'"); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "保存生产计划详情成功" : "生产计划详情失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); if (path_code != " ") { insertSectionPath(path_code, mtr_code); } } bindGrid2(hidePlanID.Value); bindGrid1(); } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnDel_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <String> commandlist = new List <string>(); commandlist.Add("delete from ht_pub_path_prod where pathcode = '" + listPathAll.SelectedValue + "'"); commandlist.Add("delete from ht_pub_aprv_flowinfo where BUSIN_ID = '" + listPathAll.SelectedValue + "'"); string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除全线路径成功" : "删除全线路径失败"; log_message += "--标识:" + listPathAll.SelectedValue; InsertTlog(log_message); initView(); bindGrid(); }
protected void btnDel_Click(object sender, EventArgs e) { List <string> commandlist = new List <string>(); commandlist.Add("update HT_PUB_PROD_DESIGN set IS_DEL = '1' where PROD_CODE = '" + txtCode.Text + "'"); commandlist.Add("delete from ht_pub_aprv_flowinfo where BUSIN_ID = '" + txtCode.Text + "'"); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除产品信息成功" : "删除产品信息失败"; log_message += ",产品编码:" + txtCode.Text; InsertTlog(log_message); bindGrid(); }
protected void btnGrid3Save_Click(object sender, EventArgs e) { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); foreach (GridViewRow row in GridView3.Rows) { string[] seg = { "para_code", "PATH_CODE", "WEIGHT" }; string[] value = { GridView3.DataKeys[row.RowIndex].Value.ToString(), listPathAll.SelectedValue, ((TextBox)row.FindControl("txtWeight")).Text }; commandlist.Add(opt.getMergeStr(seg, value, 2, "HT_PUB_PARA_WEIGHT")); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "更改工艺点权重成功" : "更改工艺点权重失败"; InsertTlog(log_message); ScriptManager.RegisterStartupScript(UpdatePanel3, this.Page.GetType(), "msg", "alert('" + log_message + "')", true); }
protected void btnGrid2Save_Click(object sender, EventArgs e) { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); foreach (GridViewRow row in GridView2.Rows) { string[] seg = { "ID", "Weight", "remark", "CREATE_ID", "CREATE_DATE", "is_adjust" }; string[] value = { GridView2.DataKeys[row.RowIndex].Value.ToString(), ((TextBox)row.FindControl("txtWeight")).Text, ((TextBox)row.FindControl("txtRemark")).Text, ((MSYS.Data.SysUser)Session["User"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "1" }; commandlist.Add(opt.getMergeStr(seg, value, 1, "HT_QLT_WEIGHT")); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "更改质量评估权重成功" : "更改质量评估权重失败"; InsertTlog(log_message); ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "msg", "alert('" + log_message + "')", true); }
protected void btnSumit_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); commandlist.Add("update HT_EQ_MT_PLAN_DETAIL set STATUS = '5',CONTENT = '故障己上报' where id = '" + txtCode.Text + "'"); string[] seg = { "EQUIPMENT_ID", "EXE_TIME", "RESPONER", "MECH_AREA", "IS_EMG", "REASON", "CONTENT", "STATUS" }; string[] value = { listEq.SelectedValue, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listOptor.SelectedValue, listArea.SelectedValue, Convert.ToInt16(ckFault.Checked).ToString(), txtResults.Text, txtRecord.Text, "-1" }; commandlist.Add(opt.InsertDatastr(seg, value, "HT_EQ_RP_PLAN_DETAIL")); string log_message = opt.TransactionCommand(commandlist) == "Success" ? "维保上报故障成功" : "维保上报故障失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindGrid(); }
protected void btnGrid1Save_Click(object sender, EventArgs e) { List <string> commandlist = new List <string>(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); foreach (GridViewRow row in GridView1.Rows) { string[] seg = { "section_code", "Weight", "remark" }; string[] value = { ((DropDownList)row.FindControl("listSection")).SelectedValue, ((TextBox)row.FindControl("txtWeight")).Text, ((TextBox)row.FindControl("txtRemark")).Text }; commandlist.Add(opt.getMergeStr(seg, value, 1, "HT_PUB_TECH_SECTION")); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "更改工艺段权重成功" : "更改工艺段权重失败"; InsertTlog(log_message); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "msg", "alert('" + log_message + "')", true); }
protected void btnGrid1Del_Click(object sender, EventArgs e) { Button btn = (Button)sender; int rowIndex = ((GridViewRow)btn.NamingContainer).RowIndex; string prod_code = GridView1.DataKeys[rowIndex].Value.ToString(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <String> commandlist = new List <string>(); commandlist.Add("update ht_pub_prod_design set is_del = '1' where PROD_CODE = '" + prod_code + "'"); commandlist.Add("delete from ht_pub_aprv_flowinfo where BUSIN_ID = '" + prod_code + "'"); string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除产品成功" : "删除产品失败"; log_message += "--标识:" + prod_code; InsertTlog(log_message); bindGrid(); }
protected void btnDelete_Click(object sender, EventArgs e) { Button btn = (Button)sender; int rowIndex = ((GridViewRow)btn.NamingContainer).RowIndex; string id = GridView1.DataKeys[rowIndex].Value.ToString(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); commandlist.Add("update ht_inner_map set is_del = '1' where MAPID = '" + id + "'"); commandlist.Add("update ht_svr_sys_menu set IS_DEL = '1' where F_MAPID = '" + id + "'"); string log_message = opt.TransactionCommand(commandlist) == "Success" ? "删除Map表映射成功" : "删除Map表映射失败"; log_message += "--标识:" + id; InsertTlog(log_message); bindData(); }
protected void btnCalbrt_Click(object sender, EventArgs e) { if (drpBatch.SelectedValue == "" || txtcalBtime.Text == "") { ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "message", "alert('请选择自动校准采样批次及采样时间!!')", true); return; } if (GridView2.Rows.Count > 0) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); string prod_code = drpBatch.SelectedValue.Substring(8, 7); foreach (GridViewRow row in GridView2.Rows) { int rowIndex = row.RowIndex; string id = GridView2.DataKeys[rowIndex].Value.ToString(); string status = ((DropDownList)row.FindControl("listGrid2Status")).SelectedValue; if (status == "1" || status == "2") { string para_code = ((DropDownList)row.FindControl("listGridPoint")).SelectedValue; string setval = opt.GetSegValue("select value from ht_tech_stdd_code_detail r left join ht_pub_prod_design q on q.tech_stdd_code = r.tech_code where r.para_code = '" + para_code + "' and q.prod_code = '" + prod_code + "'", "value"); setval = (setval == "NoRecord" ? "0" : setval); string resval = getResVal(txtcalBtime.Text, txtcalEtime.Text, para_code); string[] seg = { "ID", "OLDVALUE", "POINTVALUE", "SAMPLE_TIME", "remark", "STATUS" }; string[] value = { id, setval, resval, txtcalBtime.Text.Substring(0, 10), ((TextBox)row.FindControl("txtGridremark")).Text, "2" }; commandlist.Add(opt.getMergeStr(seg, value, 1, "HT_EQ_MCLBR_PLAN_detail")); } } if (commandlist.Count > 0) { string log_message = opt.TransactionCommand(commandlist) == "Success" ? "自动校准录入成功" : "自动校准录入失败"; InsertTlog(log_message); bindGrid2(txtCode.Value); 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(); } } } }