//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // sales_competition col = new sales_competition(); // return View(col); //} //[HttpPost] public ActionResult add(sales_competition 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 = "ccid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qprodtitle = "", qcusttitle = ""; if (!string.IsNullOrWhiteSpace(Request["qprodtitle"])) { qprodtitle = Request["qprodtitle"].Trim(); ViewBag.qprodtitle = qprodtitle; } if (!string.IsNullOrWhiteSpace(Request["qcusttitle"])) { qcusttitle = Request["qcusttitle"].Trim(); ViewBag.qcusttitle = qcusttitle; } if (sysflag != "A") { sales_competition newcol = new sales_competition(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); SqlConnection conn = dbobj.get_conn("AitagBill_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select * from sales_competition where 1<>1"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "簡易代碼重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); //找出下一個呈核角色 #region 找出下一個呈核角色 string tmparolestampid = ""; string tmprole = ""; string tmpbillid = ""; if (Request["arolestampid"].ToString() != "") { tmparolestampid = "'" + Request["arolestampid"].ToString() + "'"; } string impallstring = dbobj.getnewcheck1("G", tmparolestampid, tmparolestampid, "1", "1", ""); tmprole = impallstring.Split(';')[0].ToString(); tmpbillid = impallstring.Split(';')[1].ToString(); if (tmprole == "") { ViewBag.ErrMsg = @"<script>alert(""請先至表單流程設定中設定新業務及競業呈核流程!"");</script>"; return(View(col)); } #endregion col.custlevel1 = Request["custlevel1"]; col.custlevel2 = Request["custlevel2"]; col.custlevel3 = Request["custlevel3"]; col.iflaw = ""; col.iffin = ""; col.corpitem = Request["corpitem"]; if (!string.IsNullOrWhiteSpace(Request["arolestampid"])) { col.arolestampid = Request["arolestampid"]; } else { col.arolestampid = Request["arolestampid1"]; } col.slogtype = "1"; col.slogstatus = "0"; // 己簽核:1 :0 col.rolestampid = tmprole; col.rolestampidall = tmparolestampid; col.empstampidall = "'" + col.empid + "'"; col.billflowid = int.Parse(tmpbillid); col.billtime = DateTime.Now.ToString(); col.ccid = Decimal.Parse(DateTime.Now.ToString("yyyyMMddhhmmssff")); col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (AitagBill_DBContext con = new AitagBill_DBContext()) { con.sales_competition.Add(col); con.SaveChanges(); //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "承辦人:" + col.empid + "產品名稱:" + col.prodtitle; 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='/sales_competition/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='qcusttitle' name='qcusttitle' value='" + qcusttitle + "'>"; tmpform += "<input type=hidden id='qprodtitle' name='qprodtitle' value='" + qprodtitle + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
public ActionResult chkEdit(sales_competition 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 = "ccid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qprodtitle = "", qcusttitlename = ""; if (!string.IsNullOrWhiteSpace(Request["qprodtitle"])) { qprodtitle = Request["qprodtitle"].Trim(); ViewBag.qprodtitle = qprodtitle; } if (!string.IsNullOrWhiteSpace(Request["qcusttitlename"])) { qcusttitlename = Request["qcusttitlename"].Trim(); ViewBag.qprodtitle = qcusttitlename; } if (sysflag != "E") { using (AitagBill_DBContext con = new AitagBill_DBContext()) { var data = con.sales_competition.Where(r => r.ccid == chks.ccid).FirstOrDefault(); sales_competition competitionlogs = con.sales_competition.Find(chks.ccid); if (competitionlogs == null) { return(HttpNotFound()); } return(View(competitionlogs)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; NDcommon dbobj = new NDcommon(); sales_competition col = new sales_competition(); using (AitagBill_DBContext con = new AitagBill_DBContext()) { col = con.sales_competition.Find(chks.ccid); } string sysnote = ""; if (dbobj.get_dbnull2(Request["slogstatus"]) == "1") { string tmprolestampid = col.rolestampid; string rolea_1 = col.rolestampidall; string roleall = rolea_1 + "," + tmprolestampid; //'簽核過角色(多個) string billflowid = col.billflowid.ToString(); //找出下一個角色是誰 string tmprole = dbobj.getnewcheck1("G", tmprolestampid, roleall, "", "", billflowid); if (tmprole == "'topman'") { tmprole = ""; } string slogstatus = ""; if (tmprole == "") { slogstatus = "1";// '己簽核 } else { slogstatus = "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 = ""; slogstatus = "1"; // '己簽核 } //'========================== } col.slogstatus = slogstatus; 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(); col.lawcomment = Request["lawcomment"].ToString(); col.fincomment = Request["fincomment"].ToString(); if (tmprole != "") { //寄信 //holidaycheckmainEditMail(col, tmprole); } else { //沒有下一個承辦人 (己通過) ////資料通過後 搬移到cardreallog //battacheckmainEditMove(col); //(己通過) 寄信 //holidaycheckmainEditMailPass(col); } sysnote = "請假單審核通過作業"; } else { col.slogstatus = "2"; col.rback = Request["hback1"].ToString(); col.bmodid = (string)Session["empid"]; col.bmoddate = DateTime.Now; col.billtime = col.billtime + "," + DateTime.Now.ToString(); ////資料通過後 搬移到cardreallog //battacheckmainEditMove(col); //(己通過) 寄信 //holidaycheckmainEditMailBack(col); sysnote = "新業務及競業退回作業"; } col.bmodid = Session["tempid"].ToString(); col.bmoddate = DateTime.Now; using (AitagBill_DBContext con = new AitagBill_DBContext()) { con.Entry(col).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.empid + "產品名稱:" + chks.prodtitle; 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='/sales_competition/chk' 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='qprodtitle' name='qprodtitle' value='" + qprodtitle + "'>"; tmpform += "<input type=hidden id='qcusttitlename' name='qcusttitlename' value='" + qcusttitlename + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } }
public ActionResult Edit(sales_competition 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 = "ccid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qprodtitle = "", qcusttitlename = ""; if (!string.IsNullOrWhiteSpace(Request["qprodtitle"])) { qprodtitle = Request["qprodtitle"].Trim(); ViewBag.qprodtitle = qprodtitle; } if (!string.IsNullOrWhiteSpace(Request["qcusttitlename"])) { qcusttitlename = Request["qcusttitlename"].Trim(); ViewBag.qprodtitle = qcusttitlename; } if (sysflag != "E") { using (AitagBill_DBContext con = new AitagBill_DBContext()) { var data = con.sales_competition.Where(r => r.ccid == chks.ccid).FirstOrDefault(); if (data == null) { return(HttpNotFound()); } return(View(data)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (AitagBill_DBContext con = new AitagBill_DBContext()) { var chdata = con.sales_competition.Where(r => r.ccid == chks.ccid).FirstOrDefault(); NDcommon dbobj = new NDcommon(); chdata.indclass = Request["indclass"]; chdata.prodtitle = Request["prodtitle"]; chdata.custtitle = Request["custtitle"]; chdata.custlevel1 = Request["custlevel1"]; chdata.custlevel2 = Request["custlevel2"]; chdata.custlevel3 = Request["custlevel3"]; chdata.corpitem = Request["corpitem"]; chdata.getcomtitle = Request["getcomtitle"]; chdata.ifget = Request["ifget"]; chdata.bmodid = Session["tempid"].ToString(); chdata.bmoddate = DateTime.Now; con.Entry(chdata).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.empid + "產品名稱:" + chks.prodtitle; 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='/sales_competition/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='qprodtitle' name='qprodtitle' value='" + qprodtitle + "'>"; tmpform += "<input type=hidden id='qcusttitlename' name='qcusttitlename' value='" + qcusttitlename + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }