public void Delete(Model.DepotIn depotIn)
{
try
{
V.BeginTransaction();
foreach (Model.DepotInDetail depotInDetail in depotIn.Details)
{
if (depotInDetail.Product == null || depotInDetail.Product.ProductId == null)
{
continue;
}
// product.MpsStockQuantity=
depotInDetail.DepotPosition = depotPositionAccessor.Get(depotInDetail.DepotPositionId);
stockAccessor.Decrement(depotInDetail.DepotPosition, depotInDetail.Product, depotInDetail.DepotInQuantity);
productManager.UpdateProduct_Stock(depotInDetail.Product);
}
this.Delete(depotIn.DepotInId);
V.CommitTransaction();
}
catch
{
V.RollbackTransaction();
throw;
}
}
public DepotInForm(string id)
: this()
{
this._depotIn = this._depotInManager.Get(id);
this._depotIn = this._depotInManager.GetDetails(this._depotIn);
this.flag = 1;
this.action = "view";
}
protected override void MoveLast()
{
if (this.flag == 1)
{
this.flag = 0; return;
}
this._depotIn = this._depotInManager.Get(this._depotInManager.GetLast() == null ? "" : this._depotInManager.GetLast().DepotInId);
}
public Model.DepotIn GetDetails(Model.DepotIn depotIn)
{
depotIn = this.Get(depotIn.DepotInId);
if (depotIn != null)
{
depotIn.Details = depotInDetailsAccessor.GetDetailByDepotInId(depotIn.DepotInId);
}
return(depotIn);
}
protected override void MovePrev()
{
Model.DepotIn depotIn = this._depotInManager.GetPrev(this._depotIn);
if (depotIn == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._depotIn = this._depotInManager.Get(depotIn.DepotInId);
}
/// <summary>
/// Delete DepotIn by primary key.
/// </summary>
public void Delete(string depotInId)
{
Model.DepotIn model = this.Get(depotInId);
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(depotInId);
}
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);
}
}
/// <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;
}
}
public DepotInReport(string DepotInId)
{
InitializeComponent();
this.DepotIn = this.DepotInManager.Get(DepotInId);
if (this.DepotIn == null)
{
return;
}
this.DepotIn.Details = this.DepotInDetailManager.GetDetailByDepotInId(this.DepotIn.DepotInId);
this.DataSource = this.DepotIn.Details;
//CompanyInfo
this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName;
this.xrLabelDataName.Text = Properties.Resources.DepotIn;
this.xrLabelPrintDate.Text = "Ñu±íÈÕÆÚ£º " + DateTime.Now.ToShortDateString();
this.xrLabelDepotInId.Text = this.DepotIn.DepotInId;
this.xrLabelDepotInDate.Text = this.DepotIn.DepotInDate.Value.ToString("yyyy-MM-dd");
if (this.DepotIn.Employee != null)
{
this.xrLabelEmployeeId.Text = this.DepotIn.Employee.EmployeeName;
}
if (this.DepotIn.Employee0 != null)
{
this.xrLabelEmployee1Id.Text = this.DepotIn.Employee0.EmployeeName;
}
if (DepotIn.Depot != null)
{
this.xrLabelProduceInDepotId.Text = DepotIn.Depot.DepotName;
}
if (DepotIn.Supplier != null)
{
this.xrLabelSupplierId.Text = DepotIn.Supplier.SupplierShortName;
}
this.xrLabelDescription.Text = DepotIn.Description;
this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.DepotInDetail.PRO_Inumber);
this.TCProductID.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id);
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.DepotInDetail.PRO_DepotInQuantity);
this.xrTableCellUnit.DataBindings.Add("Text", this.DataSource, Model.DepotInDetail.PRO_ProductUnit);
this.xrTableCellPronoteHeaderId.DataBindings.Add("Text", this.DataSource, Model.DepotInDetail.PRO_PronoteHeaderId);
// this.xrTableCellCustomXOId.DataBindings.Add("Text", this.DataSource, Model.DepotInDetail);
this.xrTableCellDepotId.DataBindings.Add("Text", this.DataSource, "DepotPosition." + Model.DepotPosition.PROPERTY_ID);
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
ChooseDepotIn form = new ChooseDepotIn();
if (form.ShowDialog(this) == DialogResult.OK)
{
this._depotIn = form._depotIn;
if (this._depotIn != null)
{
this.Refresh();
}
}
}
protected override void AddNew()
{
this._depotIn = new Book.Model.DepotIn();
this._depotIn.DepotInId = this._depotInManager.GetId(DateTime.Now.Date);
this._depotIn.DepotId = null;
this._depotIn.Details = new List <Model.DepotInDetail>();
this._depotIn.Employee = BL.V.ActiveOperator.Employee;
this._depotInDetail = new Book.Model.DepotInDetail();
this._depotInDetail.DepotInDetailId = Guid.NewGuid().ToString();
this._depotInDetail.Inumber = this._depotIn.Details.Count + 1;
this._depotIn.Details.Add(this._depotInDetail);
this.bindingSourceDetail.Position = this.bindingSourceDetail.IndexOf(this._depotInDetail);
}
private void TiGuiExists(Model.DepotIn model)
{
if (this.ExistsPrimary(model.DepotInId))
{
//设置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.DepotInId = this.GetId(model.InsertTime.Value);
TiGuiExists(model);
//throw new Helper.InvalidValueException(Model.Product.PRO_Id);
}
}
protected override void Delete()
{
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
try
{
this._depotInManager.Delete(this._depotIn);
this._depotIn = this._depotInManager.GetNext(this._depotIn);
if (this._depotIn == null)
{
this._depotIn = this._depotInManager.GetLast();
}
}
catch
{
throw;
}
}
protected override void MoveLast()
{
this._depotIn = this._depotInManager.Get(this._depotInManager.GetLast() == null ? "" : this._depotInManager.GetLast().DepotInId);
}
public Model.DepotIn GetPrev(Model.DepotIn e)
{
return(accessor.GetPrev(e));
}
public override void Refresh()
{
if (this._depotIn == null)
{
this.AddNew();
this.action = "insert";
}
else
{
if (this.action != "insert")
{
this._depotIn = this._depotInManager.GetDetails(this._depotIn);
if (this._depotIn == null)
{
this._depotIn = new Book.Model.DepotIn();
this._depotIn.DepotInId = this._depotInManager.GetId(DateTime.Now.Date);
this._depotIn.Details = new List <Model.DepotInDetail>();
this._depotInDetail = new Book.Model.DepotInDetail();
this._depotInDetail.DepotInDetailId = Guid.NewGuid().ToString();
this._depotIn.Details.Add(this._depotInDetail);
this.bindingSourceDetail.Position = this.bindingSourceDetail.IndexOf(this._depotInDetail);
}
}
}
if (this._depotIn.Details != null)
{
foreach (var item in this._depotIn.Details)
{
if (!string.IsNullOrEmpty(item.PronoteHeaderId))
{
item.CusXOId = invoiceXOManager.SelectCusXOIdByPronoteHeaderId(item.PronoteHeaderId);
}
}
}
this.dateEditDate.EditValue = DateTime.Now;
this.textEditDepotInId.Text = this._depotIn.DepotInId;
if (this._depotIn.DepotInDate != null)
{
this.dateEditDate.DateTime = this._depotIn.DepotInDate.Value;
}
if (this._depotIn.Employee0Id != null)
{
this.newChooseEmp1.EditValue = _depotIn.Employee0;
}
//else
// this.newChooseEmp0.EditValue = null;
this.newChooseEmp0.EditValue = this._depotIn.Employee;
//else
// this.newChooseEmp.EditValue = null;
if (this._depotIn.Supplier != null)
{
this.newChooseContorlSupplier.EditValue = this._depotIn.Supplier;
}
//else
// this.newChooseContorlSupplier.EditValue = null;
this.lookUpEditDepotId.EditValue = this._depotIn.DepotId;
this.lookUpEditDepotId.EditValue = this._depotIn.DepotId;
if (this._depotIn.DepotId == null)
{
this.bindingSourceDepotPisition.DataSource = null;
}
//else this.newChooseEmp.EditValue = null;
//this.buttonEditProductCategry.EditValue = this._depotIn.ProductCategory;
//if (this._depotIn.ProductCategory != null)
// this.bindingSourceProduct.DataSource = this._productManager.Select(this._depotIn.ProductCategory);
this.newChooseEmp2.EditValue = this._depotIn.AuditEmp;
this.txt_AuditState.EditValue = this.GetAuditName(this._depotIn.AuditState);
this.bindingSourceDetail.DataSource = this._depotIn.Details;
this.gridControl1.RefreshDataSource();
base.Refresh();
switch (this.action)
{
case "insert":
this.gridView1.OptionsBehavior.Editable = true;
this.textEditDepotInId.Properties.ReadOnly = false;
break;
case "update":
this.gridView1.OptionsBehavior.Editable = true;
this.textEditDepotInId.Properties.ReadOnly = true;
break;
case "view":
this.gridView1.OptionsBehavior.Editable = false;
this.textEditDepotInId.Properties.ReadOnly = true;
break;
}
}
public Model.DepotIn GetNext(Model.DepotIn e)
{
return(accessor.GetNext(e));
}
public Model.DepotIn GetPrev(Model.DepotIn e)
{
return(sqlmapper.QueryForObject <Model.DepotIn>("DepotIn.get_prev", e));
}
public bool HasRowsAfter(Model.DepotIn e)
{
return(sqlmapper.QueryForObject <bool>("DepotIn.has_rows_after", e));
}
public bool HasRowsBefore(Model.DepotIn e)
{
return(sqlmapper.QueryForObject <bool>("DepotIn.has_rows_before", e));
}
public void Update(Model.DepotIn e)
{
this.Update <Model.DepotIn>(e);
}
public bool HasRowsAfter(Model.DepotIn e)
{
return(accessor.HasRowsAfter(e));
}
private void btn_OK_Click(object sender, EventArgs e)
{
this._depotIn = this.bindingSourceDepotIn.Current as Model.DepotIn;
this.DialogResult = DialogResult.OK;
this.Close();
}
public void Delete(Model.DepotIn depotIn)
{
accessor.Delete(depotIn);
}
public void Delete(Model.DepotIn depotIn)
{
sqlmapper.Delete("DepotInDetail.delete_byheader", depotIn.DepotInId);
}
public Model.DepotIn GetNext(Model.DepotIn e)
{
return(sqlmapper.QueryForObject <Model.DepotIn>("DepotIn.get_next", e));
}
public void Insert(Model.DepotIn e)
{
this.Insert <Model.DepotIn>(e);
}
/// <summary>
/// Update a DepotIn.
/// </summary>
public void Update(Model.DepotIn depotIn)
{
validate(depotIn);
try
{
V.BeginTransaction();
depotIn.UpdateTime = DateTime.Now;
accessor.Update(depotIn);
//返回库存
Model.DepotIn depotInOld = this.GetDetails(depotIn);
foreach (Model.DepotInDetail item in depotInOld.Details)
{
item.DepotPosition = depotPositionAccessor.Get(item.DepotPositionId);
//item.Product.StocksQuantity -= item.DepotInQuantity;
//productManager.update(item.Product);
stockAccessor.Decrement(item.DepotPosition, item.Product, item.DepotInQuantity);
productManager.UpdateProduct_Stock(item.Product);
}
//删除详细
depotInDetailsAccessor.Delete(depotIn);
//上次新增時和這次修改時的差值
//double Quantity = 0;
//string DepotInDetailId = "";
//Dictionary<string, Model.DepotInDetail> dic = new Dictionary<string, Book.Model.DepotInDetail>();
//IList<Model.DepotInDetail> templist = depotInDetailsAccessor.GetDetailByDepotInId(depotIn.DepotInId);
//foreach (Model.DepotInDetail item in templist)
//{
// dic.Add(item.DepotInDetailId, item);
//}
//添加详细
foreach (Model.DepotInDetail detail in depotIn.Details)
{
//if (dic.ContainsKey(depotInDetail.DepotInDetailId))
// dic.Remove(depotInDetail.DepotInDetailId);
//if (detail.Product == null || detail.Product.ProductId == null) continue;
detail.DepotPosition = depotPositionAccessor.Get(detail.DepotPositionId);
detail.DepotInId = depotIn.DepotInId;
depotInDetailsAccessor.Insert(detail);
//影响库存
if (detail.Product == null)
{
detail.Product = productAccessor.Get(detail.ProductId);
}
Model.Stock temp = stockAccessor.GetStockByProductIdAndDepotPositionId(detail.ProductId, detail.DepotPositionId);
if (temp != null && temp.StockQuantity1 == 0)
{
temp.Descriptions = detail.Descriptions;
stockAccessor.Update(temp);
}
stockAccessor.Increment(detail.DepotPosition, detail.Product, detail.DepotInQuantity);
productManager.UpdateProduct_Stock(detail.Product);
#region
//Model.DepotInDetail detail = depotInDetailsAccessor.Get(DepotInDetailId);
//不存在，说明是新入库的詳細
//if (detail == null)
//{
// depotInDetail.DepotInId = depotIn.DepotInId;
// depotInDetailsAccessor.Insert(depotInDetail);
// Model.Product product = productAccessor.Get(depotInDetail.Product.ProductId);
// if (product != null)
// {
// product.StocksQuantity += depotInDetail.DepotInQuantity.Value;
// product.UpdateTime = System.DateTime.Now;
// productAccessor.Update(product);
// }
// Model.Stock stock = stockAccessor.GetStockByProductIdAndDepotPositionId(depotInDetail.ProductId, depotInDetail.DepotPositionId);
// if (stock != null)
// {
// stock.StockQuantity1 += depotInDetail.DepotInQuantity.Value;
// stockAccessor.Update(stock);
// }
// else
// {
// stock = new Book.Model.Stock();
// stock.StockId = Guid.NewGuid().ToString();
// stock.DepotPositionId = depotInDetail.DepotPositionId;
// stock.DepotId = depotIn.DepotId;
// stock.Product = depotInDetail.Product;
// stock.ProductId = stock.Product.ProductId;
// stock.StockQuantity1 = depotInDetail.DepotInQuantity.Value;
// stock.StockQuantityOld = 0;
// stockAccessor.Insert(stock);
// }
//}
//else //存在时：有可能产品已经被修改
//{
// depotInDetail.DepotInId = depotIn.DepotInId;
// //从字典中取出上次保存的此入库详细的产品，如果和本次的产品相同
// if (depotInDetail.Product.ProductId == detail.ProductId)
// {
// //判断本次数量和上次数量是否相同，若相同库存表和产品表以及入库详细均不用保存
// if (depotInDetail.DepotInQuantity.Value == detail.DepotInQuantity.Value) continue;
// Quantity = detail.DepotInQuantity.Value - depotInDetail.DepotInQuantity.Value;
// depotInDetail.DepotInId = depotIn.DepotInId;
// depotInDetailsAccessor.Update(depotInDetail);
// Model.Product product = productAccessor.Get(depotInDetail.Product.ProductId);
// if (product != null)
// {
// product.StocksQuantity -= Quantity;
// product.UpdateTime = System.DateTime.Now;
// productAccessor.Update(product);
// }
// Model.Stock stock = stockAccessor.GetStockByProductIdAndDepotPositionId(depotInDetail.ProductId, depotInDetail.DepotPositionId);
// if (stock != null)
// {
// stock.StockQuantity1 -= Quantity;
// stockAccessor.Update(stock);
// }
// else
// {
// stock = new Book.Model.Stock();
// stock.StockId = Guid.NewGuid().ToString();
// stock.DepotPositionId = depotInDetail.DepotPositionId;
// stock.ProductId = depotInDetail.ProductId;
// stock.DepotId = depotIn.DepotId;
// stock.StockQuantity1 = depotInDetail.DepotInQuantity.Value;
// stock.StockQuantityOld = 0;
// stockAccessor.Insert(stock);
// }
// }
// else //产品不同时
// {
// depotInDetailsAccessor.Update(depotInDetail);
// Model.Product tempproduct = productAccessor.Get(detail.ProductId);
// tempproduct.StocksQuantity -= detail.Product.StocksQuantity;
// productAccessor.Update(tempproduct);
// Model.Stock tempStock = stockAccessor.GetStockByProductIdAndDepotPositionId(detail.ProductId, detail.DepotPositionId);
// tempStock.StockQuantity1 -= detail.Product.StocksQuantity;
// stockAccessor.Update(tempStock);
// Model.Product product = productAccessor.Get(depotInDetail.Product.ProductId);
// if (product != null)
// {
// product.StocksQuantity += depotInDetail.DepotInQuantity.Value;
// product.UpdateTime = System.DateTime.Now;
// productAccessor.Update(product);
// }
// Model.Stock stock = stockAccessor.GetStockByProductIdAndDepotPositionId(depotInDetail.ProductId, depotInDetail.DepotPositionId);
// if (stock != null)
// {
// stock.StockQuantity1 += depotInDetail.DepotInQuantity.Value;
// stockAccessor.Update(stock);
// }
// else
// {
// stock = new Book.Model.Stock();
// stock.StockId = Guid.NewGuid().ToString();
// stock.DepotPositionId = depotInDetail.DepotPositionId;
// stock.DepotId = depotIn.DepotId;
// stock.Product = depotInDetail.Product;
// stock.ProductId = stock.Product.ProductId;
// stock.StockQuantity1 = depotInDetail.DepotInQuantity.Value;
// stock.StockQuantityOld = 0;
// stockAccessor.Insert(stock);
// }
// }
// }
#endregion
}
//foreach (string item in dic.Keys)
//{
// Model.DepotInDetail depot = depotInDetailsAccessor.Get(item);
// depotInDetailsAccessor.Delete(item);
// Model.Product tempproduct = productAccessor.Get(depot.ProductId);
// tempproduct.StocksQuantity -= depot.DepotInQuantity;
// productAccessor.Update(tempproduct);
// Model.Stock tempStock = stockAccessor.GetStockByProductIdAndDepotPositionId(depot.ProductId, depot.DepotPositionId);
// tempStock.StockQuantity1 -= depot.DepotInQuantity;
// stockAccessor.Update(tempStock);
//}
V.CommitTransaction();
}
catch
{
V.RollbackTransaction();
throw;
}
}
private void gridView1_DoubleClick(object sender, EventArgs e)
{
this._depotIn = this.bindingSourceDepotIn.Current as Model.DepotIn;
this.DialogResult = DialogResult.OK;
}
public bool HasRowsBefore(Model.DepotIn e)
{
return(accessor.HasRowsBefore(e));
}
