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