//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.rsid = Session["rsid"].ToString(); // resthourlog col = new resthourlog(); // return View(col); //} //[HttpPost] public ActionResult add(resthourlog col, string sysflag, int?page, string orderdata, string orderdata1) { ModelState.Clear(); page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; if (string.IsNullOrWhiteSpace(orderdata)) { orderdata = "rsid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qdptid = "", qempname = "", qaddtype = "", qaddsdate = "", qaddedate = ""; if (!string.IsNullOrWhiteSpace(Request["qdptid"])) { qdptid = Request["qdptid"].Trim(); ViewBag.qdptid = qdptid; } if (!string.IsNullOrWhiteSpace(Request["qempname"])) { qempname = Request["qempname"].Trim(); ViewBag.qempname = qempname; } if (!string.IsNullOrWhiteSpace(Request["qaddtype"])) { qaddtype = Request["qaddtype"].Trim(); ViewBag.qaddtype = qaddtype; } if (!string.IsNullOrWhiteSpace(Request["qaddsdate"])) { qaddsdate = Request["qaddsdate"].Trim(); ViewBag.qaddsdate = qaddsdate; } if (!string.IsNullOrWhiteSpace(Request["qaddedate"])) { qaddedate = Request["qaddedate"].Trim(); ViewBag.qaddedate = qaddedate; } if (sysflag != "A") { resthourlog newcol = new resthourlog(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select rsid from resthourlog where rsid = '" + col.rsid + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "權限代碼重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); col.otlogid = 0; col.resmoney = 0; col.inout = "0"; col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.resthourlog.Add(col); try { con.SaveChanges(); } catch (Exception ex) { throw; } //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "代碼:" + col.rsid + "名稱:" + col.empid; dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag); sysconn.Close(); sysconn.Dispose(); //================================================= } string tmpform = ""; tmpform = "<body onload=qfr1.submit();>"; tmpform += "<form name='qfr1' action='/resthourcheck1/List' method='post'>"; tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>"; tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>"; tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>"; tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>"; tmpform += "<input type=hidden id='qdptid' name='qdptid' value='" + qdptid + "'>"; tmpform += "<input type=hidden id='qempname' name='qempname' value='" + qempname + "'>"; tmpform += "<input type=hidden id='qaddtype' name='qaddtype' value='" + qaddtype + "'>"; tmpform += "<input type=hidden id='qaddsdate' name='qaddsdate' value='" + qaddsdate + "'>"; tmpform += "<input type=hidden id='qaddedate' name='qaddedate' value='" + qaddedate + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
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(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"); } } } }