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; }
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; }