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