internal int EditLog(Taobao_ms_requestlog log)
{
if (log.id == 0)
{
string sql = @"INSERT INTO [taobao_ms_requestlog]
([noticemethod]
,[parastr]
,[subtime]
,[sendip]
,[httpmethod]
,[isrightsign])
VALUES
(@noticemethod
,@parastr
,@subtime
,@sendip
,@httpmethod
,@isrightsign);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@noticemethod", log.noticemethod);
cmd.AddParam("@parastr", log.parastr);
cmd.AddParam("@subtime", log.subtime);
cmd.AddParam("@sendip", log.sendip);
cmd.AddParam("@httpmethod", log.httpmethod);
cmd.AddParam("@isrightsign", log.isrightsign);
try
{
object o = cmd.ExecuteScalar();
return(int.Parse(o.ToString()));
}
catch
{
sqlHelper.Dispose();
return(0);
}
}
else
{
string sql = @"UPDATE [taobao_ms_requestlog]
SET [noticemethod] = @noticemethod
,[parastr] = @parastr
,[subtime] = @subtime
,[sendip] = @sendip
,[httpmethod] = @httpmethod
,[isrightsign] = @isrightsign
WHERE id=@id";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@id", log.id);
cmd.AddParam("@noticemethod", log.noticemethod);
cmd.AddParam("@parastr", log.parastr);
cmd.AddParam("@subtime", log.subtime);
cmd.AddParam("@sendip", log.sendip);
cmd.AddParam("@httpmethod", log.httpmethod);
cmd.AddParam("@isrightsign", log.isrightsign);
cmd.ExecuteNonQuery();
return(log.id);
}
}
public int EditLog(Taobao_ms_requestlog log)
{
using (var helper = new SqlHelper())
{
int r = new InternalTaobao_ms_requestlog(helper).EditLog(log);
return(r);
}
}
