public HttpResponseBase GetConditionList() { string json = string.Empty; List<EdmListConditionMain> store = new List<EdmListConditionMain>(); EdmListConditionMain item = new EdmListConditionMain(); _edmlistmainMgr = new EdmListConditionMainMgr(sqlConnectionString); try { store = _edmlistmainMgr.GetConditionList(); item.elcm_id = 0; item.elcm_name = "無"; //store.Add(item); store.Insert(0, item); // store.Insert(0, 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; }
public int SaveListInfoName(EdmListConditionMain query, out int id,out int msg) { try { EdmListConditionMain idModel = new EdmListConditionMain(); EdmListConditionMain model = new EdmListConditionMain(); idModel = _edmlistmainDao.SelectElcmIDByConditionName(query.elcm_name); msg = 0; id = 0; if (idModel == null) { query.elcm_created = DateTime.Now; int i = _edmlistmainDao.SaveListInfoName(query); if (i > 0) { model = _edmlistmainDao.SelectElcmIDByConditionName(query.elcm_name); id = model.elcm_id; } return i; } else { msg = 1; //篩選條件名已存在 return 0; } } catch (Exception ex) { throw new Exception(" EdmListConditionMainMgr-->SaveListInfoName " + ex.Message, ex); } }
/// <summary> /// 刪除篩選條件 /// </summary> /// <param name="query"></param> /// <returns></returns> public int DeleteListInfo(EdmListConditionMain query) { try { StringBuilder sql = new StringBuilder(); sql.AppendFormat(@"DELETE from edm_list_conditoin_sub WHERE elcm_id={0}; ", query.elcm_id); sql.AppendFormat(@"DELETE from edm_list_condition_main WHERE elcm_id={0};", query.elcm_id); return _dbAccess.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception(" EdmListConditionMainDao-->DeleteListInfo " + ex.Message, ex); } }
public int DeleteListInfo(EdmListConditionMain query) { EdmListConditionMain model = new EdmListConditionMain(); try { model = _edmlistmainDao.SelectElcmIDByConditionName(query.elcm_name); if (model != null) { query.elcm_id = model.elcm_id; return _edmlistmainDao.DeleteListInfo(query); } else { return 0; } } catch (Exception ex) { throw new Exception(" EdmListConditionMainMgr-->DeleteListInfo " + ex.Message, ex); } }
public int UpdateCondition(EdmListConditoinSubQuery query) { int i = 0; try { EdmListConditionMain model = new EdmListConditionMain(); model = _edmlistmainDao.SelectElcmIDByConditionName(query.elcm_name); if (model != null) { query.elcm_id = model.elcm_id; _edmlistsubDao.DeleteInfo(query); i = _edmlistsubDao.SaveListInfoCondition(query); } return i; } catch (Exception ex) { throw new Exception(" EdmListConditionMainMgr-->UpdateCondition " + ex.Message, ex); } }
/// <summary> /// 儲存篩選條件名稱 /// </summary> /// <param name="query"></param> /// <returns></returns> public int SaveListInfoName(EdmListConditionMain query) { query.Replace4MySQL(); StringBuilder sql = new StringBuilder(); try { if (query.elcm_name != string.Empty) { sql.AppendFormat(@"INSERT INTO edm_list_condition_main (elcm_creator_id, elcm_name, elcm_created) VALUES ('{0}', '{1}', '{2}')", query.elcm_creator_id, query.elcm_name, CommonFunction.DateTimeToString(query.elcm_created)); } return _dbAccess.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception(" EdmListConditionMainDao-->SaveListInfo " + ex.Message, ex); } }
public List<EdmListConditoinSubQuery> LoadCondition(EdmListConditoinSubQuery query) { EdmListConditionMain model = new EdmListConditionMain(); List<EdmListConditoinSub> result = new List<EdmListConditoinSub>(); List<EdmListConditoinSubQuery> store = new List<EdmListConditoinSubQuery>(); try { model = _edmlistmainDao.SelectElcmIDByConditionName(query.elcm_name); if (model != null) { query.elcm_id = model.elcm_id; result = _edmlistsubDao.LoadCondition(query); if (result != null) { EdmListConditoinSubQuery q = new EdmListConditoinSubQuery(); store.Add(q); #region 保存條件狀態 for (int i = 0; i < result.Count; i++) { string key = result[i].elcs_key; switch (key) { case "gender": store[0].chkGender = true; if (!string.IsNullOrEmpty(result[i].elcs_value1)) { store[0].genderCondition = Convert.ToInt32(result[i].elcs_value1); } break; case "buy_times": store[0].ChkBuy = true; if (Convert.ToInt32(result[i].elcs_value1) != 0) { store[0].buyCondition = Convert.ToInt32(result[i].elcs_value1); } if (Convert.ToInt32(result[i].elcs_value2) != 0) { store[0].buyTimes = Convert.ToInt32(result[i].elcs_value2); } if (!string.IsNullOrEmpty(result[i].elcs_value3)) { if (Convert.ToDateTime(result[i].elcs_value3) != DateTime.MinValue) { store[0].buyTimeMin = Convert.ToDateTime(result[i].elcs_value3); } if (Convert.ToDateTime(result[i].elcs_value4) != DateTime.MinValue) { store[0].buyTimeMax = Convert.ToDateTime(result[i].elcs_value4); } } break; case "age": store[0].ChkAge = true; if (Convert.ToInt32(result[i].elcs_value1) != 0) { store[0].ageMin = Convert.ToInt32(result[i].elcs_value1); } if (Convert.ToInt32(result[i].elcs_value2) != 0) { store[0].ageMax = Convert.ToInt32(result[i].elcs_value2); } break; case "cancel_times": store[0].ChkCancel = true; if (Convert.ToInt32(result[i].elcs_value1) != 0) { store[0].cancelCondition = Convert.ToInt32(result[i].elcs_value1); } if (Convert.ToInt32(result[i].elcs_value2) != 0) { store[0].cancelTimes = Convert.ToInt32(result[i].elcs_value2); } if (!string.IsNullOrEmpty(result[i].elcs_value3)) { if (Convert.ToDateTime(result[i].elcs_value3) != DateTime.MinValue) { store[0].cancelTimeMin = Convert.ToDateTime(result[i].elcs_value3); } if (Convert.ToDateTime(result[i].elcs_value4) != DateTime.MinValue) { store[0].cancelTimeMax = Convert.ToDateTime(result[i].elcs_value4); } } break; case "register_time": store[0].ChkRegisterTime = true; if (!string.IsNullOrEmpty(result[i].elcs_value1)) { if (Convert.ToDateTime(result[i].elcs_value1) != DateTime.MinValue) { store[0].registerTimeMin = Convert.ToDateTime(result[i].elcs_value1); } if (Convert.ToDateTime(result[i].elcs_value2) != DateTime.MinValue) { store[0].registerTimeMax = Convert.ToDateTime(result[i].elcs_value2); } } break; case "return_times": store[0].ChkReturn = true; if (Convert.ToInt32(result[i].elcs_value1) != 0) { store[0].returnCondition = Convert.ToInt32(result[i].elcs_value1); } if (Convert.ToInt32(result[i].elcs_value2) != 0) { store[0].returnTimes = Convert.ToInt32(result[i].elcs_value2); } if (!string.IsNullOrEmpty(result[i].elcs_value3)) { if (Convert.ToDateTime(result[i].elcs_value3) != DateTime.MinValue) { store[0].returnTimeMin = Convert.ToDateTime(result[i].elcs_value3); } if (Convert.ToDateTime(result[i].elcs_value4) != DateTime.MinValue) { store[0].returnTimeMax = Convert.ToDateTime(result[i].elcs_value4); } } break; case "last_order": store[0].ChkLastOrder = true; if (!string.IsNullOrEmpty(result[i].elcs_value1)) { if (Convert.ToDateTime(result[i].elcs_value1) != DateTime.MinValue) { store[0].lastOrderMin = Convert.ToDateTime(result[i].elcs_value1); } if (Convert.ToDateTime(result[i].elcs_value2) != DateTime.MinValue) { store[0].lastOrderMax = Convert.ToDateTime(result[i].elcs_value2); } } break; case "replenishment_info": store[0].ChkNotice = true; if (!string.IsNullOrEmpty(result[i].elcs_value1)) { if (Convert.ToInt32(result[i].elcs_value1) != 0) { store[0].noticeCondition = Convert.ToInt32(result[i].elcs_value1); } if (Convert.ToInt32(result[i].elcs_value2) != 0) { store[0].noticeTimes = Convert.ToInt32(result[i].elcs_value2); } } break; case "last_login": store[0].ChkLastLogin = true; if (!string.IsNullOrEmpty(result[i].elcs_value1)) { if (Convert.ToDateTime(result[i].elcs_value1) != DateTime.MinValue) { store[0].lastLoginMin = Convert.ToDateTime(result[i].elcs_value1); } if (Convert.ToDateTime(result[i].elcs_value2) != DateTime.MinValue) { store[0].lastLoginMax = Convert.ToDateTime(result[i].elcs_value2); } } break; case "total_consumption": store[0].ChkTotalConsumption = true; if (!string.IsNullOrEmpty(result[i].elcs_value1)) { if (Convert.ToInt32(result[i].elcs_value1) != 0) { store[0].totalConsumptionMin = Convert.ToInt32(result[i].elcs_value1); } if (Convert.ToInt32(result[i].elcs_value2) != 0) { store[0].totalConsumptionMax = Convert.ToInt32(result[i].elcs_value2); } } break; case "black_list": store[0].ChkBlackList = true; break; case "phone": store[0].ChkPhone = true; break; } } #endregion } } return store; } catch (Exception ex) { throw new Exception(" EdmListConditoinSubMgr-->LoadCondition " + ex.Message, ex); } }
public HttpResponseBase DeleteListInfo() { string json = string.Empty; _edmlistmainMgr = new EdmListConditionMainMgr(sqlConnectionString); EdmListConditionMain query = new EdmListConditionMain(); try { if (!string.IsNullOrEmpty(Request.Params["elcm_name"])) { query.elcm_name = Request.Params["elcm_name"]; } if (query.elcm_name == "無") { json = "{success:true,msg:1}"; } else { int i = _edmlistmainMgr.DeleteListInfo(query); if (i > 0) { json = "{success:true}"; } 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,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }