protected override IModel CreateModel(SqlDataReader dr)
{
SupBillDetail supbilldetail = new SupBillDetail();
int indexDetailId = dr.GetOrdinal("DetailId");
supbilldetail.DetailId = Convert.ToInt32(dr[indexDetailId]);
int indexSupBillId = dr.GetOrdinal("SupBillId");
if (dr[indexSupBillId] != DBNull.Value)
{
supbilldetail.SupBillId = Convert.ToInt32(dr[indexSupBillId]);
}
int indexEmpSalaryId = dr.GetOrdinal("EmpSalaryId");
if (dr[indexEmpSalaryId] != DBNull.Value)
{
supbilldetail.EmpSalaryId = Convert.ToInt32(dr[indexEmpSalaryId]);
}
int indexServiceAmount = dr.GetOrdinal("ServiceAmount");
if (dr[indexServiceAmount] != DBNull.Value)
{
supbilldetail.ServiceAmount = Convert.ToDecimal(dr[indexServiceAmount]);
}
int indexDetailStatus = dr.GetOrdinal("DetailStatus");
if (dr[indexDetailStatus] != DBNull.Value)
{
supbilldetail.DetailStatus = Convert.ToInt32(dr[indexDetailStatus]);
}
int indexCreatorId = dr.GetOrdinal("CreatorId");
if (dr[indexCreatorId] != DBNull.Value)
{
supbilldetail.CreatorId = Convert.ToInt32((dr[indexCreatorId]));
}
int indexCreateTime = dr.GetOrdinal("CreateTime");
if (dr[indexCreateTime] != DBNull.Value)
{
supbilldetail.CreateTime = Convert.ToDateTime(dr[indexCreateTime]);
}
int indexLastModifyId = dr.GetOrdinal("LastModifyId");
if (dr[indexLastModifyId] != DBNull.Value)
{
supbilldetail.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]);
}
int indexLastModifyTime = dr.GetOrdinal("LastModifyTime");
if (dr[indexLastModifyTime] != DBNull.Value)
{
supbilldetail.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]);
}
return(supbilldetail);
}
protected override List <SqlParameter> CreateInsertParameters(IModel obj, ref SqlParameter returnValue)
{
SupBillDetail usr_supbilldetail = (SupBillDetail)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 supbillidpara = new SqlParameter("@SupBillId", SqlDbType.Int, 4);
supbillidpara.Value = usr_supbilldetail.SupBillId;
paras.Add(supbillidpara);
SqlParameter empsalaryidpara = new SqlParameter("@EmpSalaryId", SqlDbType.Int, 4);
empsalaryidpara.Value = usr_supbilldetail.EmpSalaryId;
paras.Add(empsalaryidpara);
SqlParameter serviceamountpara = new SqlParameter("@ServiceAmount", SqlDbType.Decimal, 9);
serviceamountpara.Value = usr_supbilldetail.ServiceAmount;
paras.Add(serviceamountpara);
SqlParameter detailstatuspara = new SqlParameter("@DetailStatus", SqlDbType.Int, 4);
detailstatuspara.Value = usr_supbilldetail.DetailStatus;
paras.Add(detailstatuspara);
SqlParameter creatoridpara = new SqlParameter("@CreatorId", SqlDbType.VarChar, 10);
creatoridpara.Value = obj.CreatorId;
paras.Add(creatoridpara);
return(paras);
}
public override List <SqlParameter> CreateUpdateParameters(IModel obj)
{
SupBillDetail usr_supbilldetail = (SupBillDetail)obj;
List <SqlParameter> paras = new List <SqlParameter>();
SqlParameter detailidpara = new SqlParameter("@DetailId", SqlDbType.Int, 4);
detailidpara.Value = usr_supbilldetail.DetailId;
paras.Add(detailidpara);
SqlParameter supbillidpara = new SqlParameter("@SupBillId", SqlDbType.Int, 4);
supbillidpara.Value = usr_supbilldetail.SupBillId;
paras.Add(supbillidpara);
SqlParameter empsalaryidpara = new SqlParameter("@EmpSalaryId", SqlDbType.Int, 4);
empsalaryidpara.Value = usr_supbilldetail.EmpSalaryId;
paras.Add(empsalaryidpara);
SqlParameter serviceamountpara = new SqlParameter("@ServiceAmount", SqlDbType.Decimal, 9);
serviceamountpara.Value = usr_supbilldetail.ServiceAmount;
paras.Add(serviceamountpara);
SqlParameter detailstatuspara = new SqlParameter("@DetailStatus", SqlDbType.Int, 4);
detailstatuspara.Value = usr_supbilldetail.DetailStatus;
paras.Add(detailstatuspara);
SqlParameter lastmodifyidpara = new SqlParameter("@LastModifyId", SqlDbType.Int, 4);
lastmodifyidpara.Value = obj.LastModifyId;
paras.Add(lastmodifyidpara);
return(paras);
}
