public void _ValidateForDelete(Model.MRSHeader mRSHeader) { switch (mRSHeader.SourceType) { case "3": case "6": if (this.JudgeValueExists(" SELECT 1 FROM ProduceOtherCompact where MRSHeaderId ='" + mRSHeader.MRSHeaderId + "' ")) { throw new Helper.ViolateConstraintException("Has generated outsourcing contract,cannot delete"); } break; case "1": if (this.JudgeValueExists(" SELECT 1 FROM InvoiceCO where MRSHeaderId ='" + mRSHeader.MRSHeaderId + "'")) { throw new Helper.ViolateConstraintException("Has generated purchase order ,cannot delete"); } break; case "0": case "4": case "5": if (this.JudgeValueExists("SELECT 1 FROM PronoteHeader WHERE MRSHeaderId='" + mRSHeader.MRSHeaderId + "'")) { throw new Helper.ViolateConstraintException("Has generated processing order,cannot delete"); } break; } }
public ListForm(Model.MRSHeader mrsheader, int sourceType) : this() { // this.barButtonItem2.item = DevExpress.XtraBars.BarItemVisibility.Always; this.tag = 1; flag = 1; switch (sourceType) { case 0: this.Text = "生產管理-生產加工單列表"; break; case 4: this.Text = "生產管理-" + Properties.Resources.ZZJiaGong + "列表"; break; case 5: case 7: this.Text = "生產管理-" + Properties.Resources.GZZhiShi + "列表"; break; default: this.Text = ""; break; } this.sourceType = sourceType; listDetail = (this.manager as BL.PronoteHeaderManager).Select(mrsheader); foreach (Model.PronoteHeader pronoteHeader in listDetail) { pronoteHeader.Checkeds = true; } this.bindingSource1.DataSource = listDetail; }
public void UpdateMRSHeaderFlag(Model.MRSHeader mRSHeader) { int flag = 0; //IList<Model.MRSdetails> list = mRSdetailsManager.Select(mRSHeader); IList <Model.MRSdetails> list = mRSdetailsManager.SelectBySqlMap(mRSHeader); foreach (Model.MRSdetails detail in list) { flag += detail.DetailsFlag == null ? 0 : detail.DetailsFlag.Value; } if (flag == 0) { mRSHeader.InvoiceFlag = 0; } else if (flag < list.Count * 2) { mRSHeader.InvoiceFlag = 1; } else if (flag == list.Count * 2) { mRSHeader.InvoiceFlag = 2; } new BL.MRSHeaderManager().UpdateHeader(mRSHeader); }
public void _ValidateForDelete(Model.MRSHeader mRSHeader) { switch (mRSHeader.SourceType) { case "3": case "6": if (this.JudgeValueExists(" SELECT 1 FROM ProduceOtherCompact where MRSHeaderId ='" + mRSHeader.MRSHeaderId + "' ")) { throw new Helper.ViolateConstraintException("已形成委外單,不能刪除"); } break; case "1": if (this.JudgeValueExists(" SELECT 1 FROM InvoiceCO where MRSHeaderId ='" + mRSHeader.MRSHeaderId + "'")) { throw new Helper.ViolateConstraintException("已形成採購單,不能刪除"); } break; case "0": case "4": case "5": if (this.JudgeValueExists("SELECT 1 FROM PronoteHeader WHERE MRSHeaderId='" + mRSHeader.MRSHeaderId + "'")) { throw new Helper.ViolateConstraintException("已形成加工單,不能刪除"); } break; } }
public ListForm(Model.MRSHeader mrsheader, int sourceType) : this() { // this.barButtonItem2.item = DevExpress.XtraBars.BarItemVisibility.Always; this.tag = 1; flag = 1; switch (sourceType) { case 0: this.Text = "Production and processing list"; break; case 4: this.Text = "Assembly processing list"; break; case 5: this.Text = "Processing instructions list"; break; default: this.Text = ""; break; } this.sourceType = sourceType; listDetail = (this.manager as BL.PronoteHeaderManager).Select(mrsheader); foreach (Model.PronoteHeader pronoteHeader in listDetail) { pronoteHeader.Checkeds = true; } this.bindingSource1.DataSource = listDetail; }
private void Validate(Model.MRSHeader mRSHeader) { if (mRSHeader.MRSstartdate == new DateTime() || mRSHeader.MRSstartdate == global::Helper.DateTimeParse.NullDate || mRSHeader.MRSstartdate == null) { throw new Helper.RequireValueException(Model.MRSHeader.PRO_MRSstartdate); } bool IsNullOrZero = false; if (mRSHeader.Details != null) { foreach (Model.MRSdetails item in mRSHeader.Details) { if (item.MRSdetailssum != null) { IsNullOrZero = true; } if (mRSHeader.SourceType == "1" || mRSHeader.SourceType == "3") { if (string.IsNullOrEmpty(item.SupplierId)) { throw new Helper.RequireValueException(Model.MRSdetails.PRO_SupplierId); } } } if (IsNullOrZero == false) { throw new Helper.MessageValueException("數量不能為空!"); } } }
public bool ExistsExcept(Model.MRSHeader e) { Hashtable paras = new Hashtable(); paras.Add("newId", e.Id); paras.Add("oldId", Get(e.MRSHeaderId).Id); return(sqlmapper.QueryForObject <bool>("MRSHeader.existsexcept", paras)); }
public ListForm(Model.MRSHeader mrsheader) : this() { if (produceManager.MRSHeader.EditForm.isDelete) { this.CanDelete(); } this._mrsHeader = mrsheader; }
public Model.MRSHeader GetDetails(string mRSheaderId) { Model.MRSHeader mRSheader = accessor.Get(mRSheaderId); if (mRSheader != null) { mRSheader.Details = MRSdetailsAccessor.Select(mRSheader); } return(mRSheader); }
public EditForm(Model.MRSHeader mrsheader) : this() { this._mrsheader = mrsheader; this.action = "view"; if (this.action == "view") { LastFlag = 1; } }
public IList <Book.Model.MRSdetails> Select(Model.MRSHeader mRSheader) { //StringBuilder sb = new StringBuilder("SELECT *,(SELECT (ProduceMaterialDistributioned+OtherMaterialDistributioned) FROM Product WHERE Product.ProductId = MRSdetails.ProductId) AS ProductFPSLsum"); //sb.Append(" ,(SELECT ProductName FROM Product WHERE Product.ProductId = MRSdetails.ProductId) AS ProductName"); //sb.Append(" ,(SELECT ProductName FROM Product WHERE Product.ProductId = MRSdetails.MadeProductId) AS MadeProductName"); //sb.Append(" ,(SELECT SupplierShortName FROM Supplier WHERE Supplier.SupplierId = MRSdetails.SupplierId) AS SupplierShortName"); //sb.Append(" FROM MRSdetails WHERE MRSHeaderId='" + mRSheader.MRSHeaderId + "' order by Inumber"); //return this.DataReaderBind<Model.MRSdetails>(sb.ToString(), null, CommandType.Text); return(sqlmapper.QueryForList <Model.MRSdetails>("MRSdetails.select_byMRSheaderId", mRSheader.MRSHeaderId)); }
private void xrSubreport1_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { RO1Details1 detail = this.xrSubreport1.ReportSource as RO1Details1; Model.MRSHeader mrsh = this.GetCurrentRow() as Model.MRSHeader; if (mrsh != null) { mrsh.Details = this.mRSdetailsManager.Select(mrsh); detail.MMRSHeader = mrsh; } }
private void Q59_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { Q59_1 reportProducts = this.xrSubreport1.ReportSource as Q59_1; Model.MRSHeader mrsHeader = this.GetCurrentRow() as Model.MRSHeader; if (mrsHeader != null) { mrsHeader.Details = this.mrsDetailManager.GetByMRSIDAndProId(mrsHeader.MRSHeaderId, this.condition.Product == null?null:this.condition.Product.ProductId); reportProducts.MrsHeader = mrsHeader; } }
public IList <Book.Model.PronoteHeader> Select(Model.MRSHeader mrsheader) { StringBuilder sql = new StringBuilder(); sql.Append("SELECT w.Workhousename,a.Checkeds,a.InvoiceXOId,a.PronoteHeaderID,a.InvoiceCusId, a.InvoiceXODetailQuantity,a.PronoteDate,a.Pronotedesc,a.MRSHeaderId,a.MRSdetailsId,a.DetailsSum,a.ProductId,a.ProductUnit,a.InvoiceXODetailQuantity,(select EmployeeName from employee where employee.employeeid=a.Employee0Id) as Employee0Name,(select EmployeeName from employee where employee.employeeid=a.Employee1Id) as Employee1Name,(select EmployeeName from employee where employee.employeeid=a.Employee2Id) as Employee2Name,i.CustomerInvoiceXOId,(SELECT CheckedStandard FROM Customer c WHERE c.CustomerId = i.xocustomerId) as CustomerCheckStandard,(SELECT CustomerShortName FROM Customer c WHERE c.CustomerId = i.xocustomerId) as CustomerShortName,b.ProductName,b.id,b.CustomerProductName,b.ProductDescription as ProductDesc FROM PronoteHeader a left join Product b on a.productid=b.productid left join invoicexo i on a.invoicexoid=i.invoiceid left join WorkHouse w on a.WorkHouseId=w.WorkHouseId"); sql.Append(" where a.MRSHeaderId= '" + mrsheader.MRSHeaderId + "'"); sql.Append(" order by a.PronoteHeaderID desc "); return(this.DataReaderBind <Model.PronoteHeader>(sql.ToString(), null, CommandType.Text)); // return sqlmapper.QueryForList<Book.Model.PronoteHeader>("PronoteHeader.select_bymrsheader", mrsheader.MRSHeaderId); }
public ListForm(Model.MRSHeader mrsheader) : this() { flag = 1; listDetail = (this.manager as BL.ProduceOtherCompactManager).SelectByMRSHeaderId(mrsheader.MRSHeaderId); foreach (Model.ProduceOtherCompact item in listDetail) { item.Checkeds = true; } this.bindingSource1.DataSource = listDetail; }
public ListForm(Model.MRSHeader mrsheader) : this() { flag = 1; //listDetail = (this.manager as BL.ProduceOtherCompactManager).SelectByMRSHeaderId(mrsheader.MRSHeaderId); //foreach (Model.ProduceOtherCompact item in listDetail) //{ // item.Checkeds = true; //} this.mrsheader = mrsheader; }
/// <summary> /// Delete MRSHeader by primary key. /// </summary> public void Delete(string mRSHeaderID) { // // todo:add other logic here // Model.MRSHeader model = this.Get(mRSHeaderID); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd")); SequenceManager.Decrement(sequencekey_d); accessor.Delete(mRSHeaderID); }
public void Delete(Model.MRSHeader mRSHeader) { // // todo:add other logic here // _ValidateForDelete(mRSHeader); try { BL.V.BeginTransaction(); this._Delete(mRSHeader); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
/// <summary> /// Update a MRSHeader. /// </summary> public void Update(Model.MRSHeader mRSHeader) { // // todo: add other logic here. Validate(mRSHeader); //if (this.ExistsExcept(mRSHeader)) //{ // throw new Helper.InvalidValueException(Model.MRSHeader.PRO_Id); //} // mPSheader.UpdateTime = DateTime.Now; // accessor.Update(mPSheader); if (mRSHeader != null) { try { BL.V.BeginTransaction(); //this.Delete(mRSHeader); mRSHeader.UpdateTime = DateTime.Now; //修改头 this.UpdateHeader(mRSHeader); //删除详细 MRSdetailsAccessor.DeleteByHeader(mRSHeader); //添加详细 foreach (Model.MRSdetails item in mRSHeader.Details) { item.MRSHeaderId = mRSHeader.MRSHeaderId; MRSdetailsAccessor.Insert(item); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } } }
private void TiGuiExists(Model.MRSHeader model) { if (this.ExistsPrimary(model.MRSHeaderId)) { //设置KEY值 string invoiceKind = this.GetInvoiceKind().ToLower(); //string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, model.InsertTime.Value.Year); //string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.InsertTime.Value.Year, model.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd")); //string sequencekey = string.Format(invoiceKind); //SequenceManager.Increment(sequencekey_y); //SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); //SequenceManager.Increment(sequencekey); model.MRSHeaderId = this.GetIdSimple(model.InsertTime.Value); TiGuiExists(model); //throw new Helper.InvalidValueException(Model.Product.PRO_Id); } }
public ListForm(Model.MRSHeader mrsheader) : this() { this._mrsHeader = mrsheader; }
private void simpleButtonOther_Click(object sender, EventArgs e) { ProduceOtherCompact.ChooseOutContract f = new ProduceOtherCompact.ChooseOutContract(); if (f.ShowDialog(this) != DialogResult.OK) { return; } Model.ProduceOtherCompact OtherCompact = f.SelectItem as Model.ProduceOtherCompact; if (OtherCompact == null) { return; } if (this._produceOtherMaterial.Details.Count > 0 && string.IsNullOrEmpty(this._produceOtherMaterial.Details[0].ProductId)) { this._produceOtherMaterial.Details.RemoveAt(0); } this._produceOtherMaterial.Details.Clear(); this.textEditOtherCompact.Text = OtherCompact.ProduceOtherCompactId; this.newChooseContorlSipu.EditValue = OtherCompact.Supplier; this.textEditCusXOId.Text = string.Empty; if (!string.IsNullOrEmpty(OtherCompact.MRSHeaderId)) { Model.MRSHeader mrsHeader = this.mRSHeaderManager.Get(OtherCompact.MRSHeaderId); if (mrsHeader != null) { Model.MPSheader mPSheader = this.mPSheaderManager.Get(mrsHeader.MPSheaderId); if (mPSheader != null) { Model.InvoiceXO invoiceXO = this.invoiceXOManager.Get(mPSheader.InvoiceXOId); this.textEditCusXOId.Text = invoiceXO == null ? string.Empty : invoiceXO.CustomerInvoiceXOId; } } } //if (ProduceOtherCompact.ChooseOutContract._OtherCompactDetailList.Count == 0) return; //if (this._produceOtherInDepot.Details.Count > 0 && string.IsNullOrEmpty(this._produceOtherInDepot.Details[0].ProductId)) // this._produceOtherInDepot.Details.RemoveAt(0); //this._produceOtherInDepot.Details.Clear(); //this.textEditOtherCompact.Text = ProduceOtherCompact.ChooseOutContract._OtherCompactDetailList[0].ProduceOtherCompactId; //this._produceOtherMaterial.Details = (from p in this.OtherCompactMaterialManager.Select(OtherCompact) // group p by new { p.ProductId, p.ProductUnit } into b // select new Model.ProduceOtherMaterialDetail() // { // ProduceOtherMaterialDetailId = Guid.NewGuid().ToString(), // ProduceOtherCompactMaterialId = (from p in b select p.ProduceOtherCompactMaterialId).ToString(), // ProductId = b.Key.ProductId, // Product = new BL.ProductManager().Get(b.Key.ProductId), // ProductUnit =b.Key.ProductUnit, // OtherMaterialQuantity = (from p in b select p.ProduceQuantity).Sum(), // Description = (from p in b select p.Description).ToString(), // }).ToList(); foreach (Model.ProduceOtherCompactMaterial item in this.OtherCompactMaterialManager.Select(OtherCompact)) { Model.ProduceOtherMaterialDetail detail = new Model.ProduceOtherMaterialDetail(); detail.ProduceOtherMaterialDetailId = Guid.NewGuid().ToString(); detail.ProduceOtherCompactMaterialId = item.ProduceOtherCompactMaterialId; detail.Product = this.productManager.Get(item.ProductId); detail.ProductId = item.ProductId; detail.ProductUnit = item.ProductUnit; detail.OtherMaterialQuantity = item.ProduceQuantity;// - (item.AlreadyOutQuantity == null ? 0 : item.AlreadyOutQuantity); if (detail.OtherMaterialQuantity < 0) { detail.OtherMaterialQuantity = 0; } // detail.ProcessPrice = 0; detail.Description = item.Description; detail.ParentProductId = item.ParentProductId; detail.ParentProduct = item.ParentProduct; detail.ProductStock = detail.Product.StocksQuantity; if (!detail.Product.ProduceMaterialDistributioned.HasValue) { detail.Product.ProduceMaterialDistributioned = 0; } if (!detail.Product.OtherMaterialDistributioned.HasValue) { detail.Product.OtherMaterialDistributioned = 0; } detail.Distributioned = detail.Product.OtherMaterialDistributioned + detail.Product.ProduceMaterialDistributioned; detail.Inumber = this._produceOtherMaterial.Details.Count + 1; this._produceOtherMaterial.Details.Add(detail); } this.gridControl1.RefreshDataSource(); }
public void DeleteByHeader(Model.MRSHeader header) { sqlmapper.Delete("MRSdetails.DeleteByHeader", header.MRSHeaderId); }
public override void Refresh() { if (this._produceOtherCompact == null) { this.AddNew(); this.action = "insert"; } else { if (this.action == "view") { this._produceOtherCompact = this.produceOtherCompactManager.GetDetails(_produceOtherCompact.ProduceOtherCompactId); } } this.textEditProduceOtherCompactId.Text = this._produceOtherCompact.ProduceOtherCompactId; this.textEditProduceOtherCompactDesc.Text = this._produceOtherCompact.ProduceOtherCompactDesc; // this.comboBoxOperationType.SelectedIndex =this._produceOtherCompact.OtherOperationType==null?-1: this._produceOtherCompact.OtherOperationType.Value; this.comboBoxProduceType.SelectedIndex = this._produceOtherCompact.OtherProduceType == null ? -1 : this._produceOtherCompact.OtherProduceType.Value; this.textEditPaymentCondition.Text = this._produceOtherCompact.PaymentCondition; if (global::Helper.DateTimeParse.DateTimeEquls(this._produceOtherCompact.ProduceOtherCompactDate, global::Helper.DateTimeParse.NullDate)) { this.dateEditProduceOtherCompactDate.EditValue = null; } else { this.dateEditProduceOtherCompactDate.EditValue = this._produceOtherCompact.ProduceOtherCompactDate; } //if (global::Helper.DateTimeParse.DateTimeEquls(this._produceOtherCompact.JiaoHuoDate, global::Helper.DateTimeParse.NullDate)) //{ // this.dateEditJHDate.EditValue = null; //} //else //{ // this.dateEditJHDate.EditValue = this._produceOtherCompact.JiaoHuoDate; //} this.newChooseEmployee0Id.EditValue = this._produceOtherCompact.Employee0; this.newChooseEmployee1Id.EditValue = this._produceOtherCompact.Employee1; this.newChooseSupplierId.EditValue = this._produceOtherCompact.Supplier; if (!string.IsNullOrEmpty(this._produceOtherCompact.MRSHeaderId)) { Model.MRSHeader mRSHeader = this.mRSHeaderManager.Get(this._produceOtherCompact.MRSHeaderId); if (mRSHeader != null) { Model.MPSheader mPSheader = this.mPSheaderManager.Get(mRSHeader.MPSheaderId); if (mPSheader != null) { this.textEditCustomerXOId.Text = this.invoiceXOManager.Get(mPSheader.InvoiceXOId) == null ? "" : this.invoiceXOManager.Get(mPSheader.InvoiceXOId).CustomerInvoiceXOId; } else { this.textEditCustomerXOId.Text = string.Empty; } } else { this.textEditCustomerXOId.Text = string.Empty; } } else { this.textEditCustomerXOId.Text = string.Empty; } this.textEditAuditState.Text = this.GetAuditName(this._produceOtherCompact.AuditState); this.txtLotNumber.Text = this._produceOtherCompact.LotNumber; this.EmpAudit.EditValue = this._produceOtherCompact.AuditEmp; this.bindingSourceDetails.DataSource = this._produceOtherCompact.Details; this.bindingSourceMaterial.DataSource = this._produceOtherCompact.DetailMaterial; base.Refresh(); switch (this.action) { case "insert": this.barButtonItemProcedures.Enabled = true; this.gridView1.OptionsBehavior.Editable = true; this.gridView2.OptionsBehavior.Editable = true; break; case "update": this.barButtonItemProcedures.Enabled = true; this.gridView1.OptionsBehavior.Editable = true; this.gridView2.OptionsBehavior.Editable = true; break; case "view": this.barButtonItemProcedures.Enabled = false; this.gridView1.OptionsBehavior.Editable = false; this.gridView2.OptionsBehavior.Editable = false; break; } this.textEditProduceOtherCompactId.Properties.ReadOnly = true; this.txtLotNumber.Properties.ReadOnly = true; }
public OutStockReport(string DepotOutId) { InitializeComponent(); this.DepotOut = this.DepotOutManager.Get(DepotOutId); if (this.DepotOut == null) { return; } this.DepotOut.Details = this.DepotOutDetailManager.GetDepotOutDetailByDepotOutId(this.DepotOut.DepotOutId); this.DataSource = this.DepotOut.Details; //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.xrLabelDataName.Text = Properties.Resources.DepotOut; this.xrLabelPrintDate.Text = "列表日期:" + DateTime.Now.ToShortDateString(); this.xrLabelDepotOutId.Text = this.DepotOut.DepotOutId; this.xrLabelDepotOutDate.Text = this.DepotOut.DepotOutDate.Value.ToString("yyyy-MM-dd"); if (this.DepotOut.Employee != null) { this.xrLabelEmployeeId.Text = this.DepotOut.Employee.EmployeeName; } if (this.DepotOut.InvioiceEmployee0 != null) { this.xrLabelInvoiceEmp0.Text = this.DepotOut.InvioiceEmployee0.EmployeeName; } if (DepotOut.Depot != null) { this.xrLabelProduceInDepotId.Text = DepotOut.Depot.DepotName; } if (this.DepotOut.SourceType == "領料單") { Model.ProduceMaterial ProduceMaterial = this.produceMaterialManager.Get(this.DepotOut.InvioiceId); if (ProduceMaterial != null) { //Model.PronoteHeader PronoteHeader = this.pronoteHeaderManager.Get(ProduceMaterial.InvoiceId); //if (PronoteHeader != null) //{ Model.InvoiceXO InvoiceXO = this.invoiceXOManager.Get(ProduceMaterial.InvoiceXOId); if (InvoiceXO != null) { this.xrLabelCustomXoId.Text = InvoiceXO.CustomerInvoiceXOId; this.lblPiHao.Text = InvoiceXO.CustomerLotNumber; this.lblXOCustomer.Text = InvoiceXO.xocustomer == null ? null : InvoiceXO.xocustomer.ToString(); } //if (ProduceMaterial.Employee0 != null) // this.xrLabelInvoiceEmp0.Text = ProduceMaterial.Employee0.ToString(); if (ProduceMaterial.WorkHouse != null) { this.xrLabelWorkHouse.Text = ProduceMaterial.WorkHouse.ToString(); } // } } } else if (this.DepotOut.SourceType == "委外領料單") { Model.ProduceOtherMaterial ProduceOtherMaterial = new BL.ProduceOtherMaterialManager().Get(this.DepotOut.InvioiceId); if (ProduceOtherMaterial != null) { Model.ProduceOtherCompact ProduceOtherCompact = this.produceOtherCompactManager.Get(ProduceOtherMaterial.ProduceOtherCompactId); if (ProduceOtherCompact != null) { if (!string.IsNullOrEmpty(ProduceOtherCompact.MRSHeaderId)) { Model.MRSHeader mRSHeader = this.mRSHeaderManager.Get(ProduceOtherCompact.MRSHeaderId); if (mRSHeader != null) { Model.MPSheader mPSheader = this.mPSheaderManager.Get(mRSHeader.MPSheaderId); if (mPSheader != null) { Model.InvoiceXO InvoiceXO = this.invoiceXOManager.Get(mPSheader.InvoiceXOId); if (InvoiceXO != null) { this.xrLabelCustomXoId.Text = InvoiceXO.CustomerInvoiceXOId; this.lblPiHao.Text = InvoiceXO.CustomerLotNumber; this.lblXOCustomer.Text = InvoiceXO.xocustomer == null ? null : InvoiceXO.xocustomer.ToString(); } } } } } if (ProduceOtherMaterial.WorkHouse != null) { this.xrLabelWorkHouse.Text = ProduceOtherMaterial.WorkHouse.ToString(); } } } this.txt_ParentProduct.Text = DepotOut.ParentProduct; this.xrLabelXqlu.Text = DepotOut.SourceType; this.xrLabeldescription.Text = DepotOut.description; this.xrLabelXgdj.Text = DepotOut.InvioiceId; this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_Inumber); this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); //this.xrTableCellXH.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductSpecification); this.xrTableCellCount.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_DepotOutDetailQuantity); this.xrTableCellUnit.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_ProductUnit); this.xrTableCurrentDepotStock.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_CurrentDepotQuantity); this.xrTableCell_CurrentStock.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_CurrentStockQuantity); this.xrTableCellDepotId.DataBindings.Add("Text", this.DataSource, "DepotPosition." + Model.DepotPosition.PROPERTY_ID); //this.xrTableCellSafeStockQuantity.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.Pro_SafeStockQuantity); this.TCPihao.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_Pihao); this.xrRichText1.DataBindings.Add("Rtf", this.DataSource, Model.DepotOutDetail.Pro_ProductDescription); //this.TCPihao.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_Pihao); this.TCProductCustomerName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName); }
public void Insert(Model.MRSHeader mRSHeader) { // // todo:add other logic here // Validate(mRSHeader); if (this.Exists(mRSHeader.Id)) { throw new Helper.InvalidValueException(Model.MRSHeader.PRO_Id); } try { mRSHeader.InsertTime = DateTime.Now; BL.V.BeginTransaction(); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, mRSHeader.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, mRSHeader.InsertTime.Value.Year, mRSHeader.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, mRSHeader.InsertTime.Value.ToString("yyyy-MM-dd")); string sequencekey = string.Format(invoiceKind); SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); if (mRSHeader.Employee0 != null) { mRSHeader.Employee0Id = mRSHeader.Employee0.EmployeeId; } if (mRSHeader.Employee1 != null) { mRSHeader.Employee1Id = mRSHeader.Employee1.EmployeeId; } mRSHeader.InvoiceStatus = 1; accessor.Insert(mRSHeader); if (mRSHeader.Details != null) { foreach (Model.MRSdetails mRSdetails in mRSHeader.Details) { if (string.IsNullOrEmpty(mRSdetails.ProductId)) { continue; } mRSdetails.MRSHeaderId = mRSHeader.MRSHeaderId; MRSdetailsAccessor.Insert(mRSdetails); //Model.Product product =ProductAccessor.Get(mRSdetails.ProductId); //if (product.MRSStockQuantity != null ) //{ // product.MRSStockQuantity += mRSdetails.Product.StocksQuantity; // if (product.ProductImage == null) // product.ProductImage = pic; // if (product.ProductImage1 == null) // product.ProductImage1 = pic; // if (product.ProductImage2 == null) // product.ProductImage2 = pic; // if (product.ProductImage3 == null) // product.ProductImage3 = pic; // ProductAccessor.Update(product); //} } } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
public IList <Book.Model.MRSdetails> SelectBySqlMap(Model.MRSHeader mRSheader) { return(accessor.Select(mRSheader)); }
public void UpdateHeader(Model.MRSHeader mrsHeader) { accessor.Update(mrsHeader); }
public IList <Book.Model.PronoteHeader> Select(Model.MRSHeader mrsheader) { return(accessor.Select(mrsheader)); }
public void _Delete(Model.MRSHeader mRSHeader) { this.Delete(mRSHeader.MRSHeaderId); }