public List <STOCK_INWARD> STOCK_INWARD_Search(STOCK_INWARD obj)
{
DataTable dt = new DataTable();
try
{
DataProvider.FillDataTable(DataProvider.ConnectionString, dt, "STOCK_INWARD_Search",
obj.RefDate,
obj.Ref_OrgNo,
obj.RefType,
obj.Barcode,
obj.CustomerName,
obj.CustomerAddress,
obj.Contact,
obj.Reason,
obj.Payment,
obj.ExchangeRate,
obj.Vat,
obj.Amount,
obj.FAmount,
obj.Discount,
obj.Charge,
obj.IsClose,
obj.Description
);
return(MapSTOCK_INWARD(dt));
}
catch (Exception ex)
{
throw ex;
}
}
public int STOCK_INWARD_Update(STOCK_INWARD obj, string ID)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "STOCK_INWARD_Update",
ID,
obj.RefDate,
obj.Ref_OrgNo,
obj.RefType,
obj.PaymentMethod,
obj.TermID,
obj.PaymentDate,
obj.DeliveryDate,
obj.Barcode,
obj.Department_ID,
obj.Employee_ID,
obj.Stock_ID,
obj.Branch_ID,
obj.Contract_ID,
obj.Customer_ID,
obj.CustomerName,
obj.CustomerAddress,
obj.Contact,
obj.Reason,
obj.Payment,
obj.Currency_ID,
obj.ExchangeRate,
obj.Vat,
obj.VatAmount,
obj.Amount,
obj.FAmount,
obj.DiscountDate,
obj.DiscountRate,
obj.Discount,
obj.OtherDiscount,
obj.Charge,
obj.IsClose,
obj.Description,
obj.Sorted,
obj.User_ID,
obj.Active
));
}
catch
{
//throw ex;
return(-1);
}
}
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 List <STOCK_INWARD> MapSTOCK_INWARD(DataTable dt)
{
List <STOCK_INWARD> rs = new List <STOCK_INWARD>();
for (int i = 0; i < dt.Rows.Count; i++)
{
STOCK_INWARD obj = new STOCK_INWARD();
if (dt.Columns.Contains("ID"))
{
obj.ID = dt.Rows[i]["ID"].ToString();
}
if (dt.Columns.Contains("RefDate"))
{
obj.RefDate = DateTime.Parse(dt.Rows[i]["RefDate"].ToString());
}
if (dt.Columns.Contains("Ref_OrgNo"))
{
obj.Ref_OrgNo = dt.Rows[i]["Ref_OrgNo"].ToString();
}
if (dt.Columns.Contains("RefType"))
{
obj.RefType = int.Parse(dt.Rows[i]["RefType"].ToString());
}
if (dt.Columns.Contains("RefStatus"))
{
obj.RefStatus = int.Parse(dt.Rows[i]["RefStatus"].ToString());
}
if (dt.Columns.Contains("PaymentMethod"))
{
obj.PaymentMethod = new Guid(dt.Rows[i]["PaymentMethod"].ToString());
}
if (dt.Columns.Contains("TermID"))
{
obj.TermID = dt.Rows[i]["TermID"].ToString();
}
if (dt.Columns.Contains("PaymentDate"))
{
obj.PaymentDate = DateTime.Parse(dt.Rows[i]["PaymentDate"].ToString());
}
if (dt.Columns.Contains("DeliveryDate"))
{
obj.DeliveryDate = DateTime.Parse(dt.Rows[i]["DeliveryDate"].ToString());
}
if (dt.Columns.Contains("Barcode"))
{
obj.Barcode = dt.Rows[i]["Barcode"].ToString();
}
if (dt.Columns.Contains("Department_ID"))
{
obj.Department_ID = dt.Rows[i]["Department_ID"].ToString();
}
if (dt.Columns.Contains("Employee_ID"))
{
obj.Employee_ID = dt.Rows[i]["Employee_ID"].ToString();
}
if (dt.Columns.Contains("Stock_ID"))
{
obj.Stock_ID = dt.Rows[i]["Stock_ID"].ToString();
}
if (dt.Columns.Contains("Branch_ID"))
{
obj.Branch_ID = dt.Rows[i]["Branch_ID"].ToString();
}
if (dt.Columns.Contains("Contract_ID"))
{
obj.Contract_ID = dt.Rows[i]["Contract_ID"].ToString();
}
if (dt.Columns.Contains("Customer_ID"))
{
obj.Customer_ID = dt.Rows[i]["Customer_ID"].ToString();
}
if (dt.Columns.Contains("CustomerName"))
{
obj.CustomerName = dt.Rows[i]["CustomerName"].ToString();
}
if (dt.Columns.Contains("CustomerAddress"))
{
obj.CustomerAddress = dt.Rows[i]["CustomerAddress"].ToString();
}
if (dt.Columns.Contains("Contact"))
{
obj.Contact = dt.Rows[i]["Contact"].ToString();
}
if (dt.Columns.Contains("Reason"))
{
obj.Reason = dt.Rows[i]["Reason"].ToString();
}
if (dt.Columns.Contains("Payment"))
{
obj.Payment = int.Parse(dt.Rows[i]["Payment"].ToString());
}
if (dt.Columns.Contains("Currency_ID"))
{
obj.Currency_ID = dt.Rows[i]["Currency_ID"].ToString();
}
if (dt.Columns.Contains("ExchangeRate"))
{
obj.ExchangeRate = double.Parse(dt.Rows[i]["ExchangeRate"].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("Amount"))
{
obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString());
}
if (dt.Columns.Contains("FAmount"))
{
obj.FAmount = double.Parse(dt.Rows[i]["FAmount"].ToString());
}
if (dt.Columns.Contains("DiscountDate"))
{
obj.DiscountDate = DateTime.Parse(dt.Rows[i]["DiscountDate"].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("OtherDiscount"))
{
obj.OtherDiscount = double.Parse(dt.Rows[i]["OtherDiscount"].ToString());
}
if (dt.Columns.Contains("IsClose"))
{
obj.IsClose = bool.Parse(dt.Rows[i]["IsClose"].ToString());
}
if (dt.Columns.Contains("Description"))
{
obj.Description = dt.Rows[i]["Description"].ToString();
}
if (dt.Columns.Contains("Sorted"))
{
obj.Sorted = int.Parse(dt.Rows[i]["Sorted"].ToString());
}
if (dt.Columns.Contains("User_ID"))
{
obj.User_ID = dt.Rows[i]["User_ID"].ToString();
}
if (dt.Columns.Contains("Active"))
{
obj.Active = bool.Parse(dt.Rows[i]["Active"].ToString());
}
//if (dt.Columns.Contains("Timestamp"))
//obj.Timestamp = DateTime.Parse(dt.Rows[i]["Timestamp"].ToString());
if (dt.Columns.Contains("LastEditDate"))
{
obj.LastEditDate = DateTime.Parse(dt.Rows[i]["LastEditDate"].ToString());
}
if (dt.Columns.Contains("CreationDate"))
{
obj.CreationDate = DateTime.Parse(dt.Rows[i]["CreationDate"].ToString());
}
rs.Add(obj);
}
return(rs);
}
public UC_PhieuNhapHang(frmNhapHang _nhap, string PhieuNhap)
{
InitializeComponent();
InitLookUpKhoHang();
InitLookUp_dieukhoan();
InitLookUp_thanhtoan();
InitLookUpTenKH();
InitLookUp_NhanVien();
ReadXml_User();
barManager1.SetPopupContextMenu(gridControl1, popupMenu1);
txtPhieuN.Text = PhieuNhap;
main_form = _nhap;
objstockinward = new STOCK_INWARDController().STOCK_INWARD_Get(PhieuNhap);
lookUpdieukhoan.EditValue = objstockinward.TermID;
lookUpthanhtoan.EditValue = new CASH_METHODController().CASH_METHOD_Get(objstockinward.PaymentMethod).Code;
txtMaNPP.EditValue = objstockinward.Customer_ID;
lookUpNVBH.EditValue = objstockinward.Employee_ID;
dateEdithan.DateTime = objstockinward.PaymentDate;
dateNgayNhap.DateTime = objstockinward.DeliveryDate;
gridView1.Invalidate();
gridView1.IndicatorWidth = 35;
repositoryItemGridLookUpEdit1.DataSource = new PRODUCTController().PRODUCT_GetLookupByStock_SALE_Stock(lookUpKhoNhap.GetColumnValue("Stock_ID").ToString());
repositoryItemGridLookUpEdit1.DisplayMember = "Product_ID";
repositoryItemGridLookUpEdit1.ValueMember = "Product_ID";
repositoryItemGridLookUpEdit1.BestFitMode = BestFitMode.BestFitResizePopup;
gridLookUpEdit1.Properties.DataSource = new PRODUCTController().PRODUCT_GetLookupByStock_SALE_Stock(lookUpKhoNhap.GetColumnValue("Stock_ID").ToString());
gridLookUpEdit1.Properties.DisplayMember = "Product_Name";
gridLookUpEdit1.Properties.ValueMember = "Product_ID";
gridLookUpEdit1.Properties.BestFitMode = BestFitMode.None;
repositoryItemLookUpEdit2.Properties.DataSource = new PRODUCTController().PRODUCT_GetLookupByStock_SALE_Stock(lookUpKhoNhap.GetColumnValue("Stock_ID").ToString());
//repositoryItemLookUpEdit2.Properties.DisplayMember = "ProductName";
// The field matching the edit value.
repositoryItemLookUpEdit2.Properties.ValueMember = "Product_Name";
repositoryItemLookUpEdit2.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
// Enable auto completion search mode.
repositoryItemLookUpEdit2.Properties.SearchMode = SearchMode.AutoComplete;
// Specify the column against which to perform the search.
repositoryItemLookUpEdit2.Properties.AutoSearchColumnIndex = 1;
repositoryItemLookUpEdit3.Properties.DataSource = new STOCKController().STOCK_GetList();
//repositoryItemLookUpEdit3.Properties.DisplayMember = "Stock_Name";
// The field matching the edit value.
repositoryItemLookUpEdit3.Properties.ValueMember = "Stock_Name";
repositoryItemLookUpEdit3.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
// Enable auto completion search mode.
repositoryItemLookUpEdit3.Properties.SearchMode = SearchMode.AutoComplete;
// Specify the column against which to perform the search.
repositoryItemLookUpEdit3.Properties.AutoSearchColumnIndex = 1;
repositoryItemLookUpEdit4.Properties.DataSource = new UNITController().UNIT_GetList();
//repositoryItemLookUpEdit4.Properties.DisplayMember = "Unit_Name";//hiển thị
// The field matching the edit value.
repositoryItemLookUpEdit4.Properties.ValueMember = "Unit_Name";//tìm theo
repositoryItemLookUpEdit4.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
// Enable auto completion search mode.
repositoryItemLookUpEdit4.Properties.SearchMode = SearchMode.AutoComplete;
// Specify the column against which to perform the search.
repositoryItemLookUpEdit4.Properties.AutoSearchColumnIndex = 1;
dtable.Columns.Add("Product_ID");
dtable.Columns.Add("ProductName");
dtable.Columns.Add("Stock_Name");
dtable.Columns.Add("Unit_Name");
dtable.Columns.Add("Quantity");
dtable.Columns.Add("UnitPrice");
dtable.Columns.Add("Vat");
dtable.Columns.Add("Amount");
dtable.Columns.Add("Discount");
dtable.Columns.Add("Description");
dtable.Columns.Add("ID");//them vao
dtable = new STOCK_INWARD_DETAILController().STOCK_INWARD_DETAIL_GetList_ByID(PhieuNhap);
gridControl1.DataSource = dtable;
PROVIDER objprovider = new PROVIDER();
objprovider = new PROVIDERController().PROVIDER_Get(objstockinward.Customer_ID);
lookUpTenNPP.EditValue = objstockinward.Customer_ID;
txtDiaChi.Text = objprovider.CustomerAddress;
txtDienThoai.Text = objprovider.Tel;
memoGhiChu.Text = objprovider.Description;
this.lookUpTenNPP.EditValueChanged += new System.EventHandler(this.lookUpTenNPP_EditValueChanged);
repositoryItemGridLookUpEdit1View.RowClick += new DevExpress.XtraGrid.Views.Grid.RowClickEventHandler(repositoryItemGridLookUpEdit1View_click);
splitContainerControl1.PanelVisibility = DevExpress.XtraEditors.SplitPanelVisibility.Panel2;
//repositoryItemTextEdit1.Click += new EventHandler(repositoryItemLookUpEdit1_DoubleClick);
}
