public override IModel CreateModel(SqlDataReader dr)
{
ContractDept contractdept = new ContractDept();
int indexDetailId = dr.GetOrdinal("DetailId");
contractdept.DetailId = Convert.ToInt32(dr[indexDetailId]);
int indexContractId = dr.GetOrdinal("ContractId");
if (dr["ContractId"] != DBNull.Value)
{
contractdept.ContractId = Convert.ToInt32(dr[indexContractId]);
}
int indexDeptId = dr.GetOrdinal("DeptId");
if (dr["DeptId"] != DBNull.Value)
{
contractdept.DeptId = Convert.ToInt32(dr[indexDeptId]);
}
int indexDetailStatus = dr.GetOrdinal("DetailStatus");
if (dr["DetailStatus"] != DBNull.Value)
{
contractdept.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexDetailStatus]);
}
return contractdept;
}
public ResultModel LoadDeptByContractId(UserModel user, int contractId)
{
ResultModel result = new ResultModel();
try
{
List<SqlParameter> paras = new List<SqlParameter>();
SqlParameter para = new SqlParameter("@contractId", SqlDbType.Int, 4);
para.Value = contractId;
paras.Add(para);
int status = (int)Common.StatusEnum.已生效;
string cmdText = string.Format("select * from NFMT.dbo.Con_ContractDept where ContractId =@contractId and DetailStatus={0}", status);
DataTable dt = SqlHelper.ExecuteDataTable(this.ConnectString, cmdText, paras.ToArray(), CommandType.Text);
List<ContractDept> contractDepts = new List<ContractDept>();
foreach (DataRow dr in dt.Rows)
{
ContractDept contractdept = new ContractDept();
contractdept.DetailId = Convert.ToInt32(dr["DetailId"]);
if (dr["ContractId"] != DBNull.Value)
{
contractdept.ContractId = Convert.ToInt32(dr["ContractId"]);
}
if (dr["DeptId"] != DBNull.Value)
{
contractdept.DeptId = Convert.ToInt32(dr["DeptId"]);
}
if (dr["DetailStatus"] != DBNull.Value)
{
contractdept.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr["DetailStatus"]);
}
contractDepts.Add(contractdept);
}
result.AffectCount = dt.Rows.Count;
result.Message = "获取列表成功";
result.ResultStatus = 0;
result.ReturnValue = contractDepts;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return result;
}
