private void frmWarehouseIn_Load(object sender, EventArgs e)
{
IList <Product> lstProducts = entities.Product.OrderBy(p => p.ProductName).ToList();
lstProducts.Add(new Product());
ProductName.DataSource = lstProducts;
ProductName.DisplayMember = "ProductName";
ProductName.ValueMember = "Id";
gridOut.EditMode = DataGridViewEditMode.EditOnEnter;
gridOut.AutoGenerateColumns = false;
BindingSource bs = new BindingSource();
if (WarehouseOutId > 0)
{
WarehouseOut objW = entities.WarehouseOut.Find(WarehouseOutId);
if (objW != null)
{
txtRequstedBy.Text = objW.RequestedBy;
txtSendBy.Text = objW.SendBy;
txtAuditBy.Text = objW.AuditBy;
dtBillDate.Value = objW.BillDate;
txtReviewedBy.Text = objW.ReviewedBy;
}
IList <WarehouseOutItem> lst = entities.WarehouseOutItem.Where(item => item.WarehouseOut_Id == WarehouseOutId).ToList();
foreach (var item in lst)
{
var product = entities.Product.Find(item.Product_Id);
item.ProductName = product.ProductName;
item.Brand = product.Brand;
item.Unit = product.Unit;
item.Specification = product.Specification;
}
bs.DataSource = lst;
}
else
{
bs.DataSource = new List <WarehouseOutItem>();
}
bs.AllowNew = true;
bs.AddingNew += bs_AddingNew;
gridOut.DataSource = bs;
dtBillDate.Focus();
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
WarehouseOut objW = new WarehouseOut();
objW.Id = WarehouseOutId;
objW.RequestedBy = txtRequstedBy.Text.Trim();
objW.SendBy = txtSendBy.Text.Trim();
objW.AuditBy = txtAuditBy.Text.Trim();
objW.BillDate = dtBillDate.Value.ClearTime();
objW.ReviewedBy = txtReviewedBy.Text.Trim();
if (objW.SendBy == objW.ReviewedBy)
{
MessageBox.Show("发货人与复核人不能是同一个人！", "提示");
return;
}
IList <WarehouseOutItem> lst = (gridOut.DataSource as BindingSource).DataSource as IList <WarehouseOutItem>;
//IList<WarehouseOutItem> lst = new List<WarehouseOutItem>();
//foreach (DataGridViewRow row in gridOut.Rows)
//{
// WarehouseOutItem item = new WarehouseOutItem();
// item.Id = Convert.ToInt32(row.Cells["Id"].Value);
// item.Product_Id = Convert.ToInt32(row.Cells["ProductName"].Value);
// item.ProductName = Convert.ToString(row.Cells["ProductName"].FormattedValue);
// item.Brand = Convert.ToString(row.Cells["Brand"].Value);
// item.Specification = Convert.ToString(row.Cells["Specification"].Value);
// item.Unit = Convert.ToString(row.Cells["Unit"].Value);
// item.Memo = Convert.ToString(row.Cells["Memo"].Value);
// item.Quantity = Convert.ToDouble(row.Cells["Quantity"].Value);
// item.UnitPrice = Convert.ToDouble(row.Cells["UnitPrice"].Value);
// if (item.Quantity > 0)
// lst.Add(item);
//}
IList <int> needDelItem = new List <int>();
var oldItem = (new Entities()).WarehouseOutItem.Where(item => item.WarehouseOut_Id == WarehouseOutId).ToList();
if (WarehouseOutId > 0)
{
IList <int> lstId = oldItem.Where(item => item.WarehouseOut_Id == WarehouseOutId).Select(d => d.Id).ToList();
needDelItem = lstId.Except(lst.Where(item => item.Id > 0 && item.Quantity > 0 && item.Product_Id > 0).Select(item => item.Id).ToList()).ToList();
}
using (TransactionScope scope = new TransactionScope())
{
entities.Save <WarehouseOut>(objW);
foreach (WarehouseOutItem item in lst)
{
if (item.Quantity <= 0 || item.Product_Id <= 0)
{
continue;
}
item.WarehouseOut_Id = objW.Id;
double changedQty = item.Quantity;
if (item.Id > 0)
{
var temp = oldItem.First(t => t.Id == item.Id);
changedQty = item.Quantity - temp.Quantity;
}
entities.Save <WarehouseOutItem>(item);
var product = entities.Product.Find(item.Product_Id);
product.StockQuantity = product.StockQuantity - changedQty;
entities.Save <Product>(product);
}
if (needDelItem.Count > 0)
{
var delItems = oldItem.Where(tmp => needDelItem.Contains(tmp.Id));
var temp = from t in delItems
group t by t.Product_Id into tt
select new
{
ProductId = tt.Key,
Quantity = tt.Sum(x => x.Quantity)
};
foreach (var t1 in temp)
{
var product = entities.Product.Find(t1.ProductId);
product.StockQuantity = product.StockQuantity + t1.Quantity;
entities.Save <Product>(product);
}
entities.Delete <WarehouseOutItem>(needDelItem);
}
scope.Complete();
}
MessageBox.Show("数据保存成功！", "提示");
this.Close();
}
catch (Exception exp)
{
MessageBox.Show("数据保存失败！", "提示");
LogHelper.WriteLog(LogType.Error, exp, this.GetType());
}
}