public List<PromotionBannerQuery> GetPromotionBannerList(PromotionBannerQuery query, out int totalCount)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@" ");
if (query.brand_name != string.Empty)
{
VendorBrandQuery vb_query = new VendorBrandQuery();
vb_query.Brand_Name = query.brand_name;
string sql_getID = _vendorBrandDao.GetBrand_idByBrand_name(vb_query);
DataTable dt = _accessMySql.getDataTable(sql_getID);
string id = string.Empty;
if (dt.Rows.Count > 0 && dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
id += dt.Rows[i][0].ToString() + ",";
}
id = id.Substring(0, id.LastIndexOf(','));
strSql.AppendFormat(" AND pbr.brand_id in({0})", id);
}
else
{
strSql.AppendFormat(" AND pbr.brand_id in({0})", -1);
}
}
return _promotionBannerDao.GetPromotionBannerList(query, strSql.ToString(), out totalCount);
}
catch (Exception ex)
{
throw new Exception("PromotionBannerMgr-->GetPromotionBannerList-->" + ex.Message, ex);
}
}
/// <summary>
/// 品牌營業額統計匯出
/// </summary>
/// <returns></returns>
public void GetNewOrderRevenueExprot()
{
string json = string.Empty;
try
{
OrderDetailQuery query = new OrderDetailQuery();
#region 前置查詢條件
if (!string.IsNullOrEmpty(Request.Params["Brand_Id"]))/*品牌編號*/
{
query.Brand_Id_In = Request.Params["Brand_Id"];
}
if (!string.IsNullOrEmpty(Request.Params["product_manage"]) && Request.Params["product_manage"] != "null")//管理人員
{//獲取管理人
query.product_manage = int.Parse(Request.Params["product_manage"]);
}
if (!string.IsNullOrEmpty(Request.Params["dateOne"]))
{
query.time_start = CommonFunction.GetPHPTime(DateTime.Parse(Request.Params["dateOne"]).ToString("yyyy/MM/dd 00:00:00"));
}
if (!string.IsNullOrEmpty(Request.Params["dateTwo"]))
{
query.time_end = CommonFunction.GetPHPTime(DateTime.Parse(Request.Params["dateTwo"]).ToString("yyyy/MM/dd 23:59:59"));
}
long start = query.time_start;//開始時間
long end = query.time_end;//結束時間
if (!string.IsNullOrEmpty(Request.Params["Channel_Id"]) && Request.Params["Channel_Id"] != "null")//賣場
{
query.channel = int.Parse(Request.Params["Channel_Id"]);
}
if (!string.IsNullOrEmpty(Request.Params["slave_status"]) && Request.Params["slave_status"]!="null")//訂單狀態
{
query.Status = int.Parse(Request.Params["slave_status"]);
}
if (!string.IsNullOrEmpty(Request.Params["order_payment"]) && Request.Params["order_payment"] != "null")//付款方式
{
query.order_payment = int.Parse(Request.Params["order_payment"]);
}
if (!string.IsNullOrEmpty(Request.Params["selecttype"]))//關鍵字查詢類型
{
query.select_type = int.Parse(Request.Params["selecttype"]);
if (!string.IsNullOrEmpty(Request.Params["searchcon"]))//關鍵字查詢內容
{
query.select_con = Request.Params["searchcon"];
}
}
#endregion
VendorBrandQuery Vendorbrandquery = new VendorBrandQuery();
Dictionary<uint, VendorBrandQuery> brands = new Dictionary<uint, VendorBrandQuery>();///字典----儲存供應商編號，供應商名稱和錧別，錧別編號的信息
Dictionary<uint, Dictionary<string, Dictionary<string, uint>>> brandDailyTotal = new Dictionary<uint, Dictionary<string, Dictionary<string, uint>>>();///字典，儲存錧別，每天的計算和每天的購物金
///////////////brand_id//////////daysum,dayduct/////日期///值
List<VendorBrandQuery> aDB_Brand_Select = new List<VendorBrandQuery>();
_vbrand = new VendorBrandMgr(mySqlConnectionString);
aDB_Brand_Select = _vbrand.GetBandList(Vendorbrandquery);//把錧別和供應商信息保存到字典里
for (int i = 0; i < aDB_Brand_Select.Count; i++)
{
if (!brands.Keys.Contains(aDB_Brand_Select[i].Brand_Id))
{
brands.Add(aDB_Brand_Select[i].Brand_Id, aDB_Brand_Select[i]);
}
}
bool CrossMonth = CommonFunction.GetNetTime(start).Month == CommonFunction.GetNetTime(end).Month ? false : true;
string timelong = "";
while (start <= end)//時間格式化，用來保存每天的小計
{
timelong += CommonFunction.GetNetTime(start).ToString("yyyy/MM/dd") + ",";
start += 86400;
}
timelong = timelong.Substring(0, timelong.LastIndexOf(","));
string[] times = timelong.Split(',');
Dictionary<string, uint> timetro = new Dictionary<string, uint>();
for (int i = 0; i < times.Count(); i++)//字典加上日期時間
{
timetro.Add(times[i], 0);
}
Dictionary<string, Dictionary<string, uint>> daysum_deduct = new Dictionary<string, Dictionary<string, uint>>();//保存每個商品每日的小計和購物金
daysum_deduct.Add("daysum", timetro);//每日小計
daysum_deduct.Add("daydeduct", timetro);//每日小計
_orderDetailMgr = new OrderDetailMgr(mySqlConnectionString);
List<OrderDetailQuery> ordertailList = new List<OrderDetailQuery>();
DataTable _dt = new DataTable();
ordertailList = _orderDetailMgr.GetOrderDetailList(query);//通過查詢條件獲取的數據
string[] quanxuan = query.Brand_Id_In.Split(',');
foreach (uint item in brands.Keys)
{
if (!brandDailyTotal.Keys.Contains(item))
{
daysum_deduct = new Dictionary<string, Dictionary<string, uint>>();
timetro = new Dictionary<string, uint>();
for (int a = 0; a < times.Count(); a++)//字典加上日期時間
{
timetro.Add(times[a], 0);
}
daysum_deduct.Add("daysum", timetro);//每日小計
timetro = new Dictionary<string, uint>();
for (int a = 0; a < times.Count(); a++)//字典加上日期時間
{
timetro.Add(times[a], 0);
}
daysum_deduct.Add("daydeduct", timetro);//購物金
brandDailyTotal.Add(item, daysum_deduct);
}
}
//if (ordertailList.Count > 0)
//{
for (int i = 0; i < ordertailList.Count; i++)
{
ordertailList[i].subtotal = ordertailList[i].Single_Money * ordertailList[i].Buy_Num;
ordertailList[i].cost = (ordertailList[i].Event_Cost != 0 && ordertailList[i].Single_Cost != ordertailList[i].Single_Money) ? ordertailList[i].Event_Cost : ordertailList[i].Single_Cost;
if (!brands.Keys.Contains(ordertailList[i].Brand_Id))
{
VendorBrandQuery brand = new VendorBrandQuery();
brand.Vendor_Id = ordertailList[i].Vendor_Id;
brand.Brand_Name = ordertailList[i].Brand_Name;
brand.Brand_Id = ordertailList[i].Brand_Id;
brand.vendor_name_simple = ordertailList[i].Vendor_Name_Simple;
brands.Add(ordertailList[i].Brand_Id, brand);
}
if (!brandDailyTotal.Keys.Contains(ordertailList[i].Brand_Id))
{
daysum_deduct = new Dictionary<string, Dictionary<string, uint>>();
timetro = new Dictionary<string, uint>();
for (int a = 0; a < times.Count(); a++)//字典加上日期時間
{
timetro.Add(times[a], 0);
}
daysum_deduct.Add("daysum", timetro);//每日小計
timetro = new Dictionary<string, uint>();
for (int a = 0; a < times.Count(); a++)//字典加上日期時間
{
timetro.Add(times[a], 0);
}
daysum_deduct.Add("daydeduct", timetro);//購物金
brandDailyTotal.Add(ordertailList[i].Brand_Id, daysum_deduct);
}
string time = CommonFunction.GetNetTime(ordertailList[i].Order_Createdate).ToString("yyyy/MM/dd");
brandDailyTotal[ordertailList[i].Brand_Id]["daysum"][time] += ordertailList[i].subtotal;//每個商品的小計
brandDailyTotal[ordertailList[i].Brand_Id]["daydeduct"][time] += ordertailList[i].Deduct_Bonus;//每個商品的購物金小計
}
Dictionary<string, uint> daysum_allbrand = new Dictionary<string, uint>();//所有品牌的每日小計
Dictionary<string, uint> deductsum_allbrand = new Dictionary<string, uint>();//所有品牌的每日購物金
foreach (uint key in brandDailyTotal.Keys)
{
foreach (string time in brandDailyTotal[key]["daysum"].Keys)//循環每個品牌的每日小計，計算到所有品牌的每日小計
{
if (!daysum_allbrand.Keys.Contains(time))
{
daysum_allbrand.Add(time, brandDailyTotal[key]["daysum"][time]);
}
else
{
daysum_allbrand[time] += brandDailyTotal[key]["daysum"][time];
}
}
foreach (string time in brandDailyTotal[key]["daydeduct"].Keys)//循環每個品牌的每日購物金小計，計算到所有品牌的每日小計
{
if (!deductsum_allbrand.Keys.Contains(time))
{
deductsum_allbrand.Add(time, brandDailyTotal[key]["daydeduct"][time]);
}
else
{
deductsum_allbrand[time] += brandDailyTotal[key]["daydeduct"][time];
}
}
}
//
_dt.Columns.Add("品牌名稱", typeof(String));
_dt.Columns.Add("供應商名稱", typeof(String));
string ym_last = "";
foreach (string it in timetro.Keys)
{
string ym = it.Substring(0, 7);
if (string.IsNullOrEmpty(ym_last))
ym_last = ym;
if (!ym_last.Equals(ym))
{
_dt.Columns.Add(ym_last.Split('/')[1] + "月小計", typeof(String));
_dt.Columns.Add("購物金(" + ym_last.Split('/')[0] + "/" + ym_last.Split('/')[1] + "月)", typeof(String));
_dt.Columns.Add("扣除購物金(" + ym_last.Split('/')[0] + "/" + ym_last.Split('/')[1] + "月)", typeof(String));
ym_last = ym;
}
_dt.Columns.Add(it, typeof(String));
_dt.Columns.Add("購物金(" + it + ")", typeof(String));
_dt.Columns.Add("扣除購物金(" + it + ")", typeof(String));
}
if (CrossMonth)
{
_dt.Columns.Add(ym_last.Split('/')[1] + "月小計", typeof(String));
_dt.Columns.Add("購物金(" + ym_last.Split('/')[0] + "/" + ym_last.Split('/')[1] + "月)", typeof(String));
_dt.Columns.Add("扣除購物金(" + ym_last.Split('/')[0] + "/" + ym_last.Split('/')[1] + "月)", typeof(String));
}
_dt.Columns.Add("品牌總計", typeof(String));
_dt.Columns.Add(" 購物金總計", typeof(String));
_dt.Columns.Add(" 扣除購物金總計", typeof(String));
DataRow addrow = _dt.NewRow();//添加一行
addrow[0] = " ";
addrow[1] = "每日小計";
int r = 2;
ym_last = "";
uint sum_monthly = 0;//每月小計
uint deduct_monthly = 0;//每月購物金小計
uint sum_year = 0;//總計
uint deduct_year = 0;//購物金總計
foreach (string it in daysum_allbrand.Keys)
{
string ym = it.Substring(0, 7);
if (string.IsNullOrEmpty(ym_last))
ym_last = ym;
if (!ym_last.Equals(ym))
{
addrow[r] = sum_monthly;
r++;
addrow[r] = deduct_monthly;
r++;
addrow[r] = sum_monthly - deduct_monthly;
r++;
ym_last = ym;
sum_monthly = 0;
deduct_monthly = 0;
}
sum_monthly += daysum_allbrand[it];
deduct_monthly += deductsum_allbrand[it];
sum_year += daysum_allbrand[it];
deduct_year += deductsum_allbrand[it];
addrow[r] = daysum_allbrand[it];
r++;
addrow[r] = deductsum_allbrand[it];
r++;
addrow[r] = daysum_allbrand[it] - deductsum_allbrand[it];
r++;
}
if (CrossMonth)
{
addrow[r] = sum_monthly;
r++;
addrow[r] = deduct_monthly;
r++;
addrow[r] = sum_monthly - deduct_monthly;
r++;
}
addrow[r] = sum_year;
r++;
addrow[r] = deduct_year;
r++;
addrow[r] = sum_year - deduct_year;
_dt.Rows.Add(addrow);
foreach (uint it in brandDailyTotal.Keys)
{
ym_last = "";
sum_monthly = 0;
deduct_monthly = 0;
sum_year = 0;
deduct_year = 0;
r = 0;
addrow = _dt.NewRow();
if (brands.Keys.Contains(it))
{
addrow[r] = brands[it].Brand_Name;
r++;
addrow[r] = brands[it].vendor_name_simple;
r++;
}
else
{
addrow[r] = " ";
r++;
addrow[r] = " ";
r++;
}
foreach (string ite in brandDailyTotal[it]["daysum"].Keys)
{
string ym = ite.Substring(0, 7);
if (string.IsNullOrEmpty(ym_last))
ym_last = ym;
if (!ym_last.Equals(ym))
{
addrow[r] = sum_monthly;
r++;
addrow[r] = deduct_monthly;
r++;
addrow[r] = sum_monthly - deduct_monthly;
r++;
ym_last = ym;
sum_monthly = 0;
deduct_monthly = 0;
}
sum_monthly += brandDailyTotal[it]["daysum"][ite];
sum_year += brandDailyTotal[it]["daysum"][ite];
deduct_monthly += brandDailyTotal[it]["daydeduct"][ite];
deduct_year += brandDailyTotal[it]["daydeduct"][ite];
addrow[r] = brandDailyTotal[it]["daysum"][ite];
r++;
addrow[r] = brandDailyTotal[it]["daydeduct"][ite];
r++;
addrow[r] = brandDailyTotal[it]["daysum"][ite] - brandDailyTotal[it]["daydeduct"][ite];
r++;
}
if (CrossMonth)
{
addrow[r] = sum_monthly;
r++;
addrow[r] = deduct_monthly;
r++;
addrow[r] = sum_monthly - deduct_monthly;
r++;
}
addrow[r] = sum_year;
r++;
addrow[r] = deduct_year;
r++;
addrow[r] = sum_year - deduct_year;
_dt.Rows.Add(addrow);
}
// }
//if (_dt.Rows.Count > 0)
//{
//string fileName = "品牌營業額匯出_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
//MemoryStream ms = ExcelHelperXhf.ExportDT(_dt, "");
//Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
//Response.BinaryWrite(ms.ToArray());
string fileName = "品牌營業額匯出_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv";
//MemoryStream ms = ExcelHelperXhf.ExportDT(_dt, "");
//Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
//Response.BinaryWrite(ms.ToArray());
StringWriter sw = ExcelHelperXhf.SetCsvFromData(_dt, fileName);
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = Encoding.Default;
Response.Write(sw);
Response.End();
//}
//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);
}
}
public HttpResponseBase GetNewOrderRevenueList()
{
string json = string.Empty;
try
{
OrderDetailQuery query = new OrderDetailQuery();
#region 前置查詢條件
if (!string.IsNullOrEmpty(Request.Params["Brand_Id"]))/*品牌編號*/
{
query.Brand_Id_In = Request.Params["Brand_Id"];
}
if (!string.IsNullOrEmpty(Request.Params["product_manage"]))//管理人員
{//獲取管理人
query.product_manage = int.Parse(Request.Params["product_manage"]);
}
if (!string.IsNullOrEmpty(Request.Params["dateOne"]))
{
query.time_start = CommonFunction.GetPHPTime(DateTime.Parse(Request.Params["dateOne"]).ToString("yyyy/MM/dd 00:00:00"));
}
if (!string.IsNullOrEmpty(Request.Params["dateTwo"]))
{
query.time_end = CommonFunction.GetPHPTime(DateTime.Parse(Request.Params["dateTwo"]).ToString("yyyy/MM/dd 23:59:59"));
}
long start = query.time_start;//開始時間
long end = query.time_end;//結束時間
if (!string.IsNullOrEmpty(Request.Params["Channel_Id"]))//賣場
{
query.channel = int.Parse(Request.Params["Channel_Id"]);
}
if (!string.IsNullOrEmpty(Request.Params["slave_status"]))//訂單狀態
{
query.Status = int.Parse(Request.Params["slave_status"]);
}
if (!string.IsNullOrEmpty(Request.Params["order_payment"]))//付款方式
{
query.order_payment = int.Parse(Request.Params["order_payment"]);
}
if (!string.IsNullOrEmpty(Request.Params["selecttype"]))//關鍵字查詢類型
{
query.select_type = int.Parse(Request.Params["selecttype"]);
if (!string.IsNullOrEmpty(Request.Params["searchcon"]))//關鍵字查詢內容
{
query.select_con = Request.Params["searchcon"];
}
}
#endregion
VendorBrandQuery Vendorbrandquery = new VendorBrandQuery();
Dictionary<uint, VendorBrandQuery> brands = new Dictionary<uint, VendorBrandQuery>();///字典----儲存供應商編號，供應商名稱和錧別，錧別編號的信息
Dictionary<uint, Dictionary<string, Dictionary<string, uint>>> brandDailyTotal = new Dictionary<uint, Dictionary<string, Dictionary<string, uint>>>();///字典，儲存錧別，每天的計算和每天的購物金
///////////////brand_id//////////daysum,dayduct/////日期///值
List<VendorBrandQuery> aDB_Brand_Select = new List<VendorBrandQuery>();
_vbrand = new VendorBrandMgr(mySqlConnectionString);
aDB_Brand_Select = _vbrand.GetBandList(Vendorbrandquery);//把錧別和供應商信息保存到字典里
for (int i = 0; i < aDB_Brand_Select.Count; i++)
{
if (!brands.Keys.Contains(aDB_Brand_Select[i].Brand_Id))
{
brands.Add(aDB_Brand_Select[i].Brand_Id, aDB_Brand_Select[i]);
}
}
bool CrossMonth = CommonFunction.GetNetTime(start).Month == CommonFunction.GetNetTime(end).Month ? false : true;
string timelong = "";
while (start <= end)//時間格式化，用來保存每天的小計
{
timelong += CommonFunction.GetNetTime(start).ToString("yyyy/MM/dd") + ",";
start += 86400;
}
timelong = timelong.Substring(0, timelong.LastIndexOf(","));
string[] times = timelong.Split(',');
Dictionary<string, uint> timetro = new Dictionary<string, uint>();
for (int i = 0; i < times.Count(); i++)//字典加上日期時間
{
timetro.Add(times[i], 0);
}
Dictionary<string, Dictionary<string, uint>> daysum_deduct = new Dictionary<string, Dictionary<string, uint>>();//保存每個商品每日的小計和購物金
daysum_deduct.Add("daysum", timetro);//每日小計
daysum_deduct.Add("daydeduct", timetro);//每日小計
_orderDetailMgr = new OrderDetailMgr(mySqlConnectionString);
List<OrderDetailQuery> ordertailList = new List<OrderDetailQuery>();
ordertailList = _orderDetailMgr.GetOrderDetailList(query);//通過查詢條件獲取的數據
//if (ordertailList.Count == 0)
//{
// json = "{success:true,msg:\"" + "<div style='overflow:auto;text-align:center;width:1650px;height:550px;><p tyle='text-align:center'>~~暫無數據~~</p></div>" + "\"}";
//}
//else
//{
string[] quanxuan = query.Brand_Id_In.Split(',');
foreach (uint item in brands.Keys)
{
if (!brandDailyTotal.Keys.Contains(item))
{
daysum_deduct = new Dictionary<string, Dictionary<string, uint>>();
timetro = new Dictionary<string, uint>();
for (int a = 0; a < times.Count(); a++)//字典加上日期時間
{
timetro.Add(times[a], 0);
}
daysum_deduct.Add("daysum", timetro);//每日小計
timetro = new Dictionary<string, uint>();
for (int a = 0; a < times.Count(); a++)//字典加上日期時間
{
timetro.Add(times[a], 0);
}
daysum_deduct.Add("daydeduct", timetro);//購物金
brandDailyTotal.Add(item, daysum_deduct);
}
}
for (int i = 0; i < ordertailList.Count; i++)
{
ordertailList[i].subtotal = ordertailList[i].Single_Money * ordertailList[i].Buy_Num;
ordertailList[i].cost = (ordertailList[i].Event_Cost != 0 && ordertailList[i].Single_Cost != ordertailList[i].Single_Money) ? ordertailList[i].Event_Cost : ordertailList[i].Single_Cost;
if (!brands.Keys.Contains(ordertailList[i].Brand_Id))
{
VendorBrandQuery brand = new VendorBrandQuery();
brand.Vendor_Id = ordertailList[i].Vendor_Id;
brand.Brand_Name = ordertailList[i].Brand_Name;
brand.Brand_Id = ordertailList[i].Brand_Id;
brand.vendor_name_simple = ordertailList[i].Vendor_Name_Simple;
brands.Add(ordertailList[i].Brand_Id, brand);
}
if (!brandDailyTotal.Keys.Contains(ordertailList[i].Brand_Id))
{
daysum_deduct = new Dictionary<string, Dictionary<string, uint>>();
timetro = new Dictionary<string, uint>();
for (int a = 0; a < times.Count(); a++)//字典加上日期時間
{
timetro.Add(times[a], 0);
}
daysum_deduct.Add("daysum", timetro);//每日小計
timetro = new Dictionary<string, uint>();
for (int a = 0; a < times.Count(); a++)//字典加上日期時間
{
timetro.Add(times[a], 0);
}
daysum_deduct.Add("daydeduct", timetro);//購物金
brandDailyTotal.Add(ordertailList[i].Brand_Id, daysum_deduct);
}
string time = CommonFunction.GetNetTime(ordertailList[i].Order_Createdate).ToString("yyyy/MM/dd");
brandDailyTotal[ordertailList[i].Brand_Id]["daysum"][time] += ordertailList[i].subtotal;//每個商品的小計
brandDailyTotal[ordertailList[i].Brand_Id]["daydeduct"][time] += ordertailList[i].Deduct_Bonus;//每個商品的購物金小計
}
Dictionary<string, uint> daysum_allbrand = new Dictionary<string, uint>();//所有品牌的每日小計
Dictionary<string, uint> deductsum_allbrand = new Dictionary<string, uint>();//所有品牌的每日購物金
foreach (uint key in brandDailyTotal.Keys)
{
foreach (string time in brandDailyTotal[key]["daysum"].Keys)//循環每個品牌的每日小計，計算到所有品牌的每日小計
{
if (!daysum_allbrand.Keys.Contains(time))
{
daysum_allbrand.Add(time, brandDailyTotal[key]["daysum"][time]);
}
else
{
daysum_allbrand[time] += brandDailyTotal[key]["daysum"][time];
}
}
foreach (string time in brandDailyTotal[key]["daydeduct"].Keys)//循環每個品牌的每日購物金小計，計算到所有品牌的每日小計
{
if (!deductsum_allbrand.Keys.Contains(time))
{
deductsum_allbrand.Add(time, brandDailyTotal[key]["daydeduct"][time]);
}
else
{
deductsum_allbrand[time] += brandDailyTotal[key]["daydeduct"][time];
}
}
}
StringBuilder html_table = new StringBuilder();//匯出html頁面
html_table.AppendFormat(@"<div style='overflow:auto;text-align:right;width:1590px;height:580px;'><table style='border:0px;'>");
html_table.AppendFormat("<thead style='text-align:center;border-bottom: 1px solid #ccc;color: #000;'><tr><td style='border-bottom: 1px solid #ccc;color: #000;line-height: 1.2em;white-space: nowrap;font-size: 12px; text-align: center; text-align: center;'> 品牌名稱 </td>");
html_table.AppendFormat("<td style='border-bottom: 1px solid #ccc;color: #000;line-height: 1.2em;white-space: nowrap;font-size: 12px; text-align: center; text-align: center;'> 供應商名稱 </td>");
string ym_last = "";
foreach (string it in timetro.Keys)
{
string ym = it.Substring(0, 7);
if (string.IsNullOrEmpty(ym_last))
ym_last = ym;
if (!ym_last.Equals(ym))
{
html_table.AppendFormat("<td style= 'color: #c00;border-bottom: 1px solid #ccc;line-height: 1.2em;white-space: nowrap;font-size: 12px; text-align: center;'> {0} </td>", ym_last.Split('/')[1] + "月小計");
ym_last = ym;
}
html_table.AppendFormat("<td style='color: #000;border-bottom: 1px solid #ccc; text-align: center;'> {0} </td>", it);
}
if (CrossMonth)
{
html_table.AppendFormat("<td style= 'color: #c00;border-bottom: 1px solid #ccc;line-height: 1.2em;white-space: nowrap;font-size: 12px; text-align: center;'> {0} </td>", ym_last.Split('/')[1] + "月小計");
}
html_table.AppendFormat("<td style= 'color: #c00;border-bottom: 1px solid #ccc;line-height: 1.2em;white-space: nowrap;font-size: 12px; text-align: center;'> 品牌總計 </td></tr>");
html_table.AppendFormat("<tr><td colspan='2' style= 'text-align: right;border-bottom: 1px solid #ccc;color: #000;'> 每日小計 </td>");
ym_last = "";
uint sum_monthly = 0;
uint sum_year = 0;
foreach (string it in daysum_allbrand.Keys)
{
string ym = it.Substring(0, 7);
if (string.IsNullOrEmpty(ym_last))
ym_last = ym;
if (!ym_last.Equals(ym))
{
html_table.AppendFormat("<td style= 'border-bottom: 1px solid #ccc; text-align: right;color: #c00; '> {0} </td>", sum_monthly);
ym_last = ym;
sum_monthly = 0;
}
sum_monthly += daysum_allbrand[it];
sum_year += daysum_allbrand[it];
html_table.AppendFormat("<td style='text-align:right;border-bottom: 1px solid #ccc; '> {0} </td>", daysum_allbrand[it]);
}
if (CrossMonth)
{
html_table.AppendFormat("<td style= 'text-align:right;color: #c00;border-bottom: 1px solid #ccc; '> {0} </td>", sum_monthly);
}
html_table.AppendFormat("<td style= 'text-align:right;color: #c00;border-bottom: 1px solid #ccc; '> {0} </td></tr></thead>", sum_year);
html_table.AppendFormat("<tbody>");
foreach (uint it in brandDailyTotal.Keys)
{
ym_last = "";
sum_monthly = 0;
sum_year = 0;
if (brands.Keys.Contains(it))
{
html_table.AppendFormat("<tr><td style=' white-space: nowrap;text-align:left;line-height: 1.2em;font-size: 12px;'> {0} </td><td style='text-align:left; white-space: nowrap;line-height: 1.2em;font-size: 12px;'> {1} </td>", brands[it].Brand_Name, brands[it].vendor_name_simple);
}
else
{
html_table.AppendFormat("<tr><td> {0} </td><td > {1} </td>", " ", " ");
}
foreach (string ite in brandDailyTotal[it]["daysum"].Keys)
{
string ym = ite.Substring(0, 7);
if (string.IsNullOrEmpty(ym_last))
ym_last = ym;
if (!ym_last.Equals(ym))
{
html_table.AppendFormat("<td style= 'text-align:right;color: #c00; white-space: nowrap;line-height: 1.2em;font-size: 12px;'> {0} </td>", sum_monthly);
ym_last = ym;
sum_monthly = 0;
}
sum_monthly += brandDailyTotal[it]["daysum"][ite];
sum_year += brandDailyTotal[it]["daysum"][ite];
html_table.AppendFormat("<td style='text-align:right;white-space: nowrap;line-height: 1.2em;font-size: 12px;'> {0} </td>", brandDailyTotal[it]["daysum"][ite]);
}
if (CrossMonth)
{
html_table.AppendFormat("<td style= 'text-align:right;color: #c00; white-space: nowrap;line-height: 1.2em;font-size: 12px;'> {0} </td>", sum_monthly);
}
html_table.AppendFormat("<td style= 'text-align:right;color: #c00; white-space: nowrap;line-height: 1.2em;font-size: 12px;'> {0} </td> </tr>", sum_year);
}
html_table.AppendFormat("</tbody></table>");
json = "{success:true,msg:\"" + html_table.ToString() + "\"}";
}
// }
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);
this.Response.End();
return this.Response;
}
public HttpResponseBase ExportFile()
{
int totalCount = 0;
string json = "false";
try
{
VendorBrandQuery query = new VendorBrandQuery();
_vendorBrand = new VendorBrandMgr(connectionString);
query.IsPage = false;
query.isExport = true;
// query.searchContent = Request.Params["searchContent"];
if (!string.IsNullOrEmpty(Request.Params["searchContent"]))
{
//支持空格，中英文逗號隔開
string content = Regex.Replace(Request.Params["searchContent"].Trim(), "(\\s+)|(，)|(\\,)", ",");
string[] contents = content.Split(',');
int pid = 0;
for (int i = 0; i < contents.Length; i++)
{
if (!string.IsNullOrEmpty(contents[i].Trim()))
{
if (query.searchContent == "")
{
if (int.TryParse(contents[i], out pid))
{
query.searchContent += Regex.Replace(contents[i].Trim(), "(\\s+)|(，)|(\\,)", ",");
}
else
{
query.searchContent += Regex.Replace(contents[i].Trim(), "(\\s+)|(，)|(\\,)", ",");
}
}
else
{
if (int.TryParse(contents[i], out pid))
{
query.searchContent += "," + Regex.Replace(contents[i].Trim(), "(\\s+)|(，)|(\\,)", ",");
}
else
{
query.searchContent += "," + Regex.Replace(contents[i].Trim(), "(\\s+)|(，)|(\\,)", ",");
}
}
}
else
{
continue;
}
}
}
query.story_createname = Request.Params["createname"];
if (!string.IsNullOrEmpty(Request.Params["searchVendor"]))
{
if (Request.Params["searchVendor"] != "undefined")
{
query.Vendor_Id = uint.Parse(Request.Params["searchVendor"]);
}
}
if (!string.IsNullOrEmpty(Request.Params["brandid"]))
{
if (Request.Params["brandid"] != "undefined")
{
query.Brand_Id = uint.Parse(Request.Params["brandid"]);
}
}
// query.searchState = Convert.ToInt32(Request.Params["searchState"]);
if (!string.IsNullOrEmpty(Request.Params["start_date"]))
{
query.date_start = Convert.ToDateTime(Request.Params["start_date"]);
}
if (!string.IsNullOrEmpty(Request.Params["end_date"]))
{
query.date_end = Convert.ToDateTime(Request.Params["end_date"]);
}
if (Request.Params["searchState"] == "0")
{
query.Brand_Story_Text = string.Empty;
}
else if (Request.Params["searchState"] == "1")
{
query.Brand_Story_Text = "1";
}
else if (Request.Params["searchState"] == "2")
{
query.Brand_Story_Text = "2";
}
#region 供應商狀態、品牌狀態
if (!string.IsNullOrEmpty(Request.Params["vendorState"]))
{
query.vendorState = Convert.ToInt32(Request.Params["vendorState"]);
}
if (!string.IsNullOrEmpty(Request.Params["brandState"]))
{
query.Brand_Status = Convert.ToUInt32(Request.Params["brandState"]);
}
#endregion
query.IsPage = false;
DataTable dtHZ = new DataTable();
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));
dtHZ.Columns.Add("修改時間", typeof(String));
DataTable _dt = _vendorBrand.GetVendorBrandStory(query, out totalCount);
foreach (DataRow dr_v in _dt.Rows)
{
DataRow dr = dtHZ.NewRow();
dr[0] = dr_v["vendor_id"].ToString();
dr[1] = dr_v["vendor_name_full"].ToString();
dr[2] = dr_v["brand_id"].ToString();
dr[3] = dr_v["brand_name"].ToString();
dr[4] = dr_v["story_createname"].ToString();
dr[5] = dr_v["story_createdate"].ToString();
dr[6] = dr_v["story_updatename"].ToString();
dr[7] = dr_v["story_updatedate"].ToString();
dtHZ.Rows.Add(dr);
}
string[] colname = new string[dtHZ.Columns.Count];
string filename = "vendorbrand_story" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
newExcelName = Server.MapPath(excelPath_export) + filename;
for (int i = 0; i < dtHZ.Columns.Count; i++)
{
colname[i] = dtHZ.Columns[i].ColumnName;
}
if (System.IO.File.Exists(newExcelName))
{
System.IO.File.Delete(newExcelName);
}
ExcelHelperXhf.ExportDTtoExcel(dtHZ, "", newExcelName);
//CsvHelper.ExportDataTableToCsv(_dt, newExcelName, columnName, true);
json = "{success:true,ExcelName:\'" + filename + "\'}";
}
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);
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase VendorBrandPreview()
{
_siteConfigMgr = new SiteConfigMgr(Server.MapPath(xmlPath));
List<SiteConfig> configList = _siteConfigMgr.Query();
string DomainName = configList.Where(m => m.Name.Equals("DoMain_Name")).FirstOrDefault().Value;
string json = string.Empty;
try
{
VendorBrandQuery query = new VendorBrandQuery();
_vendorBrand = new VendorBrandMgr(connectionString);
if (!string.IsNullOrEmpty(Request.Params["brand_id"]))
{
query.Brand_Id = Convert.ToUInt32(Request.Params["brand_id"]);
int classify = _vendorBrand.GetClassify(query);
string result = string.Empty;
switch (classify)
{
case 10:
result += "http://" + DomainName + "/food/brand_food.php?b_id=" + query.Brand_Id;//商品預覽
break;
case 20:
result += "http://" + DomainName + "/stuff/brand_stuff.php?b_id=" + query.Brand_Id;//商品預覽
break;
default:
result += "http://" + DomainName + "/brand.php?b_id=" + query.Brand_Id;//商品預覽
break;
//www.gigade100.com/newweb/food/brand_food.php?b_id=332
}
json = result.ToString().ToLower();
}
}
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 = "無預覽信息";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase AddVendorBrandStory()
{
string json = string.Empty;
int i = 0;
try
{
VendorBrandQuery query = new VendorBrandQuery();
_vendorBrand = new VendorBrandMgr(connectionString);
query.Brand_Id = Convert.ToUInt32(Request.Params["brandid"]);
query.Brand_Name = Request.Params["brandName"];
query.Brand_Story_Text = Request.Params["brandStoryText"];
query.Brand_Story_Text = query.Brand_Story_Text.Replace("\\", "\\\\");
VendorBrand oldbrand = _vendorBrand.GetVendorBrand(query).FirstOrDefault();
query.Story_Update = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
query.Story_Updatedate = DateTime.Now;
if (oldbrand.Story_Created == 0)
{
query.Story_Created = query.Story_Update;
query.Story_Createdate = query.Story_Updatedate;
}
else
{
query.Story_Created = oldbrand.Story_Created;
query.Story_Createdate = oldbrand.Story_Createdate;
}
i = _vendorBrand.AddVendorBrandStory(query);
if (i > 0)
{
json = "{success:true,msg:'修改成功！'}";//返回json數據
}
else
{
json = "{success:false,msg:'修改失敗！'}";
}
}
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,msg:'異常！'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public List<VendorBrandQuery> GetBandList(VendorBrandQuery query)
{
StringBuilder strSql = new StringBuilder(@"SELECT vb.brand_id,vb.brand_name,v.vendor_id,v.vendor_name_simple ");
try
{
strSql.Append(" FROM vendor_brand vb,vendor v ");
strSql.Append(" WHERE vb.vendor_id=v.vendor_id AND vb.brand_status=1 ");
strSql.Append(" ORDER BY vb.brand_id ASC");
return _dbAccess.getDataTableForObj<VendorBrandQuery>(strSql.ToString());
}
catch (Exception ex)
{
throw new Exception("VendorBrandDao-->GetBandList-->" + ex.Message + "sql:" + strSql.ToString(), ex);
}
}
public int GetClassify(VendorBrandQuery query)
{
try
{
return _vendorBrandDao.GetClassify(query);
}
catch (Exception ex)
{
throw new Exception("VendorBrandMgr-->GetClassify-->" + ex.Message, ex);
}
}
public List<VendorBrand> GetVendorBrand(VendorBrandQuery query)
{
query.Replace4MySQL();
StringBuilder strSql = new StringBuilder();
try
{
strSql.AppendFormat(@"SELECT brand_id,brand_name,brand_status,brand_story_text,story_created,story_createdate,story_update,story_updatedate FROM vendor_brand ");
if (query.Brand_Id != 0)
{
strSql.AppendFormat(" where brand_id='{0}'", query.Brand_Id);
}
return _dbAccess.getDataTableForObj<VendorBrand>(strSql.ToString());
}
catch (Exception ex)
{
throw new Exception("VendorBrandDao-->GetVendorBrand-->" + ex.Message + "sql:" + strSql.ToString(), ex);
}
}
public string GetBrand_idByBrand_name(VendorBrandQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
query.Replace4MySQL();
sql.AppendFormat(@"SELECT brand_id,brand_name from vendor_brand WHERE brand_name LIKE N'%{0}%'",query.Brand_Name);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("VendorBrandDao-->GetBrand_idByBrand_name-->" + ex.Message + "sql:" + sql.ToString(), ex);
}
}
public int GetClassify(VendorBrandQuery query)
{
query.Replace4MySQL();
StringBuilder strSql = new StringBuilder();
DataTable store = new DataTable();
int classify = 0;
try
{
strSql.AppendFormat(@"SELECT DISTINCT prod_classify from product WHERE brand_id={0} ", query.Brand_Id);
store = _dbAccess.getDataTable(strSql.ToString());
foreach (DataRow row in store.Rows)
{
if (Convert.ToInt32(row[0]) == 10 || Convert.ToInt32(row[0]) == 20)
{
classify = Convert.ToInt32(row[0]);
break;
}
else
{
classify = Convert.ToInt32(row[0]);
}
}
}
catch (Exception ex)
{
throw new Exception("VendorBrandDao-->GetClassify-->" + ex.Message + "sql:" + strSql.ToString(), ex);
}
return classify;
}
public int AddVendorBrandStory(VendorBrandQuery query)
{
query.Replace4MySQL();
StringBuilder strSql = new StringBuilder();
DataTable store = new DataTable();
try
{
query.Brand_Story_Text = query.Brand_Story_Text.Replace("\n", "<br/>");
strSql.AppendFormat(@"UPDATE vendor_brand SET brand_story_text ='{0}',story_created='{1}',story_createdate='{2}',", query.Brand_Story_Text, query.Story_Created, Common.CommonFunction.DateTimeToString(query.Story_Createdate));
strSql.AppendFormat(" story_update='{0}', story_updatedate='{1}' WHERE brand_id={2} ", query.Story_Update, Common.CommonFunction.DateTimeToString(query.Story_Updatedate), query.Brand_Id);
return _dbAccess.execCommand(strSql.ToString());
}
catch (Exception ex)
{
throw new Exception("VendorBrandDao-->AddVendorBrandStory-->" + ex.Message + "sql:" + strSql.ToString(), ex);
}
}
/// <summary>
/// 獲取品牌故事文字列表
/// </summary>
/// <param name="query">VendorBrand表對象</param>
/// <param name="totalCount">查詢記錄總條數</param>
/// <returns></returns>
public DataTable GetVendorBrandStory(VendorBrandQuery query, out int totalCount)
{
query.Replace4MySQL();
StringBuilder conditionsql = new StringBuilder();
StringBuilder strSql = new StringBuilder();
StringBuilder sqlWhere = new StringBuilder();
StringBuilder count = new StringBuilder();
VendorBrand list = new VendorBrand();
DataTable store = new DataTable();
totalCount = 0;
try
{
if (query.isExport)
{
conditionsql.AppendFormat(@"SELECT v.vendor_id,v.vendor_name_full, brand_id,brand_name,mu.user_username story_createname,story_createdate,mu1.user_username story_updatename,story_updatedate ");
conditionsql.AppendFormat(@" FROM vendor_brand vb ");
}
else
{
conditionsql.AppendFormat(@"SELECT brand_id,brand_name,brand_status,brand_story_text,story_created,mu.user_username story_createname,story_createdate, ");
conditionsql.AppendFormat(@" story_update,mu1.user_username story_updatename,story_updatedate FROM vendor_brand vb ");
}
strSql.AppendFormat(@" LEFT JOIN manage_user mu on mu.user_id=vb.story_created ");
strSql.AppendFormat(@" LEFT JOIN manage_user mu1 on mu1.user_id=vb.story_update ");
strSql.AppendFormat(@" LEFT JOIN vendor v on vb.vendor_id=v.vendor_id ");
count.AppendFormat(@" SELECT count(brand_id) as totalCount from vendor_brand vb ");
if (query.Vendor_Id != 0)
{
sqlWhere.AppendFormat(" AND vb.vendor_id={0} ", query.Vendor_Id);
}
if (query.Brand_Id != 0)
{
sqlWhere.AppendFormat(" AND vb.brand_id={0} ", query.Brand_Id);
}
if (query.date_start != DateTime.MinValue)
{
sqlWhere.AppendFormat(" and vb.story_createdate >= '{0}'", Common.CommonFunction.DateTimeToString(query.date_start));
}
if (query.date_end != DateTime.MinValue)
{
sqlWhere.AppendFormat(" and vb.story_createdate <= '{0}'", Common.CommonFunction.DateTimeToString(query.date_end));
}
if (!string.IsNullOrEmpty(query.searchContent))
{
//判斷“品牌編號/品牌名稱”輸入欄是否輸入的是數字
//如果是數字就按品牌編號和品牌名稱中帶輸入內容的條件進行搜索，不是數字就按品牌名稱帶搜索內容的條件來搜索
int result = 0;
//支持空格，中英文逗號隔開
string content = Regex.Replace(query.searchContent.Trim(), "(\\s+)|(，)|(\\,)", ",");
string[] contents = content.Split(',');
bool isSucess = int.TryParse(contents[0], out result);
if (isSucess)
{
sqlWhere.AppendFormat(" AND vb.brand_id IN ({0}) ", content);
}
else
{
sqlWhere.AppendFormat(@" AND ( ");
for (int i = 0; i < contents.Length; i++)
{
if (i == 0)
{
sqlWhere.AppendFormat(@" vb.brand_name LIKE N'%{0}%' ", contents[i]);
}
else
{
sqlWhere.AppendFormat(@" OR vb.brand_name LIKE N'%{0}%' ", contents[i]);
}
}
sqlWhere.AppendFormat(@" )");
}
}
if (!string.IsNullOrEmpty(query.story_createname))
{
sqlWhere.AppendFormat(" AND mu.user_username like N'%{0}%' ", query.story_createname);
}
//Brand_Story_Text是未編輯狀態
if (query.Brand_Story_Text == "1")
{
sqlWhere.AppendFormat(" AND vb.brand_story_text IS NULL");
}
//Brand_Story_Text是已編輯狀態
else if (query.Brand_Story_Text == "2")
{
sqlWhere.AppendFormat(" AND vb.brand_story_text IS NOT NULL");
}
if (query.vendorState != 0)
{
sqlWhere.AppendFormat(" AND v.vendor_status={0}", query.vendorState);
}
if (query.Brand_Status != 0)
{
sqlWhere.AppendFormat(" AND vb.brand_status={0}", query.Brand_Status);
}
if (sqlWhere.Length != 0)
{
strSql.Append(" WHERE ");
strSql.Append(sqlWhere.ToString().TrimStart().Remove(0, 3));
}
if (query.IsPage)
{
DataTable dt = _dbAccess.getDataTable(count.ToString() + strSql.ToString());
if (dt != null && dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(dt.Rows[0]["totalCount"]);
}
strSql.AppendFormat(" order by brand_id limit {0},{1} ", query.Start, query.Limit);
}
else
{
strSql.AppendFormat(" order by brand_id ");
}
store = _dbAccess.getDataTable(conditionsql.ToString() + strSql.ToString());
return store;
}
catch (Exception ex)
{
throw new Exception("VendorBrandDao-->GetVendorBrandStory-->" + ex.Message + "sql:" + conditionsql.ToString() + strSql.ToString(), ex);
}
}
public DataTable GetVendorBrandStory(VendorBrandQuery query, out int totalCount)
{
try
{
return _vendorBrandDao.GetVendorBrandStory(query, out totalCount);
}
catch (Exception ex)
{
throw new Exception("VendorBrandMgr-->GetVendorBrandStory-->" + ex.Message, ex);
}
}
public string GetBrandName(PromotionBannerQuery query)
{
try
{
VendorBrandQuery vb_query = new VendorBrandQuery();
vb_query.Brand_Id = (uint)query.singleBrand_id;
List<VendorBrand> exits = _vendorBrandDao.GetVendorBrand(vb_query);//查詢是否有這個品牌編號
uint brand_id = 0;
string brand_name = string.Empty;
if (exits.Count != 0)
{
if (query.multi == 0)
{
string[] bids = query.singleBrand_id.ToString().Split(',');
AllowShowOrNot(query, bids, out brand_id);
if (brand_id != 0)
{
return "-2";//品牌编号在該促銷圖片顯示期間已有其他促銷圖片 且已啟用
}
}
List<VendorBrand> vb_store = _vendorBrandDao.GetBrandListByIds(string.Empty, query.singleBrand_id);
if (vb_store != null)
{
brand_name = vb_store[0].Brand_Name;
}
return brand_name;
}
else
{
return "-1";
}
}
catch (Exception ex)
{
throw new Exception("PromotionBannerRelationMgr-->GetBrandName-->" + ex.Message, ex);
}
}
public int AddVendorBrandStory(VendorBrandQuery query)
{
try
{
return _vendorBrandDao.AddVendorBrandStory(query);
}
catch (Exception ex)
{
throw new Exception("VendorBrandMgr-->AddVendorBrandStory-->" + ex.Message, ex);
}
}
public HttpResponseBase GetVendorBrandStory()
{
string json = string.Empty;
DataTable stores = new DataTable();
try
{
VendorBrandQuery query = new VendorBrandQuery();
_vendorBrand = new VendorBrandMgr(connectionString);
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
// query.searchContent = Request.Params["searchContent"].Trim();
if (!string.IsNullOrEmpty(Request.Params["searchContent"]))
{
//支持空格，中英文逗號隔開
string content = Regex.Replace(Request.Params["searchContent"].Trim(), "(\\s+)|(，)|(\\,)", ",");
string[] contents = content.Split(',');
int pid = 0;
for (int i = 0; i < contents.Length; i++)
{
if (!string.IsNullOrEmpty(contents[i].Trim()))
{
if (query.searchContent == "")
{
if (int.TryParse(contents[i], out pid))
{
query.searchContent += Regex.Replace(contents[i].Trim(), "(\\s+)|(，)|(\\,)", ",");
}
else
{
query.searchContent += Regex.Replace(contents[i].Trim(), "(\\s+)|(，)|(\\,)", ",");
}
}
else
{
if (int.TryParse(contents[i], out pid))
{
query.searchContent += "," + Regex.Replace(contents[i].Trim(), "(\\s+)|(，)|(\\,)", ",");
}
else
{
query.searchContent += "," + Regex.Replace(contents[i].Trim(), "(\\s+)|(，)|(\\,)", ",");
}
}
}
else
{
continue;
}
}
}
query.story_createname = Request.Params["createname"].Trim();
query.story_createname = query.story_createname.Trim();
if (!string.IsNullOrEmpty(Request.Params["searchVendor"]))
{
query.Vendor_Id = uint.Parse(Request.Params["searchVendor"]);
}
if (!string.IsNullOrEmpty(Request.Params["brandid"]))
{
query.Brand_Id = uint.Parse(Request.Params["brandid"]);
}
// query.searchState = Convert.ToInt32(Request.Params["searchState"]);
if (!string.IsNullOrEmpty(Request.Params["start_date"]))
{
query.date_start = Convert.ToDateTime(Request.Params["start_date"]);
}
if (!string.IsNullOrEmpty(Request.Params["end_date"]))
{
query.date_end = Convert.ToDateTime(Request.Params["end_date"]);
}
if (Request.Params["searchState"] == "0")
{
query.Brand_Story_Text = string.Empty;
}
else if (Request.Params["searchState"] == "1")
{
query.Brand_Story_Text = "1";
}
else if (Request.Params["searchState"] == "2")
{
query.Brand_Story_Text = "2";
}
#region 供應商狀態、品牌狀態
if (!string.IsNullOrEmpty(Request.Params["vendorState"]))
{
query.vendorState = Convert.ToInt32(Request.Params["vendorState"]);
}
if (!string.IsNullOrEmpty(Request.Params["brandState"]))
{
query.Brand_Status = Convert.ToUInt32(Request.Params["brandState"]);
}
#endregion
int totalCount = 0;
stores = _vendorBrand.GetVendorBrandStory(query, out totalCount);
foreach (DataRow dr in stores.Rows)
{
dr["Brand_Story_Text"] = dr["Brand_Story_Text"].ToString().Replace("<br/>", "\n");
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, Newtonsoft.Json.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}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public List<VendorBrand> GetVendorBrand(VendorBrandQuery query)
{
try
{
return _vendorBrandDao.GetVendorBrand(query);
}
catch (Exception ex)
{
throw new Exception("VendorBrandMgr-->GetVendorBrand-->" + ex.Message, ex);
}
}
public HttpResponseBase BrandStore()
{
string json = string.Empty;
try
{
VendorBrandQuery query = new VendorBrandQuery();
List<VendorBrand> store = new List<VendorBrand>();
query.Brand_Status = 1;
_vendorBrand = new BLL.gigade.Mgr.VendorBrandMgr(mySqlConnectionString);
store = _vendorBrand.GetProductBrandList(query);
json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented) + "}";
}
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;
}
