public void ProfessionalAdd(Tz888.Model.Register.SS_ProfessionalServices model)
{
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@NnitName", SqlDbType.VarChar, 50),
new SqlParameter("@CountryCode", SqlDbType.Char, 10),
new SqlParameter("@ProvinceID", SqlDbType.Int),
new SqlParameter("@CityID", SqlDbType.Int),
new SqlParameter("@AreaID", SqlDbType.Int),
new SqlParameter("@Job", SqlDbType.VarChar, 50),
new SqlParameter("@TalentType", SqlDbType.Int),
new SqlParameter("@ServiceSmalltype", SqlDbType.VarChar, 100),
new SqlParameter("@ServiceBigtype", SqlDbType.Int),
new SqlParameter("@Resume", SqlDbType.VarChar, 2000),
new SqlParameter("@Specialty", SqlDbType.VarChar, 2000),
new SqlParameter("@BefCase", SqlDbType.VarChar, 2000),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@FAX", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@Pic", SqlDbType.VarChar, 100),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Regdate", SqlDbType.DateTime),
new SqlParameter("@RealName", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.LoginName;
parameters[1].Value = model.NnitName;
parameters[2].Value = model.CountryCode;
parameters[3].Value = model.ProvinceID;
parameters[4].Value = model.CityID;
parameters[5].Value = model.AreaID;
parameters[6].Value = model.Job;
parameters[7].Value = model.TalentType;
parameters[8].Value = model.ServiceSmalltype;
parameters[9].Value = model.ServiceBigtype;
parameters[10].Value = model.Resume;
parameters[11].Value = model.Specialty;
parameters[12].Value = model.BefCase;
parameters[13].Value = model.Tel;
parameters[14].Value = model.FAX;
parameters[15].Value = model.Mobile;
parameters[16].Value = model.Address;
parameters[17].Value = model.Pic;
parameters[18].Value = model.Email;
parameters[19].Value = model.RegDate;
parameters[20].Value = model.RealName;
try
{
DbHelperSQL.RunProcedure("ProfessionalServicesInsert", parameters);
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
// DbHelperSQL.RunProcedure(
}
public bool SS_ProUpdate(Tz888.Model.Register.SS_ProfessionalServices model)
{
SqlParameter[] parameters =
{
new SqlParameter("@PSID", SqlDbType.Int),
new SqlParameter("@NnitName", SqlDbType.VarChar, 50),
new SqlParameter("@CountryCode", SqlDbType.Char, 10),
new SqlParameter("@ProvinceID", SqlDbType.Int),
new SqlParameter("@CityID", SqlDbType.Int),
new SqlParameter("@AreaID", SqlDbType.Int),
new SqlParameter("@Job", SqlDbType.VarChar, 50),
new SqlParameter("@TalentType", SqlDbType.Int),
new SqlParameter("@ServiceSmalltype", SqlDbType.VarChar, 100),
new SqlParameter("@ServiceBigtype", SqlDbType.Int),
new SqlParameter("@Resume", SqlDbType.VarChar, 2000),
new SqlParameter("@Specialty", SqlDbType.VarChar, 2000),
new SqlParameter("@BefCase", SqlDbType.VarChar, 2000),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@FAX", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@Pic", SqlDbType.VarChar, 100),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@RealName", SqlDbType.VarChar, 50),
new SqlParameter("@flag", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.PSID;
parameters[1].Value = model.NnitName;
parameters[2].Value = model.CountryCode;
parameters[3].Value = model.ProvinceID;
parameters[4].Value = model.CityID;
parameters[5].Value = model.AreaID;
parameters[6].Value = model.Job;
parameters[7].Value = model.TalentType;
parameters[8].Value = model.ServiceSmalltype;
parameters[9].Value = model.ServiceBigtype;
parameters[10].Value = model.Resume;
parameters[11].Value = model.Specialty;
parameters[12].Value = model.BefCase;
parameters[13].Value = model.Tel;
parameters[14].Value = model.FAX;
parameters[15].Value = model.Mobile;
parameters[16].Value = model.Address;
parameters[17].Value = model.Pic;
parameters[18].Value = model.Email;
parameters[19].Value = model.RealName;
parameters[20].Value = "Update";
return(DbHelperSQL.RunProcLob("ProfessionalServicesInsert", parameters));
}
public void ProfessionalAdd(Tz888.Model.Register.SS_ProfessionalServices model)
{
mode.ProfessionalAdd(model);
}
public bool SS_ProUpdate(Tz888.Model.Register.SS_ProfessionalServices model)
{
return(mode.SS_ProUpdate(model));
}
