/// <summary> /// Insert a Employee. /// </summary> public void Insert(Model.Employee employee) { Validate_add(employee); // // todo:add other logic here // try { BL.V.BeginTransaction(); employee.InsertTime = DateTime.Now; //employee.RoleId = employee.Role.RoleId; _Insert(employee); string invoiceKind = "emp"; DateTime now = DateTime.Now; string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, now.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, now.Year, now.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, now.ToString("yyyy-MM-dd")); string sequencekey = string.Format(invoiceKind); SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); BL.V.CommitTransaction(); } catch (Exception ex) { BL.V.RollbackTransaction(); throw ex; } }
public void InsertInvoiceCO(Model.InvoiceCO invoiceCO) { try { V.BeginTransaction(); accessor.Insert(invoiceCO); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, DateTime.Now.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, DateTime.Now.Year, DateTime.Now.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, DateTime.Now.ToString("yyyy-MM-dd")); string sequencekey = string.Format(invoiceKind); SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); V.CommitTransaction(); } catch { V.RollbackTransaction(); throw; } }
/// <summary> /// Insert a AtBankAccount. /// </summary> public void Insert(Model.AtBankAccount atBankAccount) { // // todo:add other logic here // Validate(atBankAccount); atBankAccount.BankAccountId = Guid.NewGuid().ToString(); try { atBankAccount.InsertTime = DateTime.Now; BL.V.BeginTransaction(); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, atBankAccount.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, atBankAccount.InsertTime.Value.Year, atBankAccount.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, atBankAccount.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); accessor.Insert(atBankAccount); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
/// <summary> /// Insert a AcbeginbillReceivable. /// </summary> public void Insert(Model.AcbeginbillReceivable acbeginbillReceivable) { try { BL.V.BeginTransaction(); acbeginbillReceivable.InsertTime = DateTime.Now; acbeginbillReceivable.UpdateTime = DateTime.Now; string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, acbeginbillReceivable.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, acbeginbillReceivable.InsertTime.Value.Year, acbeginbillReceivable.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, acbeginbillReceivable.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); accessor.Insert(acbeginbillReceivable); foreach (Model.AcbeginbillReceivableDetail detail in acbeginbillReceivable.Details) { detail.AcbeginbillReceivableDetailId = Guid.NewGuid().ToString(); detail.AcbeginbillReceivableId = acbeginbillReceivable.AcbeginbillReceivableId; detailsaccessor.Insert(detail); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
/// <summary> /// Insert a ANSIPCImpactCheck. /// </summary> public void Insert(Model.ANSIPCImpactCheck aNSIPCImpactCheck) { Validate(aNSIPCImpactCheck); try { BL.V.BeginTransaction(); aNSIPCImpactCheck.InsertTime = DateTime.Now; aNSIPCImpactCheck.UpdateTime = DateTime.Now; TiGuiExists(aNSIPCImpactCheck); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, aNSIPCImpactCheck.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, aNSIPCImpactCheck.InsertTime.Value.Year, aNSIPCImpactCheck.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, aNSIPCImpactCheck.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); accessor.Insert(aNSIPCImpactCheck); foreach (Model.ANSIPCImpactCheckDetail detail in aNSIPCImpactCheck.Details) { ANSIpcicDetailManager.Insert(detail); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
public void Insert(Model.OpticsTest opticsTest) { Validate(opticsTest); try { BL.V.BeginTransaction(); opticsTest.InsertTime = DateTime.Now; opticsTest.UpdateTime = DateTime.Now; TiGuiExists(opticsTest); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, opticsTest.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, opticsTest.InsertTime.Value.Year, opticsTest.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, opticsTest.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); accessor.Insert(opticsTest); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw new Helper.InvalidValueException(Model.OpticsTest.PRO_PCPGOnlineCheckDetailId); } }
/// <summary> /// Insert a AcInvoiceXOBill. /// </summary> public void Insert(Model.AcInvoiceXOBill acInvoiceXOBill) { // // todo:add other logic here // Validate(acInvoiceXOBill); try { BL.V.BeginTransaction(); acInvoiceXOBill.InsertTime = DateTime.Now; TiGuiExists(acInvoiceXOBill); acInvoiceXOBill.UpdateTime = DateTime.Now; string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, acInvoiceXOBill.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, acInvoiceXOBill.InsertTime.Value.Year, acInvoiceXOBill.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, acInvoiceXOBill.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); accessor.Insert(acInvoiceXOBill); addDetail(acInvoiceXOBill); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
public void Insert(Model.ProduceMaterial produceMaterial) { // // todo:add other logic here // Validate(produceMaterial); try { BL.V.BeginTransaction(); produceMaterial.InsertTime = produceMaterial.InsertTime == null ? DateTime.Now : produceMaterial.InsertTime; produceMaterial.UpdateTime = DateTime.Now; TiGuiExists(produceMaterial); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, produceMaterial.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, produceMaterial.InsertTime.Value.Year, produceMaterial.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, produceMaterial.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); accessor.Insert(produceMaterial); foreach (Model.ProduceMaterialdetails produceMaterialdetails in produceMaterial.Details) { if (produceMaterialdetails.Product == null || string.IsNullOrEmpty(produceMaterialdetails.Product.ProductId)) { throw new Exception("Product can not be empty"); } produceMaterialdetails.ProduceMaterialID = produceMaterial.ProduceMaterialID; Model.Product product = productManager.Get(produceMaterialdetails.ProductId); //已分配 produceMaterialdetails.Distributioned = (product.OtherMaterialDistributioned == null ? 0 : product.OtherMaterialDistributioned) + (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + Convert.ToDouble(produceMaterialdetails.Materialprocessum); // produceMaterialdetails.Materialprocesedsum = produceMaterialdetails.Materialprocessum + produceMaterialdetails.Materialprocessum; ProduceMaterialdetailsAccessor.Insert(produceMaterialdetails); product.ProduceMaterialDistributioned = (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + (produceMaterialdetails.Materialprocessum == null ? 0 : produceMaterialdetails.Materialprocessum); productManager.update(product); //物料需求领料描述 Model.MRSdetails mrsdetail; if (produceMaterialdetails.MRSdetailsId != null) { mrsdetail = new BL.MRSdetailsManager().Get(produceMaterialdetails.MRSdetailsId); if (mrsdetail != null) { mrsdetail.MaterialDesc = "Generated material requisition"; new BL.MRSdetailsManager().Update(mrsdetail); } } } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
/// <summary> /// Insert a StockEditor. /// </summary> public void Insert(Model.StockEditor stockEditor) { try { BL.V.BeginTransaction(); stockEditor.InsertTime = DateTime.Now; TiGuiExists(stockEditor); stockEditor.UpdateTime = DateTime.Now; string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, stockEditor.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, stockEditor.InsertTime.Value.Year, stockEditor.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, stockEditor.InsertTime.Value.ToString("yyyy-MM-dd")); string sequencekey = invoiceKind; SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); accessor.Insert(stockEditor); foreach (Model.StockEditorDetal stockEditorDetail in stockEditor.ProductPositionNums) { stockEditorDetail.StockEditorId = stockEditor.StockEditorId; stockEditorDetailsAccessor.Insert(stockEditorDetail); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
/// <summary> /// Insert a ProduceInDepot. /// </summary> public void Insert(Model.ProduceInDepot produceInDepot) { Validate(produceInDepot); try { BL.V.BeginTransaction(); produceInDepot.InsertTime = DateTime.Now; produceInDepot.UpdateTime = DateTime.Now; TiGuiExists(produceInDepot); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, produceInDepot.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, produceInDepot.InsertTime.Value.Year, produceInDepot.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, produceInDepot.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); accessor.Insert(produceInDepot); addDetail(produceInDepot); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
private void TiGuiExists(Model.AcInvoiceXOBill model) { if (this.ExistsPrimary(model.AcInvoiceXOBillId)) { //设置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.AcInvoiceXOBillId = this.GetId(model.InsertTime.Value); TiGuiExists(model); //throw new Helper.InvalidValueException(Model.Product.PRO_Id); } if (this.IsExistsId(model.Id)) //发票编号重复 { model.Id = GetIdNumber(); while (this.IsExistsId(model.Id)) { AddIdNumber(); model.Id = GetIdNumber(); } } }
/// <summary> /// Insert a BomParentPartInfo. /// </summary> public void Insert(Model.BomParentPartInfo bomParentPartInfo) { // // todo:add other logic here // Validate(bomParentPartInfo); if (this.Exists(bomParentPartInfo.Id)) { bomParentPartInfo.Id = this.GetId(); // throw new Helper.InvalidValueException("Id"); } string sql = " ProductId= '" + bomParentPartInfo.ProductId + "'"; if (this.Exists_Field(sql)) { throw new Helper.InvalidValueException(Model.BomParentPartInfo.PRO_ProductId); } bomParentPartInfo.BomId = Guid.NewGuid().ToString(); try { BL.V.BeginTransaction(); bomParentPartInfo.InsertTime = DateTime.Now; string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, bomParentPartInfo.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, bomParentPartInfo.InsertTime.Value.Year, bomParentPartInfo.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, bomParentPartInfo.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); bomParentPartInfo.EmployeeAddId = BL.V.ActiveOperator.EmployeeId; //if (bomParentPartInfo.Status == 0 &&!string.IsNullOrEmpty( bomParentPartInfo.Product.CustomerBeforeProductName)) // this.UpdateSql("UPDATE bomParentPartInfo set Status=1 where productid in(select productid from product where CustomerProductName= '" + bomParentPartInfo.Product.CustomerProductName + "')"); _Insert(bomParentPartInfo); ////添加物料加工工序 //if (!string.IsNullOrEmpty(bomParentPartInfo.TechonlogyHeaderId)) //{ // Model.ManProcedure manProceduce = new Model.ManProcedure(); // manProceduce.ManProcedureId = Guid.NewGuid().ToString(); // manProceduce.BomId = bomParentPartInfo.BomId; // if (bomParentPartInfo.Customer != null) // manProceduce.CustomerId = bomParentPartInfo.Customer.CustomerId; // manProceduce.InsertTime = DateTime.Now; // manProceduce.UpdateTime = DateTime.Now; // manProceduce.TechonlogyHeaderId = bomParentPartInfo.TechonlogyHeaderId; //} BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
public string GetNewId() { string sequencekey = "CBOM"; SequenceManager.Increment(sequencekey); int sequenceval = SequenceManager.GetCurrentVal(sequencekey); return(string.Format("{0}{1:d5}", sequencekey, sequenceval)); }
/// <summary> /// Insert a BGProductDepotOut. /// </summary> public void Insert(Model.BGProductDepotOut bGProductDepotOut) { // // todo:add other logic here // Validate(bGProductDepotOut); if (this.IsExistsDeclareCustomsIdInsert(bGProductDepotOut.DeclareCustomsId)) { throw new Helper.MessageValueException("已存在相同报关单号!"); } try { BL.V.BeginTransaction(); this.TiGuiExists(bGProductDepotOut); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, DateTime.Now.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, DateTime.Now.Year, DateTime.Now.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, DateTime.Now.ToString("yyyy-MM-dd")); string sequencekey = string.Format(invoiceKind); SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); bGProductDepotOut.InsertTime = DateTime.Now; bGProductDepotOut.UpdateTime = DateTime.Now; accessor.Insert(bGProductDepotOut); //修改手册成品 Model.BGHandbookDetail1 detail; foreach (var item in bGProductDepotOut.Detail) { detail = this.bGHandbookDetail1Manager.SelectBGProduct(item.BGHandbookId, item.BGHandbookProductId); if (detail != null) { if (detail.BeeQuantity == null) { detail.BeeQuantity = 0; } detail.BeeQuantity += Convert.ToDouble(item.Quantity); this.bGHandbookDetail1Manager.Update(detail); this.bGHandbookDetail1Manager.UpdateUpQuantity(detail); } item.BGProductDepotOutId = bGProductDepotOut.BGProductDepotOutId; detailaccessor.Insert(item); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
public void Insert(Model.AtSummon atSummon) { if (atSummon.SummonId == null) { atSummon.SummonId = Guid.NewGuid().ToString(); } Validate(atSummon); try { atSummon.InsertTime = DateTime.Now; atSummon.UpdateTime = DateTime.Now; BL.V.BeginTransaction(); TiGuiExists(atSummon); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, atSummon.SummonDate.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, atSummon.SummonDate.Value.Year, atSummon.SummonDate.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, atSummon.SummonDate.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); accessor.Insert(atSummon); foreach (Model.AtSummonDetail atSummonDetail in atSummon.Details) { //if (atSummonDetail.SummonDetailId == null) // continue; if (atSummonDetail.Lending == null || atSummonDetail.SubjectId == null) { throw new global::Helper.MessageValueException("請輸入傳票詳細資料!!"); } if (string.IsNullOrEmpty(atSummonDetail.SummonDetailId)) { atSummonDetail.SummonDetailId = Guid.NewGuid().ToString(); } atSummonDetail.InsertTime = DateTime.Now; atSummonDetail.SummonCatetory = atSummon.SummonCategory; atSummonDetail.BillCode = atSummon.BIllCode; atSummonDetail.SummonId = atSummon.SummonId; _atSummonDetailManager.Insert(atSummonDetail); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
private void RecursiveId(ref string str, string sequencekey) { if (this.ExistsId(str)) { SequenceManager.Increment(sequencekey); int sequenceval = SequenceManager.GetCurrentVal(sequencekey) + 1; str = string.Format("{0}{1:d6}", sequencekey, sequenceval); this.RecursiveId(ref str, sequencekey); } }
/// <summary> /// Insert a ProduceOtherReturnMaterial. /// </summary> public void Insert(Model.ProduceOtherReturnMaterial produceOtherReturnMaterial) { // // todo:add other logic here // // Valid(produceOtherReturnMaterial); try { BL.V.BeginTransaction(); produceOtherReturnMaterial.InsertTime = DateTime.Now; produceOtherReturnMaterial.UpdateTime = DateTime.Now; TiGuiExists(produceOtherReturnMaterial); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, produceOtherReturnMaterial.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, produceOtherReturnMaterial.InsertTime.Value.Year, produceOtherReturnMaterial.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, produceOtherReturnMaterial.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); accessor.Insert(produceOtherReturnMaterial); foreach (Model.ProduceOtherReturnDetail item in produceOtherReturnMaterial.Details) { item.ProduceOtherReturnMaterialId = produceOtherReturnMaterial.ProduceOtherReturnMaterialId; accessorDetail.Insert(item); Model.ProduceOtherCompactDetail CompactDetail = produceOtherCompactDetailAccessor.Get(item.ProduceOtherCompactDetailId); if (CompactDetail != null) { if (CompactDetail.CancelQuantity == null) { CompactDetail.CancelQuantity = 0; } CompactDetail.CancelQuantity += item.Quantity; produceOtherCompactDetailAccessor.Update(CompactDetail); } //stockAccess.Increment(depotpositionAccess.Get(item.DepotPositionId), item.Product, item.Quantity); //item.Product.StocksQuantity += stockAccess.GetTheCountByProduct(item.Product); //item.Product.ProductImage = new byte[0]; //item.Product.ProductImage1 = new byte[0]; //item.Product.ProductImage2 = new byte[0]; //item.Product.ProductImage3 = new byte[0]; //productAccess.Update(item.Product); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
public void Insert(Model.ProduceMaterial produceMaterial) { // // todo:add other logic here // Validate(produceMaterial); try { BL.V.BeginTransaction(); produceMaterial.InsertTime = produceMaterial.InsertTime == null ? DateTime.Now : produceMaterial.InsertTime; produceMaterial.UpdateTime = DateTime.Now; TiGuiExists(produceMaterial); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, produceMaterial.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, produceMaterial.InsertTime.Value.Year, produceMaterial.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, produceMaterial.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); accessor.Insert(produceMaterial); foreach (Model.ProduceMaterialdetails produceMaterialdetails in produceMaterial.Details) { if (produceMaterialdetails.Product == null || string.IsNullOrEmpty(produceMaterialdetails.Product.ProductId)) { throw new Exception("貨品不為空"); } produceMaterialdetails.ProduceMaterialID = produceMaterial.ProduceMaterialID; Model.Product product = productManager.Get(produceMaterialdetails.ProductId); //已分配 produceMaterialdetails.Distributioned = (product.OtherMaterialDistributioned == null ? 0 : product.OtherMaterialDistributioned) + (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + produceMaterialdetails.Materialprocessum; // produceMaterialdetails.Materialprocesedsum = produceMaterialdetails.Materialprocessum + produceMaterialdetails.Materialprocessum; ProduceMaterialdetailsAccessor.Insert(produceMaterialdetails); product.ProduceMaterialDistributioned = (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + (produceMaterialdetails.Materialprocessum == null ? 0 : produceMaterialdetails.Materialprocessum); productManager.update(product); //if (product.ProduceMaterialDistributioned + product.OtherMaterialDistributioned > product.StocksQuantity) //{ // throw new Helper.MessageValueException(product.ProductName + " ," + "領料數量大於未分配數量"); //} } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
/// <summary> /// Insert a DepotIn. /// </summary> public void Insert(Model.DepotIn depotIn) { validate(depotIn); try { V.BeginTransaction(); depotIn.InsertTime = System.DateTime.Now; depotIn.UpdateTime = System.DateTime.Now; TiGuiExists(depotIn); string invoiceKind = GetInvoiceKind().ToLower(); //string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, depotIn.InsertTime.Value.Year); //string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, depotIn.InsertTime.Value.Year, depotIn.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, depotIn.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); accessor.Insert(depotIn); foreach (Model.DepotInDetail depotInDetail in depotIn.Details) { //if (depotInDetail.ProductId == null || depotInDetail.Product == null) continue; depotInDetail.DepotInId = depotIn.DepotInId; depotInDetail.DepotPosition = depotPositionAccessor.Get(depotInDetail.DepotPositionId); depotInDetailsAccessor.Insert(depotInDetail); if (depotInDetail.Product == null) { depotInDetail.Product = productAccessor.Get(depotInDetail.ProductId); } Model.Stock temp = stockAccessor.GetStockByProductIdAndDepotPositionId(depotInDetail.ProductId, depotInDetail.DepotPositionId); if (temp != null && temp.StockQuantity1 == 0) { temp.Descriptions = depotInDetail.Descriptions; stockAccessor.Update(temp); } stockAccessor.Increment(depotInDetail.DepotPosition, depotInDetail.Product, depotInDetail.DepotInQuantity.Value); productManager.UpdateProduct_Stock(depotInDetail.Product); } V.CommitTransaction(); } catch { V.RollbackTransaction(); throw; } }
/// <summary> /// Insert a BGHandbookDepotIn. /// </summary> public void Insert(Model.BGHandbookDepotIn bGHandbookDepotIn) { // // todo:add other logic here // this.Validate(bGHandbookDepotIn); try { BL.V.BeginTransaction(); this.TiGuiExists(bGHandbookDepotIn); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, DateTime.Now.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, DateTime.Now.Year, DateTime.Now.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, DateTime.Now.ToString("yyyy-MM-dd")); string sequencekey = string.Format(invoiceKind); SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); bGHandbookDepotIn.InsertTime = DateTime.Now; bGHandbookDepotIn.UpdateTime = DateTime.Now; accessor.Insert(bGHandbookDepotIn); Model.BGHandbookDetail2 detail2; foreach (var item in bGHandbookDepotIn.Detail) { //改变手册料件 detail2 = Detail2Manager.SelectByShouceAndId(bGHandbookDepotIn.BGHangbookId, (int)item.BGHandbookProductId); if (detail2 != null) { if (Convert.ToBoolean(item.IsInto)) { detail2.ZhuanCeInQuantity = Convert.ToDouble(detail2.ZhuanCeInQuantity) + Convert.ToDouble(item.DepotInQuantity); } detail2.LbejinQuantity = Convert.ToDouble(detail2.LbejinQuantity) + Convert.ToDouble(item.DepotInQuantity); detail2.HaiKeJInQuantity = Convert.ToDouble(detail2.HaiKeJInQuantity) - Convert.ToDouble(item.DepotInQuantity); detail2.UpQuantity = Convert.ToDouble(detail2.UpQuantity) - Convert.ToDouble(item.DepotInQuantity); detail2.JinKouiMoney = Convert.ToDecimal(detail2.LbejinQuantity) * detail2.LPrice; Detail2Manager.Update(detail2); } item.BGHandbookDepotInId = bGHandbookDepotIn.BGHandbookDepotInId; Detailaccessor.Insert(item); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
private void TiGuiExists(Model.DepotIn model) { if (this.ExistsPrimary(model.DepotInId)) { //设置KEY值 string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd")); SequenceManager.Increment(sequencekey_d); model.DepotInId = this.GetIdSimple(model.InsertTime.Value); TiGuiExists(model); } }
private void TiGuiExists(Model.Product product) { // string id = this.GetNewId(product.ProductCategory); if (this.Exists(product.Id)) { //设置KEY值 string sequencekey = product.ProductCategory.Id; SequenceManager.Increment(sequencekey); product.Id = this.GetNewId(product.ProductCategory); TiGuiExists(product); //throw new Helper.InvalidValueException(Model.Product.PRO_Id); } }
public void Insert(Model.ExportSendMail exportSendMail) { Validate(exportSendMail); try { BL.V.BeginTransaction(); exportSendMail.InsertTime = DateTime.Now; exportSendMail.UpdateTime = DateTime.Now; TiGuiExists(exportSendMail); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, exportSendMail.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, exportSendMail.InsertTime.Value.Year, exportSendMail.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, exportSendMail.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); accessor.Insert(exportSendMail); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } //操作附件 if (!string.IsNullOrEmpty(exportSendMail.AccessoriesList)) { string sfdir = this.ServerSavePath + "\\" + exportSendMail.ExportSendMailId; try { System.IO.Directory.CreateDirectory(sfdir); } catch (Exception ex) { throw new Helper.MessageValueException(ex.Message); } foreach (string fn in exportSendMail.AccessoriesList.Split('|')) { if (!fn.Contains(this.ServerSavePath)) { System.IO.File.Copy(fn, sfdir + "\\" + fn.Substring(fn.LastIndexOf("\\") + 1), true); } } } }
/// <summary> /// Insert a UnitGroup. /// </summary> public void Insert(Model.UnitGroup unitGroup) { // // todo:add other logic here // Validate(unitGroup); if (accessor.existsInsertName(unitGroup.UnitGroupName)) { throw new Helper.InvalidValueException(Model.UnitGroup.PROPERTY_UNITGROUPNAME); } // unitGroup.UnitGroupId = Guid.NewGuid().ToString(); try { unitGroup.InsertTime = DateTime.Now; unitGroup.UpdateTime = DateTime.Now; BL.V.BeginTransaction(); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, unitGroup.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, unitGroup.InsertTime.Value.Year, unitGroup.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, unitGroup.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); accessor.Insert(unitGroup); if (unitGroup.Details != null) { foreach (Model.ProductUnit productUnit in unitGroup.Details) { if (string.IsNullOrEmpty(productUnit.CnName)) { continue; } if (ProductUnitAccessor.existsInsertName(productUnit.CnName, unitGroup)) { throw new Helper.InvalidValueException(Model.ProductUnit.PROPERTY_CNNAME); } productUnit.UnitGroupId = unitGroup.UnitGroupId; ProductUnitAccessor.Insert(productUnit); } } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
public void Insert(Model.ProductMouldTest productMouldTest) { Validate(productMouldTest); try { BL.V.BeginTransaction(); productMouldTest.InsertTime = DateTime.Now; productMouldTest.UpdateTime = DateTime.Now; TiGuiExists(productMouldTest); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, productMouldTest.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, productMouldTest.InsertTime.Value.Year, productMouldTest.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, productMouldTest.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); accessor.Insert(productMouldTest); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } //上传附件 if (!string.IsNullOrEmpty(productMouldTest.accessoriesList)) { string filedir = this.SaveSeverPath + "\\" + productMouldTest.ProductMouldTestId; try { System.IO.Directory.CreateDirectory(filedir); } catch (Exception ex) { throw new Helper.MessageValueException(ex.Message); } foreach (string fn in productMouldTest.accessoriesList.Split('|')) { System.IO.File.Copy(fn, filedir + "\\" + fn.Substring(fn.LastIndexOf("\\") + 1), true); } } }
/// <summary> /// Insert a Employee. /// </summary> public void Insert(Model.Employee employee) { Validate_add(employee); // // todo:add other logic here // try { BL.V.BeginTransaction(); employee.InsertTime = DateTime.Now; employee.UpdateTime = DateTime.Now; //employee.RoleId = employee.Role.RoleId; _Insert(employee); string invoiceKind = "emp"; DateTime now = DateTime.Now; string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, now.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, now.Year, now.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, now.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.MonthlySalary monthlySalary = new Book.Model.MonthlySalary(); monthlySalary.MonthlySalaryId = Guid.NewGuid().ToString(); monthlySalary.IdentifyDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM") + "-1"); monthlySalary.EmployeeId = employee.EmployeeId; monthlySalaryManager.Insert(monthlySalary); Model.MonthlySalary monthlySalary2 = new Book.Model.MonthlySalary(); monthlySalary2.MonthlySalaryId = Guid.NewGuid().ToString(); monthlySalary2.IdentifyDate = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToString("yyyy-MM") + "-1"); monthlySalary2.EmployeeId = employee.EmployeeId; monthlySalaryManager.Insert(monthlySalary2); BL.V.CommitTransaction(); } catch (Exception ex) { BL.V.RollbackTransaction(); throw ex; } }
protected override void TiGuiExists(Book.Model.Invoice model) { MethodInfo methodinfo = this.GetType().GetMethod("HasRows", new Type[] { typeof(string) }); bool f = (bool)methodinfo.Invoke(this, new object[] { model.InvoiceId }); if (f) { //设置KEY值 string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd")); SequenceManager.Increment(sequencekey_d); model.InvoiceId = this.GetIdSimple(model.InsertTime.Value); TiGuiExists(model); } }
protected override void TiGuiExists(Book.Model.Invoice model) { Model.InvoiceLH lh = this.Get(model.InvoiceId); if (lh != null) { //设置KEY值 string invoiceKind = this.GetInvoiceKind().ToLower(); //string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd")); //SequenceManager.Increment(sequencekey_d); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.InvoiceDate.Value.Year, model.InvoiceDate.Value.Month); SequenceManager.Increment(sequencekey_m); model.InvoiceId = this.GetIdByMonth(model.InsertTime.Value); TiGuiExists(model); } }
/// <summary> /// Insert a AcInvoiceCOBill. /// </summary> public void Insert(Model.AcInvoiceCOBill acInvoiceCOBill) { Validate(acInvoiceCOBill); try { acInvoiceCOBill.InsertTime = DateTime.Now; TiGuiExists(acInvoiceCOBill); acInvoiceCOBill.UpdateTime = DateTime.Now; BL.V.BeginTransaction(); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, acInvoiceCOBill.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, acInvoiceCOBill.InsertTime.Value.Year, acInvoiceCOBill.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, acInvoiceCOBill.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); accessor.Insert(acInvoiceCOBill); foreach (Model.AcInvoiceCOBillDetail item in acInvoiceCOBill.Details) { item.AcInvoiceCOBillId = acInvoiceCOBill.AcInvoiceCOBillId; accessorDetails.Insert(item); //更新进货详细 Model.InvoiceCGDetail icgd = mInvoiceCGDetailAccessor.Get(item.InvoiceCGDetailId); if (icgd != null) { icgd.InvoiceCGDetailFPQuantity = Convert.ToDouble(icgd.InvoiceCGDetailFPQuantity) + Convert.ToDouble(item.InvoiceCGDetaiInQuantity); } mInvoiceCGDetailAccessor.Update(icgd); } BL.V.CommitTransaction(); } finally { BL.V.RollbackTransaction(); } }
protected override void TiGuiExists(Book.Model.Invoice model) { MethodInfo methodinfo = this.GetType().GetMethod("HasRows", new Type[] { typeof(string) }); bool f = (bool)methodinfo.Invoke(this, new object[] { model.InvoiceId }); if (f) { //设置KEY值 string invoiceKind = this.GetInvoiceKind().ToLower(); //string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd")); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.InvoiceDate.Value.Year, model.InvoiceDate.Value.Month); SequenceManager.Increment(sequencekey_m); //model.InvoiceId = this.GetIdSimple(model.InsertTime.Value); model.InvoiceId = this.GetIdByMonth(model.InsertTime.Value); //客户订单的编号按照月增量,简单Id按照天增量,若进来此处用简单Id算法会导致死循环 TiGuiExists(model); } }