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);
}
