protected override Hashtable parseResult(DataTable mDT) { Hashtable ht = new Hashtable(); foreach (DataRow dr in mDT.Rows) { SMLIB_OBJ_SMLIB_LISTBUILDER_LIST item = new SMLIB_OBJ_SMLIB_LISTBUILDER_LIST(); item.getItem(dr); ht.Add(item.LIST_ID, item); } return(ht); }
public List <SMLIB_OBJ_SMLIB_LISTBUILDER_LIST> getCollaborateByPatronID(Double PatronID) { List <SMLIB_OBJ_SMLIB_LISTBUILDER_LIST> rv = new List <SMLIB_OBJ_SMLIB_LISTBUILDER_LIST>(); String sql = "SELECT * FROM SMLIB_LISTBUILDER_LIST WHERE LIST_ID IN (SELECT SHARED_LIST_ID FROM SMLIB_LISTBUILDER_SHARED WHERE SHARED_REF_ID='" + PatronID.ToString("F2") + "' AND SHARED_TYPE='COLLABORATE') ORDER BY LIST_NAME "; SMLIB_DBUtils dbu = new SMLIB_DBUtils(); DataTable dt = new DataTable(); dt = dbu.getTable(sql); foreach (DataRow dr in dt.Rows) { SMLIB_OBJ_SMLIB_LISTBUILDER_LIST item = new SMLIB_OBJ_SMLIB_LISTBUILDER_LIST(); item.getItem(dr); rv.Add(item); } return(rv); }