public int Update(Model.ObjectInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ObjectInfo set "); strSql.Append("ObjectName=@ObjectName,IsTest=@IsTest,OnlineTime=@OnlineTime,OnOffTime=@OnOffTime,MobCount=@MobCount,OpenIdCount=@OpenIdCount,IpCount=@IpCount,NoStartText=@NoStartText,CStext=@CStext,EndText=@EndText,WHtext=@WHtext,Note=@Note "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@ObjectName", DbTool.FixSqlParameter(model.ObjectName)) , new SqlParameter("@IsTest", DbTool.FixSqlParameter(model.IsTest)) , new SqlParameter("@OnlineTime", DbTool.FixSqlParameter(model.OnlineTime)) , new SqlParameter("@OnOffTime", DbTool.FixSqlParameter(model.OnOffTime)) , new SqlParameter("@MobCount", DbTool.FixSqlParameter(model.MobCount)) , new SqlParameter("@OpenIdCount", DbTool.FixSqlParameter(model.OpenIdCount)) , new SqlParameter("@IpCount", DbTool.FixSqlParameter(model.IpCount)) , new SqlParameter("@NoStartText", DbTool.FixSqlParameter(model.NoStartText)) , new SqlParameter("@CStext", DbTool.FixSqlParameter(model.CStext)) , new SqlParameter("@EndText", DbTool.FixSqlParameter(model.EndText)) , new SqlParameter("@WHtext", DbTool.FixSqlParameter(model.WHtext)) , new SqlParameter("@Note", DbTool.FixSqlParameter(model.Note)) , new SqlParameter("@Id", model.Id) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters)); }
public int Add(Model.ObjectInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [ObjectInfo]"); strSql.Append("(ObjectName,IsTest,OnlineTime,OnOffTime,MobCount,OpenIdCount,IpCount,NoStartText,CStext,EndText,WHtext,Note)"); strSql.Append(" values (@ObjectName,@IsTest,@OnlineTime,@OnOffTime,@MobCount,@OpenIdCount,@IpCount,@NoStartText,@CStext,@EndText,@WHtext,@Note)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@ObjectName", DbTool.FixSqlParameter(model.ObjectName)) , new SqlParameter("@IsTest", DbTool.FixSqlParameter(model.IsTest)) , new SqlParameter("@OnlineTime", DbTool.FixSqlParameter(model.OnlineTime)) , new SqlParameter("@OnOffTime", DbTool.FixSqlParameter(model.OnOffTime)) , new SqlParameter("@MobCount", DbTool.FixSqlParameter(model.MobCount)) , new SqlParameter("@OpenIdCount", DbTool.FixSqlParameter(model.OpenIdCount)) , new SqlParameter("@IpCount", DbTool.FixSqlParameter(model.IpCount)) , new SqlParameter("@NoStartText", DbTool.FixSqlParameter(model.NoStartText)) , new SqlParameter("@CStext", DbTool.FixSqlParameter(model.CStext)) , new SqlParameter("@EndText", DbTool.FixSqlParameter(model.EndText)) , new SqlParameter("@WHtext", DbTool.FixSqlParameter(model.WHtext)) , new SqlParameter("@Note", DbTool.FixSqlParameter(model.Note)) }; return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0)); }
protected Model.ObjectInfoModel AutoBindDataReader(SqlDataReader dr, params string[] fields) { var model = new Model.ObjectInfoModel(); if (DbTool.HasFields("Id", fields)) { model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]); } if (DbTool.HasFields("ObjectName", fields)) { model.ObjectName = DbTool.ConvertObject <System.String>(dr["ObjectName"]); } if (DbTool.HasFields("IsTest", fields)) { model.IsTest = DbTool.ConvertObject <System.Int32>(dr["IsTest"]); } if (DbTool.HasFields("OnlineTime", fields)) { model.OnlineTime = DbTool.ConvertObject <System.DateTime>(dr["OnlineTime"]); } if (DbTool.HasFields("OnOffTime", fields)) { model.OnOffTime = DbTool.ConvertObject <System.DateTime>(dr["OnOffTime"]); } if (DbTool.HasFields("MobCount", fields)) { model.MobCount = DbTool.ConvertObject <System.Int32>(dr["MobCount"]); } if (DbTool.HasFields("OpenIdCount", fields)) { model.OpenIdCount = DbTool.ConvertObject <System.Int32>(dr["OpenIdCount"]); } if (DbTool.HasFields("IpCount", fields)) { model.IpCount = DbTool.ConvertObject <System.Int32>(dr["IpCount"]); } if (DbTool.HasFields("NoStartText", fields)) { model.NoStartText = DbTool.ConvertObject <System.String>(dr["NoStartText"]); } if (DbTool.HasFields("CStext", fields)) { model.CStext = DbTool.ConvertObject <System.String>(dr["CStext"]); } if (DbTool.HasFields("EndText", fields)) { model.EndText = DbTool.ConvertObject <System.String>(dr["EndText"]); } if (DbTool.HasFields("WHtext", fields)) { model.WHtext = DbTool.ConvertObject <System.String>(dr["WHtext"]); } if (DbTool.HasFields("Note", fields)) { model.Note = DbTool.ConvertObject <System.String>(dr["Note"]); } return(model); }
protected void BindDataReader(Model.ObjectInfoModel model, SqlDataReader dr) { model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]); model.ObjectName = DbTool.ConvertObject <System.String>(dr["ObjectName"]); model.IsTest = DbTool.ConvertObject <System.Int32>(dr["IsTest"]); model.OnlineTime = DbTool.ConvertObject <System.DateTime>(dr["OnlineTime"]); model.OnOffTime = DbTool.ConvertObject <System.DateTime>(dr["OnOffTime"]); model.MobCount = DbTool.ConvertObject <System.Int32>(dr["MobCount"]); model.OpenIdCount = DbTool.ConvertObject <System.Int32>(dr["OpenIdCount"]); model.IpCount = DbTool.ConvertObject <System.Int32>(dr["IpCount"]); model.NoStartText = DbTool.ConvertObject <System.String>(dr["NoStartText"]); model.CStext = DbTool.ConvertObject <System.String>(dr["CStext"]); model.EndText = DbTool.ConvertObject <System.String>(dr["EndText"]); model.WHtext = DbTool.ConvertObject <System.String>(dr["WHtext"]); model.Note = DbTool.ConvertObject <System.String>(dr["Note"]); }
public Model.ObjectInfoModel GetModel(int Id) { string sql = "select top 1 * from ObjectInfo where Id =" + Id; Model.ObjectInfoModel model = new Model.ObjectInfoModel(); SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString()); if (dr.Read()) { //var fields = DbTool.GetReaderFieldNames(dr); //model = AutoBindDataReader(dr, fields); BindDataReader(model, dr); } dr.Close(); return(model); }
public List <Model.ObjectInfoModel> GetModelList() { List <Model.ObjectInfoModel> result = new List <Model.ObjectInfoModel>(); string sql = "select * from ObjectInfo where 1=1"; Model.ObjectInfoModel model = new Model.ObjectInfoModel(); SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString()); //var fields = DbTool.GetReaderFieldNames(dr); while (dr.Read()) { //model = AutoBindDataReader(dr, fields); model = new Model.ObjectInfoModel(); BindDataReader(model, dr); result.Add(model); } dr.Close(); return(result); }