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