public int Update(Model.LotteryErro_LogModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LotteryErro_Log set "); strSql.Append("Ip=@Ip,Mob=@Mob,Code=@Code,OpenId=@OpenId,CreateTime=@CreateTime,Types=@Types,LotErro=@LotErro,Pros=@Pros,City=@City,Note=@Note "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Ip", DbTool.FixSqlParameter(model.Ip)) , new SqlParameter("@Mob", DbTool.FixSqlParameter(model.Mob)) , new SqlParameter("@Code", DbTool.FixSqlParameter(model.Code)) , new SqlParameter("@OpenId", DbTool.FixSqlParameter(model.OpenId)) , new SqlParameter("@CreateTime", DbTool.FixSqlParameter(model.CreateTime)) , new SqlParameter("@Types", DbTool.FixSqlParameter(model.Types)) , new SqlParameter("@LotErro", DbTool.FixSqlParameter(model.LotErro)) , new SqlParameter("@Pros", DbTool.FixSqlParameter(model.Pros)) , new SqlParameter("@City", DbTool.FixSqlParameter(model.City)) , 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.LotteryErro_LogModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [LotteryErro_Log]"); strSql.Append("(Ip,Mob,Code,OpenId,CreateTime,Types,LotErro,Pros,City,Note)"); strSql.Append(" values (@Ip,@Mob,@Code,@OpenId,@CreateTime,@Types,@LotErro,@Pros,@City,@Note)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@Ip", DbTool.FixSqlParameter(model.Ip)) , new SqlParameter("@Mob", DbTool.FixSqlParameter(model.Mob)) , new SqlParameter("@Code", DbTool.FixSqlParameter(model.Code)) , new SqlParameter("@OpenId", DbTool.FixSqlParameter(model.OpenId)) , new SqlParameter("@CreateTime", DbTool.FixSqlParameter(model.CreateTime)) , new SqlParameter("@Types", DbTool.FixSqlParameter(model.Types)) , new SqlParameter("@LotErro", DbTool.FixSqlParameter(model.LotErro)) , new SqlParameter("@Pros", DbTool.FixSqlParameter(model.Pros)) , new SqlParameter("@City", DbTool.FixSqlParameter(model.City)) , new SqlParameter("@Note", DbTool.FixSqlParameter(model.Note)) }; return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0)); }
protected Model.LotteryErro_LogModel AutoBindDataReader(SqlDataReader dr, params string[] fields) { var model = new Model.LotteryErro_LogModel(); if (DbTool.HasFields("Id", fields)) { model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]); } if (DbTool.HasFields("Ip", fields)) { model.Ip = DbTool.ConvertObject <System.String>(dr["Ip"]); } if (DbTool.HasFields("Mob", fields)) { model.Mob = DbTool.ConvertObject <System.String>(dr["Mob"]); } if (DbTool.HasFields("Code", fields)) { model.Code = DbTool.ConvertObject <System.String>(dr["Code"]); } if (DbTool.HasFields("OpenId", fields)) { model.OpenId = DbTool.ConvertObject <System.String>(dr["OpenId"]); } if (DbTool.HasFields("CreateTime", fields)) { model.CreateTime = DbTool.ConvertObject <System.String>(dr["CreateTime"]); } if (DbTool.HasFields("Types", fields)) { model.Types = DbTool.ConvertObject <System.Int32>(dr["Types"]); } if (DbTool.HasFields("LotErro", fields)) { model.LotErro = DbTool.ConvertObject <System.String>(dr["LotErro"]); } if (DbTool.HasFields("Pros", fields)) { model.Pros = DbTool.ConvertObject <System.String>(dr["Pros"]); } if (DbTool.HasFields("City", fields)) { model.City = DbTool.ConvertObject <System.String>(dr["City"]); } if (DbTool.HasFields("Note", fields)) { model.Note = DbTool.ConvertObject <System.String>(dr["Note"]); } return(model); }
protected void BindDataReader(Model.LotteryErro_LogModel model, SqlDataReader dr) { model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]); model.Ip = DbTool.ConvertObject <System.String>(dr["Ip"]); model.Mob = DbTool.ConvertObject <System.String>(dr["Mob"]); model.Code = DbTool.ConvertObject <System.String>(dr["Code"]); model.OpenId = DbTool.ConvertObject <System.String>(dr["OpenId"]); model.CreateTime = DbTool.ConvertObject <System.String>(dr["CreateTime"]); model.Types = DbTool.ConvertObject <System.Int32>(dr["Types"]); model.LotErro = DbTool.ConvertObject <System.String>(dr["LotErro"]); model.Pros = DbTool.ConvertObject <System.String>(dr["Pros"]); model.City = DbTool.ConvertObject <System.String>(dr["City"]); model.Note = DbTool.ConvertObject <System.String>(dr["Note"]); }
public Model.LotteryErro_LogModel GetModel(int Id) { string sql = "select top 1 * from LotteryErro_Log where Id =" + Id; Model.LotteryErro_LogModel model = new Model.LotteryErro_LogModel(); 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.LotteryErro_LogModel> GetModelList() { List <Model.LotteryErro_LogModel> result = new List <Model.LotteryErro_LogModel>(); string sql = "select * from LotteryErro_Log where 1=1"; Model.LotteryErro_LogModel model = new Model.LotteryErro_LogModel(); SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString()); //var fields = DbTool.GetReaderFieldNames(dr); while (dr.Read()) { //model = AutoBindDataReader(dr, fields); model = new Model.LotteryErro_LogModel(); BindDataReader(model, dr); result.Add(model); } dr.Close(); return(result); }