public HttpResponseBase Getnewticketslist()
{
string jsonStr = String.Empty;
StringBuilder sb = new StringBuilder();
List<TicketQuery> store = new List<TicketQuery>();
TicketQuery tqQuery = new TicketQuery();
try
{
tqQuery.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
tqQuery.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量
_tkMgr = new TicketMgr(mySqlConnectionString);
int totalCount = 0;
string condition = string.Empty;
int deliver_type = Convert.ToInt32(Request.Params["deliver_type"]);//批次出貨類別
int vendorcondition = 0;
if (!string.IsNullOrEmpty(Request.Params["vendorcondition"]))
{
vendorcondition = int.Parse(Request.Params["vendorcondition"]);//出貨廠商
}
int shipment = 0;
if (!string.IsNullOrEmpty(Request.Params["shipment"]))
{
shipment = int.Parse(Request.Params["shipment"]);//物流商
}
int gongyinshang = 0;
if (!string.IsNullOrEmpty(Request.Params["gongyinshang"]))
{
gongyinshang = int.Parse(Request.Params["gongyinshang"]);
}
int scheduling = int.Parse(Request.Params["scheduling"]);//調度狀態
int screen = int.Parse(Request.Params["screen"]);//批次出貨狀態
int lytype = int.Parse(Request.Params["lytype"]);//列印處理狀態
int ystype = int.Parse(Request.Params["ystype"]);//運送方式
string search = Request.Params["search"].Trim();//搜索內容
if (deliver_type == 1) //批次出貨類別
{
condition = condition + " and Ticket.type = 1 ";
}
else
{
condition = condition + " and Ticket.type = 2 ";
}
#region 出貨廠商
if (vendorcondition == 0)//出貨廠商 所有 對
{
condition = condition + "";
}
else
{
condition = condition + " and Export.vendor_id=" + vendorcondition;
}
#endregion
#region 物流商或者是供應商
if (shipment == 0)//物流商
{
condition = condition + "";
}
else
{
condition = condition + " and Ticket.delivery_store=" + shipment;
}
if (gongyinshang == 0)//物流商
{
condition = condition + "";
}
else
{
condition = condition + " and Ticket.delivery_store=" + shipment;
}
#endregion
if (scheduling == 0)//調度狀態
{
condition = condition + " and warehouse_status=0 ";
}
else if (scheduling == 1)
{
condition = condition + " and warehouse_status=1 ";
}
if (screen == -1)//批次出貨狀態
{
condition = condition + "";
}
else if (screen == 0)
{
condition = condition + " and ticket_status=0 ";
}
else if (screen == 1)
{
condition = condition + " and ticket_status=1 ";
}
if (lytype == 0)//列印處理狀態 現在php後台好像沒有作用
{
condition = condition + " ";
}
else
{
condition = condition + " ";
}
if (ystype == 1)//運送方式
{
condition = condition + " and freight_set=1 ";
}
else if (ystype == 2)
{
condition = condition + " and freight_set=2 ";
}
else if (ystype == 5)
{
condition = condition + " and freight_set=5 ";
}
if (!string.IsNullOrEmpty(search))//搜索條件
{
condition = condition + string.Format(" AND ((Ticket.ticket_id like '%{0}%') OR (Export.vendor_name_simple like '%{0}%'))", search);
}
store = _tkMgr.GetTicketList(tqQuery, out totalCount, condition);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd";
jsonStr = "{success:true,totalCount:" + totalCount + ",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);
jsonStr = "{success:false,msg:0}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
