//採購收穫上架記錄
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 HttpResponseBase CreateTallyList()
{
string json = String.Empty;
json = "{success:false}";
IpoNvdQuery query = new IpoNvdQuery();
string id=string.Empty;
try
{
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
id = Request.Params["id"].ToString();
id = id.Substring(0, id.Length - 1).ToString();
query.modify_user = (Session["caller"] as Caller).user_id;
}
query.work_id = "IN" + DateTime.Now.ToString("yyyyMMddHHmmss");
if(!string.IsNullOrEmpty(id))
{
_IpoNvdMgr = new IpoNvdMgr(mySqlConnectionString);
int result = _IpoNvdMgr.CreateTallyList( query, id);
if (result > 0)
{
json = "{success:true,work_id:\""+query.work_id+"\"}";
}
}
}
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}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 收貨上架提交
/// </summary>
/// <returns></returns>
public HttpResponseBase SaveReceiptShelves()
{
string json = String.Empty;
json = "{success:false}";
IpoNvdQuery query = new IpoNvdQuery();
try
{
query.row_id = Convert.ToInt32(Request.Params["row_id"]);
query.modify_user = (Session["caller"] as Caller).user_id;
query.made_date = Convert.ToDateTime(Request.Params["made_date"]);
query.cde_dt = Convert.ToDateTime(Request.Params["cde_dt"]);
query.loc_id = Request.Params["loc_id"].ToString();
int pick_num = Convert.ToInt32(Request.Params["pick_num"]);
if (query.row_id != 0)
{
_IpoNvdMgr = new IpoNvdMgr(mySqlConnectionString);
bool result = _IpoNvdMgr.SaveReceiptShelves(query,pick_num);
if (result)
{
json = "{success:true}";
}
}
}
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}";
}
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:[]}";
}
}