private DataGridViewModel <Dictionary <string, object> > GetDataList(CouponsSearch query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult couponInfos = CouponHelper.GetCouponInfos(query, "");
dataGridViewModel.rows = DataHelper.DataTableToDictionary(couponInfos.Data);
dataGridViewModel.total = couponInfos.TotalRecords;
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
CouponInfo couponInfo = row.ToObject <CouponInfo>();
int couponSurplus = CouponHelper.GetCouponSurplus(couponInfo.CouponId);
row.Add("LastCount", couponSurplus);
int couponObtainUserNum = CouponHelper.GetCouponObtainUserNum(couponInfo.CouponId);
int couponObtainNum = CouponHelper.GetCouponObtainNum(couponInfo.CouponId, 0);
row.Add("UserCount", couponObtainUserNum);
row.Add("UserGetCount", couponObtainNum);
int couponUsedNum = CouponHelper.GetCouponUsedNum(couponInfo.CouponId);
row.Add("UseCount", couponUsedNum);
row.Add("IsCouponEnd", this.IsCouponEnd(couponInfo.ClosingTime));
}
}
return(dataGridViewModel);
}
public void GetList(HttpContext context)
{
int num = 1;
int num2 = 10;
num = base.GetIntParam(context, "page", false).Value;
if (num < 1)
{
num = 1;
}
num2 = base.GetIntParam(context, "rows", false).Value;
if (num2 < 1)
{
num2 = 10;
}
CouponsSearch couponsSearch = new CouponsSearch();
couponsSearch.CouponName = context.Request["CouponName"];
couponsSearch.State = base.GetIntParam(context, "State", true);
couponsSearch.ObtainWay = base.GetIntParam(context, "ObtainWay", true);
couponsSearch.PageIndex = num;
couponsSearch.PageSize = num2;
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(couponsSearch);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
public DbQueryResult GetCouponInfos(CouponsSearch search)
{
DbQueryResult result;
try
{
StringBuilder stringBuilder = new StringBuilder(" 1=1 ");
if (!string.IsNullOrEmpty(search.CouponName))
{
stringBuilder.Append(" and CouponName like '%" + search.CouponName.ReplaceSingleQuoteMark() + "%' ");
}
if (search.beginDate.HasValue)
{
stringBuilder.Append(" and beginDate<='" + search.beginDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' ");
}
if (search.endDate.HasValue)
{
stringBuilder.Append(" and endDate>='" + search.endDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' ");
}
if (search.Finished.HasValue)
{
if (search.Finished.Value)
{
stringBuilder.Append(" and (Finished=1 or getdate()>endDate)");
}
else
{
stringBuilder.Append(" and Finished=0 and getdate()<=endDate");
}
}
if (search.minValue.HasValue)
{
stringBuilder.Append(" and CouponValue>=" + search.minValue.Value);
}
if (search.maxValue.HasValue)
{
stringBuilder.Append(" and CouponValue<=" + search.maxValue.Value);
}
if (search.SearchType.HasValue && search.SearchType.Value != 0)
{
stringBuilder.Append(" and CouponTypes like '%" + search.SearchType.Value + "%'");
}
result = DataHelper.PagingByRownumber(search.PageIndex, search.PageSize, search.SortBy, search.SortOrder, search.IsCount, "Hishop_Coupon_Coupons", "CouponId", stringBuilder.ToString(), "*");
}
catch (Exception)
{
result = null;
}
return(result);
}
public void GetList(HttpContext context)
{
CouponsSearch couponsSearch = new CouponsSearch();
couponsSearch.CouponName = base.GetParameter(context, "CouponName", true);
couponsSearch.ObtainWay = 1;
couponsSearch.IsValid = true;
couponsSearch.PageIndex = base.CurrentPageIndex;
couponsSearch.PageSize = base.CurrentPageSize;
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(couponsSearch);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(CouponsSearch query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult couponInfos = CouponHelper.GetCouponInfos(query, "");
dataGridViewModel.rows = DataHelper.DataTableToDictionary(couponInfos.Data);
dataGridViewModel.total = couponInfos.TotalRecords;
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
row.Add("CouponSurplus", this.GetCouponSurplus(row["CouponId"].ToInt(0)));
}
}
return(dataGridViewModel);
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(CouponsSearch query, string NotInCouponIds = "")
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
string sWhere = "";
if (!string.IsNullOrWhiteSpace(NotInCouponIds))
{
sWhere = "and COUPONID NOT IN ('" + NotInCouponIds.Replace(",", "','") + "')";
}
DbQueryResult couponInfos = CouponHelper.GetCouponInfos(query, sWhere);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(couponInfos.Data);
dataGridViewModel.total = couponInfos.TotalRecords;
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
row.Add("CouponSurplus", this.GetCouponSurplus(row["CouponId"].ToInt(0)));
}
}
return(dataGridViewModel);
}
public string GetAppModelJson(HttpContext context)
{
CouponsSearch couponsSearch = new CouponsSearch
{
CouponName = ((context.Request.Form["Name"] == null) ? "" : context.Request.Form["Name"].ToNullString()),
PageIndex = 1,
IsValid = true,
ObtainWay = 0
};
couponsSearch.PageSize = 1000;
DataTable noPageCouponInfos = CouponHelper.GetNoPageCouponInfos(couponsSearch);
int pageCount = 1;
if (noPageCouponInfos != null)
{
string str = "{\"status\":1,";
str = str + this.GetCouponsListJson(noPageCouponInfos, context) + ",";
str = str + "\"page\":\"" + this.GetPageHtml(pageCount, context) + "\"";
return(str + "}");
}
return("{\"status\":1,\"list\":[],\"page\":\"\"}");
}
public DbQueryResult GetCouponInfos(CouponsSearch search)
{
try
{
StringBuilder builder = new StringBuilder(" 1=1 ");
if (!string.IsNullOrEmpty(search.CouponName))
{
builder.Append(" and CouponName like '%" + search.CouponName.ReplaceSingleQuoteMark() + "%' ");
}
if (search.beginDate.HasValue)
{
builder.Append(" and beginDate<='" + search.beginDate.Value.ToString("yyyy-MM-dd") + "' ");
}
if (search.endDate.HasValue)
{
builder.Append(" and endDate>='" + search.endDate.Value.ToString("yyyy-MM-dd") + "' ");
}
if (search.Finished.HasValue)
{
builder.Append(" and Finished=" + (search.Finished.Value ? 1 : 0).ToString());
}
if (search.minValue.HasValue)
{
builder.Append(" and CouponValue>=" + search.minValue.Value);
}
if (search.maxValue.HasValue)
{
builder.Append(" and CouponValue<=" + search.maxValue.Value);
}
return(DataHelper.PagingByRownumber(search.PageIndex, search.PageSize, search.SortBy, search.SortOrder, search.IsCount, "Hishop_Coupon_Coupons", "CouponId", builder.ToString(), "*"));
}
catch (Exception)
{
return(null);
}
}
private void BindData()
{
string text = "";
string selectedValue = "";
decimal? nullable = null;
decimal? nullable2 = null;
DateTime?selectedDate = null;
DateTime?nullable4 = null;
text = this.txt_name.Text;
decimal i = 0M;
DateTime now = DateTime.Now;
if (this.bDecimal(this.txt_minVal.Text, ref i))
{
nullable = new decimal?(i);
}
if (this.bDecimal(this.txt_maxVal.Text, ref i))
{
nullable2 = new decimal?(i);
}
selectedDate = this.calendarStartDate.SelectedDate;
nullable4 = this.calendarEndDate.SelectedDate;
selectedValue = this.ddlCouponType.SelectedValue;
CouponsSearch search = new CouponsSearch
{
CouponName = text,
minValue = nullable,
maxValue = nullable2,
beginDate = selectedDate,
endDate = nullable4,
IsCount = true,
PageIndex = this.pager1.PageIndex,
PageSize = this.pager1.PageSize,
SortBy = "CouponId",
SortOrder = SortAction.Desc,
Finished = new bool?(bFininshed),
SearchType = new int?(string.IsNullOrEmpty(selectedValue) ? 0 : int.Parse(selectedValue))
};
DbQueryResult couponInfos = CouponHelper.GetCouponInfos(search);
if (couponInfos != null)
{
DataTable data = (DataTable)couponInfos.Data;
if (data.Rows.Count > 0)
{
data.Columns.Add("useConditon");
data.Columns.Add("ReceivNum");
data.Columns.Add("expire");
for (int j = 0; j < data.Rows.Count; j++)
{
decimal num3 = decimal.Parse(data.Rows[j]["ConditionValue"].ToString());
if (num3 == 0M)
{
data.Rows[j]["useConditon"] = "不限制";
}
else
{
data.Rows[j]["useConditon"] = "满" + num3.ToString("F2") + "可使用";
}
string str3 = data.Rows[j]["maxReceivNum"].ToString();
if (str3 == "0")
{
data.Rows[j]["ReceivNum"] = "无限制";
}
else
{
data.Rows[j]["ReceivNum"] = str3 + "/张每人";
}
data.Rows[j]["expire"] = DateTime.Parse(data.Rows[j]["EndDate"].ToString()) <= DateTime.Now;
}
}
this.grdCoupondsList.DataSource = data;
this.grdCoupondsList.DataBind();
}
this.pager1.TotalRecords = couponInfos.TotalRecords;
}
private void BindData()
{
string text = "";
decimal? nullable = null;
decimal? nullable2 = null;
DateTime?nullable3 = null;
DateTime?nullable4 = null;
text = this.txt_name.Text;
decimal i = 0M;
DateTime now = DateTime.Now;
if (this.bDecimal(this.txt_minVal.Text, ref i))
{
nullable = new decimal?(i);
}
if (this.bDecimal(this.txt_maxVal.Text, ref i))
{
nullable2 = new decimal?(i);
}
if (this.bDate(this.calendarStartDate.Text, ref now))
{
nullable3 = new DateTime?(now);
}
if (this.bDate(this.calendarEndDate.Text, ref now))
{
nullable4 = new DateTime?(now);
}
CouponsSearch search = new CouponsSearch
{
CouponName = text,
minValue = nullable,
maxValue = nullable2,
beginDate = nullable3,
endDate = nullable4,
IsCount = true,
PageIndex = this.pager1.PageIndex,
PageSize = this.pager1.PageSize,
SortBy = "CouponId",
SortOrder = SortAction.Desc
};
DbQueryResult couponInfos = CouponHelper.GetCouponInfos(search);
DataTable data = (DataTable)couponInfos.Data;
if (data.Rows.Count > 0)
{
data.Columns.Add("useConditon");
data.Columns.Add("ReceivNum");
for (int j = 0; j < data.Rows.Count; j++)
{
decimal num3 = decimal.Parse(data.Rows[j]["ConditionValue"].ToString());
if (num3 == 0M)
{
data.Rows[j]["useConditon"] = "不限制";
}
else
{
data.Rows[j]["useConditon"] = "满" + num3.ToString("F2") + "可使用";
}
string str2 = data.Rows[j]["maxReceivNum"].ToString();
if (str2 == "0")
{
data.Rows[j]["ReceivNum"] = "无限制";
}
else
{
data.Rows[j]["ReceivNum"] = str2 + "/张每人";
}
}
}
this.grdCoupondsList.DataSource = data;
this.grdCoupondsList.DataBind();
this.pager1.TotalRecords = couponInfos.TotalRecords;
}
public static DbQueryResult GetCouponInfos(CouponsSearch search)
{
return((new CouponDao()).GetCouponInfos(search));
}
public static DataTable GetNoPageCouponInfos(CouponsSearch search)
{
return(new CouponDao().GetNoPageCouponInfos(search));
}
public static DbQueryResult GetCouponInfos(CouponsSearch search, string sWhere = "")
{
return(new CouponDao().GetCouponInfos(search, sWhere));
}
public void LoadCoupon()
{
if (!string.IsNullOrEmpty(this.context.Request["PageSize"]) && !string.IsNullOrEmpty(this.context.Request["CurrentPage"]))
{
int pageSize = int.Parse(this.context.Request["PageSize"]);
int pageIndex = int.Parse(this.context.Request["CurrentPage"]);
int value = 0;
int.TryParse(this.context.Request["obtainWay"], out value);
int num = 0;
MemberInfo user = Users.GetUser(HiContext.Current.UserId);
if (user != null)
{
num = user.UserId;
}
CouponsSearch couponsSearch = new CouponsSearch();
couponsSearch.ObtainWay = value;
couponsSearch.PageIndex = pageIndex;
couponsSearch.PageSize = pageSize;
couponsSearch.IsValid = true;
DbQueryResult couponInfos = CouponHelper.GetCouponInfos(couponsSearch, "");
DataTable data = couponInfos.Data;
string str = "{\"totalCount\":\"" + couponInfos.TotalRecords + "\",\"data\":[";
string text = "";
for (int i = 0; i < data.Rows.Count; i++)
{
if (text != "")
{
text += ",";
}
object[] obj = new object[24]
{
text,
"{\"CouponId\":\"",
data.Rows[i]["CouponId"],
"\",\"CouponName\":\"",
data.Rows[i]["CouponName"],
"\",\"Price\":\"",
data.Rows[i]["Price"],
"\",\"SendCount\":\"",
data.Rows[i]["SendCount"],
"\",\"UserLimitCount\":\"",
data.Rows[i]["UserLimitCount"],
"\",\"OrderUseLimit\":\"",
data.Rows[i]["OrderUseLimit"],
"\",\"StartTime\":\"",
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
};
DateTime dateTime = DateTime.Parse(data.Rows[i]["StartTime"].ToString());
obj[14] = dateTime.ToString("yyyy.MM.dd");
obj[15] = "\",\"ClosingTime\":\"";
dateTime = DateTime.Parse(data.Rows[i]["ClosingTime"].ToString());
obj[16] = dateTime.ToString("yyyy.MM.dd");
obj[17] = "\",\"CanUseProducts\":\"";
obj[18] = data.Rows[i]["CanUseProducts"];
obj[19] = "\",\"ObtainWay\":\"";
obj[20] = data.Rows[i]["ObtainWay"];
obj[21] = "\",\"NeedPoint\":\"";
obj[22] = data.Rows[i]["NeedPoint"];
obj[23] = "\"}";
text = string.Concat(obj);
}
str += text;
str += "]}";
this.context.Response.Write(str);
}
}
public DataTable GetNoPageCouponInfos(CouponsSearch search)
{
try
{
StringBuilder stringBuilder = new StringBuilder(" 1=1 ");
if (!string.IsNullOrEmpty(search.CouponName))
{
stringBuilder.Append(" AND COUPONNAME LIKE '%" + DataHelper.CleanSearchString(search.CouponName) + "%' ");
}
DateTime now;
if (search.State.HasValue)
{
switch (search.State.Value)
{
case 0:
{
StringBuilder stringBuilder4 = stringBuilder;
now = DateTime.Now;
stringBuilder4.Append(" AND STARTTIME > '" + now.ToString() + "' ");
break;
}
case 1:
{
StringBuilder stringBuilder3 = stringBuilder;
string[] obj = new string[5]
{
" AND STARTTIME < '",
null,
null,
null,
null
};
now = DateTime.Now;
obj[1] = now.ToString();
obj[2] = "' and ClosingTime > '";
now = DateTime.Now;
obj[3] = now.ToString();
obj[4] = "' ";
stringBuilder3.Append(string.Concat(obj));
break;
}
case 2:
{
StringBuilder stringBuilder2 = stringBuilder;
now = DateTime.Now;
stringBuilder2.Append(" AND CLOSINGTIME < '" + now.ToString() + "' ");
break;
}
}
}
if (search.ObtainWay.HasValue)
{
stringBuilder.Append(" AND OBTAINWAY = '" + search.ObtainWay.Value + "' ");
}
if (search.IsValid.HasValue)
{
if (search.IsValid.Value)
{
StringBuilder stringBuilder5 = stringBuilder;
now = DateTime.Now;
stringBuilder5.Append(" AND CLOSINGTIME > '" + now.ToString() + "' ");
stringBuilder.Append(" AND SendCount > (SELECT COUNT(CI.CouponId) FROM Hishop_CouponItems as CI WHERE CI.CouponId=Hishop_Coupons.CouponId)");
}
else
{
StringBuilder stringBuilder6 = stringBuilder;
now = DateTime.Now;
stringBuilder6.Append(" AND CLOSINGTIME < '" + now.ToString() + "' ");
}
}
if (string.IsNullOrEmpty(search.SortBy))
{
search.SortBy = "COUPONID";
search.SortOrder = SortAction.Desc;
}
string query = "SELECT CouponId,CouponName,Price,OrderUseLimit,StartTime,ClosingTime FROM Hishop_Coupons WHERE" + stringBuilder.ToString();
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(query);
DataSet dataSet = base.database.ExecuteDataSet(sqlStringCommand);
if (dataSet != null && dataSet.Tables[0] != null && dataSet.Tables[0].Rows.Count > 0)
{
return(dataSet.Tables[0]);
}
return(null);
}
catch (Exception)
{
return(null);
}
}
public DbQueryResult GetCouponInfos(CouponsSearch search, string sWhere = "")
{
try
{
StringBuilder stringBuilder = new StringBuilder(" 1=1 ");
if (!string.IsNullOrEmpty(search.CouponName))
{
stringBuilder.Append(" AND COUPONNAME LIKE '%" + DataHelper.CleanSearchString(search.CouponName) + "%' ");
}
DateTime now;
if (search.State.HasValue)
{
switch (search.State.Value)
{
case 0:
{
StringBuilder stringBuilder4 = stringBuilder;
now = DateTime.Now;
stringBuilder4.Append(" AND STARTTIME > '" + now.ToString() + "' ");
break;
}
case 1:
{
StringBuilder stringBuilder3 = stringBuilder;
string[] obj = new string[5]
{
" AND STARTTIME < '",
null,
null,
null,
null
};
now = DateTime.Now;
obj[1] = now.ToString();
obj[2] = "' and ClosingTime > '";
now = DateTime.Now;
obj[3] = now.ToString();
obj[4] = "' ";
stringBuilder3.Append(string.Concat(obj));
break;
}
case 2:
{
StringBuilder stringBuilder2 = stringBuilder;
now = DateTime.Now;
stringBuilder2.Append(" AND CLOSINGTIME < '" + now.ToString() + "' ");
break;
}
}
}
if (search.ObtainWay.HasValue)
{
stringBuilder.Append(" AND OBTAINWAY = '" + search.ObtainWay.Value + "' ");
}
if (search.IsValid.HasValue)
{
if (search.IsValid.Value)
{
StringBuilder stringBuilder5 = stringBuilder;
now = DateTime.Now;
stringBuilder5.Append(" AND CLOSINGTIME > '" + now.ToString() + "' ");
stringBuilder.Append(" AND SendCount > (SELECT COUNT(CI.CouponId) FROM Hishop_CouponItems as CI WHERE CI.CouponId=Hishop_Coupons.CouponId)");
}
else
{
StringBuilder stringBuilder6 = stringBuilder;
now = DateTime.Now;
stringBuilder6.Append(" AND CLOSINGTIME < '" + now.ToString() + "' ");
}
}
if (string.IsNullOrEmpty(search.SortBy))
{
if (search.ObtainWay.HasValue && search.ObtainWay.Value == 2)
{
search.SortBy = "NeedPoint ASC,COUPONID";
search.SortOrder = SortAction.Desc;
}
else
{
search.SortBy = "COUPONID";
search.SortOrder = SortAction.Desc;
}
}
if (!string.IsNullOrEmpty(sWhere))
{
stringBuilder.Append(sWhere);
}
return(DataHelper.PagingByRownumber(search.PageIndex, search.PageSize, search.SortBy, search.SortOrder, search.IsCount, "Hishop_Coupons", "CouponId", stringBuilder.ToString(), "*"));
}
catch (Exception)
{
return(null);
}
}
