Пример #1
0
        public override IModel CreateModel(SqlDataReader dr)
        {
            CustomsClearance customsclearance = new CustomsClearance();

            int indexCustomsId = dr.GetOrdinal("CustomsId");
            customsclearance.CustomsId = Convert.ToInt32(dr[indexCustomsId]);

            int indexCustomsApplyId = dr.GetOrdinal("CustomsApplyId");
            if (dr["CustomsApplyId"] != DBNull.Value)
            {
                customsclearance.CustomsApplyId = Convert.ToInt32(dr[indexCustomsApplyId]);
            }

            int indexCustomser = dr.GetOrdinal("Customser");
            if (dr["Customser"] != DBNull.Value)
            {
                customsclearance.Customser = Convert.ToInt32(dr[indexCustomser]);
            }

            int indexCustomsCorpId = dr.GetOrdinal("CustomsCorpId");
            if (dr["CustomsCorpId"] != DBNull.Value)
            {
                customsclearance.CustomsCorpId = Convert.ToInt32(dr[indexCustomsCorpId]);
            }

            int indexCustomsDate = dr.GetOrdinal("CustomsDate");
            if (dr["CustomsDate"] != DBNull.Value)
            {
                customsclearance.CustomsDate = Convert.ToDateTime(dr[indexCustomsDate]);
            }

            int indexCustomsName = dr.GetOrdinal("CustomsName");
            if (dr["CustomsName"] != DBNull.Value)
            {
                customsclearance.CustomsName = Convert.ToInt32(dr[indexCustomsName]);
            }

            int indexGrossWeight = dr.GetOrdinal("GrossWeight");
            if (dr["GrossWeight"] != DBNull.Value)
            {
                customsclearance.GrossWeight = Convert.ToDecimal(dr[indexGrossWeight]);
            }

            int indexNetWeight = dr.GetOrdinal("NetWeight");
            if (dr["NetWeight"] != DBNull.Value)
            {
                customsclearance.NetWeight = Convert.ToDecimal(dr[indexNetWeight]);
            }

            int indexCurrencyId = dr.GetOrdinal("CurrencyId");
            if (dr["CurrencyId"] != DBNull.Value)
            {
                customsclearance.CurrencyId = Convert.ToInt32(dr[indexCurrencyId]);
            }

            int indexCustomsPrice = dr.GetOrdinal("CustomsPrice");
            if (dr["CustomsPrice"] != DBNull.Value)
            {
                customsclearance.CustomsPrice = Convert.ToDecimal(dr[indexCustomsPrice]);
            }

            int indexTariffRate = dr.GetOrdinal("TariffRate");
            if (dr["TariffRate"] != DBNull.Value)
            {
                customsclearance.TariffRate = Convert.ToDecimal(dr[indexTariffRate]);
            }

            int indexAddedValueRate = dr.GetOrdinal("AddedValueRate");
            if (dr["AddedValueRate"] != DBNull.Value)
            {
                customsclearance.AddedValueRate = Convert.ToDecimal(dr[indexAddedValueRate]);
            }

            int indexOtherFees = dr.GetOrdinal("OtherFees");
            if (dr["OtherFees"] != DBNull.Value)
            {
                customsclearance.OtherFees = Convert.ToDecimal(dr[indexOtherFees]);
            }

            int indexMemo = dr.GetOrdinal("Memo");
            if (dr["Memo"] != DBNull.Value)
            {
                customsclearance.Memo = Convert.ToString(dr[indexMemo]);
            }

            int indexCustomsStatus = dr.GetOrdinal("CustomsStatus");
            if (dr["CustomsStatus"] != DBNull.Value)
            {
                customsclearance.CustomsStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexCustomsStatus]);
            }

            int indexCreatorId = dr.GetOrdinal("CreatorId");
            if (dr["CreatorId"] != DBNull.Value)
            {
                customsclearance.CreatorId = Convert.ToInt32(dr[indexCreatorId]);
            }

            int indexCreateTime = dr.GetOrdinal("CreateTime");
            if (dr["CreateTime"] != DBNull.Value)
            {
                customsclearance.CreateTime = Convert.ToDateTime(dr[indexCreateTime]);
            }

            int indexLastModifyId = dr.GetOrdinal("LastModifyId");
            if (dr["LastModifyId"] != DBNull.Value)
            {
                customsclearance.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]);
            }

            int indexLastModifyTime = dr.GetOrdinal("LastModifyTime");
            if (dr["LastModifyTime"] != DBNull.Value)
            {
                customsclearance.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]);
            }

            return customsclearance;
        }
Пример #2
0
        public override IModel CreateModel(DataRow dr)
        {
            CustomsClearance customsclearance = new CustomsClearance();

            customsclearance.CustomsId = Convert.ToInt32(dr["CustomsId"]);

            if (dr["CustomsApplyId"] != DBNull.Value)
            {
                customsclearance.CustomsApplyId = Convert.ToInt32(dr["CustomsApplyId"]);
            }

            if (dr["Customser"] != DBNull.Value)
            {
                customsclearance.Customser = Convert.ToInt32(dr["Customser"]);
            }

            if (dr["CustomsCorpId"] != DBNull.Value)
            {
                customsclearance.CustomsCorpId = Convert.ToInt32(dr["CustomsCorpId"]);
            }

            if (dr["CustomsDate"] != DBNull.Value)
            {
                customsclearance.CustomsDate = Convert.ToDateTime(dr["CustomsDate"]);
            }

            if (dr["CustomsName"] != DBNull.Value)
            {
                customsclearance.CustomsName = Convert.ToInt32(dr["CustomsName"]);
            }

            if (dr["GrossWeight"] != DBNull.Value)
            {
                customsclearance.GrossWeight = Convert.ToDecimal(dr["GrossWeight"]);
            }

            if (dr["NetWeight"] != DBNull.Value)
            {
                customsclearance.NetWeight = Convert.ToDecimal(dr["NetWeight"]);
            }

            if (dr["CurrencyId"] != DBNull.Value)
            {
                customsclearance.CurrencyId = Convert.ToInt32(dr["CurrencyId"]);
            }

            if (dr["CustomsPrice"] != DBNull.Value)
            {
                customsclearance.CustomsPrice = Convert.ToDecimal(dr["CustomsPrice"]);
            }

            if (dr["TariffRate"] != DBNull.Value)
            {
                customsclearance.TariffRate = Convert.ToDecimal(dr["TariffRate"]);
            }

            if (dr["AddedValueRate"] != DBNull.Value)
            {
                customsclearance.AddedValueRate = Convert.ToDecimal(dr["AddedValueRate"]);
            }

            if (dr["OtherFees"] != DBNull.Value)
            {
                customsclearance.OtherFees = Convert.ToDecimal(dr["OtherFees"]);
            }

            if (dr["Memo"] != DBNull.Value)
            {
                customsclearance.Memo = Convert.ToString(dr["Memo"]);
            }

            if (dr["CustomsStatus"] != DBNull.Value)
            {
                customsclearance.CustomsStatus = (Common.StatusEnum)Convert.ToInt32(dr["CustomsStatus"]);
            }

            if (dr["CreatorId"] != DBNull.Value)
            {
                customsclearance.CreatorId = Convert.ToInt32(dr["CreatorId"]);
            }

            if (dr["CreateTime"] != DBNull.Value)
            {
                customsclearance.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
            }

            if (dr["LastModifyId"] != DBNull.Value)
            {
                customsclearance.LastModifyId = Convert.ToInt32(dr["LastModifyId"]);
            }

            if (dr["LastModifyTime"] != DBNull.Value)
            {
                customsclearance.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]);
            }

            return customsclearance;
        }