//新增
private void btnSubmit_Click(object sender, EventArgs e)
{
if (txtProcductName.Text == "" || txtProcductName.Text == "請輸入產品名稱" || txtUnitPrice.Text == "" || txtUnitPrice.Text == "請輸入產品單價" || txtQuantity.Text == "" || txtQuantity.Text == "請輸入產品數量" || txtNote.Text == "" || txtNote.Text == "請輸入購買原因")
{
MessageBox.Show("請輸入完整資料!!!");
}
else
{
try
{
this.Cursor = Cursors.WaitCursor;
try
{
var newRequisitionMain = new RequisitionMain
{
ReportID = 2,
EmployeeID = LoginID
};
var newOrderDetail = new OrderDetail
{
Note = txtNote.Text,
ProductName = txtProcductName.Text,
UnitPrice = decimal.Parse(txtUnitPrice.Text),
Quantity = Convert.ToInt32(txtQuantity.Text),
RequisitionMain = newRequisitionMain
};
if (MessageBox.Show("確定新增購案?", "新增購案", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
this.dbContext.RequisitionMains.Add(newRequisitionMain);
this.dbContext.OrderDetails.Add(newOrderDetail);
this.dbContext.SaveChanges();
DataGridViewFormat();
txtProcductName.Text = txtProcductNameExpand;
txtUnitPrice.Text = txtUnitPriceExpand;
txtQuantity.Text = txtQuantityExpand;
txtNote.Text = txtNoteExpand;
}
else
{
txtProcductName.Text = txtProcductNameExpand;
txtUnitPrice.Text = txtUnitPriceExpand;
txtQuantity.Text = txtQuantityExpand;
txtNote.Text = txtNoteExpand;
}
}
finally
{
this.Cursor = Cursors.Default;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public ActionResult DeleteConfirmed(int id)
{
RequisitionMain requisitionMain = db.RequisitionMains.Find(id);
db.RequisitionMains.Remove(requisitionMain);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
OrderDetail orderDetail = db.OrderDetails.Find(id);
RequisitionMain requisitionMain = db.RequisitionMains.Find(orderDetail.OrderID);
Approval approval = db.Approvals.Find(orderDetail.OrderID);
db.OrderDetails.Remove(orderDetail);
db.RequisitionMains.Remove(requisitionMain);
db.Approvals.Remove(approval);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "OrderID,ReportID,EmployeeID,RequisitionDate,ApprovalStatusID")] RequisitionMain requisitionMain)
{
if (ModelState.IsValid)
{
db.Entry(requisitionMain).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ApprovalStatusID = new SelectList(db.ApprovalStatus, "ApprovalStatusID", "StatusName", requisitionMain.ApprovalStatusID);
ViewBag.EmployeeID = new SelectList(db.Employees, "employeeID", "EmployeeName", requisitionMain.EmployeeID);
ViewBag.ReportID = new SelectList(db.ReportCategories, "ReportID", "ReportName", requisitionMain.ReportID);
return(View(requisitionMain));
}
// GET: RequisitionMains/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RequisitionMain requisitionMain = db.RequisitionMains.Find(id);
if (requisitionMain == null)
{
return(HttpNotFound());
}
return(View(requisitionMain));
}
public ActionResult Delete(int id)
{
OrderDetail orderDetail = db.OrderDetails.Find(id);
RequisitionMain requisitionMain = db.RequisitionMains.Find(orderDetail.OrderID);
Approval approval = db.Approvals.Find(orderDetail.OrderID);
db.OrderDetails.Remove(orderDetail);
db.RequisitionMains.Remove(requisitionMain);
db.Approvals.Remove(approval);
db.SaveChanges();
return(Json(new { success = true, message = "刪除成功" }, JsonRequestBehavior.AllowGet));
}
// GET: RequisitionMains/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RequisitionMain requisitionMain = db.RequisitionMains.Find(id);
if (requisitionMain == null)
{
return(HttpNotFound());
}
ViewBag.ApprovalStatusID = new SelectList(db.ApprovalStatus, "ApprovalStatusID", "StatusName", requisitionMain.ApprovalStatusID);
ViewBag.EmployeeID = new SelectList(db.Employees, "employeeID", "EmployeeName", requisitionMain.EmployeeID);
ViewBag.ReportID = new SelectList(db.ReportCategories, "ReportID", "ReportName", requisitionMain.ReportID);
return(View(requisitionMain));
}
public ActionResult ApprovalReject(RequisitionMain requisitionMain)
{
if (requisitionMain.OrderID == 0)
{
return(View());
}
else
{
var approval = db.Approvals.Find(requisitionMain.OrderID);
if (approval.FirstSignerID == EmployeeDetail.EmployeeID)
{
requisitionMain.ApprovalStatusID = 1;
approval.FirstSignDate = DateTime.Now;
approval.FirstSignStatus = "駁回簽核";
}
if (approval.SecondSignerID == EmployeeDetail.EmployeeID && approval.FirstSignStatus == "已審核")
{
requisitionMain.ApprovalStatusID = 1;
approval.SecondSignDate = DateTime.Now;
approval.SecondSignStatus = "駁回簽核";
}
if (approval.ThirdSignerID == EmployeeDetail.EmployeeID && approval.SecondSignStatus == "已審核")
{
requisitionMain.ApprovalStatusID = 1;
approval.ThirdSignDate = DateTime.Now;
approval.ThirdSignStatus = "駁回簽核";
}
if (approval.FourthSignerID == EmployeeDetail.EmployeeID && approval.ThirdSignStatus == "已審核")
{
requisitionMain.ApprovalStatusID = 1;
approval.ForthSignDate = DateTime.Now;
approval.FourthSignStatus = "駁回簽核";
}
db.Entry(requisitionMain).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "填寫成功" }, JsonRequestBehavior.AllowGet));
}
}
