public DataSet GetAll(M_ADMIN model, ref MJD.COMMON.MySqlRtMsg rtObj) { List <MJD.COMMON.MySqlPara> pArr = new List <MJD.COMMON.MySqlPara>(); pArr.Add(new MJD.COMMON.MySqlPara("T", ParameterDirection.Input, DbType.String, "TADMIN_GETALL")); pArr.Add(new MJD.COMMON.MySqlPara("ID", ParameterDirection.Input, DbType.Int32, model.ID)); pArr.Add(new MJD.COMMON.MySqlPara("RID", ParameterDirection.Input, DbType.Int32, model.RID)); pArr.Add(new MJD.COMMON.MySqlPara("Name", ParameterDirection.Input, DbType.String, model.Name)); pArr.Add(new MJD.COMMON.MySqlPara("TeleNum", ParameterDirection.Input, DbType.String, model.TeleNum)); pArr.Add(new MJD.COMMON.MySqlPara("CreateTime", ParameterDirection.Input, DbType.Int64, model.CreateTime)); pArr.Add(new MJD.COMMON.MySqlPara("CreateIP", ParameterDirection.Input, DbType.String, model.CreateIP)); pArr.Add(new MJD.COMMON.MySqlPara("Status", ParameterDirection.Input, DbType.Int32, model.Status)); return(MJD.COMMON.MYSQLHELPER.ExecuteQueryProcedure(procName, ref rtObj, pArr.ToArray())); }
public DataSet GetPagination(M_ADMIN model, ref MJD.COMMON.MySqlRtMsg rtObj) { List <MJD.COMMON.MySqlPara> pArr = new List <MJD.COMMON.MySqlPara>(); pArr.Add(new MJD.COMMON.MySqlPara("T", ParameterDirection.Input, DbType.String, "TADMIN_PAGINATION")); pArr.Add(new MJD.COMMON.MySqlPara("ID", ParameterDirection.Input, DbType.Int32, model.ID)); pArr.Add(new MJD.COMMON.MySqlPara("RID", ParameterDirection.Input, DbType.Int32, model.RID)); pArr.Add(new MJD.COMMON.MySqlPara("Name", ParameterDirection.Input, DbType.String, model.Name)); pArr.Add(new MJD.COMMON.MySqlPara("TeleNum", ParameterDirection.Input, DbType.String, model.TeleNum)); pArr.Add(new MJD.COMMON.MySqlPara("CreateTime", ParameterDirection.Input, DbType.Int64, model.CreateTime)); pArr.Add(new MJD.COMMON.MySqlPara("CreateIP", ParameterDirection.Input, DbType.String, model.CreateIP)); pArr.Add(new MJD.COMMON.MySqlPara("Status", ParameterDirection.Input, DbType.Int32, model.Status)); pArr.Add(new MJD.COMMON.MySqlPara("pageSize", ParameterDirection.InputOutput, DbType.Int32, model.pageSize)); pArr.Add(new MJD.COMMON.MySqlPara("currentPage", ParameterDirection.InputOutput, DbType.Int32, model.currentPage)); DataSet ds = MJD.COMMON.MYSQLHELPER.ExecuteQueryProcedure(procName, ref rtObj, pArr.ToArray()); return(ds); }