예제 #1
0
        /// <summary>
        /// 获取周报收件人列表
        ///  Created:2017.04.11(ChengMengjia)
        /// </summary>
        /// <returns></returns>
        public IList <dynamic> GetMemberList(string ProjectID, string IDs)
        {
            string    sql   = "select * from Stakeholders where PID=:PID and ID in (" + IDs + ")";
            ISQLQuery query = NHHelper.GetCurrentSession().CreateSQLQuery(sql.ToString());

            query.SetString("PID", ProjectID);
            return(query.DynamicList());
        }
예제 #2
0
        public static List <dynamic> GetDynamicList(string sql, Dictionary <string, string> args)
        {
            ISession session = GetCurrentSession();

            try
            {
                ISQLQuery query = session.CreateSQLQuery(sql);
                foreach (var item in args)
                {
                    query.SetString(item.Key, item.Value);
                }
                return(query.DynamicList().ToList());
            }
            catch (Exception ex)
            {
                LogHelper.WriteException(ex, LogType.DataAccessDLL);
                return(null);
            }
        }