Beispiel #1
0
        public Expose178.Com.Model.ReadRoleType GetReadRole(string strReadRoleTypeCode)
        {
            DataSet dsReadRole = GetDataSetReadRole("");

            Expose178.Com.Model.ReadRoleType read = null;
            if (Gadget.DatatSetIsNotNullOrEmpty(dsReadRole))
            {
                read = new Model.ReadRoleType();
                read.ReadRoleTypeCode = Gadget.GetDataRowStringValue(dsReadRole.Tables[0].Rows[0], "ReadRoleTypeCode");
                read.ReadRoleTypeDesc = Gadget.GetDataRowStringValue(dsReadRole.Tables[0].Rows[0], "ReadRoleTypeDesc");
                read.UpdatedByUserID  = Gadget.GetDataRowStringValue(dsReadRole.Tables[0].Rows[0], "UpdatedByUserID");
                read.LastUpdatedDate  = Gadget.GetDataRowDateTimeValue(dsReadRole.Tables[0].Rows[0], "LastUpdatedDate");
            }
            return(read);
        }
Beispiel #2
0
        private Expose178.Com.Model.ReadRoleType GetReadRoleType(string strReadRoleTypeCode)
        {
            Expose178.Com.Model.ReadRoleType ReadRoleType = new Model.ReadRoleType();
            DataSet   dsReadRoleType = null;
            Hashtable hshParam       = new Hashtable();

            dsReadRoleType = dbOperator.ProcessData("usp_GetReadRoleType", hshParam, strDSN);
            if (Gadget.DatatSetIsNotNullOrEmpty(dsReadRoleType))
            {
                ReadRoleType.ReadRoleTypeCode = strReadRoleTypeCode;
                ReadRoleType.ReadRoleTypeDesc = Gadget.GetDataRowStringValue(dsReadRoleType.Tables[0].Rows[0], "ReadRoleTypeDesc");
                ReadRoleType.LastUpdatedDate  = Gadget.GetDataRowDateTimeValue(dsReadRoleType.Tables[0].Rows[0], "LastUpdatedDate");
                ReadRoleType.UpdatedByUserID  = Gadget.GetDataRowStringValue(dsReadRoleType.Tables[0].Rows[0], "UpdatedByUserID");
            }
            return(ReadRoleType);
        }
Beispiel #3
0
        public IList <Expose178.Com.Model.ReadRoleType> GetListReadRole()
        {
            DataSet dsReadRole = GetDataSetReadRole("");
            IList <Expose178.Com.Model.ReadRoleType> listReadRole = null;

            if (Gadget.DatatSetIsNotNullOrEmpty(dsReadRole))
            {
                listReadRole = new List <Expose178.Com.Model.ReadRoleType>();
                foreach (DataRow dr in dsReadRole.Tables[0].Rows)
                {
                    Expose178.Com.Model.ReadRoleType read = new Model.ReadRoleType();
                    read.ReadRoleTypeCode = Gadget.GetDataRowStringValue(dr, "ReadRoleTypeCode");
                    read.ReadRoleTypeDesc = Gadget.GetDataRowStringValue(dr, "ReadRoleTypeDesc");
                    read.UpdatedByUserID  = Gadget.GetDataRowStringValue(dr, "UpdatedByUserID");
                    read.LastUpdatedDate  = Gadget.GetDataRowDateTimeValue(dr, "LastUpdatedDate");
                    listReadRole.Add(read);
                }
            }
            return(listReadRole);
        }