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); } }