public ActionResult JFRuleSet()
{
SetViewData();
#region 获取会员积分规则设置
Hashtable param = new Hashtable();
param.Add("id_masteruser", id_user_master);
ViewData["db_data"] = BusinessFactory.Tb_Hy_Jfrule.GetAll(param).Data;
#endregion
#region 获取会员积分兑换商品设置
param.Clear();
param.Add("id_masteruser", id_user_master);
ViewData["db_dbjf_dhsp_data"] = BusinessFactory.Tb_Hy_Jfconvertsp.GetAll(param).Data;
#endregion
#region 获取会员积分 多倍积分设置
var dbjf = new Ts_HykDbjf();
if (id_shop_master != id_shop)
{
dbjf = this.GetDBJFModel(id_shop);
}
else
{
dbjf = this.GetDBJFModel("0");
}
ViewData["db_dbjf_data"] = dbjf;
#endregion
return(View());
}
public ActionResult CZRuleSet()
{
SetViewData();
Hashtable param = new Hashtable();
param.Add("id_masteruser", id_user_master);
param.Add("query_body", "1");
param.Add("digit", GetParm());
ViewData["db_data"] = BusinessFactory.Tb_Hy_Czrule.GetAll(param).Data;
#region 获取会员积分 多倍积分设置
var dbjf = new Ts_HykDbjf();
if (id_shop_master != id_shop)
{
dbjf = this.GetCZModel(id_shop);
}
else
{
dbjf = this.GetCZModel("0");
}
ViewData["db_dbjf_data"] = dbjf;
#endregion
return(View());
}
public Ts_HykDbjf GetDBJFModel(string id_shop_select)
{
try
{
Ts_HykDbjf model = new Ts_HykDbjf()
{
id_masteruser = id_user_master, id_shop = id_shop_select
};
var shopParm = BusinessFactory.Tb_Hy_Jfrule.GetShopParm(model.id_masteruser, model.id_shop);
if (shopParm != null && shopParm.ContainsKey("success") && shopParm["success"].ToString() == "1")
{
model.hy_jfsz_week_val = shopParm["hy_jfsz_week_val"].ToString();
model.hy_jfsz_xs_rq_b = shopParm["hy_jfsz_xs_rq_b"].ToString();
model.hy_jfsz_xs_rq_e = shopParm["hy_jfsz_xs_rq_e"].ToString();
model.hy_jfsz_day_nbjf = shopParm["hy_jfsz_day_nbjf"].ToString();
model.hy_jfsz_xs_je = shopParm["hy_jfsz_xs_je"].ToString();
model.hy_jfsz_day_val = shopParm["hy_jfsz_day_val"].ToString();
model.hy_jfsz_xs_nbjf = shopParm["hy_jfsz_xs_nbjf"].ToString();
model.hy_jfsz_hysr_lx = shopParm["hy_jfsz_hysr_lx"].ToString();
model.hy_jfsz_hysr_nbjf = shopParm["hy_jfsz_hysr_nbjf"].ToString();
model.hy_jfsz_week_nbjf = shopParm["hy_jfsz_week_nbjf"].ToString();
}
else
{
shopParm = BusinessFactory.Tb_Hy_Jfrule.GetShopParm(model.id_masteruser, "0");
if (shopParm != null && shopParm.ContainsKey("success") && shopParm["success"].ToString() == "1")
{
model.hy_jfsz_week_val = shopParm["hy_jfsz_week_val"].ToString();
model.hy_jfsz_xs_rq_b = shopParm["hy_jfsz_xs_rq_b"].ToString();
model.hy_jfsz_xs_rq_e = shopParm["hy_jfsz_xs_rq_e"].ToString();
model.hy_jfsz_day_nbjf = shopParm["hy_jfsz_day_nbjf"].ToString();
model.hy_jfsz_xs_je = shopParm["hy_jfsz_xs_je"].ToString();
model.hy_jfsz_day_val = shopParm["hy_jfsz_day_val"].ToString();
model.hy_jfsz_xs_nbjf = shopParm["hy_jfsz_xs_nbjf"].ToString();
model.hy_jfsz_hysr_lx = shopParm["hy_jfsz_hysr_lx"].ToString();
model.hy_jfsz_hysr_nbjf = shopParm["hy_jfsz_hysr_nbjf"].ToString();
model.hy_jfsz_week_nbjf = shopParm["hy_jfsz_week_nbjf"].ToString();
}
}
return(model);
}
catch (CySoftException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public Ts_HykDbjf GetCZModel(string id_shop_select)
{
try
{
Ts_HykDbjf model = new Ts_HykDbjf()
{
id_masteruser = id_user_master, id_shop = id_shop_select
};
var shopParm = BusinessFactory.Tb_Hy_Jfrule.GetShopParm(model.id_masteruser, model.id_shop);
if (shopParm != null && shopParm.ContainsKey("success") && shopParm["success"].ToString() == "1")
{
model.hy_czje_min_onec = shopParm["hy_czje_min_onec"].ToString();
model.hy_czje_max_onec = shopParm["hy_czje_max_onec"].ToString();
model.hy_czje_max_month = shopParm["hy_czje_max_month"].ToString();
}
else
{
shopParm = BusinessFactory.Tb_Hy_Jfrule.GetShopParm(model.id_masteruser, "0");
if (shopParm != null && shopParm.ContainsKey("success") && shopParm["success"].ToString() == "1")
{
model.hy_czje_min_onec = shopParm["hy_czje_min_onec"].ToString();
model.hy_czje_max_onec = shopParm["hy_czje_max_onec"].ToString();
model.hy_czje_max_month = shopParm["hy_czje_max_month"].ToString();
}
}
return(model);
}
catch (CySoftException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public void AddWithExists(Ts_HykDbjf model)
{
try
{
StringBuilder sb = new StringBuilder();
if (model == null)
{
return;
}
//每日最小充值金额:
if (!string.IsNullOrEmpty(model.hy_czje_min_onec))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_czje_min_onec') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_czje_min_onec' ", model.hy_czje_min_onec, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle ,'21' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_czje_min_onec));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_czje_min_onec' ");
sb.Append(" END ");
sb.Append(" ");
}
else
{
//判断如果数据库中存在有值的数据 清空
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_czje_min_onec' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_czje_min_onec' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
}
//每日最大充值金额:
if (!string.IsNullOrEmpty(model.hy_czje_max_onec))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_czje_max_onec') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_czje_max_onec' ", model.hy_czje_max_onec, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle ,'21' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_czje_max_onec));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_czje_max_onec' ");
sb.Append(" END ");
sb.Append(" ");
}
else
{
//判断如果数据库中存在有值的数据 清空
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_czje_max_onec' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_czje_max_onec' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
}
//每月最大充值金额:
if (!string.IsNullOrEmpty(model.hy_czje_max_month))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_czje_max_month') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_czje_max_month' ", model.hy_czje_max_month, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle ,'21' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_czje_max_month));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_czje_max_month' ");
sb.Append(" END ");
sb.Append(" ");
}
else
{
//判断如果数据库中存在有值的数据 清空
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_czje_max_month' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_czje_max_month' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
}
dataMapper.Insert("DataTools.ExecuteSql", sb.ToString());
}
catch (DataMapperException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public void AddWithExists(Ts_HykDbjf model)
{
try
{
StringBuilder sb = new StringBuilder();
if (model == null)
{
return;
}
//会员阳历生日
if (!string.IsNullOrEmpty(model.hy_jfsz_hysr_nbjf))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_hysr_nbjf') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_hysr_nbjf' ", model.hy_jfsz_hysr_nbjf, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle ,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_hysr_nbjf));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_hysr_nbjf' ");
sb.Append(" END ");
sb.Append(" ");
//请选择会员生日期间类型
if (!string.IsNullOrEmpty(model.hy_jfsz_hysr_lx))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_hysr_lx') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_hysr_lx' ", model.hy_jfsz_hysr_lx, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_hysr_lx));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_hysr_lx' ");
sb.Append(" END ");
sb.Append(" ");
}
}
else
{
//判断如果数据库中存在有值的数据 清空
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_hysr_nbjf' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_hysr_nbjf' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_hysr_lx' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_hysr_lx' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
}
//星期
if (!string.IsNullOrEmpty(model.hy_jfsz_week_nbjf))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_week_nbjf') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_week_nbjf' ", model.hy_jfsz_week_nbjf, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle ,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle ,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_week_nbjf));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_week_nbjf' ");
sb.Append(" END ");
sb.Append(" ");
//请选择星期积分倍数的星期
if (!string.IsNullOrEmpty(model.hy_jfsz_week_val))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_week_val') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_week_val' ", model.hy_jfsz_week_val, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle ,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_week_val));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_week_val' ");
sb.Append(" END ");
sb.Append(" ");
}
}
else
{
//判断如果数据库中存在有值的数据 清空
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_week_nbjf' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_week_nbjf' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_week_val' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_week_val' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
}
//日期
if (!string.IsNullOrEmpty(model.hy_jfsz_day_nbjf))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_day_nbjf') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_day_nbjf' ", model.hy_jfsz_day_nbjf, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_day_nbjf));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_day_nbjf' ");
sb.Append(" END ");
sb.Append(" ");
//请选择日期积分倍数的日期
if (!string.IsNullOrEmpty(model.hy_jfsz_day_val))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_day_val') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_day_val' ", model.hy_jfsz_day_val, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle ,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_day_val));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_day_val' ");
sb.Append(" END ");
sb.Append(" ");
}
}
else
{
//判断如果数据库中存在有值的数据 清空
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_day_nbjf' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_day_nbjf' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_day_val' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_day_val' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
}
//满金额
if (!string.IsNullOrEmpty(model.hy_jfsz_xs_nbjf))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_xs_nbjf') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_xs_nbjf' ", model.hy_jfsz_xs_nbjf, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_xs_nbjf));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_xs_nbjf' ");
sb.Append(" END ");
sb.Append(" ");
//请选择金额积分倍数的开始时间
if (!string.IsNullOrEmpty(model.hy_jfsz_xs_rq_b))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_xs_rq_b') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_xs_rq_b' ", model.hy_jfsz_xs_rq_b, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_xs_rq_b));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_xs_rq_b' ");
sb.Append(" END ");
sb.Append(" ");
}
//请选择金额积分倍数的结束时间
if (!string.IsNullOrEmpty(model.hy_jfsz_xs_rq_e))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_xs_rq_e') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_xs_rq_e' ", model.hy_jfsz_xs_rq_e, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle ,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_xs_rq_e));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_xs_rq_e' ");
sb.Append(" END ");
sb.Append(" ");
}
//请选择金额积分倍数的消费满金额
if (!string.IsNullOrEmpty(model.hy_jfsz_xs_je))
{
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_xs_je') ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_xs_je' ", model.hy_jfsz_xs_je, model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(" ELSE BEGIN ");
sb.Append(" INSERT INTO ts_parm_shop (id_masteruser,id,id_shop,parmcode,parmname,parmvalue,regex,version,parmdescribe,sort_id,flag_editstyle,flag_type) ");
sb.Append(string.Format(" SELECT TOP 1 '{0}',NEWID() id,'{1}',parmcode,parmname,'{2}',regex,version,parmdescribe,sort_id,flag_editstyle ,'20' as flag_type from ts_parm_shop ", model.id_masteruser, model.id_shop, model.hy_jfsz_xs_je));
sb.Append(" WHERE id_masteruser='******' and id_shop='0' and parmcode='hy_jfsz_xs_je' ");
sb.Append(" END ");
sb.Append(" ");
}
}
else
{
//判断如果数据库中存在有值的数据 清空
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_xs_nbjf' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_xs_nbjf' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_xs_rq_b' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_xs_rq_b' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_xs_rq_e' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_xs_rq_e' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
sb.Append(string.Format(" IF EXISTS(SELECT ID FROM ts_parm_shop where id_masteruser='******' and id_shop='{1}' and parmcode='hy_jfsz_xs_je' and isnull(parmvalue,'')!='' ) ", model.id_masteruser, model.id_shop));
sb.Append(" BEGIN ");
sb.Append(string.Format(" UPDATE ts_parm_shop set parmvalue='{0}' where id_masteruser='******' and id_shop='{2}' and parmcode='hy_jfsz_xs_je' and isnull(parmvalue,'')!='' ", "", model.id_masteruser, model.id_shop));
sb.Append(" END ");
}
dataMapper.Insert("DataTools.ExecuteSql", sb.ToString());
}
catch (DataMapperException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
