protected void btnFlag_Click(object sender, EventArgs e) { try { var list = new List <Mod_TMO_ORDER_PCZB>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxID = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxID"); Literal ltlC_FLAG = (Literal)rptList.Items[i].FindControl("ltlC_FLAG"); Literal ltlC_TYPE = (Literal)rptList.Items[i].FindControl("ltlC_TYPE"); Mod_TMO_ORDER_PCZB mod = new Mod_TMO_ORDER_PCZB(); if (cbxID.Checked) { mod.C_ID = cbxID.Value; mod.C_EMP_ID = ltlEmpName.Text; mod.D_EMP_DT = DateTime.Now; mod.C_TYPE2 = ltlC_TYPE.Text; mod.C_FLAG = ltlC_FLAG.Text == "N" ? "Y" : "N"; list.Add(mod); } } if (tmo_order_pczb.UpdateFlag(list)) { GetList(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('设置成功');</script>", false); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
//删除指标 protected void btndel_Click(object sender, EventArgs e) { try { var list = new List <Mod_TMO_ORDER_PCZB>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxID = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxID"); if (cbxID.Checked) { var mod = new Mod_TMO_ORDER_PCZB() { C_ID = cbxID.Value }; list.Add(mod); } } if (tmo_order_pczb.DelZB2(list)) { WebMsg.MessageBox("删除成功"); GetList(); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
//生成指标 protected void btnZB_Click(object sender, EventArgs e) { try { var list = new List <Mod_TMO_ORDER_PCZB>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxID = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxID"); Literal ltlC_AREA = (Literal)rptList.Items[i].FindControl("ltlC_AREA"); HtmlInputText txtN_MONTH_JK_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_MONTH_JK_ZB"); //月指标监控 HtmlInputText txtN_MONTH_JP_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_MONTH_JP_ZB"); //月指标精品 HtmlInputText txtN_MONTH_PZ_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_MONTH_PZ_ZB"); //月指标品种 HtmlInputText txtN_MONTH_PT_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_MONTH_PT_ZB"); //月指标普碳钢 Literal ltlC_TYPE = (Literal)rptList.Items[i].FindControl("ltlC_TYPE"); //N/Y INSERT/UPDATE Mod_TMO_ORDER_PCZB mod = new Mod_TMO_ORDER_PCZB(); mod.C_ID = cbxID.Value; mod.C_AREA = ltlC_AREA.Text; //区域 mod.N_MONTH_JK_ZB = Convert.ToDecimal(txtN_MONTH_JK_ZB.Value == "" ? "0" : txtN_MONTH_JK_ZB.Value); //月监控指标 mod.N_MONTH_JP_ZB = Convert.ToDecimal(txtN_MONTH_JP_ZB.Value == "" ? "0" : txtN_MONTH_JP_ZB.Value); //月精品指标 mod.N_MONTH_PZ_ZB = Convert.ToDecimal(txtN_MONTH_PZ_ZB.Value == "" ? "0" : txtN_MONTH_PZ_ZB.Value); //月品种指标 mod.N_MONTH_PT_ZB = Convert.ToDecimal(txtN_MONTH_PT_ZB.Value == "" ? "0" : txtN_MONTH_PT_ZB.Value); //月普碳指标 mod.D_PLAN_DT = Convert.ToDateTime(txtStart.Value + "-1"); //计划日期 mod.C_CREATE_ID = ltlEmpName.Text; //制单人 mod.C_TYPE2 = ltlC_TYPE.Text; //N/Y 添加/修改 list.Add(mod); } if (tmo_order_pczb.Insert_Update2(list)) { GetList(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('保存成功');</script>", false); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
//生成指标 protected void btnZB_Click(object sender, EventArgs e) { try { var list = new List <Mod_TMO_ORDER_PCZB>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxID = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxID"); Literal ltlC_AREA = (Literal)rptList.Items[i].FindControl("ltlC_AREA"); HtmlInputText txtN_MONTH_JK_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_MONTH_JK_ZB"); //月指标监控 HtmlInputText txtN_MONTH_JP_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_MONTH_JP_ZB"); //月指标精品 HtmlInputText txtN_MONTH_PZ_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_MONTH_PZ_ZB"); //月指标品种 HtmlInputText txtN_MONTH_PT_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_MONTH_PT_ZB"); //月指标普碳钢 HtmlInputText txtN_DAY_JK_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_DAY_JK_ZB"); //旬指标监控 HtmlInputText txtN_DAY_JP_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_DAY_JP_ZB"); //旬指标精品 HtmlInputText txtN_DAY_PZ_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_DAY_PZ_ZB"); //旬指标品种 HtmlInputText txtN_DAY_PT_ZB = (HtmlInputText)rptList.Items[i].FindControl("txtN_DAY_PT_ZB"); //旬指标普碳钢 Literal ltlC_TYPE = (Literal)rptList.Items[i].FindControl("ltlC_TYPE");//N/Y INSERT/UPDATE Mod_TMO_ORDER_PCZB mod = new Mod_TMO_ORDER_PCZB(); mod.C_ID = cbxID.Value; mod.C_AREA = ltlC_AREA.Text; //区域 mod.N_MONTH_JK_ZB = Convert.ToDecimal(txtN_MONTH_JK_ZB.Value == "" ? "0" : txtN_MONTH_JK_ZB.Value); //月监控指标 mod.N_MONTH_JP_ZB = Convert.ToDecimal(txtN_MONTH_JP_ZB.Value == "" ? "0" : txtN_MONTH_JP_ZB.Value); //月精品指标 mod.N_MONTH_PZ_ZB = Convert.ToDecimal(txtN_MONTH_PZ_ZB.Value == "" ? "0" : txtN_MONTH_PZ_ZB.Value); //月品种指标 mod.N_MONTH_PT_ZB = Convert.ToDecimal(txtN_MONTH_PT_ZB.Value == "" ? "0" : txtN_MONTH_PT_ZB.Value); //月普碳指标 if (ltlC_TYPE.Text == "N") { switch (dropZB.SelectedItem.Value) { case "0": //上旬指标 mod.N_DAY_JK_ZB = decimal.Round(Convert.ToDecimal(txtN_MONTH_JK_ZB.Value == "" ? "0" : txtN_MONTH_JK_ZB.Value) / 3, 0); //旬监控指标 mod.N_DAY_JP_ZB = decimal.Round(Convert.ToDecimal(txtN_MONTH_JP_ZB.Value == "" ? "0" : txtN_MONTH_JP_ZB.Value) / 3, 0); //旬精品指标 mod.N_DAY_PZ_ZB = decimal.Round(Convert.ToDecimal(txtN_MONTH_PZ_ZB.Value == "" ? "0" : txtN_MONTH_PZ_ZB.Value) / 3, 0); //旬品种指标 mod.N_DAY_PT_ZB = decimal.Round(Convert.ToDecimal(txtN_MONTH_PT_ZB.Value == "" ? "0" : txtN_MONTH_PT_ZB.Value) / 3, 0); //旬普碳指标 break; case "1": //中旬指标 DataTable dtZB = tmo_order_pczb.GetZB(txtEnd.Value, ltlC_AREA.Text).Tables[0]; if (dtZB.Rows.Count > 0) { mod.N_DAY_JK_ZB = decimal.Round(Convert.ToDecimal(dtZB.Rows[0]["JKZB"].ToString()) / 2, 0); //旬监控指标 mod.N_DAY_JP_ZB = decimal.Round(Convert.ToDecimal(dtZB.Rows[0]["JPZB"].ToString()) / 2, 0); //旬精品指标 mod.N_DAY_PZ_ZB = decimal.Round(Convert.ToDecimal(dtZB.Rows[0]["PZZB"].ToString()) / 2, 0); //旬品种指标 mod.N_DAY_PT_ZB = decimal.Round(Convert.ToDecimal(dtZB.Rows[0]["PTZB"].ToString()) / 2, 0); //旬普碳指标 } break; case "2": //下旬指标 DataTable dtZB2 = tmo_order_pczb.GetZB(txtEnd.Value, ltlC_AREA.Text).Tables[0]; if (dtZB2.Rows.Count > 0) { mod.N_DAY_JK_ZB = Convert.ToDecimal(dtZB2.Rows[0]["JKZB"].ToString()); //旬监控指标 mod.N_DAY_JP_ZB = Convert.ToDecimal(dtZB2.Rows[0]["JPZB"].ToString()); //旬精品指标 mod.N_DAY_PZ_ZB = Convert.ToDecimal(dtZB2.Rows[0]["PZZB"].ToString()); //旬品种指标 mod.N_DAY_PT_ZB = Convert.ToDecimal(dtZB2.Rows[0]["PTZB"].ToString()); //旬普碳指标 } break; } } else { mod.N_DAY_JK_ZB = Convert.ToDecimal(txtN_DAY_JK_ZB.Value); //旬监控指标 mod.N_DAY_JP_ZB = Convert.ToDecimal(txtN_DAY_JP_ZB.Value); //旬精品指标 mod.N_DAY_PZ_ZB = Convert.ToDecimal(txtN_DAY_PZ_ZB.Value); //旬品种指标 mod.N_DAY_PT_ZB = Convert.ToDecimal(txtN_DAY_PT_ZB.Value); //旬普碳指标 } mod.D_PLAN_DT = Convert.ToDateTime(txtEnd.Value); //计划日期 mod.N_TYPE = Convert.ToDecimal(dropZB.SelectedItem.Value); //1上旬 ,2中旬,3下旬 mod.C_CREATE_ID = ltlEmpName.Text; //制单人 mod.C_EMP_ID = ltlEmpName.Text; //最后修改人 mod.D_EMP_DT = DateTime.Now; //最后修改实际 mod.N_PC_JK = Convert.ToDecimal(txtjkzb.Text == "" ? "0" : txtjkzb.Text); //监控下发范围 mod.N_PC_JP = Convert.ToDecimal(txtjp.Text == "" ? "0" : txtjp.Text); //精品下发范围 mod.N_PC_PZ = Convert.ToDecimal(txtpz.Text == "" ? "0" : txtpz.Text); //品种下发范围 mod.N_PC_PT = Convert.ToDecimal(txtpt.Text == "" ? "0" : txtpt.Text); //普碳下发范围 mod.N_SORT = i; mod.C_TYPE2 = ltlC_TYPE.Text; //N/Y 添加/修改 list.Add(mod); } if (tmo_order_pczb.Insert_Update(list)) { GetList(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('保存成功');</script>", false); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }