internal Agent_RechargeRemindSms GetAgent_RechargeRemindSms(int agentid, int comid, int edu, int isdeal)
{
string sql = "select * from agent_RechargeRemindSms where agentid=" + agentid + " and comid=" + comid + " and tishi_edu=" + edu + " and isdeal=" + isdeal;
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
using (var reader = cmd.ExecuteReader())
{
Agent_RechargeRemindSms m = null;
if (reader.Read())
{
m = new Agent_RechargeRemindSms
{
id = reader.GetValue <int>("id"),
agentid = reader.GetValue <int>("agentid"),
comid = reader.GetValue <int>("comid"),
smscontent = reader.GetValue <string>("smscontent"),
tishi_phone = reader.GetValue <string>("tishi_phone"),
tishi_time = reader.GetValue <DateTime>("tishi_time"),
tishi_edu = reader.GetValue <string>("tishi_edu"),
isdeal = reader.GetValue <int>("isdeal")
};
}
return(m);
}
}
internal int InsRemindsms(Agent_RechargeRemindSms m)
{
string sql = @"INSERT [agent_RechargeRemindSms]
([agentid]
,[comid]
,[smscontent]
,[tishi_phone]
,[tishi_time]
,[tishi_edu]
,[isdeal])
VALUES
(@agentid
,@comid
,@smscontent
,@tishi_phone
,@tishi_time
,@tishi_edu
,@isdeal);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@agentid", m.agentid);
cmd.AddParam("@comid", m.comid);
cmd.AddParam("@smscontent", m.smscontent);
cmd.AddParam("@tishi_phone", m.tishi_phone);
cmd.AddParam("@tishi_time", m.tishi_time);
cmd.AddParam("@tishi_edu", m.tishi_edu);
cmd.AddParam("@isdeal", m.isdeal);
object o = cmd.ExecuteScalar();
return(int.Parse(o.ToString()));
}
public int InsRemindsms(Agent_RechargeRemindSms m)
{
using (var helper = new SqlHelper())
{
int r = new Internalagent_RechargeRemindSms(helper).InsRemindsms(m);
return(r);
}
}
