public int EditLog(Wxqunfa_log log)
{
using (var helper = new SqlHelper())
{
int id = new InternalWxqunfa_log(helper).EditLog(log);
return(id);
}
}
internal int EditLog(Wxqunfa_log log)
{
string sql = @"INSERT INTO [EtownDB].[dbo].[wxqunfa_log]
([msgtype],[media_id] ,[content],[sendtime],[errcode] ,[errmsg],[msg_id] ,[userid],[channelcompanyid] ,[comid] ,[yearmonth],[yearmonthday],[weixins])
VALUES
(@msgtype
,@media_id
,@content
,@sendtime
,@errcode
,@errmsg
,@msg_id
,@userid
,@channelcompanyid
,@comid
,@yearmonth
,@yearmonthday
,@weixins);select @@IDENTITY;";
if (log.Id > 0)
{
sql = @" UPDATE [EtownDB].[dbo].[wxqunfa_log]
SET [msgtype] = @msgtype
,[media_id] = @media_id
,[content] = @content
,[sendtime] = @sendtime
,[errcode] = @errcode
,[errmsg] = @errmsg
,[msg_id] = @msg_id
,[userid] = @userid
,[channelcompanyid] = @channelcompanyid
,[comid] = @comid
,[yearmonth] = @yearmonth
,[yearmonthday] = @yearmonthday
,[weixins] = @weixins
WHERE id=@id";
}
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@msgtype", log.Msgtype);
cmd.AddParam("@media_id", log.Media_id);
cmd.AddParam("@content", log.Content);
cmd.AddParam("@sendtime", log.Sendtime);
cmd.AddParam("@errcode", log.Errcode);
cmd.AddParam("@errmsg", log.Errmsg);
cmd.AddParam("@msg_id", log.Msg_id);
cmd.AddParam("@userid", log.Userid);
cmd.AddParam("@channelcompanyid", log.Channelcompanyid);
cmd.AddParam("@comid", log.Comid);
cmd.AddParam("@yearmonth", log.Yearmonth);
cmd.AddParam("@yearmonthday", log.Yearmonthday);
cmd.AddParam("@weixins", log.Weixins);
if (log.Id > 0)
{
cmd.AddParam("@id", log.Id);
}
if (log.Id > 0)
{
cmd.ExecuteNonQuery();
return(log.Id);
}
else
{
object o = cmd.ExecuteScalar();
return(o == null ? 0 : int.Parse(o.ToString()));
}
}