public ActionResult Edit(Webmaincontent chks, HttpPostedFileBase Mcfile1, HttpPostedFileBase Mpic1) { ViewBag.Cid = chks.AC_Cid; ViewBag.Ccid = chks.AC_Ccid; if (ModelState.IsValid) { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); using (Aitag_DBContext con = new Aitag_DBContext()) { chks.AC_Bmodid = Session["tempid"].ToString(); chks.AC_Bmoddate = DateTime.Now; con.Entry(chks).State = EntityState.Modified; //檔案ㄋ int sernonum; if (Mcfile1 != null) { // Uploadfile.SaveAs(Server.MapPath("~/Uploads/") + Apic.FileName); //上傳檔案 //找序號 SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select sno from Serno where sid=1"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { //重新命名,存入檔案 sernonum = int.Parse(dr[0].ToString()) + 1; string fileName = "contente" + sernonum.ToString() + Mcfile1.FileName.Substring(Mcfile1.FileName.IndexOf("."), Mcfile1.FileName.Length - Mcfile1.FileName.IndexOf(".")); Mcfile1.SaveAs(Server.MapPath("~/Upload/") + fileName); chks.AC_Mcfile = fileName; //序號+1後存入 Aitag.Models.NDcommon dbobj1 = new Aitag.Models.NDcommon(); SqlConnection conn1 = dbobj1.get_conn("Aitag_DBContext"); SqlCommand sqlsmd1 = new SqlCommand(); sqlsmd1.Connection = conn1; string sqlstr1 = "UPDATE Serno SET sno ='" + sernonum + "' where sid=1"; sqlsmd1.CommandText = sqlstr1; sqlsmd1.ExecuteReader(); sqlsmd1.Dispose(); conn1.Close(); conn1.Dispose(); } sqlsmd.Dispose(); conn.Close(); conn.Dispose(); } else { chks.AC_Mcfile = chks.AC_Mcfile; } //圖片 if (Mpic1 != null) { // Uploadfile.SaveAs(Server.MapPath("~/Uploads/") + Apic.FileName); //上傳檔案 //找序號 //Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select sno from Serno where sid=1"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { //重新命名,存入檔案 sernonum = int.Parse(dr[0].ToString()) + 1; string fileName = "contente" + sernonum.ToString() + Mpic1.FileName.Substring(Mpic1.FileName.IndexOf("."), Mpic1.FileName.Length - Mpic1.FileName.IndexOf(".")); Mpic1.SaveAs(Server.MapPath("~/Upload/") + fileName); chks.AC_Mpic = fileName; //序號+1後存入 Aitag.Models.NDcommon dbobj1 = new Aitag.Models.NDcommon(); SqlConnection conn1 = dbobj1.get_conn("Aitag_DBContext"); SqlCommand sqlsmd1 = new SqlCommand(); sqlsmd1.Connection = conn1; string sqlstr1 = "UPDATE Serno SET sno ='" + sernonum + "' where sid=1"; sqlsmd1.CommandText = sqlstr1; sqlsmd1.ExecuteReader(); sqlsmd1.Dispose(); conn1.Close(); conn1.Dispose(); } sqlsmd.Dispose(); conn.Close(); conn.Dispose(); } else { chks.AC_Mcfile = chks.AC_Mcfile; } con.SaveChanges(); //系統LOG檔 //================================================= // //Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); string syssubname = "網站管理作業 > 網站內容管理"; string sysnote = "名稱:" + chks.AC_Mctitle; string sysflag = "M"; SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag); sysconn.Close(); sysconn.Dispose(); //================================================= if (chks.AC_Ccid != 0) { return(RedirectToAction("List", new { cid = chks.AC_Ccid, cid1 = chks.AC_Cid })); } else { return(RedirectToAction("List", new { cid = chks.AC_Cid, cid1 = 0 })); } } } return(View(chks)); }
public ActionResult detedit(yearhddet 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 = "hid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qyhid = "", qyhtitle = "", yhid = ""; if (!string.IsNullOrWhiteSpace(Request["qyhid"])) { qyhid = Request["qyhid"].Trim(); ViewBag.qyhid = qyhid; } if (!string.IsNullOrWhiteSpace(Request["qyhtitle"])) { qyhtitle = Request["qyhtitle"].Trim(); ViewBag.qyhtitle = qyhtitle; } if (!string.IsNullOrWhiteSpace(Request["yhid"])) { yhid = Request["yhid"].Trim(); ViewBag.yhid = yhid; } if (sysflag != "Q") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.yearhddet.Where(r => r.hid == chks.hid).FirstOrDefault(); yearhddet eyearholidays = con.yearhddet.Find(chks.hid); if (eyearholidays == null) { return(HttpNotFound()); } return(View(eyearholidays)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); chks.comid = Session["comid"].ToString(); 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.yhid + "假別代碼:" + chks.hdayid + "發放時數:" + chks.allhour; 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='/yearholiday/Edit' 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='qyhid' name='qyhid' value='" + qyhid + "'>"; tmpform += "<input type=hidden id='qyhtitle' name='qyhtitle' value='" + qyhtitle + "'>"; tmpform += "<input type=hidden id='yhid' name='yhid' value='" + yhid + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult logcheckEdit(delholidaylog chks, string sysflag, int?page, string orderdata, string orderdata1, HttpPostedFileBase logopic1) { ModelState.Clear(); page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; if (string.IsNullOrWhiteSpace(orderdata)) { orderdata = "hdellogid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qhlogsdate = "", qhlogedate = ""; if (!string.IsNullOrWhiteSpace(Request["qhlogsdate"])) { qhlogsdate = Request["qhlogsdate"].Trim(); ViewBag.qhlogsdate = qhlogsdate; } if (!string.IsNullOrWhiteSpace(Request["qhlogedate"])) { qhlogedate = Request["qhlogedate"].Trim(); ViewBag.qhlogedate = qhlogedate; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { //var data = con.delholidaylog.Where(r => r.hdellogid == chks.hdellogid).FirstOrDefault(); delholidaylog edelholidaylogs = con.delholidaylog.Find(chks.hdellogid); if (edelholidaylogs == null) { return(HttpNotFound()); } return(View(edelholidaylogs)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { NDcommon dbobj = new NDcommon(); delholidaylog col = new delholidaylog(); string sysnote = ""; using (Aitag_DBContext con = new Aitag_DBContext()) { col = con.delholidaylog.Find(chks.hdellogid); } string hdellogstatus = ""; if (dbobj.get_dbnull2(Request["hdellogstatus"]) == "1") { string tmprolestampid = col.rolestampid; string rolea_1 = col.rolestampidall; string roleall = rolea_1 + "," + tmprolestampid; //'簽核過角色(多個) string billflowid = col.billflowid.ToString(); //找出下一個角色是誰 string tmprole = dbobj.getnewcheck1("H", tmprolestampid, roleall, "0", "", billflowid); if (tmprole == "'topman'") { tmprole = ""; } if (tmprole == "") { hdellogstatus = "1";// '己簽核 } else { hdellogstatus = "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 = ""; hdellogstatus = "1"; // '己簽核 } //'========================== } col.hdellogstatus = hdellogstatus; 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(); if (tmprole != "") { //寄信 logcheckEditMail(col, tmprole); } else { //(己通過) 寄信 logcheckEditMailPass(col); } } else { col.hdellogstatus = "2"; col.delback = chks.delback; col.bmodid = (string)Session["empid"]; col.bmoddate = DateTime.Now; // col.billtime = col.billtime + "," + DateTime.Now.ToString(); //(己通過) 寄信 logcheckEditMailBack(col); } using (Aitag_DBContext con = new Aitag_DBContext()) { con.Entry(col).State = EntityState.Modified; con.SaveChanges(); } if (hdellogstatus == "1") { //銷假時數補回 delholidayMode(col, hdellogstatus); } //系統LOG檔 if (sysnote.Length > 4000) { sysnote = sysnote.Substring(0, 4000); } ////================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); 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='/delholiday/logcheckList' 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='qhlogsdate' name='qhlogsdate' value='" + qhlogsdate + "'>"; tmpform += "<input type=hidden id='qhlogedate' name='qhlogedate' value='" + qhlogedate + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); } } }
private void delholidayMode(delholidaylog col, string hdellogstatus) { NDcommon dbobj = new NDcommon(); using (SqlConnection comconn = dbobj.get_conn("Aitag_DBContext")) { if (col.hdayid == "A04") { #region '請補假部分 resthourlog chks = new resthourlog(); chks.empid = col.empid; chks.rsdeaddate = col.hlogsdate; using (Aitag_DBContext con = new Aitag_DBContext()) { var eresthourlogs = con.resthourlog.Where(r => r.empid == chks.empid && r.rsdeaddate >= chks.rsdeaddate).OrderBy(r => r.rsdeaddate); float tmphloghour = float.Parse(col.hloghour.ToString()); foreach (resthourlog es in eresthourlogs) { var lefthour = es.usehour - tmphloghour; if (lefthour >= 0) { es.usehour -= tmphloghour; using (Aitag_DBContext con2 = new Aitag_DBContext()) { con2.Entry(es).State = EntityState.Modified; con2.SaveChanges(); } if (lefthour == 0) { break; } } else { es.usehour = 0; using (Aitag_DBContext con2 = new Aitag_DBContext()) { con2.Entry(es).State = EntityState.Modified; con2.SaveChanges(); } tmphloghour = float.Parse(Math.Abs(decimal.Parse(lefthour.ToString())).ToString()); } } } #endregion } else { #region 事實發生假部分 string mergehdayid = dbobj.get_dbvalue(comconn, "select * from holidaycode where hdayid = '" + col.hdayid + "'");; string sql = ""; emphdlog chks = new emphdlog(); if (mergehdayid != "") { chks.empid = col.empid; chks.hdayid = mergehdayid; } else { chks.empid = col.empid; chks.hdayid = col.hdayid; } using (Aitag_DBContext con = new Aitag_DBContext()) { emphdlog eemphdlogs = con.emphdlog.Where(r => r.empid == chks.empid && r.hdayid == chks.hdayid).FirstOrDefault(); if (eemphdlogs != null) { eemphdlogs.usehour = eemphdlogs.usehour - decimal.Parse(col.hloghour.ToString()); con.Entry(eemphdlogs).State = EntityState.Modified; con.SaveChanges(); if (eemphdlogs.usehour == 0) { if (mergehdayid != "") { sql = "delete emphdlog where empid = '" + col.empid + "' and hdayid = '" + mergehdayid + "'"; } else { sql = "delete emphdlog where empid = '" + col.empid + "' and hdayid = '" + col.hdayid + "'"; } dbobj.dbexecute("Aitag_DBContext", sql); } } } #endregion } } }
public ActionResult maincontentmod(maincontent 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 = "mcid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qkeyword = "", qsmdate = "", qemdate = "", qmclassid = ""; int mcid = 0; if (!string.IsNullOrWhiteSpace(Request["mcid"])) { mcid = int.Parse(Request["mcid"].Trim()); // ViewBag.qkeyword = qkeyword; } if (!string.IsNullOrWhiteSpace(Request["qkeyword"])) { qkeyword = Request["qkeyword"].Trim(); ViewBag.qkeyword = qkeyword; } if (!string.IsNullOrWhiteSpace(Request["qsmdate"])) { qsmdate = Request["qsmdate"].Trim(); ViewBag.qsmdate = qsmdate; } if (!string.IsNullOrWhiteSpace(Request["qemdate"])) { qemdate = Request["qemdate"].Trim(); ViewBag.qemdate = qemdate; } if (!string.IsNullOrWhiteSpace(Request["qmclassid"])) { qmclassid = Request["qmclassid"].Trim(); ViewBag.qmclassid = qmclassid; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.maincontent.Where(r => r.mcid == mcid).FirstOrDefault(); maincontent eCheckcodes = con.maincontent.Find(mcid); if (eCheckcodes == null) { return(HttpNotFound()); } return(View(eCheckcodes)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (Aitag_DBContext con = new Aitag_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.mcid + "標題名稱:" + 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='/oa/maincontent' 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='qkeyword' name='qkeyword' value='" + qkeyword + "'>"; tmpform += "<input type=hidden id='qsmdate' name='qsmdate' value='" + qsmdate + "'>"; tmpform += "<input type=hidden id='qemdate' name='qemdate' value='" + qemdate + "'>"; tmpform += "<input type=hidden id='qmclassid' name='qmclassid' value='" + qmclassid + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Edit(billflow 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 = "bid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qbillid = "", qcomclass = ""; if (!string.IsNullOrWhiteSpace(Request["qbillid"])) { qbillid = Request["qbillid"].Trim(); ViewBag.qbillid = qbillid; } if (!string.IsNullOrWhiteSpace(Request["qcomclass"])) { qcomclass = Request["qcomclass"].Trim(); ViewBag.qcomclass = qcomclass; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.billflow.Where(r => r.bid == chks.bid).FirstOrDefault(); billflow ebillflows = con.billflow.Find(chks.bid); if (ebillflows == null) { return(HttpNotFound()); } return(View(ebillflows)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldbillid = Request["oldbillid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); chks.addr = Request["addr"]; chks.billtype = Request["billtype"]; 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 tmpbillidname = dbobj.get_dbvalue(sysconn, "select doctitle from docgroup where docid ='" + Request["billid"].Trim() + "' and comid='" + Session["comid"] + "'"); string flowcheck = ""; if (!string.IsNullOrWhiteSpace(Request["flowcheck"].Trim())) { string sqlstr1 = "select * from roleplay where rid in (" + Request["flowcheck"].Trim() + ")"; SqlCommand cmd = new SqlCommand(); cmd.Connection = sysconn; cmd.CommandText = sqlstr1; SqlDataReader dr1 = cmd.ExecuteReader(); while (dr1.Read()) { flowcheck = flowcheck + dr1["roletitle"].ToString() + " → "; } if (flowcheck != "") { flowcheck = flowcheck.Substring(0, flowcheck.Length - 2); } dr1.Close(); dr1.Dispose(); } string sysnote = "呈核單類別:" + tmpbillidname + "<br>呈核人員:" + flowcheck; 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='/billflow/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='qbillid' name='qbillid' value='" + qbillid + "'>"; tmpform += "<input type=hidden id='qcomclass' name='qcomclass' value='" + qcomclass + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Edit(cardreallog 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 = "crid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qdptid = "", qempname = "", qclogsdate = "", qclogedate = ""; if (!string.IsNullOrWhiteSpace(Request["qdptid"])) { qdptid = Request["qdptid"].Trim(); ViewBag.qdptid = qdptid; } if (!string.IsNullOrWhiteSpace(Request["qempname"])) { qempname = Request["qempname"].Trim(); ViewBag.qempname = qempname; } if (!string.IsNullOrWhiteSpace(Request["qclogsdate"])) { qclogsdate = Request["qclogsdate"].Trim(); ViewBag.qclogsdate = qclogsdate; } if (!string.IsNullOrWhiteSpace(Request["qclogedate"])) { qclogedate = Request["qclogedate"].Trim(); ViewBag.qclogedate = qclogedate; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.cardreallog.Where(r => r.crid == chks.crid).FirstOrDefault(); cardreallog ecardreallogs = con.cardreallog.Find(chks.crid); if (ecardreallogs == null) { return(HttpNotFound()); } ViewBag.cloghour = ViewBagcloghour(ecardreallogs.clogtime.Substring(0, 2)); ViewBag.clogmin = ViewBagclogmin(ecardreallogs.clogtime.Substring(2, 2)); return(View(ecardreallogs)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldcrid = Request["oldcrid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); chks.clogtime = Request["cloghour"].Trim() + Request["clogmin"].Trim() + "00"; chks.tmpcardno = Request["cardno"].Trim(); chks.tmpdepid = Request["dptidname"].Trim(); 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.empname + "<br>刷卡日期:" + chks.clogdate + " " + Request["cloghour"].Trim() + Request["clogmin"].Trim() + "的資料"; 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='/cardreallog/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='qdptid' name='qdptid' value='" + qdptid + "'>"; tmpform += "<input type=hidden id='qempname' name='qempname' value='" + qempname + "'>"; tmpform += "<input type=hidden id='qclogsdate' name='qclogsdate' value='" + qclogsdate + "'>"; tmpform += "<input type=hidden id='qclogedate' name='qclogedate' value='" + qclogedate + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Edit(otworklog 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 = "otlogid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qotstatus = "", qempname = "", qdptid = "", otlogsdate = "", otlogedate = ""; if (!string.IsNullOrWhiteSpace(Request["qotstatus"])) { qotstatus = Request["qotstatus"].Trim(); ViewBag.qotstatus = qotstatus; } if (!string.IsNullOrWhiteSpace(Request["qempname"])) { qempname = Request["qempname"].Trim(); ViewBag.qempname = qempname; } if (!string.IsNullOrWhiteSpace(Request["qdptid"])) { qdptid = Request["qdptid"].Trim(); ViewBag.qdptid = qdptid; } if (!string.IsNullOrWhiteSpace(Request["otlogsdate"])) { otlogsdate = Request["otlogsdate"].Trim(); ViewBag.otlogsdate = otlogsdate; } if (!string.IsNullOrWhiteSpace(Request["otlogedate"])) { otlogedate = Request["otlogedate"].Trim(); ViewBag.otlogedate = otlogedate; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.otworklog.Where(r => r.otlogid == chks.otlogid).FirstOrDefault(); otworklog eotworklogs = con.otworklog.Find(chks.otlogid); if (eotworklogs == null) { return(HttpNotFound()); } return(View(eotworklogs)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldotlogid = Request["oldotlogid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); chks.otlogid = int.Parse(Request["otlogid"].Trim()); 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.otlogid + "名稱:" + chks.empname; 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='/otworklog/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='qotstatus' name='qotstatus' value='" + qotstatus + "'>"; tmpform += "<input type=hidden id='qempname' name='qempname' value='" + qempname + "'>"; tmpform += "<input type=hidden id='qdptid' name='qdptid' value='" + qdptid + "'>"; tmpform += "<input type=hidden id='otlogsdate' name='otlogsdate' value='" + otlogsdate + "'>"; tmpform += "<input type=hidden id='otlogedate' name='otlogedate' value='" + otlogedate + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Edit(resthourlog 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 = "rsid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qdptid = "", qempname = "", qaddtype = "", qaddsdate = "", qaddedate = ""; if (!string.IsNullOrWhiteSpace(Request["qdptid"])) { qdptid = Request["qdptid"].Trim(); ViewBag.qdptid = qdptid; } if (!string.IsNullOrWhiteSpace(Request["qempname"])) { qempname = Request["qempname"].Trim(); ViewBag.qempname = qempname; } if (!string.IsNullOrWhiteSpace(Request["qaddtype"])) { qaddtype = Request["qaddtype"].Trim(); ViewBag.qaddtype = qaddtype; } if (!string.IsNullOrWhiteSpace(Request["qaddsdate"])) { qaddsdate = Request["qaddsdate"].Trim(); ViewBag.qaddsdate = qaddsdate; } if (!string.IsNullOrWhiteSpace(Request["qaddedate"])) { qaddedate = Request["qaddedate"].Trim(); ViewBag.qaddedate = qaddedate; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.resthourlog.Where(r => r.rsid == chks.rsid).FirstOrDefault(); resthourlog eresthourlogs = con.resthourlog.Find(chks.rsid); if (eresthourlogs == null) { return(HttpNotFound()); } return(View(eresthourlogs)); } } else { if (!ModelState.IsValid) { string otlogstime = ""; Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext")) { // string tmpwhere = " where osno = '" + Model.osno + "'", otlogstime = "", otlogetime = ""; //otlogstime = dbobj.get_dbvalue(comconn,"select otlogstime from otworklog" + tmpwhere); //otlogetime = dbobj.get_dbvalue(comconn,"select otlogetime from otworklog" + tmpwhere); //if (otlogstime != "" && otlogetime != "") //{ // @:@otlogstime ~ @otlogetime //} } return(View(chks)); } else { //string oldrsid = Request["oldrsid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); chks.rsid = int.Parse(Request["rsid"].Trim()); chks.bmodid = Session["tempid"].ToString(); chks.bmoddate = DateTime.Now; if (chks.inout == null) { chks.inout = ""; } 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.rsid + "名稱:" + chks.empid; 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='/resthourcheck1/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='qdptid' name='qdptid' value='" + qdptid + "'>"; tmpform += "<input type=hidden id='qempname' name='qempname' value='" + qempname + "'>"; tmpform += "<input type=hidden id='qaddtype' name='qaddtype' value='" + qaddtype + "'>"; tmpform += "<input type=hidden id='qaddsdate' name='qaddsdate' value='" + qaddsdate + "'>"; tmpform += "<input type=hidden id='qaddedate' name='qaddedate' value='" + qaddedate + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Edit(empfunction 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 = "funorder"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qempdid = "", funid = ""; if (!string.IsNullOrWhiteSpace(Request["qempdid"])) { qempdid = Request["qempdid"].Trim(); ViewBag.qempdid = qempdid; } if (!string.IsNullOrWhiteSpace(Request["funid"])) { funid = Request["funid"].Trim(); ViewBag.funid = funid; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.empfunction.Where(r => r.empdid == chks.empdid).FirstOrDefault(); empfunction eempfunctions = con.empfunction.Find(chks.empdid); if (eempfunctions == null) { return(HttpNotFound()); } return(View(eempfunctions)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string empdid = Request["empdid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); chks.empid = "99999999"; 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 dbdata = dbobj.get_dbvalue(sysconn, "select chkitem from checkcode where chkclass='08' and chkcode='" + chks.funid + "'"); string sysnote = "共用首頁設定:" + dbdata + "的資料"; 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='/empfunction/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='qempdid' name='qempdid' value='" + qempdid + "'>"; tmpform += "<input type=hidden id='funid' name='funid' value='" + funid + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Edit(Checkcode 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 = "cid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qchkclass = "", qchkitem = ""; if (!string.IsNullOrWhiteSpace(Request["qchkclass"])) { qchkclass = Request["qchkclass"].Trim(); ViewBag.qchkclass = qchkclass; } if (!string.IsNullOrWhiteSpace(Request["qchkitem"])) { qchkitem = Request["qchkitem"].Trim(); ViewBag.qchkitem = qchkitem; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.Checkcode.Where(r => r.cid == chks.cid).FirstOrDefault(); Checkcode eCheckcodes = con.Checkcode.Find(chks.cid); if (eCheckcodes == null) { return(HttpNotFound()); } return(View(eCheckcodes)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (Aitag_DBContext con = new Aitag_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.chkclasstitle + "代碼名稱:" + chks.chkitem; 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='/Checkcode/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='qchkclass' name='qchkclass' value='" + qchkclass + "'>"; tmpform += "<input type=hidden id='qchkitem' name='qchkitem' value='" + qchkitem + "'>"; tmpform += "</form>"; tmpform += "</body>"; string tgourl = "/Checkcode/List?page=" + page + "&qchkclass=" + qchkclass + "&qchkitem=" + qchkitem; return(new ContentResult() { Content = @"<script>alert('修改成功!!');location.href='" + tgourl + "'</script>" }); //return RedirectToAction("List"); } } } }
public ActionResult Edit(Company chks, string sysflag, int?page, string orderdata, string orderdata1, HttpPostedFileBase logopic1) { ModelState.Clear(); page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; if (string.IsNullOrWhiteSpace(orderdata)) { orderdata = "comid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qcomid = "", qcsno = "", qcomtitle = ""; if (!string.IsNullOrWhiteSpace(Request["qcomid"])) { qcomid = Request["qcomid"].Trim(); ViewBag.qcomid = qcomid; } if (!string.IsNullOrWhiteSpace(Request["qcsno"])) { qcsno = Request["qcsno"].Trim(); ViewBag.qcsno = qcsno; } if (!string.IsNullOrWhiteSpace(Request["qcomtitle"])) { qcomtitle = Request["qcomtitle"].Trim(); ViewBag.qcomtitle = qcomtitle; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.Company.Where(r => r.comid == chks.comid).FirstOrDefault(); Company eCompanys = con.Company.Find(chks.comid); if (eCompanys == null) { return(HttpNotFound()); } return(View(eCompanys)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldcomid = Request["oldcomid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); if (logopic1 != null) { if (logopic1.ContentLength > 0) { chks.logopic = Request["comid"] + "." + logopic1.FileName.Substring(logopic1.FileName.Length - 3, 3); logopic1.SaveAs(Server.MapPath("/upload/" + chks.logopic)); } } chks.comid = Request["comid"].Trim(); 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.comid + "名稱:" + chks.comtitle; 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='/Company/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='qcomid' name='qcomid' value='" + qcomid + "'>"; tmpform += "<input type=hidden id='qcsno' name='qcsno' value='" + qcsno + "'>"; tmpform += "<input type=hidden id='qcomtitle' name='qcomtitle' value='" + qcomtitle + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult maincontentadd(maincontent 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 = "mcid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qkeyword = "", qsmdate = "", qemdate = "", qmclassid = ""; if (!string.IsNullOrWhiteSpace(Request["qkeyword"])) { qkeyword = Request["qkeyword"].Trim(); ViewBag.qkeyword = qkeyword; } if (!string.IsNullOrWhiteSpace(Request["qsmdate"])) { qsmdate = Request["qsmdate"].Trim(); ViewBag.qsmdate = qsmdate; } if (!string.IsNullOrWhiteSpace(Request["qemdate"])) { qemdate = Request["qemdate"].Trim(); ViewBag.qemdate = qemdate; } if (!string.IsNullOrWhiteSpace(Request["qmclassid"])) { qmclassid = Request["qmclassid"].Trim(); ViewBag.qmclassid = qmclassid; } if (sysflag != "A") { maincontent newcol = new maincontent(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); Session["mcid"] = ""; SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select * from sublevel1 where sid = '" + Request["realsid"].ToString() + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); string functype = ""; if (dr.Read()) { //取得功能代號 functype = dr["functype"].ToString(); } dr.Close(); dr.Dispose(); conn.Close(); conn.Dispose(); int mcid = 0; maincontent mobj; using (Aitag_DBContext con = new Aitag_DBContext()) { if (Request["mcid"].ToString() != "") { mcid = int.Parse(Request["mcid"].ToString()); //sqlstr = "select * from maincontent where mcid = '" + Request["mcid"].ToString() + "'"; var data = con.maincontent.Where(r => r.mcid == mcid).FirstOrDefault(); mobj = con.maincontent.Find(mcid); } else { mobj = new maincontent(); } mobj.mctype = functype; mobj.mctitle = Request["mctitle"].ToString().Trim(); mobj.mchttp = Request["mchttp"].ToString().Trim(); mobj.mccontent = Request["mccontent"].ToString().Trim(); if (Request["qmcparentid"].ToString() != "") { mobj.mcparentid = int.Parse(Request["mcparentid"].ToString().Trim()); } mobj.mcfiletype = Request["mcfiletype"].ToString().Trim(); mobj.mclassid = int.Parse(Request["mclassid"].ToString().Trim()); // mobj.mcplace = Request["mcplace"].ToString().Trim(); mobj.sid = int.Parse(Request["realsid"].ToString().Trim()); mobj.mdate = DateTime.Parse(Request["mdate"].ToString()); mobj.mclick = 0; //%> //<!--#include file=addprivtbcount.asp--> //<% mobj.ownman = Session["empid"].ToString(); mobj.comid = Session["comid"].ToString(); mobj.bmodid = Session["empid"].ToString(); mobj.bmoddate = DateTime.Now; if (Request["mcid"].ToString() != "") { con.Entry(mobj).State = EntityState.Modified; con.SaveChanges(); } else { con.maincontent.Add(mobj); 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 = "類別:"; 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='/oa/maincontent' 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='qkeyword' name='qkeyword' value='" + qkeyword + "'>"; tmpform += "<input type=hidden id='qsmdate' name='qsmdate' value='" + qsmdate + "'>"; tmpform += "<input type=hidden id='qemdate' name='qemdate' value='" + qemdate + "'>"; tmpform += "<input type=hidden id='qmclassid' name='qmclassid' value='" + qmclassid + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
public ActionResult Edit(schedule chks, string sysflag, HttpPostedFileBase sfile1) { if (!string.IsNullOrWhiteSpace(Request["year1"])) { ViewBag.year1 = Request["year1"].ToString(); } else { ViewBag.year1 = ""; } if (!string.IsNullOrWhiteSpace(Request["month1"])) { ViewBag.month1 = Request["month1"].ToString(); } else { ViewBag.month1 = ""; } if (!string.IsNullOrWhiteSpace(Request["qschdate"])) { ViewBag.qschdate = Request["qschdate"].ToString(); } else { ViewBag.qschdate = ""; } ViewBag.schtype = Request["schtype"].ToString(); ViewBag.Mflag = Request["Mflag"].ToString(); int schid = int.Parse(Request["schid"].ToString()); if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.schedule.Where(r => r.schid == chks.schid).FirstOrDefault(); schedule schedule = con.schedule.Find(chks.schid); if (schedule == null) { return(HttpNotFound()); } return(View(schedule)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { using (Aitag_DBContext con = new Aitag_DBContext()) { schedule modobj = con.schedule.Where(r => r.schid == schid).FirstOrDefault(); string schtitle = Request["schtitle"].ToString().Trim(); schtitle = schtitle.Replace("'", "’"); modobj.schtitle = schtitle; modobj.schcontent = Request["schcontent"].ToString().Trim(); modobj.schplace = Request["schplace"].ToString().Trim(); modobj.schdate = DateTime.Parse(Request["schdate"].ToString()); modobj.schhour = Request["schhour"].ToString().Trim(); modobj.schmin = Request["schmin"].ToString().Trim(); modobj.schehour = Request["schehour"].ToString().Trim(); modobj.schemin = Request["schemin"].ToString().Trim(); #region 傳檔案 if (sfile1 != null) { string sernonum; //重新命名,存入檔案 DateTime myDate = DateTime.Now; sernonum = myDate.ToString("yyyyMMddHHmmss"); string fileName = sfile1.FileName.Substring(sfile1.FileName.IndexOf("."), sfile1.FileName.Length - sfile1.FileName.IndexOf(".")); if (fileName != ".exe" && fileName != ".asp" && fileName != ".aspx" && fileName != ".jsp" && fileName != ".php") { fileName = "F-" + sernonum.ToString() + fileName; sfile1.SaveAs(Server.MapPath("~/Upload/") + fileName); modobj.sfile = fileName; } } #endregion con.Entry(modobj).State = EntityState.Modified; con.SaveChanges(); con.Dispose(); Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "分類:" + Request["tmptitle"].ToString() + "<br>標題:" + schtitle + "<br>日期:" + Request["schdate"].ToString(); 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='/schedule/List' method='post'>"; tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>"; tmpform += "<input type=hidden name='year1' id='year1' value='" + ViewBag.year1 + "'>"; tmpform += "<input type=hidden name='month1' id='month1' value='" + ViewBag.month1 + "'>"; tmpform += "<input type=hidden name='Mflag' id='Mflag' value='" + ViewBag.Mflag + "'>"; tmpform += "<input type=hidden name='qschdate' id='qschdate' value='" + ViewBag.qschdate + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"<script>alert('修改成功!!');</script>" + tmpform }); } } } }
public ActionResult Edit(progparam 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 = "comid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qchkclass = "", qchkitem = ""; string comid = Session["comid"].ToString(); if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.progparam.Where(r => r.comid == comid).FirstOrDefault(); progparam eprogparams = con.progparam.Find(comid); if (eprogparams == null) { eprogparams = new progparam(); // return HttpNotFound(); } //else { return(View(eprogparams)); //} } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); chks.bmodid = Session["tempid"].ToString(); chks.bmoddate = DateTime.Now; chks.comid = Session["comid"].ToString(); con.Entry(chks).State = EntityState.Modified; con.SaveChanges(); //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Session["realsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = ""; //string sysnote = "後來使用者登入後踢掉前面使用者::" + Request["ifkickuser"].ToString() + "<br>POP3 Server:" + Request["pop3server"].ToString() + "<br>SMTP Server:" + Request["smtpserver"].ToString() + "的資料"; 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='/progparam/Edit' method='post'>"; tmpform += "<input type=hidden name='sysflag' id='sysflag' value='A'>"; 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='comid' id='comid' value='" + Session["comid"].ToString() + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Edit(certifystamp 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 = "citemid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qwtrack = "", qcitemid = ""; if (!string.IsNullOrWhiteSpace(Request["qwtrack"])) { qwtrack = Request["qwtrack"].Trim(); ViewBag.qwtrack = qwtrack; } if (!string.IsNullOrWhiteSpace(Request["qcitemid"])) { qcitemid = Request["qcitemid"].Trim(); ViewBag.qcitemid = qcitemid; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.certifystamp.Where(r => r.citemid == chks.citemid).FirstOrDefault(); certifystamp ecertifystamps = con.certifystamp.Find(chks.citemid); if (ecertifystamps == null) { return(HttpNotFound()); } return(View(ecertifystamps)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); //chks.comid = Session["comid"].ToString(); 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.wtrack; 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='/certifystamp/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='qwtrack' name='qwtrack' value='" + qwtrack + "'>"; tmpform += "<input type=hidden id='qcitemid' name='qcitemid' value='" + qcitemid + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Edit(holidayschedule 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 = "wsid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qwstitle = "", qyear = "", qcomid = ""; if (!string.IsNullOrWhiteSpace(Request["qwstitle"])) { qwstitle = Request["qwstitle"].Trim(); ViewBag.qwstitle = qwstitle; } if (!string.IsNullOrWhiteSpace(Request["qyear"])) { qyear = Request["qyear"].Trim(); ViewBag.qyear = qyear; } if (!string.IsNullOrWhiteSpace(Request["qcomid"])) { qcomid = Request["qcomid"].Trim(); ViewBag.qcomid = qcomid; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.holidayschedule.Where(r => r.wsid == chks.wsid).FirstOrDefault(); holidayschedule eholidayschedules = con.holidayschedule.Find(chks.wsid); if (eholidayschedules == null) { return(HttpNotFound()); } return(View(eholidayschedules)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); chks.bmodid = Session["tempid"].ToString(); chks.bmoddate = DateTime.Now; con.Entry(chks).State = EntityState.Modified; con.SaveChanges(); //try //{ // con.SaveChanges(); // con.Dispose(); //} //catch (Exception ex) //{ // throw; //} //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "行事曆標題:" + chks.wstitle + "<br>日期:" + chks.wsdate + "的資料"; 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='/holidayschedule/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='qwstitle' name='qchkclass' value='" + qwstitle + "'>"; tmpform += "<input type=hidden id='qyear' name='qchkitem' value='" + qyear + "'>"; tmpform += "<input type=hidden id='qcomid' name='qchkitem' value='" + qcomid + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult Edit1(sublevel1 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 = "corder"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "asc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qsublevelname1 = ""; string uplink = "0"; if (!string.IsNullOrWhiteSpace(Request["qsublevelname1"])) { qsublevelname1 = Request["qsublevelname1"].Trim(); ViewBag.qsublevelname1 = qsublevelname1; } if (string.IsNullOrWhiteSpace(Request["uplink"])) { uplink = "0"; } else { uplink = Request["uplink"].Trim(); } ViewBag.uplink = uplink; NDcommon dbobj = new NDcommon(); string tmpsid = dbobj.checknumber(Request["tmpsid"]); int tmpsid1 = 0; if (!string.IsNullOrEmpty(tmpsid)) { tmpsid1 = int.Parse(tmpsid); } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.sublevel1.Where(r => r.sid == tmpsid1).FirstOrDefault(); sublevel1 esublevel1s = con.sublevel1.Find(tmpsid1); if (esublevel1s == null) { return(HttpNotFound()); } return(View(esublevel1s)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { chks.sid = tmpsid1; chks.lid = "3"; chks.counttype = "00"; chks.uplink = Int32.Parse(uplink); chks.comid = Session["comid"].ToString(); 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.sublevelname; 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='/sublevel1/List1' 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='uplink' id='uplink' value='" + uplink + "'>"; tmpform += "<input type=hidden id='qsublevelname1' name='qsublevelname1' value='" + qsublevelname1 + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }
public ActionResult subreadwriteedit(subreadwrite 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 = "srwid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "asc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qsublevelname = ""; if (!string.IsNullOrWhiteSpace(Request["qsublevelname"])) { qsublevelname = Request["qsublevelname"].Trim(); ViewBag.qsublevelname = qsublevelname; } NDcommon dbobj = new NDcommon(); string tmpsid = dbobj.checknumber(Request["tmpsid"]); int tmpsid1 = 0; int tmpsrwid = int.Parse(Request["srwid"].ToString()); if (!string.IsNullOrEmpty(tmpsid)) { tmpsid1 = int.Parse(tmpsid); } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.subreadwrite.Where(r => r.srwid == tmpsrwid).FirstOrDefault(); subreadwrite esublevel1s = con.subreadwrite.Find(tmpsrwid); if (esublevel1s == null) { return(HttpNotFound()); } return(View(esublevel1s)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { using (Aitag_DBContext con = new Aitag_DBContext()) { chks.sid = int.Parse(Request["tmpsid"].ToString()); chks.dptgroup = Request["dptgroup"]; chks.empgroup = Request["empgroup"]; chks.comid = Session["comid"].ToString(); 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 = "調整id:" + Request["tmpsid"].ToString() + "的權限"; 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='/sublevel1/subreadwritelist' 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='qsublevelname' name='qsublevelname' value='" + qsublevelname + "'>"; tmpform += "<input type=hidden name='tmpsid' id='tmpsid' value='" + Request["tmpsid"].ToString() + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"<script>alert('修改成功!!');</script>" + tmpform }); } } } }