public POInfoForm(T_PurchaseOrder po) { InitializeComponent(); base.formmode = frmmodetype.edit; this.PO = po; this.okButton.Enabled = false; }
private void gvPO_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (this.gvPO.GetFocusedRow() != null) { T_PurchaseOrder po = this.gvPO.GetFocusedRow() as T_PurchaseOrder; switch (po.postatus) { case (int)POStatus.编制: this.barEdit.Enabled = true; this.barDelete.Enabled = true; this.barbtn1.Enabled = true; this.barbtn2.Enabled = false; break; case (int)POStatus.提交未审批: this.barEdit.Enabled = false; this.barDelete.Enabled = false; this.barbtn1.Enabled = false; this.barbtn2.Enabled = false; break; case (int)POStatus.审批驳回: this.barEdit.Enabled = true; this.barDelete.Enabled = true; this.barbtn1.Enabled = false; this.barbtn2.Enabled = false; break; case (int)POStatus.已审批通过: this.barEdit.Enabled = false; this.barDelete.Enabled = false; this.barbtn1.Enabled = false; if (po.storagestatus == (int)StorageStatus.已入库) { this.barbtn2.Enabled = true; } else { this.barbtn2.Enabled = false; } break; default: this.barEdit.Enabled = false; this.barDelete.Enabled = false; this.barbtn1.Enabled = false; this.barbtn2.Enabled = false; break; } } }
public JsonResult GetPurchaseOrderDetailList(T_PurchaseOrder ObjPurchaseOrder) { var ObjList = new List <T_PurchaseOrderDetails>(); try { ObjList = _blPurchaseOrder.GetPurchaseOrderDetailList(ObjPurchaseOrder); } catch (Exception ex) { throw ex; } return(Json(ObjList, JsonRequestBehavior.AllowGet)); }
protected override void FormLoad() { this.POTypeComboBox.DataSource = EnumTool.GetDataSource(typeof(Enums.POTypes)); this.BuyerComboBox.DataSource = proxy.GetEmployees(); this.ApplicantComboBox.DataSource = proxy.GetEmployees(); this.ApplyDeptComboBox.DataSource = proxy.GetAllDepts(); this.gvUnitEdit.DataSource = proxy.GetUnitList(); this.gvPODetails.CellValueChanged += (o, e) => { if (e.Column.Name == "Quantity" || e.Column.Name == "Price") { CalAmount(); } }; if (formmode == frmmodetype.add) { DateTime now = DateTime.Now; DateTime nextWeek = now.AddDays(7); this.DmdArrivalDateEdit.Text = (new DateTime(nextWeek.Year, nextWeek.Month, nextWeek.Day)).ToString("yyyy-MM-dd"); this.ApplyDateEdit.Text = (new DateTime(now.Year, now.Month, now.Day)).ToString("yyyy-MM-dd"); PO = new T_PurchaseOrder() { pono = proxy.GetLatestPOIndex(), register = Global.UserNo, registerdesc = Global.UserName, arrivalstatus = (int)ArrivalStatus.未到货, paymentstatus = (int)PaymentStatus.未付款, postatus = (int)POStatus.编制, potype = (int)POTypes.销售订单, amount = 0 }; _PODetails = new List <T_PurchaseOrderDetail>(); } else { this.DmdArrivalDateEdit.Text = PO.demandarrivaldate; this.ApplyDateEdit.Text = PO.applydate; _PODetails = proxy.GetPODetailList(PO.pono); } SetData(); }
public T_PurchaseOrder Delete(T_PurchaseOrder ObjPurchaseOrder) { try { using (_objUnitOfWork = new UnitOfWork()) { _objUnitOfWork._T_PurchaseOrder_Repository.Delete(ObjPurchaseOrder.Id); _objUnitOfWork.Save(); } } catch (Exception ex) { throw ex; } return(ObjPurchaseOrder); }
private void gvPO_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (this.gvPO.GetFocusedRow() != null) { T_PurchaseOrder po = this.gvPO.GetFocusedRow() as T_PurchaseOrder; switch (po.postatus) { case (int)POStatus.已审批通过: this.barEdit.Enabled = true; break; default: this.barEdit.Enabled = false; break; } } }
public T_PurchaseOrder GetById(Guid UserId) { var ObjPurchaseOrder = new T_PurchaseOrder(); try { using (_objUnitOfWork = new UnitOfWork()) { ObjPurchaseOrder = _objUnitOfWork._T_PurchaseOrder_Repository.GetById(UserId); } } catch (Exception ex) { throw ex; } return(ObjPurchaseOrder); }
protected override void custom1() { if (this.gvPO.GetFocusedRow() != null) { T_PurchaseOrder po = this.gvPO.GetFocusedRow() as T_PurchaseOrder; if (po.postatus == (int)POStatus.编制) { po.postatus = (int)POStatus.提交未审批; po.sendapprovaldate = DateTime.Now.ToString("yyyy-MM-dd"); _Proxy.UpdatePO(po); this.gvPO.RefreshData(); gvPO_FocusedRowChanged(null, null); } } }
protected override void EditObject() { if (this.gvPO.GetFocusedRow() != null) { T_PurchaseOrder po = this.gvPO.GetFocusedRow() as T_PurchaseOrder; if (po.postatus == (int)POStatus.编制 || po.postatus == (int)POStatus.审批驳回) { var frm = new POInfoForm(Common.frmmodetype.edit, po); refreshFormData(frm); gvPO_FocusedRowChanged(null, null); } else { MessageBox.Show("非编制状态下不能修改采购单"); } } }
public T_PurchaseOrder GetFirstOrDefault(T_PurchaseOrder ObjPurchaseOrder) { var ReturnCompanyObj = new T_PurchaseOrder(); try { using (_objUnitOfWork = new UnitOfWork()) { ReturnCompanyObj = _objUnitOfWork._T_PurchaseOrder_Repository.GetFirstOrDefault(x => x.OrderId == ObjPurchaseOrder.OrderId); } } catch (Exception ex) { throw ex; } return(ReturnCompanyObj); }
public List <T_PurchaseOrder> GetList(T_PurchaseOrder ObjPurchaseOrder) { var ObjList = new List <T_PurchaseOrder>(); try { using (_objUnitOfWork = new UnitOfWork()) { var queryPurchaseOrder = _objUnitOfWork._T_PurchaseOrder_Repository.Query(); var queryPurchaseOrderDetails = _objUnitOfWork._T_PurchaseOrderDetails_Repository.Query(); if (ObjPurchaseOrder.EventDate != null && ObjPurchaseOrder.EventDate.ToString("yyyy-MM-dd") != "0001-01-01") { queryPurchaseOrder = queryPurchaseOrder.Where(x => x.EventDate == ObjPurchaseOrder.EventDate); } if (!string.IsNullOrWhiteSpace(ObjPurchaseOrder.OrderId)) { queryPurchaseOrder = queryPurchaseOrder.Where(x => x.OrderId.Contains(ObjPurchaseOrder.OrderId)); } if (!string.IsNullOrWhiteSpace(ObjPurchaseOrder.BillerName)) { queryPurchaseOrder = queryPurchaseOrder.Where(x => x.BillerName.Contains(ObjPurchaseOrder.BillerName)); } queryPurchaseOrder = queryPurchaseOrder.OrderByDescending(x => x.CreatedDate); var vList = queryPurchaseOrder.ToList(); ObjList = vList.Select(x => new T_PurchaseOrder { Id = x.Id, OrderId = x.OrderId, TotalAmount = queryPurchaseOrderDetails.Where(s => s.PurchaseOrderId == x.Id).ToList().Sum(y => y.BuyingPrice), EventDate = x.EventDate, BillerName = x.BillerName, CreatedDate = x.CreatedDate }).ToList(); } } catch (Exception ex) { throw ex; } return(ObjList); }
private void btnCreate_Click(object sender, EventArgs e) { try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { if (listItem.Items.Count != 0) { T_PurchaseOrder table = new T_PurchaseOrder(); table.purchaseOrderNo = SerialGenerator.GenerateSerialNumber(); table.purchaseOrderDate = DateTime.Now; table.printJobNo = printJob.SelectedItem.ToString().Split(',')[0]; conn.T_PurchaseOrder.InsertOnSubmit(table); conn.SubmitChanges(); //添加POItem表信息 for (int i = 0; i < listItem.Items.Count; i++) { T_POItem ta = new T_POItem(); ta.itemNo = listItem.Items[i].SubItems[0].Text; ta.purchaseOrderNo = table.purchaseOrderNo; ta.quantity = int.Parse(listItem.Items[i].SubItems[2].Text); //减库存 var res = conn.T_Item.Where(o => o.itemNo == ta.itemNo).FirstOrDefault(); res.itemQuantityInStock -= ta.quantity; conn.T_POItem.InsertOnSubmit(ta); } conn.SubmitChanges(); MessageBox.Show("订单生成成功!订单号为:" + table.purchaseOrderNo, "成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("尚未选择印刷耗材,无法生成订单。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { CreateAOrder_Load(null, null); } }
public ActionResult Delete(T_PurchaseOrder ObjPurchaseOrder) { try { if (!string.IsNullOrWhiteSpace(Convert.ToString(ObjPurchaseOrder.Id))) { var vObj = _blPurchaseOrder.GetById(ObjPurchaseOrder.Id); if (vObj != null) { _blPurchaseOrder.Delete(ObjPurchaseOrder); } } } catch (Exception ex) { throw ex; } return(Json(ObjPurchaseOrder)); }
public ActionResult Create(T_PurchaseOrder ObjPurchaseOrder) { try { bool bAnyError = false; if (ModelState.IsValid) { var vNameExists = _blPurchaseOrder.GetFirstOrDefault(ObjPurchaseOrder); if (vNameExists != null) { ViewBag.ErrorMsg = "Order No alreay exists in our system"; bAnyError = true; } if (bAnyError == false) { T_PurchaseOrder _Obj_T_PurchaseOrder = new T_PurchaseOrder() { Id = Guid.NewGuid(), EventDate = Convert.ToDateTime(ObjPurchaseOrder.EventDate), OrderId = ObjPurchaseOrder.OrderId, BillerName = ObjPurchaseOrder.BillerName, CreatedBy = _objAuthentication.UserName, CreatedDate = DateTime.Now }; var vReturnObj = _blPurchaseOrder.Create(_Obj_T_PurchaseOrder); } } else { bAnyError = true; } if (bAnyError) { return(View(ObjPurchaseOrder)); } return(RedirectToAction("Index", "PurchaseOrder")); } catch (Exception ex) { throw ex; } }
protected override void custom2() { if (this.gvPO.GetFocusedRow() != null) { T_PurchaseOrder po = this.gvPO.GetFocusedRow() as T_PurchaseOrder; if ((po.postatus == (int)POStatus.已审批通过 || po.postatus == (int)POStatus.审批驳回) && po.arrivalstatus == (int)ArrivalStatus.未到货) { po.postatus = (int)POStatus.提交未审批; po.approval = string.Empty; po.approvaldesc = string.Empty; po.approvaldate = null; po.approvalremark = string.Empty; _Proxy.UpdatePO(po); this.gvPO.RefreshData(); gvPO_FocusedRowChanged(null, null); } } }
public ActionResult Edit(string Id) { var model = new T_PurchaseOrder(); if (!string.IsNullOrWhiteSpace(Id)) { var vDetails = _blPurchaseOrder.GetById(new Guid(Id)); if (vDetails != null) { model.PurchaseOrderId = vDetails.Id; model.EventDate = Convert.ToDateTime(vDetails.EventDate); model.OrderId = vDetails.OrderId; model.BillerName = vDetails.BillerName; } } M_Items ObjItemsModel = new M_Items(); model.ItemsList = _blItems.GetList(ObjItemsModel).Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).OrderBy(x => x.Text).ToList(); M_Brand objBrandModel = new M_Brand(); model.BrandList = _blBrand.GetList(objBrandModel).Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).OrderBy(x => x.Text).ToList(); M_Guage objGuageModel = new M_Guage(); model.GuageList = _blGuage.GetList(objGuageModel).Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).OrderBy(x => x.Text).ToList(); M_UOM objUomModel = new M_UOM(); model.UomList = _blUOM.GetList(objUomModel).Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).OrderBy(x => x.Text).ToList(); return(View(model)); }
public void ResetPayStatus(string pono) { T_PurchaseOrder po = POList.Find(o => o.pono == pono); if (po != null) { decimal invoiceAmount = POInvoiceList.Where(o => o.pono == pono).Sum(o => o.amount); if (po.amount == invoiceAmount) { po.paymentstatus = (int)PaymentStatus.已付款; } else if (invoiceAmount > 0) { po.paymentstatus = (int)PaymentStatus.部分付款; } else { po.paymentstatus = (int)PaymentStatus.未付款; } } }
protected override void custom1() { if (this.gvPO.GetFocusedRow() != null) { T_PurchaseOrder po = this.gvPO.GetFocusedRow() as T_PurchaseOrder; if (po.postatus == (int)POStatus.提交未审批) { ApprovalWindow window = new ApprovalWindow(); window.FormClosed += (o, e) => { if (window.DialogResult == System.Windows.Forms.DialogResult.OK) { if (window.IsAccept) { po.postatus = (int)POStatus.已审批通过; } else { po.postatus = (int)POStatus.审批驳回; } po.approval = Global.UserNo; po.approvaldesc = Global.UserName; po.approvaldate = DateTime.Now.ToString("yyyy-MM-dd"); po.approvalremark = window.ApprovalRemark; _Proxy.UpdatePO(po); this.gvPO.RefreshData(); gvPO_FocusedRowChanged(null, null); } }; window.ShowDialog(); } } }
public ActionResult Edit(T_PurchaseOrder ObjModel) { try { if (ModelState.IsValid) { var vObj = _blPurchaseOrder.GetById(ObjModel.Id); if (vObj != null) { vObj.EventDate = Convert.ToDateTime(ObjModel.EventDate); vObj.BillerName = ObjModel.BillerName; vObj.ModifyBy = _objAuthentication.UserName; vObj.ModifyDate = DateTime.Now; _blPurchaseOrder.Update(vObj); } } } catch (Exception ex) { throw ex; } return(RedirectToAction("Index", "PurchaseOrder")); }
public void UpdatePO(T_PurchaseOrder po) { POList.Remove(POList.Find(o => o.pono == po.pono)); POList.Add(po); }
public POInfoForm(frmmodetype type, T_PurchaseOrder po) { InitializeComponent(); base.formmode = type; this.PO = po; }
public PurchaseOrder(T_PurchaseOrder purchaseOrder) { _purchaseOrder = purchaseOrder; }
public void UpdatePO(T_PurchaseOrder po) { POList.Remove(POList.Find(o => o.pono == po.pono)); POList.Add(po); }
public POInfoForm(frmmodetype type, T_PurchaseOrder po) { InitializeComponent(); base.formmode = type; this.PO = po; }
public void AddPO(T_PurchaseOrder po) { po.registdate = DateTime.Now; POList.Add(po); }
public void AddPO(T_PurchaseOrder po) { po.registdate = DateTime.Now; POList.Add(po); }
public POPayInfoForm(T_PurchaseOrder po) { InitializeComponent(); this.PO = po; }
public EnteringInfoForm(T_PurchaseOrder po) { InitializeComponent(); base.formmode = frmmodetype.edit; this.PO = po; }
public EnteringInfoForm(T_PurchaseOrder po) { InitializeComponent(); base.formmode = frmmodetype.edit; this.PO = po; }
public void PurchaseOrderDelete(T_PurchaseOrder purchaseOrder) { _purchaseOrders.Remove(purchaseOrder); }
protected override void FormLoad() { this.POTypeComboBox.DataSource = EnumTool.GetDataSource(typeof(Enums.POTypes)); this.BuyerComboBox.DataSource = proxy.GetEmployees(); this.ApplicantComboBox.DataSource = proxy.GetEmployees(); this.ApplyDeptComboBox.DataSource = proxy.GetAllDepts(); this.gvUnitEdit.DataSource = proxy.GetUnitList(); this.gvPODetails.CellValueChanged += (o, e) => { if (e.Column.Name == "Quantity" || e.Column.Name == "Price") { CalAmount(); } }; if (formmode == frmmodetype.add) { DateTime now = DateTime.Now; DateTime nextWeek = now.AddDays(7); this.DmdArrivalDateEdit.Text = (new DateTime(nextWeek.Year, nextWeek.Month, nextWeek.Day)).ToString("yyyy-MM-dd"); this.ApplyDateEdit.Text = (new DateTime(now.Year, now.Month, now.Day)).ToString("yyyy-MM-dd"); PO = new T_PurchaseOrder() { pono = proxy.GetLatestPOIndex(), register = Global.UserNo, registerdesc = Global.UserName, arrivalstatus = (int)ArrivalStatus.未到货, paymentstatus = (int)PaymentStatus.未付款, postatus = (int)POStatus.编制, potype = (int)POTypes.销售订单, amount = 0 }; _PODetails = new List<T_PurchaseOrderDetail>(); } else { this.DmdArrivalDateEdit.Text = PO.demandarrivaldate; this.ApplyDateEdit.Text = PO.applydate; _PODetails = proxy.GetPODetailList(PO.pono); } SetData(); }
public ActionResult ExportToExcel(string Id) { if (string.IsNullOrWhiteSpace(Id)) { return(null); } T_PurchaseOrder ObjItem = new T_PurchaseOrder() { Id = Guid.Parse(Id) }; var vObjList = _blPurchaseOrder.GetPurchaseOrderDetailList(ObjItem); // ExcelPackageF dll Need OfficeOpenXml.ExcelPackage Ep = new OfficeOpenXml.ExcelPackage(); OfficeOpenXml.ExcelWorksheet workSheet = Ep.Workbook.Worksheets.Add("Report"); string sEndColumn = "M1"; workSheet.Cells[string.Format("A1:{0}", sEndColumn)].Style.Font.Bold = true; workSheet.Cells[string.Format("A1:{0}", sEndColumn)].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; workSheet.Cells[string.Format("A1:{0}", sEndColumn)].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.LightSeaGreen); var allCells = workSheet.Cells[string.Format("A1:{0}", sEndColumn)]; var cellFont = allCells.Style.Font; workSheet.Cells["A1"].Value = "Slno"; //sheet["A3:A4"].Merge(); workSheet.Cells["B1"].Value = "Item"; workSheet.Cells["C1"].Value = "Brand"; workSheet.Cells["D1"].Value = "Guage"; workSheet.Cells["E1"].Value = "Quantity"; workSheet.Cells["F1"].Value = "UOM"; workSheet.Cells["G1"].Value = "Buying Rate"; workSheet.Cells["H1"].Value = "Buying Price"; workSheet.Cells["I1"].Value = "Selling Rate"; workSheet.Cells["J1"].Value = "Selling Price"; workSheet.Cells["K1"].Value = "Profit"; workSheet.Cells["L1"].Value = "Remark"; workSheet.Cells["M1"].Value = "Created Dated"; string dateformat = "dd-MM-yyyy"; int row = 2; foreach (var item in vObjList) { //workSheet.Cells[string.Format("A{0}", row)].Value = item.EventDate; //workSheet.Cells[string.Format("A{0}", row)].Style.Numberformat.Format = dateformat; workSheet.Cells[string.Format("A{0}", row)].Value = item.SlNo; workSheet.Cells[string.Format("B{0}", row)].Value = item.ItemsName; workSheet.Cells[string.Format("C{0}", row)].Value = item.BrandName; workSheet.Cells[string.Format("D{0}", row)].Value = item.GuageName; workSheet.Cells[string.Format("E{0}", row)].Value = item.Quantity; workSheet.Cells[string.Format("F{0}", row)].Value = item.UomName; workSheet.Cells[string.Format("G{0}", row)].Value = item.BuyingRate; workSheet.Cells[string.Format("H{0}", row)].Value = item.BuyingPrice; workSheet.Cells[string.Format("I{0}", row)].Value = item.SellingRate; workSheet.Cells[string.Format("J{0}", row)].Value = item.SellingPrice; workSheet.Cells[string.Format("K{0}", row)].Value = item.DifferenceAmount; workSheet.Cells[string.Format("L{0}", row)].Value = item.Remark; workSheet.Cells[string.Format("M{0}", row)].Value = item.CreatedDate; workSheet.Cells[string.Format("M{0}", row)].Style.Numberformat.Format = dateformat; row++; } workSheet.Cells["A:AZ"].AutoFitColumns(); Response.Clear(); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment: filename=" + "Expense.csv" + DateTime.Now.ToString("s")); Response.BinaryWrite(Ep.GetAsByteArray()); Response.End(); return(View()); }
private void InitPO() { POList = new List<T_PurchaseOrder>(); PODetailList = new List<T_PurchaseOrderDetail>(); POInvoiceList = new List<T_Invoice>(); T_PurchaseOrder po = new T_PurchaseOrder() { pono = "201400000", potype = 1, amount = 100, applicant = "0002", applicantdesc = "李四", applydate = "2014-12-03", applydept = "D000", applydeptdesc = "A部门", buyer = "0001", buyerdesc = "张三", arrivalstatus = 0, demandarrivaldate = "2014-12-21", paymentstatus = 0, postatus = 0, registdate = DateTime.Now, register = "0002", registerdesc = "李四", storagestatus = 0 }; POList.Add(po); T_PurchaseOrderDetail poDetailsA = new T_PurchaseOrderDetail() { Id = "ec45994f-be4e-49b5-a472-4ab8b64b4d9e", PONo = po.pono, Price = 10, Quantity = 4, Unit = UnitList[0].Code, Material = StdMatList[0] }; T_PurchaseOrderDetail poDetailsB = new T_PurchaseOrderDetail() { Id = "c0704259-882f-496b-8ba5-e56b979bb71f", PONo = po.pono, Price = 20, Quantity = 3, Unit = UnitList[1].Code, Material = StdMatList[1] }; PODetailList.Add(poDetailsA); PODetailList.Add(poDetailsB); }
public POPayInfoForm(T_PurchaseOrder po) { InitializeComponent(); this.PO = po; }
public void PurchaseOrderAdd(T_PurchaseOrder purchaseOrder) { _purchaseOrders.Push(purchaseOrder); }