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