public HttpResponseBase GetCountBook()
{
// DataSet.Tables["XX"].Columns["xx"].ColumnName = "NewColumnName";
string json = string.Empty;
IinvdQuery m = new IinvdQuery();
CbjobMaster cm = new CbjobMaster();
CbjobDetail cd = new CbjobDetail();
IinvdMgr iinvdMgr = new IinvdMgr(mySqlConnectionString);
_IiupcMgr = new IupcMgr(mySqlConnectionString);
string cbjob_id = "PC" + DateTime.Now.ToString("yyyyMMddHHmmss");
try
{
#region 條件
if (!string.IsNullOrEmpty(Request.Params["startIloc"]))
{//料位開始
m.startIloc = Request.Params["startIloc"].ToUpper();
}
if (!string.IsNullOrEmpty(Request.Params["endIloc"]))
{
m.endIloc = Request.Params["endIloc"] + "Z";
m.endIloc = m.endIloc.ToUpper();
}
if (!string.IsNullOrEmpty(Request.Params["level"]))//層數
{//層數選擇
m.lot_no = Request.Params["level"].ToString().ToUpper();
}
if (!string.IsNullOrEmpty(Request.Params["sort"]))//排序
{//排序方式
m.Sort = Request.Params["sort"];
if (m.Sort == "0" && !string.IsNullOrEmpty(Request.Params["firstsd"]))
{
m.Firstsd = Request.Params["firstsd"];
}
}
if (!string.IsNullOrEmpty(Request.Params["vender"]))
{//vender
m.vender = Request.Params["vender"].ToString().ToUpper();
}
if (!string.IsNullOrEmpty(Request.Params["prepaid"]))
{
m.prepaid = int.Parse(Request.Params["prepaid"]);
}
#endregion
DataTable dt = iinvdMgr.getproduct(m);
#region 列名
DataTable dtCountBook = new DataTable();
dtCountBook.Columns.Add("編號", typeof(String));
dtCountBook.Columns.Add("料位", typeof(String));
dtCountBook.Columns.Add("狀態", typeof(String));
dtCountBook.Columns.Add("商品細項編號", typeof(String));
dtCountBook.Columns.Add("庫存", typeof(String));
dtCountBook.Columns.Add("成本", typeof(String));
dtCountBook.Columns.Add("商品名稱", typeof(String));
dtCountBook.Columns.Add("商品規格", typeof(String));
dtCountBook.Columns.Add("是否買斷", typeof(String));
dtCountBook.Columns.Add("製造日期", typeof(String));
dtCountBook.Columns.Add("保存期限", typeof(String));
dtCountBook.Columns.Add("有效日期", typeof(String));
dtCountBook.Columns.Add("是否有效期控制", typeof(String));
dtCountBook.Columns.Add("是否即期", typeof(String));
dtCountBook.Columns.Add("是否過期", typeof(String));
dtCountBook.Columns.Add("允出天數", typeof(String));
dtCountBook.Columns.Add("允收天數", typeof(String));
dtCountBook.Columns.Add("國際條碼", typeof(String));
dtCountBook.Columns.Add("最新店內碼", typeof(String));
#endregion
if (dt.Rows.Count > 0)
{
#region 往cbjob_master裡面插入一條數據
StringBuilder sb = new StringBuilder();
_cbjobMgr = new CbjobDetailMgr(mySqlConnectionString);
_cbMasterMgr = new CbjobMasterMgr(mySqlConnectionString);
cm.cbjob_id = cbjob_id;
cm.create_datetime = DateTime.Now;
cm.sta_id = "CNT";
cm.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
sb.Append(_cbMasterMgr.Insertsql(cm));
#endregion
#region 修改iinvd數據,往cbjob_detail循環插入數據
int a = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(dt.Rows[i]["row_id"].ToString()))
{
cd.cb_jobid = cm.cbjob_id;
cd.cb_newid = a + 1;
cd.chang_user = cm.create_user;
cd.change_datetime = DateTime.Now;
cd.create_datetime = DateTime.Now;
cd.create_user = cm.create_user;
cd.status = 1;
cd.iinvd_id = int.Parse(dt.Rows[i]["row_id"].ToString());
sb.AppendFormat("set sql_safe_updates = 0; UPDATE iinvd set st_qty=prod_qty where row_id='{0}'; set sql_safe_updates = 1;", cd.iinvd_id);
sb.Append(_cbjobMgr.insertsql(cd));
a++;
}
}
_cbjobMgr.InsertSql(sb.ToString());
#endregion
m.cb_jobid = cm.cbjob_id;//賦值給m
//dt = iinvdMgr.CountBook(m);
int bh = 1;
string loc = "";
foreach (DataRow item2 in dt.Rows)
{
if (item2["loc_id"].ToString() != loc)
{
if (!string.IsNullOrEmpty(item2["row_id"].ToString()))
{
#region 讀取iinvd裡面的數據
m.loc_id = item2["loc_id"].ToString();
DataTable Invdt = iinvdMgr.GetIinvdCountBook(m);
foreach (DataRow item in Invdt.Rows)
{
DataRow dr = dtCountBook.NewRow();
dr[0] = bh;
dr[1] = item["loc_id"];
dr[2] = item["lsta_id"];
if (!string.IsNullOrEmpty(item["item_id"].ToString()))
{
dr[3] = item["item_id"];
}
if (!string.IsNullOrEmpty(item["prod_qty"].ToString()))
{
dr[4] = item["prod_qty"];
}
else
{
dr[4] = "0";
}
if (!string.IsNullOrEmpty(item["product_id"].ToString()))
{
dr[5] = iinvdMgr.Getcost(item["product_id"].ToString());
}
dr[6] = item["product_name"];
dr[7] = GetProductSpec(item["item_id"].ToString());
dr[8] = item["prepaid"].ToString() == "0" ? "否" : "是";
DateTime md;
if (DateTime.TryParse(item["made_date"].ToString(), out md))
{
dr[9] = DateTime.Parse(item["made_date"].ToString()).ToString("yyyy/MM/dd");
}
dr[10] = item["cde_dt_incr"];
DateTime cdate;
if (DateTime.TryParse(item["cde_dt"].ToString(), out cdate))
{
dr[11] = cdate.ToString("yyyy/MM/dd");
}
int shp = 0;
if (item["pwy_dte_ctl"].ToString() == "Y" && Int32.TryParse(item["cde_dt_shp"].ToString(), out shp))//表示是有效期控管的商品
{
dr[12] = "Y";
if (cdate.AddDays(-shp) <= DateTime.Now && cdate >= DateTime.Now)
{
dr[13] = "Y";
}
else
{
dr[13] = "N";
}
if (cdate < DateTime.Now)
{
dr[14] = "Y";
}
else
{
dr[14] = "N";
}
dr[15] = item["cde_dt_shp"];//允出天數
dr[16] = item["cde_dt_var"];
}
else if (item["pwy_dte_ctl"].ToString() == "N")
{
dr[12] = "N";
dr[13] = "";
dr[14] = "";
dr[15] = 0;//允出天數
dr[16] = 0;
}
else
{
dr[12] = "";
dr[13] = "";
dr[14] = "";
dr[15] = 0;//允出天數
dr[16] = 0;
}
dr[17] = " " + _IiupcMgr.Getupc(item["item_id"].ToString(), "1");
dr[18] = " " + _IiupcMgr.Getupc(item["item_id"].ToString(), "2");
dtCountBook.Rows.Add(dr);
bh++;
}
#endregion
}
else
{
#region iinvd沒有的料位信息從iplas表查出
DataRow dr = dtCountBook.NewRow();
m.loc_id = item2["loc_id"].ToString();
DataTable dt1 = iinvdMgr.GetIplasCountBook(m);
foreach (DataRow item1 in dt1.Rows)
{
dr[0] = bh;
dr[1] = item2["loc_id"];
dr[2] = item1["lsta_id"];
if (!string.IsNullOrEmpty(item1["item_id"].ToString()))
{
dr[3] = item1["item_id"];
}
if (!string.IsNullOrEmpty(item1["prod_qty"].ToString()))
{
dr[4] = item1["prod_qty"];
}
else
{
dr[4] = "0";
}
if (!string.IsNullOrEmpty(item1["product_id"].ToString()))
{
dr[5] = iinvdMgr.Getcost(item1["product_id"].ToString());
}
else
{
dr[5] = "0";
}
dr[6] = item1["product_name"];
dr[7] = GetProductSpec(item1["item_id"].ToString());
dr[8] = item1["prepaid"].ToString() == "0" ? "否" : "是";
dr[9] = "";
dr[10] = item1["cde_dt_incr"];
dr[11] = "";
if (item1["pwy_dte_ctl"].ToString() == "Y")//表示是有效期控管的商品
{
dr[12] = "Y";
dr[13] = "N";
dr[14] = "N";
dr[15] = item1["cde_dt_shp"];//允出天數
dr[16] = item1["cde_dt_var"];
}
else if (item1["pwy_dte_ctl"].ToString() == "N")
{
dr[12] = "N";
dr[13] = "";
dr[14] = "";
dr[15] = 0;//允出天數
dr[16] = 0;
}
else
{
dr[12] = "";
dr[13] = "";
dr[14] = "";
dr[15] = 0;//允出天數
dr[16] = 0;
}
dr[17] = " " + _IiupcMgr.Getupc(item1["item_id"].ToString(), "1");
dr[18] = " " + _IiupcMgr.Getupc(item1["item_id"].ToString(), "2");
dtCountBook.Rows.Add(dr);
bh++;
}
#endregion
}
loc = item2["loc_id"].ToString();
}
}
string fileName = "盤點簿" + cm.cbjob_id.Substring(2, 14) + ".xls";
String str = "盤點簿報表-" + cm.cbjob_id;
MemoryStream ms = ExcelHelperXhf.ExportDT(dtCountBook, str);
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.BinaryWrite(ms.ToArray());
}
else
{
Response.Clear();
this.Response.Write("沒有數據<br/>");
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
return this.Response;
}
public void ExportAseldMessage()
{
string json = string.Empty;
AseldQuery m = new AseldQuery();
if (!string.IsNullOrEmpty(Request.Params["job_id"]))
{//料位開始
m.assg_id = Request.Params["job_id"];
}
if (!string.IsNullOrEmpty(Request.Params["aseld_type"]))
{
m.commodity_type = Request.Params["aseld_type"];
}
if (!System.IO.Directory.Exists(Server.MapPath(excelPath)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(excelPath));
}
DataTable dtHZ = new DataTable();
string newExcelName = string.Empty;
dtHZ.Columns.Add("出貨單號", typeof(String));
dtHZ.Columns.Add("訂單編號", typeof(String));
dtHZ.Columns.Add("料位", typeof(String));
dtHZ.Columns.Add("數量", typeof(String));
dtHZ.Columns.Add("已撿", typeof(String));
dtHZ.Columns.Add("缺", typeof(String));
dtHZ.Columns.Add("品號", typeof(String));
dtHZ.Columns.Add("條碼", typeof(String));
dtHZ.Columns.Add("商品名稱", typeof(String));
dtHZ.Columns.Add("狀態", typeof(String));
dtHZ.Columns.Add("規格", typeof(String));
try
{
DataTable dt = new DataTable();
_iasdMgr = new AseldMgr(mySqlConnectionString);
_IiupcMgr = new IupcMgr(mySqlConnectionString);
dt = _iasdMgr.ExportAseldMessage(m);
foreach (DataRow item in dt.Rows)
{
DataRow dr = dtHZ.NewRow();
dr[0] = item["deliver_code"];
dr[1] = item["ord_id"];
//dr[1] = item["sel_loc"];
if (string.IsNullOrEmpty(item["loc_id"].ToString()))
{
switch (item["commodity_type"].ToString())
{
case "2": dr[2] = "YY999999"; break;
case "3": dr[2] = "ZZ999999"; break;
}
}
else
{
dr[2] = item["loc_id"];
}
dr[3] = item["out_qty"];
dr[4] = string.Empty;
dr[5] = string.Empty;
dr[6] = item["item_id"];
dr[7] = " " + _IiupcMgr.Getupc(item["item_id"].ToString(), "0");
dr[8] = item["product_name"];
dr[9] = item["wust_id"];
dr[10] = item["prod_sz"];
dtHZ.Rows.Add(dr);
}
string str = "撿貨報表by料位";
if (!string.IsNullOrEmpty(m.assg_id))
{
if (m.assg_id.IndexOf('N') == 0)
{
str = m.assg_id + "(常溫/";
}
else if (m.assg_id.IndexOf('N') != 0 && m.assg_id.IndexOf('F') == 0)
{
str = m.assg_id + "(冷凍/";
}
}
if (m.commodity_type == "2")
{
str = str + "寄倉)";
}
else if (m.commodity_type == "3")
{
str = str + "調度)";
}
string fileName = str + DateTime.Now.ToString("_yyyyMMddHHmmss") + ".xls";
MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, str + "_" + DateTime.Now.ToString("yyyyMMddHHmmss"));
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.BinaryWrite(ms.ToArray());
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,data:[]}";
}
}
public void NoIlocReportList()
{
string json = string.Empty;
string fileName = "無主料位商品報表_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
ProductQuery prod = new ProductQuery();
prod.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
prod.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
try
{
if (!string.IsNullOrEmpty(Request.Params["search"]))
{
prod.vendor_name_simple = Request.Params["search"];
}
DataTable dt = new DataTable();
_IiplasMgr = new IplasMgr(mySqlConnectionString);
_IiupcMgr = new IupcMgr(mySqlConnectionString);
dt = _IiplasMgr.NoIlocReportList(prod);
DataTable dtHZ = new DataTable();
string newExcelName = string.Empty;
dtHZ.Columns.Add("主料位", typeof(String));
dtHZ.Columns.Add("商品品號", typeof(String));
dtHZ.Columns.Add("品號", typeof(String));
dtHZ.Columns.Add("品名", typeof(String));
dtHZ.Columns.Add("規格", typeof(String));
dtHZ.Columns.Add("廠商", typeof(String));
dtHZ.Columns.Add("條碼", typeof(String));
dtHZ.Columns.Add("內箱長", typeof(String));
dtHZ.Columns.Add("內箱寬", typeof(String));
dtHZ.Columns.Add("內箱高", typeof(String));
//dtHZ.Columns.Add("商品分類", typeof(String));
// pe.inner_pack_len,pe.inner_pack_wid,pe.inner_pack_hgt
foreach (DataRow item in dt.Rows)
{
DataRow dr = dtHZ.NewRow();
dr[0] = item["loc_id"];
dr[1] = item["Product_Id"];
dr[2] = item["item_id"];
dr[3] = item["Product_Name"];
dr[4] = GetProductSpec(item["item_id"].ToString());
dr[5] = item["vendor_name_simple"];
if (string.IsNullOrEmpty(_IiupcMgr.Getupc(item["item_id"].ToString(), "0")))
{
dr[6] = "未維護";
}
else
{
dr[6] = " " + _IiupcMgr.Getupc(item["item_id"].ToString(), "0");
}
if (string.IsNullOrEmpty(item["inner_pack_len"].ToString()))
{
dr[7] = "未維護";
}
else
{
dr[7] = item["inner_pack_len"];
}
if (string.IsNullOrEmpty(item["inner_pack_wid"].ToString()))
{
dr[8] = "未維護";
}
else
{
dr[8] = item["inner_pack_wid"];
}
if (string.IsNullOrEmpty(item["inner_pack_hgt"].ToString()))
{
dr[9] = "未維護";
}
else
{
dr[9] = item["inner_pack_hgt"];
}
dtHZ.Rows.Add(dr);
}
MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, "無主料位商品報表(寄倉品)" + "_" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.BinaryWrite(ms.ToArray());
#region CSV
//string[] colname = new string[dtHZ.Columns.Count];
//string filename = "NoIplas.csv";
//newExcelName = Server.MapPath(excelPath) + filename;
//for (int i = 0; i < dtHZ.Columns.Count; i++)
//{
// colname[i] = dtHZ.Columns[i].ColumnName;
//}
//if (System.IO.File.Exists(newExcelName))
//{
// System.IO.File.Delete(newExcelName);
//}
//CsvHelper.ExportDataTableToCsv(dtHZ, newExcelName, colname, true);
//IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
#endregion
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,data:[]}";
}
}
public void ExportKucunLockList()
{
string json = string.Empty;
IinvdQuery m = new IinvdQuery();
if (!string.IsNullOrEmpty(Request.Params["startIloc"]))
{//料位開始
m.startIloc = Request.Params["startIloc"].ToUpper();
}
if (!string.IsNullOrEmpty(Request.Params["endIloc"]))
{
m.endIloc = Request.Params["endIloc"] + "Z";
m.endIloc = m.endIloc.ToUpper();
}
_iinvd = new IinvdMgr(mySqlConnectionString);
if (!String.IsNullOrEmpty(Request.Params["item_id"]))//料位和條碼不再通過長度來判斷了
{
////if (Request.Params["item_id"].ToString().Length >= 8)
////{
DataTable dt = new DataTable();
dt = _iinvd.Getprodubybar(Request.Params["item_id"].ToString());
if (dt.Rows.Count > 0)
{
m.item_id = Convert.ToUInt32(dt.Rows[0]["item_id"].ToString());
}
////}
else
{
int itemid = 0;
}
//m.upc_id
}
if (!System.IO.Directory.Exists(Server.MapPath(excelPath)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(excelPath));
}
DataTable dtHZ = new DataTable();
string newExcelName = string.Empty;
dtHZ.Columns.Add("料位", typeof(String));
dtHZ.Columns.Add("數量", typeof(String));
dtHZ.Columns.Add("商品細項編號", typeof(String));
dtHZ.Columns.Add("品名", typeof(String));
dtHZ.Columns.Add("規格", typeof(String));
dtHZ.Columns.Add("有效期/FIFO", typeof(String));
dtHZ.Columns.Add("是否買斷", typeof(String));
dtHZ.Columns.Add("條碼", typeof(String));
dtHZ.Columns.Add("庫鎖原因", typeof(String));
dtHZ.Columns.Add("庫鎖備註", typeof(String));
try
{
List<IinvdQuery> store = new List<IinvdQuery>();
_iinvd = new IinvdMgr(mySqlConnectionString);
_IiupcMgr = new IupcMgr(mySqlConnectionString);
store = _iinvd.KucunExport(m);
foreach (var item in store)
{
DataRow dr = dtHZ.NewRow();
dr[0] = item.plas_loc_id;
dr[1] = item.prod_qty;
dr[2] = item.item_id;
dr[3] = item.product_name;
dr[4] = GetProductSpec(item.item_id.ToString());
dr[5] = item.cde_dt.ToString("yyyy-MM-dd");
dr[6] = item.prepaid == 0 ? "否" : "是";
dr[7] = " " + _IiupcMgr.Getupc(item.item_id.ToString(), "0");
dr[8] = item.parameterName;
m.item_id = uint.Parse(item.item_id.ToString());
m.plas_loc_id = item.plas_loc_id.ToString();
m.made_date = item.made_date;
if (item.ista_id.ToString() == "H")
{
dr[9] = _iinvd.remark(m);
}
else
{
dr[9] = "";
}
dtHZ.Rows.Add(dr);
}
string fileName = DateTime.Now.ToString("庫存鎖住管理報表_yyyyMMddHHmmss") + ".xls";
MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, "庫存鎖住管理報表_" + DateTime.Now.ToString("yyyyMMddHHmmss"));
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.BinaryWrite(ms.ToArray());
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,data:[]}";
}
}
public void PastProductExportlist()
{
string json = string.Empty;
string fileName = "";
string fileNametwo = "";
IinvdQuery invd = new IinvdQuery();
try
{
_iinvd = new IinvdMgr(mySqlConnectionString);
_IiupcMgr = new IupcMgr(mySqlConnectionString);
invd.notimeortimeout = Convert.ToInt32(Request.Params["time_type"]);
if (!string.IsNullOrEmpty(Request.Params["startIloc"]))//model中默認為F
{
invd.startIloc = Request.Params["startIloc"].ToUpper();
}
else
{
invd.startIloc = string.Empty;
}
if (!string.IsNullOrEmpty(Request.Params["endIloc"]))
{
invd.endIloc = Request.Params["endIloc"] + "Z";
invd.endIloc = invd.endIloc.ToUpper();
}
else
{
invd.endIloc = string.Empty;
}
if (!string.IsNullOrEmpty(Request.Params["startDay"]))
{
invd.startDay = Convert.ToInt32(Request.Params["startDay"]);
}
else
{
invd.startDay = 0;
}
if (!string.IsNullOrEmpty(Request.Params["endDay"]))
{
invd.endDay = Convert.ToInt32(Request.Params["endDay"]);
}
else
{
invd.endDay = 0;
}
int yugao = 0;
if (int.TryParse(Request.Params["yugaoDay"], out yugao))
{
invd.yugaoDay = yugao;
}
else
{
invd.yugaoDay = 0;
}
if (!System.IO.Directory.Exists(Server.MapPath(excelPath)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(excelPath));
}
DataTable dtHZ = new DataTable();
string newExcelName = string.Empty;
dtHZ.Columns.Add("即過", typeof(String));
dtHZ.Columns.Add("料位", typeof(String));
dtHZ.Columns.Add("屬性", typeof(String));
dtHZ.Columns.Add("品號", typeof(String));
dtHZ.Columns.Add("數量", typeof(String));
dtHZ.Columns.Add("品名", typeof(String));
dtHZ.Columns.Add("規格", typeof(String));
dtHZ.Columns.Add("條碼", typeof(String));
dtHZ.Columns.Add("允出天數", typeof(String));
dtHZ.Columns.Add("有效日期", typeof(String));
dtHZ.Columns.Add("是否買斷", typeof(String));
dtHZ.Columns.Add("溫層", typeof(String));
dtHZ.Columns.Add("即期日期", typeof(String));
dtHZ.Columns.Add("庫存鎖", typeof(String));
DataTable dt = new DataTable();
dt = _iinvd.PastProductExportExcel(invd);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dtHZ.NewRow();
if (invd.notimeortimeout == 2)//(Convert.ToDateTime(dt.Rows[i]["cde_dt"]) <= DateTime.Now.AddDays(invd.yugaoDay))//過期有效期<=今天
{
dr[0] = "過期";
fileName = "過期品";
fileNametwo = "過期品";
}
else if (invd.notimeortimeout == 1)//(Convert.ToDateTime(dt.Rows[i]["cde_dt"]) <= DateTime.Now.AddDays(int.Parse(dt.Rows[i]["cde_dt_shp"].ToString() + invd.yugaoDay)))
{
dr[0] = "即期";
fileName = "即期品";
fileNametwo = "即期品";
}
else
{
dr[0] = "錯誤";
}
dr[1] = dt.Rows[i]["plas_loc_id"];
dr[2] = dt.Rows[i]["lcat_id"];
dr[3] = dt.Rows[i]["item_id"];
dr[4] = dt.Rows[i]["prod_qty"];
dr[5] = dt.Rows[i]["product_name"];
dr[6] = GetProductSpec(dt.Rows[i]["item_id"].ToString());
dr[7] = " " + _IiupcMgr.Getupc(dt.Rows[i]["item_id"].ToString(), "0");
dr[8] = dt.Rows[i]["cde_dt_shp"];
dr[9] = Convert.ToDateTime(dt.Rows[i]["cde_dt"]).ToString("yyyy-MM-dd");
dr[10] = dt.Rows[i]["prepaid"].ToString() == "1" ? "是" : "否";
if (dt.Rows[i]["product_freight_set"].ToString() == "1")
{
dr[11] = "常溫";
}
else if (dt.Rows[i]["product_freight_set"].ToString() == "2")
{
dr[11] = "冷凍";
}
else
{
dr[11] = "";
}
dr[12] = DateTime.Parse(dt.Rows[i]["cde_dt"].ToString()).AddDays(-int.Parse(dt.Rows[i]["cde_dt_shp"].ToString())).ToString("yyyy-MM-dd");
dr[13] = dt.Rows[i]["ista_id"];
dtHZ.Rows.Add(dr);
}
if (System.IO.File.Exists(newExcelName))
{
System.IO.File.Delete(newExcelName);
}
fileName += "預告報表預告天數:" + invd.yugaoDay + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
fileNametwo += " 預告報表 預告天數:" + invd.yugaoDay + " _" + DateTime.Now.ToString("yyyyMMddHHmm");
MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, fileNametwo);
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.BinaryWrite(ms.ToArray());
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,data:[]}";
}
}
