public string CreateDonBanHang()
{
string PhieuNhapHang, Temp_BH, Number_PC;
PhieuNhapHang = "PO_" + objuser.UserName + "_000001"; //Trả về số phiếu thu
Temp_BH = ""; //Số phiếu tạm
Number_PC = ""; // Number phiếu thu
string _stockout_PC = new PURCHASE_ORDERController().PurchaseOrder_Search(objuser.UserName);
Temp_BH = _stockout_PC;
if (Temp_BH != "")
{
Number_PC = Temp_BH.Substring(Temp_BH.Length - 6, 6);
Number_PC = (long.Parse(Number_PC.ToString()) + 1).ToString();
PhieuNhapHang = Number_PC;
for (int i = 0; i < 6 - Number_PC.Length; i++)
{
PhieuNhapHang = "0" + PhieuNhapHang;
}
PhieuNhapHang = Temp_BH.Substring(0, Temp_BH.Length - 6) + PhieuNhapHang;
}
return(PhieuNhapHang);
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int rsstock = 1;
objpurchaseorder.ID = txtPhieuN.Text;
objpurchaseorder.RefDate = DateTime.Now;
objpurchaseorder.RefType = 1;
//if (lookUpdieukhoan.GetColumnValue("Code").ToString() == "TM")
objpurchaseorder.RefStatus = 0;
//else
// objpurchaseorder.RefStatus = 1;
objpurchaseorder.Status = 0;
objpurchaseorder.PaymentMethod = new Guid(lookUpthanhtoan.GetColumnValue("ID").ToString());
objpurchaseorder.TermID = lookUpdieukhoan.GetColumnValue("Code").ToString();
objpurchaseorder.PaymentDate = dateNgayNhap.DateTime;
objpurchaseorder.DeliveryDate = dateEdithan.DateTime;
objpurchaseorder.Barcode = txtPhieuN.Text;
objpurchaseorder.Employee_ID = lookUpNVBH.GetColumnValue("Employee_ID").ToString();
objpurchaseorder.Customer_ID = txtMaNPP.Text;
objpurchaseorder.CustomerName = lookUpTenNPP.Text;
objpurchaseorder.CustomerAddress = txtDiaChi.Text;
objpurchaseorder.Currency_ID = "VND";
objpurchaseorder.DiscountDate = DateTime.Now;
objpurchaseorder.User_ID = objuser.UserID;
objpurchaseorder.Reason = "Đặt Hàng";
objpurchaseorder.Active = true;
objpurchaseorder.ExchangeRate = 1;
objpurchaseorder.Amount = double.Parse(gridView1.Columns["Amount"].SummaryItem.SummaryValue.ToString());
objpurchaseorder.FAmount = double.Parse(gridView1.Columns["Amount"].SummaryItem.SummaryValue.ToString());
PURCHASE_ORDERController test = new PURCHASE_ORDERController();
objpurchaseorder_detail.PURCHASE_ID = txtPhieuN.Text;
objpurchaseorder_detail.RefType = 1;
if (new STOCK_INWARDController().STOCK_INWARD_Exist(txtPhieuN.Text) == txtPhieuN.Text)
{
if (gridView1.RowCount > 1)
{
rsstock = test.PURCHASE_ORDER_Update(objpurchaseorder, objpurchaseorder.ID);
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
int rsstockdetail = -1;
if (gridView1.GetRowCellValue(i, gridView1.Columns[10]).ToString() != "")
{
objpurchaseorder_detail.ID = new Guid(gridView1.GetRowCellValue(i, gridView1.Columns["ID"]).ToString());
}
else
{
objpurchaseorder_detail.ID = Guid.NewGuid();
}
objpurchaseorder_detail.Stock_ID = repositoryItemLookUpEdit3.GetDataSourceValue(repositoryItemLookUpEdit3.Columns["Stock_ID"], repositoryItemLookUpEdit3.GetDataSourceRowIndex(repositoryItemLookUpEdit3.Columns["Stock_Name"], gridView1.GetRowCellValue(i, gridView1.Columns[2]).ToString())).ToString();
objpurchaseorder_detail.Product_ID = gridView1.GetRowCellValue(i, gridView1.Columns[0]).ToString();
objpurchaseorder_detail.ProductName = gridView1.GetRowCellValue(i, gridView1.Columns[1]).ToString();
objpurchaseorder_detail.Unit = repositoryItemLookUpEdit4.GetDataSourceValue(repositoryItemLookUpEdit4.Columns["Unit_ID"], repositoryItemLookUpEdit4.GetDataSourceRowIndex(repositoryItemLookUpEdit4.Columns["Unit_Name"], gridView1.GetRowCellValue(i, gridView1.Columns[3]).ToString())).ToString();
objpurchaseorder_detail.UnitConvert = 1;
objpurchaseorder_detail.CurrentQty = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objpurchaseorder_detail.Quantity = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objpurchaseorder_detail.UnitPrice = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[5]).ToString());
objpurchaseorder_detail.Amount = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[7]).ToString());
objpurchaseorder_detail.QtyConvert = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objpurchaseorder_detail.Active = true;
//objpurchaseorder_detail.Batch = "LOT21012014";
objpurchaseorder_detail.Description = lookUpTenNPP.Text;
rsstockdetail = new PURCHASE_ORDER_DETAILController().PURCHASE_ORDER_DETAIL_Update(objpurchaseorder_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.PURCHASE_ORDER_Insert(objpurchaseorder);
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
int rsstockdetail = -1;
objpurchaseorder_detail.ID = Guid.NewGuid();
objpurchaseorder_detail.Stock_ID = repositoryItemLookUpEdit3.GetDataSourceValue(repositoryItemLookUpEdit3.Columns["Stock_ID"], repositoryItemLookUpEdit3.GetDataSourceRowIndex(repositoryItemLookUpEdit3.Columns["Stock_Name"], gridView1.GetRowCellValue(i, gridView1.Columns[2]).ToString())).ToString();
objpurchaseorder_detail.Product_ID = gridView1.GetRowCellValue(i, gridView1.Columns[0]).ToString();
objpurchaseorder_detail.ProductName = gridView1.GetRowCellValue(i, gridView1.Columns[1]).ToString();
objpurchaseorder_detail.Unit = repositoryItemLookUpEdit4.GetDataSourceValue(repositoryItemLookUpEdit4.Columns["Unit_ID"], repositoryItemLookUpEdit4.GetDataSourceRowIndex(repositoryItemLookUpEdit4.Columns["Unit_Name"], gridView1.GetRowCellValue(i, gridView1.Columns[3]).ToString())).ToString();
objpurchaseorder_detail.UnitConvert = 1;
objpurchaseorder_detail.CurrentQty = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objpurchaseorder_detail.Quantity = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objpurchaseorder_detail.UnitPrice = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[5]).ToString());
objpurchaseorder_detail.Amount = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[7]).ToString());
objpurchaseorder_detail.QtyConvert = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
objpurchaseorder_detail.Active = true;
//objpurchaseorder_detail.Batch = "LOT21112013";
objpurchaseorder_detail.Description = lookUpTenNPP.Text;
rsstockdetail = new PURCHASE_ORDER_DETAILController().PURCHASE_ORDER_DETAIL_Insert(objpurchaseorder_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 Đơn Mua Hàng" + "-" + txtPhieuN.Text;
_sys_log.Reference = txtPhieuN.Text;
_sys_log.Module = "Đơn Đặt Hàng";
_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 = CreateDonBanHang();
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");
}
}
