protected override void AddNew() { this.packingListHeader = new Book.Model.PackingListHeader(); packingListHeader.PackingDate = DateTime.Now; this.action = "insert"; }
/// <summary> /// Update a PackingListHeader. /// </summary> public void Update(Model.PackingListHeader packingListHeader, string oldId) { // // todo: add other logic here. // Validate(packingListHeader); try { BL.V.BeginTransaction(); //删除详细 accessorDetail.DeleteByHeader(oldId); accessor.Delete(oldId); packingListHeader.UpdateTime = DateTime.Now; accessor.Insert(packingListHeader); foreach (var item in packingListHeader.Details) { item.PackingListHeaderId = packingListHeader.PackingNo; accessorDetail.Insert(item); } BL.V.CommitTransaction(); } catch (Exception ex) { BL.V.RollbackTransaction(); throw ex; } }
protected override void MoveNext() { Model.PackingListHeader model = this.packingListHeaderManager.GetNext(this.packingListHeader); if (model == null) { throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows); } this.packingListHeader = model; }
protected override void MoveLast() { if (this.LastFlag == 1) { this.LastFlag = 0; return; } this.packingListHeader = this.packingListHeaderManager.GetLast(); }
protected override Form GetViewForm() { Model.PackingListHeader invoice = this.SelectedItem as Model.PackingListHeader; if (invoice != null) { return(new EditForm(invoice.PackingNo)); } return(null); }
public Book.Model.PackingListHeader GetDetail(string packingNo) { Model.PackingListHeader header = this.Get(packingNo); if (header != null) { header.Details = accessorDetail.SelectByHeader(packingNo); } return(header); }
public override void Refresh() { if (this.packingListHeader == null) { this.AddNew(); } else { if (this.action == "view" || this.action == "update") //打印時去掉PLTNO,修改時刷新一下顯示出來 { this.packingListHeader = this.packingListHeaderManager.GetDetail(this.packingListHeader.PackingNo); } } this.txt_PackingNo.Text = this.packingListHeader.PackingNo; this.Date_PackingDate.EditValue = this.packingListHeader.PackingDate; this.btne_CustomerName.Text = this.packingListHeader.CustomerFullName; this.txt_ADDRESS.Text = this.packingListHeader.CustomerAddress; this.txt_PerSS.Text = this.packingListHeader.PerSS; this.lue_From.EditValue = this.packingListHeader.FromPortId; this.lue_TO.EditValue = this.packingListHeader.ToPortId; //2020年1月5日22:42:35 this.txt_PackingListOf.EditValue = this.packingListHeader.PackingListOf; this.txt_Attn.EditValue = this.packingListHeader.Attn; this.btne_ShippedBy.EditValue = this.packingListHeader.ShippedBy; this.txt_ShippedByAddress.EditValue = this.packingListHeader.ShippedByAddress; this.btne_ShipTo.EditValue = this.packingListHeader.ShipTo; this.txt_ShipToAddress.EditValue = this.packingListHeader.ShipToAddress; this.richTextBox1.Rtf = this.packingListHeader.MarkNos; switch (this.action) { case "insert": this.gridView3.OptionsBehavior.Editable = true; break; case "update": this.gridView3.OptionsBehavior.Editable = true; break; default: this.gridView3.OptionsBehavior.Editable = false; break; } this.bindingSourceDetail.DataSource = this.packingListHeader.Details; base.Refresh(); //if (this.action == "update") // this.txt_PackingNo.Properties.ReadOnly = true; }
public EditForm(Model.PackingListHeader invoice) : this() { if (invoice == null) { throw new ArithmeticException("invoiceid"); } this.packingListHeader = invoice; this.action = "view"; if (this.action == "view") { LastFlag = 1; } }
int LastFlag = 0; //页面载 入时是否执行 last方法 public EditForm(string invoiceId) : this() { this.packingListHeader = this.packingListHeaderManager.Get(invoiceId); if (this.packingListHeader == null) { throw new ArithmeticException("invoiceid"); } this.action = "view"; if (this.action == "view") { LastFlag = 1; } }
public override void Refresh() { if (this.packingListHeader == null) { this.AddNew(); } else { if (this.action == "view" || this.action == "update") //打印時去掉PLTNO,修改時刷新一下顯示出來 { this.packingListHeader = this.packingListHeaderManager.GetDetail(this.packingListHeader.PackingNo); } } this.txt_PackingNo.Text = this.packingListHeader.PackingNo; this.Date_PackingDate.EditValue = this.packingListHeader.PackingDate; this.ncc_Customer.EditValue = this.packingListHeader.Customer; this.txt_CustomerName.Text = this.packingListHeader.CustomerFullName; this.txt_ADDRESS.Text = this.packingListHeader.CustomerAddress; this.txt_PerSS.Text = this.packingListHeader.PerSS; this.date_Sailing.EditValue = this.packingListHeader.SailingOnOrAbout; this.lue_From.EditValue = this.packingListHeader.FromPortId; this.lue_TO.EditValue = this.packingListHeader.ToPortId; this.txt_MarkNos.Text = this.packingListHeader.MarkNos; this.cob_Unit.Text = this.packingListHeader.Unit; switch (this.action) { case "insert": this.gridView3.OptionsBehavior.Editable = true; break; case "update": this.gridView3.OptionsBehavior.Editable = true; break; default: this.gridView3.OptionsBehavior.Editable = false; break; } this.bindingSourceDetail.DataSource = this.packingListHeader.Details; base.Refresh(); //if (this.action == "update") // this.txt_PackingNo.Properties.ReadOnly = true; }
protected override void TurnNull() { if (this.packingListHeader == null) { return; } if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { this.packingListHeaderManager.Delete(this.packingListHeader.PackingNo); this.packingListHeader = this.packingListHeaderManager.GetNext(this.packingListHeader); if (this.packingListHeader == null) { this.packingListHeader = this.packingListHeaderManager.GetLast(); } } }
private void gridView1_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { Model.PackingListHeader model = this.bindingSourceHeader.Current as Model.PackingListHeader; if (model != null) { this.bindingSourceDetail.DataSource = model.Details = detailManager.SelectByHeader(model.PackingNo); } else { this.bindingSourceDetail.DataSource = null; } this.gridControl3.RefreshDataSource(); this.SelectItem = model; }
private void Validate(Model.PackingListHeader model) { if (string.IsNullOrEmpty(model.PackingNo)) { throw new Helper.RequireValueException(Model.PackingListHeader.PRO_PackingNo); } if (model.PackingDate == null) { throw new Helper.RequireValueException(Model.PackingListHeader.PRO_PackingDate); } if (string.IsNullOrEmpty(model.CustomerId)) { throw new Helper.RequireValueException(Model.PackingListHeader.PRO_CustomerId); } if (string.IsNullOrEmpty(model.PerSS)) { throw new Helper.RequireValueException(Model.PackingListHeader.PRO_PerSS); } if (model.SailingOnOrAbout == null) { throw new Helper.RequireValueException(Model.PackingListHeader.PRO_SailingOnOrAbout); } if (string.IsNullOrEmpty(model.FromPortId)) { throw new Helper.RequireValueException(Model.PackingListHeader.PRO_FromPortId); } if (string.IsNullOrEmpty(model.ToPortId)) { throw new Helper.RequireValueException(Model.PackingListHeader.PRO_ToPortId); } foreach (var item in model.Details) { //if (string.IsNullOrEmpty(item.PLTNo)) // throw new Helper.RequireValueException(Model.PackingListDetail.PRO_PLTNo); if (string.IsNullOrEmpty(item.CartonNo)) { throw new Helper.RequireValueException(Model.PackingListDetail.PRO_CartonNo); } } }
/// <summary> /// Insert a PackingListHeader. /// </summary> public void Insert(Model.PackingListHeader packingListHeader) { // // todo:add other logic here // Validate(packingListHeader); if (this.ExistsPrimary(packingListHeader.PackingNo)) { throw new Helper.MessageValueException(string.Format("已存在相同的PACKINGNO:{0}", packingListHeader.PackingNo)); } try { BL.V.BeginTransaction(); packingListHeader.InsertTime = DateTime.Now; packingListHeader.UpdateTime = DateTime.Now; accessor.Insert(packingListHeader); foreach (var item in packingListHeader.Details) { item.PackingListHeaderId = packingListHeader.PackingNo; accessorDetail.Insert(item); } BL.V.CommitTransaction(); } catch (Exception ex) { BL.V.RollbackTransaction(); throw ex; } }
public Model.PackingListHeader GetNext(Model.PackingListHeader e) { return(accessor.GetNext(e)); }
public bool HasRowsAfter(Model.PackingListHeader e) { return(accessor.HasRowsAfter(e)); }
public bool HasRowsBefore(Model.PackingListHeader e) { return(accessor.HasRowsBefore(e)); }
public RO(Model.PackingListHeader packingList) { InitializeComponent(); if (!string.IsNullOrEmpty(packingList.Unit)) { this.xrTableCell5.Text = string.Format("Quantity ({0})", packingList.Unit); } var group = packingList.Details.GroupBy(P => P.PLTNo); foreach (var item in group) { item.ToList().ForEach(D => { D.PLTNo = ""; }); item.First().PLTNo = item.Key; } this.DataSource = packingList.Details; //lbl_CompanyName.Text = BL.Settings.CompanyChineseName; this.lbl_PackingNo.Text = packingList.PackingNo; this.lbl_PackingDate.Text = packingList.PackingDate.Value.ToString("yyyy/MM/dd"); this.lbl_CustomerFullName.Text = packingList.CustomerFullName; this.lbl_address.Text = packingList.CustomerAddress; this.lbl_PerSS.Text = packingList.PerSS; if (packingList.FromPort != null) { this.lbl_From.Text = packingList.FromPort.PortName; } if (packingList.ToPort != null) { this.lbl_TO.Text = packingList.ToPort.PortName; } //2020年1月6日03:09:13 this.lbl_PackingListOf.Text = packingList.PackingListOf; this.lbl_Attn.Text = packingList.Attn; this.lbl_ShippedBy.Text = packingList.ShippedBy; this.lbl_ShipTo.Text = packingList.ShipTo; this.lbl_ShioToAddress.Text = packingList.ShipToAddress; this.xrRichText1.Rtf = packingList.MarkNos; //this.lblTotal.Text = packingList.Details.Max(P => Convert.ToInt32(string.IsNullOrEmpty(P.PLTNo) ? "0" : P.PLTNo)) + " PLT / " + // (string.IsNullOrEmpty(packingList.Details.Last().CartonNo) ? "" : packingList.Details.Last().CartonNo.Substring(packingList.Details.Last().CartonNo.Length - 1)) + " CARTON"; var cartonNoGroup = packingList.Details.GroupBy(P => P.CartonNo.Trim()); int totalCartonNo = 0; foreach (var item in cartonNoGroup) { totalCartonNo += item.ToList()[0].CartonQty; } if (packingList.Details != null && packingList.Details.Count > 0) { //this.lblTotal.Text = (packingList.Details.Max(P => Convert.ToInt32(string.IsNullOrEmpty(P.PLTNo) ? "0" : P.PLTNo)) == 0 ? 1 : packingList.Details.Max(P => Convert.ToInt32(string.IsNullOrEmpty(P.PLTNo) ? "0" : P.PLTNo))) + " PLT / " + totalCartonNo + " CARTON"; this.lblTotal.Text = totalCartonNo + " CARTON"; } if (!string.IsNullOrEmpty(packingList.Unit)) { this.lbl_TotalQTY.Text = packingList.Details.Sum(P => P.Quantity).Value.ToString("0.##") + " " + packingList.Unit; } else { this.lbl_TotalQTY.Text = packingList.Details.Sum(P => P.Quantity).Value.ToString("0.##") + " PCS"; } this.lbl_TotalNetWeight.Text = packingList.Details.Sum(P => P.NetWeight).Value.ToString("0.##") + " KGS"; this.lbl_TotalGrossWeight.Text = packingList.Details.Sum(P => P.GrossWeight).Value.ToString("0.##") + " KGS"; this.lbl_TotalCaiji.Text = packingList.Details.Sum(P => P.Caiji).Value.ToString("0.##") + " CUFT"; //另一种加总方法,此方法需要在界面上该控件的Summary属性设置如下 Func-Sum; Running-Report //this.lbl_TotalCaiji.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_Caiji, "{0:0.##} CUFT"); //TC_PLTNo.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_PLTNo); TC_CartonNo.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_CartonNo); TC_CartonQty.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_CartonQty, "{0:0.##}"); TC_ProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); TCQTY.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_ShowQty, "{0:0.##}"); TC_NetWeight.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_ShowNetWeight, "{0:0.##}"); TC_GrossWeight.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_ShowGrossWeight, "{0:0.##}"); TC_Caiji.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_ShowCaiji, "{0:0.##}"); }
public void Insert(Model.PackingListHeader e) { this.Insert <Model.PackingListHeader>(e); }
public void Update(Model.PackingListHeader e) { this.Update <Model.PackingListHeader>(e); }
public bool HasRowsBefore(Model.PackingListHeader e) { return(sqlmapper.QueryForObject <bool>("PackingListHeader.has_rows_before", e)); }
public bool HasRowsAfter(Model.PackingListHeader e) { return(sqlmapper.QueryForObject <bool>("PackingListHeader.has_rows_after", e)); }
public Model.PackingListHeader GetNext(Model.PackingListHeader e) { return(sqlmapper.QueryForObject <Model.PackingListHeader>("PackingListHeader.get_next", e)); }
public RO(Model.PackingListHeader packingList) { InitializeComponent(); if (!string.IsNullOrEmpty(packingList.Unit)) { this.xrTableCell5.Text = string.Format("Quantity ({0})", packingList.Unit); } var group = packingList.Details.GroupBy(P => P.PLTNo); foreach (var item in group) { item.ToList().ForEach(D => { D.PLTNo = ""; }); item.First().PLTNo = item.Key; } this.DataSource = packingList.Details; this.lbl_PackingNo.Text = packingList.PackingNo; //this.lbl_PackingDate.Text = packingList.PackingDate.Value.ToString("yyyy-MM-dd"); this.lbl_PackingDate.Text = packingList.PackingDate.Value.ToString("MMM dd.yyyy", CultureInfo.CreateSpecificCulture("en-GB")); //this.lbl_CustomerFullName.Text = packingList.Customer.CustomerFullName; //this.lbl_address.Text = packingList.Customer.CustomerAddress; this.lbl_CustomerFullName.Text = packingList.CustomerFullName; this.lbl_address.Text = packingList.CustomerAddress; this.lbl_PerSS.Text = packingList.PerSS; if (packingList.SailingOnOrAbout != null) { this.lbl_SailingDate.Text = packingList.SailingOnOrAbout.Value.ToString("MMM dd.yyyy", CultureInfo.CreateSpecificCulture("en-GB")); } if (packingList.FromPort != null) { this.lbl_From.Text = packingList.FromPort.PortName; } if (packingList.ToPort != null) { this.lbl_TO.Text = packingList.ToPort.PortName; } this.lbl_marks.Text = packingList.MarkNos; //this.lblTotal.Text = packingList.Details.Max(P => Convert.ToInt32(string.IsNullOrEmpty(P.PLTNo) ? "0" : P.PLTNo)) + " PLT / " + // (string.IsNullOrEmpty(packingList.Details.Last().CartonNo) ? "" : packingList.Details.Last().CartonNo.Substring(packingList.Details.Last().CartonNo.Length - 1)) + " CARTON"; var cartonNoGroup = packingList.Details.GroupBy(P => P.CartonNo.Trim()); int totalCartonNo = 0; foreach (var item in cartonNoGroup) { totalCartonNo += item.ToList()[0].CartonQty; } if (packingList.Details != null && packingList.Details.Count > 0) { this.lblTotal.Text = packingList.Details.Max(P => Convert.ToInt32(string.IsNullOrEmpty(P.PLTNo) ? "0" : P.PLTNo)) + " PLT / " + totalCartonNo + " CARTON"; } if (!string.IsNullOrEmpty(packingList.Unit)) { this.lbl_TotalQTY.Text = packingList.Details.Sum(P => P.Quantity).Value.ToString("0.00") + " " + packingList.Unit; } else { this.lbl_TotalQTY.Text = packingList.Details.Sum(P => P.Quantity).Value.ToString("0.00") + " PCS"; } this.lbl_TotalNetWeight.Text = packingList.Details.Sum(P => P.NetWeight).Value.ToString("0.00") + " KGS"; this.lbl_TotalGrossWeight.Text = packingList.Details.Sum(P => P.GrossWeight).Value.ToString("0.00") + " KGS"; TC_PLTNo.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_PLTNo); TC_CartonNo.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_CartonNo); TC_PONO.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_PONo); //TC_CUSTNO.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_CUSTNO); //TC_ProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); TC_CUSTNO.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName); TC_ProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); TCQTY.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_ShowQty); TC_NetWeight.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_ShowNetWeight); TC_GrossWeight.DataBindings.Add("Text", this.DataSource, Model.PackingListDetail.PRO_ShowGrossWeight); }
public Model.PackingListHeader GetPrev(Model.PackingListHeader e) { return(sqlmapper.QueryForObject <Model.PackingListHeader>("PackingListHeader.get_prev", e)); }
protected override void MoveFirst() { this.packingListHeader = this.packingListHeaderManager.GetFirst(); }