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