public ActionResult Transfer(string sysflag, vend_contractdet col, HttpPostedFileBase upfile)
{
ViewBag.vcid = Request["vcid"].ToString();
if (sysflag != "A")
{
return(View());
}
else
{
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
if (upfile != null)
{
String sernonum = "";
//重新命名，存入檔案
DateTime myDate = DateTime.Now;
sernonum = myDate.ToString("yyyyMMddHHmmss");
string BasicPath = Server.MapPath("~/upload/");
int inputcount = 0;
string fileName = upfile.FileName.Substring(upfile.FileName.IndexOf("."), upfile.FileName.Length - upfile.FileName.IndexOf("."));
if (fileName != ".exe" && fileName != ".asp" && fileName != ".aspx" && fileName != ".jsp" && fileName != ".php")
{
fileName = "cust-" + sernonum.ToString() + fileName;
upfile.SaveAs(Server.MapPath("~/upload/") + fileName);
string tmppath = BasicPath + fileName;
StreamReader sr = new StreamReader(@tmppath, System.Text.Encoding.Default);
string allstr = sr.ReadToEnd(); //從資料流末端存取檔案
sr.Close();
string[] tmpstridno; //匯入資料
string[] toptmparry; //匯入的第一筆資料(欄位)
int tmparrycount = 0; //匯入欄位數
tmpstridno = allstr.Split(System.Environment.NewLine.ToCharArray());
//找第一筆的欄位數
toptmparry = tmpstridno[0].Split(',');
for (int tmpi = 0; tmpi <= toptmparry.Length - 1; tmpi++)
{
if (toptmparry[tmpi] != "")
{
tmparrycount++;
}
}
SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
string[] tmparry;
int vitemno = 0;
for (int i = 1; i <= tmpstridno.Length - 1; i++)
{
if (tmpstridno[i] != "")
{
#region
inputcount++;
tmparry = tmpstridno[i].Split(',');
//判斷必填欄位
if (tmparry[0] != "" && tmparry[1] != "")
{
// 品項編號0 品項名稱1 單位2 數量3 單價4 金額5 備註6
vitemno = vitemno + 2;
col.vcid = int.Parse(ViewBag.vcid);
col.bdprodno = tmparry[0];
col.bdprodtitle = tmparry[1];
col.vitemno = vitemno;
col.pdunit = tmparry[2];
col.vccount = int.Parse(tmparry[3]);
col.vcmoney = int.Parse(tmparry[4]);
col.vcallmoney = int.Parse(tmparry[5]);
col.vcdcomment = tmparry[6];
col.comid = Session["comid"].ToString();
col.bmodid = Session["tempid"].ToString();
col.bmoddate = DateTime.Now;
using (AitagBill_DBContext con = new AitagBill_DBContext())
{
con.vend_contractdet.Add(col);
con.SaveChanges();
//系統LOG檔 //================================================= //
//SqlConnection sysconn = dbobj.get_conn("MatsuEip_DBContext");
//string sysrealsid = Request["sysrealsid"].ToString();
//string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2");
//string sysnote = "行事曆標題:" + col.wstitle + "<br>日期:" + col.wsdate + "的資料";
//dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
//sysconn.Close();
//sysconn.Dispose();
//=================================================
}
}
#endregion
}
}
}
else
{
ViewBag.AddModelError = @"alert('上傳格式錯誤！');";
return(View());
}
}
ViewBag.AddModel = @"alert('轉檔成功！');" +
@"parent.opener.location.href = '/custcontract/detlist?vcid=" + ViewBag.vcid + "&sid=" + Request["sid"].ToString() + "&realsid=" + Request["realsid"].ToString() + "';" +
@"window.close();";
return(View());
}
}
public ActionResult detlistdo(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["pdid"];
string bdprodno1 = Request["bdprodno"];
string bdprodtitle1 = Request["bdprodtitle"];
//string mdno1 = Request["mdno"];
//string mdcomment1 = Request["mdcomment"];
string pdunit1 = Request["pdunit"];
string vccount1 = Request["vccount"];
string vcmoney1 = Request["vcmoney"];
string vcallmoney1 = Request["vcallmoney"];
string vcdcomment1 = Request["vcdcomment"];
string[] cdelarr = cdel1.Split(',');
string[] bdprodnoarr = bdprodno1.Split(',');
string[] bdprodtitlearr = bdprodtitle1.Split(',');
// string[] mdnoarr = mdno1.Split(',');
// string[] mdcommentarr = mdcomment1.Split(',');
string[] pdunitarr = pdunit1.Split(',');
string[] vccountarr = vccount1.Split(',');
string[] vcmoneyarr = vcmoney1.Split(',');
string[] vcallmoneyarr = vcallmoney1.Split(',');
string[] vcdcommentarr = vcdcomment1.Split(',');
vcid = Request["vcid"].ToString();
int pitemno = 10;
for (int i = 0; i < cdelarr.Length; i++)
{
if (cdelarr[i].Trim() == "")
{
if (!(bdprodnoarr[i].Trim() == ""))
{
vend_contractdet addobj = new vend_contractdet();
addobj.vcid = decimal.Parse(vcid);
addobj.vcno = Request["vcno"].ToString();
addobj.comid = Request["comid"].ToString();
addobj.bdprodno = bdprodnoarr[i].Trim();
addobj.bdprodtitle = bdprodtitlearr[i].Trim();
// addobj.mdno = mdnoarr[i].Trim();
// addobj.mdcomment = mdcommentarr[i].Trim();
addobj.vitemno = pitemno;
addobj.pdunit = pdunitarr[i].Trim();
addobj.vccount = Decimal.Parse(vccountarr[i].ToString());
addobj.vcmoney = Decimal.Parse(vcmoneyarr[i].ToString());
addobj.vcallmoney = Decimal.Parse(vcallmoneyarr[i].ToString());
addobj.vcdcomment = vcdcommentarr[i].Trim();
addobj.projno = Request["projno"].ToString();
addobj.bmodid = Session["empid"].ToString();
addobj.bmoddate = DateTime.Now;
con.vend_contractdet.Add(addobj);
con.SaveChanges();
pitemno = pitemno + 10;
}
}
else
{
//修改
int pdid = int.Parse(cdelarr[i].Trim());
vend_contractdet modobj = con.vend_contractdet.Where(r => r.vcdid == pdid).FirstOrDefault();
modobj.bdprodno = bdprodnoarr[i].Trim();
modobj.bdprodtitle = bdprodtitlearr[i].Trim();
// modobj.mdno = mdnoarr[i].Trim();
// modobj.mdcomment = mdcommentarr[i].Trim();
modobj.pdunit = pdunitarr[i].Trim();
modobj.vccount = Decimal.Parse(vccountarr[i].ToString());
modobj.vcmoney = Decimal.Parse(vcmoneyarr[i].ToString());
modobj.vcallmoney = Decimal.Parse(vcallmoneyarr[i].ToString());
modobj.vcdcomment = vcdcommentarr[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='/custcontract/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='vcid' id='vcid' value='" + vcid + "'>";
tmpform += "</form>";
tmpform += "</body>";
return(new ContentResult()
{
Content = @"" + tmpform
});
}
