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");
                    }
                }
            }
        }
示例#4
0
        //[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");
                }
            }
        }
示例#5
0
        //[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
                    });
                }
            }
        }
示例#7
0
        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
            });
        }
示例#8
0
        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));
        }
示例#9
0
        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");
                }
            }
        }
示例#11
0
        public ActionResult Transfer(holidayschedule col, string sysflag, HttpPostedFileBase upfile)
        {
            if (sysflag != "A")
            {
                holidayschedule newcol = new holidayschedule();
                return(View(newcol));
            }
            else
            {
                Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
                string tmpform = "";
                if (upfile != null)
                {
                    String sernonum = "";
                    //重新命名,存入檔案
                    DateTime myDate = DateTime.Now;
                    sernonum = myDate.ToString("yyyyMMddHHmmss");
                    string BasicPath  = Server.MapPath("~/upload/");
                    int    inputcount = 0;
                    string fileName   = upfile.FileName.Substring(upfile.FileName.IndexOf("."), upfile.FileName.Length - upfile.FileName.IndexOf("."));

                    if (fileName != ".exe" && fileName != ".asp" && fileName != ".aspx" && fileName != ".jsp" && fileName != ".php")
                    {
                        fileName = "udf-" + sernonum.ToString() + fileName;
                        upfile.SaveAs(Server.MapPath("~/upload/") + fileName);

                        string tmppath = BasicPath + fileName;

                        //StreamReader sr = new StreamReader(@tmppath); //讀取檔案
                        StreamReader sr     = new StreamReader(@tmppath, System.Text.Encoding.Default);
                        string       allstr = sr.ReadToEnd(); //從資料流末端存取檔案
                        sr.Close();

                        string[] tmpstridno;       //匯入資料
                        string[] toptmparry;       //匯入的第一筆資料(欄位)
                        int      tmparrycount = 0; //匯入欄位數
                        tmpstridno = allstr.Split(System.Environment.NewLine.ToCharArray());

                        //找第一筆的欄位數
                        toptmparry = tmpstridno[0].Split(',');

                        //先暫時停掉20160827
                        for (int tmpi = 0; tmpi <= toptmparry.Length - 1; tmpi++)
                        {
                            if (toptmparry[tmpi] != "")
                            {
                                tmparrycount++;
                            }
                        }

                        SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
                        string[]      tmparry;
                        string        tmpvalue  = "";
                        string        tmpaddsql = "";
                        string        cmid      = "";

                        for (int i = 1; i <= tmpstridno.Length - 1; i++)
                        {
                            if (tmpstridno[i] != "")
                            {
                                inputcount++;
                                tmparry = tmpstridno[i].Split(',');
                                //判斷必填欄位
                                if (tmparry[0] != "" && tmparry[1] != "" && tmparry[2] != "")
                                {
                                    string wstype = "";
                                    if (tmparry[2] == "假日")
                                    {
                                        wstype = "0";
                                    }
                                    if (tmparry[2] == "上班")
                                    {
                                        wstype = "1";
                                    }
                                    if (tmparry[2] == "年假")
                                    {
                                        wstype = "2";
                                    }
                                    col.wstitle  = tmparry[0];
                                    col.wsdate   = Convert.ToDateTime(tmparry[1]);
                                    col.wstype   = wstype;
                                    col.comid    = Session["comid"].ToString();
                                    col.bmodid   = Session["tempid"].ToString();
                                    col.bmoddate = DateTime.Now;
                                    using (Aitag_DBContext con = new Aitag_DBContext())
                                    {
                                        con.holidayschedule.Add(col);
                                        con.SaveChanges();

                                        //系統LOG檔 //================================================= //
                                        //SqlConnection sysconn = dbobj.get_conn("MatsuEip_DBContext");
                                        //string sysrealsid = Request["sysrealsid"].ToString();
                                        //string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                                        //string sysnote = "行事曆標題:" + col.wstitle + "<br>日期:" + col.wsdate + "的資料";
                                        //dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                                        //sysconn.Close();
                                        //sysconn.Dispose();
                                        //=================================================
                                    }


                                    //tmpform = "<body onload=javascript:alert('轉檔成功!');parent.opener.location.href='/holidayschedule/List?sid=" + Request["sid"].ToString() + "&realsid=" + Request["realsid"].ToString() + "';window.close();>";
                                }
                            }
                        }
                    }
                    else
                    {
                        ViewBag.AddModelError = @"alert('上傳格式錯誤!');";
                        return(View());
                    }
                }
                ViewBag.AddModel = @"alert('轉檔成功!');" +
                                   @"parent.opener.location.href = '/holidayschedule/list?sid=" + Request["sid"].ToString() + "&realsid=" + Request["realsid"].ToString() + "';" +
                                   @"window.close();";


                return(View());
            }
        }
示例#12
0
        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());
            }
        }
示例#13
0
        //[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");
                }
            }
        }
示例#14
0
        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 }));
            }
        }
示例#18
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");
                }
            }
        }
示例#19
0
        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());
        }
示例#20
0
        //[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");
                }
            }
        }
示例#21
0
        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());
        }
示例#23
0
        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 + "&nbsp;</td>";
                Excel += "</tr>";
                Excel += "<tr>";
                Excel += "<td>出差事由</td>";
                Excel += "<td colspan=5 width=500>" + blogcomment + "&nbsp;</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"] + "&nbsp;</td>";
                            bdday     += "<td>" + dr["bdday"] + "&nbsp;</td>";
                            bdplace   += "<td>" + dr["bdplace"] + "&nbsp;</td>";
                            bdwork    += "<td>" + dr["bdwork"] + "&nbsp;</td>";
                            bdplane   += "<td>" + dr["bdplane"] + "&nbsp;</td>";
                            bdcar     += "<td>" + dr["bdcar"] + "&nbsp;</td>";
                            bdtrain   += "<td>" + dr["bdtrain"] + "&nbsp;</td>";
                            bdship    += "<td>" + dr["bdship"] + "&nbsp;</td>";
                            bdliving1 += "<td>" + dr["bdliving1"] + "&nbsp;</td>";
                            bdliving2 += "<td>" + dr["bdliving2"] + "&nbsp;</td>";
                            bdother   += "<td>" + dr["bdother"] + "&nbsp;</td>";
                            bdbillno  += "<td>" + dr["bdbillno"] + "&nbsp;</td>";
                            bdcomment += "<td>" + dr["bdcomment"] + "&nbsp;</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() + "&nbsp;</td>";
                            ttlmoney += dsum;
                        }
                        else
                        {//國外
                            bdmonth    += "<td>" + dr["bdmonth"] + "&nbsp;</td>";
                            bdday      += "<td>" + dr["bdday"] + "&nbsp;</td>";
                            bdplace    += "<td>" + dr["bdplace"] + "&nbsp;</td>";
                            bdwork     += "<td>" + dr["bdwork"] + "&nbsp;</td>";
                            bdplane    += "<td>" + dr["bdplane"] + "&nbsp;</td>";
                            bdship     += "<td>" + dr["bdship"] + "&nbsp;</td>";
                            bland      += "<td>" + dr["bland"] + "&nbsp;</td>";
                            blive      += "<td>" + dr["blive"] + "&nbsp;</td>";
                            bvisa      += "<td>" + dr["bvisa"] + "&nbsp;</td>";
                            binsurance += "<td>" + dr["binsurance"] + "&nbsp;</td>";
                            badmin     += "<td>" + dr["badmin"] + "&nbsp;</td>";
                            bgift      += "<td>" + dr["bgift"] + "&nbsp;</td>";
                            bdother    += "<td>" + dr["bdother"] + "&nbsp;</td>";
                            bdbillno   += "<td>" + dr["bdbillno"] + "&nbsp;</td>";
                            bdcomment  += "<td>" + dr["bdcomment"] + "&nbsp;</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() + "&nbsp;</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) + ">中華民國&nbsp;&nbsp;" + (blogsdate.Year - 1911) + "&nbsp;&nbsp;年&nbsp;&nbsp;" + blogsdate.Month.ToString() + "&nbsp;&nbsp;月&nbsp;&nbsp;" + blogsdate.Day.ToString() + "&nbsp;&nbsp;日起中華民國&nbsp;&nbsp;" + (blogedate.Year - 1911) + "&nbsp;&nbsp;年&nbsp;&nbsp;" + blogedate.Month.ToString() + "&nbsp;&nbsp;月&nbsp;&nbsp;" + blogedate.Day.ToString() + "&nbsp;&nbsp;日止共計&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + diffday + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;日附單據&nbsp;&nbsp;" + bbillcount + "&nbsp;&nbsp;張</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) + ">中華民國&nbsp;&nbsp;" + (blogsdate.Year - 1911) + "&nbsp;&nbsp;年&nbsp;&nbsp;" + blogsdate.Month.ToString() + "&nbsp;&nbsp;月&nbsp;&nbsp;" + blogsdate.Day.ToString() + "&nbsp;&nbsp;日起中華民國&nbsp;&nbsp;" + (blogedate.Year - 1911) + "&nbsp;&nbsp;年&nbsp;&nbsp;" + blogedate.Month.ToString() + "&nbsp;&nbsp;月&nbsp;&nbsp;" + blogedate.Day.ToString() + "&nbsp;&nbsp;日止共計&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + diffday + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;日附單據&nbsp;&nbsp;" + bbillcount + "&nbsp;&nbsp;張</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>出差旅費新台幣&nbsp;" + ttlmoney + "元整</td>";
                Excel += "<td>具領人          (簽章)</td>";
                Excel += "</tr>";
                Excel += "</table>";
            }


            #endregion
            Excel += "</table>";
            Excel += "</body>";
            Excel += "</HTML>";

            ViewBag.Excel = Excel;
            return(View());
        }
示例#27
0
        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
            });
        }
示例#28
0
        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");
                }
            }
        }
示例#30
0
        //[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");
                }
            }
        }