public int PublishingAdd(Publisher_Certificate pcertificate)
{
GetProvince();
pcertificate.UnifiedSocial = _UnifiedSocial;
pcertificate.CertificatePublica = _CertificatePublica;
var result = Convert.ToInt32(WebApiHelper.GetApiResult("post", "Jurisdiction", "PublisherAdd", pcertificate));
return(result);
}
/// <summary>
/// 添加企业资质证明并返回自增列
/// </summary>
/// <param name="pcertificate"></param>
/// <returns></returns>
public int AddCertificate(Publisher_Certificate pcertificate)
{
Certificate certificate = new Certificate()
{
CertificatePublica = pcertificate.CertificatePublica,
PublicationQualif = pcertificate.PublicationQualif,
RegTime = pcertificate.RegTime,
Type = pcertificate.Type,
UnifiedSocial = pcertificate.UnifiedSocial
};
var result = db.Insertable(certificate).ExecuteReturnIdentity();
return(result);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="pcertificate"></param>
/// <returns></returns>
public int AddUser(Publisher_Certificate pcertificate)
{
User user = new User()
{
IsEnabled = 1,
SubmissionState = 1,
UserInfoId = pcertificate.UserInfoId,
UserName = pcertificate.UserName,
UserPwd = pcertificate.UserPwd,
UserTypeId = pcertificate.UserTypeId
};
var result = db.Insertable(user).ExecuteCommand();
return(result);
}
public int PublisherAdd(Publisher_Certificate pcertificate)
{
//添加资质证明并返回自增id
var certificateid = _publisher.AddCertificate(pcertificate);
//赋值
pcertificate.CertificateId = certificateid;
//添加个人信息并返回自增id
var publisherid = _publisher.AddPublisher(pcertificate);
//赋值
pcertificate.UserInfoId = publisherid;
pcertificate.UserTypeId = 1;
//添加账户
var result = _publisher.AddUser(pcertificate);
return(result);
}
/// <summary>
/// 添加出版单位详情并返回自增列
/// </summary>
/// <param name="pcertificate"></param>
/// <returns></returns>
public int AddPublisher(Publisher_Certificate pcertificate)
{
Publisher publisher = new Publisher()
{
ApplicantEmail = pcertificate.ApplicantEmail,
ApplicantName = pcertificate.ApplicantName,
OfficeTel = pcertificate.OfficeTel,
MovTel = pcertificate.MovTel,
BaseId = pcertificate.BaseId,
PublishingEntity = pcertificate.PublishingEntity,
PublisheChinese = pcertificate.PublisheChinese,
PublisherEnglish = pcertificate.PublisherEnglish,
CreditCode = pcertificate.CreditCode,
Publication = pcertificate.Publication,
ScopePublicati = pcertificate.ScopePublicati,
MailingAddress = pcertificate.MailingAddress,
Postcode = pcertificate.Postcode,
PublisherWebsit = pcertificate.PublisherWebsit,
Sponsor = pcertificate.Sponsor,
GoverningBody = pcertificate.GoverningBody,
ApplicationTime = DateTime.Now,
RepresentativeName = pcertificate.RepresentativeName,
RepresentativeTel = pcertificate.RepresentativeTel,
RepresentativePhon = pcertificate.RepresentativePhon,
RepresentativePost = pcertificate.RepresentativePost,
RepresentativeFax = pcertificate.RepresentativeFax,
RepresentativeEmai = pcertificate.RepresentativeEmai,
ContactName = pcertificate.ContactName,
ContactTel = pcertificate.ContactTel,
ContactPhone = pcertificate.ContactPhone,
ContactPerson = pcertificate.ContactPerson,
ContactFax = pcertificate.ContactFax,
ContactEmail = pcertificate.ContactEmail,
CertificateId = pcertificate.CertificateId
};
var result = db.Insertable(publisher).ExecuteReturnIdentity();
return(result);
}
