public DataTable Select(int uid, int i) { DataTable dt = sql.Query("select * from [OA_filepath] where uid=" + uid + " and isdelete=" + i + " order by Id desc").Tables[0]; return(dt); }
public static int ReCordCount(SqlCommand cmd) { string sql = "select count(*) as total " + cmd.CommandText; return(Convert.ToInt32(sqlhelp.Query(sql).Tables[0].Rows[0]["total"])); }