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