internal int EditWxdelivernotify(Wxdelivernotify m_d)
{
if (m_d.Id == 0)
{
string sql = "INSERT INTO [wxdelivernotify]([out_trade_no] ,[appid],[openid],[transid],[deliver_timestamp],[timeformat],[deliver_status] ,[deliver_msg],[requestxml],[responsexml],[errcode] ,[errmsg] ,[comid]) VALUES " +
"('" + m_d.Out_trade_no + "','" + m_d.Appid + "','" + m_d.Openid + "','" + m_d.Transid + "','" + m_d.Deliver_timestamp + "','" + m_d.Timeformat + "','" + m_d.Deliver_status + "','" + m_d.Deliver_msg + "','" + m_d.Requestxml + "','" + m_d.Responsexml + "','" + m_d.Errcode + "','" + m_d.Errmsg + "','" + m_d.Comid + "');select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
object o = cmd.ExecuteScalar();
return(int.Parse(o.ToString()));
}
else
{
string sql = "UPDATE [EtownDB].[dbo].[wxdelivernotify] " +
"SET [out_trade_no] = '" + m_d.Out_trade_no + "'" +
",[appid] = '" + m_d.Appid + "'" +
",[openid] = '" + m_d.Openid + "'" +
",[transid] = '" + m_d.Transid + "'" +
",[deliver_timestamp] ='" + m_d.Deliver_timestamp + "'" +
",[timeformat] = '" + m_d.Timeformat + "'" +
",[deliver_status] = '" + m_d.Deliver_status + "'" +
",[deliver_msg] = '" + m_d.Deliver_msg + "'" +
",[requestxml] ='" + m_d.Requestxml + "'" +
",[responsexml] = '" + m_d.Responsexml + "'" +
",[errcode] = '" + m_d.Errcode + "'" +
",[errmsg] = '" + m_d.Errmsg + "'" +
",[comid] = '" + m_d.Comid + "'" +
"WHERE id=" + m_d.Id;
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.ExecuteNonQuery();
return(m_d.Id);
}
}
public int EditWxdelivernotify(Wxdelivernotify m_d)
{
using (var helper = new SqlHelper())
{
int r = new InternalWxdelivernotify(helper).EditWxdelivernotify(m_d);
return(r);
}
}
