internal WxSubscribeSource GetReserveproVerifywxqrcode(int comid, int qrcodeviewtype)
{
string sql = "select * from WxSubscribeSource where comid=" + comid + " and qrcodeviewtype=" + qrcodeviewtype + " and comid>0 and qrcodeviewtype>0";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
using (var reader = cmd.ExecuteReader())
{
WxSubscribeSource m = null;
if (reader.Read())
{
m = new WxSubscribeSource
{
Id = reader.GetValue <int>("id"),
Sourcetype = reader.GetValue <int>("sourcetype"),
Activityid = reader.GetValue <int>("activityid"),
Channelcompanyid = reader.GetValue <int>("channelcompanyid"),
viewchannelcompanyid = reader.GetValue <int>("viewchannelcompanyid"),
Comid = reader.GetValue <int>("comid"),
Ticket = reader.GetValue <string>("ticket"),
Title = reader.GetValue <string>("title"),
Qrcodeurl = reader.GetValue <string>("qrcodeurl"),
Createtime = reader.GetValue <DateTime>("createtime"),
Onlinestatus = Convert.IsDBNull(reader.GetValue(9)) == true ? true : reader.GetValue <bool>("onlinestatus"),
Channelid = reader.GetValue <int>("channelid"),
Productid = reader.GetValue <int>("productid"),
qrcodeviewtype = reader.GetValue <int>("qrcodeviewtype"),
projectid = reader.GetValue <int>("projectid"),
wxmaterialtypeid = reader.GetValue <int>("wxmaterialtypeid"),
Wxmaterialid = reader.GetValue <int>("Wxmaterialid"),
};
}
return(m);
}
}
internal WxSubscribeSource GetWXSourceByChannelcompanyid(int channelcompanyid)
{
string sql = "select * from WxSubscribeSource where sourcetype=2 and channelcompanyid=" + channelcompanyid + " and channelid=0 and onlinestatus=1 ";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
using (var reader = cmd.ExecuteReader())
{
WxSubscribeSource m = null;
if (reader.Read())
{
m = new WxSubscribeSource
{
Id = reader.GetValue <int>("id"),
Sourcetype = reader.GetValue <int>("sourcetype"),
Activityid = reader.GetValue <int>("activityid"),
Channelcompanyid = reader.GetValue <int>("channelcompanyid"),
Comid = reader.GetValue <int>("comid"),
Ticket = reader.GetValue <string>("ticket"),
Title = reader.GetValue <string>("title"),
Qrcodeurl = reader.GetValue <string>("qrcodeurl"),
Createtime = reader.GetValue <DateTime>("createtime"),
Onlinestatus = Convert.IsDBNull(reader.GetValue(9)) == true ? true : reader.GetValue <bool>("onlinestatus"),
Channelid = reader.GetValue <int>("channelid"),
Productid = reader.GetValue <int>("productid")
};
}
return(m);
}
}
public int EditSubscribeSource(WxSubscribeSource source)
{
using (var helper = new SqlHelper())
{
var list = new InternalWxSubscribeSource(helper).EditSubscribeSource(source);
return(list);
}
}
internal int EditSubscribeSource(WxSubscribeSource source)
{
var cmd = sqlHelper.PrepareStoredSqlCommand("usp_InsertOrUpdateWxSubscribeSource");
cmd.AddParam("@id", source.Id);
cmd.AddParam("@sourcetype", source.Sourcetype);
cmd.AddParam("@channelcompanyid", source.Channelcompanyid);
cmd.AddParam("@activityid", source.Activityid);
cmd.AddParam("@comid", source.Comid);
cmd.AddParam("@ticket", source.Ticket);
var parm = cmd.AddReturnValueParameter("ReturnValue");
cmd.ExecuteNonQuery();
return((int)parm.Value);
}
internal WxSubscribeSource Getchannelwxqrcodebychannelid(int channelid)
{
string sql = "select * from WxSubscribeSource where channelid=" + channelid;
//判断渠道是否有二维码
int num = Getqrcodenumbychannelid(channelid);
if (num == 0)
{
int isdefaultchannel = 0;
int channelcompanyid = 0;
//如果渠道是默认渠道，则查询门店二维码
Member_Channel mcompany = new MemberChannelData().GetChannelDetail(channelid);
if (mcompany != null)
{
if (mcompany.Whetherdefaultchannel == 1)
{
isdefaultchannel = 1;
channelcompanyid = mcompany.Companyid;
}
}
if (isdefaultchannel == 1)
{
sql = "select * from WxSubscribeSource where channelcompanyid=" + channelcompanyid + " and channelid=0 and channelcompanyid>0";
}
}
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
using (var reader = cmd.ExecuteReader())
{
WxSubscribeSource m = null;
if (reader.Read())
{
m = new WxSubscribeSource
{
Id = reader.GetValue <int>("id"),
Sourcetype = reader.GetValue <int>("sourcetype"),
Activityid = reader.GetValue <int>("activityid"),
Channelcompanyid = reader.GetValue <int>("channelcompanyid"),
viewchannelcompanyid = reader.GetValue <int>("viewchannelcompanyid"),
Comid = reader.GetValue <int>("comid"),
Ticket = reader.GetValue <string>("ticket"),
Title = reader.GetValue <string>("title"),
Qrcodeurl = reader.GetValue <string>("qrcodeurl"),
Createtime = reader.GetValue <DateTime>("createtime"),
Onlinestatus = Convert.IsDBNull(reader.GetValue(9)) == true ? true : reader.GetValue <bool>("onlinestatus"),
Channelid = reader.GetValue <int>("channelid"),
Productid = reader.GetValue <int>("productid"),
qrcodeviewtype = reader.GetValue <int>("qrcodeviewtype"),
projectid = reader.GetValue <int>("projectid"),
wxmaterialtypeid = reader.GetValue <int>("wxmaterialtypeid"),
Wxmaterialid = reader.GetValue <int>("Wxmaterialid"),
choujiangactid = reader.GetValue <int>("choujiangactid"),
};
}
return(m);
}
}
