public string WeixinConPass(string openid, int comid)
{
using (var helper = new SqlHelper())
{
var crmid = new InternalB2bCrm(helper).WeixinConPass(openid, comid);
return(crmid.ToString());
}
}
public DataTable GetCrmStatistics(int comid, int channelcompanyid)
{
using (var helper = new SqlHelper())
{
DataTable dt = new InternalB2bCrm(helper).GetCrmStatistics(comid, channelcompanyid);
return(dt);
}
}
public int GetComidByOpenid(string openid)
{
using (var helper = new SqlHelper())
{
int r = new InternalB2bCrm(helper).GetComidByOpenid(openid);
return(r);
}
}
public string GetNameorImgByid(int id, int type)
{
using (var helper = new SqlHelper())
{
var r = new InternalB2bCrm(helper).GetNameorImgByid(id, type);
return(r);
}
}
public B2b_crm_location GetB2bcrmlocationByopenid(string openid)
{
using (var helper = new SqlHelper())
{
B2b_crm_location r = new InternalB2bCrm(helper).GetB2bcrmlocationByopenid(openid);
return(r);
}
}
/// <summary>
/// 进入分销免登陆账户
/// </summary>
/// <param name="openid"></param>
/// <param name="freelandingaccount"></param>
public int UpFreelandingAccount(string openid, string freelandingaccount)
{
using (var helper = new SqlHelper())
{
int r = new InternalB2bCrm(helper).UpFreelandingAccount(openid, freelandingaccount);
return(r);
}
}
/// <summary>
/// 调整用户等积分;记录等积分调整日志；同时根据等积分变动调整会员级别（会员级别只增不降）
/// </summary>
/// <param name="id"></param>
/// <param name="dengjifen"></param>
/// <returns></returns>
public int Adjust_dengjifen(B2bcrm_dengjifenlog djflog, int id, int comid, decimal dengjifen)
{
using (var helper = new SqlHelper())
{
int r = new InternalB2bCrm(helper).Adjust_dengjifen(djflog, id, comid, dengjifen);
return(r);
}
}
/// <summary>
/// 根据微信号 修改用户的微信关注状态和 激活状态
/// </summary>
/// <param name="comid"></param>
/// <param name="weixin"></param>
/// <param name="whetherwxfocus"></param>
/// <param name="whetheractivate"></param>
/// <returns></returns>
public int UpWxsubstate(int comid, string weixin, int whetherwxfocus, int whetheractivate)
{
using (var helper = new SqlHelper())
{
int r = new InternalB2bCrm(helper).UpWxsubstate(comid, weixin, whetherwxfocus, whetheractivate);
return(r);
}
}
/// <summary>
/// 记录微信用户最后一次互动时间
/// </summary>
/// <param name="comid"></param>
/// <param name="weixin"></param>
/// <param name="dateTime"></param>
/// <returns></returns>
public int RecordInteracttime(int comid, string weixin, DateTime dateTime)
{
using (var helper = new SqlHelper())
{
int r = new InternalB2bCrm(helper).RecordInteracttime(comid, weixin, dateTime);
return(r);
}
}
public int GetWeiXinAttentionNum(int comid)
{
using (var helper = new SqlHelper())
{
int num = new InternalB2bCrm(helper).GetWeiXinAttentionNum(comid);
return(num);
}
}
public B2b_crm GetB2bCrmByPhone(int comid, string Phone)
{
using (var helper = new SqlHelper())
{
B2b_crm crm = new InternalB2bCrm(helper).GetB2bCrmByPhone(comid, Phone);
return(crm);
}
}
private B2b_crm_location GetGuwenLocationByVipweixin(string openid, int comid)
{
using (var helper = new SqlHelper())
{
B2b_crm_location r = new InternalB2bCrm(helper).GetGuwenLocationByVipweixin(openid, comid);
return(r);
}
}
//项目坐标
public string GetProjDistanceByid(int projid)
{
using (var helper = new SqlHelper())
{
var crm = new InternalB2bCrm(helper).GetProjDistanceByid(projid);
return(crm);
}
}
public int GetMemberChannelcompanyIdByB2bCrmId(int crmid)
{
using (var helper = new SqlHelper())
{
var crm = new InternalB2bCrm(helper).GetMemberChannelcompanyIdByB2bCrmId(crmid);
return(crm);
}
}
//用户坐标坐标
public string GetB2bCrmDistanceByid(string openid)
{
using (var helper = new SqlHelper())
{
var crm = new InternalB2bCrm(helper).GetB2bCrmDistanceByid(openid);
return(crm);
}
}
public List <B2b_crm> GetB2bCrmWeixinByComid(int comid, string country = "", string province = "", string city = "", string sex = "", int tagtype = 0, int tag = 0, string groupid = "全部")
{
using (var helper = new SqlHelper())
{
List <B2b_crm> list = new InternalB2bCrm(helper).GetB2bCrmWeixinByComid(comid, country, province, city, sex, tagtype, tag, groupid);
return(list);
}
}
public bool IsCompanyCrm(string openid, int comid)
{
using (var helper = new SqlHelper())
{
bool result = new InternalB2bCrm(helper).IsCompanyCrm(openid, comid);
return(result);
}
}
public List <string> Getqunfaphone(int comid, out int total, string qunfanum = "-1")
{
using (var helper = new SqlHelper())
{
List <string> result = new InternalB2bCrm(helper).Getqunfaphone(comid, out total, qunfanum);
return(result);
}
}
public List <B2b_crm> GetB2bCrmWeixinByMenshi(int menshiid, string country = "", string province = "", string city = "", string sex = "", int tagtype = 0, int tag = 0)
{
using (var helper = new SqlHelper())
{
List <B2b_crm> list = new InternalB2bCrm(helper).GetB2bCrmWeixinByMenshi(menshiid, country, province, city, sex, tagtype, tag);
return(list);
}
}
public bool IsHasCrmPhone(int comid, string phone)
{
using (var helper = new SqlHelper())
{
bool result = new InternalB2bCrm(helper).IsHasCrmPhone(comid, phone);
return(result);
}
}
public B2b_crm GetB2bCrmById(int crmid)
{
using (var helper = new SqlHelper())
{
B2b_crm crm = new InternalB2bCrm(helper).GetB2bCrmById(crmid);
return(crm);
}
}
public bool IsHasCrmWeiXin(int comid, string weixin)
{
using (var helper = new SqlHelper())
{
bool result = new InternalB2bCrm(helper).IsHasCrmWeiXin(comid, weixin);
return(result);
}
}
public string GetWeiXinByCrmid(int crmid)
{
using (var helper = new SqlHelper())
{
string r = new InternalB2bCrm(helper).Getweixinbycrmid(crmid);
return(r);
}
}
//门市坐标
public string GetChannelDistanceByid(int channelid)
{
using (var helper = new SqlHelper())
{
var crm = new InternalB2bCrm(helper).GetChannelDistanceByid(channelid);
return(crm);
}
}
public int CoverRegion(string openid, string Country, string Province, string City)
{
using (var helper = new SqlHelper())
{
int result = new InternalB2bCrm(helper).CoverRegion(openid, Country, Province, City);
return(result);
}
}
public string Getkey(string key)
{
using (var helper = new SqlHelper())
{
var list = new InternalB2bCrm(helper).Getkey(key);
return(list);
}
}
/// <summary>
/// excel导入其他商家的会员
/// </summary>
/// <param name="comid"></param>
/// <param name="cardcode"></param>
/// <param name="name"></param>
/// <param name="phone"></param>
/// <param name="weixin"></param>
/// <param name="whetherwxfocus"></param>
/// <param name="whetheractivate"></param>
/// <param name="registertime"></param>
/// <returns></returns>
public int ExcelInsB2bCrm(int comid, string cardcode, string name, string phone, string weixin, int whetherwxfocus, int whetheractivate, string registertime, string email, decimal imprest, decimal integral, string country, string province, string city, string address, string agegroup, string crmlevel)
{
using (var helper = new SqlHelper())
{
int id = new InternalB2bCrm(helper).ExcelInsB2bCrm(comid, cardcode, name, phone, weixin, whetherwxfocus, whetheractivate, registertime, email, imprest, integral, country, province, city, address, agegroup, crmlevel);
return(id);
}
}
/// <summary>
/// 修改会员的激活状态
/// </summary>
/// <param name="weixin"></param>
/// <param name="comid"></param>
/// <param name="activatestate"></param>
/// <returns></returns>
public int ModifyCrmActivate(string weixin, int comid, int activatestate)
{
using (var helper = new SqlHelper())
{
int id = new InternalB2bCrm(helper).ModifyCrmActivate(weixin, comid, activatestate);
return(id);
}
}
public bool GetWeixin(string openid, int comid)
{
using (var helper = new SqlHelper())
{
var list = new InternalB2bCrm(helper).GetWeixin(openid, comid);
return(list);
}
}
public B2b_crm GetB2bCrm(string openid, int comid)
{
using (var helper = new SqlHelper())
{
var pro = new InternalB2bCrm(helper).GetB2bCrm(openid, comid);
return(pro);
}
}
