public HttpResponseBase ShowArrByUserList()
{
string json = string.Empty;
int totalcount = 0;
ArrivalNoticeQuery query = new ArrivalNoticeQuery();
//Ris.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
//Ris.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
query.item_id = Convert.ToUInt32( Request.Params["item_id"]);
arrivalnoticemgr = new ArrivalNoticeMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["item_id"]))
{
string item_id = Request.Params["item_id"];
}
if (!string.IsNullOrEmpty(Request.Params["startTime"]))
{
query.start_time = Convert.ToDateTime(Request.Params["startTime"]).ToString("yyyy-MM-dd 00:00:00");
}
if (!string.IsNullOrEmpty(Request.Params["endTime"]))
{
query.end_time = Convert.ToDateTime(Request.Params["endTime"]).ToString("yyyy-MM-dd 23:59:59");
}
List<ArrivalNoticeQuery> List = arrivalnoticemgr.ShowArrByUserList(query, out totalcount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
timeConverter.DateTimeFormat = "yyyy-MM-dd";
json = "{success:true,totalCount:" + totalcount + ",data:" + JsonConvert.SerializeObject(List, Formatting.Indented,timeConverter) + "}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return Response;
}
public void ExportCSV()
{
ArrivalNoticeQuery query = new ArrivalNoticeQuery();
try
{
if (!string.IsNullOrEmpty(Request.Params["vendor_name_full_OR_vendor_id"]))
{
query.vendor_name_full_OR_vendor_id = Request.Params["vendor_name_full_OR_vendor_id"];//供應商名稱/供應商編號
}
if (!string.IsNullOrEmpty(Request.Params["product_id_OR_product_name"]))//商品編號或商品名稱
{
query.product_id_OR_product_name = Request.Params["product_id_OR_product_name"];
}
if (!string.IsNullOrEmpty(Request.Params["start_time"]))//開始時間
{
query.start_time = 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(Request.Params["end_time"]).ToString("yyyy-MM-dd 23:59:59");
}
DataTable dtHZ = new DataTable();
int totalcount = 0;
query.IsPage = false;
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));
List<ArrivalNoticeQuery> list = new List<ArrivalNoticeQuery>();
arrivalnoticemgr = new ArrivalNoticeMgr(mySqlConnectionString);
list = arrivalnoticemgr.GetArrNoticeList(query, out totalcount);
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
DataRow dr = dtHZ.NewRow();
dr[0] = list[i].product_id;
dr[1] = list[i].product_name;
dr[2] = list[i].item_id;
dr[3] = list[i].product_spec;
dr[4] = list[i].vendor_id;
dr[5] = list[i].vendor_name_full;
dr[6] = list[i].ri_nums;
dtHZ.Rows.Add(dr);
}
string fileName = "補貨通知統計匯出_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, "");
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);
}
}
public HttpResponseBase GetArrNoticeList()// createTime 2015/8/25 by yachao1120j
{
string json = string.Empty;
int totalcount = 0;
ArrivalNoticeQuery query = new ArrivalNoticeQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
arrivalnoticemgr = new ArrivalNoticeMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["vendor_name_full_OR_vendor_id"]))
{
query.vendor_name_full_OR_vendor_id = Request.Params["vendor_name_full_OR_vendor_id"];//供應商名稱/供應商編號
}
// 要修改商品編號 改為 商品編號/名稱
//if (!string.IsNullOrEmpty(Request.Params["product_id"]))//商品編號
//{
// query.product_id = Convert.ToUInt32(Request.Params["product_id"]);
//}
if (!string.IsNullOrEmpty(Request.Params["product_id_OR_product_name"]))
{
query.product_id_OR_product_name = Request.Params["product_id_OR_product_name"];//商品编号/名称
}
if (!string.IsNullOrEmpty(Request.Params["start_time"]))//開始時間
{
query.start_time = 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(Request.Params["end_time"]).ToString("yyyy-MM-dd 23:59:59");
}
List<ArrivalNoticeQuery> list = arrivalnoticemgr.GetArrNoticeList(query, out totalcount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
timeConverter.DateTimeFormat = "yyyy-MM-dd";
json = "{success:true,totalCount:" + totalcount + ",data:" + JsonConvert.SerializeObject(list, Formatting.Indented, timeConverter) + "}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return Response;
}