//根据SQL语句查找所有信息 public static List <CustomerPianTB> GetAllCustomerPianTBBySql(string strsql) { List <CustomerPianTB> allinfo = new List <CustomerPianTB>(); DataTable dt = DBHelper.GetTable(strsql); foreach (DataRow row in dt.Rows) { CustomersService cus = new CustomersService(); CustomerPianTB t = new CustomerPianTB(); t.CPid = Convert.ToInt32(row["cpid"]); t.CusID = Convert.ToInt32(row["cusid"]); t.DateMon = Convert.ToDateTime(row["datemon"]); t.OddMon = Convert.ToDouble(row["oddmon"]); t.SendMon = Convert.ToDouble(row["sendmon"]); t.GiveMon = Convert.ToDouble(row["givemon"]); t.BackMon = Convert.ToDouble(row["backmon"]); t.AccMon = Convert.ToDouble(row["accmon"]); t.OtherMon = Convert.ToDouble(row["othermon"]); t.AllMon = Convert.ToDouble(row["allmon"]); t.ISsettle = row["issettle"].ToString(); if (t.ISsettle == "True") { t.ISsettle = "已付"; } else { t.ISsettle = "未付"; } t.Remark = row["remark"].ToString(); t.customer = cus.GetCusmoerByid(Convert.ToInt32(row["cusid"])); allinfo.Add(t); } return(allinfo); }
//插入信息 public int AddCustomerPianTBInfo(CustomerPianTB cp) { int count; string sql = "insert into CustomerPianTB(CusID,DateMon,OddMon,SendMon,GiveMon,BackMon,AccMon,OtherMon,AllMon,ISsettle,Remark) values(@CusID,@DateMon,@OddMon,@SendMon,@GiveMon,@BackMon,@AccMon,@OtherMon,@AllMon,@ISsettle,@Remark)"; try { SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@CusID", cp.CusID), new SqlParameter("@DateMon", cp.DateMon), new SqlParameter("@OddMon", cp.OddMon), new SqlParameter("@SendMon", cp.SendMon), new SqlParameter("@GiveMon", cp.GiveMon), new SqlParameter("@BackMon", cp.BackMon), new SqlParameter("@AccMon", cp.AccMon), new SqlParameter("@OtherMon", cp.OtherMon), new SqlParameter("@AllMon", cp.AllMon), new SqlParameter("@ISsettle", cp.ISsettle), new SqlParameter("@Remark", cp.Remark) }; DBHelper.ExecuteCommand(sql, paras); return(count = 1); } catch (Exception e) { return(count = 0); Console.Write(e.Message); throw e; } }
//更新结算信息 public int UpdateCustomerPianTBById(CustomerPianTB cp) { string sql = "update CustomerPianTB set CusID=@CusID,DateMon=@DateMon,OddMon=@OddMon,SendMon=@SendMon,GiveMon=@GiveMon,BackMon=@BackMon,AccMon=@AccMon,OtherMon=@OtherMon,AllMon=@AllMon,ISsettle=@ISsettle,Remark=@Remark where CPid=@CPid"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@CPid", cp.CPid), new SqlParameter("@CusID", cp.CusID), new SqlParameter("@DateMon", cp.DateMon), new SqlParameter("@OddMon", cp.OddMon), new SqlParameter("@SendMon", cp.SendMon), new SqlParameter("@GiveMon", cp.GiveMon), new SqlParameter("@BackMon", cp.BackMon), new SqlParameter("@AccMon", cp.AccMon), new SqlParameter("@OtherMon", cp.OtherMon), new SqlParameter("@AllMon", cp.AllMon), new SqlParameter("@ISsettle", cp.ISsettle), new SqlParameter("@Remark", cp.Remark) }; return(DBHelper.ExecuteCommand(sql, paras)); }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { CustomerPianTB cp = new CustomerPianTB(); cp.CPid = Convert.ToInt32(Label14.Text); cp.CusID = Convert.ToInt32(lbl1.Text); cp.OddMon = Convert.ToDouble(Label4.Text); cp.SendMon = Convert.ToDouble(Label8.Text); cp.GiveMon = Convert.ToDouble(Label9.Text); cp.BackMon = Convert.ToDouble(Label10.Text); cp.AccMon = Convert.ToDouble(Label11.Text); cp.OtherMon = Convert.ToDouble(Label12.Text); cp.AllMon = Convert.ToDouble(Label13.Text); cp.ISsettle = "true"; cp.DateMon = Convert.ToDateTime(Label7.Text); cp.Remark = "面单费已结!"; int count = customerpianmanager.UpdateCustomerPianTBById(cp); if (count > 0) { lblinfos.Text = "结算成功!"; List <CustomerPianTB> p = customerpianmanager.GetAllCustomerPianTBInfo(id); Label14.Text = p[0].CPid.ToString(); lbl1.Text = p[0].CusID.ToString(); Label4.Text = p[0].OddMon.ToString(); Label8.Text = p[0].SendMon.ToString(); Label9.Text = p[0].GiveMon.ToString(); Label10.Text = p[0].BackMon.ToString(); Label11.Text = p[0].AccMon.ToString(); Label12.Text = p[0].OtherMon.ToString(); Label13.Text = p[0].AllMon.ToString(); Label5.Text = p[0].ISsettle.ToString(); Label7.Text = p[0].DateMon.ToString(); Label6.Text = p[0].Remark.ToString(); } }
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 UpdateCustomerPianTBById(CustomerPianTB cp) { return(customerpianservice.UpdateCustomerPianTBById(cp)); }
public int AddCustomerPianTBInfo(CustomerPianTB cp) { return(customerpianservice.AddCustomerPianTBInfo(cp)); }