/// <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);
}
}
