public ActionResult add(workcard col, string sysflag, int?page, string orderdata, string orderdata1)
{
ModelState.Clear();
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = " wno";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = " asc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qwno = "", qcustno = "";
if (!string.IsNullOrWhiteSpace(Request["qwno"]))
{
qwno = Request["qwno"].Trim();
ViewBag.qwno = qwno;
}
if (!string.IsNullOrWhiteSpace(Request["qcustno"]))
{
qcustno = Request["qcustno"].Trim();
ViewBag.qcustno = qcustno;
}
NDcommon dbobj = new NDcommon();
if (sysflag != "A")
{
workcard newcol = new workcard();
return(View(newcol));
}
else
{
if (!ModelState.IsValid)
{
return(View(col));
}
else
{
SqlConnection conn = dbobj.get_conn("AitagBill_DBContext");
col.wno = dbobj.get_billno(conn, "W", "", col.comid.ToString(), "", col.adddate.ToString());
conn.Close();
conn.Dispose();
col.wstatus = "0";
col.bmodid = Session["tempid"].ToString();
col.bmoddate = DateTime.Now;
col.ownman = Session["empid"].ToString();
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
con.workcard.Add(col);
con.SaveChanges();
}
//系統LOG檔 //================================================= //
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
string sysrealsid = Request["sysrealsid"].ToString();
string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
string sysnote = "客戶:" + col.custno + "工作卡號:" + col.wno;
dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
sysconn.Close();
sysconn.Dispose();
//=================================================
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/workcard/list' method='post'>";
tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
tmpform += "<input type=hidden id='qwno' name='qwno' value='" + qwno + "'>";
tmpform += "<input type=hidden id='qcustno' name='qcustno' value='" + qcustno + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"<script>alert('新增成功!!');</script>" + tmpform
});
// return RedirectToAction("List");
}
}
}
public ActionResult Edit(workcard chks, string sysflag, int?page, string orderdata, string orderdata1)
{
ModelState.Clear();
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = " wno";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = " asc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qwno = "", qcustno = "";
if (!string.IsNullOrWhiteSpace(Request["qwno"]))
{
qwno = Request["qwno"].Trim();
ViewBag.qwno = qwno;
}
if (!string.IsNullOrWhiteSpace(Request["qcustno"]))
{
qcustno = Request["qcustno"].Trim();
ViewBag.qcustno = qcustno;
}
if (sysflag != "E")
{
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
var data = con.workcard.Where(r => r.wno == chks.wno && r.comid == chks.comid).FirstOrDefault();
workcard eCompanys = con.workcard.Find(chks.wno);
if (eCompanys == null)
{
return(HttpNotFound());
}
return(View(eCompanys));
}
}
else
{
if (!ModelState.IsValid)
{
return(View(chks));
}
else
{
NDcommon dbobj = new NDcommon();
string wno = Request["wno"].ToString();
string comid = Request["comid"].ToString();
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
workcard modobj = con.workcard.Where(r => r.wno == wno && r.comid == comid).FirstOrDefault();
modobj.projno = Request["projno"];
modobj.custno = Request["custno"];
modobj.wktitle = Request["wktitle"];
modobj.wkbudget = int.Parse(Request["wkbudget"]);
modobj.prodno = Request["prodno"];
modobj.pwno = Request["pwno"];
modobj.ifwh = Request["ifwh"];
modobj.whno = Request["whno"];
modobj.prclosedate = DateTime.Parse(Request["prclosedate"].ToString());
modobj.putoffday = int.Parse(Request["putoffday"]);
modobj.closedate = DateTime.Parse(Request["closedate"].ToString());
modobj.closeman = Request["closeman"];
modobj.slyear = int.Parse(Request["slyear"]);
modobj.slmonth = int.Parse(Request["slmonth"]);
modobj.tkyear = int.Parse(Request["tkyear"]);
modobj.tkmonth = int.Parse(Request["tkmonth"]);
modobj.bmodid = Session["empid"].ToString();
modobj.bmoddate = DateTime.Now;
con.Entry(modobj).State = EntityState.Modified;
con.SaveChanges();
con.Dispose();
}
//系統LOG檔
//================================================= //
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
string sysrealsid = Request["sysrealsid"].ToString();
string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
string sysnote = "客戶:" + Request["custno"] + "工作卡號:" + wno;
dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
sysconn.Close();
sysconn.Dispose();
//=================================================
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/workcard/list' method='post'>";
tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
tmpform += "<input type=hidden id='qwno' name='qwno' value='" + qwno + "'>";
tmpform += "<input type=hidden id='qcustno' name='qcustno' value='" + qcustno + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"<script>alert('修改成功!!');</script>" + tmpform
});
// return RedirectToAction("List");
}
}
}
