コード例 #1
0
        public ActionResult Edit(Webmaincontent chks, HttpPostedFileBase Mcfile1, HttpPostedFileBase Mpic1)
        {
            ViewBag.Cid  = chks.AC_Cid;
            ViewBag.Ccid = chks.AC_Ccid;

            if (ModelState.IsValid)
            {
                Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    chks.AC_Bmodid        = Session["tempid"].ToString();
                    chks.AC_Bmoddate      = DateTime.Now;
                    con.Entry(chks).State = EntityState.Modified;
                    //檔案ㄋ
                    int sernonum;
                    if (Mcfile1 != 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() + Mcfile1.FileName.Substring(Mcfile1.FileName.IndexOf("."), Mcfile1.FileName.Length - Mcfile1.FileName.IndexOf("."));
                            Mcfile1.SaveAs(Server.MapPath("~/Upload/") + fileName);
                            chks.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();
                    }
                    else
                    {
                        chks.AC_Mcfile = chks.AC_Mcfile;
                    }
                    //圖片
                    if (Mpic1 != null)
                    {
                        // Uploadfile.SaveAs(Server.MapPath("~/Uploads/") + Apic.FileName);
                        //上傳檔案
                        //找序號
                        //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 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() + Mpic1.FileName.Substring(Mpic1.FileName.IndexOf("."), Mpic1.FileName.Length - Mpic1.FileName.IndexOf("."));
                            Mpic1.SaveAs(Server.MapPath("~/Upload/") + fileName);
                            chks.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();
                    }
                    else
                    {
                        chks.AC_Mcfile = chks.AC_Mcfile;
                    }
                    con.SaveChanges();


                    //系統LOG檔 //================================================= //
                    //Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
                    string        syssubname = "網站管理作業 > 網站內容管理";
                    string        sysnote    = "名稱:" + chks.AC_Mctitle;
                    string        sysflag    = "M";
                    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 (chks.AC_Ccid != 0)
                    {
                        return(RedirectToAction("List", new { cid = chks.AC_Ccid, cid1 = chks.AC_Cid }));
                    }
                    else
                    {
                        return(RedirectToAction("List", new { cid = chks.AC_Cid, cid1 = 0 }));
                    }
                }
            }
            return(View(chks));
        }
コード例 #2
0
        public ActionResult detedit(yearhddet chks, string sysflag, int?page, string orderdata, string orderdata1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "hid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qyhid = "", qyhtitle = "", yhid = "";

            if (!string.IsNullOrWhiteSpace(Request["qyhid"]))
            {
                qyhid         = Request["qyhid"].Trim();
                ViewBag.qyhid = qyhid;
            }
            if (!string.IsNullOrWhiteSpace(Request["qyhtitle"]))
            {
                qyhtitle         = Request["qyhtitle"].Trim();
                ViewBag.qyhtitle = qyhtitle;
            }
            if (!string.IsNullOrWhiteSpace(Request["yhid"]))
            {
                yhid         = Request["yhid"].Trim();
                ViewBag.yhid = yhid;
            }

            if (sysflag != "Q")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var       data          = con.yearhddet.Where(r => r.hid == chks.hid).FirstOrDefault();
                    yearhddet eyearholidays = con.yearhddet.Find(chks.hid);
                    if (eyearholidays == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(eyearholidays));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldmsid = Request["oldmsid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();
                        chks.comid            = Session["comid"].ToString();
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "年假代碼:" + chks.yhid + "假別代碼:" + chks.hdayid + "發放時數:" + chks.allhour;
                        dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                        sysconn.Close();
                        sysconn.Dispose();
                        //=================================================

                        string tmpform = "";
                        tmpform  = "<body onload=qfr1.submit();>";
                        tmpform += "<form name='qfr1' action='/yearholiday/Edit' method='post'>";
                        tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
                        tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                        tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                        tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
                        tmpform += "<input type=hidden id='qyhid' name='qyhid' value='" + qyhid + "'>";
                        tmpform += "<input type=hidden id='qyhtitle' name='qyhtitle' value='" + qyhtitle + "'>";
                        tmpform += "<input type=hidden id='yhid' name='yhid' value='" + yhid + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #3
0
        public ActionResult logcheckEdit(delholidaylog chks, string sysflag, int?page, string orderdata, string orderdata1, HttpPostedFileBase logopic1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "hdellogid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;

            string qhlogsdate = "", qhlogedate = "";

            if (!string.IsNullOrWhiteSpace(Request["qhlogsdate"]))
            {
                qhlogsdate         = Request["qhlogsdate"].Trim();
                ViewBag.qhlogsdate = qhlogsdate;
            }
            if (!string.IsNullOrWhiteSpace(Request["qhlogedate"]))
            {
                qhlogedate         = Request["qhlogedate"].Trim();
                ViewBag.qhlogedate = qhlogedate;
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    //var data = con.delholidaylog.Where(r => r.hdellogid == chks.hdellogid).FirstOrDefault();
                    delholidaylog edelholidaylogs = con.delholidaylog.Find(chks.hdellogid);
                    if (edelholidaylogs == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(edelholidaylogs));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    NDcommon      dbobj   = new NDcommon();
                    delholidaylog col     = new delholidaylog();
                    string        sysnote = "";
                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        col = con.delholidaylog.Find(chks.hdellogid);
                    }

                    string hdellogstatus = "";
                    if (dbobj.get_dbnull2(Request["hdellogstatus"]) == "1")
                    {
                        string tmprolestampid = col.rolestampid;
                        string rolea_1        = col.rolestampidall;
                        string roleall        = rolea_1 + "," + tmprolestampid; //'簽核過角色(多個)
                        string billflowid     = col.billflowid.ToString();

                        //找出下一個角色是誰
                        string tmprole = dbobj.getnewcheck1("H", tmprolestampid, roleall, "0", "", billflowid);

                        if (tmprole == "'topman'")
                        {
                            tmprole = "";
                        }
                        if (tmprole == "")
                        {
                            hdellogstatus = "1";// '己簽核
                        }
                        else
                        {
                            hdellogstatus = "0";
                            //'找往上呈核長管級數
                            //'==========================
                            string tmpflowlevel = "";
                            using (SqlConnection conn = dbobj.get_conn("Aitag_DBContext"))
                            {
                                tmpflowlevel = dbobj.get_dbvalue(conn, "select billflow from flowlevel where bid=" + billflowid);
                            }
                            if (tmpflowlevel == "")
                            {
                                tmpflowlevel = "0";
                            }
                            string[] tmpa      = rolea_1.Split(',');
                            int      tmpacount = tmpa.Length;
                            if (int.Parse(tmpflowlevel) == (tmpacount + 1))
                            {
                                tmprole       = "";
                                hdellogstatus = "1"; // '己簽核
                            }
                            //'==========================
                        }

                        col.hdellogstatus  = hdellogstatus;
                        col.rolestampid    = tmprole;
                        col.rolestampidall = roleall;
                        col.empstampidall  = col.empstampidall + ",'" + (string)Session["empid"] + "'"; //'所有人員帳號
                        col.bmodid         = (string)Session["empid"];
                        col.bmoddate       = DateTime.Now;
                        col.billtime       = col.billtime + "," + DateTime.Now.ToString();

                        if (tmprole != "")
                        {
                            //寄信
                            logcheckEditMail(col, tmprole);
                        }
                        else
                        {
                            //(己通過)  寄信
                            logcheckEditMailPass(col);
                        }
                    }
                    else
                    {
                        col.hdellogstatus = "2";
                        col.delback       = chks.delback;
                        col.bmodid        = (string)Session["empid"];
                        col.bmoddate      = DateTime.Now;
                        //  col.billtime = col.billtime + "," + DateTime.Now.ToString();

                        //(己通過)  寄信
                        logcheckEditMailBack(col);
                    }

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        con.Entry(col).State = EntityState.Modified;
                        con.SaveChanges();
                    }


                    if (hdellogstatus == "1")
                    {
                        //銷假時數補回
                        delholidayMode(col, hdellogstatus);
                    }



                    //系統LOG檔

                    if (sysnote.Length > 4000)
                    {
                        sysnote = sysnote.Substring(0, 4000);
                    }
                    ////================================================= //

                    SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                    string        sysrealsid = Request["sysrealsid"].ToString();
                    string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                    dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                    sysconn.Close();
                    sysconn.Dispose();
                    //=================================================

                    string tmpform = "";
                    tmpform  = "<body onload=qfr1.submit();>";
                    tmpform += "<form name='qfr1' action='/delholiday/logcheckList' method='post'>";
                    tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
                    tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                    tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                    tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";

                    tmpform += "<input type=hidden id='qhlogsdate' name='qhlogsdate' value='" + qhlogsdate + "'>";
                    tmpform += "<input type=hidden id='qhlogedate' name='qhlogedate' value='" + qhlogedate + "'>";

                    tmpform += "</form>";
                    tmpform += "</body>";

                    return(new ContentResult()
                    {
                        Content = @"" + tmpform
                    });
                }
            }
        }
コード例 #4
0
        private void delholidayMode(delholidaylog col, string hdellogstatus)
        {
            NDcommon dbobj = new NDcommon();

            using (SqlConnection comconn = dbobj.get_conn("Aitag_DBContext"))
            {
                if (col.hdayid == "A04")
                {
                    #region  '請補假部分
                    resthourlog chks = new resthourlog();
                    chks.empid      = col.empid;
                    chks.rsdeaddate = col.hlogsdate;

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        var   eresthourlogs = con.resthourlog.Where(r => r.empid == chks.empid && r.rsdeaddate >= chks.rsdeaddate).OrderBy(r => r.rsdeaddate);
                        float tmphloghour   = float.Parse(col.hloghour.ToString());
                        foreach (resthourlog es in eresthourlogs)
                        {
                            var lefthour = es.usehour - tmphloghour;
                            if (lefthour >= 0)
                            {
                                es.usehour -= tmphloghour;
                                using (Aitag_DBContext con2 = new Aitag_DBContext())
                                {
                                    con2.Entry(es).State = EntityState.Modified;
                                    con2.SaveChanges();
                                }
                                if (lefthour == 0)
                                {
                                    break;
                                }
                            }
                            else
                            {
                                es.usehour = 0;
                                using (Aitag_DBContext con2 = new Aitag_DBContext())
                                {
                                    con2.Entry(es).State = EntityState.Modified;
                                    con2.SaveChanges();
                                }
                                tmphloghour = float.Parse(Math.Abs(decimal.Parse(lefthour.ToString())).ToString());
                            }
                        }
                    }
                    #endregion
                }
                else
                {
                    #region  事實發生假部分
                    string   mergehdayid = dbobj.get_dbvalue(comconn, "select * from holidaycode where hdayid = '" + col.hdayid + "'");;
                    string   sql         = "";
                    emphdlog chks        = new emphdlog();


                    if (mergehdayid != "")
                    {
                        chks.empid  = col.empid;
                        chks.hdayid = mergehdayid;
                    }
                    else
                    {
                        chks.empid  = col.empid;
                        chks.hdayid = col.hdayid;
                    }
                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        emphdlog eemphdlogs = con.emphdlog.Where(r => r.empid == chks.empid && r.hdayid == chks.hdayid).FirstOrDefault();

                        if (eemphdlogs != null)
                        {
                            eemphdlogs.usehour          = eemphdlogs.usehour - decimal.Parse(col.hloghour.ToString());
                            con.Entry(eemphdlogs).State = EntityState.Modified;
                            con.SaveChanges();

                            if (eemphdlogs.usehour == 0)
                            {
                                if (mergehdayid != "")
                                {
                                    sql = "delete emphdlog where empid = '" + col.empid + "' and hdayid = '" + mergehdayid + "'";
                                }
                                else
                                {
                                    sql = "delete emphdlog where empid = '" + col.empid + "' and hdayid = '" + col.hdayid + "'";
                                }
                                dbobj.dbexecute("Aitag_DBContext", sql);
                            }
                        }
                    }
                    #endregion
                }
            }
        }
コード例 #5
0
        public ActionResult maincontentmod(maincontent 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 = "mcid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qkeyword = "", qsmdate = "", qemdate = "", qmclassid = "";
            int    mcid = 0;

            if (!string.IsNullOrWhiteSpace(Request["mcid"]))
            {
                mcid = int.Parse(Request["mcid"].Trim());
                // ViewBag.qkeyword = qkeyword;
            }
            if (!string.IsNullOrWhiteSpace(Request["qkeyword"]))
            {
                qkeyword         = Request["qkeyword"].Trim();
                ViewBag.qkeyword = qkeyword;
            }
            if (!string.IsNullOrWhiteSpace(Request["qsmdate"]))
            {
                qsmdate         = Request["qsmdate"].Trim();
                ViewBag.qsmdate = qsmdate;
            }
            if (!string.IsNullOrWhiteSpace(Request["qemdate"]))
            {
                qemdate         = Request["qemdate"].Trim();
                ViewBag.qemdate = qemdate;
            }
            if (!string.IsNullOrWhiteSpace(Request["qmclassid"]))
            {
                qmclassid         = Request["qmclassid"].Trim();
                ViewBag.qmclassid = qmclassid;
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var         data        = con.maincontent.Where(r => r.mcid == mcid).FirstOrDefault();
                    maincontent eCheckcodes = con.maincontent.Find(mcid);
                    if (eCheckcodes == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(eCheckcodes));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldmsid = Request["oldmsid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "序號:" + chks.mcid + "標題名稱:" + chks.mctitle;
                        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='/oa/maincontent' 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='qkeyword' name='qkeyword' value='" + qkeyword + "'>";
                        tmpform += "<input type=hidden id='qsmdate' name='qsmdate' value='" + qsmdate + "'>";
                        tmpform += "<input type=hidden id='qemdate' name='qemdate' value='" + qemdate + "'>";
                        tmpform += "<input type=hidden id='qmclassid' name='qmclassid' value='" + qmclassid + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #6
0
        public ActionResult Edit(billflow chks, string sysflag, int?page, string orderdata, string orderdata1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "bid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qbillid = "", qcomclass = "";

            if (!string.IsNullOrWhiteSpace(Request["qbillid"]))
            {
                qbillid         = Request["qbillid"].Trim();
                ViewBag.qbillid = qbillid;
            }
            if (!string.IsNullOrWhiteSpace(Request["qcomclass"]))
            {
                qcomclass         = Request["qcomclass"].Trim();
                ViewBag.qcomclass = qcomclass;
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var      data       = con.billflow.Where(r => r.bid == chks.bid).FirstOrDefault();
                    billflow ebillflows = con.billflow.Find(chks.bid);
                    if (ebillflows == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(ebillflows));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldbillid = Request["oldbillid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();

                        chks.addr             = Request["addr"];
                        chks.billtype         = Request["billtype"];
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;

                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn       = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid    = Request["sysrealsid"].ToString();
                        string        syssubname    = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        tmpbillidname = dbobj.get_dbvalue(sysconn, "select doctitle from docgroup where docid ='" + Request["billid"].Trim() + "' and comid='" + Session["comid"] + "'");
                        string        flowcheck     = "";
                        if (!string.IsNullOrWhiteSpace(Request["flowcheck"].Trim()))
                        {
                            string     sqlstr1 = "select * from roleplay where rid in (" + Request["flowcheck"].Trim() + ")";
                            SqlCommand cmd     = new SqlCommand();
                            cmd.Connection  = sysconn;
                            cmd.CommandText = sqlstr1;
                            SqlDataReader dr1 = cmd.ExecuteReader();
                            while (dr1.Read())
                            {
                                flowcheck = flowcheck + dr1["roletitle"].ToString() + " → ";
                            }
                            if (flowcheck != "")
                            {
                                flowcheck = flowcheck.Substring(0, flowcheck.Length - 2);
                            }
                            dr1.Close();
                            dr1.Dispose();
                        }
                        string sysnote = "呈核單類別:" + tmpbillidname + "<br>呈核人員:" + flowcheck;
                        dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                        sysconn.Close();
                        sysconn.Dispose();
                        //=================================================

                        string tmpform = "";
                        tmpform  = "<body onload=qfr1.submit();>";
                        tmpform += "<form name='qfr1' action='/billflow/List' method='post'>";
                        tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
                        tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                        tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                        tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
                        tmpform += "<input type=hidden id='qbillid' name='qbillid' value='" + qbillid + "'>";
                        tmpform += "<input type=hidden id='qcomclass' name='qcomclass' value='" + qcomclass + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #7
0
        public ActionResult Edit(cardreallog chks, string sysflag, int?page, string orderdata, string orderdata1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "crid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qdptid = "", qempname = "", qclogsdate = "", qclogedate = "";

            if (!string.IsNullOrWhiteSpace(Request["qdptid"]))
            {
                qdptid         = Request["qdptid"].Trim();
                ViewBag.qdptid = qdptid;
            }
            if (!string.IsNullOrWhiteSpace(Request["qempname"]))
            {
                qempname         = Request["qempname"].Trim();
                ViewBag.qempname = qempname;
            }
            if (!string.IsNullOrWhiteSpace(Request["qclogsdate"]))
            {
                qclogsdate         = Request["qclogsdate"].Trim();
                ViewBag.qclogsdate = qclogsdate;
            }
            if (!string.IsNullOrWhiteSpace(Request["qclogedate"]))
            {
                qclogedate         = Request["qclogedate"].Trim();
                ViewBag.qclogedate = qclogedate;
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var         data          = con.cardreallog.Where(r => r.crid == chks.crid).FirstOrDefault();
                    cardreallog ecardreallogs = con.cardreallog.Find(chks.crid);
                    if (ecardreallogs == null)
                    {
                        return(HttpNotFound());
                    }


                    ViewBag.cloghour = ViewBagcloghour(ecardreallogs.clogtime.Substring(0, 2));
                    ViewBag.clogmin  = ViewBagclogmin(ecardreallogs.clogtime.Substring(2, 2));

                    return(View(ecardreallogs));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldcrid = Request["oldcrid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();

                        chks.clogtime         = Request["cloghour"].Trim() + Request["clogmin"].Trim() + "00";
                        chks.tmpcardno        = Request["cardno"].Trim();
                        chks.tmpdepid         = Request["dptidname"].Trim();
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "申請人:" + chks.empname + "<br>刷卡日期:" + chks.clogdate + " " + Request["cloghour"].Trim() + Request["clogmin"].Trim() + "的資料";
                        dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                        sysconn.Close();
                        sysconn.Dispose();
                        //=================================================

                        string tmpform = "";
                        tmpform  = "<body onload=qfr1.submit();>";
                        tmpform += "<form name='qfr1' action='/cardreallog/List' method='post'>";
                        tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
                        tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                        tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                        tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";

                        tmpform += "<input type=hidden id='qdptid' name='qdptid' value='" + qdptid + "'>";
                        tmpform += "<input type=hidden id='qempname' name='qempname' value='" + qempname + "'>";
                        tmpform += "<input type=hidden id='qclogsdate' name='qclogsdate' value='" + qclogsdate + "'>";
                        tmpform += "<input type=hidden id='qclogedate' name='qclogedate' value='" + qclogedate + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #8
0
        public ActionResult Edit(otworklog 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 = "otlogid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qotstatus = "", qempname = "", qdptid = "", otlogsdate = "", otlogedate = "";

            if (!string.IsNullOrWhiteSpace(Request["qotstatus"]))
            {
                qotstatus         = Request["qotstatus"].Trim();
                ViewBag.qotstatus = qotstatus;
            }
            if (!string.IsNullOrWhiteSpace(Request["qempname"]))
            {
                qempname         = Request["qempname"].Trim();
                ViewBag.qempname = qempname;
            }
            if (!string.IsNullOrWhiteSpace(Request["qdptid"]))
            {
                qdptid         = Request["qdptid"].Trim();
                ViewBag.qdptid = qdptid;
            }
            if (!string.IsNullOrWhiteSpace(Request["otlogsdate"]))
            {
                otlogsdate         = Request["otlogsdate"].Trim();
                ViewBag.otlogsdate = otlogsdate;
            }
            if (!string.IsNullOrWhiteSpace(Request["otlogedate"]))
            {
                otlogedate         = Request["otlogedate"].Trim();
                ViewBag.otlogedate = otlogedate;
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var       data        = con.otworklog.Where(r => r.otlogid == chks.otlogid).FirstOrDefault();
                    otworklog eotworklogs = con.otworklog.Find(chks.otlogid);
                    if (eotworklogs == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(eotworklogs));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldotlogid = Request["oldotlogid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();
                        chks.otlogid          = int.Parse(Request["otlogid"].Trim());
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        //con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "代碼:" + chks.otlogid + "名稱:" + chks.empname;
                        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='/otworklog/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='qotstatus' name='qotstatus' value='" + qotstatus + "'>";
                        tmpform += "<input type=hidden id='qempname' name='qempname' value='" + qempname + "'>";
                        tmpform += "<input type=hidden id='qdptid' name='qdptid' value='" + qdptid + "'>";
                        tmpform += "<input type=hidden id='otlogsdate' name='otlogsdate' value='" + otlogsdate + "'>";
                        tmpform += "<input type=hidden id='otlogedate' name='otlogedate' value='" + otlogedate + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #9
0
        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");
                    }
                }
            }
        }
コード例 #10
0
        public ActionResult Edit(empfunction chks, string sysflag, int?page, string orderdata, string orderdata1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "funorder";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qempdid = "", funid = "";

            if (!string.IsNullOrWhiteSpace(Request["qempdid"]))
            {
                qempdid         = Request["qempdid"].Trim();
                ViewBag.qempdid = qempdid;
            }
            if (!string.IsNullOrWhiteSpace(Request["funid"]))
            {
                funid         = Request["funid"].Trim();
                ViewBag.funid = funid;
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var         data          = con.empfunction.Where(r => r.empdid == chks.empdid).FirstOrDefault();
                    empfunction eempfunctions = con.empfunction.Find(chks.empdid);
                    if (eempfunctions == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(eempfunctions));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string empdid = Request["empdid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();
                        chks.empid            = "99999999";
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        dbdata     = dbobj.get_dbvalue(sysconn, "select chkitem from checkcode where chkclass='08' and chkcode='" + chks.funid + "'");
                        string        sysnote    = "共用首頁設定:" + dbdata + "的資料";
                        dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                        sysconn.Close();
                        sysconn.Dispose();
                        //=================================================

                        string tmpform = "";
                        tmpform  = "<body onload=qfr1.submit();>";
                        tmpform += "<form name='qfr1' action='/empfunction/List' method='post'>";
                        tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
                        tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                        tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                        tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
                        tmpform += "<input type=hidden id='qempdid' name='qempdid' value='" + qempdid + "'>";
                        tmpform += "<input type=hidden id='funid' name='funid' value='" + funid + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #11
0
        public ActionResult Edit(Checkcode chks, string sysflag, int?page, string orderdata, string orderdata1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "cid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qchkclass = "", qchkitem = "";

            if (!string.IsNullOrWhiteSpace(Request["qchkclass"]))
            {
                qchkclass         = Request["qchkclass"].Trim();
                ViewBag.qchkclass = qchkclass;
            }
            if (!string.IsNullOrWhiteSpace(Request["qchkitem"]))
            {
                qchkitem         = Request["qchkitem"].Trim();
                ViewBag.qchkitem = qchkitem;
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var       data        = con.Checkcode.Where(r => r.cid == chks.cid).FirstOrDefault();
                    Checkcode eCheckcodes = con.Checkcode.Find(chks.cid);
                    if (eCheckcodes == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(eCheckcodes));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldmsid = Request["oldmsid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "類別:" + chks.chkclasstitle + "代碼名稱:" + chks.chkitem;
                        dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                        sysconn.Close();
                        sysconn.Dispose();
                        //=================================================

                        string tmpform = "";
                        tmpform  = "<body onload=qfr1.submit();>";
                        tmpform += "<form name='qfr1' action='/Checkcode/List' method='post'>";
                        tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
                        tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                        tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                        tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
                        tmpform += "<input type=hidden id='qchkclass' name='qchkclass' value='" + qchkclass + "'>";
                        tmpform += "<input type=hidden id='qchkitem' name='qchkitem' value='" + qchkitem + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";

                        string tgourl = "/Checkcode/List?page=" + page + "&qchkclass=" + qchkclass + "&qchkitem=" + qchkitem;
                        return(new ContentResult()
                        {
                            Content = @"<script>alert('修改成功!!');location.href='" + tgourl + "'</script>"
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #12
0
        public ActionResult Edit(Company chks, string sysflag, int?page, string orderdata, string orderdata1, HttpPostedFileBase logopic1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "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 != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var     data      = con.Company.Where(r => r.comid == chks.comid).FirstOrDefault();
                    Company eCompanys = con.Company.Find(chks.comid);
                    if (eCompanys == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(eCompanys));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldcomid = Request["oldcomid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();
                        if (logopic1 != null)
                        {
                            if (logopic1.ContentLength > 0)
                            {
                                chks.logopic = Request["comid"] + "." + logopic1.FileName.Substring(logopic1.FileName.Length - 3, 3);
                                logopic1.SaveAs(Server.MapPath("/upload/" + chks.logopic));
                            }
                        }

                        chks.comid            = Request["comid"].Trim();
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "代碼:" + chks.comid + "名稱:" + chks.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");
                    }
                }
            }
        }
コード例 #13
0
        public ActionResult maincontentadd(maincontent 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 = "mcid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qkeyword = "", qsmdate = "", qemdate = "", qmclassid = "";

            if (!string.IsNullOrWhiteSpace(Request["qkeyword"]))
            {
                qkeyword         = Request["qkeyword"].Trim();
                ViewBag.qkeyword = qkeyword;
            }
            if (!string.IsNullOrWhiteSpace(Request["qsmdate"]))
            {
                qsmdate         = Request["qsmdate"].Trim();
                ViewBag.qsmdate = qsmdate;
            }
            if (!string.IsNullOrWhiteSpace(Request["qemdate"]))
            {
                qemdate         = Request["qemdate"].Trim();
                ViewBag.qemdate = qemdate;
            }
            if (!string.IsNullOrWhiteSpace(Request["qmclassid"]))
            {
                qmclassid         = Request["qmclassid"].Trim();
                ViewBag.qmclassid = qmclassid;
            }

            if (sysflag != "A")
            {
                maincontent newcol = new maincontent();
                return(View(newcol));
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(col));
                }
                else
                {
                    Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
                    Session["mcid"] = "";


                    SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
                    SqlDataReader dr;
                    SqlCommand    sqlsmd = new SqlCommand();
                    sqlsmd.Connection = conn;
                    string sqlstr = "select * from sublevel1 where sid = '" + Request["realsid"].ToString() + "'";
                    sqlsmd.CommandText = sqlstr;
                    dr = sqlsmd.ExecuteReader();
                    string functype = "";
                    if (dr.Read())
                    {
                        //取得功能代號
                        functype = dr["functype"].ToString();
                    }

                    dr.Close();
                    dr.Dispose();
                    conn.Close();
                    conn.Dispose();

                    int         mcid = 0;
                    maincontent mobj;
                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        if (Request["mcid"].ToString() != "")
                        {
                            mcid = int.Parse(Request["mcid"].ToString());
                            //sqlstr = "select * from maincontent where mcid = '" +  Request["mcid"].ToString() + "'";
                            var data = con.maincontent.Where(r => r.mcid == mcid).FirstOrDefault();
                            mobj = con.maincontent.Find(mcid);
                        }
                        else
                        {
                            mobj = new maincontent();
                        }
                        mobj.mctype    = functype;
                        mobj.mctitle   = Request["mctitle"].ToString().Trim();
                        mobj.mchttp    = Request["mchttp"].ToString().Trim();
                        mobj.mccontent = Request["mccontent"].ToString().Trim();

                        if (Request["qmcparentid"].ToString() != "")
                        {
                            mobj.mcparentid = int.Parse(Request["mcparentid"].ToString().Trim());
                        }
                        mobj.mcfiletype = Request["mcfiletype"].ToString().Trim();
                        mobj.mclassid   = int.Parse(Request["mclassid"].ToString().Trim());
                        //        mobj.mcplace = Request["mcplace"].ToString().Trim();
                        mobj.sid    = int.Parse(Request["realsid"].ToString().Trim());
                        mobj.mdate  = DateTime.Parse(Request["mdate"].ToString());
                        mobj.mclick = 0;
                        //%>
                        //<!--#include file=addprivtbcount.asp-->
                        //<%
                        mobj.ownman   = Session["empid"].ToString();
                        mobj.comid    = Session["comid"].ToString();
                        mobj.bmodid   = Session["empid"].ToString();
                        mobj.bmoddate = DateTime.Now;
                        if (Request["mcid"].ToString() != "")
                        {
                            con.Entry(mobj).State = EntityState.Modified;
                            con.SaveChanges();
                        }
                        else
                        {
                            con.maincontent.Add(mobj);
                            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    = "類別:";
                        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='/oa/maincontent' 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='qkeyword' name='qkeyword' value='" + qkeyword + "'>";
                    tmpform += "<input type=hidden id='qsmdate' name='qsmdate' value='" + qsmdate + "'>";
                    tmpform += "<input type=hidden id='qemdate' name='qemdate' value='" + qemdate + "'>";
                    tmpform += "<input type=hidden id='qmclassid' name='qmclassid' value='" + qmclassid + "'>";
                    tmpform += "</form>";
                    tmpform += "</body>";


                    return(new ContentResult()
                    {
                        Content = @"" + tmpform
                    });
                    // return RedirectToAction("List");
                }
            }
        }
コード例 #14
0
        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
                        });
                    }
                }
            }
        }
コード例 #15
0
        public ActionResult Edit(progparam chks, string sysflag, int?page, string orderdata, string orderdata1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "comid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qchkclass = "", qchkitem = "";
            string comid = Session["comid"].ToString();

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var       data        = con.progparam.Where(r => r.comid == comid).FirstOrDefault();
                    progparam eprogparams = con.progparam.Find(comid);

                    if (eprogparams == null)
                    {
                        eprogparams = new progparam();
                        // return HttpNotFound();
                    }
                    //else {
                    return(View(eprogparams));
                    //}
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldmsid = Request["oldmsid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        chks.comid            = Session["comid"].ToString();
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Session["realsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "";
                        //string sysnote = "後來使用者登入後踢掉前面使用者::" + Request["ifkickuser"].ToString() + "<br>POP3 Server:" + Request["pop3server"].ToString() + "<br>SMTP Server:" + Request["smtpserver"].ToString() + "的資料";
                        dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                        sysconn.Close();
                        sysconn.Dispose();
                        //=================================================

                        string tmpform = "";
                        tmpform  = "<body onload=qfr1.submit();>";
                        tmpform += "<form name='qfr1' action='/progparam/Edit' method='post'>";
                        tmpform += "<input type=hidden name='sysflag' id='sysflag' value='A'>";
                        tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                        tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                        tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
                        tmpform += "<input type=hidden name='comid' id='comid' value='" + Session["comid"].ToString() + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #16
0
        public ActionResult Edit(certifystamp chks, string sysflag, int?page, string orderdata, string orderdata1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "citemid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qwtrack = "", qcitemid = "";

            if (!string.IsNullOrWhiteSpace(Request["qwtrack"]))
            {
                qwtrack         = Request["qwtrack"].Trim();
                ViewBag.qwtrack = qwtrack;
            }
            if (!string.IsNullOrWhiteSpace(Request["qcitemid"]))
            {
                qcitemid         = Request["qcitemid"].Trim();
                ViewBag.qcitemid = qcitemid;
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var          data           = con.certifystamp.Where(r => r.citemid == chks.citemid).FirstOrDefault();
                    certifystamp ecertifystamps = con.certifystamp.Find(chks.citemid);
                    if (ecertifystamps == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(ecertifystamps));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldmsid = Request["oldmsid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();
                        //chks.comid = Session["comid"].ToString();
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "標章認證字軌:" + chks.wtrack;
                        dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                        sysconn.Close();
                        sysconn.Dispose();
                        //=================================================

                        string tmpform = "";
                        tmpform  = "<body onload=qfr1.submit();>";
                        tmpform += "<form name='qfr1' action='/certifystamp/List' method='post'>";
                        tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
                        tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                        tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                        tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
                        tmpform += "<input type=hidden id='qwtrack' name='qwtrack' value='" + qwtrack + "'>";
                        tmpform += "<input type=hidden id='qcitemid' name='qcitemid' value='" + qcitemid + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #17
0
        public ActionResult Edit(holidayschedule chks, string sysflag, int?page, string orderdata, string orderdata1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "wsid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qwstitle = "", qyear = "", qcomid = "";

            if (!string.IsNullOrWhiteSpace(Request["qwstitle"]))
            {
                qwstitle         = Request["qwstitle"].Trim();
                ViewBag.qwstitle = qwstitle;
            }
            if (!string.IsNullOrWhiteSpace(Request["qyear"]))
            {
                qyear         = Request["qyear"].Trim();
                ViewBag.qyear = qyear;
            }
            if (!string.IsNullOrWhiteSpace(Request["qcomid"]))
            {
                qcomid         = Request["qcomid"].Trim();
                ViewBag.qcomid = qcomid;
            }
            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var             data = con.holidayschedule.Where(r => r.wsid == chks.wsid).FirstOrDefault();
                    holidayschedule eholidayschedules = con.holidayschedule.Find(chks.wsid);
                    if (eholidayschedules == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(eholidayschedules));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldmsid = Request["oldmsid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        NDcommon dbobj = new NDcommon();
                        chks.bmodid           = Session["tempid"].ToString();
                        chks.bmoddate         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();

                        //try
                        //{
                        //    con.SaveChanges();
                        //    con.Dispose();
                        //}
                        //catch (Exception ex)
                        //{
                        //    throw;
                        //}


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

                        string tmpform = "";
                        tmpform  = "<body onload=qfr1.submit();>";
                        tmpform += "<form name='qfr1' action='/holidayschedule/List' method='post'>";
                        tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
                        tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                        tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                        tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
                        tmpform += "<input type=hidden id='qwstitle' name='qchkclass' value='" + qwstitle + "'>";
                        tmpform += "<input type=hidden id='qyear' name='qchkitem' value='" + qyear + "'>";
                        tmpform += "<input type=hidden id='qcomid' name='qchkitem' value='" + qcomid + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #18
0
        public ActionResult Edit1(sublevel1 chks, string sysflag, int?page, string orderdata, string orderdata1)
        {
            ModelState.Clear();
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "corder";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "asc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;
            string qsublevelname1 = "";
            string uplink         = "0";

            if (!string.IsNullOrWhiteSpace(Request["qsublevelname1"]))
            {
                qsublevelname1         = Request["qsublevelname1"].Trim();
                ViewBag.qsublevelname1 = qsublevelname1;
            }
            if (string.IsNullOrWhiteSpace(Request["uplink"]))
            {
                uplink = "0";
            }
            else
            {
                uplink = Request["uplink"].Trim();
            }
            ViewBag.uplink = uplink;

            NDcommon dbobj   = new NDcommon();
            string   tmpsid  = dbobj.checknumber(Request["tmpsid"]);
            int      tmpsid1 = 0;

            if (!string.IsNullOrEmpty(tmpsid))
            {
                tmpsid1 = int.Parse(tmpsid);
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var       data        = con.sublevel1.Where(r => r.sid == tmpsid1).FirstOrDefault();
                    sublevel1 esublevel1s = con.sublevel1.Find(tmpsid1);
                    if (esublevel1s == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(esublevel1s));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    //string oldmsid = Request["oldmsid"];

                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        chks.sid              = tmpsid1;
                        chks.lid              = "3";
                        chks.counttype        = "00";
                        chks.uplink           = Int32.Parse(uplink);
                        chks.comid            = Session["comid"].ToString();
                        chks.BMODID           = Session["tempid"].ToString();
                        chks.BMODDATE         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();


                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "主目錄名稱:" + chks.sublevelname;
                        dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
                        sysconn.Close();
                        sysconn.Dispose();
                        //=================================================

                        string tmpform = "";
                        tmpform  = "<body onload=qfr1.submit();>";
                        tmpform += "<form name='qfr1' action='/sublevel1/List1' method='post'>";
                        tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
                        tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
                        tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
                        tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
                        tmpform += "<input type=hidden name='uplink' id='uplink' value='" + uplink + "'>";
                        tmpform += "<input type=hidden id='qsublevelname1' name='qsublevelname1' value='" + qsublevelname1 + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";


                        return(new ContentResult()
                        {
                            Content = @"" + tmpform
                        });
                        //return RedirectToAction("List");
                    }
                }
            }
        }
コード例 #19
0
        public ActionResult subreadwriteedit(subreadwrite 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 = "srwid";
            }

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

            NDcommon dbobj    = new NDcommon();
            string   tmpsid   = dbobj.checknumber(Request["tmpsid"]);
            int      tmpsid1  = 0;
            int      tmpsrwid = int.Parse(Request["srwid"].ToString());

            if (!string.IsNullOrEmpty(tmpsid))
            {
                tmpsid1 = int.Parse(tmpsid);
            }

            if (sysflag != "E")
            {
                using (Aitag_DBContext con = new Aitag_DBContext())
                {
                    var          data        = con.subreadwrite.Where(r => r.srwid == tmpsrwid).FirstOrDefault();
                    subreadwrite esublevel1s = con.subreadwrite.Find(tmpsrwid);
                    if (esublevel1s == null)
                    {
                        return(HttpNotFound());
                    }
                    return(View(esublevel1s));
                }
            }
            else
            {
                if (!ModelState.IsValid)
                {
                    return(View(chks));
                }
                else
                {
                    using (Aitag_DBContext con = new Aitag_DBContext())
                    {
                        chks.sid              = int.Parse(Request["tmpsid"].ToString());
                        chks.dptgroup         = Request["dptgroup"];
                        chks.empgroup         = Request["empgroup"];
                        chks.comid            = Session["comid"].ToString();
                        chks.BMODID           = Session["tempid"].ToString();
                        chks.BMODDATE         = DateTime.Now;
                        con.Entry(chks).State = EntityState.Modified;
                        con.SaveChanges();

                        //系統LOG檔
                        //================================================= //
                        SqlConnection sysconn    = dbobj.get_conn("Aitag_DBContext");
                        string        sysrealsid = Request["sysrealsid"].ToString();
                        string        syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
                        string        sysnote    = "調整id:" + Request["tmpsid"].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='/sublevel1/subreadwritelist' 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 += "<input type=hidden name='tmpsid' id='tmpsid' value='" + Request["tmpsid"].ToString() + "'>";
                        tmpform += "</form>";
                        tmpform += "</body>";

                        return(new ContentResult()
                        {
                            Content = @"<script>alert('修改成功!!');</script>" + tmpform
                        });
                    }
                }
            }
        }