public HttpResponseBase DistinctCode() { string json = string.Empty; try { MemberLevelQuery query = new MemberLevelQuery(); if (!string.IsNullOrEmpty(Request.Params["ml_code"])) { query.ml_code = Request.Params["ml_code"]; _memberLevel = new MemberLevelMgr(mySqlConnectionString); if (_memberLevel.DistinctCode(query)) { json = "{success:false}";//代碼重複 } else { json = "{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); json = "{success:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase SaveMemberLevel() { string json = string.Empty; try { MemberLevelQuery query = new MemberLevelQuery(); _memberLevel = new MemberLevelMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["ml_name"])) { query.ml_name = Request.Params["ml_name"]; } if (!string.IsNullOrEmpty(Request.Params["ml_code"])) { query.ml_code = Request.Params["ml_code"]; } if (!string.IsNullOrEmpty(Request.Params["ml_minimal_amount"])) { query.ml_minimal_amount = Convert.ToInt32(Request.Params["ml_minimal_amount"]); } if (!string.IsNullOrEmpty(Request.Params["ml_max_amount"])) { query.ml_max_amount = Convert.ToInt32(Request.Params["ml_max_amount"]); } if (!string.IsNullOrEmpty(Request.Params["ml_month_seniority"])) { query.ml_month_seniority = Convert.ToInt32(Request.Params["ml_month_seniority"]); } if (!string.IsNullOrEmpty(Request.Params["ml_last_purchase"])) { query.ml_last_purchase = Convert.ToInt32(Request.Params["ml_last_purchase"]); } if (!string.IsNullOrEmpty(Request.Params["ml_minpurchase_times"])) { query.ml_minpurchase_times = Convert.ToInt32(Request.Params["ml_minpurchase_times"]); } if (!string.IsNullOrEmpty(Request.Params["ml_birthday_voucher"])) { query.ml_birthday_voucher = Convert.ToInt32(Request.Params["ml_birthday_voucher"]); } if (!string.IsNullOrEmpty(Request.Params["ml_shipping_voucher"])) { query.ml_shipping_voucher = Convert.ToInt32(Request.Params["ml_shipping_voucher"]); } if (!string.IsNullOrEmpty(Request.Params["ml_seq"])) { query.ml_seq = Convert.ToInt32(Request.Params["ml_seq"]); } if (!string.IsNullOrEmpty(Request.Params["rowID"]))//編輯 { query.rowID = Convert.ToInt32(Request.Params["rowID"]); query.m_user = (Session["caller"] as Caller).user_id; query.m_date = DateTime.Now; if (!string.IsNullOrEmpty(Request.Params["old_ml_seq"])) { query.old_ml_seq = Convert.ToInt32(Request.Params["old_ml_seq"]); } if (!string.IsNullOrEmpty(Request.Params["old_ml_code"])) { query.old_ml_code = (Request.Params["old_ml_code"]); } if (query.ml_seq != query.old_ml_seq && _memberLevel.DistinctSeq(query))//新代碼與老代碼不一樣並且重複 { json = "{success:'true',msg:'0'}";//排序重複 } else if (query.ml_code != query.old_ml_code && _memberLevel.DistinctCode(query)) { json = "{success:'true',msg:'2'}";//級別代碼重複 } else { if (_memberLevel.SaveMemberLevel(query) > 0) { json = "{success:'true',mag:'1'}";//保存成功 } else { json = "{success:'false'}";//保存失敗 } } } else//新增 { query.k_user = (Session["caller"] as Caller).user_id; query.k_date = DateTime.Now; query.k_user = (Session["caller"] as Caller).user_id; query.m_date = query.k_date; if (_memberLevel.DistinctSeq(query)) { json = "{success:'true',msg:'0'}";//排序重複 } else if (_memberLevel.DistinctCode(query)) { json = "{success:'true',msg:'2'}";//級別代碼重複 } else { if (_memberLevel.SaveMemberLevel(query) > 0) { json = "{success:'true',mag:'1'}";//保存成功 } else { json = "{success:'false'}";//保存失敗 } } } } 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; }