コード例 #1
0
        public bool GetUserById(string requestUserId)
        {
            var dataSet = InfraDal.ExecuteQuery(Connection,
                                                "SELECT ACTIVE FROM USERS WHERE USER_ID ='" + requestUserId + "'");
            var data = dataSet.Tables[0].Rows[0][0];

            return(Convert.ToBoolean(data));
        }
コード例 #2
0
        public void DestroyUserDummyData(params string[] ids)
        {
            var query = new StringBuilder();

            query.Append("DELETE FROM ").Append("USERS ").Append("WHERE USERS.USER_ID IN (");
            foreach (var id in ids)
            {
                query.Append("'").Append(id).Append("'").Append(",");
            }

            query.Length--;
            query.Append(")");
            var queryStr = query.ToString();

            InfraDal.ExecuteQuery(Connection, query.ToString());
        }