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