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);
}
