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 }); } } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // holidaycode col = new holidaycode(); // return View(col); //} //[HttpPost] public ActionResult add(holidaycode 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 = "hdayid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qhdayid = "", qhdaytitle = ""; if (!string.IsNullOrWhiteSpace(Request["qhdayid"])) { qhdayid = Request["qhdayid"].Trim(); ViewBag.qhdayid = qhdayid; } if (!string.IsNullOrWhiteSpace(Request["qhdaytitle"])) { qhdaytitle = Request["qhdaytitle"].Trim(); ViewBag.qhdaytitle = qhdaytitle; } if (sysflag != "A") { holidaycode newcol = new holidaycode(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { 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 hdayid from holidaycode where hdayid = '" + col.hdayid + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "假勤代碼重覆,請重新填寫!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); col.htype = Request["htype"]; col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.holidaycode.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.hdayid + "假勤名稱:" + col.hdaytitle; 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='/holidaycode/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='qhdayid' name='qhdayid' value='" + qhdayid + "'>"; tmpform += "<input type=hidden id='qhdaytitle' name='qhdaytitle' value='" + qhdaytitle + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // Checkcode col = new Checkcode(); // return View(col); //} //[HttpPost] public ActionResult add(Checkcode 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 = "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 != "A") { Checkcode newcol = new Checkcode(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { 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 cid from Checkcode where chkclass = '" + col.chkclass + "' and chkcode = '" + col.chkcode + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "共用代碼重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); //密碼加密 //col.emppasswd = dbobj.Encrypt(col.emppasswd); //col.chkclass = col.emppasswd; //col.baddid = Session["tempid"].ToString(); col.bmodid = Session["tempid"].ToString(); //col.badddate = DateTime.Now; col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.Checkcode.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.chkclasstitle + "代碼名稱:" + col.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>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
public ActionResult add(schedule col, string sysflag, HttpPostedFileBase sfile) { ModelState.Clear(); 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 = ""; } string schtype = Request["schtype"].ToString(); ViewBag.schtype = schtype; ViewBag.Mflag = Request["Mflag"].ToString();; if (Request["tmpadate"] != "" && Request["tmpadate"] != null) { ViewBag.tmpadate = Request["tmpadate"].ToString(); } if (sysflag != "A") { schedule newcol = new schedule(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { string fileName = ""; #region 傳 if (sfile != null) { String sernonum = ""; //重新命名,存入檔案 DateTime myDate = DateTime.Now; sernonum = myDate.ToString("yyyyMMddHHmmss"); fileName = sfile.FileName.Substring(sfile.FileName.IndexOf("."), sfile.FileName.Length - sfile.FileName.IndexOf(".")); if (fileName != ".exe" && fileName != ".asp" && fileName != ".aspx" && fileName != ".jsp" && fileName != ".php") { fileName = "F-" + sernonum.ToString() + fileName; sfile.SaveAs(Server.MapPath("~/upload/") + fileName); } //else //{ // ModelState.AddModelError("Ebpic", "上傳圖片格式錯誤"); // return View(col); //} } #endregion #region Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); schedule mobj; using (Aitag_DBContext con = new Aitag_DBContext()) { mobj = new schedule(); mobj.schtype = schtype; string schtitle = Request["schtitle"].ToString().Trim(); schtitle = schtitle.Replace("'", "’"); mobj.schtitle = schtitle; mobj.schcontent = Request["schcontent"].ToString().Trim(); mobj.schplace = Request["schplace"].ToString().Trim(); mobj.schowner = Session["empid"].ToString(); mobj.schloginer = Session["empid"].ToString(); mobj.schdate = DateTime.Parse(Request["schdate"].ToString()); mobj.schhour = Request["schhour"].ToString().Trim(); mobj.schmin = Request["schmin"].ToString().Trim(); mobj.schehour = Request["schehour"].ToString().Trim(); mobj.schemin = Request["schemin"].ToString().Trim(); mobj.comid = Session["comid"].ToString(); mobj.bmodid = Session["empid"].ToString(); mobj.bmoddate = DateTime.Now; mobj.sfile = fileName; con.schedule.Add(mobj); con.SaveChanges(); #endregion string tmptitle = ""; switch (schtype) { case "0": tmptitle = "個人備忘"; break; case "1": tmptitle = "個人行程"; break; case "2": tmptitle = "公司行程"; break; } //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "分類:" + tmptitle + "<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 }); } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.billid = Session["billid"].ToString(); // billflow col = new billflow(); // return View(col); //} //[HttpPost] public ActionResult add(billflow 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 = "billid"; } 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 != "A") { billflow newcol = new billflow(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { 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 billid from billflow where 1<>1"; //sqlsmd.CommandText = sqlstr; //dr = sqlsmd.ExecuteReader(); //if (dr.Read()) //{ // //ModelState.AddModelError("", "權限代碼重複!"); // return View(col); //} //dr.Close(); //dr.Dispose(); //sqlsmd.Dispose(); //conn.Close(); //conn.Dispose(); col.billtype = Request["billtype"]; col.addr = Request["addr"]; col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.billflow.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 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 roletitle 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"); } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // workitem col = new workitem(); // return View(col); //} //[HttpPost] public ActionResult add(workitem 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 = "corp_no"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qcorp_no = "", qworkitem = ""; if (!string.IsNullOrWhiteSpace(Request["qcorp_no"])) { qcorp_no = Request["qcorp_no"].Trim(); ViewBag.qcorp_no = qcorp_no; } if (!string.IsNullOrWhiteSpace(Request["qworkitem"])) { qworkitem = Request["qworkitem"].Trim(); ViewBag.qworkitem = qworkitem; } if (sysflag != "A") { workitem newcol = new workitem(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); SqlConnection conn = dbobj.get_conn("AitagBill_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select corp_no from workitem where corp_no = '" + col.corp_no + "' and work_no_code = '" + col.work_no_code + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "項目代碼重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); col.hourgroup = Request["hourgroup"].Trim(); col.bmoddate = DateTime.Now; using (AitagBill_DBContext con = new AitagBill_DBContext()) { con.workitem.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.corp_no + "項目代碼:" + col.work_no_code + "項目名稱:" + col.workitemname; 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='/workitem/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='qcorp_no' name='qcorp_no' value='" + qcorp_no + "'>"; tmpform += "<input type=hidden id='qworkitem' name='qworkitem' value='" + qworkitem + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
public ActionResult getallpage(int?page, empfunction emp, string orderdata, string orderdata1) { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); SqlConnection conn2 = dbobj.get_conn("Aitag_DBContext"); SqlDataReader dr, dr2; SqlCommand sqlsmd = new SqlCommand(); SqlCommand sqlcmd = new SqlCommand(); //List<empfunction> datalist = new List<empfunction>(); sqlsmd.Connection = conn; sqlcmd.Connection = conn2; sqlcmd.CommandText = "delete empfunction where empid <> '99999999'"; sqlcmd.ExecuteNonQuery(); string sqlstr = "select * from employee where empstatus not in ('3','4') and ifuse='y'"; sqlcmd.CommandText = sqlstr; string qempdid = Request["qempdid"].Trim(); string funid = Request["funid"].Trim(); dr2 = sqlcmd.ExecuteReader(); if (dr2.HasRows) { while (dr2.Read()) { string sql = "select * from empfunction where empid = '99999999' "; sqlsmd.CommandText = sql; dr = sqlsmd.ExecuteReader(); while (dr.Read()) { emp.empid = dr2["empid"].ToString(); emp.funid = dr["funid"].ToString(); emp.funposition = dr["funposition"].ToString(); emp.funorder = Convert.ToInt32(dr["funorder"]); emp.ifshowalert = dr["ifshowalert"].ToString(); emp.funrowcount = Convert.ToInt32(dr["funrowcount"]); emp.comid = Session["comid"].ToString(); emp.bmodid = Session["tempid"].ToString(); emp.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.empfunction.Add(emp); con.SaveChanges(); } } dr.Close(); dr.Dispose(); } } dr2.Close(); dr2.Dispose(); sqlsmd.Dispose(); sqlcmd.Dispose(); conn.Close(); conn.Dispose(); conn2.Close(); conn2.Dispose(); //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "公司代碼::" + Session["comid"].ToString() + "的員工個人化首頁重新產生"; string sysflag = "M"; 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 = @"<script>alert('員工個人化首頁產生成功!!');</script>" + tmpform }); }
public ActionResult subreadwriteadd(subreadwrite 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 = "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; } if (sysflag != "A") { subreadwrite newcol = new subreadwrite(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); col.dptgroup = Request["dptgroup"]; col.empgroup = Request["empgroup"]; col.sid = int.Parse(Request["tmpsid"].ToString()); col.comid = Session["comid"].ToString(); col.BMODID = Session["tempid"].ToString(); col.BMODDATE = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.subreadwrite.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 = "主目錄id:" + Request["tmpsid"]; 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 id='tmpsid' name='tmpsid' value='" + Request["tmpsid"] + "'>"; tmpform += "</form>"; tmpform += "</body>"; string tgourl = "/sublevel1/List?page=" + page + "&qsublevelname=" + qsublevelname; return(new ContentResult() { Content = @"<script>alert('新增成功!!');</script>" + tmpform }); // return RedirectToAction("List"); } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.comid = Session["comid"].ToString(); // Company col = new Company(); // return View(col); //} //[HttpPost] public ActionResult add(Company col, 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 != "A") { Company newcol = new Company(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { 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 comid from Company where comid = '" + col.comid + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "權限代碼重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); if (logopic1.ContentLength > 0) { col.logopic = Request["comid"] + "." + logopic1.FileName.Substring(logopic1.FileName.Length - 3, 3); logopic1.SaveAs(Server.MapPath("/upload/" + col.logopic)); } //密碼加密 //col.emppasswd = dbobj.Encrypt(col.emppasswd); //col.comid = col.emppasswd; //col.baddid = Session["tempid"].ToString(); col.bmodid = Session["tempid"].ToString(); //col.badddate = DateTime.Now; col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.Company.Add(col); try { con.SaveChanges(); } 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 = "代碼:" + col.comid + "名稱:" + col.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"); } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.rsid = Session["rsid"].ToString(); // resthourlog col = new resthourlog(); // return View(col); //} //[HttpPost] public ActionResult add(resthourlog 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 = "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 != "A") { resthourlog newcol = new resthourlog(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { 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 rsid from resthourlog where rsid = '" + col.rsid + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "權限代碼重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); col.otlogid = 0; col.resmoney = 0; col.inout = "0"; col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.resthourlog.Add(col); try { con.SaveChanges(); } 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 = "代碼:" + col.rsid + "名稱:" + col.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 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"); } } }
//[HttpPost] public ActionResult add(mediachannel 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 = "mdno"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qallcomid = "", pmdno = "0", qmdtitle = ""; if (!string.IsNullOrWhiteSpace(Request["qallcomid"])) { qallcomid = Request["qallcomid"].Trim(); ViewBag.qallcomid = qallcomid; } if (!string.IsNullOrWhiteSpace(Request["pmdno"])) { pmdno = Request["pmdno"].Trim(); ViewBag.pmdno = pmdno; } if (!string.IsNullOrWhiteSpace(Request["qmdtitle"])) { qmdtitle = Request["qmdtitle"].Trim(); ViewBag.qmdtitle = qmdtitle; } if (sysflag != "A") { mediaclass newcol = new mediaclass(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); SqlConnection conn = dbobj.get_conn("AitagBill_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select mdno from mediachannel where mdno = '" + col.mdno + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "媒體編號重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); col.mdno = DateTime.Now.ToString("yyyyMMddhhmmssfffff"); col.pmdno = pmdno; col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (AitagBill_DBContext con = new AitagBill_DBContext()) { con.mediachannel.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.mdno + "媒體名稱:" + col.mdtitle; 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='/mediachannel/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='qallcomid' name='qallcomid' value='" + qallcomid + "'>"; tmpform += "<input type=hidden id='pmdno' name='pmdno' value='" + pmdno + "'>"; tmpform += "<input type=hidden id='qmdtitle' name='qmdtitle' value='" + qmdtitle + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // sales_competition col = new sales_competition(); // return View(col); //} //[HttpPost] public ActionResult add(sales_competition 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 = "ccid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qprodtitle = "", qcusttitle = ""; if (!string.IsNullOrWhiteSpace(Request["qprodtitle"])) { qprodtitle = Request["qprodtitle"].Trim(); ViewBag.qprodtitle = qprodtitle; } if (!string.IsNullOrWhiteSpace(Request["qcusttitle"])) { qcusttitle = Request["qcusttitle"].Trim(); ViewBag.qcusttitle = qcusttitle; } if (sysflag != "A") { sales_competition newcol = new sales_competition(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); SqlConnection conn = dbobj.get_conn("AitagBill_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select * from sales_competition where 1<>1"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "簡易代碼重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); //找出下一個呈核角色 #region 找出下一個呈核角色 string tmparolestampid = ""; string tmprole = ""; string tmpbillid = ""; if (Request["arolestampid"].ToString() != "") { tmparolestampid = "'" + Request["arolestampid"].ToString() + "'"; } string impallstring = dbobj.getnewcheck1("G", tmparolestampid, tmparolestampid, "1", "1", ""); tmprole = impallstring.Split(';')[0].ToString(); tmpbillid = impallstring.Split(';')[1].ToString(); if (tmprole == "") { ViewBag.ErrMsg = @"<script>alert(""請先至表單流程設定中設定新業務及競業呈核流程!"");</script>"; return(View(col)); } #endregion col.custlevel1 = Request["custlevel1"]; col.custlevel2 = Request["custlevel2"]; col.custlevel3 = Request["custlevel3"]; col.iflaw = ""; col.iffin = ""; col.corpitem = Request["corpitem"]; if (!string.IsNullOrWhiteSpace(Request["arolestampid"])) { col.arolestampid = Request["arolestampid"]; } else { col.arolestampid = Request["arolestampid1"]; } col.slogtype = "1"; col.slogstatus = "0"; // 己簽核:1 :0 col.rolestampid = tmprole; col.rolestampidall = tmparolestampid; col.empstampidall = "'" + col.empid + "'"; col.billflowid = int.Parse(tmpbillid); col.billtime = DateTime.Now.ToString(); col.ccid = Decimal.Parse(DateTime.Now.ToString("yyyyMMddhhmmssff")); col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (AitagBill_DBContext con = new AitagBill_DBContext()) { con.sales_competition.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.empid + "產品名稱:" + col.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='qcusttitle' name='qcusttitle' value='" + qcusttitle + "'>"; tmpform += "<input type=hidden id='qprodtitle' name='qprodtitle' value='" + qprodtitle + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // certifystamp col = new certifystamp(); // return View(col); //} //[HttpPost] public ActionResult add(certifystamp 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 = "csid"; } 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 != "A") { certifystamp newcol = new certifystamp(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { 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 * from certifystamp where 1<>1"; * sqlsmd.CommandText = sqlstr; * dr = sqlsmd.ExecuteReader(); * * if (dr.Read()) * { * * ModelState.AddModelError("", "no"); * return View(col); * } * dr.Close(); * dr.Dispose(); * sqlsmd.Dispose(); * conn.Close(); * conn.Dispose(); */ col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); //col.badddate = DateTime.Now; col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.certifystamp.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.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"); } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.empdid = Session["empdid"].ToString(); // empfunction col = new empfunction(); // return View(col); //} //[HttpPost] public ActionResult add(empfunction col, string sysflag, int?page, string orderdata, string orderdata1, string test) { ModelState.Clear(); page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; if (string.IsNullOrWhiteSpace(orderdata)) { orderdata = "empdid"; } 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 != "A") { empfunction newcol = new empfunction(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); // SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; #region 註解 //string sqlstr = "select empdid from empfunction where empdid = '" + col.empdid + "'"; //sqlsmd.CommandText = sqlstr; //dr = sqlsmd.ExecuteReader(); //if (dr.Read()) //{ // ModelState.AddModelError("", "權限代碼重複!"); // return View(col); //} //dr.Close(); //dr.Dispose(); //sqlsmd.Dispose(); //conn.Close(); //conn.Dispose(); #endregion //密碼加密 //col.emppasswd = dbobj.Encrypt(col.emppasswd); //col.empdid = col.emppasswd; //col.baddid = Session["tempid"].ToString(); col.bmodid = Session["tempid"].ToString(); col.empid = "99999999"; //col.badddate = DateTime.Now; col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.empfunction.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 dbdata = dbobj.get_dbvalue(sysconn, "select chkitem from checkcode where chkclass='08' and chkcode='" + col.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"); } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // sublevel1 col = new sublevel1(); // return View(col); //} //[HttpPost] public ActionResult add(sublevel1 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 = "corder"; } 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; } if (sysflag != "A") { sublevel1 newcol = new sublevel1(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { 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 * from sublevel1 where 1<>1 "; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); col.lid = "2"; col.uplink = Int32.Parse(Request["psid"]); col.counttype = "00"; col.subread = "2"; //全部 col.subadd = "2"; //全部 col.submod = "2"; //個人 col.subdel = "2"; //個人 col.comid = Session["comid"].ToString(); col.BMODID = Session["tempid"].ToString(); col.BMODDATE = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.sublevel1.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.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/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='qsublevelname' name='qsublevelname' value='" + qsublevelname + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
//子目錄 public ActionResult add1(sublevel1 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 = "corder"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "asc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qsublevelname1 = ""; string uplink = ""; 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; if (sysflag != "A") { sublevel1 newcol = new sublevel1(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); col.lid = "3"; col.uplink = Int32.Parse(uplink); col.counttype = "00"; col.subread = "2"; //全部 col.subadd = "2"; //全部 col.submod = "2"; //個人 col.subdel = "2"; //個人 col.comid = Session["comid"].ToString(); col.BMODID = Session["tempid"].ToString(); col.BMODDATE = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.sublevel1.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.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 = @"<script>alert('新增成功!!');</script>" + tmpform }); // return RedirectToAction("List"); } } }