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;
}
