protected void btnadd_Click(object sender, EventArgs e) { try { bool res = true; var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; var list = new List <Mod_TMB_NCADDRESS_COST>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect"); Literal ltlADDRCODE = (Literal)rptList.Items[i].FindControl("ltlADDRCODE"); Literal ltlADDRNAME = (Literal)rptList.Items[i].FindControl("ltlADDRNAME"); Literal ltlPK_AREACL = (Literal)rptList.Items[i].FindControl("ltlPK_AREACL"); if (cbxselect.Checked) { var mod = new Mod_TMB_NCADDRESS_COST() { C_FAYUN = dropfyfs.SelectedItem.Text, N_PRICE = Convert.ToDecimal(txtprice.Text == "" ? "0" : txtprice.Text), D_START_DT = Convert.ToDateTime(txtStart.Value), D_END_DT = Convert.ToDateTime(txtEnd.Value), C_ADDRNAME = ltlADDRNAME.Text, C_ADDRCODE = ltlADDRCODE.Text, C_ADDR_NCPK = cbxselect.Value, C_AREA_PK = ltlPK_AREACL.Text, C_CREATE_EMP = vUser?.Name, C_EMP = vUser?.Name, D_EMP = DateTime.Now }; if (!tmb_ncaddress_cost.Exists(mod.C_FAYUN, mod.C_ADDRNAME)) { list.Add(mod); } else { res = false; string msg = mod.C_ADDRNAME + ",该地点已存在"; WebMsg.MessageBox(msg); break; } } } if (res) { if (list.Count > 0) { tmb_ncaddress_cost.Add(list); Response.Write("<script>window.parent.document.getElementById('imgbtnJz').click();window.parent.close();</script>"); } } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
protected void btndel_Click(object sender, EventArgs e) { try { var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; var list = new List <Mod_TMB_NCADDRESS_COST>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect"); if (cbxselect.Checked) { var mod = new Mod_TMB_NCADDRESS_COST() { C_ID = cbxselect.Value, C_EMP = vUser?.Name }; list.Add(mod); } } if (tmb_ncaddress_cost.Del(list)) { BindList(); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
private void SetCheckedChildNodes(TreeNode node) { try { var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; var list = new List <Mod_TMB_NCADDRESS_COST>(); for (int i = 0; i < node.ChildNodes.Count; i++) { string id = node.ChildNodes[i].Value; if (node.ChildNodes[i].Checked) { DataTable dt = tmb_ncaddress_cost.GetList(id).Tables[0]; if (dt.Rows.Count > 0) { var mod = new Mod_TMB_NCADDRESS_COST() { C_CHENGYUN = dropcys.SelectedItem.Text, C_FAYUN = dropfyfs.SelectedItem.Text, N_PRICE = Convert.ToDecimal(txtprice.Text == "" ? "0" : txtprice.Text), D_START_DT = Convert.ToDateTime(txtStart.Value), D_END_DT = Convert.ToDateTime(txtEnd.Value), C_ADDRNAME = dt.Rows[0]["ADDRNAME"].ToString(), C_ADDRCODE = dt.Rows[0]["ADDRCODE"].ToString(), C_ADDR_NCPK = dt.Rows[0]["PK_ADDRESS"].ToString(), C_AREA_PK = id, C_CREATE_EMP = vUser?.Name }; if (!tmb_ncaddress_cost.Exists(mod.C_FAYUN, mod.C_ADDRNAME)) { list.Add(mod); } } } SetCheckedChildNodes(node.ChildNodes[i]); } if (list.Count > 0) { tmb_ncaddress_cost.Add(list); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
protected void btnsave_Click(object sender, EventArgs e) { try { var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; var list = new List <Mod_TMB_NCADDRESS_COST>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect"); TextBox txtprice = (TextBox)rptList.Items[i].FindControl("txtprice"); HtmlInputText txtStart = (HtmlInputText)rptList.Items[i].FindControl("txtStart"); HtmlInputText txtEnd = (HtmlInputText)rptList.Items[i].FindControl("txtEnd"); Literal ltlC_FAYUN = (Literal)rptList.Items[i].FindControl("ltlC_FAYUN"); Literal ltlC_ADDRNAME = (Literal)rptList.Items[i].FindControl("ltlC_ADDRNAME"); if (cbxselect.Checked) { var mod = new Mod_TMB_NCADDRESS_COST() { C_ID = cbxselect.Value, C_FAYUN = ltlC_FAYUN.Text, C_ADDRNAME = ltlC_ADDRNAME.Text, N_PRICE = Convert.ToDecimal(txtprice.Text), D_START_DT = Convert.ToDateTime(txtStart.Value), D_END_DT = Convert.ToDateTime(txtEnd.Value), C_CREATE_EMP = vUser?.Name }; list.Add(mod); } } if (tmb_ncaddress_cost.UpdateList(list)) { WebMsg.MessageBox("保存成功"); BindList(); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
/// <summary> /// 修改 /// </summary> /// <param name="mod">修改参数:费用,生效日期,失效日期,修改人</param> /// <returns></returns> public bool Update(Mod_TMB_NCADDRESS_COST mod) { return(dal.Update(mod)); }
/// <summary> /// 修改 /// </summary> /// <param name="mod">修改参数:费用,生效日期,失效日期,修改人</param> /// <returns></returns> public bool Update(Mod_TMB_NCADDRESS_COST mod) { string strSql = $@"UPDATE TMB_NCADDRESS_COST SET N_PRICE={mod.N_PRICE},D_START_DT=TO_DATE('{mod.D_START_DT}','yyyy-mm-dd hh24:mi:ss'),D_END_DT=TO_DATE('{mod.D_END_DT}','yyyy-mm-dd hh24:mi:ss'),D_EMP=TO_DATE('{DateTime.Now.ToString()}','yyyy-mm-dd hh24:mi:ss'),C_EMP='{mod.C_CREATE_EMP}' WHERE C_ID='{mod.C_ID}'"; return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false); }