public ActionResult Editdo(string sysflag, int?page, string orderdata, string orderdata1)
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qpdno = "", qallcomid = "", qvcno = "", qvcsdate = "", qvcedate = "";
if (!string.IsNullOrWhiteSpace(Request["qallcomid"]))
{
qallcomid = Request["qallcomid"].Trim();
ViewBag.qvendno = qallcomid;
}
if (!string.IsNullOrWhiteSpace(Request["qvcno"]))
{
qvcno = Request["qvcno"].Trim();
ViewBag.qvcno = qvcno;
}
if (!string.IsNullOrWhiteSpace(Request["qvcsdate"]))
{
qvcsdate = Request["qvcsdate"].Trim();
ViewBag.qvcsdate = qvcsdate;
}
if (!string.IsNullOrWhiteSpace(Request["qvcedate"]))
{
qvcedate = Request["qvcedate"].Trim();
ViewBag.qvcedate = qvcedate;
}
if (!string.IsNullOrWhiteSpace(Request["qpdno"]))
{
qpdno = Request["qpdno"].Trim();
ViewBag.qpdno = qpdno;
}
int vcid = int.Parse(Request["vcid"].ToString());
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
vend_contract modobj = con.vend_contract.Where(r => r.vcid == vcid).FirstOrDefault();
modobj.vcdate = DateTime.Parse(Request["vcdate"].ToString());
modobj.vcsdate = DateTime.Parse(Request["vcsdate"].ToString());
modobj.vcedate = DateTime.Parse(Request["vcedate"].ToString());
modobj.comid = Request["comid"];
modobj.projno = Request["projno"];
modobj.taxtype = Request["taxtype"];
modobj.vcmoney = int.Parse(Request["vcmoney"]);
modobj.vctaxmoney = int.Parse(Request["vctaxmoney"]);
modobj.vcallmoney = int.Parse(Request["vcallmoney"]);
modobj.vccomment = Request["vccomment"];
modobj.allcomid = Request["allcomid"];
modobj.bmodid = Session["empid"].ToString();
modobj.bmoddate = DateTime.Now;
con.Entry(modobj).State = EntityState.Modified;
con.SaveChanges();
con.Dispose();
}
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/custcontract/list' method='post'>";
tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
tmpform += "<input type=hidden id='qpdno' name='qpdno' value='" + qpdno + "'>";
tmpform += "<input type=hidden id='qallcomid' name='qallcomid' value='" + qallcomid + "'>";
tmpform += "<input type=hidden id='qvcno' name='qvcno' value='" + qvcno + "'>";
//tmpform += "<input type=hidden id='qpcomment' name='qpcomment' value='" + qpcomment + "'>";
tmpform += "<input type=hidden id='qvcsdate' name='qvcsdate' value='" + qvcsdate + "'>";
tmpform += "<input type=hidden id='qvcedate' name='qvcedate' value='" + qvcedate + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
}
public ActionResult adddo(string sysflag, int?page, string orderdata, string orderdata1)
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qbseason = "", qslyear = "", qslmonth = "", qvtype = "", qvendcomid = "", qsdate = "", qedate = "";
if (!string.IsNullOrWhiteSpace(Request["qbseason"]))
{
qbseason = Request["qbseason"].Trim();
ViewBag.qbseason = qbseason;
}
if (!string.IsNullOrWhiteSpace(Request["qslyear"]))
{
qslyear = Request["qslyear"].Trim();
ViewBag.qslyear = qslyear;
}
if (!string.IsNullOrWhiteSpace(Request["qslmonth"]))
{
qslmonth = Request["qslmonth"].Trim();
ViewBag.qslmonth = qslmonth;
}
if (!string.IsNullOrWhiteSpace(Request["qvtype"]))
{
qvtype = Request["qvtype"].Trim();
ViewBag.qvtype = qvtype;
}
if (!string.IsNullOrWhiteSpace(Request["qvendcomid"]))
{
qvendcomid = Request["qvendcomid"].Trim();
ViewBag.qvendcomid = qvendcomid;
}
if (!string.IsNullOrWhiteSpace(Request["qsdate"]))
{
qsdate = Request["qsdate"].Trim();
ViewBag.qsdate = qsdate;
}
if (!string.IsNullOrWhiteSpace(Request["qedate"]))
{
qedate = Request["qedate"].Trim();
ViewBag.qedate = qedate;
}
NDcommon dbobj = new NDcommon();
SqlConnection erpconn = dbobj.get_conn("AitagBill_DBContext");
SqlConnection erpconn1 = dbobj.get_conn("AitagBill_DBContext");
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
string tmpssql = "";
int strym = 0;
int etrym = 0;
//找審過過單
tmpssql = "select (payvendcomid) as vendno, isnull(sum(psummoney),0) as psummoney FROM vend_contractinvclose INNER JOIN vend_contractinvclose_det ON vend_contractinvclose.vcinvid =vend_contractinvclose_det.vcinvid where vstatus<>'D' ";
switch (qbseason)
{
case "01": //月獎
tmpssql += " and slyear =" + qslyear + " and slmonth = " + qslmonth + " group by payvendcomid ";
break;
case "02": //季獎 3 / 6 / 9/ 12
strym = 365 * int.Parse(qslyear) + 30 * int.Parse(qslmonth);
//etrym = qslyear.ToString() + qslmonth.ToString().PadLeft(2, '0');
if (qslmonth.ToString().PadLeft(2, '0') == "03")
{
strym = 365 * int.Parse(qslyear) + 30 * 1;
etrym = 365 * int.Parse(qslyear) + 30 * 3;
}
else if (qslmonth.ToString().PadLeft(2, '0') == "06")
{
strym = 365 * int.Parse(qslyear) + 30 * 4;
etrym = 365 * int.Parse(qslyear) + 30 * 6;
}
else if (qslmonth.ToString().PadLeft(2, '0') == "09")
{
strym = 365 * int.Parse(qslyear) + 30 * 7;
etrym = 365 * int.Parse(qslyear) + 30 * 9;
}
else if (qslmonth.ToString().PadLeft(2, '0') == "12")
{
strym = 365 * int.Parse(qslyear) + 30 * 10;
etrym = 365 * int.Parse(qslyear) + 30 * 12;
}
tmpssql += " and (slyear * 365 + slmonth * 30) >= " + strym.ToString() + " and (slyear * 365 + slmonth * 30) <= " + etrym.ToString() + " group by payvendcomid ";
break;
case "03": //半年獎 06 / 12
strym = 365 * int.Parse(qslyear) + 30 * int.Parse(qslmonth);
//etrym = qslyear.ToString() + qslmonth.ToString().PadLeft(2, '0');
if (qslmonth.ToString().PadLeft(2, '0') == "06")
{
strym = 365 * int.Parse(qslyear) + 30 * 1;
etrym = 365 * int.Parse(qslyear) + 30 * 6;
}
else if (qslmonth.ToString().PadLeft(2, '0') == "12")
{
strym = 365 * int.Parse(qslyear) + 30 * 7;
etrym = 365 * int.Parse(qslyear) + 30 * 12;
}
tmpssql += " and (slyear * 365 + slmonth * 30) >= " + strym.ToString() + " and (slyear * 365 + slmonth * 30) <= " + etrym.ToString() + " group by payvendcomid ";
break;
case "04": //年獎
tmpssql += " and year(vadate) =" + qslyear + " group by payvendcomid ";
break;
}
SqlDataReader dr = dbobj.dbselect(erpconn, tmpssql);
string iftax = "";
if (dr.HasRows)
{
while (dr.Read())
{
decimal tmprate = 0;
decimal tmppsummoney = decimal.Parse(dr["psummoney"].ToString());
decimal pallbonusmoney = tmppsummoney;
// 找 廠商/客戶的 計算方式 , vendno 在客戶計算是客戶的欄位
//tmpssql = "select * from allcompany_rate where bseason='" + qbseason + "' and allcomid='" + dr["vendno"].ToString() + "' and (bsmoney <=" + tmppsummoney + " and bemoney >=" + tmppsummoney + " )";
//單筆金額
tmpssql = "select * from allcompany_rate where bseason='" + qbseason + "' and allcomid='" + dr["vendno"].ToString() + "' and btype = '0'";
SqlDataReader dr1 = dbobj.dbselect(erpconn1, tmpssql);
if (dr1.Read())
{
pallbonusmoney = decimal.Parse(dr1["brate"].ToString());
}
dr1.Close();
dr1.Dispose();
//單筆比例
tmpssql = "select * from allcompany_rate where bseason='" + qbseason + "' and allcomid='" + dr["vendno"].ToString() + "' and btype = '1'";
dr1 = dbobj.dbselect(erpconn1, tmpssql);
if (dr1.Read())
{
iftax = dr1["brate"].ToString();
tmprate = decimal.Parse(dr1["brate"].ToString());
if (iftax == "0")
{
pallbonusmoney = pallbonusmoney * tmprate / 100;
}
else
{
pallbonusmoney = (pallbonusmoney * tmprate * decimal.Parse("1.05")) / 100;
}
}
dr1.Close();
dr1.Dispose();
//落點金額比例
tmpssql = "select * from allcompany_rate where bseason='" + qbseason + "' and allcomid='" + dr["vendno"].ToString() + "' and btype = '2' and (bsmoney <=" + tmppsummoney + " and bemoney >=" + tmppsummoney + ")";
dr1 = dbobj.dbselect(erpconn1, tmpssql);
if (dr1.Read())
{
iftax = dr1["brate"].ToString();
tmprate = decimal.Parse(dr1["brate"].ToString());
if (iftax == "0")
{
pallbonusmoney = pallbonusmoney * tmprate / 100;
}
else
{
pallbonusmoney = (pallbonusmoney * tmprate * decimal.Parse("1.05")) / 100;
}
}
dr1.Close();
dr1.Dispose();
//累積金額比例
tmpssql = "select * from allcompany_rate where bseason='" + qbseason + "' and allcomid='" + dr["vendno"].ToString() + "' and btype = '3' and (bsmoney <=" + tmppsummoney + " and bemoney >=" + tmppsummoney + ")";
dr1 = dbobj.dbselect(erpconn1, tmpssql);
if (dr1.Read())
{
iftax = dr1["brate"].ToString();
tmprate = decimal.Parse(dr1["brate"].ToString());
if (iftax == "0")
{
pallbonusmoney = pallbonusmoney * tmprate / 100;
}
else
{
pallbonusmoney = (pallbonusmoney * tmprate * decimal.Parse("1.05")) / 100;
}
}
dr1.Close();
dr1.Dispose();
vend_monthmoney addobj = new vend_monthmoney();
addobj.bseason = qbseason; //01:月獎 02:季獎 03:半年獎 04:年獎 05:現折
addobj.slyear = int.Parse(qslyear);
if (qbseason == "04")
{
addobj.slmonth = 12;
}
else
{
addobj.slmonth = int.Parse(qslmonth);
}
addobj.vendcomid = dr["vendno"].ToString();
addobj.vtype = "2";//1:收入 2:支出
addobj.pallbonusmoney = pallbonusmoney;
addobj.pallmoney = tmppsummoney;
addobj.bmodid = Session["empid"].ToString();
addobj.bmoddate = DateTime.Now;
addobj.comid = Session["comid"].ToString();
con.vend_monthmoney.Add(addobj);
}
}
con.SaveChanges();
con.Dispose();
}
erpconn.Close();
erpconn.Dispose();
erpconn1.Close();
erpconn1.Dispose();
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/vend_monthmoney/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='qbseason' name='qbseason' value='" + qbseason + "'>";
tmpform += "<input type=hidden id='qslyear' name='qslyear' value='" + qslyear + "'>";
tmpform += "<input type=hidden id='qslmonth' name='qslmonth' value='" + qslmonth + "'>";
tmpform += "<input type=hidden id='qvendcomid' name='qvendcomid' value='" + qvendcomid + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
}
public ActionResult detlistdo(string sysflag, int?page, string orderdata, string orderdata1)
{
NDcommon dbobj = new NDcommon();
SqlConnection erpconn = dbobj.get_conn("AitagBill_DBContext");
SqlCommand cmd = new SqlCommand();
string wno = "", comid = "";
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string sqlstr = "";
string cdel1 = Request["wkdid"];
string wkcdate1 = Request["wkcdate"];
string wkstep1 = Request["wkstep"];
string getman1 = Request["getman"];
string prdate1 = Request["prdate"];
string realdate1 = Request["realdate"];
string worktype1 = Request["worktype"];
string makeitem1 = Request["makeitem"];
string[] cdelarr = cdel1.Split(',');
string[] wkcdatedarr = wkcdate1.Split(',');
string[] wksteparr = wkstep1.Split(',');
string[] getmanarr = getman1.Split(',');
string[] prdatearr = prdate1.Split(',');
string[] realdatearr = realdate1.Split(',');
string[] worktypearr = worktype1.Split(',');
string[] makeitemrr = makeitem1.Split(',');
wno = Request["wno"].ToString();
comid = Request["comid"].ToString();
for (int i = 0; i < cdelarr.Length; i++)
{
if (cdelarr[i].Trim() == "")
{
if (!(wkcdatedarr[i].Trim() == "" && wksteparr[i].Trim() == ""))
{
workcard_det addobj = new workcard_det();
addobj.comid = comid;
addobj.wno = wno;
addobj.wkcdate = DateTime.Parse(wkcdatedarr[i].ToString());
addobj.wkstep = wksteparr[i].Trim();
addobj.getman = getmanarr[i].Trim();
addobj.bmodid = Session["empid"].ToString();
addobj.bmoddate = DateTime.Now;
if (prdatearr[i].ToString() != "")
{
addobj.prdate = DateTime.Parse(prdatearr[i].ToString());
}
else
{
addobj.prdate = null;
}
if (realdatearr[i].ToString() != "")
{
addobj.realdate = DateTime.Parse(realdatearr[i].ToString());
}
else
{
addobj.realdate = null;
}
addobj.worktype = worktypearr[i].Trim();
addobj.makeitem = makeitemrr[i].Trim();
con.workcard_det.Add(addobj);
con.SaveChanges();
}
}
else
{
//修改
int wkdid = int.Parse(cdelarr[i].Trim());
workcard_det modobj = con.workcard_det.Where(r => r.wkdid == wkdid).FirstOrDefault();
modobj.wkcdate = DateTime.Parse(wkcdatedarr[i].ToString());
modobj.wkstep = wksteparr[i].Trim();
modobj.getman = getmanarr[i].Trim();
if (prdatearr[i].ToString() != "")
{
modobj.prdate = DateTime.Parse(prdatearr[i].ToString());
}
else
{
modobj.prdate = null;
}
if (realdatearr[i].ToString() != "")
{
modobj.realdate = DateTime.Parse(realdatearr[i].ToString());
}
else
{
modobj.realdate = null;
}
modobj.worktype = worktypearr[i].Trim();
modobj.makeitem = makeitemrr[i].Trim();
modobj.bmodid = Session["empid"].ToString();
modobj.bmoddate = DateTime.Now;
con.Entry(modobj).State = EntityState.Modified;
con.SaveChanges();
}
}
con.Dispose();
}
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/workcard/detlist' 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='wno' id='wno' value='" + wno + "'>";
tmpform += "<input type=hidden name='comid' id='comid' value='" + comid + "'>";
tmpform += "</body>";
erpconn.Close();
erpconn.Dispose();
return(new ContentResult()
{
Content = @"" + tmpform
});
}
public ActionResult Edit(workcard 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 = " wno";
}
if (string.IsNullOrWhiteSpace(orderdata1))
{
orderdata1 = " asc";
}
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qwno = "", qcustno = "";
if (!string.IsNullOrWhiteSpace(Request["qwno"]))
{
qwno = Request["qwno"].Trim();
ViewBag.qwno = qwno;
}
if (!string.IsNullOrWhiteSpace(Request["qcustno"]))
{
qcustno = Request["qcustno"].Trim();
ViewBag.qcustno = qcustno;
}
if (sysflag != "E")
{
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
var data = con.workcard.Where(r => r.wno == chks.wno && r.comid == chks.comid).FirstOrDefault();
workcard eCompanys = con.workcard.Find(chks.wno);
if (eCompanys == null)
{
return(HttpNotFound());
}
return(View(eCompanys));
}
}
else
{
if (!ModelState.IsValid)
{
return(View(chks));
}
else
{
NDcommon dbobj = new NDcommon();
string wno = Request["wno"].ToString();
string comid = Request["comid"].ToString();
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
workcard modobj = con.workcard.Where(r => r.wno == wno && r.comid == comid).FirstOrDefault();
modobj.projno = Request["projno"];
modobj.custno = Request["custno"];
modobj.wktitle = Request["wktitle"];
modobj.wkbudget = int.Parse(Request["wkbudget"]);
modobj.prodno = Request["prodno"];
modobj.pwno = Request["pwno"];
modobj.ifwh = Request["ifwh"];
modobj.whno = Request["whno"];
modobj.prclosedate = DateTime.Parse(Request["prclosedate"].ToString());
modobj.putoffday = int.Parse(Request["putoffday"]);
modobj.closedate = DateTime.Parse(Request["closedate"].ToString());
modobj.closeman = Request["closeman"];
modobj.slyear = int.Parse(Request["slyear"]);
modobj.slmonth = int.Parse(Request["slmonth"]);
modobj.tkyear = int.Parse(Request["tkyear"]);
modobj.tkmonth = int.Parse(Request["tkmonth"]);
modobj.bmodid = Session["empid"].ToString();
modobj.bmoddate = DateTime.Now;
con.Entry(modobj).State = EntityState.Modified;
con.SaveChanges();
con.Dispose();
}
//系統LOG檔
//================================================= //
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
string sysrealsid = Request["sysrealsid"].ToString();
string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
string sysnote = "客戶:" + Request["custno"] + "工作卡號:" + wno;
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='/workcard/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='qwno' name='qwno' value='" + qwno + "'>";
tmpform += "<input type=hidden id='qcustno' name='qcustno' value='" + qcustno + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"<script>alert('修改成功!!');</script>" + tmpform
});
// return RedirectToAction("List");
}
}
}
public ActionResult brlistdo(string sysflag, int?page, string orderdata, string orderdata1)
{
string vcid = "";
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string sqlstr = "";
string cdel1 = Request["bid"];
string bseason1 = Request["bseason"];
string btype1 = Request["btype"];
//string mdno1 = Request["mdno"];
//string mdcomment1 = Request["mdcomment"];
string bsmoney1 = Request["bsmoney"];
string bemoney1 = Request["bemoney"];
string brate1 = Request["brate"];
string bcomment1 = Request["bcomment"];
string[] cdelarr = cdel1.Split(',');
string[] bseasonarr = bseason1.Split(',');
string[] btypearr = btype1.Split(',');
// string[] mdnoarr = mdno1.Split(',');
// string[] mdcommentarr = mdcomment1.Split(',');
string[] bsmoneyarr = bsmoney1.Split(',');
string[] bemoneyarr = bemoney1.Split(',');
string[] bratearr = brate1.Split(',');
string[] bcommentarr = bcomment1.Split(',');
vcid = Request["vcid"].ToString();
int pitemno = 10;
for (int i = 0; i < cdelarr.Length; i++)
{
if (cdelarr[i].Trim() == "")
{
if (!(bseasonarr[i].Trim() == ""))
{
bonusrate addobj = new bonusrate();
addobj.vcid = int.Parse(vcid);
//addobj.vcno = Request["vcno"].ToString();
addobj.comid = Request["comid"].ToString();
addobj.bseason = bseasonarr[i].Trim();
addobj.btype = btypearr[i].Trim();
// addobj.mdno = mdnoarr[i].Trim();
// addobj.mdcomment = mdcommentarr[i].Trim();
// addobj.vitemno = pitemno;
addobj.bsmoney = int.Parse(bsmoneyarr[i].ToString());
addobj.bemoney = int.Parse(bemoneyarr[i].ToString());
addobj.brate = Decimal.Parse(bratearr[i].ToString());
//addobj.vcallmoney = Decimal.Parse(vcallmoneyarr[i].ToString());
addobj.bcomment = bcommentarr[i].Trim();
// addobj.projno = Request["projno"].ToString();
addobj.bmodid = Session["empid"].ToString();
addobj.bmoddate = DateTime.Now;
con.bonusrate.Add(addobj);
con.SaveChanges();
pitemno = pitemno + 10;
}
}
else
{
//修改
int bid = int.Parse(cdelarr[i].Trim());
bonusrate modobj = con.bonusrate.Where(r => r.bid == bid).FirstOrDefault();
modobj.comid = Request["comid"].ToString();
modobj.bseason = bseasonarr[i].Trim();
modobj.btype = btypearr[i].Trim();
// addobj.mdno = mdnoarr[i].Trim();
// addobj.mdcomment = mdcommentarr[i].Trim();
// addobj.vitemno = pitemno;
modobj.bsmoney = int.Parse(bsmoneyarr[i].ToString());
modobj.bemoney = int.Parse(bemoneyarr[i].ToString());
modobj.brate = Decimal.Parse(bratearr[i].ToString());
//addobj.vcallmoney = Decimal.Parse(vcallmoneyarr[i].ToString());
modobj.bcomment = bcommentarr[i].Trim();
// addobj.projno = Request["projno"].ToString();
modobj.bmodid = Session["empid"].ToString();
modobj.bmoddate = DateTime.Now;
modobj.bmodid = Session["empid"].ToString();
modobj.bmoddate = DateTime.Now;
con.Entry(modobj).State = EntityState.Modified;
con.SaveChanges();
}
}
con.Dispose();
}
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/custcontract/brlist' 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='vcid' id='vcid' value='" + vcid + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
}
public ActionResult adddo(string sysflag, int?page, string orderdata, string orderdata1)
{
page = ((!page.HasValue || page < 1) ? 1 : page);
ViewBag.page = page;
ViewBag.orderdata = orderdata;
ViewBag.orderdata1 = orderdata1;
string qpdno = "", qallcomid = "", qvcno = "", qvcsdate = "", qvcedate = "";
if (!string.IsNullOrWhiteSpace(Request["qallcomid"]))
{
qallcomid = Request["qallcomid"].Trim();
ViewBag.qvendno = qallcomid;
}
if (!string.IsNullOrWhiteSpace(Request["qvcno"]))
{
qvcno = Request["qvcno"].Trim();
ViewBag.qvcno = qvcno;
}
if (!string.IsNullOrWhiteSpace(Request["qvcsdate"]))
{
qvcsdate = Request["qvcsdate"].Trim();
ViewBag.qvcsdate = qvcsdate;
}
if (!string.IsNullOrWhiteSpace(Request["qvcedate"]))
{
qvcedate = Request["qvcedate"].Trim();
ViewBag.qvcedate = qvcedate;
}
if (!string.IsNullOrWhiteSpace(Request["qpdno"]))
{
qpdno = Request["qpdno"].Trim();
ViewBag.qpdno = qpdno;
}
NDcommon dbobj = new NDcommon();
SqlConnection conn = dbobj.get_conn("AitagBill_DBContext");
string vcno = "";
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
vend_contract addobj = new vend_contract();
vcno = dbobj.get_billno(conn, "C", "", Request["comid"].ToString(), "", Request["pdate"].ToString());
addobj.vcid = Decimal.Parse(DateTime.Now.ToString("yyyyMMddhhmmssff"));
addobj.vcdate = DateTime.Parse(Request["pdate"].ToString());
addobj.comid = Request["comid"];
addobj.vcno = vcno;
addobj.projno = vcno;
addobj.vcstatus = "0";
addobj.vendtype = "2";
addobj.taxtype = Request["taxtype"];
addobj.ownman = Session["empid"].ToString();
addobj.vcmoney = int.Parse(Request["vcmoney"]);
addobj.vctaxmoney = int.Parse(Request["vctaxmoney"]);
addobj.vcallmoney = int.Parse(Request["vcallmoney"]);
addobj.allcomid = Request["allcomid"].Trim();
addobj.vccomment = Request["vccomment"].Trim();
addobj.bmodid = Session["empid"].ToString();
addobj.bmoddate = DateTime.Now;
con.vend_contract.Add(addobj);
con.SaveChanges();
con.Dispose();
}
conn.Close();
conn.Dispose();
string tmpform = "";
tmpform = "<body onload=qfr1.submit();>";
tmpform += "<form name='qfr1' action='/custcontract/list' method='post'>";
tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>";
tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>";
tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>";
tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>";
tmpform += "<input type=hidden id='qpdno' name='qpdno' value='" + qpdno + "'>";
tmpform += "<input type=hidden id='qallcomid' name='qallcomid' value='" + qallcomid + "'>";
tmpform += "<input type=hidden id='qvcno' name='qvcno' value='" + qvcno + "'>";
// tmpform += "<input type=hidden id='qpcomment' name='qpcomment' value='" + qpcomment + "'>";
tmpform += "<input type=hidden id='qvcsdate' name='qvcsdate' value='" + qvcsdate + "'>";
tmpform += "<input type=hidden id='qvcedate' name='qvcedate' value='" + qvcedate + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
}
