public int Save(Role Role) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetStoredProcCommand("p_Role_insert");//返回主键 db.AddInParameter(cmd, "@Role_Name", DbType.String, Role.Role_Name); db.AddInParameter(cmd, "@DES", DbType.String, Role.DES); object res = db.ExecuteScalar(cmd); return res == null ? -1 :1; }
public int SelectRolePageCount(string searchCondition) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetSqlStringCommand("select count(*) from Role where 1=1 " + searchCondition); return Convert.ToInt32(db.ExecuteScalar(cmd)); }
private long SelectUserPageCount(string sqlWhere) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetSqlStringCommand("select count(*) from [UserInfo] where 1=1 " + sqlWhere); return Convert.ToInt32(db.ExecuteScalar(cmd)); }