public string CreateDonHangTraNCC() { string PhieuNhapHang, Temp_BH, Number_PC; PhieuNhapHang = "TH_" + 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 PURCHASE_RETURNController().PURCHASE_RETURN_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 barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int rsstock = 1; objinbound.ID = txtPhieuN.Text; objinbound.RefDate = DateTime.Now; objinbound.RefType = 1; //if (lookUpdieukhoan.GetColumnValue("Code").ToString() == "TM") objinbound.RefStatus = 0; //else // objpurchaseorder.RefStatus = 1; objinbound.Status = 0; objinbound.PaymentMethod = new Guid(lookUpthanhtoan.GetColumnValue("ID").ToString()); objinbound.TermID = lookUpdieukhoan.GetColumnValue("Code").ToString(); objinbound.PaymentDate = dateNgayNhap.DateTime; objinbound.DeliveryDate = dateEdithan.DateTime; objinbound.Barcode = txtPhieuN.Text; objinbound.Employee_ID = lookUpNVBH.GetColumnValue("Employee_ID").ToString(); objinbound.Customer_ID = txtMaNPP.Text; objinbound.CustomerName = lookUpTenNPP.Text; objinbound.CustomerAddress = txtDiaChi.Text; objinbound.Currency_ID = "VND"; objinbound.DiscountDate = DateTime.Now; objinbound.User_ID = objuser.UserID; objinbound.Reason = "Đơn Hàng Trả"; objinbound.Active = true; objinbound.ExchangeRate = 1; objinbound.Amount = double.Parse(gridView1.Columns["Amount"].SummaryItem.SummaryValue.ToString()); objinbound.FAmount = double.Parse(gridView1.Columns["Amount"].SummaryItem.SummaryValue.ToString()); PURCHASE_RETURNController test = new PURCHASE_RETURNController(); objinbound_detail.Return_ID = txtPhieuN.Text; objinbound_detail.RefType = 1; { if (gridView1.RowCount > 1) { rsstock = test.PURCHASE_RETURN_Insert(objinbound); for (int i = 0; i < gridView1.RowCount - 1; i++) { int rsstockdetail = -1; objinbound_detail.ID = Guid.NewGuid(); objinbound_detail.Stock_ID = repositoryItemLookUpEdit3.GetDataSourceValue(repositoryItemLookUpEdit3.Columns["Stock_ID"], repositoryItemLookUpEdit3.GetDataSourceRowIndex(repositoryItemLookUpEdit3.Columns["Stock_ID"], gridView1.GetRowCellValue(i, gridView1.Columns[2]).ToString())).ToString(); //objinbound.Stock_ID = lookUpKhoNhap.GetColumnValue("Stock_ID").ToString(); objinbound_detail.Product_ID = gridView1.GetRowCellValue(i, gridView1.Columns[0]).ToString(); objinbound_detail.ProductName = gridView1.GetRowCellValue(i, gridView1.Columns[1]).ToString(); objinbound_detail.Unit = repositoryItemLookUpEdit4.GetDataSourceValue(repositoryItemLookUpEdit4.Columns["Unit_ID"], repositoryItemLookUpEdit4.GetDataSourceRowIndex(repositoryItemLookUpEdit4.Columns["Unit_ID"], gridView1.GetRowCellValue(i, gridView1.Columns[3]).ToString())).ToString(); objinbound_detail.UnitConvert = 1; objinbound_detail.CurrentQty = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString()); objinbound_detail.Quantity = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString()); objinbound_detail.UnitPrice = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[5]).ToString()); objinbound_detail.Amount = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[7]).ToString()); objinbound_detail.QtyConvert = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString()); objinbound_detail.RefPurchase_ID = gridView1.GetRowCellValue(i, gridView1.Columns["PO_ID"]).ToString(); objinbound_detail.RefInward_ID = ""; if (gridView1.GetRowCellValue(i, gridView1.Columns["PN_ID"]).Equals(null)) { objinbound_detail.RefInward_ID = ""; } else { objinbound_detail.RefInward_ID = gridView1.GetRowCellValue(i, gridView1.Columns["PN_ID"]).ToString(); } //objinbound_detail.Active = true; //objpurchaseorder_detail.Batch = "LOT21112013"; objinbound_detail.Description = lookUpTenNPP.Text; rsstockdetail = new PURCHASE_RETURN_DETAILController().PURCHASE_RETURN_DETAIL_Insert(objinbound_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 Hàng Trả" + "-" + txtPhieuN.Text; _sys_log.Reference = txtPhieuN.Text; _sys_log.Module = "Đơn Hàng Trả"; _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 = CreateDonHangTraNCC(); 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"); } }