//私有方法 private List <CustomerSendTB> GetInfoBysql(string strsql) { DataTable ds = DBHelper.GetTable(strsql); List <CustomerSendTB> AllCS = new List <CustomerSendTB>(); foreach (DataRow r in ds.Rows) { CustomerSendTB CS = new CustomerSendTB(); CS.CEid = Convert.ToInt32(r["CEid"]); CS.CusID = r["CusID"].ToString(); CS.ECount = Convert.ToInt32(r["ECount"]); object iss = r["Issettle"]; int cnt = Convert.ToInt32(iss); string ise = ""; if (cnt == 1) { ise = "是"; } if (cnt == 0) { ise = "否"; } CS.Issettle = ise; CS.EAllPrice = Convert.ToDouble(r["EAllPrice"]); CS.EDate = Convert.ToDateTime(r["Edate"]); CS.Remark = r["Remark"].ToString(); CustomersService cust = new CustomersService(); CS.Ccustomer = cust.GetCusmoerByid(Convert.ToInt32(r["CusID"].ToString())); AllCS.Add(CS); } return(AllCS); }
//添加的方法 protected void TmgBtnExit_Click(object sender, ImageClickEventArgs e) { if (Page.IsValid) { CustomerSendTB CusS = new CustomerSendTB(); CusS.CusID = ddlCustomer.SelectedValue; CusS.ECount = Convert.ToInt32(txtcount.Text); int count = Convert.ToInt32(txtcount.Text); object obj = DelM.GetMoney(Convert.ToInt32(ddlCustomer.SelectedValue)); int mon = Convert.ToInt32(obj); double allprice = mon * count; CusS.EAllPrice = allprice; int iss = 0; if (rdoYes.Checked == true) { iss = 1; } else { iss = 0; } CusS.Issettle = iss.ToString(); CusS.EDate = Convert.ToDateTime(txtDate.Text); CusS.Remark = txtRemark.Text; if (Request.QueryString["CEid"] == null) { int cnt = Sudd.InsertCustomerSend(CusS); if (cnt > 0) { lblmessage.Visible = true; lblmessage.Text = "添加成功"; txtcount.Text = ""; txtmoney.Text = ""; txtDate.Text = ""; txtRemark.Text = ""; } } if (Request.QueryString["CEid"] != null) { int CEid = Convert.ToInt32(Request.QueryString["CEid"]); CusS.CEid = CEid; int cnn = Sudd.UpdateCustomerSend(CusS); if (cnn > 0) { lblmessage.Visible = true; lblmessage.Text = "修改成功"; } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Usermanager"] == null) { Response.Redirect("~/Login.aspx"); } else { if (!IsPostBack) { //窗体加载标签不显示 lblmessage.Visible = false; //填充DropDownlist控件客户 this.ddlCustomer.DataSource = CusMan.GetAllCustomers(); this.ddlCustomer.DataTextField = "CusName"; this.ddlCustomer.DataValueField = "CusID"; ddlCustomer.DataBind(); if (Request.QueryString["CEid"] == null) { txtcount.Text = ""; txtmoney.Text = ""; txtDate.Text = ""; txtRemark.Text = ""; } if (Request.QueryString["CEid"] != null) { int ceid = Convert.ToInt32(Request.QueryString["CEid"]); CustomerSendTB CusSs = Sudd.SelectCustomerSendByCEid(ceid); ddlCustomer.SelectedValue = CusSs.CusID; txtcount.Text = CusSs.ECount.ToString(); txtmoney.Text = CusSs.EAllPrice.ToString(); string isss = CusSs.Issettle; if (isss == "True") { rdoYes.Checked = true; } else { rdoNo.Checked = true; } txtDate.Text = CusSs.EDate.ToString(); txtRemark.Text = CusSs.Remark; } } } }
//白少杰 01-11 //添加新记录 public int InsertCustomerSend(CustomerSendTB CSend) { string sql = "insert into CustomerSendTB values(@CusID,@ECount,@EAllPrice,@Issettle,@Edate,@Remark)"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@CusID", CSend.CusID), new SqlParameter("@ECount", CSend.ECount), new SqlParameter("@Issettle", CSend.Issettle), new SqlParameter("@EAllPrice", CSend.EAllPrice), new SqlParameter("@Edate", CSend.EDate), new SqlParameter("@Remark", CSend.Remark) }; int cut = DBHelper.ExecuteCommand(sql, para); return(cut); }
//白少杰 01-11 //修改记录 public int UpdateCustomerSend(CustomerSendTB CSend) { string sql = "Update CustomerSendTB set CusID=@CusID,ECount=@ECount,Issettle=@Issettle,EAllPrice=@EAllPrice,Edate=@Edate,Remark=@Remark where CEid=@CEid"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@CEid", CSend.CEid), new SqlParameter("@CusID", CSend.CusID), new SqlParameter("@ECount", CSend.ECount), new SqlParameter("@Issettle", CSend.Issettle), new SqlParameter("@EAllPrice", CSend.EAllPrice), new SqlParameter("@Edate", CSend.EDate), new SqlParameter("@Remark", CSend.Remark) }; int cut = DBHelper.ExecuteCommand(sql, para); return(cut); }
//白少杰 01-11 //根据CEid查询所有 public CustomerSendTB SelectCustomerSendByCEid(int CEid) { string str = "Select * from CustomerSendTB where CEid=@CEid"; DataTable dt = DBHelper.GetTable(str, new SqlParameter("@CEid", CEid)); List <CustomerSendTB> AllCS = new List <CustomerSendTB>(); foreach (DataRow r in dt.Rows) { CustomerSendTB CS = new CustomerSendTB(); CS.CEid = Convert.ToInt32(r["CEid"]); CS.CusID = r["CusID"].ToString(); CS.ECount = Convert.ToInt32(r["ECount"]); object iss = r["Issettle"]; int cnt = Convert.ToInt32(iss); string ise = ""; if (cnt == 1) { ise = "是"; } if (cnt == 0) { ise = "否"; } CS.Issettle = ise; CS.EAllPrice = Convert.ToDouble(r["EAllPrice"]); CS.EDate = Convert.ToDateTime(r["Edate"]); CS.Remark = r["Remark"].ToString(); CustomersService cust = new CustomersService(); CS.Ccustomer = cust.GetCusmoerByid(Convert.ToInt32(r["CusID"].ToString())); AllCS.Add(CS); } return(AllCS[0]); }
protected void imgbtnsel_Click(object sender, ImageClickEventArgs e) { CustomerPianTB cp = new CustomerPianTB(); int cusid = Convert.ToInt32(ddlcus.SelectedValue); DateTime qtime = Convert.ToDateTime(txtstime.Text); DateTime ttime = Convert.ToDateTime(txtttime.Text); try { if (customerpianmanager.GetCustomerPianTBById(cusid, qtime, ttime) != null) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该用户信息已存在,请确认业务员及时间。')</script>"); return; } } catch (Exception ex) { try { CustomersTB cus = customersmanager.GetCusmoerByid(cusid); string name = cus.CusName; //获取客户名 DisNoteTB dis = disnotemanager.GetDisNoteTBById(cusid, qtime, ttime); double oddmon = dis.Sum; //获取面单费用 string issrt = dis.IsSet; //获取面单费用是否已结算 if (issrt == "是") { cp.Remark = "面单费已结!"; } else { cp.Remark = "面单费未结!"; } CustomerSentTB cs = customersentmanager.GetCustomerSentTBById(cusid, qtime, ttime); double sendmon = cs.Price;//获取发件费 CustomerSendTB cf = customersendmanager.GetCustomerSendTBById(cusid, qtime, ttime); double givemon = cf.EAllPrice;//获取送件费 SentTB st = sentmanager.GetSentTBById(cusid, qtime, ttime); double backmon = st.Price;//获取收到付件返利 AcceptTB at = acceptmanager.GetAcceptTBById(cusid, qtime, ttime); double accmon = at.Price;//获取派收到付件款 IAEManagerTB ia = iaemanagermanager.GetIAEManagerTBById(cusid, qtime, ttime); double othermon = ia.Price; //获取其他费用 double allmon = oddmon + sendmon + backmon - givemon - accmon + othermon; //总计 string ISsettle = "false"; cp.CusID = Convert.ToInt32(cusid); cp.DateMon = ttime; cp.OddMon = oddmon; cp.SendMon = sendmon; cp.GiveMon = givemon; cp.BackMon = backmon; cp.AccMon = accmon; cp.OtherMon = othermon; cp.AllMon = allmon; cp.ISsettle = ISsettle; int cou = customerpianmanager.AddCustomerPianTBInfo(cp); if (cou == 1) { allInfo = customerpianmanager.GetAllCustomerPianTBInfo(cusid); anpInfo.RecordCount = allInfo.Count(); BindData(); anpInfo.CurrentPageIndex = 1; } } catch (Exception) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('无该用户信息,请确认业务员及时间。')</script>"); return; } } }
//修改记录 public int UpdateCustomerSend(CustomerSendTB CSend) { return(cusdd.UpdateCustomerSend(CSend)); }
//添加新记录 public int InsertCustomerSend(CustomerSendTB CSend) { return(cusdd.InsertCustomerSend(CSend)); }