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 }));
}
}
}
private object get_hdaytitle(string hdayid)
{
string hdayid1 = hdayid.Replace(",", "','").Replace(" ", "");
hdayid1 = "'" + hdayid1 + "'";
string sqlstr = "select hdayid, hdaytitle from holidaycode where hdayid in (" + hdayid1 + ") order by hdayid";
System.Collections.ArrayList list = new System.Collections.ArrayList();
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext"))
{
using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
{
SqlDataReader dr = cmd.ExecuteReader();
hdayid = "";
while (dr.Read())
{
list.Add(dbobj.get_dbnull2(dr["hdaytitle"]));
hdayid += dr["hdayid"] + ",";
}
dr.Close();
}
}
hdayid = hdayid.Substring(0, hdayid.Length - 1);
ViewBag.hdayid = hdayid;
return(list);
}
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();
// certifystamp col = new certifystamp();
// return View(col);
//}
//[HttpPost]
public ActionResult add(certifystamp col, string sysflag, int?page, string orderdata, string orderdata1)
{
ModelState.Clear();
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "csid";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = "desc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qwtrack = "", qcitemid = "";
if (!string.IsNullOrWhiteSpace(Request["qwtrack"]))
{
qwtrack = Request["qwtrack"].Trim();
ViewBag.qwtrack = qwtrack;
}
if (!string.IsNullOrWhiteSpace(Request["qcitemid"]))
{
qcitemid = Request["qcitemid"].Trim();
ViewBag.qcitemid = qcitemid;
}
if (sysflag != "A")
{
certifystamp newcol = new certifystamp();
return(View(newcol));
}
else
{
if (!ModelState.IsValid)
{
return(View(col));
}
else
{
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
/*
* SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
* SqlDataReader dr;
* SqlCommand sqlsmd = new SqlCommand();
* sqlsmd.Connection = conn;
* string sqlstr = "select * from certifystamp where 1<>1";
* sqlsmd.CommandText = sqlstr;
* dr = sqlsmd.ExecuteReader();
*
* if (dr.Read())
* {
*
* ModelState.AddModelError("", "no");
* return View(col);
* }
* dr.Close();
* dr.Dispose();
* sqlsmd.Dispose();
* conn.Close();
* conn.Dispose();
*/
col.comid = Session["comid"].ToString();
col.bmodid = Session["tempid"].ToString();
//col.badddate = DateTime.Now;
col.bmoddate = DateTime.Now;
using (Aitag_DBContext con = new Aitag_DBContext())
{
con.certifystamp.Add(col);
con.SaveChanges();
//系統LOG檔 //================================================= //
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
string sysrealsid = Request["sysrealsid"].ToString();
string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
string sysnote = "標章認證字軌：" + col.wtrack;
dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
sysconn.Close();
sysconn.Dispose();
//=================================================
}
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/certifystamp/List' method='post'>";
tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
tmpform += "<input type=hidden id='qwtrack' name='qwtrack' value='" + qwtrack + "'>";
tmpform += "<input type=hidden id='qcitemid' name='qcitemid' value='" + qcitemid + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
// return RedirectToAction("List");
}
}
}
//[HttpGet]
//public ActionResult Add()
//{
// ViewBag.Ifboss = Session["Ifboss"].ToString();
// ViewBag.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");
}
}
}
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 monthcardsave(int?page, string orderdata, string orderdata1)
{
//save................
string strcjid = Request["cjid"].ToString();
string[] arrcjid = strcjid.Split(',');
string cchkstatus = Request["cchkstatus"].ToString();
string today = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
foreach (var cjid in arrcjid)
{
string clogstime = Request["clogstime" + cjid].ToString().Replace(":", "");
string clogetime = Request["clogetime" + cjid].ToString().Replace(":", "");
string cchkcomment = Request["cchkcomment" + cjid];
double cloghour = 0;
if (clogstime != "" && clogetime != "")
{
double hours = Convert.ToDouble("0" + clogetime.Substring(0, 2)) - Convert.ToDouble("0" + clogstime.Substring(0, 2));
double mints = Convert.ToDouble("0" + clogetime.Substring(2, 2)) - Convert.ToDouble("0" + clogstime.Substring(2, 2));
cloghour = hours + mints / 60 - 1.5;
}
if (cloghour > 0 || cchkcomment != "")
{
string sql = "update cardjudgelog set ";
sql += "clogstime = '" + clogstime + "', ";
sql += "clogetime = '" + clogetime + "', ";
sql += "cloghour = '" + cloghour.ToString() + "', ";
if (cloghour >= 8)
{
sql += "clogstatus = '0', ";
}
if (cchkstatus == "2")
{
sql += "cchkownman = '" + Request["qempid"].ToString() + "', cchkowndate = '" + today + "',";
}
sql += "cchkcomment = '" + cchkcomment + "', ";
sql += "bmodid = '" + (string)Session["empid"] + "', ";
sql += "bmoddate = '" + today + "' ";
sql += "where cjid = '" + cjid + "' ";
dbobj.dbexecute("Aitag_DBContext", sql);
}
}
//回monthcardlist..............
string qempid = Request["qempid"].ToString();
string qtheday = Request["qtheday"].ToString();
string qclogstatus = Request["qclogstatus"].ToString();
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/cardabnormallog/monthcardlist' method='post'>";
tmpform += "<input type=hidden id='qempid' name='qempid' value='" + qempid + "'>";
tmpform += "<input type=hidden id='qtheday' name='qtheday' value='" + qtheday + "'>";
tmpform += "<input type=hidden id='qclogstatus' name='qclogstatus' value='" + qclogstatus + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
}
public ActionResult monthcard(int?page, string orderdata, string orderdata1)
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "dptid";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = "";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
string qdptid = "", qempname = "", qclogsdate = "", qclogedate = "", qcchkstatus = "";
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["qcchkstatus"]))
{
qcchkstatus = Request["qcchkstatus"].Trim();
ViewBag.qcchkstatus = qcchkstatus;
}
string DateEx = "", DateEx1 = "";
dbobj.get_dateRang(Request["qclogsdate"], "acd", "min", @"日期起格式錯誤!!\n", out qclogsdate, out DateEx);
ViewBag.qclogsdate = qclogsdate;
dbobj.get_dateRang(Request["qclogedate"], "acd", "max", @"日期訖格式錯誤!!\n", out qclogedate, out DateEx1);
ViewBag.qclogedate = qclogedate;
DateEx += DateEx1;
//NullStDate 跟 NullTeDate 會判斷格式，有錯誤就 修改全域的DateEx
if (DateEx != "")
{
ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>";
}
IPagedList <cardjudgelog> result;
using (Aitag_DBContext con = new Aitag_DBContext())
{
string sqlstr = "select CAST(CAST(NEWID() AS binary(3)) AS int) as cjid, empid, empname, dptid ,NULL as clogdate,'' as clogstime, '' as clogetime, '' as clogstatus, '' as clogcomment, sum(cloghour) as cloghour , '' as comid, '' as bmodid, NULL as bmoddate, cchkstatus, '' as cchkcomment, '' as cchkownman, NULL as cchkowndate from cardjudgelog where comid='" + Session["comid"].ToString() + "' and";
if (!string.IsNullOrWhiteSpace(ViewBag.qdptid))
{
sqlstr += " dptid = '" + ViewBag.qdptid + "' and ";
}
if (!string.IsNullOrWhiteSpace(ViewBag.qempname))
{
sqlstr += " empname like '%" + ViewBag.qempname + "%' and ";
}
if (!string.IsNullOrWhiteSpace(ViewBag.qclogsdate))
{
sqlstr += " clogdate >= '" + ViewBag.qclogsdate + "' and ";
}
if (!string.IsNullOrWhiteSpace(ViewBag.qclogedate))
{
sqlstr += " clogdate <= '" + ViewBag.qclogedate + "' and ";
}
if (!string.IsNullOrWhiteSpace(ViewBag.qcchkstatus))
{
sqlstr += " cchkstatus = '" + ViewBag.qcchkstatus + "' and ";
}
sqlstr = sqlstr.Substring(0, sqlstr.Length - 5);
sqlstr += " group by dptid, empid, empname, cchkstatus order by dptid,empid";
var query = con.cardjudgelog.SqlQuery(sqlstr).AsQueryable();
result = query.ToPagedList <cardjudgelog>(page.Value - 1, (int)Session["pagesize"]);
}
ViewBag.SetOrder_ch = SetOrder_ch(orderdata, orderdata1);
return(View(result));
}
public ActionResult csvsystemlogout(int?page, string orderdata, string orderdata1)
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "slid";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = "desc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qcomid = "", qsflag = "", qslaccount = "", qsltext = "", qsodate1 = "", qsodate2 = "";
if (!string.IsNullOrWhiteSpace(Request["qcomid"]))
{
qcomid = Request["qcomid"].Trim();
ViewBag.qcomid = qcomid;
}
if (!string.IsNullOrWhiteSpace(Request["qsflag"]))
{
qsflag = Request["qsflag"].Trim();
ViewBag.qsflag = qsflag;
}
if (!string.IsNullOrWhiteSpace(Request["qslaccount"]))
{
qslaccount = Request["qslaccount"].Trim();
ViewBag.qslaccount = qslaccount;
}
if (!string.IsNullOrWhiteSpace(Request["qsltext"]))
{
qsltext = Request["qsltext"].Trim();
ViewBag.qsltext = qsltext;
}
if (!string.IsNullOrWhiteSpace(Request["qsodate1"]))
{
qsodate1 = Request["qsodate1"].Trim();
ViewBag.qsodate1 = qsodate1;
}
if (!string.IsNullOrWhiteSpace(Request["qsodate2"]))
{
qsodate2 = Request["qsodate2"].Trim();
ViewBag.qsodate2 = qsodate2;
}
//IPagedList<systemlog> result;
string Excel = "", Excel2 = "";
string sqlstr = "";
using (Aitag_DBContext con = new Aitag_DBContext())
{
sqlstr = "select * from systemlog where";
if (qcomid != "")
{
sqlstr += " comid = '" + qcomid + "' and";
}
if (qsflag != "")
{
sqlstr += " sflag = '" + qsflag + "' and";
}
if (qslaccount != "")
{
sqlstr += " slaccount = '" + qslaccount + "' and";
}
if (qsltext != "")
{
sqlstr += " (slevent like N'%" + qsltext + "%' or sname like N'%" + qsltext + "%') and";
}
if (qsodate1 == "")
{
qsodate1 = DateTime.Now.ToString("yyyy") + "/1/1";
}
if (qsodate2 == "")
{
DateTime date2 = new DateTime(DateTime.Now.Year + 1, 1, 1);
date2 = date2.AddDays(-1);
qsodate2 = date2.ToString("yyyy/MM/dd");
}
string DateEx = "";
try
{
DateTime.Parse(qsodate1);
sqlstr += " sodate >= '" + qsodate1 + "' and";
}
catch
{
DateEx += @"異動時間起格式錯誤!!\n";
}
try
{
DateTime.Parse(qsodate2);
sqlstr += " sodate <= '" + qsodate2 + "' and";
}
catch
{
DateEx += @"異動時間訖格式錯誤!!\n";
}
if (DateEx != "")
{
ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>";
}
sqlstr = sqlstr.Substring(0, sqlstr.Length - 5);
sqlstr += " order by " + orderdata + " " + orderdata1;
//var query = con.systemlog.SqlQuery(sqlstr).AsQueryable();
//result = query.ToPagedList<systemlog>(0, 10000);
}
Excel += "<HTML>";
Excel += "<HEAD>";
Excel += @"<meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"">";
Excel += "</HEAD>";
Excel += "<body>";
Excel += "<table border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 bordercolordark=#ffffff width=900 >";
Excel += "<tr align=center>";
Excel += "<td>異動狀態</td>";
Excel += "<td>使用者帳號</td>";
Excel += "<td>使用功能</td>";
Excel += "<td>內容</td>";
Excel += "<td>登入IP</td>";
Excel += "<td>異動時間</td>";
Excel += "</tr>";
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext"))
{
using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
{
SqlDataReader dr = cmd.ExecuteReader();
string sflag = "", empname = "";
while (dr.Read())
{
switch (dbobj.get_dbnull2(dr["sflag"]))
{
case "A":
sflag = "新增";
break;
case "M":
sflag = "修改";
break;
case "D":
sflag = "刪除";
break;
case "L":
sflag = "登入";
break;
default:
sflag = "";
break;
}
empname = dbobj.get_dbvalue(conn, "select empname from employee where empid='" + dbobj.get_dbnull2(dr["slaccount"]) + "'");
Excel2 += "<tr>";
Excel2 += "<td>" + sflag.Trim() + "</td>";
Excel2 += "<td>" + empname.Trim() + "</td>";
Excel2 += "<td>" + dbobj.get_dbnull2((dr["sname"])).Trim() + "</td>";
Excel2 += "<td>" + dbobj.get_dbnull2((dr["slevent"])).Trim() + "</td>";
Excel2 += "<td>" + dbobj.get_dbnull2((dr["sfromip"])).Trim() + "</td>";
Excel2 += "<td>" + dr["sodate"] + "</td>";
Excel2 += "</tr>";
}
if (Excel2 == "")
{
Excel += "<tr align=left><td colspan=6>目前沒有資料</td></tr>";
}
else
{
Excel += Excel2;
}
dr.Close();
}
}
Excel += "</table>";
Excel += "</body>";
Excel += "</HTML>";
ViewBag.Excel = Excel;
return(View());
}
//[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");
}
}
}
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 Transfer(string sysflag, vend_contractdet col, HttpPostedFileBase upfile)
{
ViewBag.vcid = Request["vcid"].ToString();
if (sysflag != "A")
{
return(View());
}
else
{
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
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 = "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; //匯入資料
string[] toptmparry; //匯入的第一筆資料(欄位)
int tmparrycount = 0; //匯入欄位數
tmpstridno = allstr.Split(System.Environment.NewLine.ToCharArray());
//找第一筆的欄位數
toptmparry = tmpstridno[0].Split(',');
for (int tmpi = 0; tmpi <= toptmparry.Length - 1; tmpi++)
{
if (toptmparry[tmpi] != "")
{
tmparrycount++;
}
}
SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
string[] tmparry;
int vitemno = 0;
for (int i = 1; i <= tmpstridno.Length - 1; i++)
{
if (tmpstridno[i] != "")
{
#region
inputcount++;
tmparry = tmpstridno[i].Split(',');
//判斷必填欄位
if (tmparry[0] != "" && tmparry[1] != "")
{
// 品項編號0 品項名稱1 單位2 數量3 單價4 金額5 備註6
vitemno = vitemno + 2;
col.vcid = int.Parse(ViewBag.vcid);
col.bdprodno = tmparry[0];
col.bdprodtitle = tmparry[1];
col.vitemno = vitemno;
col.pdunit = tmparry[2];
col.vccount = int.Parse(tmparry[3]);
col.vcmoney = int.Parse(tmparry[4]);
col.vcallmoney = int.Parse(tmparry[5]);
col.vcdcomment = tmparry[6];
col.comid = Session["comid"].ToString();
col.bmodid = Session["tempid"].ToString();
col.bmoddate = DateTime.Now;
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
con.vend_contractdet.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();
//=================================================
}
}
#endregion
}
}
}
else
{
ViewBag.AddModelError = @"alert('上傳格式錯誤！');";
return(View());
}
}
ViewBag.AddModel = @"alert('轉檔成功！');" +
@"parent.opener.location.href = '/custcontract/detlist?vcid=" + ViewBag.vcid + "&sid=" + Request["sid"].ToString() + "&realsid=" + Request["realsid"].ToString() + "';" +
@"window.close();";
return(View());
}
}
//[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
});
}
//[HttpGet]
//public ActionResult Add()
//{
// ViewBag.Ifboss = Session["Ifboss"].ToString();
// ViewBag.rsid = Session["rsid"].ToString();
// resthourlog col = new resthourlog();
// return View(col);
//}
//[HttpPost]
public ActionResult add(resthourlog col, string sysflag, int?page, string orderdata, string orderdata1)
{
ModelState.Clear();
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "rsid";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = "desc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qdptid = "", qempname = "", qaddtype = "", qaddsdate = "", qaddedate = "";
if (!string.IsNullOrWhiteSpace(Request["qdptid"]))
{
qdptid = Request["qdptid"].Trim();
ViewBag.qdptid = qdptid;
}
if (!string.IsNullOrWhiteSpace(Request["qempname"]))
{
qempname = Request["qempname"].Trim();
ViewBag.qempname = qempname;
}
if (!string.IsNullOrWhiteSpace(Request["qaddtype"]))
{
qaddtype = Request["qaddtype"].Trim();
ViewBag.qaddtype = qaddtype;
}
if (!string.IsNullOrWhiteSpace(Request["qaddsdate"]))
{
qaddsdate = Request["qaddsdate"].Trim();
ViewBag.qaddsdate = qaddsdate;
}
if (!string.IsNullOrWhiteSpace(Request["qaddedate"]))
{
qaddedate = Request["qaddedate"].Trim();
ViewBag.qaddedate = qaddedate;
}
if (sysflag != "A")
{
resthourlog newcol = new resthourlog();
return(View(newcol));
}
else
{
if (!ModelState.IsValid)
{
return(View(col));
}
else
{
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
SqlDataReader dr;
SqlCommand sqlsmd = new SqlCommand();
sqlsmd.Connection = conn;
string sqlstr = "select rsid from resthourlog where rsid = '" + col.rsid + "'";
sqlsmd.CommandText = sqlstr;
dr = sqlsmd.ExecuteReader();
if (dr.Read())
{
ModelState.AddModelError("", "權限代碼重複!");
return(View(col));
}
dr.Close();
dr.Dispose();
sqlsmd.Dispose();
conn.Close();
conn.Dispose();
col.otlogid = 0;
col.resmoney = 0;
col.inout = "0";
col.comid = Session["comid"].ToString();
col.bmodid = Session["tempid"].ToString();
col.bmoddate = DateTime.Now;
using (Aitag_DBContext con = new Aitag_DBContext())
{
con.resthourlog.Add(col);
try
{
con.SaveChanges();
}
catch (Exception ex)
{
throw;
}
//系統LOG檔 //================================================= //
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
string sysrealsid = Request["sysrealsid"].ToString();
string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
string sysnote = "代碼:" + col.rsid + "名稱:" + col.empid;
dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
sysconn.Close();
sysconn.Dispose();
//=================================================
}
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/resthourcheck1/List' method='post'>";
tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
tmpform += "<input type=hidden id='qdptid' name='qdptid' value='" + qdptid + "'>";
tmpform += "<input type=hidden id='qempname' name='qempname' value='" + qempname + "'>";
tmpform += "<input type=hidden id='qaddtype' name='qaddtype' value='" + qaddtype + "'>";
tmpform += "<input type=hidden id='qaddsdate' name='qaddsdate' value='" + qaddsdate + "'>";
tmpform += "<input type=hidden id='qaddedate' name='qaddedate' value='" + qaddedate + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
// return RedirectToAction("List");
}
}
}
public ActionResult resthourcheck1rpt(int?page, string orderdata, string orderdata1)
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "resthourlog.adddate";
}
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["qaddedate"]))
{
qaddedate = Request["qaddedate"].Trim();
ViewBag.qaddedate = qaddedate;
}
qaddsdate = NullStDate(Request["qaddsdate"]);
ViewBag.qaddsdate = qaddsdate;
qaddedate = NullTeDate(Request["qaddedate"]);
ViewBag.qaddedate = qaddedate;
//NullStDate 跟 NullTeDate 會判斷格式，有錯誤就 修改全域的DateEx
if (DateEx != "")
{
ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>";
}
string Excel = "", Excel2 = "";
string sqlstr = "";
using (Aitag_DBContext con = new Aitag_DBContext())
{
sqlstr = "SELECT * FROM resthourlog ";
sqlstr += " INNER JOIN employee ON resthourlog.empid = employee.empid ";
sqlstr += " where resthourlog.rstype='2' and resthourlog.ifactive = 'y'";
if (qdptid != "")
{
sqlstr += " and employee.empworkdepid ='" + qdptid + "'";
}
if (qempname != "")
{
sqlstr += " and employee.empname like N'%" + qempname + "%'";
}
if (qaddtype != "")
{
switch (qaddtype)
{
case "1":
sqlstr += " and resthourlog.resthour > 0";
break;
case "2":
sqlstr += " and resthourlog.moneyhour > 0";
break;
case "3":
sqlstr += " and resthourlog.ifdinner = 'y'";
break;
default:
break;
}
}
if (qaddsdate != "")
//{ sqlstr += " and resthourlog.adddate >= '" + qaddsdate + "'"; }
{
sqlstr += " and resthourlog.adddate >= '2016/03/01'";
}
if (qaddedate != "")
{
sqlstr += " and resthourlog.adddate <= '" + qaddedate + "'";
}
sqlstr += " order by " + orderdata + " " + orderdata1;
}
#region 組 Excel 格式
Excel += "<HTML>";
Excel += "<HEAD>";
Excel += @"<meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"">";
Excel += "</HEAD>";
Excel += "<body>";
Excel += "<table border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 bordercolordark=#ffffff width=900 >";
Excel += "<tr align=center>";
Excel += @"<td colspan=""11"" style=""font-size:14pt"">加班時數紀錄表";
if (qaddsdate != "" || qaddedate != "")
{
Excel += qaddsdate + "~" + qaddedate;
}
Excel += "</td>";
Excel += "</tr>";
Excel += "<tr align=center>";
Excel += "<td>加班日期</td>";
Excel += "<td>部門</td>";
Excel += "<td>申請人</td>";
Excel += "<td>加班時數</td>";
Excel += "<td>請款時數</td>";
Excel += "<td>1.34</td>";
Excel += "<td>1.67</td>";
Excel += "<td>1.0(假日)</td>";
Excel += "<td>補休時數</td>";
Excel += "<td>已休時數</td>";
Excel += "<td>補休期限</td>";
Excel += "</tr>";
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext"))
{
using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
{
SqlDataReader dr = cmd.ExecuteReader();
string dpttitle = "", empname = "";
double hour = 0;
while (dr.Read())
{
using (SqlConnection conn1 = dbobj.get_conn("Aitag_DBContext"))
{
dpttitle = dbobj.get_dbvalue(conn1, "select dpttitle form Department where dptid='" + dr["empworkdepid"] + "'");
empname = dbobj.get_name(conn1, dbobj.get_dbnull2(dr["empid"]));
}
hour = Convert.ToDouble(dr["resthour"]) + Convert.ToDouble(dr["moneyhour"]);
Excel2 += "<tr>";
Excel2 += "<td>" + Convert.ToDateTime(dr["adddate"]).ToString("yyyy/MM/dd") + "</td>";
Excel2 += "<td>" + dpttitle + "</td>";
Excel2 += "<td>" + empname + "</td>";
Excel2 += "<td>" + hour + "</td>";
Excel2 += "<td>" + dr["moneyhour"] + "</td>";
Excel2 += "<td>" + dr["moneyh1"] + "</td>";
Excel2 += "<td>" + dr["moneyh2"] + "</td>";
Excel2 += "<td>" + dr["moneyh3"] + "</td>";
Excel2 += "<td>" + dr["resthour"] + "</td>";
Excel2 += "<td>" + dr["usehour"] + "</td>";
Excel2 += "<td>" + dr["rsdeaddate"] + "</td>";
Excel2 += "</tr>";
//dbobj.get_dbnull2().Trim()
}
if (Excel2 == "")
{
Excel += "<tr align=left><td colspan=6>目前沒有資料</td></tr>";
}
else
{
Excel += Excel2;
}
dr.Close();
}
}
#endregion
Excel += "</table>";
Excel += "</body>";
Excel += "</HTML>";
ViewBag.Excel = Excel;
return(View());
}
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 }));
}
}
//[HttpGet]
//public ActionResult Add()
//{
// ViewBag.Ifboss = Session["Ifboss"].ToString();
// ViewBag.Msid = Session["Msid"].ToString();
// workitem col = new workitem();
// return View(col);
//}
//[HttpPost]
public ActionResult add(workitem col, string sysflag, int?page, string orderdata, string orderdata1)
{
ModelState.Clear();
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "corp_no";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = "desc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qcorp_no = "", qworkitem = "";
if (!string.IsNullOrWhiteSpace(Request["qcorp_no"]))
{
qcorp_no = Request["qcorp_no"].Trim();
ViewBag.qcorp_no = qcorp_no;
}
if (!string.IsNullOrWhiteSpace(Request["qworkitem"]))
{
qworkitem = Request["qworkitem"].Trim();
ViewBag.qworkitem = qworkitem;
}
if (sysflag != "A")
{
workitem newcol = new workitem();
return(View(newcol));
}
else
{
if (!ModelState.IsValid)
{
return(View(col));
}
else
{
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
SqlConnection conn = dbobj.get_conn("AitagBill_DBContext");
SqlDataReader dr;
SqlCommand sqlsmd = new SqlCommand();
sqlsmd.Connection = conn;
string sqlstr = "select corp_no from workitem where corp_no = '" + col.corp_no + "' and work_no_code = '" + col.work_no_code + "'";
sqlsmd.CommandText = sqlstr;
dr = sqlsmd.ExecuteReader();
if (dr.Read())
{
ModelState.AddModelError("", "項目代碼重複!");
return(View(col));
}
dr.Close();
dr.Dispose();
sqlsmd.Dispose();
conn.Close();
conn.Dispose();
col.comid = Session["comid"].ToString();
col.bmodid = Session["tempid"].ToString();
col.hourgroup = Request["hourgroup"].Trim();
col.bmoddate = DateTime.Now;
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
con.workitem.Add(col);
con.SaveChanges();
//系統LOG檔 //================================================= //
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
string sysrealsid = Request["sysrealsid"].ToString();
string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
string sysnote = "所屬公司:" + col.corp_no + "項目代碼:" + col.work_no_code + "項目名稱:" + col.workitemname;
dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
sysconn.Close();
sysconn.Dispose();
//=================================================
}
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/workitem/List' method='post'>";
tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
tmpform += "<input type=hidden id='qcorp_no' name='qcorp_no' value='" + qcorp_no + "'>";
tmpform += "<input type=hidden id='qworkitem' name='qworkitem' value='" + qworkitem + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
// return RedirectToAction("List");
}
}
}
public ActionResult csvcardabnormallog(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["qclogsdate"]))
{
qclogsdate = Request["qclogsdate"].Trim();
ViewBag.qclogsdate = qclogsdate;
}
if (!string.IsNullOrWhiteSpace(Request["qclogedate"]))
{
qclogedate = Request["qclogedate"].Trim();
ViewBag.qclogedate = qclogedate;
}
//NullStDate 跟 NullTeDate 會判斷格式，有錯誤就 修改全域的DateEx
if (DateEx != "")
{
ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>";
}
string Excel = "", Excel2 = "";
string sqlstr = "";
using (Aitag_DBContext con = new Aitag_DBContext())
{
sqlstr = "SELECT * FROM cardjudgelog where comid='" + (string)Session["comid"] + "' and";
if (qdptid != "")
{
sqlstr += " dptid='" + qdptid + "' and";
}
if (qempname != "")
{
sqlstr += " empname like N'%" + qempname + "%' and";
}
if (qclogsdate != "")
{
sqlstr += " clogdate >= '" + qclogsdate + "' and";
}
if (qclogedate != "")
{
sqlstr += " clogdate <= '" + qclogedate + "' and";
}
if (qclogstatus != "")
{
sqlstr += " clogstatus = '" + qclogstatus + "' and";
}
if (qempid != "")
{
sqlstr += " empid = '" + qempid + "' and";
}
sqlstr = sqlstr.Substring(0, sqlstr.Length - 5);
sqlstr += " order by " + orderdata + " " + orderdata1;
//var query = con.systemlog.SqlQuery(sqlstr).AsQueryable();
//result = query.ToPagedList<systemlog>(0, 10000);
}
Excel += "<HTML>";
Excel += "<HEAD>";
Excel += @"<meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"">";
Excel += "</HEAD>";
Excel += "<body>";
Excel += "<table border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 bordercolordark=#ffffff width=900 >";
Excel += "<tr align=center>";
Excel += "<td>部門</td>";
Excel += "<td>員工姓名</td>";
Excel += "<td>刷卡日期</td>";
Excel += "<td>上班刷卡</td>";
Excel += "<td>下班刷卡</td>";
Excel += "<td>星期</td>";
Excel += "<td>工時</td>";
Excel += "<td>差勤狀態</td>";
Excel += "<td>備註</td>";
Excel += "</tr>";
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext"))
{
using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
{
SqlDataReader dr = cmd.ExecuteReader();
string clogstatus = "";
while (dr.Read())
{
switch (dbobj.get_dbnull2(dr["clogstatus"]))
{
case "0":
clogstatus = "正常";
break;
case "1":
clogstatus = "遲到";
break;
case "2":
clogstatus = "早退";
break;
case "3":
clogstatus = "曠職";
break;
case "4":
clogstatus = "未到職";
break;
default:
clogstatus = "";
break;
}
//string dpttitle = dbobj.get_dbvalue(conn, "select dpttitle from department where dptid='" + dbobj.get_dbnull2(dr["dptid"]) + "'");
string tmpsql = "select dpttitle from Department where dptid='" + dbobj.get_dbnull2(dr["dptid"]) + "' and comid='" + (string)Session["comid"] + "'";
SqlConnection conn1 = dbobj.get_conn("Aitag_DBContext");
string dpttitle = dbobj.get_dbvalue(conn1, tmpsql);
conn1.Close();
conn1.Dispose();
string tmpstime = dbobj.get_dbnull2((dr["clogstime"])).Trim();
if (tmpstime.Length == 6)
{
string tmpstime1 = tmpstime.Substring(0, 2);
if (tmpstime1 == "24")
{
tmpstime1 = "00";
}
tmpstime = tmpstime1 + ":" + tmpstime.Substring(2, 2) + ":" + tmpstime.Substring(4, 2);
}
else
{
tmpstime = "";
}
string tmpetime = dbobj.get_dbnull2((dr["clogetime"])).Trim();
if (tmpetime.Length == 6)
{
string tmpetime1 = tmpetime.Substring(0, 2);
if (tmpetime1 == "24")
{
tmpetime1 = "00";
}
tmpetime = tmpetime1 + ":" + tmpetime.Substring(2, 2) + ":" + tmpetime.Substring(4, 2);
}
else
{
tmpetime = "";
}
string weekofday = Convert.ToDateTime(dbobj.get_dbnull2((dr["clogdate"])).Trim()).ToString("ddd");
weekofday = weekofday.Substring(1, 1);
string thours = dr["cloghour"].ToString(); //工時
if (Convert.ToDouble(dr["cloghour"]) < 0)
{
thours = "0";
}
Excel2 += "<tr>";
Excel2 += "<td>" + dpttitle + "</td>";
Excel2 += "<td>" + dbobj.get_dbnull2(dr["empname"]) + "</td>";
Excel2 += "<td>" + Convert.ToDateTime(dr["clogdate"]).ToString("yyyy/MM/dd") + "</td>";
Excel2 += "<td>" + tmpstime + "</td>";
Excel2 += "<td>" + tmpetime + "</td>";
Excel2 += "<td>" + weekofday + "</td>";
Excel2 += "<td>" + thours + "</td>";
Excel2 += "<td>" + clogstatus.Trim() + "</td>";
Excel2 += "<td>" + dbobj.get_dbnull2((dr["clogcomment"])).Trim() + "</td>";
Excel2 += "</tr>";
}
if (Excel2 == "")
{
Excel += "<tr align=left><td colspan=9>目前沒有資料</td></tr>";
}
else
{
Excel += Excel2;
}
dr.Close();
}
}
Excel += "</table>";
Excel += "</body>";
Excel += "</HTML>";
ViewBag.Excel = Excel;
return(View());
}
//[HttpGet]
//public ActionResult Add()
//{
// ViewBag.Ifboss = Session["Ifboss"].ToString();
// ViewBag.Msid = Session["Msid"].ToString();
// Checkcode col = new Checkcode();
// return View(col);
//}
//[HttpPost]
public ActionResult add(Checkcode col, string sysflag, int?page, string orderdata, string orderdata1)
{
ModelState.Clear();
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "cid";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = "desc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qchkclass = "", qchkitem = "";
if (!string.IsNullOrWhiteSpace(Request["qchkclass"]))
{
qchkclass = Request["qchkclass"].Trim();
ViewBag.qchkclass = qchkclass;
}
if (!string.IsNullOrWhiteSpace(Request["qchkitem"]))
{
qchkitem = Request["qchkitem"].Trim();
ViewBag.qchkitem = qchkitem;
}
if (sysflag != "A")
{
Checkcode newcol = new Checkcode();
return(View(newcol));
}
else
{
if (!ModelState.IsValid)
{
return(View(col));
}
else
{
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
SqlDataReader dr;
SqlCommand sqlsmd = new SqlCommand();
sqlsmd.Connection = conn;
string sqlstr = "select cid from Checkcode where chkclass = '" + col.chkclass + "' and chkcode = '" + col.chkcode + "'";
sqlsmd.CommandText = sqlstr;
dr = sqlsmd.ExecuteReader();
if (dr.Read())
{
ModelState.AddModelError("", "共用代碼重複!");
return(View(col));
}
dr.Close();
dr.Dispose();
sqlsmd.Dispose();
conn.Close();
conn.Dispose();
//密碼加密
//col.emppasswd = dbobj.Encrypt(col.emppasswd);
//col.chkclass = col.emppasswd;
//col.baddid = Session["tempid"].ToString();
col.bmodid = Session["tempid"].ToString();
//col.badddate = DateTime.Now;
col.bmoddate = DateTime.Now;
using (Aitag_DBContext con = new Aitag_DBContext())
{
con.Checkcode.Add(col);
con.SaveChanges();
//系統LOG檔 //================================================= //
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
string sysrealsid = Request["sysrealsid"].ToString();
string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
string sysnote = "類別:" + col.chkclasstitle + "代碼名稱:" + col.chkitem;
dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
sysconn.Close();
sysconn.Dispose();
//=================================================
}
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/Checkcode/List' method='post'>";
tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
tmpform += "<input type=hidden id='qchkclass' name='qchkclass' value='" + qchkclass + "'>";
tmpform += "<input type=hidden id='qchkitem' name='qchkitem' value='" + qchkitem + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
// return RedirectToAction("List");
}
}
}
public ActionResult csvmonthcard(int?page, string orderdata, string orderdata1)
{
string qdptid = "", qempname = "", qclogsdate = "", qclogedate = "", qcchkstatus = "";
string sql = "select CAST(CAST(NEWID() AS binary(3)) AS int) as cjid, empid, empname, dptid ,NULL as clogdate,'' as clogstime, '' as clogetime, '' as clogstatus, '' as clogcomment, sum(cloghour) as cloghour , '' as comid, '' as bmodid, NULL as bmoddate, cchkstatus, '' as cchkcomment, '' as cchkownman, NULL as cchkowndate from cardjudgelog where comid='" + Session["comid"].ToString() + "' and";
if (!string.IsNullOrWhiteSpace(Request["qdptid"].ToString()))
{
sql += " dptid = '" + Request["qdptid"].ToString() + "' and ";
}
if (!string.IsNullOrWhiteSpace(Request["qempname"].ToString()))
{
sql += " empname like '%" + Request["qempname"].ToString() + "%' and ";
}
if (!string.IsNullOrWhiteSpace(Request["qclogsdate"].ToString()))
{
sql += " clogdate >= '" + Request["qclogsdate"].ToString() + "' and ";
}
if (!string.IsNullOrWhiteSpace(Request["qclogedate"].ToString()))
{
sql += " clogdate <= '" + Request["qclogedate"].ToString() + "' and ";
}
if (!string.IsNullOrWhiteSpace(Request["qcchkstatus"].ToString()))
{
sql += " cchkstatus = '" + Request["qcchkstatus"].ToString() + "' and ";
}
sql = sql.Substring(0, sql.Length - 5);
sql += " group by dptid, empid, empname, cchkstatus order by dptid,empid";
string Excel = "", Excel2 = "";
Excel += "<HTML>";
Excel += "<HEAD>";
Excel += @"<meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"">";
Excel += "</HEAD>";
Excel += "<body>";
Excel += "<table border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 bordercolordark=#ffffff width=900 >";
Excel += "<tr align=center>";
Excel += "<td>確認狀態</td>";
Excel += "<td>差勤日期</td>";
Excel += "<td>部門</td>";
Excel += "<td>員工姓名</td>";
Excel += "<td>工時</td>";
Excel += "</tr>";
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext"))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string cchkstatus = "";
switch (dr["cchkstatus"].ToString())
{
case "0":
cchkstatus = "未確認";
break;
case "1":
cchkstatus = "發信通知";
break;
case "2":
cchkstatus = "已確認";
break;
default:
break;
}
Excel2 += "<tr>";
Excel2 += "<td>" + cchkstatus.Trim() + "</td>";
Excel2 += "<td>" + Request["qclogsdate"].ToString() + "~" + Request["qclogedate"].ToString() + "</td>";
using (SqlConnection conn1 = dbobj.get_conn("Aitag_DBContext"))
{
Excel2 += "<td>" + dbobj.get_dbvalue(conn1, "select dpttitle from Department where dptid='" + dr["dptid"].ToString() + "'") + "</td>";
}
Excel2 += "<td>" + dbobj.get_dbnull2(dr["empname"]) + "</td>";
Excel2 += "<td>" + dbobj.get_dbnull2(dr["cloghour"]) + "</td>";
Excel2 += "</tr>";
}
if (Excel2 == "")
{
Excel += "<tr align=left><td colspan=6>目前沒有資料</td></tr>";
}
else
{
Excel += Excel2;
}
dr.Close();
}
}
Excel += "</table>";
Excel += "</body>";
Excel += "</HTML>";
ViewBag.Excel = Excel;
return(View());
}
public ActionResult daliyreportrpt(int?page, string orderdata, string orderdata1)
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "empworkdepid,empid";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = "asc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qdptid = "", qhlogstatus = "", qempname = "", qworksdate = "", qworkedate = "", hdayid = "";
if (!string.IsNullOrWhiteSpace(Request["qdptid"]))
{
qdptid = Request["qdptid"].Trim();
ViewBag.qdptid = qdptid;
}
if (!string.IsNullOrWhiteSpace(Request["qempname"]))
{
qempname = Request["qempname"].Trim();
ViewBag.qempname = qempname;
}
//繞細項用 qhlogstatus qworksdate qworkedate
if (!string.IsNullOrWhiteSpace(Request["qhlogstatus"]))
{
qhlogstatus = Request["qhlogstatus"].Trim();
ViewBag.qhlogstatus = qhlogstatus;
}
qworksdate = NullStDate(Request["qworksdate"]);
ViewBag.qworksdate = qworksdate;
qworkedate = NullTeDate(Request["qworkedate"]);
ViewBag.qworkedate = qworkedate;
//NullStDate 跟 NullTeDate 會判斷格式，有錯誤就 修改全域的DateEx
if (DateEx != "")
{
ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>";
}
if (!string.IsNullOrWhiteSpace(Request["hdayid"]))
{
hdayid = Request["hdayid"].Trim();
ViewBag.hdayid1 = get_hdaytitle(hdayid);
}
else
{
hdayid = "A01,A02,A03,A04,A05,A06";
ViewBag.hdayid1 = get_hdaytitle(hdayid);
}
string Excel = "", Excel2 = "";
string sqlstr = "";
using (Aitag_DBContext con = new Aitag_DBContext())
{
sqlstr = "select * from employee where empstatus<>'4' and empworkcomp='" + (string)Session["comid"] + "' and";
//'部門 組多筆
if (qdptid != "")
{
string tmpa = "";
tmpa += "'";
tmpa += qdptid.Replace(",", "','");
tmpa += "'";
sqlstr += " empworkdepid in (" + tmpa + ") and";
}
if (qempname != "")
{
sqlstr += " empname like N'%" + qempname + "%' and";
}
sqlstr = sqlstr.Substring(0, sqlstr.Length - 5);
sqlstr += " order by " + orderdata + " " + orderdata1;
}
#region 組 Excel 格式
Excel += "<HTML>";
Excel += "<HEAD>";
Excel += @"<meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"">";
Excel += "</HEAD>";
Excel += "<body>";
Excel += "<table border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 bordercolordark=#ffffff width=900 >";
Excel += "<tr align=center>";
Excel += @"<td colspan=""11"" style=""font-size:14pt"">員工請假統計表 ";
if (qworksdate != "" || qworkedate != "")
{
Excel += qworksdate + "~" + qworkedate;
}
Excel += "</td>";
Excel += "</tr>";
Excel += "<tr align=center>";
int count = ViewBag.hdayid1.Count + 3;
Excel += "<td colspan='" + count + "' ></td><td>製表日期：" + DateTime.Now.ToString("yyyy/MM/dd") + "</td>";
Excel += "</tr>";
Excel += "<tr align=center>";
Excel += "<td>部門</td>";
Excel += "<td>員工姓名</td>";
Excel += "<td>到職日</td>";
foreach (string v in ViewBag.hdayid1)
{
Excel += "<td>" + v + "</td>";
}
Excel += "<td>合計時</td>";
Excel += "</tr>";
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext"))
{
using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
{
SqlDataReader dr = cmd.ExecuteReader();
string dpttitle = "", empname = "";
using (SqlConnection comconn = dbobj.get_conn("Aitag_DBContext"))
{
while (dr.Read())
{
using (SqlConnection conn1 = dbobj.get_conn("Aitag_DBContext"))
{
dpttitle = dbobj.get_dbvalue(conn1, "select dpttitle form Department where dptid='" + dr["empworkdepid"] + "'");
empname = dbobj.get_dbnull2(dr["empname"]);
}
Excel2 += "<tr>";
Excel2 += "<td>" + dpttitle + "</td>";
Excel2 += "<td>" + empname + "</td>";
Excel2 += "<td>" + Convert.ToDateTime(dr["jobdate"]).ToString("yyyy/MM/dd") + "</td>";
Excel2 += get_daliyreportHour(comconn, dbobj.get_dbnull2(dr["empid"]), dbobj.get_dbnull2(dr["empworkcomp"]));
Excel2 += "</tr>";
//dbobj.get_dbnull2().Trim()
}
}
if (Excel2 == "")
{
Excel += "<tr align=left><td colspan=6>目前沒有資料</td></tr>";
}
else
{
Excel += Excel2;
}
dr.Close();
}
}
Excel += "</table>";
Excel += "</body>";
Excel += "</HTML>";
#endregion
ViewBag.Excel = Excel;
return(View());
}
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 battamoneyrpt(int?page, string orderdata, string orderdata1)
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "bsno";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = "desc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qblogstatus = "", qempname = "", qdptid = "", qblogsdate = "", qblogedate = "";
if (!string.IsNullOrWhiteSpace(Request["qblogstatus"]))
{
qblogstatus = Request["qblogstatus"].Trim();
ViewBag.qblogstatus = qblogstatus;
}
if (!string.IsNullOrWhiteSpace(Request["qempname"]))
{
qempname = Request["qempname"].Trim();
ViewBag.qempname = qempname;
}
if (!string.IsNullOrWhiteSpace(Request["qdptid"]))
{
qdptid = Request["qdptid"].Trim();
ViewBag.qdptid = qdptid;
}
qblogsdate = NullStDate(Request["qblogsdate"]);
qblogsdate = "2016/03/01";
ViewBag.qblogsdate = qblogsdate;
qblogedate = NullTeDate(Request["qblogedate"]);
ViewBag.qblogedate = qblogedate;
//NullStDate 跟 NullTeDate 會判斷格式，有錯誤就 修改全域的DateEx
if (DateEx != "")
{
ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>";
}
string Excel = "", Excel2 = "";
string sqlstr = "";
using (Aitag_DBContext con = new Aitag_DBContext())
{
string viewid = "";
string[] mpriv = (string[])Session["priv"];
//viewid = get_viewpriv(int.Parse(funcpriv(2)), int.Parse(mpriv(realsid, 2)));
sqlstr = "select * from battalog where (blogtype='1' or (blogtype='2' and (pbsno='' or pbsno is null )) ) and comid='" + (string)Session["comid"] + "'";
if (viewid != "")
{
sqlstr += " and bmodid = '" + viewid + "'";
}
if (qblogstatus != "" && qblogstatus != "all")
{
sqlstr += " and blogstatus = '" + qblogstatus + "'";
}
else if (qblogstatus == "")
{
sqlstr += " and blogstatus = '1'";
ViewBag.qblogstatus = "1";
}
if (qempname != "")
{
sqlstr += " and empname like N'%" + qempname + "%'";
}
if (qdptid != "")
{
sqlstr += " and dptid='" + qdptid + "'";
}
sqlstr += " and (( blogsdate >= '" + qblogsdate + "' and blogsdate <= '" + qblogedate + "' ) or ";
sqlstr += "( blogedate >= '" + qblogsdate + "' and blogedate <= '" + qblogedate + "'))";
sqlstr += " order by " + orderdata + " " + orderdata1;
}
#region 組 Excel 格式
Excel += "<HTML>";
Excel += "<HEAD>";
Excel += @"<meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"">";
Excel += "</HEAD>";
Excel += "<body>";
Excel += "<table border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 bordercolordark=#ffffff width=900 >";
Excel += "<tr align=center>";
Excel += @"<td colspan=""8"" style=""font-size:14pt"">出差明細表";
Excel += "</td>";
Excel += "</tr>";
Excel += "<tr align=center>";
int count = 7;
Excel += "<td colspan='" + count + "' ></td><td>列印日期：" + DateTime.Now.ToString("yyyy/MM/dd") + "</td>";
Excel += "</tr>";
Excel += "<tr align=center>";
Excel += "<td>狀態</td>";
Excel += "<td>核銷</td>";
Excel += "<td>員工編號</td>";
Excel += "<td>姓名</td>";
Excel += "<td>部門</td>";
Excel += "<td>出差起迄日</td>";
Excel += "<td>出差天數</td>";
Excel += "<td>地點</td>";
Excel += "</tr>";
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext"))
{
using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
{
SqlDataReader dr = cmd.ExecuteReader();
string dpttitle = "";
string empno = "", blogstatus = "", ifhdell = "";
string SEtime = "自{0}({1}時)<br>至{2}({3}時)";
string chkitem = "", blogsdate = "", blogstime = "", blogedate = "", blogetime = "";
int bloghour = 0;
while (dr.Read())
{
blogstatus = dbobj.get_dbnull2(dr["blogstatus"]);
switch (blogstatus)
{
case "0":
blogstatus = "簽核中";
break;
case "1":
blogstatus = "已核准";
break;
case "2":
blogstatus = "退回";
break;
case "D":
blogstatus = "撤回";
break;
default:
break;
}
ifhdell = dbobj.get_dbnull2(dr["ifhdell"]);
if (ifhdell == "y")
{
ifhdell = "是";
}
else if (ifhdell == "n")
{
ifhdell = "否";
}
using (SqlConnection comconn = dbobj.get_conn("Aitag_DBContext"))
{
empno = "select empno from employee where empid='" + dbobj.get_dbnull2(dr["empid"]) + "'"; empno = dbobj.get_dbvalue(comconn, empno);
dpttitle = "select dpttitle from Department where dptid='" + dbobj.get_dbnull2(dr["dptid"]) + "' and comid='" + (string)Session["comid"] + "'"; dpttitle = dbobj.get_dbvalue(comconn, dpttitle);
blogsdate = Convert.ToDateTime(dbobj.get_dbnull2(dr["blogsdate"])).ToString("yyyy/MM/dd");
blogstime = int.Parse(dbobj.get_dbnull2(dr["blogstime"])).ToString("00");
blogedate = Convert.ToDateTime(dbobj.get_dbnull2(dr["blogedate"])).ToString("yyyy/MM/dd");
blogetime = int.Parse(dbobj.get_dbnull2(dr["blogetime"])).ToString("00");
bloghour = int.Parse("0" + dbobj.get_dbnull2(dr["bloghour"]));
if (bloghour > 0)
{
bloghour = bloghour / 8;
}
else
{
bloghour = 0;
}
chkitem = "select chkitem from checkcode where chkclass = '90' and chkcode = '" + dbobj.get_dbnull2(dr["blogaddr"]) + "'"; chkitem = dbobj.get_dbvalue(comconn, chkitem);
}
Excel2 += "<tr>";
Excel2 += "<td>" + blogstatus + "</td>";
Excel2 += "<td>" + ifhdell + "</td>";
Excel2 += "<td>" + empno + "</td>";
Excel2 += "<td>" + dbobj.get_dbnull2(dr["empname"]) + "</td>";
Excel2 += "<td>" + dpttitle + "</td>";
Excel2 += "<td>" + String.Format(SEtime, blogsdate, blogstime, blogedate, blogetime) + "</td>";
Excel2 += "<td>" + bloghour + "</td>";
Excel2 += "<td>" + chkitem;
if (dbobj.get_dbnull2(dr["blogplace"]) != "")
{
Excel2 += dbobj.get_dbnull2(dr["blogplace"]);
}
Excel2 += "</td>";
Excel2 += "</tr>";
}
if (Excel2 == "")
{
Excel += "<tr align=left><td colspan=6>目前沒有資料</td></tr>";
}
else
{
Excel += Excel2;
}
dr.Close();
}
}
#endregion
Excel += "</table>";
Excel += "</body>";
Excel += "</HTML>";
ViewBag.Excel = Excel;
return(View());
}
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
});
}
}
}
}
public ActionResult battamoneyprint(int?page, string orderdata, string orderdata1)
{
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
string qblogid = "";
if (!string.IsNullOrWhiteSpace(Request["qblogid"]))
{
qblogid = Request["qblogid"].Trim();
}
string empname = "", blogcomment = "", blogaddr = "", exrate = "", comid = "", bbillcount = "";
DateTime blogsdate, blogedate;
string sql = "select * from battalog where blogid='" + qblogid + "' and comid='" + (string)Session["comid"] + "'";
using (SqlConnection tconn = dbobj.get_conn("Aitag_DBContext"))
{
using (SqlCommand cmd = new SqlCommand(sql, tconn))
{
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
empname = dr["empname"].ToString();
blogcomment = dr["blogcomment"].ToString();
blogaddr = dr["blogaddr"].ToString();
exrate = dr["exrate"].ToString();
comid = dr["comid"].ToString();
bbillcount = dr["bbillcount"].ToString();
blogsdate = Convert.ToDateTime(dr["blogsdate"]);
blogedate = Convert.ToDateTime(dr["blogedate"]);
dr.Close();
}
tconn.Close();
tconn.Dispose();
}
//參數
string bdmonth = "", bdday = "", bdplace = "", bdwork = "", bdplane = "";
string bdcar = "", bdtrain = "", bdship = "", bdliving1 = "", bdliving2 = "";
string bdother = "", bdbillno = "", bdcomment = "", strsum = "";
double dsum = 0, ttlmoney = 0;
string bland = "", blive = "", bvisa = "", binsurance = "", badmin = "", bgift = "";
int rowcounter = 0;
string listtitle = "", Excel = "", Excel2 = "", sqlstr = "";
int diffday = 0;
using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext")){
//天數
TimeSpan spantime = blogedate - blogsdate;
diffday = spantime.Days + 1;
//表單名稱
string dpttitle = "select comtitle from Company where comid='" + comid + "' ";
dpttitle = dbobj.get_dbvalue(conn, dpttitle);
if (blogaddr == "1")
{
listtitle = dpttitle + "國內出差旅費報告表";
}
else
{
listtitle = dpttitle + "國外出差旅費報告表";
}
#region 組 Excel 格式
Excel += "<HTML>";
Excel += "<HEAD>";
Excel += @"<meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"">";
Excel += "</HEAD>";
Excel += "<body>";
//表頭(國內國外一樣)
Excel += "<div align=center><b><font style='font-size:18pt;font-family:標楷體'>" + listtitle + "</font></b></div>";
Excel += "<table border=1 style='border-collapse:collapse;border:none;mso-border-alt:solid' borderColorDark=#000000 borderColorLight=#000000 cellpadding=6 cellspacing=0 width=100% align=center style='font-size:12pt;font-family:標楷體'>";
Excel += "<tr>";
Excel += "<td width=50>姓名</td>";
Excel += "<td colspan=5>" + empname + " </td>";
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>出差事由</td>";
Excel += "<td colspan=5 width=500>" + blogcomment + " </td>";
Excel += "</tr>";
Excel += "</table>";
//國內(blogaddr=1)國外(blogaddr<>1)不同
sql = "select * from battadet where blogid=" + qblogid + " order by bddate";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
rowcounter++;
if (blogaddr == "1")
{//國內
bdmonth += "<td>" + dr["bdmonth"] + " </td>";
bdday += "<td>" + dr["bdday"] + " </td>";
bdplace += "<td>" + dr["bdplace"] + " </td>";
bdwork += "<td>" + dr["bdwork"] + " </td>";
bdplane += "<td>" + dr["bdplane"] + " </td>";
bdcar += "<td>" + dr["bdcar"] + " </td>";
bdtrain += "<td>" + dr["bdtrain"] + " </td>";
bdship += "<td>" + dr["bdship"] + " </td>";
bdliving1 += "<td>" + dr["bdliving1"] + " </td>";
bdliving2 += "<td>" + dr["bdliving2"] + " </td>";
bdother += "<td>" + dr["bdother"] + " </td>";
bdbillno += "<td>" + dr["bdbillno"] + " </td>";
bdcomment += "<td>" + dr["bdcomment"] + " </td>";
dsum = Convert.ToDouble(dr["bdplane"]) + Convert.ToDouble(dr["bdcar"]) + Convert.ToDouble(dr["bdtrain"]) + Convert.ToDouble(dr["bdship"]) + Convert.ToDouble(dr["bdliving1"]) + Convert.ToDouble(dr["bdliving2"]) + Convert.ToDouble(dr["bdother"]);
strsum += "<td>" + dsum.ToString() + " </td>";
ttlmoney += dsum;
}
else
{//國外
bdmonth += "<td>" + dr["bdmonth"] + " </td>";
bdday += "<td>" + dr["bdday"] + " </td>";
bdplace += "<td>" + dr["bdplace"] + " </td>";
bdwork += "<td>" + dr["bdwork"] + " </td>";
bdplane += "<td>" + dr["bdplane"] + " </td>";
bdship += "<td>" + dr["bdship"] + " </td>";
bland += "<td>" + dr["bland"] + " </td>";
blive += "<td>" + dr["blive"] + " </td>";
bvisa += "<td>" + dr["bvisa"] + " </td>";
binsurance += "<td>" + dr["binsurance"] + " </td>";
badmin += "<td>" + dr["badmin"] + " </td>";
bgift += "<td>" + dr["bgift"] + " </td>";
bdother += "<td>" + dr["bdother"] + " </td>";
bdbillno += "<td>" + dr["bdbillno"] + " </td>";
bdcomment += "<td>" + dr["bdcomment"] + " </td>";
dsum = Convert.ToDouble(dr["bdplane"]) + Convert.ToDouble(dr["bdship"]) + Convert.ToDouble(dr["bland"]) + Convert.ToDouble(dr["blive"]) + Convert.ToDouble(exrate);
dsum += Convert.ToDouble(dr["bvisa"]) + Convert.ToDouble(dr["binsurance"]) + Convert.ToDouble(dr["badmin"]) + Convert.ToDouble(dr["bgift"]) + Convert.ToDouble(dr["bdother"]);
strsum += "<td>" + dsum.ToString() + " </td>";
ttlmoney += dsum;
}
}
dr.Close();
}
}
int emptyrow = 5 - rowcounter;
if (blogaddr == "1")
{
Excel += "<table border=1 style='border-collapse:collapse;border:none;mso-border-alt:solid' borderColorDark=#000000 borderColorLight=#000000 cellpadding=6 cellspacing=0 width=100% align=center style='font-size:12pt;font-family:標楷體'><tr align=center>";
Excel += "<tr align=center>";
Excel += "<td colspan=" + (rowcounter + 2) + ">中華民國 " + (blogsdate.Year - 1911) + " 年 " + blogsdate.Month.ToString() + " 月 " + blogsdate.Day.ToString() + " 日起中華民國 " + (blogedate.Year - 1911) + " 年 " + blogedate.Month.ToString() + " 月 " + blogedate.Day.ToString() + " 日止共計 " + diffday + " 日附單據 " + bbillcount + " 張</td>";
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 align=center>月</td>";
Excel += bdmonth + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 align=center>日</td>";
Excel += bdday + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 align=center>起訖地點</td>";
Excel += bdplace + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 align=center>工作記要</td>";
Excel += bdwork + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td rowspan=4 width=10%>交通費</td>";
Excel += "<td width=15%>飛機及高鐵</td>";
Excel += bdplane + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>汽車及捷運</td>";
Excel += bdcar + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>火車</td>";
Excel += bdtrain + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>輪船</td>";
Excel += bdship + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 >住宿費</td>";
Excel += bdliving1 + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 >住宿費加計交通費<br>(旅行業代收轉付)</td>";
Excel += bdliving2 + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 >膳雜費</td>";
Excel += bdother + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 >單據號數</td>";
Excel += bdbillno + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 >小計</td>";
Excel += strsum + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 >總計</td>";
Excel += "<td colspan=5 >" + ttlmoney + "</td>";
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 >備註</td>";
Excel += bdcomment + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "</table>";
Excel += "<p>";
Excel += "<table width=100% style='font-size:12pt;font-family:標楷體'>";
Excel += "<tr>";
Excel += "<td valign=top>出差人</td>";
Excel += "<td>單位<br>主管</td>";
Excel += "<td>主辦人<br>事人員</td>";
Excel += "<td>主辦會<br>計人員</td>";
Excel += "<td>機關首長或<br>授權代簽人</td>";
Excel += "</tr>";
Excel += "</table>";
}
else
{
Excel += "<table border=1 style='border-collapse:collapse;border:none;mso-border-alt:solid' borderColorDark=#000000 borderColorLight=#000000 cellpadding=6 cellspacing=0 width=100% align=center style='font-size:12pt;font-family:標楷體'><tr align=center>";
Excel += "<tr align=center>";
Excel += "<td colspan=" + (rowcounter + 2) + ">中華民國 " + (blogsdate.Year - 1911) + " 年 " + blogsdate.Month.ToString() + " 月 " + blogsdate.Day.ToString() + " 日起中華民國 " + (blogedate.Year - 1911) + " 年 " + blogedate.Month.ToString() + " 月 " + blogedate.Day.ToString() + " 日止共計 " + diffday + " 日附單據 " + bbillcount + " 張</td>";
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 align=center>月</td>";
Excel += bdmonth + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 align=center>日</td>";
Excel += bdday + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 align=center>起訖地點</td>";
Excel += bdplace + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 align=center>工作記要</td>";
Excel += bdwork + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td rowspan=3 width=10%>交通費</td>";
Excel += "<td width=15%>飛機</td>";
Excel += bdplane + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>船舶</td>";
Excel += bdship + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>長途大眾<Br>陸運工具</td>";
Excel += bland + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2>生活費(US$)</td>";
Excel += blive + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td rowspan=5 width=10%>辦公費</td>";
Excel += "<td width=15%>手續費</td>";
Excel += bvisa + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>保險費</td>";
Excel += binsurance + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>行政費</td>";
Excel += badmin + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>禮品及<br>交際費</td>";
Excel += bgift + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>雜費</td>";
Excel += bdother + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2>單據號數</td>";
Excel += bdbillno + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2>小計</td>";
Excel += strsum + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 >總計</td>";
Excel += "<td colspan=5 >" + ttlmoney + "</td>";
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td colspan=2 >備註</td>";
Excel += bdcomment + add_emptytd(emptyrow);
Excel += "</tr>";
Excel += "</table>";
Excel += "<p>";
Excel += "<table width=100% style='font-size:12pt;font-family:標楷體'>";
Excel += "<tr>";
Excel += "<td valign=top>出差人</td>";
Excel += "<td>單位<br>主管</td>";
Excel += "<td>主辦人<br>事人員</td>";
Excel += "<td>主辦會<br>計人員</td>";
Excel += "<td>機關首長或<br>授權代簽人</td>";
Excel += "</tr>";
Excel += "</table>";
Excel += "<br>";
Excel += "<table width=80% style='font-size:12pt;font-family:標楷體' border=0 align=center>";
Excel += "<tr>";
Excel += "<td valign=top width=50%>茲 收 到</td>";
Excel += "<td width=50%></td>";
Excel += "</tr>";
Excel += "<tr>";
Excel += "<td>出差旅費新台幣 " + ttlmoney + "元整</td>";
Excel += "<td>具領人 (簽章)</td>";
Excel += "</tr>";
Excel += "</table>";
}
#endregion
Excel += "</table>";
Excel += "</body>";
Excel += "</HTML>";
ViewBag.Excel = Excel;
return(View());
}
public ActionResult Editdo(string sysflag, int?page, string orderdata, string orderdata1)
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qpdno = "", qallcomid = "", qvcno = "", qvcsdate = "", qvcedate = "";
if (!string.IsNullOrWhiteSpace(Request["qallcomid"]))
{
qallcomid = Request["qallcomid"].Trim();
ViewBag.qvendno = qallcomid;
}
if (!string.IsNullOrWhiteSpace(Request["qvcno"]))
{
qvcno = Request["qvcno"].Trim();
ViewBag.qvcno = qvcno;
}
if (!string.IsNullOrWhiteSpace(Request["qvcsdate"]))
{
qvcsdate = Request["qvcsdate"].Trim();
ViewBag.qvcsdate = qvcsdate;
}
if (!string.IsNullOrWhiteSpace(Request["qvcedate"]))
{
qvcedate = Request["qvcedate"].Trim();
ViewBag.qvcedate = qvcedate;
}
if (!string.IsNullOrWhiteSpace(Request["qpdno"]))
{
qpdno = Request["qpdno"].Trim();
ViewBag.qpdno = qpdno;
}
int vcid = int.Parse(Request["vcid"].ToString());
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
vend_contract modobj = con.vend_contract.Where(r => r.vcid == vcid).FirstOrDefault();
modobj.vcdate = DateTime.Parse(Request["vcdate"].ToString());
modobj.vcsdate = DateTime.Parse(Request["vcsdate"].ToString());
modobj.vcedate = DateTime.Parse(Request["vcedate"].ToString());
modobj.comid = Request["comid"];
modobj.projno = Request["projno"];
modobj.taxtype = Request["taxtype"];
modobj.vcmoney = int.Parse(Request["vcmoney"]);
modobj.vctaxmoney = int.Parse(Request["vctaxmoney"]);
modobj.vcallmoney = int.Parse(Request["vcallmoney"]);
modobj.vccomment = Request["vccomment"];
modobj.allcomid = Request["allcomid"];
modobj.bmodid = Session["empid"].ToString();
modobj.bmoddate = DateTime.Now;
con.Entry(modobj).State = EntityState.Modified;
con.SaveChanges();
con.Dispose();
}
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/custcontract/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='qpdno' name='qpdno' value='" + qpdno + "'>";
tmpform += "<input type=hidden id='qallcomid' name='qallcomid' value='" + qallcomid + "'>";
tmpform += "<input type=hidden id='qvcno' name='qvcno' value='" + qvcno + "'>";
//tmpform += "<input type=hidden id='qpcomment' name='qpcomment' value='" + qpcomment + "'>";
tmpform += "<input type=hidden id='qvcsdate' name='qvcsdate' value='" + qvcsdate + "'>";
tmpform += "<input type=hidden id='qvcedate' name='qvcedate' value='" + qvcedate + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
}
public ActionResult menugo(string id)
{
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
SqlConnection comconn = dbobj.get_conn("Aitag_DBContext");
string prog = dbobj.get_dbvalue(comconn, "select location from menutab where mtid = '" + id + "'");
Session["mtid"] = id;
string sql = "SELECT sublevel1.* FROM privtb LEFT OUTER JOIN sublevel1 ON privtb.sid = sublevel1.sid where sublevel1.mtid = '" + id + "' and privtb.bid='" + Session["empid"] + "' and privtb.chk='1' order by sublevel1.lid , sublevel1.corder , sublevel1.sid";
SqlCommand cmd = new SqlCommand();
cmd.Connection = comconn;
cmd.CommandText = sql;
SqlDataReader tmprs = cmd.ExecuteReader();
if (tmprs.Read())
{
string location = tmprs["location"].ToString().Trim();
string p1 = tmprs["uplink"].ToString().Trim();
string p2 = tmprs["sid"].ToString().Trim();
if (location.IndexOf('#') >= 0)
{
sql = "SELECT sublevel1.location,sublevel1.sid FROM privtb LEFT OUTER JOIN sublevel1 ON privtb.sid = sublevel1.sid where sublevel1.uplink = '" + tmprs["sid"].ToString() + "' and sublevel1.lid='3' and privtb.bid='" + Session["empid"].ToString() + "' and privtb.chk='1' order by sublevel1.corder , sublevel1.sid";
tmprs.Close();
tmprs.Dispose();
cmd.CommandText = sql;
tmprs = cmd.ExecuteReader();
if (tmprs.Read())
{
location = tmprs["location"].ToString().Trim();
p1 = p2;
p2 = tmprs["sid"].ToString().Trim();
}
tmprs.Close();
tmprs.Dispose();
}
else
{
tmprs.Close();
tmprs.Dispose();
}
if (location.IndexOf('?') >= 0)
{
ViewBag.js = @"location.href='" + location + "';";
return(View());
}
else
{
ViewBag.js = @"location.href='" + location + "?sid=" + p1 + "&realsid=" + p2 + "';";
return(View());
}
}
else
{
return(new ContentResult()
{
Content = @"<script>alert('您並無此選單的使用權限!!');window.history.go(-1);</script>"
});
}
comconn.Close();
comconn.Dispose();
}
//[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");
}
}
}
//[HttpGet]
//public ActionResult Add()
//{
// ViewBag.Ifboss = Session["Ifboss"].ToString();
// ViewBag.comid = Session["comid"].ToString();
// Company col = new Company();
// return View(col);
//}
//[HttpPost]
public ActionResult add(Company col, string sysflag, int?page, string orderdata, string orderdata1, HttpPostedFileBase logopic1)
{
ModelState.Clear();
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
if (string.IsNullOrWhiteSpace(orderdata))
{
orderdata = "comid";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = "desc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qcomid = "", qcsno = "", qcomtitle = "";
if (!string.IsNullOrWhiteSpace(Request["qcomid"]))
{
qcomid = Request["qcomid"].Trim();
ViewBag.qcomid = qcomid;
}
if (!string.IsNullOrWhiteSpace(Request["qcsno"]))
{
qcsno = Request["qcsno"].Trim();
ViewBag.qcsno = qcsno;
}
if (!string.IsNullOrWhiteSpace(Request["qcomtitle"]))
{
qcomtitle = Request["qcomtitle"].Trim();
ViewBag.qcomtitle = qcomtitle;
}
if (sysflag != "A")
{
Company newcol = new Company();
return(View(newcol));
}
else
{
if (!ModelState.IsValid)
{
return(View(col));
}
else
{
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
SqlDataReader dr;
SqlCommand sqlsmd = new SqlCommand();
sqlsmd.Connection = conn;
string sqlstr = "select comid from Company where comid = '" + col.comid + "'";
sqlsmd.CommandText = sqlstr;
dr = sqlsmd.ExecuteReader();
if (dr.Read())
{
ModelState.AddModelError("", "權限代碼重複!");
return(View(col));
}
dr.Close();
dr.Dispose();
sqlsmd.Dispose();
conn.Close();
conn.Dispose();
if (logopic1.ContentLength > 0)
{
col.logopic = Request["comid"] + "." + logopic1.FileName.Substring(logopic1.FileName.Length - 3, 3);
logopic1.SaveAs(Server.MapPath("/upload/" + col.logopic));
}
//密碼加密
//col.emppasswd = dbobj.Encrypt(col.emppasswd);
//col.comid = col.emppasswd;
//col.baddid = Session["tempid"].ToString();
col.bmodid = Session["tempid"].ToString();
//col.badddate = DateTime.Now;
col.bmoddate = DateTime.Now;
using (Aitag_DBContext con = new Aitag_DBContext())
{
con.Company.Add(col);
try
{
con.SaveChanges();
}
catch (Exception ex)
{
throw;
}
//系統LOG檔 //================================================= //
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
string sysrealsid = Request["sysrealsid"].ToString();
string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
string sysnote = "代碼:" + col.comid + "名稱:" + col.comtitle;
dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
sysconn.Close();
sysconn.Dispose();
//=================================================
}
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/Company/List' method='post'>";
tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
tmpform += "<input type=hidden id='qcomid' name='qcomid' value='" + qcomid + "'>";
tmpform += "<input type=hidden id='qcsno' name='qcsno' value='" + qcsno + "'>";
tmpform += "<input type=hidden id='qcomtitle' name='qcomtitle' value='" + qcomtitle + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
// return RedirectToAction("List");
}
}
}