internal B2b_order_busRemindSmsLog GetB2b_order_busRemindSmsSucLog(int proid, string gooutdate)
{
string sql = "select * from b2b_order_busRemindSmsLog where proid=" + proid + " and traveldate='" + gooutdate + "' and issuc=1";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
using (var reader = cmd.ExecuteReader())
{
B2b_order_busRemindSmsLog m = null;
if (reader.Read())
{
m = new B2b_order_busRemindSmsLog
{
id = reader.GetValue <int>("id"),
smscontent = reader.GetValue <string>("smscontent"),
sendtophones = reader.GetValue <string>("sendtophones"),
sendtime = reader.GetValue <DateTime>("sendtime"),
opertorid = reader.GetValue <int>("opertorid"),
opertorname = reader.GetValue <string>("opertorname"),
proid = reader.GetValue <int>("proid"),
traveldate = reader.GetValue <DateTime>("traveldate"),
issuc = reader.GetValue <int>("issuc")
};
}
return(m);
}
}
public int EditRemindSmsLog(B2b_order_busRemindSmsLog m)
{
using (var helper = new SqlHelper())
{
int r = new Internalb2b_order_busRemindSmsLog(helper).EditRemindSmsLog(m);
return(r);
}
}
internal int EditRemindSmsLog(B2b_order_busRemindSmsLog m)
{
if (m.id == 0)
{
string sql = @"INSERT [b2b_order_busRemindSmsLog]
([smscontent]
,[sendtophones]
,[sendtime]
,[opertorid]
,[opertorname]
,[proid]
,[traveldate]
,issuc)
VALUES
(@smscontent
,@sendtophones
,@sendtime
,@opertorid
,@opertorname
,@proid
,@traveldate
,@issuc);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@smscontent", m.smscontent);
cmd.AddParam("@sendtophones", m.sendtophones);
cmd.AddParam("@sendtime", m.sendtime);
cmd.AddParam("@opertorid", m.opertorid);
cmd.AddParam("@opertorname", m.opertorname);
cmd.AddParam("@proid", m.proid);
cmd.AddParam("@traveldate", m.traveldate);
cmd.AddParam("@issuc", m.issuc);
object o = cmd.ExecuteScalar();
return(int.Parse(o.ToString()));
}
else
{
string sql = @"UPDATE [b2b_order_busRemindSmsLog]
SET [smscontent] = @smscontent
,[sendtophones] = @sendtophones
,[sendtime] = @sendtime
,[opertorid] = @opertorid
,[opertorname] = @opertorname
,[proid] = @proid
,[traveldate] = @traveldate
,issuc=@issuc
WHERE id=@id";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@smscontent", m.smscontent);
cmd.AddParam("@sendtophones", m.sendtophones);
cmd.AddParam("@sendtime", m.sendtime);
cmd.AddParam("@opertorid", m.opertorid);
cmd.AddParam("@opertorname", m.opertorname);
cmd.AddParam("@proid", m.proid);
cmd.AddParam("@traveldate", m.traveldate);
cmd.AddParam("@id", m.id);
cmd.AddParam("@issuc", m.issuc);
cmd.ExecuteNonQuery();
return(m.id);
}
}
