public int UpdateServiceInformationBuIndID(ServiceInformation serviceInformation)
{
iwaywardDataContext db = new iwaywardDataContext();
try
{
var result = db.ServiceInformation.Single(c => c.ServicID == serviceInformation.ServicID && c.UserID == serviceInformation.UserID);
result.title = serviceInformation.title;
result.serviceTyoe = serviceInformation.serviceTyoe;
result.sendTime = serviceInformation.sendTime;
result.IndID = serviceInformation.IndID;
result.region = serviceInformation.region;
result.city = serviceInformation.city;
result.province = serviceInformation.province;
result.macrk = serviceInformation.macrk;
result.longitude = serviceInformation.longitude;
result.latitude = serviceInformation.latitude;
db.SubmitChanges();
return(result.ServicID);
}
catch
{
return(0);
}
}
/// <summary>
/// 根据resumeId修改简历信息
/// </summary>
/// <param name="r"></param>
/// <returns></returns>
public string UpdatResumeByResumeID(resume r)
{
iwaywardDataContext db = new iwaywardDataContext();
try
{
var result = (from item in db.resume where item.resumeID == r.resumeID select item).Single();
result.resumeID = r.resumeID;
result.userID = r.userID;
result.jobState = r.jobState;
result.resumeState = r.resumeState;
result.myEdu = r.myEdu;
result.jobYear = r.jobYear;
result.toAddress = r.toAddress;
result.industry = r.industry;
result.position = r.position;
result.salary = r.salary;
result.research = r.research;
result.jobID = r.jobID;
result.projectID = r.projectID;
db.SubmitChanges();
return(result.resumeID.ToString());
}
catch
{
return(string.Empty);
}
}
public int UpdatePositionInfoByJobID(positionInfo post)
{
iwaywardDataContext db = new iwaywardDataContext();
try
{
var result = (from item in db.positionInfo where item.posID == post.posID select item).Single();
result.posID = post.posID;
result.userID = post.userID;
result.companyID = post.companyID;
result.posName = post.posName;
result.createTime = post.createTime;
result.region = post.region;
result.city = post.city;
result.province = post.province;
result.record = post.record;
result.recruitment = post.recruitment;
result.range = post.range;
result.posstate = post.posstate;
result.posType = post.posType;
result.requirements = post.requirements;
db.SubmitChanges();
return(int.Parse(result.posID.ToString()));
}
catch
{
return(0);
}
}
/// <summary>
/// 根据UserId修改用户信息
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public string UpdateUserInfoByUserID(UserInfo user)
{
iwaywardDataContext db = new iwaywardDataContext();
try {
var result = (from item in db.UserInfo where item.userID == user.userID select item).Single();
result.userName = user.userName;
result.age = user.age;
result.sex = user.sex;
result.headUrl = user.headUrl;
result.nickName = user.nickName;
result.region = user.region;
result.city = user.city;
result.province = user.province;
result.mail = user.mail;
result.qqNo = user.qqNo;
result.sinaID = user.sinaID;
result.tengID = user.tengID;
result.weixinID = user.weixinID;
result.weixinName = user.weixinName;
result.weixinTwo = user.weixinTwo;
result.professional = user.professional;
result.industry = user.industry;
result.position = user.position;
result.erweima = user.erweima;
result.zhuceTime = user.zhuceTime;
result.qianming = user.qianming;
db.SubmitChanges();
return(result.userID);
}
catch {
return(string.Empty);
}
}
public int DeletePositionInfoByJobID(int posID)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var user = from c in db.positionInfo where c.posID == posID select c;
if (user.Count() > 0)
{
db.positionInfo.DeleteAllOnSubmit(user);
count = db.positionInfo.Where(c => c.posID == posID).Count();
}
return(count);
}
public int DeleteCompanyTableByComId(int companyID)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var user = from c in db.companyTable where c.companyID == companyID select c;
if (user.Count() > 0)
{
db.companyTable.DeleteAllOnSubmit(user);
count = db.companyTable.Where(c => c.companyID == companyID).Count();
}
return(count);
}
public int DeleteCodeByCodeID(string CodeID)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var code = from c in db.CODE where c.CodeID == CodeID select c;
if (code.Count() > 0)
{
db.CODE.DeleteAllOnSubmit(code);
count = db.CODE.Where(c => c.CodeID == CodeID).Count();
}
return(count);
}
public int DeleteIndustryByIndID(int indID)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var user = from c in db.industry where c.IndID == indID select c;
if (user.Count() > 0)
{
db.industry.DeleteAllOnSubmit(user);
count = db.industry.Where(c => c.IndID == indID).Count();
}
return(count);
}
public int DeleteJobTableByJobID(int jobID)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var user = from c in db.jobTable where c.jobID == jobID select c;
if (user.Count() > 0)
{
db.jobTable.DeleteAllOnSubmit(user);
count = db.jobTable.Where(c => c.jobID == jobID).Count();
}
return(count);
}
//根据resumeId删除简历信息
public int DeleteResumeByResumeID(int resumeId)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var user = from c in db.resume where c.resumeID == resumeId select c;
if (user.Count() > 0)
{
db.resume.DeleteAllOnSubmit(user);
count = db.resume.Where(c => c.resumeID == resumeId).Count();
}
return(count);
}
public int DeleteCommentByCommID(int CommId)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var comment = from c in db.comments where c.commID == CommId select c;
if (comment.Count() > 0)
{
db.comments.DeleteAllOnSubmit(comment);
count = db.comments.Where(c => c.commID == CommId).Count();
}
return(count);
}
//根据UserID删除用户信息
public int DeleteUserInfoByUserID(string userID)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var user = from c in db.UserInfo where c.userID == userID select c;
if (user.Count() > 0)
{
db.UserInfo.DeleteAllOnSubmit(user);
count = db.UserInfo.Where(c => c.userID == userID).Count();
}
return(count);
}
public int DeletePersonnelRelationshipByUserID(string userID)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var user = from c in db.PersonnelRelationship where c.UserID == userID select c;
if (user.Count() > 0)
{
db.PersonnelRelationship.DeleteAllOnSubmit(user);
count = db.PersonnelRelationship.Where(c => c.UserID == userID).Count();
}
return(count);
}
public int DeleteServiceInformationByIndID(int ServiceID)
{
int count = 0;
iwaywardDataContext db = new iwaywardDataContext();
var code = from c in db.ServiceInformation where c.ServicID == ServiceID select c;
if (code.Count() > 0)
{
db.ServiceInformation.DeleteAllOnSubmit(code);
count = db.ServiceInformation.Where(c => c.ServicID == ServiceID).Count();
}
return(count);
}
/// <summary>
/// 获取简历信息
/// </summary>
/// <returns></returns>
public IList <resume> GetResume()
{
iwaywardDataContext db = new iwaywardDataContext();
IEnumerable <resume> r = from c in db.resume select c;
if (r != null)
{
return(r.ToList <resume>());
}
else
{
return(new List <resume>());
}
}
public IList <positionInfo> GetListPositionInfo(int posID)
{
iwaywardDataContext db = new iwaywardDataContext();
IEnumerable <positionInfo> attInd = from c in db.positionInfo where c.posID == posID select c;
if (attInd != null)
{
return(attInd.ToList <positionInfo>());
}
else
{
return(null);
}
}
public ServiceInformation GetServiceInformation(int ServiceID, string UserId)
{
iwaywardDataContext db = new iwaywardDataContext();
if (db.ServiceInformation.Count() > 0)
{
var code = db.ServiceInformation.Single(c => c.ServicID == ServiceID && c.UserID == UserId);
return(code);
}
else
{
return(null);
}
}
public IList <servicepipei> GetServicepipei()
{
iwaywardDataContext db = new iwaywardDataContext();
IEnumerable <servicepipei> attInd = from c in db.servicepipei select c;
if (attInd != null)
{
return(attInd.ToList <servicepipei>());
}
else
{
return(new List <servicepipei>());
}
}
/// <summary>
/// 根据UserId获取用户信息
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public UserInfo GetUserInfo(string userID)
{
iwaywardDataContext db = new iwaywardDataContext();
if (db.UserInfo.Count() > 0)
{
var user = db.UserInfo.Single(c => c.userID == userID);
return(user);
}
else
{
return(null);
}
}
public comments GetComment(int commID)
{
iwaywardDataContext db = new iwaywardDataContext();
if (db.comments.Count() > 0)
{
var comm = db.comments.Single(c => c.commID == commID);
return(comm);
}
else
{
return(null);
}
}
public AttentionIndustry GetAttentionIndustry(string UserId)
{
iwaywardDataContext db = new iwaywardDataContext();
if (db.AttentionIndustry.Count() > 0)
{
var user = db.AttentionIndustry.Single(c => c.UserID == UserId);
return(user);
}
else
{
return(null);
}
}
public IList <AttentionIndustry> GetAttentionIndustry()
{
iwaywardDataContext db = new iwaywardDataContext();
IEnumerable <AttentionIndustry> attInd = from c in db.AttentionIndustry select c;
if (attInd != null)
{
return(attInd.ToList <AttentionIndustry>());
}
else
{
return(new List <AttentionIndustry>());
}
}
public servicepipei GetServicepipei(string UserId)
{
iwaywardDataContext db = new iwaywardDataContext();
if (db.servicepipei.Count() > 0)
{
var user = db.servicepipei.Single(c => c.UserID == UserId);
return(user);
}
else
{
return(null);
}
}
/// <summary>
/// 根据resumeId获取简历信息
/// </summary>
/// <param name="resumeId"></param>
/// <returns></returns>
public resume GetResume(int resumeId)
{
iwaywardDataContext db = new iwaywardDataContext();
if (db.resume.Count() > 0)
{
var r = db.resume.Single(c => c.resumeID == resumeId);
return(r);
}
else
{
return(null);
}
}
public companyTable GetCompanyTable(int companyID)
{
iwaywardDataContext db = new iwaywardDataContext();
if (db.companyTable.Count() > 0)
{
var user = db.companyTable.Single(c => c.companyID == companyID);
return(user);
}
else
{
return(null);
}
}
public IList <ServiceInformation> GetServiceInformationforUserId(string UserId)
{
iwaywardDataContext db = new iwaywardDataContext();
IEnumerable <ServiceInformation> codes = from c in db.ServiceInformation where c.UserID == UserId select c;
if (codes != null)
{
return(codes.ToList <ServiceInformation>());
}
else
{
return(null);
}
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <returns></returns>
public IList <UserInfo> GetUserInfo()
{
iwaywardDataContext db = new iwaywardDataContext();
IEnumerable <UserInfo> userInfo = from c in db.UserInfo select c;
if (userInfo != null)
{
return(userInfo.ToList <UserInfo>());
}
else
{
return(new List <UserInfo>());
}
}
public IList <ServiceInformation> GetServiceInformation()
{
iwaywardDataContext db = new iwaywardDataContext();
IEnumerable <ServiceInformation> codes = from c in db.ServiceInformation select c;
if (codes != null)
{
return(codes.ToList <ServiceInformation>());
}
else
{
return(null);
}
}
public IList <comments> GetComment()
{
iwaywardDataContext db = new iwaywardDataContext();
IEnumerable <comments> comm = from c in db.comments select c;
if (comm != null)
{
return(comm.ToList <comments>());
}
else
{
return(new List <comments>());
}
}
public positionInfo GetPositionInfo(int posID)
{
iwaywardDataContext db = new iwaywardDataContext();
if (db.positionInfo.Count() > 0)
{
var user = db.positionInfo.Single(c => c.posID == posID);
return(user);
}
else
{
return(null);
}
}
