public int UpdateActive(PromotionsAccumulateRate store)
{
StringBuilder sb = new StringBuilder();
store.Replace4MySQL();
try
{
sb.AppendFormat("update promotions_accumulate_rate set active ={0},modified='{1}',muser={2} where id={3}", store.active, CommonFunction.DateTimeToString(store.modified),store.muser, store.id);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("PromotionsAccumulateRateDao-->UpdateActive-->" + ex.Message + sb.ToString(), ex);
}
}
/// <summary>
/// 更改活動使用狀態
/// </summary>
/// <returns>數據庫操作結果</returns>
public JsonResult UpdateActive()
{
string currentUser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
string muser = Request.Params["muser"];
int activeValue = Convert.ToInt32(Request.Params["active"]);
if (currentUser == muser && activeValue == 1)
{
return Json(new { success = "stop" });
}
_padAccRateMgr = new PromotionsAccumulateRateMgr(mySqlConnectionString);
int id = Convert.ToInt32(Request.Params["id"]);
PromotionsAccumulateRate model = new PromotionsAccumulateRate();
model.active = Convert.ToBoolean(activeValue);
model.modified = DateTime.Now;
model.muser = int.Parse(currentUser);
model.id = id;
if (_padAccRateMgr.UpdateActive(model) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
}
//public HttpResponseBase getfkfs()
//{
// List<PaymentType> fklx = new List<PaymentType>();
// List<PaymentType> nfklx = new List<PaymentType>();
// string resultStr = "";
// try
// {
// _paytyMgr = new PaymentTypeMgr(mySqlConnectionString);
// fklx = _paytyMgr.Myfkfs();
// PaymentType pt1 = new PaymentType();
// pt1.payment_name = "不分";
// pt1.payment_code = "0";
// nfklx.Add(pt1);
// for (int i = 0; i < fklx.Count; i++)
// {
// PaymentType pt = new PaymentType();
// pt.payment_name = fklx[i].payment_name;
// pt.payment_code = fklx[i].payment_code;
// nfklx.Add(pt);
// }
// resultStr = JsonConvert.SerializeObject(nfklx);
// }
// 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(resultStr);
//this.Response.End();
//return this.Response;
//}
#endregion
#region 點數累積 判斷保存或者編輯 +HttpResponseBase Save()
public HttpResponseBase Save()
{
PromotionsAccumulateRate model = new PromotionsAccumulateRate();
model.muser=(System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
model.modified = DateTime.Now;
string jsonStr = String.Empty;
//判斷是否能夠獲取到rowid
if (String.IsNullOrEmpty(Request.Params["rowid"]))
{
//todo:對model進行賦值
model.kuser = model.muser;
model.created = model.modified;
#region try catch 應用
try
{
model.amount = Convert.ToInt32(Request.Params["amount"]);
}
catch (Exception)
{
model.amount = 0;
}
try
{
if (Convert.ToInt32(Request.Params["bonus_type"]) == 1)
{
model.bonus_type = 1;
}
else
{
model.bonus_type = 0;
}
}
catch
{
model.bonus_type = 0;
}
try
{
model.end = Convert.ToDateTime(Request.Params["end"]);
}
catch (Exception)
{
model.end = DateTime.Now;
}
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() != "" && Request.Params["condition_id"].ToString() != "0")
{
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.start = Convert.ToDateTime(Request.Params["newstart"]);
}
catch (Exception)
{
model.start = DateTime.Now;
}
try
{
model.name = Request.Params["name"];
}
catch (Exception)
{
model.name = "";
}
try
{
model.dollar = Convert.ToInt32(Request.Params["dollar"]);
}
catch (Exception)
{
model.dollar = 0;
}
try
{
model.point = Convert.ToInt32(Request.Params["points"]);
}
catch (Exception)
{
model.point = 0;
}
try
{
model.payment_type_rid = Request.Params["payment_id"];
}
catch (Exception)
{
model.payment_type_rid = "";
}
#endregion
return InsertPromotionsAccumulateRate(model);//如果獲取不到則進行新增
}
else
{
_padAccRateMgr = new PromotionsAccumulateRateMgr(mySqlConnectionString);
model.id = Convert.ToInt32(Request.Params["rowid"].ToString());
PromotionsAccumulateRate PAR = _padAccRateMgr.GetModel(model.id);
#region try catch應用
try
{
model.amount = Convert.ToInt32(Request.Params["amount"]);
}
catch (Exception)
{
model.amount = PAR.amount;
}
try
{
model.bonus_type = Convert.ToInt32(Request.Params["bonus_type"]);
}
catch (Exception)
{
model.bonus_type = PAR.bonus_type;
}
try
{
model.end = Convert.ToDateTime(Request.Params["end"]);
}
catch (Exception)
{
model.end = PAR.end;
}
try
{
model.start = Convert.ToDateTime(Request.Params["newstart"]);
}
catch (Exception)
{
model.start = PAR.start;
}
try
{
model.name = Request.Params["name"];
}
catch (Exception)
{
model.name = PAR.name;
}
try
{
model.dollar = Convert.ToInt32(Request.Params["dollar"]);
}
catch (Exception)
{
model.dollar = 0;
}
try
{
model.point = Convert.ToInt32(Request.Params["points"]);
}
catch (Exception)
{
model.point = PAR.point;
}
try
{
model.payment_type_rid = Request.Params["payment_id"];
}
catch (Exception)
{
model.payment_type_rid = PAR.payment_type_rid;
}
//try
//{
// model.group_id = Convert.ToInt32(Request.Params["group_id"]);
//}
//catch (Exception)
//{
// model.group_id = PAR.group_id;
//}
//try
//{
// if (Convert.ToInt32(Request.Params["condition_id"]) != 0)
// {
// model.condition_id = Convert.ToInt32(Request.Params["condition_id"]);
// //model.group_id = 0;
// }
// else
// {
// model.condition_id = 0;
// }
//}
//catch (Exception)
//{
// model.condition_id = PAR.condition_id;
//}
if (Request.Params["group_id"].ToString() != "")
{
try//group_id
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
catch (Exception)
{
model.group_id = PAR.group_id;
}
if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
UserCondition uc = new UserCondition();
uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]);
if (_ucMgr.Delete(uc) > 0)
{
jsonStr = "{success:true}";
model.condition_id = 0;
}
else
{
jsonStr = "{success:false,msg:'user_condition刪除出錯！'}";
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
}
}
else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
try//condition_id
{
model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
}
catch (Exception)
{
model.condition_id = PAR.condition_id;
}
model.group_id = 0;
}
#endregion
model.active = false;
//todo:對model進行賦值
return UpdatePromotionsAccumulateRate(model);//如果可以獲取到rowid則進行修改
}
}
/// <summary>
/// 修改功能 PromotionsAmountFare
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
protected HttpResponseBase UpdatePromotionsAccumulateRate(PromotionsAccumulateRate model)
{
string json = string.Empty;
try
{
_padAccRateMgr.Update(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;
}
public HttpResponseBase Delete()
{
string jsonStr = String.Empty;
_padAccRateMgr = new PromotionsAccumulateRateMgr(mySqlConnectionString);
PromotionsAccumulateRate query = new PromotionsAccumulateRate();
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 =(System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
query.modified = DateTime.Now;
_padAccRateMgr.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;
}