protected void btnSettlement_Click(object sender, EventArgs e) { //get no SeedDAL sdal = new SeedDAL(); string no = sdal.GetNoByTableName(SysConst.TableSettlement, SysConst.SuffixSettlement); string companyName = string.Empty; string contact = string.Empty; string address = string.Empty; string email = string.Empty; string qq = string.Empty; string phone1 = string.Empty; string phone2 = string.Empty; string other = string.Empty; OrderDAL soDAL = new OrderDAL(); var so = soDAL.GetOrderByNo(SourceNo); companyName = so.CustomerCompanyName; contact = so.CustomerContactName; address = so.CustomerAddress; email = so.CustomerEmail; qq = so.CustomerQQ; phone1 = so.CustomerPhone1; phone2 = so.CustomerPhone2; other = so.CustomerOthers; //new refine SettlementDAL dal = new SettlementDAL(); Settlement st = new Settlement() { St_No = no, Status = FirstStatusConsts.Settlement, SourceType = SourceType, SourceNo = SourceNo, CreatedDate = DateTime.Now, CustomerCompanyName = companyName, CustomerContactName = contact, CustomerAddress = address, CustomerEmail = email, CustomerQQ = qq, CustomerPhone1 = phone1, CustomerPhone2 = phone2, CustomerOthers = other }; dal.AddSettlement(st); dal.Save(); int stid = st.St_Id; string stno = st.St_No; string url = Page.ResolveUrl(string.Format("~/SettlementForm.aspx?stid={0}&stno={1}&sourcetype={2}&sourceno={3}", stid, stno, SysConst.SourceTypeOrder, SourceNo)); string script = string.Format("<script>window.open('{0}')</script>", url); Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "createsettle", script); BindControl(); SetFocus(btnSettlement); }
protected void btnSave_Click(object sender, EventArgs e) { SettlementDAL dal = new SettlementDAL(); var st = dal.GetSettlementByNo(StNo); if (!string.IsNullOrEmpty(txtDeliveryDate.Text)) { st.DeliveryDate = DateTime.Parse(txtDeliveryDate.Text); } //update st st.StMan = Utility.GetSelectedText(ddlSettlementMan); StringBuilder sb = new StringBuilder(); for (int i = 0; i < cblDeliveryList.Items.Count; i++) { if (cblDeliveryList.Items[i].Selected) { sb.Append(cblDeliveryList.Items[i].Text).Append("|"); } } st.DeliveryList = sb.ToString(); st.StLocation = txtSettleLocation.Text; st.CustomerCompanyName = customerInfoControl.CompanyName; st.CustomerContactName = customerInfoControl.ContactName; st.CustomerAddress = customerInfoControl.Address; st.CustomerEmail = customerInfoControl.Email; st.CustomerQQ = customerInfoControl.QQ; st.CustomerPhone1 = customerInfoControl.Phone1; st.CustomerPhone2 = customerInfoControl.Phone2; st.CustomerOthers = customerInfoControl.Other; //settlement if (!string.IsNullOrEmpty(txtTotalAmount.Text)) { st.TotalAmount = double.Parse(txtTotalAmount.Text); } if (!string.IsNullOrEmpty(txtReceivedFirst.Text)) { st.FirstAmount = double.Parse(txtReceivedFirst.Text); } if (!string.IsNullOrEmpty(txtReceived.Text)) { st.AmountReceived = double.Parse(txtReceived.Text); } st.ReceivableIntro = txtBalanceIntro.Text; AddFollowUp(followUpControl, st.Status, Utility.GetSelectedText(ddlSettlementStatus)); st.Status = Utility.GetSelectedText(ddlSettlementStatus); dal.Save(); //save new customer customerInfoControl.Save(); this.SetFocus(sender); }
protected void btnImport_Click(object sender, EventArgs e) { SettlementDAL dal = new SettlementDAL(); LineItemDAL lDal = new LineItemDAL(); var settlement = dal.GetSettlementById(StId); StringBuilder sb = new StringBuilder(256); List <LineItem> lineItems = new List <LineItem>(); foreach (ListItem item in cblDeliveryList.Items) { if (item.Selected) { sb.Append(item.Text).Append("|"); lineItems.AddRange(lDal.GetLineItemsBySource(int.Parse(item.Value), SysConst.SourceTypeDelivery)); } } settlement.DeliveryList = sb.ToString(); dal.Save(); var dbItems = lDal.GetLineItemsBySource(this.StId, SysConst.SourceTypeSettlement); foreach (var item in dbItems) { lDal.DeleteItem(item.LineItem_Id); } foreach (var item in lineItems) { LineItem li = new LineItem() { Intro = item.Intro, Name = item.Name, OriginNo = item.OriginNo, Project = item.Project, Quantity = item.Quantity, Remark = item.Remark, SourceId = this.StId, SourceType = SysConst.SourceTypeSettlement, Spec = item.Spec, Unit = item.Unit, UnitPrice = item.UnitPrice }; lDal.AddLineItem(li); } lDal.Save(); UIUtility.BindUserControl(LineItemsControl1, SysConst.SourceTypeSettlement, StId); }
protected void btnSaveAmount_Click(object sender, EventArgs e) { SettlementDAL dal = new SettlementDAL(); var st = dal.GetSettlementByNo(StNo); if (!string.IsNullOrEmpty(txtTotalAmount.Text)) { st.TotalAmount = double.Parse(txtTotalAmount.Text); } if (!string.IsNullOrEmpty(txtReceivedFirst.Text)) { st.FirstAmount = double.Parse(txtReceivedFirst.Text); } if (!string.IsNullOrEmpty(txtReceived.Text)) { st.AmountReceived = double.Parse(txtReceived.Text); } st.ReceivableIntro = txtBalanceIntro.Text; lblEndBalance.Text = ((st.TotalAmount.HasValue ? st.TotalAmount.Value : 0) - (st.AmountReceived.HasValue ? st.AmountReceived.Value : 0)).ToString(); dal.Save(); }
protected void cblDeliveryList_SelectedIndexChanged(object sender, EventArgs e) { List <LineItem> items = new List <LineItem>(); LineItemDAL dal = new LineItemDAL(); foreach (ListItem listItem in cblDeliveryList.Items) { if (listItem.Selected) { var del = new DeliveryDAL().GetDeliveryByNo(listItem.Text); var delItems = dal.GetLineItemsBySource(del.Delivery_Id, SysConst.SourceTypeDelivery); foreach (var delItem in delItems) { items.Add(new LineItem() { Intro = delItem.Intro, Name = delItem.Name, OriginNo = listItem.Text, Project = delItem.Project, Quantity = delItem.Quantity, Remark = delItem.Remark, SourceId = StId, SourceType = SysConst.SourceTypeSettlement, Spec = delItem.Spec, Unit = delItem.Unit, UnitPrice = delItem.UnitPrice }); } } else { var lineItemsOfSt = dal.GetLineItemsBySource(StId, SysConst.SourceTypeSettlement); foreach (var item in lineItemsOfSt) { if (item.OriginNo == listItem.Text) { dal.DeleteItem(item.LineItem_Id); } } } } foreach (var item in items) { dal.AddLineItem(item); } dal.Save(); //save list StringBuilder sb = new StringBuilder(); for (int i = 0; i < cblDeliveryList.Items.Count; i++) { if (cblDeliveryList.Items[i].Selected) { sb.Append(cblDeliveryList.Items[i].Text).Append("|"); } } var stDAL = new SettlementDAL(); var st = stDAL.GetSettlementByNo(StNo); st.DeliveryList = sb.ToString(); stDAL.Save(); UIUtility.BindUserControl(LineItemsControl1, SysConst.SourceTypeSettlement, StId); }