public int STOCK_INWARD_DETAIL_Update(STOCK_INWARD_DETAIL obj)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "STOCK_INWARD_DETAIL_Update",
obj.ID,
obj.Inward_ID,
obj.Product_ID,
obj.ProductName,
obj.RefType,
obj.Stock_ID,
obj.Unit,
obj.UnitConvert,
obj.Vat,
obj.VatAmount,
obj.CurrentQty,
obj.Quantity,
obj.UnitPrice,
obj.Amount,
obj.QtyConvert,
obj.DiscountRate,
obj.Discount,
obj.Charge,
obj.Limit,
obj.Width,
obj.Height,
obj.Orgin,
obj.Size,
obj.Color,
obj.Batch,
obj.Serial,
obj.ChassyNo,
obj.IME,
obj.Location,
obj.StoreID,
obj.Description,
obj.Sorted,
obj.Active
));
}
catch
{
//throw ex;
return(-1);
}
}
private List <STOCK_INWARD_DETAIL> MapSTOCK_INWARD_DETAIL(DataTable dt)
{
List <STOCK_INWARD_DETAIL> rs = new List <STOCK_INWARD_DETAIL>();
for (int i = 0; i < dt.Rows.Count; i++)
{
STOCK_INWARD_DETAIL obj = new STOCK_INWARD_DETAIL();
if (dt.Columns.Contains("ID"))
{
obj.ID = new Guid(dt.Rows[i]["ID"].ToString().Trim());
}
if (dt.Columns.Contains("Inward_ID"))
{
obj.Inward_ID = dt.Rows[i]["Inward_ID"].ToString();
}
if (dt.Columns.Contains("Product_ID"))
{
obj.Product_ID = dt.Rows[i]["Product_ID"].ToString();
}
if (dt.Columns.Contains("ProductName"))
{
obj.ProductName = dt.Rows[i]["ProductName"].ToString();
}
if (dt.Columns.Contains("RefType"))
{
obj.RefType = int.Parse(dt.Rows[i]["RefType"].ToString());
}
if (dt.Columns.Contains("Stock_ID"))
{
obj.Stock_ID = dt.Rows[i]["Stock_ID"].ToString();
}
if (dt.Columns.Contains("Unit"))
{
obj.Unit = dt.Rows[i]["Unit"].ToString();
}
if (dt.Columns.Contains("UnitConvert"))
{
obj.UnitConvert = double.Parse(dt.Rows[i]["UnitConvert"].ToString());
}
if (dt.Columns.Contains("Vat"))
{
obj.Vat = int.Parse(dt.Rows[i]["Vat"].ToString());
}
if (dt.Columns.Contains("VatAmount"))
{
obj.VatAmount = double.Parse(dt.Rows[i]["VatAmount"].ToString());
}
if (dt.Columns.Contains("CurrentQty"))
{
obj.CurrentQty = double.Parse(dt.Rows[i]["CurrentQty"].ToString());
}
if (dt.Columns.Contains("Quantity"))
{
obj.Quantity = double.Parse(dt.Rows[i]["Quantity"].ToString());
}
if (dt.Columns.Contains("UnitPrice"))
{
obj.UnitPrice = double.Parse(dt.Rows[i]["UnitPrice"].ToString());
}
if (dt.Columns.Contains("Amount"))
{
obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString());
}
if (dt.Columns.Contains("QtyConvert"))
{
obj.QtyConvert = double.Parse(dt.Rows[i]["QtyConvert"].ToString());
}
if (dt.Columns.Contains("DiscountRate"))
{
obj.DiscountRate = double.Parse(dt.Rows[i]["DiscountRate"].ToString());
}
if (dt.Columns.Contains("Discount"))
{
obj.Discount = double.Parse(dt.Rows[i]["Discount"].ToString());
}
if (dt.Columns.Contains("Charge"))
{
obj.Charge = double.Parse(dt.Rows[i]["Charge"].ToString());
}
if (dt.Columns.Contains("Limit"))
{
obj.Limit = DateTime.Parse(dt.Rows[i]["Limit"].ToString());
}
if (dt.Columns.Contains("Width"))
{
obj.Width = double.Parse(dt.Rows[i]["Width"].ToString());
}
if (dt.Columns.Contains("Height"))
{
obj.Height = double.Parse(dt.Rows[i]["Height"].ToString());
}
if (dt.Columns.Contains("Orgin"))
{
obj.Orgin = dt.Rows[i]["Orgin"].ToString();
}
if (dt.Columns.Contains("Size"))
{
obj.Size = dt.Rows[i]["Size"].ToString();
}
if (dt.Columns.Contains("Color"))
{
obj.Color = dt.Rows[i]["Color"].ToString();
}
if (dt.Columns.Contains("Batch"))
{
obj.Batch = dt.Rows[i]["Batch"].ToString();
}
if (dt.Columns.Contains("Serial"))
{
obj.Serial = dt.Rows[i]["Serial"].ToString();
}
if (dt.Columns.Contains("ChassyNo"))
{
obj.ChassyNo = dt.Rows[i]["ChassyNo"].ToString();
}
if (dt.Columns.Contains("IME"))
{
obj.IME = dt.Rows[i]["IME"].ToString();
}
if (dt.Columns.Contains("Location"))
{
obj.Location = dt.Rows[i]["Location"].ToString();
}
if (dt.Columns.Contains("StoreID"))
{
obj.StoreID = long.Parse(dt.Rows[i]["StoreID"].ToString());
}
if (dt.Columns.Contains("Sorted"))
{
obj.Sorted = long.Parse(dt.Rows[i]["Sorted"].ToString());
}
if (dt.Columns.Contains("Active"))
{
obj.Active = bool.Parse(dt.Rows[i]["Active"].ToString());
}
rs.Add(obj);
}
return(rs);
}
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int rsstock = 1;
STOCK_INWARD objstockinward = new STOCK_INWARD();
STOCK_INWARD_DETAIL objstockinward_detail = new STOCK_INWARD_DETAIL();
objstockinward.ID = txtPhieuDK.Text;
objstockinward.RefDate = DateTime.Now;
objstockinward.RefType = 0;
//if (lookUpdieukhoan.GetColumnValue("Code").ToString() == "TM")
objstockinward.RefStatus = 0;
//else
// objstockinward.RefStatus = 1;
objstockinward.PaymentMethod = new Guid("11111111-1111-1111-1111-111111111111");
objstockinward.TermID = "";
objstockinward.PaymentDate = dateNgayTao.DateTime;
objstockinward.DeliveryDate = dateNgayTao.DateTime;
objstockinward.Barcode = txtPhieuDK.Text;
objstockinward.Currency_ID = "VND";
objstockinward.DiscountDate = DateTime.Now;
objstockinward.User_ID = objuser.UserID;
objstockinward.Reason = "Nhập Kho";
objstockinward.Active = true;
objstockinward.ExchangeRate = 1;
objstockinward.Amount = double.Parse(gridView1.Columns["Amount"].SummaryItem.SummaryValue.ToString());
objstockinward.FAmount = double.Parse(gridView1.Columns["Amount"].SummaryItem.SummaryValue.ToString());
STOCK_INWARDController test = new STOCK_INWARDController();
objstockinward_detail.Inward_ID = txtPhieuDK.Text;
objstockinward_detail.RefType = 1;
if (new STOCK_INWARDController().STOCK_INWARD_Exist(txtPhieuDK.Text) != txtPhieuDK.Text)
{
if (gridView1.RowCount > 1)
{
rsstock = test.STOCK_INWARD_Insert(objstockinward);
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
int rsstockdetail = -1;
objstockinward_detail.ID = Guid.NewGuid();
objstockinward_detail.Stock_ID = lookUpKhoNhap.GetColumnValue("Stock_ID").ToString();
objstockinward_detail.Product_ID = gridView1.GetRowCellValue(i, gridView1.Columns[0]).ToString();
objstockinward_detail.ProductName = gridView1.GetRowCellValue(i, gridView1.Columns[1]).ToString();
objstockinward_detail.Unit = repositoryItemLookUpEdit1.GetDataSourceValue(repositoryItemLookUpEdit1.Columns["Unit_ID"], repositoryItemLookUpEdit1.GetDataSourceRowIndex(repositoryItemLookUpEdit1.Columns["Unit_Name"], gridView1.GetRowCellValue(i, gridView1.Columns[3]).ToString())).ToString();
objstockinward_detail.UnitConvert = 1;
objstockinward_detail.CurrentQty = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objstockinward_detail.Quantity = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objstockinward_detail.UnitPrice = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[5]).ToString());
objstockinward_detail.Amount = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[6]).ToString());
objstockinward_detail.QtyConvert = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objstockinward_detail.Active = true;
//objstockinward_detail.Batch = "LOT21012014";
objstockinward_detail.Description = "";
rsstockdetail = new STOCK_INWARD_DETAILController().STOCK_INWARD_DETAIL_Insert(objstockinward_detail);
if (rsstockdetail == -1)
{
XtraMessageBox.Show("Lưu Thất Bại", "Thông Báo");
break;
}
}
_sys_log.MChine = new MobilityNetwork().GetComputerName();
_sys_log.IP = new MobilityNetwork().GetIP();
_sys_log.UserID = objuser.UserID;
_sys_log.Created = DateTime.Now;
_sys_log.Action_Name = "Cập Nhật";
_sys_log.Description = "Cập Nhật Phiếu Nhập" + "-" + txtPhieuDK.Text;
_sys_log.Reference = txtPhieuDK.Text;
_sys_log.Module = "Nhập Kho Đầu Kỳ";
_sys_log.Active = true;
SYS_LOGController insertlog = new SYS_LOGController();
insertlog.SYS_LOG_Insert(_sys_log);
}
else
{
XtraMessageBox.Show("Chưa nhập hàng hóa", "Thông Báo");
}
}
if (rsstock > -1)
{
XtraMessageBox.Show("Lưu Thành công", "Thông Báo");
}
else
{
XtraMessageBox.Show("Lưu Thất bại", "Thông Báo");
}
}
