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); }