//採購收穫上架記錄 public HttpResponseBase GetIpoNvdList()// { string json = string.Empty; IpoNvdQuery query = new IpoNvdQuery(); int totalCount = 0; try { query.work_status = "AVL"; if (!string.IsNullOrEmpty(Request.Params["work_id"])) { query.work_id = Request.Params["work_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["item_id"])) { query.item_id =Convert.ToUInt32(Request.Params["item_id"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["locid_allownull"])) { query.locid_allownull = Convert.ToBoolean(Request.Params["locid_allownull"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["search_type"])) { if (Request.Params["search_type"].ToString() == "ipo_id") { query.ipo_id = Request.Params["search_con"].ToString().Trim(); } else if (Request.Params["search_type"].ToString() == "item_id") { query.item_id = Convert.ToUInt32(Request.Params["search_con"]); } else if (Request.Params["search_type"].ToString() == "work_id") { query.work_id = Request.Params["search_con"].ToString().Trim(); } } if (!string.IsNullOrEmpty(Request.Params["work_status"])) { query.work_status = Request.Params["work_status"]; } if (!string.IsNullOrEmpty(Request.Params["start_time"])) { query.start_time = Convert.ToDateTime(Convert.ToDateTime(Request.Params["start_time"]).ToString("yyyy-MM-dd 00:00:00")); } if (!string.IsNullOrEmpty(Request.Params["end_time"])) { query.end_time = Convert.ToDateTime(Convert.ToDateTime(Request.Params["end_time"]).ToString("yyyy-MM-dd 23:59:59")); } List<SchedulePeriodQuery> ipodStore = new List<SchedulePeriodQuery>(); _IpoNvdMgr = new IpoNvdMgr(mySqlConnectionString); List<IpoNvdQuery> store = _IpoNvdMgr.GetIpoNvdList(query, out totalCount); int msg = 0; if (totalCount == 0) { query.work_status = string.Empty; _IpoNvdMgr.GetIpoNvdList(query, out msg); } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 //timeConverter.DateTimeFormat = "yyyy-MM-dd"; timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",msg:" + msg + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } 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:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
//採購收穫上架記錄匯出 public void ExportIpoNvdList() { string json = string.Empty; IpoNvdQuery query = new IpoNvdQuery(); int totalCount = 0; try { query.work_status = "AVL"; if (!string.IsNullOrEmpty(Request.Params["work_id"])) { query.work_id = Request.Params["work_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["item_id"])) { query.item_id = Convert.ToUInt32(Request.Params["item_id"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["locid_allownull"])) { query.locid_allownull = Convert.ToBoolean(Request.Params["locid_allownull"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["search_type"])) { if (Request.Params["search_type"].ToString() == "ipo_id") { query.ipo_id = Request.Params["search_con"].ToString().Trim(); } else if (Request.Params["search_type"].ToString() == "item_id") { query.item_id = Convert.ToUInt32(Request.Params["search_con"]); } else if (Request.Params["search_type"].ToString() == "work_id") { query.work_id = Request.Params["search_con"].ToString().Trim(); } } if (!string.IsNullOrEmpty(Request.Params["work_status"])) { query.work_status = Request.Params["work_status"]; } if (!string.IsNullOrEmpty(Request.Params["start_time"])) { query.start_time = Convert.ToDateTime(Convert.ToDateTime(Request.Params["start_time"]).ToString("yyyy-MM-dd 00:00:00")); } if (!string.IsNullOrEmpty(Request.Params["end_time"])) { query.end_time = Convert.ToDateTime(Convert.ToDateTime(Request.Params["end_time"]).ToString("yyyy-MM-dd 23:59:59")); } List<SchedulePeriodQuery> ipodStore = new List<SchedulePeriodQuery>(); _IpoNvdMgr = new IpoNvdMgr(mySqlConnectionString); List<IpoNvdQuery> store = _IpoNvdMgr.GetIpoNvdList(query, out totalCount); //匯出excel ////// DataTable dtExcel = new DataTable(); dtExcel.Columns.Add("工作單號", typeof(String)); dtExcel.Columns.Add("採購單編號", typeof(String)); dtExcel.Columns.Add("商品細項編號", typeof(String)); dtExcel.Columns.Add("採購單驗收數量", typeof(String)); dtExcel.Columns.Add("未收貨上架數量", typeof(String)); dtExcel.Columns.Add("完成收穫上架數量", typeof(String)); dtExcel.Columns.Add("有效日期", typeof(String)); dtExcel.Columns.Add("製造日期", typeof(String)); dtExcel.Columns.Add("收穫上架狀態", typeof(String)); dtExcel.Columns.Add("創建人", typeof(String)); dtExcel.Columns.Add("創建時間", typeof(String)); dtExcel.Columns.Add("修改人", typeof(String)); dtExcel.Columns.Add("修改時間", typeof(String)); for (int i = 0; i < store.Count; i++) { DataRow newRow = dtExcel.NewRow(); newRow[0] = store[i].work_id.ToString(); newRow[1] = store[i].ipo_id.ToString()+" "; newRow[2] = store[i].item_id.ToString(); newRow[3] = store[i].ipo_qty.ToString(); newRow[4] = store[i].out_qty.ToString(); newRow[5] = store[i].com_qty.ToString(); newRow[6] = store[i].cde_dt.ToString("yyyy-MM-dd"); newRow[7] = store[i].made_date.ToString("yyyy-MM-dd"); newRow[8] = store[i].work_status.ToString(); if (store[i].work_status.ToString() == "AVL") { newRow[8] = "未處理"; } else if (store[i].work_status.ToString() == "SKP") { newRow[8] = "已處理但未完成"; } else if (store[i].work_status.ToString() == "COM") { newRow[8] = "已完成"; } newRow[9] = store[i].create_username.ToString(); newRow[10] = store[i].create_datetime.ToString("yyyy-MM-dd HH:mm:ss"); newRow[11] = store[i].modify_username.ToString(); newRow[12] = store[i].modify_datetime.ToString("yyyy-MM-dd HH:mm:ss"); dtExcel.Rows.Add(newRow); } if (dtExcel.Rows.Count > 0) { string fileName = "收貨上架_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; System.IO.MemoryStream ms = gigadeExcel.Comment.ExcelHelperXhf.ExportDT(dtExcel, fileName); Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); Response.BinaryWrite(ms.ToArray()); } else { Response.Write("匯出數據不存在"); } } 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:[]}"; } }