public ActionResult DeleteConfirmed(int id, string cid, string cid1) { using (Aitag_DBContext con = new Aitag_DBContext()) { Webmaincontent Webmaincontents = con.Webmaincontents.Find(id); con.Webmaincontents.Remove(Webmaincontents); con.SaveChanges(); //系統LOG檔 //================================================= // Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); string syssubname = "網站管理作業 > 網站內容管理"; string sysnote = "名稱:" + Webmaincontents.AC_Mctitle; string sysflag = "D"; 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 (cid1 == "0") { return(RedirectToAction("List", new { cid = cid, cid1 = cid1 })); } else { return(RedirectToAction("List", new { cid = cid1, cid1 = cid })); } } }
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"); } } } }
//[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 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 fileuploadDB() { string realsid = Request["realsid"].ToString(); string mcid = Request["mcid"].ToString(); if (mcid == "") { mcid = Session["mcid"].ToString(); } string qmcparentid = Request["qmcparentid"].ToString(); string cfilename = Request["cfilename"].ToString(); string vfilename = Request["vfilename"].ToString(); string cfilesize = Request["cfilesize"].ToString(); NDcommon dbobj = new NDcommon(); System.IO.File.Copy(Server.MapPath(Imglink + "/upload/" + cfilename), Server.MapPath(Imglink + "/upload/" + vfilename)); System.IO.File.Delete(Server.MapPath(Imglink + "/upload/" + cfilename)); using (Aitag_DBContext con = new Aitag_DBContext()) { SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; //取得功能代號 string sqlstr = "select * from sublevel1 where sid = '" + realsid + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); string functype = ""; if (dr.Read()) { functype = dr["functype"].ToString(); } dr.Close(); dr.Dispose(); if (mcid == "") { maincontent mainobj = new maincontent(); if (qmcparentid != "") { mainobj.mcparentid = int.Parse(qmcparentid); } mainobj.mctitle = ""; mainobj.mchttp = ""; mainobj.mctype = functype; mainobj.sid = int.Parse(realsid); mainobj.readallman = ""; mainobj.mdate = DateTime.Today; mainobj.mclick = 0; mainobj.ownman = Session["empid"].ToString(); mainobj.comid = Session["comid"].ToString(); mainobj.bmodid = Session["empid"].ToString(); mainobj.bmoddate = DateTime.Today; con.maincontent.Add(mainobj); con.SaveChanges(); sqlstr = "select top 1 * from maincontent where ownman = '" + Session["empid"].ToString() + "' order by mcid desc"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { mcid = dr["mcid"].ToString(); } dr.Close(); dr.Dispose(); Session["mcid"] = mcid; } conn.Close(); conn.Dispose(); contupload addobj = new contupload(); addobj.cfilename = cfilename; addobj.cfilesize = int.Parse(cfilesize); addobj.mcid = int.Parse(mcid); addobj.cfiletitle = cfilename; addobj.cupfile = vfilename; addobj.bmodid = Session["empid"].ToString(); addobj.bmoddate = DateTime.Now; con.contupload.Add(addobj); con.SaveChanges(); con.Dispose(); } string tmpdata = mcid; return(new ContentResult() { Content = @"" + tmpdata }); }
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 }); } } }
public ActionResult holidaylogcal(int?page, string orderdata, string orderdata1) { string qdptid = "", qempname = "", qclogsdate = "", qclogedate = "", qclogstatus = "", qempid = ""; if (!string.IsNullOrWhiteSpace(Request["qdptid"])) { qdptid = Request["qdptid"].Trim(); } if (!string.IsNullOrWhiteSpace(Request["qempname"])) { qempname = Request["qempname"].Trim(); } if (!string.IsNullOrWhiteSpace(Request["qclogstatus"])) { qclogstatus = Request["qclogstatus"].Trim(); } if (!string.IsNullOrWhiteSpace(Request["qempid"])) { qempid = Request["qempid"].Trim(); } if (!string.IsNullOrWhiteSpace(Request["qtheday"])) { DateTime qtheday = Convert.ToDateTime(Request["qtheday"]); DateTime qendday = qtheday.AddMonths(1).AddDays(-1); qclogsdate = qtheday.ToString("yyyy/MM/dd"); qclogedate = qendday.ToString("yyyy/MM/dd"); } else { qclogsdate = NullStDate(Request["qclogsdate"]); qclogedate = NullTeDate(Request["qclogedate"]); } //NullStDate 跟 NullTeDate 會判斷格式,有錯誤就 修改全域的DateEx if (DateEx != "") { ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>"; } string sqlstr = ""; int jstart = 0; int countday = 0; Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); countday = Convert.ToDateTime(qclogedate).Subtract(Convert.ToDateTime(qclogsdate)).Days; dbobj.dbexecute("Aitag_DBContext", "delete cardjudgelog where clogdate>='" + qclogsdate + "' and clogdate<='" + qclogedate + "' and comid = '" + Session["comid"] + "'"); SqlConnection comconn1 = dbobj.get_conn("Aitag_DBContext"); for (int j = jstart; j <= countday; j++) { DateTime tmpdate = Convert.ToDateTime(qclogsdate).AddDays(j); using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext")) { string sql = "select * from employee where empstatus<>'4' and empworkcomp='" + (string)Session["comid"] + "'"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { cardjudgelog rscard = new cardjudgelog(); string clogstime = "000000", clogetime = "000000", clogcomment = ""; string clogstatus = ""; using (SqlConnection conn1 = dbobj.get_conn("Aitag_DBContext")) { int count1 = 0; count1 = int.Parse(dbobj.get_dbvalue(conn1, "select isnull(count(*),0) as count1 from cardreallog where empid='" + dr["empid"] + "' and clogdate ='" + dbobj.get_date(tmpdate.ToString(), "1") + "'")); sql = "select clogtime from cardreallog where empid='" + dr["empid"] + "' and clogdate ='" + dbobj.get_date(tmpdate.ToString(), "1") + "' order by clogtime"; using (SqlCommand cmd1 = new SqlCommand(sql, conn1)) { SqlDataReader dr1 = cmd1.ExecuteReader(); if (dr1.HasRows) { if (count1 < 2)//'cardreallog 判斷小於每天兩次打卡時間 { if (dr1.Read()) { clogstime = dr1["clogtime"].ToString(); } else { clogstime = "000000"; } } else { int k = 0; while (dr1.Read()) { k++; if (k == 1) { clogstime = dbobj.get_dbvalue(comconn1, "select top(1) clogtime from cardreallog where empid='" + dr["empid"].ToString() + "' and clogdate ='" + dbobj.get_date(tmpdate.ToString(), "1") + "' order by clogtime"); } if (k == 2) { clogetime = dbobj.get_dbvalue(comconn1, "select top(1) clogtime from cardreallog where empid='" + dr["empid"].ToString() + "' and clogdate ='" + dbobj.get_date(tmpdate.ToString(), "1") + "' order by clogtime desc"); } } } } else { clogstime = "000000"; clogetime = "000000"; } dr1.Close(); #region 整理rscard rscard.empid = dr["empid"].ToString(); rscard.empname = dr["empname"].ToString(); rscard.comid = dr["empworkcomp"].ToString(); rscard.dptid = dr["empworkdepid"].ToString(); rscard.clogdate = tmpdate; if (clogstime == "000000") { rscard.clogstime = ""; } else { rscard.clogstime = clogstime; } if (clogetime == "000000") { rscard.clogetime = ""; } else { rscard.clogetime = clogetime; } if (clogstime.Length != 6) { clogstime = "000000"; } if (clogetime.Length != 6) { clogstime = "000000"; } string clogetime1 = "", clogstime1 = ""; if (clogstime != "" || clogetime != "") { clogetime1 = (int.Parse(clogetime.Substring(0, 2)) * 60 + int.Parse(clogetime.Substring(2, 2))).ToString("000000"); clogstime1 = (int.Parse(clogstime.Substring(0, 2)) * 60 + int.Parse(clogstime.Substring(2, 2))).ToString("000000"); rscard.cloghour = Math.Round((decimal.Parse(clogetime1) - decimal.Parse(clogstime1)) / 60, 1); } else { rscard.cloghour = 0; } string hlogstatus = "", hloghour = "", hdayid = ""; dr1 = dbobj.dbselect(comconn1, "select * from holidaylog where empid='" + dr["empid"] + "' and comid='" + dr["empworkcomp"] + "' and hlogstatus='1' and hlogsdate<='" + dbobj.get_date(tmpdate.ToString(), "1") + "' and hlogedate>='" + dbobj.get_date(tmpdate.ToString(), "1") + "'"); if (dr1.Read()) { hlogstatus = dr1["hlogstatus"].ToString(); hloghour = dr1["hloghour"].ToString(); hdayid = dr1["hdayid"].ToString(); } dr1.Close(); //string hlogstatus = dbobj.get_dbvalue(comconn1, "select hlogstatus from holidaylog where empid='" + dr["empid"] + "' and comid='" + dr["empworkcomp"] + "' and hlogstatus='1' and hlogsdate<='" + dbobj.get_date(tmpdate.ToString(), "1") + "' and hlogedate>='" + dbobj.get_date(tmpdate.ToString(), "1") + "'"); //string hloghour = dbobj.get_dbvalue(comconn1, "select hloghour from holidaylog where empid='" + dr["empid"] + "' and comid='" + dr["empworkcomp"] + "' and hlogstatus='1' and hlogsdate<='" + dbobj.get_date(tmpdate.ToString(), "1") + "' and hlogedate>='" + dbobj.get_date(tmpdate.ToString(), "1") + "'"); //string hdayid = dbobj.get_dbvalue(comconn1, "select hdayid from holidaylog where empid='" + dr["empid"] + "' and comid='" + dr["empworkcomp"] + "' and hlogstatus='1' and hlogsdate<='" + dbobj.get_date(tmpdate.ToString(), "1") + "' and hlogedate>='" + dbobj.get_date(tmpdate.ToString(), "1") + "'"); clogcomment = dbobj.get_dbvalue(comconn1, "select hdaytitle from holidaycode where hdayid='" + hdayid + "'"); if (tmpdate.DayOfWeek.ToString("d") == "0" || tmpdate.DayOfWeek.ToString("d") == "6") //'例假日 { using (SqlConnection conn3 = dbobj.get_conn("Aitag_DBContext")) { sql = "select wstitle from holidayschedule where comid='" + dr["empworkcomp"] + "' and wstype='1' and wsdate='" + dbobj.get_date(tmpdate.ToString(), "1") + "'"; //'20160920因無年假身分別故先取消 using (SqlCommand cmd3 = new SqlCommand(sql, conn3)) { SqlDataReader dr3 = cmd3.ExecuteReader(); if (dr3.Read()) { clogcomment = dr3["wstitle"].ToString(); if (hlogstatus == "1") { clogstatus = "0"; } else { if (rscard.cloghour < 8) { if (int.Parse(clogstime) > 093000) { clogstatus = "1"; } if (int.Parse(clogetime) < 183000) { clogstatus = "2"; } if (rscard.cloghour == 0) { if (tmpdate >= DateTime.Parse(dr["jobdate"].ToString())) { clogstatus = "3"; } else { clogstatus = "4"; } } } else { clogstatus = "0"; } } } else { clogstatus = "0"; clogcomment = "假日"; } dr3.Close(); } } } else //'上班日 { using (SqlConnection conn3 = dbobj.get_conn("Aitag_DBContext")) { sql = "select wstitle from holidayschedule where comid='" + dr["empworkcomp"] + "' and wstype='0' and wsdate='" + dbobj.get_date(tmpdate.ToString(), "1") + "'"; //'20160920因無年假身分別故先取消 using (SqlCommand cmd3 = new SqlCommand(sql, conn3)) { SqlDataReader dr3 = cmd3.ExecuteReader(); if (dr3.Read()) { clogcomment = dr3["wstitle"].ToString(); clogstatus = "0"; } else { if (hlogstatus == "1") { clogstatus = "0"; } else { if (rscard.cloghour < 8) { if (int.Parse(clogstime) > 093000) { clogstatus = "1"; } if (int.Parse(clogetime) < 183000) { clogstatus = "2"; } if (rscard.cloghour == 0) { if (tmpdate >= DateTime.Parse(dr["jobdate"].ToString())) { clogstatus = "3"; } else { clogstatus = "4"; } } } else { clogstatus = "0"; } } } dr3.Close(); } } } rscard.clogstime = clogstime; rscard.clogetime = clogetime; rscard.clogstatus = clogstatus; rscard.clogcomment = clogcomment; rscard.comid = (string)Session["comid"]; rscard.bmodid = (string)Session["empid"]; rscard.bmoddate = DateTime.Now; #endregion } } #region 整理rscard #endregion using (Aitag_DBContext con = new Aitag_DBContext()) { con.cardjudgelog.Add(rscard); con.SaveChanges(); } } dr.Close(); } } } comconn1.Close(); comconn1.Dispose(); string tmpform = ""; tmpform = "<body onload=qfr1.submit();>"; tmpform += "<form name='qfr1' action='/cardabnormallog/List' method='post'>"; tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>"; tmpform += "<input type=hidden name='qclogsdate' id='qclogsdate' value='" + qclogsdate + "'>"; tmpform += "<input type=hidden name='qclogedate' id='qclogedate' value='" + qclogedate + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"<script>alert('差勤轉入成功!!');</script>" + tmpform }); }
public ActionResult cardbatch(string sysflag) { ModelState.Clear(); string sid = "", realsid = "", yhid = "", carddate = "", ctype = ""; if (!string.IsNullOrWhiteSpace(Request["sid"])) { sid = Request["sid"].Trim(); ViewBag.sid = sid; } if (!string.IsNullOrWhiteSpace(Request["realsid"])) { realsid = Request["realsid"].Trim(); ViewBag.realsid = realsid; } if (!string.IsNullOrWhiteSpace(Request["yhid"])) { yhid = Request["yhid"].Trim(); ViewBag.yhid = yhid; } if (!string.IsNullOrWhiteSpace(Request["carddate"])) { carddate = Request["carddate"].Trim(); ViewBag.carddate = DateTime.Parse(carddate); } if (!string.IsNullOrWhiteSpace(Request["ctype"])) { ctype = Request["ctype"].Trim(); ViewBag.ctype = ctype; } if (sysflag != "A") { return(View()); } else { if (!ModelState.IsValid) { return(View()); } else { NDcommon dbobj = new NDcommon(); //'取得這類人員的上下班時間 string ytstime = "", ydetime = ""; using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext")) { string sql = "select * from yearholiday where yhid = '" + yhid + "'"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); ytstime = dbobj.get_dbnull2(dr["ytstime"]); ydetime = dbobj.get_dbnull2(dr["ydetime"]); } dr.Close(); } } using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext")) { string sql = "select * from employee where empstatus in ('1','2') and yhid = '" + yhid + "'"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { SqlDataReader dr = cmd.ExecuteReader(); string clogtime = ""; if (ctype == "1") { clogtime = ytstime; } else { clogtime = ydetime; } var bmoddate = DateTime.Now; while (dr.Read()) { cardreallog col = new cardreallog(); col.empid = dbobj.get_dbnull2(dr["empid"]); col.empname = dbobj.get_dbnull2(dr["empname"]); col.dptid = dbobj.get_dbnull2(dr["empworkdepid"]); col.clogdate = ViewBag.carddate; col.clogtime = clogtime; col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); col.bmoddate = bmoddate; using (Aitag_DBContext con = new Aitag_DBContext()) { con.cardreallog.Add(col); con.SaveChanges(); } } dr.Close(); } } //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "班別代碼:" + yhid + "<br>產生日期:" + carddate + "的資料"; dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag); sysconn.Close(); sysconn.Dispose(); //================================================= string tmpform = ""; tmpform += "<script>"; tmpform += "function SetParentOpener() {"; tmpform += "alert('刷卡資料批次產生成功!!');"; tmpform += "parent.opener.location.href='/cardreallog/List';"; tmpform += "window.close();"; tmpform += "}"; tmpform += "</script>"; tmpform += "<body onload=SetParentOpener();>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); } } }
public ActionResult cardlogtransfer3(string sysflag, conbudgetdet col, HttpPostedFileBase upfile) { // ViewBag.pid = Request["pid"].ToString(); if (sysflag != "A") { return(View()); } else { NDcommon dbobj = new NDcommon(); string errmsg = ""; if (upfile != null) { String sernonum = ""; //重新命名,存入檔案 DateTime myDate = DateTime.Now; sernonum = myDate.ToString("yyyyMMddHHmmss"); string BasicPath = Server.MapPath("~/upload/"); string fileName = upfile.FileName.Substring(upfile.FileName.IndexOf("."), upfile.FileName.Length - upfile.FileName.IndexOf(".")); if (fileName != ".exe" && fileName != ".asp" && fileName != ".aspx" && fileName != ".jsp" && fileName != ".php") { fileName = "cust-" + sernonum.ToString() + fileName; upfile.SaveAs(Server.MapPath("~/upload/") + fileName); string tmppath = BasicPath + fileName; StreamReader sr = new StreamReader(@tmppath, System.Text.Encoding.Default); string allstr = sr.ReadToEnd(); //從資料流末端存取檔案 sr.Close(); string[] tmpstridno; //匯入資料 allstr = allstr.Replace(Environment.NewLine, "\""); allstr = allstr.Substring(0, allstr.Length - 1); tmpstridno = allstr.Split('\"'); //tmpstridno[0] = GetBytesCount1(tmpstridno[0]); #region string tempcard = "", tempcard1 = "", tempdatetime = "", tmptime = ""; SqlConnection comconn = dbobj.get_conn("Aitag_DBContext"); foreach (string tmptxt in tmpstridno) { if (tmptxt != "") { tempcard = tmptxt.Trim().Substring(0, 10); tempcard1 = tmptxt.Trim().Substring(11, 4); tempdatetime = tmptxt.Trim().Substring(16, 8); tmptime = tmptxt.Trim().Substring(25, 4); if (tempcard != "" && tempcard1 != "" && tempdatetime != "" && tmptime != "") { string date1 = tempdatetime.Substring(0, 4) + "/" + tempdatetime.Substring(4, 2) + "/" + tempdatetime.Substring(6, 2); tmptime = tmptime + "00"; string rs1_Open = ""; rs1_Open = dbobj.get_dbvalue(comconn, "select * from cardreallog where clogtime = '" + tmptime + "' and clogdate = '" + date1 + "' and tmpcardno = '" + tempcard1 + "'"); if (rs1_Open == "") { using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext")) { string sql = "select empid,empname,empworkdepid,empworkcomp from employee where empno = '" + tempcard1 + "'"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { cardreallog rs = new cardreallog(); dr.Read(); rs.empid = dr["empid"] + ""; rs.empname = dr["empname"] + ""; rs.dptid = dr["empworkdepid"] + ""; rs.comid = dr["empworkcomp"] + ""; rs.clogdate = DateTime.Parse(date1); rs.clogtime = tmptime; rs.tmpcardno = tempcard1; rs.tmpdepid = dbobj.get_dbvalue(comconn, "select dpttitle from department where dptid='" + dr["empworkdepid"] + "'"); using (Aitag_DBContext con = new Aitag_DBContext()) { con.cardreallog.Add(rs); con.SaveChanges(); } } else { errmsg += tempcard1 + ","; } dr.Close(); } } } } } } comconn.Close(); comconn.Dispose(); #endregion } else { ViewBag.AddModelError = @"alert('上傳格式錯誤!');"; return(View()); } } string tmpform = ""; if (errmsg != "") { tmpform += "<script>"; tmpform += "function SetParentOpener() {"; tmpform += "alert('以下員編尚未轉檔,請確認!!" + errmsg + "');"; tmpform += "parent.opener.location.href='/cardreallog/List';"; tmpform += "window.close();"; tmpform += "}"; tmpform += "</script>"; tmpform += "<body onload=SetParentOpener();>"; //tmpform += errmsg; tmpform += "</body>"; } else { tmpform += "<script>"; tmpform += "function SetParentOpener() {"; tmpform += "alert('轉檔成功!!');"; tmpform += "parent.opener.location.href='/cardreallog/List';"; tmpform += "window.close();"; tmpform += "}"; tmpform += "</script>"; tmpform += "<body onload=SetParentOpener();>"; tmpform += "</body>"; } return(new ContentResult() { Content = @"" + tmpform }); } }
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"); } } } }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.crid = Session["crid"].ToString(); // cardreallog col = new cardreallog(); // return View(col); //} //[HttpPost] public ActionResult add(cardreallog 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 = "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 != "A") { cardreallog newcol = new cardreallog(); ViewBag.cloghour = ViewBagcloghour(""); ViewBag.clogmin = ViewBagclogmin(""); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { NDcommon dbobj = new NDcommon(); SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select crid from cardreallog where crid = '" + col.crid + "'"; 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.clogtime = Request["cloghour"].Trim() + Request["clogmin"].Trim() + "00"; col.comid = Session["comid"].ToString(); col.tmpcardno = Request["cardno"].Trim(); col.tmpdepid = Request["dptidname"].Trim(); col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.cardreallog.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.empname + "<br>刷卡日期:" + col.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"); } } }
//[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"); } } }
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 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 logadd(delholidaylog 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 = "hdellogid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; if (sysflag != "A") { delholidaylog newcol = new delholidaylog(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { NDcommon dbobj = new NDcommon(); //簽核 string tmparolestampid = ""; if (dbobj.get_dbnull2(Request["arolestampid"]) != "") { tmparolestampid = "'" + Request["arolestampid"].ToString() + "'"; } else { tmparolestampid = "'" + Request["arolestampid1"].ToString() + "'"; } string tmpmoney = "0", tmprole = "", tmpbillid = ""; //找出下一個角色是誰 string impallstring = dbobj.getnewcheck1("H", tmparolestampid, tmparolestampid, Request["hloghour"], "", ""); tmprole = impallstring.Split(';')[0].ToString(); tmpbillid = impallstring.Split(';')[1].ToString(); string errmsg = ""; if (tmprole == "") { errmsg = "請先至表單流程設定中設定首長信箱的呈核流程!"; ViewBag.errmsg = "<script>alert('" + errmsg + "');</script>"; return(View(col)); } //簽核 //if ((string)Session["mplayrole"] == "") //{ // errmsg = "您並未設定呈核角色!"; // ViewBag.errmsg = "<script>alert('" + errmsg + "');</script>"; // return View(col); //} //'找單據編號(自動產生編號) string tmpbsno = "select hdno from delholidaylog where year(cdate) = " + DateTime.Now.Year + " and month(cdate) = " + DateTime.Now.Month + " and hdno is not null order by hdno desc"; using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext")) { tmpbsno = dbobj.get_dbvalue(conn, tmpbsno); } if (tmpbsno != "") { tmpbsno = tmpbsno.Substring(tmpbsno.Length - 3, 3); tmpbsno = (int.Parse(tmpbsno) + 1).ToString("000"); } else { tmpbsno = "001"; } string tmpyear = (DateTime.Now.Year - 1911).ToString(); string tmpmonth = DateTime.Now.Month.ToString("00"); tmpbsno = "A" + tmpyear + tmpmonth + tmpbsno; //====== col.hdellogstatus = "0"; col.hdno = tmpbsno; //呈核人員 //====== if (dbobj.get_dbnull2(col.arolestampid) == "") { col.arolestampid = Request["arolestampid1"]; } col.rolestampid = tmprole; //'下個呈核角色 col.rolestampidall = tmparolestampid; //'所有呈核角色 col.empstampidall = "'" + Request["empid"] + "'"; //'所有人員帳號 col.billflowid = int.Parse(tmpbillid); //====== col.comid = (string)Session["comid"]; col.bmodid = (string)Session["empid"]; col.bmoddate = DateTime.Now; col.deldate = DateTime.Now; col.billtime = DateTime.Now.ToString(); using (Aitag_DBContext con = new Aitag_DBContext()) { con.delholidaylog.Add(col); con.SaveChanges(); } // '寄信 //'====================== using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext")) { string fromadd = "", fromaddname = "", mailtitle = "", MailContext = ""; fromadd = dbobj.get_dbvalue(conn, "select enemail from employee where empid='" + Request["empid"] + "'"); fromaddname = dbobj.get_dbvalue(conn, "select empname from employee where empid='" + Request["empid"] + "'"); //'寄送mail給下一個審核角色 #region 寄送mail給下一個審核角 mailtitle = "銷假單資料要求簽核通知"; MailContext = "<HTML><HEAD><meta http-equiv='Content-Type' content='text/html; charset=BIG5'></HEAD><body>"; MailContext = MailContext + "以下為明細資料:<BR>"; MailContext = MailContext + "<table cellpadding=3 cellspacing=0 bordercolorlight=#000000 bordercolordark=ffffff border=1 width=400 bgcolor=ffffff style='FONT-SIZE: 11pt;FONT-FAMILY:Tahoma,Arial'>"; MailContext = MailContext + "<tr><td align=right width=130>申請單號:</td><td>" + tmpbsno + "</td></tr>"; MailContext = MailContext + "<tr><td align=right width=130>請假單號:</td><td>" + col.hsno + "</td></tr>"; MailContext = MailContext + "<tr><td align=right width=130>申請人:</td><td>" + col.empname + "</td></tr>"; MailContext = MailContext + "<tr><td align=right width=130>假別:</td><td>" + Request["hdaytitle"] + "</td></tr>"; string hlogsdate = dbobj.get_dbDate(col.hlogsdate, "yyyy/MM/dd"); string hlogedate = dbobj.get_dbDate(col.hlogedate, "yyyy/MM/dd"); string SEDate = "自{0} ({1})<br>至{2} ({3})"; SEDate = string.Format(SEDate, hlogsdate, col.hlogstime, hlogedate, col.hlogetime); MailContext = MailContext + "<tr><td align=right width=130>日期起訖:</td><td>" + SEDate + "</td></tr>"; if (dbobj.get_dbnull2(col.hlogcomment) != "") { MailContext = MailContext + "<tr><td align=right width=130>備註:</td><td>" + col.hlogcomment.ToString().Trim().Replace(Environment.NewLine, "<br>") + "</td></tr>"; } else { MailContext = MailContext + "<tr><td align=right width=130>備註:</td><td> </td></tr>"; } MailContext = MailContext + "</table>"; MailContext = MailContext + "</body></HTML>"; string tmproleid = tmprole.Replace("'", ""); string sql = "select enemail from viewemprole where rid = '" + tmproleid + "' and empstatus <> '4' and enemail<>''"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { SqlDataReader dr = cmd.ExecuteReader(); string tomail = ""; while (dr.Read()) { tomail += dr["enemail"] + ","; } dbobj.send_mailfile("", tomail, mailtitle, MailContext, null, null); dr.Close(); } #endregion } //系統LOG檔 string sysnote = "申請人:{0}<br>申請單號:{1}的資料"; sysnote = string.Format(sysnote, Request["empid"], tmpbsno); 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 += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + 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"); } } } }
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 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 add(Webmaincontent col, HttpPostedFileBase Mcfile, HttpPostedFileBase Mpic) { ViewBag.Cid = col.AC_Cid.ToString(); ViewBag.Ccid = col.AC_Ccid.ToString(); /* * if (Mcfile == null) * { * ModelState.AddModelError("Mcfile", "請選擇檔案"); * } */ if (!ModelState.IsValid) { return(View(col)); } Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); //上傳檔案****開始 int sernonum; if (Mcfile != 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() + Mcfile.FileName.Substring(Mcfile.FileName.IndexOf("."), Mcfile.FileName.Length - Mcfile.FileName.IndexOf(".")); Mcfile.SaveAs(Server.MapPath("~/Upload/") + fileName); col.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(); } //上傳圖片****開始 if (Mpic != null) { //上傳檔案 //找序號 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() + Mpic.FileName.Substring(Mpic.FileName.IndexOf("."), Mpic.FileName.Length - Mpic.FileName.IndexOf(".")); Mpic.SaveAs(Server.MapPath("~/Upload/") + fileName); col.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(); } col.AC_Baddid = Session["tempid"].ToString(); col.AC_Badddate = DateTime.Now; col.AC_Bmodid = Session["tempid"].ToString(); col.AC_Bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.Webmaincontents.Add(col); con.SaveChanges(); } //系統LOG檔 //================================================= // //Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); string syssubname = "網站管理作業 > 網站內容管理"; string sysnote = "名稱:" + col.AC_Mctitle; string sysflag = "A"; 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 (col.AC_Ccid != 0) { return(RedirectToAction("List", new { cid = col.AC_Ccid, cid1 = col.AC_Cid })); } else { return(RedirectToAction("List", new { cid = col.AC_Cid, cid1 = 0 })); } }
public ActionResult Transfer(holidayschedule col, string sysflag, HttpPostedFileBase upfile) { if (sysflag != "A") { holidayschedule newcol = new holidayschedule(); return(View(newcol)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); string tmpform = ""; if (upfile != null) { String sernonum = ""; //重新命名,存入檔案 DateTime myDate = DateTime.Now; sernonum = myDate.ToString("yyyyMMddHHmmss"); string BasicPath = Server.MapPath("~/upload/"); int inputcount = 0; string fileName = upfile.FileName.Substring(upfile.FileName.IndexOf("."), upfile.FileName.Length - upfile.FileName.IndexOf(".")); if (fileName != ".exe" && fileName != ".asp" && fileName != ".aspx" && fileName != ".jsp" && fileName != ".php") { fileName = "udf-" + sernonum.ToString() + fileName; upfile.SaveAs(Server.MapPath("~/upload/") + fileName); string tmppath = BasicPath + fileName; //StreamReader sr = new StreamReader(@tmppath); //讀取檔案 StreamReader sr = new StreamReader(@tmppath, System.Text.Encoding.Default); string allstr = sr.ReadToEnd(); //從資料流末端存取檔案 sr.Close(); string[] tmpstridno; //匯入資料 string[] toptmparry; //匯入的第一筆資料(欄位) int tmparrycount = 0; //匯入欄位數 tmpstridno = allstr.Split(System.Environment.NewLine.ToCharArray()); //找第一筆的欄位數 toptmparry = tmpstridno[0].Split(','); //先暫時停掉20160827 for (int tmpi = 0; tmpi <= toptmparry.Length - 1; tmpi++) { if (toptmparry[tmpi] != "") { tmparrycount++; } } SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); string[] tmparry; string tmpvalue = ""; string tmpaddsql = ""; string cmid = ""; for (int i = 1; i <= tmpstridno.Length - 1; i++) { if (tmpstridno[i] != "") { inputcount++; tmparry = tmpstridno[i].Split(','); //判斷必填欄位 if (tmparry[0] != "" && tmparry[1] != "" && tmparry[2] != "") { string wstype = ""; if (tmparry[2] == "假日") { wstype = "0"; } if (tmparry[2] == "上班") { wstype = "1"; } if (tmparry[2] == "年假") { wstype = "2"; } col.wstitle = tmparry[0]; col.wsdate = Convert.ToDateTime(tmparry[1]); col.wstype = wstype; col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.holidayschedule.Add(col); con.SaveChanges(); //系統LOG檔 //================================================= // //SqlConnection sysconn = dbobj.get_conn("MatsuEip_DBContext"); //string sysrealsid = Request["sysrealsid"].ToString(); //string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); //string sysnote = "行事曆標題:" + col.wstitle + "<br>日期:" + col.wsdate + "的資料"; //dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag); //sysconn.Close(); //sysconn.Dispose(); //================================================= } //tmpform = "<body onload=javascript:alert('轉檔成功!');parent.opener.location.href='/holidayschedule/List?sid=" + Request["sid"].ToString() + "&realsid=" + Request["realsid"].ToString() + "';window.close();>"; } } } } else { ViewBag.AddModelError = @"alert('上傳格式錯誤!');"; return(View()); } } ViewBag.AddModel = @"alert('轉檔成功!');" + @"parent.opener.location.href = '/holidayschedule/list?sid=" + Request["sid"].ToString() + "&realsid=" + Request["realsid"].ToString() + "';" + @"window.close();"; return(View()); } }
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 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(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.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(); // 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"); } } }
//[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"); } } }
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 }); } } }
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 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"); } } } }