//根據工作代號、細項編號 獲取商品數據
/// <summary>
/// 自動理貨 根據工作代號/細項編號/訂單號/出貨單號獲取所有商品信息
/// </summary>
/// <returns></returns>
public HttpResponseBase GetAllAseldList()
{//判斷寄倉或者調度
string json = String.Empty;
AseldQuery m = new AseldQuery();
List<AseldQuery> list = new List<AseldQuery>();
_iasdMgr = new AseldMgr(mySqlConnectionString);
int totalCount = 0;
try
{
string search_type = Request.Params["search_type"].ToString().Trim();
if (!string.IsNullOrEmpty(Request.Params["search_con"].ToString().Trim()))
{
if (search_type == "assg_id")
{
m.assg_id = Request.Params["search_con"].ToString().Trim();
}
else if (search_type == "item_id")
{
m.item_id = Convert.ToUInt32(Request.Params["search_con"].ToString().Trim());
}
else if (search_type == "ord_id")
{
m.ord_id = Convert.ToInt32(Request.Params["search_con"].ToString().Trim());
}
else if (search_type == "deliver_code")
{
m.deliver_code = Request.Params["search_con"].ToString().Trim();
}
else
{
}
}
if (!string.IsNullOrEmpty(Request.Params["start_time"]))
{
m.start_time = Convert.ToDateTime(Convert.ToDateTime(Request.Params["start_time"]).ToString("yyyy-MM-dd 00:00:00"));
}
if (!string.IsNullOrEmpty(Request.Params["end_time"]))
{
m.end_time = Convert.ToDateTime(Convert.ToDateTime(Request.Params["end_time"]).ToString("yyyy-MM-dd 23:59:59"));
}
list = _iasdMgr.GetAllAseldList(m, out totalCount);
foreach (var item in list)
{
m.seld_id = item.seld_id;
}
m.wust_id = "BSY";
m.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
_iasdMgr.Updwust(m);
json = "{success:true,totalCount:"+ totalCount +",data:" + JsonConvert.SerializeObject(list, Formatting.Indented) + "}";//返回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,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json.ToString());
this.Response.End();
return this.Response;
}