/// <summary>
/// 技术服务商个人信息并返回id
/// </summary>
/// <param name="fqualification"></param>
/// <returns></returns>
public int AddFacilitator(Facilitator_Qualification fqualification)
{
using (SqlSugarClient db = BaseDB.GetClient())
{
Facilitator facilitator = new Facilitator()
{
ApplicantEmail = fqualification.ApplicantEmail,
ApplicantName = fqualification.ApplicantName,
CellPhone = fqualification.CellPhone,
CompanyName = fqualification.CompanyName,
ContactEmail = fqualification.ContactEmail,
ContactName = fqualification.ContactName,
ContactNumber = fqualification.ContactNumber,
ContactPhone = fqualification.ContactPhone,
CreditCode = fqualification.CreditCode,
Email = fqualification.Email,
Postcode = fqualification.Postcode,
QualificationId = fqualification.QualificationId,
RegistrationAddres = fqualification.RegistrationAddres,
RegistrationCode = fqualification.RegistrationCode,
RepresentativeName = fqualification.RepresentativeName,
ServiceType = fqualification.ServiceType
};
var result = db.Insertable <Facilitator>(facilitator).ExecuteReturnIdentity();
return(result);
}
}
/// <summary>
/// 技术服务商资质证明添加
/// </summary>
/// <returns></returns>
public int QualificationAdd(int Type)
{
//从redis中取出
Facilitator_Qualification facilitator = RedisHelper.Get <Facilitator_Qualification>("fqualification");
facilitator.Type = Type;
facilitator.UnifiedSocial = _UnifiedSocial;
facilitator.RegTime = DateTime.Now;
var result = Convert.ToInt32(WebApiHelper.GetApiResult("post", "Jurisdiction", "QualificationAdd", facilitator));
return(result);
}
/// <summary>
/// 企业资质证明并返回id
/// </summary>
/// <param name="fqualification"></param>
/// <returns></returns>
public int AddQualification(Facilitator_Qualification fqualification)
{
using (SqlSugarClient db = BaseDB.GetClient())
{
Qualification qualification = new Qualification()
{
RegTime = DateTime.Now,
Type = fqualification.Type,
UnifiedSocial = fqualification.UnifiedSocial
};
var result = db.Insertable <Qualification>(qualification).ExecuteReturnIdentity();
return(result);
}
}
public int FacilitatorAdd(Facilitator_Qualification fqualification)
{
//添加资质证明并返回自增id
var qualificationid = _facilitator.AddQualification(fqualification);
//赋值
fqualification.QualificationId = qualificationid;
//添加个人信息并返回自增id
var facilitatorid = _facilitator.AddFacilitator(fqualification);
fqualification.UserInfoId = facilitatorid;
fqualification.UserTypeId = 2;
//添加账户
var result = _facilitator.AddUser(fqualification);
return(result);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="fqualification"></param>
/// <returns></returns>
public int AddUser(Facilitator_Qualification fqualification)
{
using (SqlSugarClient db = BaseDB.GetClient())
{
User user = new User()
{
IsEnabled = 1,
SubmissionState = 1,
UserInfoId = fqualification.UserInfoId,
UserName = fqualification.UserName,
UserPwd = fqualification.UserPwd,
UserTypeId = fqualification.UserTypeId
};
var result = db.Insertable(user).ExecuteCommand();
return(result);
}
}
public bool FacilitatorAdd(Facilitator_Qualification fqualification)
{
//存入redis中
RedisHelper.Set <Facilitator_Qualification>("fqualification", fqualification);
return(true);
}
