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