C# 执行sql语句批量更新 

              int x = db.Database.ExecuteSqlCommand(string.Format("update T_Pension SET UnitType = '{0}' WHERE  PensionId   between '{1}' and  '{2}'", value, startmaxid, endmaxid));
                //update T_Pension SET UnitType = 0,CreateTime= convert(varchar(100),getdate(),120),CreateUserName=''  WHERE  PensionId   between '1' and  '30000'
                int x = db.Database.ExecuteSqlCommand(string.Format("update T_Pension SET UnitType = {0},CreateTime= convert(varchar(100),getdate(),120),CreateUserName='{1}'  WHERE  PensionId   between '{2}' and  '{3}'",
                value,UserInfo.UserName,startmaxid, endmaxid));

 

start.ToString("yyyy-MM-dd HH:mm:ss")

 

posted @ 2018-11-14 16:51  enych  阅读(4958)  评论(0)  编辑  收藏  举报