예제 #1
0
        /// <summary>
        /// ログイン情報取得
        /// </summary>
        /// <remarks>
        /// 作成者    :  sesaki
        /// 作成日    :  2019/10/30
        /// </remarks>
        public DataRow GetLoginUser(Condition condition)
        {
            DataTable dtTable;
            DataRow   dtRow = null;

            List <object> paraList = new List <object>();
            string        queryStr = QueryBuild.SystemLogin(condition, ref paraList);

            DataBase dataBase = new DataBase();

            dataBase.ConnectDB();

            DataSet dtSet = dataBase.GetDataSet(queryStr, paraList.ToArray());

            dtTable = dtSet.Tables[0];

            if (dtTable.Rows.Count != 0)
            {
                dtRow = dtTable.Rows[0];
            }

            if (dataBase != null)
            {
                dataBase.DisconnectDB();
            }
            if (dtSet != null)
            {
                dtSet.Dispose();
            }

            return(dtRow);
        }