public static List <User> GetUserByItCode(params string[] itcodes) { Database db = DBHelper.GetDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("Usp_GetSysUserByItCodes", InHelper.ConvertToInStr(itcodes)); List <User> users = new List <User>(); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { users.Add(PopulateUser(dataReader)); } } return(users); }
public static List <Attachment> GetAttachmentByID(List <Guid> ids) { Database db = DBHelper.GetDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("Usp_GetAttachmentByIDs", InHelper.ConvertToInStr(ids)); List <Attachment> attaches = new List <Attachment>(); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { attaches.Add(PopulateAttachment(dataReader)); } } return(attaches); }