protected override IModel CreateModel(SqlDataReader dr) { CorpBillDetail corpbilldetail = new CorpBillDetail(); int indexDetailId = dr.GetOrdinal("DetailId"); corpbilldetail.DetailId = Convert.ToInt32(dr[indexDetailId]); int indexCorpBillId = dr.GetOrdinal("CorpBillId"); if (dr[indexCorpBillId] != DBNull.Value) { corpbilldetail.CorpBillId = Convert.ToInt32(dr[indexCorpBillId]); } int indexEmpSalaryId = dr.GetOrdinal("EmpSalaryId"); if (dr[indexEmpSalaryId] != DBNull.Value) { corpbilldetail.EmpSalaryId = Convert.ToInt32(dr[indexEmpSalaryId]); } int indexServiceAmount = dr.GetOrdinal("ServiceAmount"); if (dr[indexServiceAmount] != DBNull.Value) { corpbilldetail.ServiceAmount = Convert.ToDecimal(dr[indexServiceAmount]); } int indexDetailStatus = dr.GetOrdinal("DetailStatus"); if (dr[indexDetailStatus] != DBNull.Value) { corpbilldetail.DetailStatus = Convert.ToInt32(dr[indexDetailStatus]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr[indexCreatorId] != DBNull.Value) { corpbilldetail.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr[indexCreateTime] != DBNull.Value) { corpbilldetail.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr[indexLastModifyId] != DBNull.Value) { corpbilldetail.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr[indexLastModifyTime] != DBNull.Value) { corpbilldetail.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return(corpbilldetail); }
protected override List <SqlParameter> CreateInsertParameters(IModel obj, ref SqlParameter returnValue) { CorpBillDetail usr_corpbilldetail = (CorpBillDetail)obj; List <SqlParameter> paras = new List <SqlParameter>(); returnValue.Direction = ParameterDirection.Output; returnValue.SqlDbType = SqlDbType.Int; returnValue.ParameterName = "@DetailId"; returnValue.Size = 4; paras.Add(returnValue); SqlParameter corpbillidpara = new SqlParameter("@CorpBillId", SqlDbType.Int, 4); corpbillidpara.Value = usr_corpbilldetail.CorpBillId; paras.Add(corpbillidpara); SqlParameter empsalaryidpara = new SqlParameter("@EmpSalaryId", SqlDbType.Int, 4); empsalaryidpara.Value = usr_corpbilldetail.EmpSalaryId; paras.Add(empsalaryidpara); SqlParameter serviceamountpara = new SqlParameter("@ServiceAmount", SqlDbType.Decimal, 9); serviceamountpara.Value = usr_corpbilldetail.ServiceAmount; paras.Add(serviceamountpara); SqlParameter detailstatuspara = new SqlParameter("@DetailStatus", SqlDbType.Int, 4); detailstatuspara.Value = usr_corpbilldetail.DetailStatus; paras.Add(detailstatuspara); SqlParameter creatoridpara = new SqlParameter("@CreatorId", SqlDbType.Int, 4); creatoridpara.Value = obj.CreatorId; paras.Add(creatoridpara); return(paras); }
public override List <SqlParameter> CreateUpdateParameters(IModel obj) { CorpBillDetail usr_corpbilldetail = (CorpBillDetail)obj; List <SqlParameter> paras = new List <SqlParameter>(); SqlParameter detailidpara = new SqlParameter("@DetailId", SqlDbType.Int, 4); detailidpara.Value = usr_corpbilldetail.DetailId; paras.Add(detailidpara); SqlParameter corpbillidpara = new SqlParameter("@CorpBillId", SqlDbType.Int, 4); corpbillidpara.Value = usr_corpbilldetail.CorpBillId; paras.Add(corpbillidpara); SqlParameter empsalaryidpara = new SqlParameter("@EmpSalaryId", SqlDbType.Int, 4); empsalaryidpara.Value = usr_corpbilldetail.EmpSalaryId; paras.Add(empsalaryidpara); SqlParameter serviceamountpara = new SqlParameter("@ServiceAmount", SqlDbType.Decimal, 9); serviceamountpara.Value = usr_corpbilldetail.ServiceAmount; paras.Add(serviceamountpara); SqlParameter detailstatuspara = new SqlParameter("@DetailStatus", SqlDbType.Int, 4); detailstatuspara.Value = usr_corpbilldetail.DetailStatus; paras.Add(detailstatuspara); SqlParameter lastmodifyidpara = new SqlParameter("@LastModifyId", SqlDbType.Int, 4); lastmodifyidpara.Value = obj.LastModifyId; paras.Add(lastmodifyidpara); return(paras); }