public ActionResult Edit(mediaclass 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 = "mcno"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qmcno = "", qmctitle = ""; if (!string.IsNullOrWhiteSpace(Request["qmcno"])) { qmcno = Request["qmcno"].Trim(); ViewBag.qmcno = qmcno; } if (!string.IsNullOrWhiteSpace(Request["qmctitle"])) { qmctitle = Request["qmctitle"].Trim(); ViewBag.qmctitle = qmctitle; } if (sysflag != "E") { using (AitagBill_DBContext con = new AitagBill_DBContext()) { var data = con.mediaclass.Where(r => r.mcno == chks.mcno).FirstOrDefault(); mediaclass ebillsubjects = con.mediaclass.Find(chks.mcno); if (ebillsubjects == null) { return(HttpNotFound()); } return(View(ebillsubjects)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { using (AitagBill_DBContext con = new AitagBill_DBContext()) { NDcommon dbobj = new NDcommon(); chks.bmodid = Session["tempid"].ToString(); chks.bmoddate = DateTime.Now; con.Entry(chks).State = EntityState.Modified; 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 = "編號:" + chks.mcno + "名稱:" + chks.mctitle; 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='/mediaclass/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='qmcno' name='qmcno' value='" + qmcno + "'>"; tmpform += "<input type=hidden id='qmctitle' name='qmctitle' value='" + qmctitle + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Editdo(string sysflag, int?page, string orderdata, string orderdata1) { page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qpdno = "", qallcomid = "", qvcno = "", qvcsdate = "", qvcedate = ""; if (!string.IsNullOrWhiteSpace(Request["qallcomid"])) { qallcomid = Request["qallcomid"].Trim(); ViewBag.qvendno = qallcomid; } if (!string.IsNullOrWhiteSpace(Request["qvcno"])) { qvcno = Request["qvcno"].Trim(); ViewBag.qvcno = qvcno; } if (!string.IsNullOrWhiteSpace(Request["qvcsdate"])) { qvcsdate = Request["qvcsdate"].Trim(); ViewBag.qvcsdate = qvcsdate; } if (!string.IsNullOrWhiteSpace(Request["qvcedate"])) { qvcedate = Request["qvcedate"].Trim(); ViewBag.qvcedate = qvcedate; } if (!string.IsNullOrWhiteSpace(Request["qpdno"])) { qpdno = Request["qpdno"].Trim(); ViewBag.qpdno = qpdno; } int vcid = int.Parse(Request["vcid"].ToString()); Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); using (AitagBill_DBContext con = new AitagBill_DBContext()) { vend_contract modobj = con.vend_contract.Where(r => r.vcid == vcid).FirstOrDefault(); modobj.vcdate = DateTime.Parse(Request["vcdate"].ToString()); modobj.vcsdate = DateTime.Parse(Request["vcsdate"].ToString()); modobj.vcedate = DateTime.Parse(Request["vcedate"].ToString()); modobj.comid = Request["comid"]; modobj.projno = Request["projno"]; modobj.taxtype = Request["taxtype"]; modobj.vcmoney = int.Parse(Request["vcmoney"]); modobj.vctaxmoney = int.Parse(Request["vctaxmoney"]); modobj.vcallmoney = int.Parse(Request["vcallmoney"]); modobj.vccomment = Request["vccomment"]; modobj.allcomid = Request["allcomid"]; modobj.bmodid = Session["empid"].ToString(); modobj.bmoddate = DateTime.Now; con.Entry(modobj).State = EntityState.Modified; con.SaveChanges(); con.Dispose(); } string tmpform = ""; tmpform = "<body onload=qfr1.submit();>"; tmpform += "<form name='qfr1' action='/custcontract/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='qpdno' name='qpdno' value='" + qpdno + "'>"; tmpform += "<input type=hidden id='qallcomid' name='qallcomid' value='" + qallcomid + "'>"; tmpform += "<input type=hidden id='qvcno' name='qvcno' value='" + qvcno + "'>"; //tmpform += "<input type=hidden id='qpcomment' name='qpcomment' value='" + qpcomment + "'>"; tmpform += "<input type=hidden id='qvcsdate' name='qvcsdate' value='" + qvcsdate + "'>"; tmpform += "<input type=hidden id='qvcedate' name='qvcedate' value='" + qvcedate + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); }
public ActionResult detlistdo(string sysflag, int?page, string orderdata, string orderdata1) { NDcommon dbobj = new NDcommon(); SqlConnection erpconn = dbobj.get_conn("AitagBill_DBContext"); SqlCommand cmd = new SqlCommand(); string wno = "", comid = ""; using (AitagBill_DBContext con = new AitagBill_DBContext()) { page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string sqlstr = ""; string cdel1 = Request["wkdid"]; string wkcdate1 = Request["wkcdate"]; string wkstep1 = Request["wkstep"]; string getman1 = Request["getman"]; string prdate1 = Request["prdate"]; string realdate1 = Request["realdate"]; string worktype1 = Request["worktype"]; string makeitem1 = Request["makeitem"]; string[] cdelarr = cdel1.Split(','); string[] wkcdatedarr = wkcdate1.Split(','); string[] wksteparr = wkstep1.Split(','); string[] getmanarr = getman1.Split(','); string[] prdatearr = prdate1.Split(','); string[] realdatearr = realdate1.Split(','); string[] worktypearr = worktype1.Split(','); string[] makeitemrr = makeitem1.Split(','); wno = Request["wno"].ToString(); comid = Request["comid"].ToString(); for (int i = 0; i < cdelarr.Length; i++) { if (cdelarr[i].Trim() == "") { if (!(wkcdatedarr[i].Trim() == "" && wksteparr[i].Trim() == "")) { workcard_det addobj = new workcard_det(); addobj.comid = comid; addobj.wno = wno; addobj.wkcdate = DateTime.Parse(wkcdatedarr[i].ToString()); addobj.wkstep = wksteparr[i].Trim(); addobj.getman = getmanarr[i].Trim(); addobj.bmodid = Session["empid"].ToString(); addobj.bmoddate = DateTime.Now; if (prdatearr[i].ToString() != "") { addobj.prdate = DateTime.Parse(prdatearr[i].ToString()); } else { addobj.prdate = null; } if (realdatearr[i].ToString() != "") { addobj.realdate = DateTime.Parse(realdatearr[i].ToString()); } else { addobj.realdate = null; } addobj.worktype = worktypearr[i].Trim(); addobj.makeitem = makeitemrr[i].Trim(); con.workcard_det.Add(addobj); con.SaveChanges(); } } else { //修改 int wkdid = int.Parse(cdelarr[i].Trim()); workcard_det modobj = con.workcard_det.Where(r => r.wkdid == wkdid).FirstOrDefault(); modobj.wkcdate = DateTime.Parse(wkcdatedarr[i].ToString()); modobj.wkstep = wksteparr[i].Trim(); modobj.getman = getmanarr[i].Trim(); if (prdatearr[i].ToString() != "") { modobj.prdate = DateTime.Parse(prdatearr[i].ToString()); } else { modobj.prdate = null; } if (realdatearr[i].ToString() != "") { modobj.realdate = DateTime.Parse(realdatearr[i].ToString()); } else { modobj.realdate = null; } modobj.worktype = worktypearr[i].Trim(); modobj.makeitem = makeitemrr[i].Trim(); modobj.bmodid = Session["empid"].ToString(); modobj.bmoddate = DateTime.Now; con.Entry(modobj).State = EntityState.Modified; con.SaveChanges(); } } con.Dispose(); } string tmpform = ""; tmpform = "<body onload=qfr1.submit();>"; tmpform += "<form name='qfr1' action='/workcard/detlist' 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 name='wno' id='wno' value='" + wno + "'>"; tmpform += "<input type=hidden name='comid' id='comid' value='" + comid + "'>"; tmpform += "</body>"; erpconn.Close(); erpconn.Dispose(); return(new ContentResult() { Content = @"" + tmpform }); }
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"); } } }
public ActionResult brlistdo(string sysflag, int?page, string orderdata, string orderdata1) { string vcid = ""; using (AitagBill_DBContext con = new AitagBill_DBContext()) { page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string sqlstr = ""; string cdel1 = Request["bid"]; string bseason1 = Request["bseason"]; string btype1 = Request["btype"]; //string mdno1 = Request["mdno"]; //string mdcomment1 = Request["mdcomment"]; string bsmoney1 = Request["bsmoney"]; string bemoney1 = Request["bemoney"]; string brate1 = Request["brate"]; string bcomment1 = Request["bcomment"]; string[] cdelarr = cdel1.Split(','); string[] bseasonarr = bseason1.Split(','); string[] btypearr = btype1.Split(','); // string[] mdnoarr = mdno1.Split(','); // string[] mdcommentarr = mdcomment1.Split(','); string[] bsmoneyarr = bsmoney1.Split(','); string[] bemoneyarr = bemoney1.Split(','); string[] bratearr = brate1.Split(','); string[] bcommentarr = bcomment1.Split(','); vcid = Request["vcid"].ToString(); int pitemno = 10; for (int i = 0; i < cdelarr.Length; i++) { if (cdelarr[i].Trim() == "") { if (!(bseasonarr[i].Trim() == "")) { bonusrate addobj = new bonusrate(); addobj.vcid = int.Parse(vcid); //addobj.vcno = Request["vcno"].ToString(); addobj.comid = Request["comid"].ToString(); addobj.bseason = bseasonarr[i].Trim(); addobj.btype = btypearr[i].Trim(); // addobj.mdno = mdnoarr[i].Trim(); // addobj.mdcomment = mdcommentarr[i].Trim(); // addobj.vitemno = pitemno; addobj.bsmoney = int.Parse(bsmoneyarr[i].ToString()); addobj.bemoney = int.Parse(bemoneyarr[i].ToString()); addobj.brate = Decimal.Parse(bratearr[i].ToString()); //addobj.vcallmoney = Decimal.Parse(vcallmoneyarr[i].ToString()); addobj.bcomment = bcommentarr[i].Trim(); // addobj.projno = Request["projno"].ToString(); addobj.bmodid = Session["empid"].ToString(); addobj.bmoddate = DateTime.Now; con.bonusrate.Add(addobj); con.SaveChanges(); pitemno = pitemno + 10; } } else { //修改 int bid = int.Parse(cdelarr[i].Trim()); bonusrate modobj = con.bonusrate.Where(r => r.bid == bid).FirstOrDefault(); modobj.comid = Request["comid"].ToString(); modobj.bseason = bseasonarr[i].Trim(); modobj.btype = btypearr[i].Trim(); // addobj.mdno = mdnoarr[i].Trim(); // addobj.mdcomment = mdcommentarr[i].Trim(); // addobj.vitemno = pitemno; modobj.bsmoney = int.Parse(bsmoneyarr[i].ToString()); modobj.bemoney = int.Parse(bemoneyarr[i].ToString()); modobj.brate = Decimal.Parse(bratearr[i].ToString()); //addobj.vcallmoney = Decimal.Parse(vcallmoneyarr[i].ToString()); modobj.bcomment = bcommentarr[i].Trim(); // addobj.projno = Request["projno"].ToString(); modobj.bmodid = Session["empid"].ToString(); modobj.bmoddate = DateTime.Now; modobj.bmodid = Session["empid"].ToString(); modobj.bmoddate = DateTime.Now; con.Entry(modobj).State = EntityState.Modified; con.SaveChanges(); } } con.Dispose(); } string tmpform = ""; tmpform = "<body onload=qfr1.submit();>"; tmpform += "<form name='qfr1' action='/custcontract/brlist' 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 name='vcid' id='vcid' value='" + vcid + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); }
public ActionResult chkEdit(sales_competition 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 = "ccid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qprodtitle = "", qcusttitlename = ""; if (!string.IsNullOrWhiteSpace(Request["qprodtitle"])) { qprodtitle = Request["qprodtitle"].Trim(); ViewBag.qprodtitle = qprodtitle; } if (!string.IsNullOrWhiteSpace(Request["qcusttitlename"])) { qcusttitlename = Request["qcusttitlename"].Trim(); ViewBag.qprodtitle = qcusttitlename; } if (sysflag != "E") { using (AitagBill_DBContext con = new AitagBill_DBContext()) { var data = con.sales_competition.Where(r => r.ccid == chks.ccid).FirstOrDefault(); sales_competition competitionlogs = con.sales_competition.Find(chks.ccid); if (competitionlogs == null) { return(HttpNotFound()); } return(View(competitionlogs)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; NDcommon dbobj = new NDcommon(); sales_competition col = new sales_competition(); using (AitagBill_DBContext con = new AitagBill_DBContext()) { col = con.sales_competition.Find(chks.ccid); } string sysnote = ""; if (dbobj.get_dbnull2(Request["slogstatus"]) == "1") { string tmprolestampid = col.rolestampid; string rolea_1 = col.rolestampidall; string roleall = rolea_1 + "," + tmprolestampid; //'簽核過角色(多個) string billflowid = col.billflowid.ToString(); //找出下一個角色是誰 string tmprole = dbobj.getnewcheck1("G", tmprolestampid, roleall, "", "", billflowid); if (tmprole == "'topman'") { tmprole = ""; } string slogstatus = ""; if (tmprole == "") { slogstatus = "1";// '己簽核 } else { slogstatus = "0"; //'找往上呈核長管級數 //'========================== string tmpflowlevel = ""; using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext")) { tmpflowlevel = dbobj.get_dbvalue(conn, "select billflow from flowlevel where bid=" + billflowid); } if (tmpflowlevel == "") { tmpflowlevel = "0"; } string[] tmpa = rolea_1.Split(','); int tmpacount = tmpa.Length; if (int.Parse(tmpflowlevel) == (tmpacount + 1)) { tmprole = ""; slogstatus = "1"; // '己簽核 } //'========================== } col.slogstatus = slogstatus; col.rolestampid = tmprole; col.rolestampidall = roleall; col.empstampidall = col.empstampidall + ",'" + (string)Session["empid"] + "'"; //'所有人員帳號 col.bmodid = (string)Session["empid"]; col.bmoddate = DateTime.Now; col.billtime = col.billtime + "," + DateTime.Now.ToString(); col.lawcomment = Request["lawcomment"].ToString(); col.fincomment = Request["fincomment"].ToString(); if (tmprole != "") { //寄信 //holidaycheckmainEditMail(col, tmprole); } else { //沒有下一個承辦人 (己通過) ////資料通過後 搬移到cardreallog //battacheckmainEditMove(col); //(己通過) 寄信 //holidaycheckmainEditMailPass(col); } sysnote = "請假單審核通過作業"; } else { col.slogstatus = "2"; col.rback = Request["hback1"].ToString(); col.bmodid = (string)Session["empid"]; col.bmoddate = DateTime.Now; col.billtime = col.billtime + "," + DateTime.Now.ToString(); ////資料通過後 搬移到cardreallog //battacheckmainEditMove(col); //(己通過) 寄信 //holidaycheckmainEditMailBack(col); sysnote = "新業務及競業退回作業"; } col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (AitagBill_DBContext con = new AitagBill_DBContext()) { con.Entry(col).State = EntityState.Modified; 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 = "承辦人:" + chks.empid + "產品名稱:" + chks.prodtitle; 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='/sales_competition/chk' 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='qprodtitle' name='qprodtitle' value='" + qprodtitle + "'>"; tmpform += "<input type=hidden id='qcusttitlename' name='qcusttitlename' value='" + qcusttitlename + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } }
public ActionResult Edit(sales_competition 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 = "ccid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qprodtitle = "", qcusttitlename = ""; if (!string.IsNullOrWhiteSpace(Request["qprodtitle"])) { qprodtitle = Request["qprodtitle"].Trim(); ViewBag.qprodtitle = qprodtitle; } if (!string.IsNullOrWhiteSpace(Request["qcusttitlename"])) { qcusttitlename = Request["qcusttitlename"].Trim(); ViewBag.qprodtitle = qcusttitlename; } if (sysflag != "E") { using (AitagBill_DBContext con = new AitagBill_DBContext()) { var data = con.sales_competition.Where(r => r.ccid == chks.ccid).FirstOrDefault(); if (data == null) { return(HttpNotFound()); } return(View(data)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (AitagBill_DBContext con = new AitagBill_DBContext()) { var chdata = con.sales_competition.Where(r => r.ccid == chks.ccid).FirstOrDefault(); NDcommon dbobj = new NDcommon(); chdata.indclass = Request["indclass"]; chdata.prodtitle = Request["prodtitle"]; chdata.custtitle = Request["custtitle"]; chdata.custlevel1 = Request["custlevel1"]; chdata.custlevel2 = Request["custlevel2"]; chdata.custlevel3 = Request["custlevel3"]; chdata.corpitem = Request["corpitem"]; chdata.getcomtitle = Request["getcomtitle"]; chdata.ifget = Request["ifget"]; chdata.bmodid = Session["tempid"].ToString(); chdata.bmoddate = DateTime.Now; con.Entry(chdata).State = EntityState.Modified; 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 = "承辦人:" + chks.empid + "產品名稱:" + chks.prodtitle; 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='/sales_competition/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='qprodtitle' name='qprodtitle' value='" + qprodtitle + "'>"; tmpform += "<input type=hidden id='qcusttitlename' name='qcusttitlename' value='" + qcusttitlename + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }