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