/// <summary>
/// 查詢出序號兌換列表
/// </summary>
/// <returns>序號兌換列表</returns>
public HttpResponseBase PromotionsBonuslist()
{
List<PromotionsBonusQuery> stores = new List<PromotionsBonusQuery>();
_promBnus = new PromotionsBonusMgr(mySqlConnectionString);
string json = string.Empty;
try
{
PromotionsBonusQuery query = new PromotionsBonusQuery();
query.Start = Convert.ToInt32(Request["Start"] ?? "0");
if (!string.IsNullOrEmpty(Request["Limit"]))
{
query.Limit = Convert.ToInt32(Request["Limit"]);
}
if (!string.IsNullOrEmpty(Request.Params["ddlSel"]))
{
query.expired = Convert.ToInt32(Request.Params["ddlSel"]);
}
int totalCount = 0;
stores = _promBnus.Query(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
//listUser是准备转换的对象
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, 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:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//public HttpResponseBase GetInsertNum()
//{
// string jsonStr = "";
// try
// {
// //StreamReader sr = new StreamReader(@"D:\\2.txt", Encoding.UTF8);
// //string result = "";
// //string re = sr.ReadToEnd();
// //if (re.Length > 0)
// //{
// // result = re.Trim().TrimEnd(',');
// //}
// //string[] ge = result.Split(',');
// //string a = ge[(ge.Count() - 1)];
// //jsonStr = "{success:true,msg:" + a + "}";//返回json數據
// jsonStr = "{success:true,msg:" + SuccessNum + "}";//返回json數據
// // sr.Close();
// }
// 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}";
// }
// this.Response.Clear();
// this.Response.Write(jsonStr.ToString());
// this.Response.End();
// return this.Response;
//}
#endregion
#endregion
#region 序號兌換 更改活動使用狀態+JsonResult UpdateActive()
/// <summary>
/// 更改活動使用狀態
/// </summary>
/// <returns>數據庫操作結果</returns>
public JsonResult UpdateActive()
{
string currentUser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
string muser = string.Empty;
int activeValue = Convert.ToInt32(Request.Params["active"]);
if (!string.IsNullOrEmpty(Request.Params["muser"]))
{
muser = (Request.Params["muser"]);
}
if (currentUser == muser && activeValue == 1)
{
return Json(new { success = "stop" });
}
_promBnus = new PromotionsBonusMgr(mySqlConnectionString);
int id = Convert.ToInt32(Request.Params["id"]);
PromotionsBonus model = new PromotionsBonus();
model = _promBnus.GetModel(id);
model.active = Convert.ToBoolean(activeValue);
model.muser =int.Parse(currentUser);
model.modified = DateTime.Now;
if (_promBnus.UpdateActive(model) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
}
/// <summary>
/// 保存前臺新增或者修改的數據
/// </summary>
/// <returns></returns>
public HttpResponseBase Save()
{
PromotionsBonus model = new PromotionsBonus();
model.muser=int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
//判斷是否能夠獲取到rowid
if (String.IsNullOrEmpty(Request.Params["rowid"])) //新增
{
model.modified = DateTime.Now;
model.created = DateTime.Now;
model.kuser = model.muser;
//todo:對model進行賦值
try
{
model.amount = Convert.ToInt32(Request.Params["amount"]);
}
catch (Exception)
{
model.amount = 0;
}
if (Request.Params["group_id"].ToString() != "")
{
try//group_id
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
catch (Exception)
{
model.group_id = 0;
}
model.condition_id = 0;
}
else if (Request.Params["condition_id"].ToString() != "")
{
try//condition_id
{
model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
}
catch (Exception)
{
model.condition_id = 0;
}
model.group_id = 0;
}
try
{
model.end = Convert.ToDateTime(Request.Params["end"]);
}
catch (Exception)
{
model.end = DateTime.Now;
}
try
{
model.start = Convert.ToDateTime(Request.Params["startbegin"]);
}
catch (Exception)
{
model.start = DateTime.Now;
}
try
{
model.name = Request.Params["name"];
}
catch (Exception)
{
model.name = "";
}
try
{
model.type = Convert.ToInt32(Request.Params["bonus_type"]);
}
catch (Exception)
{
model.type = 0;
}
try
{
if (Convert.ToInt32(Request.Params["hmcfsy"]) == 1)
{
model.repeat = true;
}
else
{
model.repeat = false;
}
}
catch (Exception)
{
model.repeat = false;
}
try
{
if (Convert.ToInt32(Request.Params["sydzxh"]) == 1)
{
model.multiple = true;
}
else
{
model.multiple = false;
}
}
catch (Exception)
{
model.multiple = false;
}
//添加使用期限
int day;
if (Int32.TryParse(Request.Params["days"], out day))
{
model.days = day;
}
return InsertPromotionsBonus(model);//如果獲取不到則進行新增
}
else //修改
{
_promBnus = new PromotionsBonusMgr(mySqlConnectionString);
model.id = Convert.ToInt32(Request.Params["rowid"]);
PromotionsBonus PB = _promBnus.GetModel(model.id);
model.modified = DateTime.Now;
try
{
model.amount = Convert.ToInt32(Request.Params["amount"]);
}
catch (Exception)
{
model.amount = PB.amount;
}
try
{
model.type = Convert.ToInt32(Request.Params["bonus_type"]);
}
catch (Exception)
{
model.type = PB.type;
}
if (Request.Params["group_id"].ToString() != "")
{
try//group_id
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
catch (Exception)
{
model.group_id = PB.group_id;
}
model.condition_id = 0;
}
else if (Request.Params["condition_id"].ToString() != "")
{
try//condition_id
{
model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
}
catch (Exception)
{
model.condition_id = PB.condition_id;
}
model.group_id = 0;
}
try
{
model.end = Convert.ToDateTime(Request.Params["end"]);
}
catch (Exception)
{
model.end = PB.end;
}
try
{
model.start = Convert.ToDateTime(Request.Params["startbegin"]);
}
catch (Exception)
{
model.start = PB.start;
}
try
{
model.name = Request.Params["name"];
}
catch (Exception)
{
model.name = PB.name;
}
try
{
if ("1" == Request.Params["hmcfsy"].ToString())
{
model.repeat = true;
}
else
{
model.repeat = false;
}
}
catch (Exception)
{
model.repeat = PB.repeat;
}
try
{
if ("1" == Request.Params["sydzxh"].ToString())
{
model.multiple = true;
}
else
{
model.multiple = false;
}
}
catch (Exception)
{
model.multiple = PB.multiple;
}
model.active = false;
int day;
if (Int32.TryParse(Request.Params["days"], out day))
{
model.days = day;
}
//todo:對model進行賦值
return UpdatePromotionsBonus(model);//如果可以獲取到rowid則進行修改
}
}
/// <summary>
/// 新增功能 PromotionsBonus
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
protected HttpResponseBase InsertPromotionsBonus(PromotionsBonus model)
{
string json = string.Empty;
try
{
_promBnus = new PromotionsBonusMgr(mySqlConnectionString);
_promBnus.Save(model);
json = "{success:true}";//返回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;
}
/// <summary>
/// 刪除數據
/// </summary>
/// <returns>數據庫操作結果</returns>
public HttpResponseBase Delete()
{
string jsonStr = String.Empty;
_promBnus = new PromotionsBonusMgr(mySqlConnectionString);
PromotionsBonus query = new PromotionsBonus();
if (!String.IsNullOrEmpty(Request.Params["rowid"]))
{
try
{
foreach (string rid in Request.Params["rowid"].ToString().Split('|'))
{
if (!string.IsNullOrEmpty(rid))
{
query.id = Convert.ToInt32(rid);
query.muser=int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
query.modified = DateTime.Now;
_promBnus.Delete(query);
}
}
jsonStr = "{success:true}";
}
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}";
}
}
this.Response.Clear();
this.Response.Write(jsonStr);
this.Response.End();
return this.Response;
}