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 }); } }
//[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"); } } }
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 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"); } } } }