/// <summary>
/// zxm 个人资料添加
/// </summary>
/// <param name="dlmodel"></param>
/// <returns></returns>
public int add_personal(CT_Drivers_List_New dlmodel)
{
SqlParameter[] parameters =
{
new SqlParameter("@MAU_Code", SqlDbType.BigInt),
new SqlParameter("@AU_Code", SqlDbType.BigInt),
new SqlParameter("@AU_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@AU_Married", SqlDbType.Bit),
new SqlParameter("@AU_Gender", SqlDbType.Bit),
new SqlParameter("@AU_B_date", SqlDbType.DateTime),
new SqlParameter("@AU_ID_Type", SqlDbType.Int),
new SqlParameter("@AU_ID_No", SqlDbType.NVarChar, 20),
new SqlParameter("@AU_Dr_Lic", SqlDbType.NVarChar, 20),
new SqlParameter("@AU_Education", SqlDbType.Int),
new SqlParameter("@DL_Rel", SqlDbType.Int),
new SqlParameter("@DL_Type", SqlDbType.Int),
new SqlParameter("@DL_Acc", SqlDbType.Int),
new SqlParameter("@DL_Cars", SqlDbType.NVarChar, 4000),
new SqlParameter("@DL_CI_Code", SqlDbType.Int),
};
parameters[0].Value = dlmodel.MAU_Code;
parameters[1].Value = dlmodel.AU_Code;
parameters[2].Value = dlmodel.AU_Name;;
parameters[3].Value = dlmodel.AU_Married;
parameters[4].Value = dlmodel.AU_Gender;
parameters[5].Value = dlmodel.AU_B_date;
parameters[6].Value = dlmodel.AU_ID_Type;
parameters[7].Value = dlmodel.AU_ID_No;
parameters[8].Value = dlmodel.AU_Dr_Lic;
parameters[9].Value = dlmodel.AU_Education;
parameters[10].Value = dlmodel.DL_Rel;
if (dlmodel.DL_Type == null)
{
parameters[11].Value = null;
}
else
if ((bool)dlmodel.DL_Type)
{
parameters[11].Value = 0;
}
else
{
parameters[11].Value = 1;
}
parameters[12].Value = dlmodel.DL_Acc;
parameters[13].Value = dlmodel.DL_Cars.Trim(',');
parameters[14].Value = dlmodel.DL_CI_Code;
return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "zxm_add_personal", parameters));
}
public int add_personal(CT_Drivers_List_New dlmodel)
{
return(new DL_UserEntity().add_personal(dlmodel));
}
