public static string EditActInfo(Member_Activity actinfo)
{
try
{
var pro = MemberActivityData.EditActInfo(actinfo);
//if (actinfo.Id == 0)
//{
// WxSubscribeSource source = new WxSubscribeSource
// {
// Id = 0,
// Activityid = pro,
// Channelcompanyid = 0,
// Sourcetype = 1,
// Comid = actinfo.Com_id,
// Whethercreateqrcode = false
// };
// int dd = new WxSubscribeSourceData().EditSubscribeSource(source);
//}
return(JsonConvert.SerializeObject(new { type = 100, msg = pro }));
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
public string EconfirmCard(int aid, int actid, int cardid, int comid, out Member_Activity actinfo, out string phone, out string name, out decimal idcard, out decimal agcardcode)
{
using (var sql = new SqlHelper())
{
try
{
var cardinfo = new InternalMemberCard(sql).EconfirmCard(aid, actid, cardid, comid, out actinfo, out phone, out name, out idcard, out agcardcode);
return cardinfo;
}
catch
{
throw;
}
}
}
public static string EconfirmCard(int aid, int actid, int cardid, int comid, out Member_Activity actinfo, out string phone, out string name, out decimal idcard, out decimal agcardcode)
{
try
{
MemberCardData carddate = new MemberCardData();
var pro = carddate.EconfirmCard(aid, actid, cardid, comid, out actinfo, out phone, out name, out idcard, out agcardcode);
Member_Channel channel = new MemberChannelData().GetChannelDetailByCardNo(idcard.ToString());//根据卡号得到所属渠道的详细信息
if (channel != null)
{
//给渠道表中 开卡数量和总金额赋值
channel.Firstdealnum = channel.Firstdealnum + 1;
channel.Summoney = channel.Summoney + channel.RebateConsume;
var channeldata = new MemberChannelData().EditChannel(channel);
//把返佣日志录入渠道返佣日志表
ChannelRebateLog channelrebatelog = new ChannelRebateLog()
{
Id = 0,
Channelid = channel.Id,
Execdate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
Rebatemoney = channel.RebateConsume,
Type = (int)ChannelRebateType.FirstDeal,
Summoney = channel.Summoney,
Remark = "消费返佣" + channel.RebateConsume + "元"
};
var channelrebatelogret = new ChannelRebateLogData().EditChannelRebateLog(channelrebatelog);
}
return(JsonConvert.SerializeObject(new { type = 100, actinfo = actinfo, phone = phone, name = name, idcard = idcard, agcardcode = agcardcode, msg = pro }));
}
catch (Exception ex)
{
actinfo = null;
phone = "";
name = "";
idcard = 0;
agcardcode = 0;
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
public static int EditActInfo(Member_Activity actinfo)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalMemberActivity(sql);
int result = internalData.InsertOrUpdate(actinfo);
return(result);
}
catch
{
throw;
}
}
}
public static Member_Activity GetActById(int actid)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalMemberActivity(sql);
Member_Activity result = internalData.GetActById(actid);
return(result);
}
catch
{
throw;
}
}
}
internal string EconfirmCard(int aid, int actid, int cardid, int comid, out Member_Activity actinfo, out string phone, out string name, out decimal idcard, out decimal agcardcode)
{
string sqltxt = "";
sqltxt = @"select a.id,b.id as aid,a.ReturnAct,b.cardid,a.com_id,a.title,a.Acttype,a.discount,a.money,a.cashfull,a.cashback,a.faceobjects,a.repeatissue,a.returnact,a.useonce,a.actstar,a.actend,a.runstate,b.USEstate,b.Actnum,d.name,d.idcard,d.phone,e.cardcode from Member_Activity as a left join Member_Card_Activity as b on a.id=b.actid left join member_card as c on b.cardid=c.id left join b2b_crm as d on c.cardcode=d.idcard and c.com_id=d.com_id left join member_channel as e on c.issuecard=e.id and e.com_id=e.com_id where a.com_id=@comid and b.id=@aid and b.cardid=@cardid and b.USEstate=1 order by a.id desc";
var cmd = this.sqlHelper.PrepareTextSqlCommand(sqltxt);
cmd.AddParam("@aid", aid);
cmd.AddParam("@comid", comid);
cmd.AddParam("@cardid", cardid);
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
actinfo = new Member_Activity
{
Id = reader.GetValue <int>("Id"),
Com_id = reader.GetValue <int>("Com_id"),
Title = reader.GetValue <string>("title"),
Money = reader.GetValue <decimal>("money"),
Acttype = reader.GetValue <int>("Acttype"),
//Cashback = reader.GetValue<int>("Cashback"),
//CashFull = reader.GetValue<int>("CashFull"),
//Discount = reader.GetValue<double>("Discount"),
Actnum = reader.GetValue <int>("Actnum"),
Runstate = reader.GetValue <bool>("Runstate"),
};
phone = reader.GetValue <string>("phone");
name = reader.GetValue <string>("name");
idcard = reader.GetValue <decimal>("idcard");
agcardcode = reader.GetValue <decimal>("cardcode");
int ReturnAct = reader.GetValue <int>("ReturnAct");
reader.Close();
//修改活动状态
sqltxt = @"update member_card_activity set Actnum=0,USEstate=2,USEsubdate=@subdate where id=@aid";
var cmd1 = this.sqlHelper.PrepareTextSqlCommand(sqltxt);
cmd1.AddParam("@aid", aid);
cmd1.AddParam("@subdate", DateTime.Now);
cmd1.ExecuteNonQuery();
//赠送活动
if (ReturnAct != 0)
{
sqltxt = @"insert member_card_activity (cardid,actid) values (@cardid,@ReturnAct)";
var cmd2 = this.sqlHelper.PrepareTextSqlCommand(sqltxt);
cmd2.AddParam("@cardid", cardid);
cmd2.AddParam("@ReturnAct", ReturnAct);
cmd2.ExecuteNonQuery();
}
return("OK");
}
else
{
actinfo = null;
phone = "";
name = "";
idcard = 0;
agcardcode = 0;
return("此账户使用优惠活动错误，请重新操作！");
}
}
}
public static string AccountClaimActPageList(int aid, int cardid, int AccountId, int comid)
{
int totalcount = 0;
var aaid = 0;
var ret = "";
try
{
if (cardid != 0)
{
//查询优惠券
MemberActivityData Activitydata = new MemberActivityData();
Member_Activity Activitymodel = Activitydata.GetMemberActivityById(aid);
if (Activitymodel != null)
{
if (Activitymodel.Runstate == false)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "活动已结束" }));
}
var today = DateTime.Now;
if (Activitymodel.Actstar < today && Activitymodel.Actend.AddDays(1) > today)
{
}
else
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "活动已结束" }));
}
}
//每个活动只能领取一次，防止重复领取，
var listact = Activitydata.AccountActInfo(aid, AccountId, comid, out totalcount);
if (listact == null)
{
//领取活动
aaid = Activitydata.AccountClaimActPageList(aid, cardid, comid);
if (aaid != 0)
{
if (Activitymodel != null)
{
if (Activitymodel.Acttype == 4)//只有积分优惠券才会领取时充入积分
{
MemberIntegralData intdate = new MemberIntegralData();
Member_Integral Intinfo = new Member_Integral()
{
Id = AccountId,
Comid = comid,
Acttype = "add_integral", //操作类型,增加积分
Money = Activitymodel.Money, //交易金额
Admin = "领取积分优惠券",
Ip = "",
Ptype = 1,
Oid = 0,
Remark = "",
OrderId = 0,
OrderName = Activitymodel.Atitle
};
var InsertIntegral = intdate.InsertOrUpdate(Intinfo);
//优惠券确认使用
Member_Activity actinfo = null;
string phone = "";
string name = "";
decimal idcard = 0;
decimal aggcardcode = 0;
MemberCardData carddata = new MemberCardData();
var confirm = carddata.EconfirmCard(aaid, aid, cardid, comid, out actinfo, out phone, out name, out idcard, out aggcardcode);
B2bCrmData prodata = new B2bCrmData();
var list = prodata.Readuser(AccountId, comid);
//微信消息模板
if (list.Weixin != "")
{
new Weixin_tmplmsgManage().WxTmplMsg_CrmIntegralReward(list.Com_id, list.Weixin, "您好，" + AccountId + " 积分已经打入您的账户", list.Idcard.ToString(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "活动赠送", Intinfo.Money.ToString(), list.Integral.ToString(), "如有疑问，请致电客服。");
}
}
}
}
ret = "OK";
}
else
{
ret = "已领取活动";
}
return(JsonConvert.SerializeObject(new { type = 100, msg = ret }));
}
else
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "Unlogin" }));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string oper = context.Request["oper"].ConvertTo <string>("");
if (oper != "")
{
if (oper == "getActById")
{
int actid = context.Request["actid"].ConvertTo <int>(0);
var data = PromotionJsonDate.GetActById(actid);
context.Response.Write(data);
}
if (oper == "WhetherEditById")
{
int actid = context.Request["actid"].ConvertTo <int>(0);
int operuserid = context.Request["operuserid"].ConvertTo <int>(0);
var data = PromotionJsonDate.WhetherEditByIdJson(actid, operuserid);
context.Response.Write(data);
}
if (oper == "editActinfo")
{
var title = context.Request["title"].ConvertTo <string>("");
var comid = context.Request["comid"].ConvertTo <int>(0);
var Acttype = context.Request["Acttype"].ConvertTo <int>(0);
var Money = context.Request["Money"].ConvertTo <int>(0);
var Discount = context.Request["Discount"].ConvertTo <int>(0);
var CashFull = context.Request["CashFull"].ConvertTo <int>(0);
var Cashback = context.Request["Cashback"].ConvertTo <int>(0);
var UseOnce = context.Request["UseOnce"].ConvertTo <bool>();
var RepeatIssue = context.Request["RepeatIssue"].ConvertTo <int>(1);
var Actstar = context.Request["Actstar"].ConvertTo <DateTime>();
var Actend = context.Request["Actend"].ConvertTo <DateTime>();
var FaceObjects = context.Request["FaceObjects"].ConvertTo <int>(1);
var ReturnAct = context.Request["ReturnAct"].ConvertTo <int>(0);
var Id = context.Request["actid"].ConvertTo <int>(0);
var Runstate = context.Request["runstate"].ConvertTo <bool>();
var Atitle = context.Request["atitle"].ConvertTo <string>("");
var Remark = context.Request["remark"].ConvertTo <string>("");
var Useremark = context.Request["useremark"].ConvertTo <string>("");
var Usetitle = context.Request["usetitle"].ConvertTo <string>("");
var UseChannel = context.Request["UseChannel"].ConvertTo <string>("0");
int createuserid = context.Request["createuserid"].ConvertTo <int>(0);
Member_Activity manageuser = new Member_Activity()
{
Id = Id,
Com_id = comid,
Title = title,
Acttype = Acttype,
Money = Money,
Discount = Discount,
CashFull = CashFull,
Cashback = Cashback,
UseOnce = UseOnce,
RepeatIssue = RepeatIssue,
Actstar = Actstar,
Actend = Actend,
FaceObjects = FaceObjects,
ReturnAct = ReturnAct,
Runstate = Runstate,
Atitle = Atitle,
Remark = Remark,
Useremark = Useremark,
Usetitle = Usetitle,
Usechannel = UseChannel,
CreateUserId = createuserid,
CreateTime = DateTime.Now
};
var data = PromotionJsonDate.EditActInfo(manageuser);
context.Response.Write(data);
}
if (oper == "pagelist")
{
var comid = context.Request["comid"];
var pageindex = context.Request["pageindex"].ConvertTo <int>(0);
var pagesize = context.Request["pagesize"].ConvertTo <int>(10);
int userid = context.Request["userid"].ConvertTo <int>(0);
string state = context.Request["state"].ConvertTo <string>("0,1");
string data = PromotionJsonDate.ActPageList(comid, pageindex, pagesize, userid, state);
context.Response.Write(data);
}
if (oper == "ERNIEgetActById")
{
int actid = context.Request["actid"].ConvertTo <int>(0);
var data = PromotionJsonDate.ERNIEGetActById(actid);
context.Response.Write(data);
}
if (oper == "ERNIEeditActinfo")
{
var title = context.Request["title"].ConvertTo <string>("");
var comid = context.Request["comid"].ConvertTo <int>(0);
var ERNIE_type = context.Request["ERNIE_type"].ConvertTo <int>(1);
var ERNIE_RateNum = context.Request["ERNIE_RateNum"].ConvertTo <int>(10000);
var ERNIE_Limit = context.Request["ERNIE_Limit"].ConvertTo <int>(0);
var Limit_Num = context.Request["Limit_Num"].ConvertTo <int>(0);
var runstate = context.Request["Runstate"].ConvertTo <int>(0);
var ERNIE_star = context.Request["ERNIE_star"].ConvertTo <DateTime>();
var ERNIE_end = context.Request["ERNIE_end"].ConvertTo <DateTime>();
var Id = context.Request["actid"].ConvertTo <int>(0);
var Remark = context.Request["Remark"].ConvertTo <string>("");
var Award_title = context.Request["Award_title"].ConvertTo <string>("");
var Award_num = context.Request["Award_num"].ConvertTo <int>(0);
var Award_type = context.Request["Award_type"].ConvertTo <int>(0);
var Award_Get_Num = context.Request["Award_Get_Num"].ConvertTo <int>(0);
List <Member_ERNIE_Award> Awardlist = new List <Member_ERNIE_Award>();
for (int i = 0; i < 6; i++)
{
Awardlist.Add(new Member_ERNIE_Award()
{
Award_title = context.Request["Award_title" + i].ConvertTo <string>(""),
Award_num = context.Request["Award_num" + i].ConvertTo <int>(1),
Award_type = context.Request["Award_type" + i].ConvertTo <int>(0),
Award_Get_Num = context.Request["Award_Get_Num" + i].ConvertTo <int>(0),
});
}
Member_ERNIE manageuser = new Member_ERNIE()
{
Id = Id,
Com_id = comid,
Title = title,
ERNIE_type = ERNIE_type,
ERNIE_RateNum = ERNIE_RateNum,
ERNIE_Limit = ERNIE_Limit,
Limit_Num = Limit_Num,
Runstate = runstate,
ERNIE_star = ERNIE_star,
ERNIE_end = ERNIE_end,
Remark = Remark
};
var data = PromotionJsonDate.ERNIEEditActInfo(manageuser, Awardlist);
context.Response.Write(data);
}
if (oper == "ERNIEActpagelist")
{
var comid = context.Request["comid"];
var pageindex = context.Request["pageindex"].ConvertTo <int>(0);
var pagesize = context.Request["pagesize"].ConvertTo <int>(10);
var runstate = context.Request["runstate"].ConvertTo <string>("0,1");
string data = PromotionJsonDate.ERNIEActPageList(comid, pageindex, pagesize, runstate);
context.Response.Write(data);
}
if (oper == "ERNIEgetAwardById")
{
int actid = context.Request["actid"].ConvertTo <int>(0);
var data = PromotionJsonDate.ERNIEGetAwardById(actid);
context.Response.Write(data);
}
if (oper == "ERNIERecordpagelist")
{
var comid = context.Request["comid"];
var pageindex = context.Request["pageindex"].ConvertTo <int>(0);
var pagesize = context.Request["pagesize"].ConvertTo <int>(10);
var actid = context.Request["actid"].ConvertTo <int>(0);
var ERNIE_type = context.Request["ERNIE_type"].ConvertTo <int>(9);
var key = context.Request["key"].ConvertTo <string>("");
string data = PromotionJsonDate.ERNIERecordpagelist(comid, pageindex, pagesize, actid, ERNIE_type, key);
context.Response.Write(data);
}
if (oper == "ERNIERecordedit")
{
var actid = context.Request["actid"].ConvertTo <int>(0);
var data = PromotionJsonDate.ERNIERecordedit(actid);
context.Response.Write(data);
}
if (oper == "ERNIEAwardget")
{
int actid = context.Request["actid"].ConvertTo <int>(0);
int topclass = context.Request["topclass"].ConvertTo <int>(0);
var data = PromotionJsonDate.ERNIEAwardget(actid, topclass);
context.Response.Write(data);
}
if (oper == "ERNIEeditAwardinfo")
{
var Id = context.Request["Id"].ConvertTo <int>(0);
var ERNIE_id = context.Request["ERNIE_id"].ConvertTo <int>(0);
var Award_class = context.Request["Award_class"].ConvertTo <int>(1);
var Award_num = context.Request["Award_num"].ConvertTo <int>(10000);
var Award_type = context.Request["Award_type"].ConvertTo <int>(0);
var Award_Get_Num = context.Request["Award_Get_Num"].ConvertTo <int>(0);
var Award_title = context.Request["Award_title"].ConvertTo <string>("");
Member_ERNIE_Award manageuser = new Member_ERNIE_Award()
{
Id = Id,
ERNIE_id = ERNIE_id,
Award_class = Award_class,
Award_num = Award_num,
Award_type = Award_type,
Award_Get_Num = Award_Get_Num,
Award_title = Award_title
};
var data = PromotionJsonDate.ERNIEEditAwardInfo(manageuser);
context.Response.Write(data);
}
if (oper == "ERNIEAwardpagelist")
{
var actid = context.Request["actid"].ConvertTo <int>(0);
var pageindex = context.Request["pageindex"].ConvertTo <int>(0);
var pagesize = context.Request["pagesize"].ConvertTo <int>(10);
string data = PromotionJsonDate.ERNIEAwardPageList(actid, pageindex, pagesize);
context.Response.Write(data);
}
if (oper == "ERNIEeditActOnline")
{
var actid = context.Request["actid"].ConvertTo <int>(0);
var data = PromotionJsonDate.ERNIEeditActOnline(actid);
context.Response.Write(data);
}
}
}
public string comlogo = ""; //公司logo地址
protected void Page_Load(object sender, EventArgs e)
{
openid = Request["openid"];
act = Request["act"];
aid = Request["aid"].ToString();
RequestUrl = Request.ServerVariables["SERVER_NAME"].ToLower();
//如果SESSION有值，进行赋值
if (openid == "" && Session["Openid"] != null)
{
openid = Session["Openid"].ToString();
}
//根据域名读取商户ID,如果没有绑定域名直接跳转后台
if (Domain_def.Domain_yanzheng(RequestUrl))//如果符合shop101.etown.cn的格式，则从多微信商户基本信息表中获取comid
{
//先通过正则表达式获取COMid
comid = Int32.Parse(Domain_def.Domain_Huoqu(RequestUrl).ToString());
if (comid == 0)
{
comid = new WeiXinBasicData().GetWeiXinBasicByDomain(RequestUrl).Comid;
}
}
else
{
B2b_company_info companyinfo = B2bCompanyData.GetComId(RequestUrl);
if (companyinfo != null)
{
comid = companyinfo.Com_id;
}
}
if (comid != 0)
{
//根据公司id得到公司logo地址和公司名称
comname = B2bCompanyData.GetCompany(comid).Com_name;
B2b_company_saleset pro = B2bCompanySaleSetData.GetDirectSellByComid(comid.ToString());
if (pro != null)
{
comlogo = FileSerivce.GetImgUrl(pro.Logo.ConvertTo <int>(0));
}
}
//如果账户登陆状态则读取用户信息
if (Session["AccountId"] != null)
{
//获取用户卡号
B2bCrmData crmdate = new B2bCrmData();
B2b_crm crmmodle = crmdate.Readuser(Int32.Parse(Session["AccountId"].ToString()), comid);
if (crmmodle != null)
{
cardcode = crmmodle.Idcard;
}
//获取优惠劵信息 对已领的优惠劵和未领的优惠劵
if (aid != "")
{
MemberActivityData actdata = new MemberActivityData();
if (act == "A")//已领的优惠劵
{
Member_Activity actmodel = actdata.AccountActInfo(Int32.Parse(aid), Int32.Parse(Session["AccountId"].ToString()), comid, out totalcount);
if (actmodel != null)
{
Actend = actmodel.Actend.ToString("yyyy-MM-dd");
Title = actmodel.Title;
usestate = actmodel.Usestate;
Atitle = actmodel.Atitle;
Remark = actmodel.Remark.Replace(((char)10).ToString(), "<br />");
//Useremark = actmodel.Useremark;
Usetitle = actmodel.Usetitle.Replace(((char)10).ToString(), "<br />");
}
}
else
{//未领取的
Member_Activity actmodel = actdata.UnAccountActInfo(Int32.Parse(aid), 0, comid, out totalcount);
if (actmodel != null)
{
Actend = actmodel.Actend.ToString("yyyy-MM-dd");
Title = actmodel.Title;
Atitle = actmodel.Atitle;
Remark = actmodel.Remark.Replace(((char)10).ToString(), "<br />");
//Useremark = actmodel.Useremark.Replace(((char)10).ToString(), "<br />");
Usetitle = actmodel.Usetitle;
usestate = 6;
}
}
//活动使用门市
MemberChannelcompanyData chandata = new MemberChannelcompanyData();
var list = chandata.GetUnitListselected(int.Parse(aid));
if (list != null)
{
for (int i = 0; i < list.Count(); i++)
{
Useremark += list[i].Companyname + " <br>";
}
}
}
else
{
Response.Redirect("/M/Default.aspx");
}
}
else
{//非会员看未领取的
if (aid != "")
{
MemberActivityData actdata = new MemberActivityData();
Member_Activity actmodel = actdata.UnAccountActInfo(Int32.Parse(aid), 0, comid, out totalcount);
if (actmodel != null)
{
Actend = actmodel.Actend.ToString("yyyy-MM-dd");
Title = actmodel.Title;
Atitle = actmodel.Atitle;
Remark = actmodel.Remark.Replace(((char)10).ToString(), "<br />");
Useremark = actmodel.Useremark.Replace(((char)10).ToString(), "<br />");
Usetitle = actmodel.Usetitle.Length > 14 ? actmodel.Usetitle.Substring(0, 13) + "." : actmodel.Useremark;
usestate = 5;
}
}
}
}
public int InsertOrUpdate(Member_Activity model)
{
var cmd = sqlHelper.PrepareStoredSqlCommand(SQLInsertOrUpdate);
cmd.AddParam("@Id", model.Id);
cmd.AddParam("@Com_id", model.Com_id);
cmd.AddParam("@title", model.Title);
cmd.AddParam("@Acttype", model.Acttype);
cmd.AddParam("@Money", model.Money);
cmd.AddParam("@Discount", model.Discount);
cmd.AddParam("@CashFull", model.CashFull);
cmd.AddParam("@Cashback", model.Cashback);
cmd.AddParam("@UseOnce", model.UseOnce);
cmd.AddParam("@RepeatIssue", model.RepeatIssue);
cmd.AddParam("@Actstar", model.Actstar);
cmd.AddParam("@Actend", model.Actend);
cmd.AddParam("@FaceObjects", model.FaceObjects);
cmd.AddParam("@ReturnAct", model.ReturnAct);
cmd.AddParam("@Runstate", model.Runstate);
cmd.AddParam("@Atitle", model.Atitle);
cmd.AddParam("@Remark", model.Remark);
cmd.AddParam("@Useremark", model.Useremark);
cmd.AddParam("@Usetitle", model.Usetitle);
cmd.AddParam("@Createuserid", model.CreateUserId);
cmd.AddParam("@Createtime", model.CreateTime);
var parm = cmd.AddReturnValueParameter("ReturnValue");
cmd.ExecuteNonQuery();
string insertsqltxt = "";
//先删除原数据， 使用门店
insertsqltxt = "delete Member_Act_Ch_Company where actid = " + (int)parm.Value;
cmd = this.sqlHelper.PrepareTextSqlCommand(insertsqltxt);
cmd.ExecuteNonQuery();
if (model.Usechannel == "0")
{
//重新插入， 使用门店
insertsqltxt = "insert Member_Act_Ch_Company (actid,companyid) values (" + (int)parm.Value + ",0)";
cmd = this.sqlHelper.PrepareTextSqlCommand(insertsqltxt);
cmd.ExecuteNonQuery();
}
else
{
//分割后重新插入， 使用门店
string[] s = model.Usechannel.Split(new char[] { ',' });
for (int i = 0; i < s.Length; i++)
{
if (s[i].Trim() != "" && s[i].Trim() != null)
{
insertsqltxt = "insert Member_Act_Ch_Company (actid,companyid) values (" + (int)parm.Value + "," + s[i].Trim() + ")";
cmd = this.sqlHelper.PrepareTextSqlCommand(insertsqltxt);
cmd.ExecuteNonQuery();
}
}
}
return((int)parm.Value);
}
