private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Bạn Muốn Xóa Phiếu Nhập Hàng Này?", "Cảnh Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
if (gridView1.RowCount > 0)
{
string id = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns[0]).ToString();
if ((new DEBTController().DEBT_GetbyRefID(id).Amount >= new DEBTController().DEBT_GetbyRefID(id).Payment) && (new DEBTController().DEBT_GetbyRefID(id).Payment > 0))
{
MessageBox.Show("Không thể xóa phiếu nhập hàng này.\n\n Phiếu này đã được trả tiền.", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
int rs = -1;
int rsdetail = -1;
rs = new STOCK_INWARDController().STOCK_INWARD_Delete(id);
DataTable TableStockdetail = new STOCK_INWARD_DETAILController().STOCK_INWARD_DETAIL_GetList_ByID(id);
//rsdetail = new STOCK_OUTWARD_DETAILController().STOCK_OUTWARD_DETAIL_Delete(new Guid("391fd8bf-0f5f-452e-bdc5-a2303be1c3d2"));
foreach (DataRow datarow in TableStockdetail.Rows)
{
rsdetail = new STOCK_INWARD_DETAILController().STOCK_INWARD_DETAIL_Delete(new Guid(datarow["ID"].ToString()));
}
if ((rs > -1))
{
MessageBox.Show("Phiếu nhập hàng đã được xóa", "Thông báo");
_sys_log.MChine = new MobilityNetwork().GetComputerName();
_sys_log.IP = new MobilityNetwork().GetIP();
_sys_log.UserID = "US000001";
_sys_log.Created = DateTime.Now;
_sys_log.Action_Name = "Xóa";
_sys_log.Description = "Xóa Bảng Kê Phiếu Nhập" + "-" + gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns[0]).ToString();
_sys_log.Reference = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns[0]).ToString();
_sys_log.Module = "Bảng Kê Phiếu Nhập";
_sys_log.Active = true;
SYS_LOGController insertlog = new SYS_LOGController();
insertlog.SYS_LOG_Insert(_sys_log);
}
else
{
MessageBox.Show("Phiếu nhập hàng không được xóa", "Thông báo");
}
}
}
}
}
public string CreatePhieuBanHang()
{
string PhieuNhapHang, Temp_BH, Number_PC;
PhieuNhapHang = "BH_" + 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 STOCK_INWARDController().SaleOrder_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 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");
}
}
