internal WxSubscribeDetail GetWXSourceByOpenId(string openid)
{
string sql = @"select top 1 * from WxSubscribeDetail where openid=@openid order by id desc";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@openid", openid);
WxSubscribeDetail u = null;
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
u = new WxSubscribeDetail
{
Id = reader.GetValue <int>("id"),
Openid = reader.GetValue <string>("Openid"),
Subscribesourceid = reader.GetValue <int>("Subscribesourceid"),
Subscribetime = reader.GetValue <DateTime>("subscribetime"),
Comid = reader.GetValue <int>("comid"),
Eevent = reader.GetValue <string>("event"),
Eventkey = reader.GetValue <string>("eventkey")
};
}
}
return(u);
}
public int EditSubscribeDetail(WxSubscribeDetail model)
{
using (var helper = new SqlHelper())
{
int data = new InternalWxSubscribeDetail(helper).EditSubscribeDetail(model);
return(data);
}
}
internal int EditSubscribeDetail(WxSubscribeDetail model)
{
string sql = @"INSERT INTO [EtownDB].[dbo].[WxSubscribeDetail]
([openid]
,[subscribetime]
,[subscribesourceid]
,[event]
,[eventkey]
,[comid]
,createtime)
VALUES
(@openid
,@subscribetime
,@subscribesourceid
,@event
,@eventkey
,@comid
,@createtime)";
if (model.Id > 0)
{
sql = @"UPDATE [EtownDB].[dbo].[WxSubscribeDetail]
SET [openid] = @openid
,[subscribetime] = @subscribetime
,[subscribesourceid] = @subscribesourceid
,[event] = @event
,[eventkey] = @eventkey
,[comid] = @comid
,createtime=@createtime
WHERE id=@id";
}
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@openid", model.Openid);
cmd.AddParam("@subscribetime", model.Subscribetime);
cmd.AddParam("@subscribesourceid", model.Subscribesourceid);
cmd.AddParam("@event", model.Eevent);
cmd.AddParam("@eventkey", model.Eventkey);
cmd.AddParam("@comid", model.Comid);
cmd.AddParam("@id", model.Id);
cmd.AddParam("@createtime", model.Createtime);
return(cmd.ExecuteNonQuery());
}
