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");
}
}
//private void lookUpMaNPP_EditValueChanged(object sender, EventArgs e)
//{
// PROVIDER objprovider = new PROVIDER();
// objprovider = new PROVIDERController().PROVIDER_Get(lookUpMaNPP.Text);
// lookUpTenNPP.EditValue = lookUpMaNPP.Text;
// txtDiaChi.Text = objprovider.CustomerAddress;
// txtDienThoai.Text = objprovider.Tel;
// memoGhiChu.Text = objprovider.Description;
//}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int rsstock = 1;
objstockinward.ID = txtPhieuN.Text;
objstockinward.RefDate = DateTime.Now;
objstockinward.RefType = 1;
//if (lookUpdieukhoan.GetColumnValue("Code").ToString() == "TM")
objstockinward.RefStatus = 0;
//else
// objstockinward.RefStatus = 1;
objstockinward.PaymentMethod = new Guid(lookUpthanhtoan.GetColumnValue("ID").ToString());
objstockinward.TermID = lookUpdieukhoan.GetColumnValue("Code").ToString();
objstockinward.PaymentDate = dateNgayNhap.DateTime;
objstockinward.DeliveryDate = dateEdithan.DateTime;
objstockinward.Barcode = txtPhieuN.Text;
objstockinward.Employee_ID = lookUpNVBH.GetColumnValue("Employee_ID").ToString();
objstockinward.Customer_ID = txtMaNPP.Text;
objstockinward.CustomerName = lookUpTenNPP.Text;
objstockinward.CustomerAddress = txtDiaChi.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 = txtPhieuN.Text;
objstockinward_detail.RefType = 1;
if (new STOCK_INWARDController().STOCK_INWARD_Exist(txtPhieuN.Text) == txtPhieuN.Text)
{
if (gridView1.RowCount > 1)
{
rsstock = test.STOCK_INWARD_Update(objstockinward, objstockinward.ID);
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
int rsstockdetail = -1;
if (gridView1.GetRowCellValue(i, gridView1.Columns[10]).ToString() != "")
{
objstockinward_detail.ID = new Guid(gridView1.GetRowCellValue(i, gridView1.Columns["ID"]).ToString());
}
else
{
objstockinward_detail.ID = Guid.NewGuid();
}
objstockinward_detail.Stock_ID = repositoryItemLookUpEdit3.GetDataSourceValue(repositoryItemLookUpEdit3.Columns["Stock_ID"], repositoryItemLookUpEdit3.GetDataSourceRowIndex(repositoryItemLookUpEdit3.Columns["Stock_Name"], gridView1.GetRowCellValue(i, gridView1.Columns[2]).ToString())).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 = repositoryItemLookUpEdit4.GetDataSourceValue(repositoryItemLookUpEdit4.Columns["Unit_ID"], repositoryItemLookUpEdit4.GetDataSourceRowIndex(repositoryItemLookUpEdit4.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[7]).ToString());
objstockinward_detail.QtyConvert = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objstockinward_detail.Active = true;
//objstockinward_detail.Batch = "LOT21012014";
objstockinward_detail.Description = lookUpTenNPP.Text;
rsstockdetail = new STOCK_INWARD_DETAILController().STOCK_INWARD_DETAIL_Update(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" + "-" + txtPhieuN.Text;
_sys_log.Reference = txtPhieuN.Text;
_sys_log.Module = "Phiếu Nhập";
_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");
}
}
else
{
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 = repositoryItemLookUpEdit3.GetDataSourceValue(repositoryItemLookUpEdit3.Columns["Stock_ID"], repositoryItemLookUpEdit3.GetDataSourceRowIndex(repositoryItemLookUpEdit3.Columns["Stock_Name"], gridView1.GetRowCellValue(i, gridView1.Columns[2]).ToString())).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 = repositoryItemLookUpEdit4.GetDataSourceValue(repositoryItemLookUpEdit4.Columns["Unit_ID"], repositoryItemLookUpEdit4.GetDataSourceRowIndex(repositoryItemLookUpEdit4.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[7]).ToString());
objstockinward_detail.QtyConvert = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objstockinward_detail.Active = true;
//objstockinward_detail.Batch = "LOT21112013";
objstockinward_detail.Description = lookUpTenNPP.Text;
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 = "Thêm";
_sys_log.Description = "Thêm Phiếu Nhập" + "-" + txtPhieuN.Text;
_sys_log.Reference = txtPhieuN.Text;
_sys_log.Module = "Phiếu Nhập";
_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");
txtPhieuN.Text = CreatePhieuBanHang();
InitLookUp_dieukhoan();
InitLookUp_thanhtoan();
InitLookUpTenKH();
//InitLookUpMaKH();
InitLookUp_NhanVien();
ReadXml_User();
InitLookUpKhoHang();
dtable.Rows.Clear();
}
else
{
XtraMessageBox.Show("Lưu Thất bại", "Thông Báo");
}
}
