public IHttpActionResult DelRelation_UseGroup(Guid UseGroupID)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
Relation_UseGroup rrelation_UseGroupModel = new Relation_UseGroup();
rrelation_UseGroupModel.UseGroupID = UseGroupID;
if (transRelation_UseGroup.DelUseGroup_User(UseGroupID))//删除用户组用户信息
{
int i = useGroupAdapter.Remove(rrelation_UseGroupModel);
if (i > 0)
{
isSucceed.IsSucceed = true;
isSucceed.ErrorMessage = "删除成功";
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "删除失败";
}
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "删除用户组用户失败";
}
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "删除失败:" + ex.ToString();
}
return(Json(isSucceed));
}
public IHttpActionResult DelRelation_UseGroup(Guid ItID)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
SYS_IdentityType sYS_IdentityType = new SYS_IdentityType();
sYS_IdentityType.ItID = ItID;
int i = SYS_IdentityTypeAdapter.Instance.Remove(sYS_IdentityType);
if (i > 0)
{
isSucceed.IsSucceed = true;
isSucceed.ErrorMessage = "删除成功";
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "删除失败";
}
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "删除失败:" + ex.ToString();
}
return(Json(isSucceed));
}
public IHttpActionResult AddOrUpdateSYSCollege([FromBody] SYS_College syscollege)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
//用户
SYS_College college = adapter.GetAll().Where(w => w.CID == syscollege.CID).FirstOrDefault();
if (college == null)//添加
{
college.CID = Guid.NewGuid();
}
int i = adapter.AddOrUpdate(syscollege);
if (i > 0)
{
isSucceed.IsSucceed = true;
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "无操作记录!";
}
return(Json(isSucceed));
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return(Json(isSucceed));
}
}
public IHttpActionResult DeleteRelationUserAttentionTheme([FromBody]RelationUserAttentionThemeModel model)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
int i = relationUserAttentionThemeAdapter.Remove(model);
if (i > 0)
{
isSucceed.IsSucceed = true;
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "无操作记录!";
}
return Json(isSucceed);
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return Json(isSucceed);
}
}
/// <summary>
/// 保存用户头像
/// </summary>
public async Task <WebModelIsSucceed> SaveUserFile(Guid useruuid, string localpath)
{
UserPersonalHomepageAdapter adapter = new UserPersonalHomepageAdapter();
UserAdapter useradapter = new UserAdapter();
UserModel userinfo = useradapter.GetAll().Where(s => s.UUID == useruuid).FirstOrDefault();
HttpFileCollection picColl = HttpContext.Current.Request.Files;
//int maxLength = 10971520;
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
List <UserPersonalHomepageModel> list = new List <UserPersonalHomepageModel>();
UserPersonalHomepageModel userph = adapter.GetAll().Where(s => s.UserID == useruuid).FirstOrDefault();
if (userph == null)
{
userph = new UserPersonalHomepageModel();
userph.UUID = Guid.NewGuid();
}
try
{
for (var i = 0; i < picColl.Count; i++)
{
HttpPostedFile file = picColl[i];
string type = file.ContentType;
//重命名
string[] oldFileNameList = file.FileName.Split('.');
// string fileName = userinfo.UserID + "." + oldFileNameList[1];
string fileName = oldFileNameList[0] + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "." + oldFileNameList[1];
// string locapath = System.Configuration.ConfigurationSettings.AppSettings["LocalImageUrl"];
attachment.SaveUserFile(file, fileName, localpath);
userph.UploadIMG = fileName;
userph.UserID = useruuid;
userph.AdministratorSettings = 0;
userph.ChineseVersion = "";
userph.EnglishVersion = "";
userph.PersonalHomepagePower = 0;
list.Add(userph);
}
await adapter.AddOrUpdateAsyncCollection(list);
isSucceed.IsSucceed = true;
return(isSucceed);
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message;
return(isSucceed);
}
}
/// <summary>
/// 保存附件
/// </summary>
public async Task <WebModelIsSucceed> SaveFile(Guid businessID)
{
using (OperationManagerDbContext db = new OperationManagerDbContext())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
HttpFileCollection picColl = HttpContext.Current.Request.Files;
//int maxLength = 10971520;
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
List <AttachmentModel> list = new List <AttachmentModel>();
try
{
for (var i = 0; i < picColl.Count; i++)
{
HttpPostedFile file = picColl[i];
string type = file.ContentType;
//重命名
string[] oldFileNameList = file.FileName.Split('.');
string fileName = oldFileNameList[0] + "_" + DateTime.Now.ToString("yyyy-MM-ddHH-mm-ss-fff") + "." + oldFileNameList[1];
attachment.SaveFile(file, fileName);
AttachmentModel model = new AttachmentModel
{
UUID = System.Guid.NewGuid(),
CreateTime = DateTime.Now,
ValidStatus = 1,
FileName = oldFileNameList[0],
FileType = oldFileNameList[1],
RelativePath = fileName,
FileLength = file.ContentLength / 1024,
BusinessID = businessID,
FileFullPath = "C:\\Files\\" + fileName
};
list.Add(model);
}
db.Attachment.AddOrUpdate(list.ToArray());
isSucceed.IsSucceed = await db.SaveChangesAsync() > 0 ? true : false;
dbContextTransaction.Commit();
return(isSucceed);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return(isSucceed);
}
}
}
}
public async Task <IHttpActionResult> AddRrelation_UseGroup([FromBody] Relation_UseGroup model)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
if (!model.SponsorID.HasValue)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "邀请人信息有误!";
return(Json(isSucceed));
}
else if (string.IsNullOrEmpty(model.UseGroupName))
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "组名称不能为空!";
return(Json(isSucceed));
}
return(Json(await transRelation_UseGroup.AddOrUpdateRelation_UseGroup(model)));
}
public IHttpActionResult AddOrUpdateRelationUserAttentionTheme([FromBody]RelationUserAttentionThemeModel model)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
//
RelationUserAttentionThemeModel Model = relationUserAttentionThemeAdapter.GetAll().Where(w => w.UUID == model.UUID).FirstOrDefault();
if (Model == null)//添加
{
Model = new RelationUserAttentionThemeModel();
Model.UUID = Guid.NewGuid();
}
Model.CreateTime = model.CreateTime;
Model.ThemeID = model.ThemeID;
Model.ThemeName = model.ThemeName;
Model.SysUserID = model.SysUserID;
Model.ValidStatus = model.ValidStatus;
int i = relationUserAttentionThemeAdapter.AddOrUpdate(Model);
if (i > 0)
{
isSucceed.IsSucceed = true;
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "无操作记录!";
}
return Json(isSucceed);
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return Json(isSucceed);
}
}
public IHttpActionResult AddOrUpdateRrelation_UseGroup([FromBody] Relation_UseGroup model)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
Relation_UseGroup rrelation_UseGroupModel = useGroupAdapter.GetAll().Where(w => w.UseGroupID == model.UseGroupID).FirstOrDefault();
if (rrelation_UseGroupModel == null)//添加
{
rrelation_UseGroupModel = new Relation_UseGroup();
rrelation_UseGroupModel.UseGroupID = Guid.NewGuid();
rrelation_UseGroupModel.CreateTime = DateTime.Now;
}
rrelation_UseGroupModel.UseGroupName = model.UseGroupName;
rrelation_UseGroupModel.SponsorID = model.SponsorID;
rrelation_UseGroupModel.Describe = model.Describe;
rrelation_UseGroupModel.GroupType = model.GroupType;
rrelation_UseGroupModel.Sort = model.Sort;
int i = useGroupAdapter.AddOrUpdate(rrelation_UseGroupModel);
if (i > 0)
{
isSucceed.IsSucceed = true;
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "无操作记录!";
}
return(Json(isSucceed));
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return(Json(isSucceed));
}
}
public IHttpActionResult UpdateRelationUseGroupUser([FromBody] Relation_UseGroup_User useGroup_User)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
//用户组邀请信息
Relation_UseGroup_User useGroup_UserModel = relation_UseGroup_UserAdapter.GetAll().Where(w => w.UUID == useGroup_User.UUID).FirstOrDefault();
if (useGroup_UserModel == null)//
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "传过来的参数有误,请检查!";
return(Json(isSucceed));
}
useGroup_UserModel.UUID = useGroup_User.UUID;
useGroup_UserModel.Join = useGroup_User.Join;
int i = relation_UseGroup_UserAdapter.AddOrUpdate(useGroup_UserModel);
if (i > 0)
{
isSucceed.IsSucceed = true;
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "无操作记录!";
}
return(Json(isSucceed));
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return(Json(isSucceed));
}
}
public IHttpActionResult AddOrUpdateRrelation_UseGroup_User([FromBody] Relation_UseGroup_User model)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
Relation_UseGroup_User rrelation_UseGroup_UserModel = relation_UseGroup_UserAdapter.GetAll().Where(w => w.UseGroupID == model.UseGroupID).FirstOrDefault();
if (rrelation_UseGroup_UserModel == null)//添加
{
rrelation_UseGroup_UserModel = new Relation_UseGroup_User();
rrelation_UseGroup_UserModel.UUID = Guid.NewGuid();
rrelation_UseGroup_UserModel.InvitationTime = DateTime.Now;
}
rrelation_UseGroup_UserModel.UseGroupID = model.UseGroupID;
rrelation_UseGroup_UserModel.SysUserID = model.SysUserID;
rrelation_UseGroup_UserModel.Join = model.Join;
rrelation_UseGroup_UserModel.sort = model.sort;
int i = relation_UseGroup_UserAdapter.AddOrUpdate(rrelation_UseGroup_UserModel);
if (i > 0)
{
isSucceed.IsSucceed = true;
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "无操作记录!";
}
return(Json(isSucceed));
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return(Json(isSucceed));
}
}
public IHttpActionResult AddOrUpdateSYSIdentityType([FromBody] SYS_IdentityType model)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
SYS_IdentityType sYS_IdentityTypeModel = SYS_IdentityTypeAdapter.Instance.GetAll().Where(w => w.ItID == model.ItID).FirstOrDefault();
if (sYS_IdentityTypeModel == null)//添加
{
sYS_IdentityTypeModel = new SYS_IdentityType();
sYS_IdentityTypeModel.ItID = Guid.NewGuid();
sYS_IdentityTypeModel.DelFlag = 1;
}
sYS_IdentityTypeModel.IdentityTypeName = model.IdentityTypeName;
sYS_IdentityTypeModel.IdentityTypeEnglishName = model.IdentityTypeEnglishName;
sYS_IdentityTypeModel.Sort = model.Sort;
int i = SYS_IdentityTypeAdapter.Instance.AddOrUpdate(sYS_IdentityTypeModel);
if (i > 0)
{
isSucceed.IsSucceed = true;
}
else
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = "无操作记录!";
}
return(Json(isSucceed));
}
catch (Exception ex)
{
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return(Json(isSucceed));
}
}
/// <summary>
/// 添加文献信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <WebModelIsSucceed> AddOrUpdateProductionsField(ProductionsModel model)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
using (OperationManagerDbContext db = new OperationManagerDbContext())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
List <ProductionsField> list = new List <ProductionsField>();
//作品文献表
try
{
#region 文献
Production productions = new Production();
productions.ProductionID = Guid.NewGuid();
productions.TemplateID = model.TemplateID;
productions.IsUploadFileFlag = model.IsUploadFileFlag;
productions.UserID = model.UserID;
productions.DownloadNum = 0;
productions.BrowseNum = 0;
productions.CreateTime = DateTime.Now;
foreach (var fieldList in model.DicProductionsField)
{
ProductionsField productionsField = new ProductionsField();
productionsField.UUID = Guid.NewGuid();
productionsField.ProductionID = productions.ProductionID;
productionsField.TemplateID = model.TemplateID;
productionsField.MetaDataID = fieldList.MetaDataID;
productionsField.FieldSequence = fieldList.FieldSequence;
productionsField.DefaultText = fieldList.DefaultText;
productionsField.DefaultValue = fieldList.DefaultValue;
productionsField.Remark = fieldList.Remark;
productionsField.FieldValue = fieldList.FieldValue;
list.Add(productionsField);
}
db.Production.AddOrUpdate(productions);
db.ProductionsField.AddOrUpdate(list.ToArray());
#endregion
#region 未认领
RelationUserClaimWorksModel rcw = new RelationUserClaimWorksModel();
rcw.ProductionID = productions.ProductionID + "";
rcw.UserClaimWorksID = Guid.NewGuid();
rcw.SysUserID = model.UserID;
rcw.UserClaimWorksStatus = 0;
rcw.IsHave = 0;
rcw.AuthorOrder = 0;
rcw.CorrespondenceAuthor = 0;
rcw.ParticipatingAuthor = 0;
db.RelationUserClaimWorks.AddOrUpdate(rcw);
#endregion
#region 大表
List <SYS_MetaData> list_Meta = await db.SYS_MetaData.ToListAsync();
StaticProductions staticProductions = new StaticProductions();
staticProductions.ProductionID = productions.ProductionID;
staticProductions.TemplateID = productions.TemplateID.Value;
staticProductions.CreateTime = DateTime.Now;
staticProductions.UserID = productions.UserID;
staticProductions.DataType = model.TemplateName;
#region 元数据赋值
staticProductions.Abstract = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "abstract")).ToList());
staticProductions.Author = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "author")).ToList());
staticProductions.Chemicallist = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "chemicallist")).ToList());
staticProductions.Citations = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "citations")).ToList());
staticProductions.Cn = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "cn")).ToList());
staticProductions.Cooperation = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "cooperation")).ToList());
staticProductions.Correspondent = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "correspondent")).ToList());
staticProductions.Correspondentemail = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "correspondentemail")).ToList());
staticProductions.Dataset = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "dataset")).ToList());
staticProductions.Department = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "department")).ToList());
staticProductions.Discipline = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "discipline")).ToList());
staticProductions.Doctype = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "doctype")).ToList());
staticProductions.Doi = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "doi")).ToList());
staticProductions.Ei = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "Ei")).ToList());
staticProductions.EnglishAbstract = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "EnglishAbstract")).ToList());
staticProductions.FirstAuthor = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "FirstAuthor")).ToList());
staticProductions.Fulljournaltitle = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "fulljournaltitle")).ToList());
staticProductions.Funder = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "funder")).ToList());
staticProductions.Indexed = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "indexed")).ToList());
staticProductions.Institution = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "institution")).ToList());
staticProductions.Iso = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "iso")).ToList());
staticProductions.Issn = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "issn")).ToList());
staticProductions.Issue = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "issue")).ToList());
staticProductions.Issued = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "issued")).ToList());
staticProductions.Jigouyuanxi = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "jigouyuanxi")).ToList());
staticProductions.Journalabbreviation = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "journalabbreviation")).ToList());
staticProductions.Keyword = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "keyword")).ToList());
staticProductions.Keywords_plus = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "keywords_plus")).ToList());
staticProductions.Link = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "link")).ToList());
staticProductions.Orcid = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "orcid")).ToList());
staticProductions.Pages = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "pages")).ToList());
staticProductions.Pmid = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "pmid")).ToList());
staticProductions.Project = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "project")).ToList());
staticProductions.Projectno = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "projectno")).ToList());
staticProductions.Publisher = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "Publisher")).ToList());
staticProductions.Rank = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "rank")).ToList());
staticProductions.Reference = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "reference")).ToList());
staticProductions.Referencecount = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "referencecount")).ToList());
staticProductions.Resulttype = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "resulttype")).ToList());
staticProductions.Source = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "source")).ToList());
staticProductions.Subjectword = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "subjectword")).ToList());
staticProductions.Sumpages = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "sumpages")).ToList());
staticProductions.Title = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "Title")).ToList());
staticProductions.Ut = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "ut")).ToList());
staticProductions.Version = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "version")).ToList());
staticProductions.Volume = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "volume")).ToList());
staticProductions.Webofscience = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "webofscience")).ToList());
staticProductions.Wos_headings = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "wos_headings")).ToList());
staticProductions.Wos_subject = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "wos_subject")).ToList());
staticProductions.Wos_subject_extended = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "wos_subject_extended")).ToList());
staticProductions.Woscitations = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "woscitations")).ToList());
staticProductions.Wosid = ListChangeString.GetString(list.Where(w => w.MetaDataID == GetMetaID(list_Meta, "wosid")).ToList());
#endregion
db.StaticProductions.AddOrUpdate(staticProductions);
#endregion
isSucceed.IsSucceed = await db.SaveChangesAsync() > 0 ? true : false;
OperationFiles operationFiles = new OperationFiles();
await operationFiles.SaveFile(productions.ProductionID);//上传文档信息
dbContextTransaction.Commit();
isSucceed.ErrorMessage = productions.ProductionID + "";
return(isSucceed);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return(isSucceed);
}
}
}
}
/// <summary>
/// 添加用户组信息 邀请人信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <WebModelIsSucceed> AddOrUpdateRelation_UseGroup(Relation_UseGroup model)
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
using (OperationManagerDbContext db = new OperationManagerDbContext())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
List <Relation_UseGroup_User> list = new List <Relation_UseGroup_User>();
try
{
Relation_UseGroup rrelation_UseGroupModel = null; // new Relation_UseGroup();// useGroupAdapter.GetAll().Where(w => w.UseGroupID == model.UseGroupID).FirstOrDefault();
if (rrelation_UseGroupModel == null) //添加
{
rrelation_UseGroupModel = new Relation_UseGroup();
rrelation_UseGroupModel.UseGroupID = Guid.NewGuid();
rrelation_UseGroupModel.CreateTime = DateTime.Now;
}
rrelation_UseGroupModel.UseGroupName = model.UseGroupName;
rrelation_UseGroupModel.SponsorID = model.SponsorID;
rrelation_UseGroupModel.Describe = model.Describe;
rrelation_UseGroupModel.GroupType = model.GroupType;
rrelation_UseGroupModel.Sort = model.Sort;
if (model.Relation_UseGroup_User != null)//邀请人信息
{
foreach (var Relation_UseGroup_User in model.Relation_UseGroup_User)
{
Relation_UseGroup_User relation_UseGroup_User = new Relation_UseGroup_User();
relation_UseGroup_User.UUID = Guid.NewGuid();
relation_UseGroup_User.UseGroupID = rrelation_UseGroupModel.UseGroupID;
relation_UseGroup_User.SysUserID = Relation_UseGroup_User.SysUserID;
relation_UseGroup_User.InvitationTime = DateTime.Now;
relation_UseGroup_User.Join = 0;
relation_UseGroup_User.sort = Relation_UseGroup_User.sort == null ? 0: Relation_UseGroup_User.sort;
list.Add(relation_UseGroup_User);
}
//加入创建组人信息 创建人自己
Relation_UseGroup_User relation_UseGroup_UserAdmin = new Relation_UseGroup_User();
relation_UseGroup_UserAdmin.UUID = Guid.NewGuid();
relation_UseGroup_UserAdmin.UseGroupID = rrelation_UseGroupModel.UseGroupID;
relation_UseGroup_UserAdmin.SysUserID = model.SponsorID;
relation_UseGroup_UserAdmin.InvitationTime = DateTime.Now;
relation_UseGroup_UserAdmin.Join = 1;
relation_UseGroup_UserAdmin.sort = 0;
list.Add(relation_UseGroup_UserAdmin);
}
db.Relation_UseGroup.AddOrUpdate(rrelation_UseGroupModel);
if (list.Count > 0)
{
db.Relation_UseGroup_User.AddOrUpdate(list.ToArray());
}
isSucceed.IsSucceed = await db.SaveChangesAsync() > 0 ? true : false;
dbContextTransaction.Commit();
return(isSucceed);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return(isSucceed);
}
}
}
}
public async Task <IHttpActionResult> Register([FromBody] RegisterUser registerUser)
{
WebModelIsSucceed model = new WebModelIsSucceed();
UserAdapter userAdapter = new UserAdapter();
string userEmail = registerUser.UserEmail;
UserModel user = await userAdapter.LoadUserByUserEmail(userEmail);
string telphone = registerUser.Telphone;
UserModel userph = await userAdapter.LoadUserByUserPhone(telphone);
int result = 0;
//验证电话号
if (userph != null && !string.IsNullOrEmpty(userph.Telphone))
{
if (userph.IsLogin == 1)
{
//未激活
userph.IsLogin = 0;
result = await userAdapter.AddOrUpdateAsync(userph);
if (result > 0)
{
model.IsSucceed = true;
}
else
{
model.IsSucceed = false;
model.ErrorMessage = "用户激活失败!";
}
}
else
{
//已激活
model.IsSucceed = false;
model.ErrorMessage = "此电话号码已激活,无需注册!";
}
}
//验证邮箱
else if (user != null && !string.IsNullOrEmpty(user.UserEmail))
{
if (user.IsLogin == 1)
{
//未激活
user.IsLogin = 0;
result = await userAdapter.AddOrUpdateAsync(user);
if (result > 0)
{
model.IsSucceed = true;
}
else
{
model.IsSucceed = false;
model.ErrorMessage = "用户激活失败!";
}
}
else
{
//已激活
model.IsSucceed = false;
model.ErrorMessage = "此邮箱已激活,无需注册!";
}
}
else
{
//邮箱未存在,在判断姓名和部门
UserModel userUnit = await userAdapter.LoadByUserNameAndUnit(registerUser.SurnameChinese, registerUser.NameChinese, registerUser.UnitID);
if (userUnit != null && !string.IsNullOrEmpty(Convert.ToString(userUnit.UnitID)))
{
//姓名和部门符合要求
if (userUnit.IsLogin == 1)
{
//未激活
userUnit.IsLogin = 0;
result = await userAdapter.AddOrUpdateAsync(userUnit);
return(Json(userUnit));
}
else
{
//已激活
model.IsSucceed = false;
model.ErrorMessage = "此姓名和部门已被注册过，无法注册！";
}
}
else
{
//添加数据
user = new UserModel();
user.UUID = Guid.NewGuid();
user.UserEmail = registerUser.UserEmail;
user.Telphone = registerUser.Telphone;
user.SurnameChinese = registerUser.SurnameChinese;
user.SurnamePhoneticize = registerUser.SurnamePhoneticize;
user.NameChinese = registerUser.NameChinese;
user.NamePhoneticize = registerUser.NamePhoneticize;
user.PassWord = MD5Method.Instance.MD5Encrypt(registerUser.Password);
user.UnitID = registerUser.UnitID;
user.DeptID = registerUser.DeptID;
user.PttID = registerUser.PttID;
user.ItID = registerUser.ItID;
result = await userAdapter.AddOrUpdateAsync(user);
if (result > 0)
{
model.IsSucceed = true;
return(Json(user));
}
else
{
model.IsSucceed = false;
model.ErrorMessage = "插入数据有误!";
}
}
}
return(Json(model));
}
/// <summary>
/// 用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public async Task <WebModelIsSucceed> AddOrUpdateUser(UserModel user)
{
using (OperationManagerDbContext db = new OperationManagerDbContext())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
try
{
//用户
//UserModel oldUser = userAdapter.GetAll().Where(w => w.UUID == user.UUID).FirstOrDefault();
UserModel oldUser = await db.User.Where(w => w.UUID == user.UUID).FirstOrDefaultAsync();
if (oldUser == null)//添加
{
oldUser.UUID = Guid.NewGuid();
}
oldUser.UserEmail = user.UserEmail;
oldUser.SurnameChinese = user.SurnameChinese;
oldUser.SurnamePhoneticize = user.SurnamePhoneticize;
oldUser.NameChinese = user.NameChinese;
oldUser.NamePhoneticize = user.NamePhoneticize;
oldUser.Orcid = user.Orcid;
oldUser.UserID = user.UserID;
oldUser.UnitID = user.UnitID;
oldUser.DeptID = user.DeptID;
oldUser.PttID = user.PttID;
oldUser.ItID = user.ItID;
oldUser.Telphone = user.Telphone;
oldUser.IsLogin = user.IsLogin;
oldUser.PassWord = user.PassWord;
oldUser.Degree = user.Degree;
oldUser.DegreeOpen = user.DegreeOpen;
oldUser.Education = user.Education;
oldUser.EducationOpen = user.EducationOpen;
oldUser.ResearchID = user.ResearchID;
oldUser.Tutor = user.Tutor;
oldUser.TutorOpen = user.TutorOpen;
oldUser.IsExpert = user.IsExpert;
oldUser.Sex = user.Sex;
oldUser.BirthDay = user.BirthDay;
oldUser.PoliticalStatus = user.PoliticalStatus;
oldUser.Nation = user.Nation;
oldUser.BirthPlace = user.BirthPlace;
oldUser.PlaceOrigin = user.PlaceOrigin;
oldUser.PersonalProfile = user.PersonalProfile;
oldUser.PersonalProfileEnglish = user.PersonalProfileEnglish;
db.User.AddOrUpdate(oldUser);
dbContextTransaction.Commit();
return(isSucceed);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
isSucceed.IsSucceed = false;
isSucceed.ErrorMessage = ex.Message + "\r\n" + ex.StackTrace;
return(isSucceed);
}
}
}
}
/// <summary>
/// 先禁用后增加合同表及附属表
/// </summary>
/// <returns></returns>
public async Task <WebModelIsSucceed> InsertCollectMoney(CollectMoneyInfo collectMoneyInfo, List <CollectMoneyImages> collectMoneyImages)
{
using (MySqlManagerDbContext db = new MySqlManagerDbContext())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
WebModelIsSucceed isSucceed = new WebModelIsSucceed();
db.CollectMoneyInfo.AddOrUpdate(collectMoneyInfo);
db.CollectMoneyImages.AddOrUpdate(collectMoneyImages.ToArray());
bool mysql = await db.SaveChangesAsync() > 0 ? true : false;
//如果还款金额等于应还金额 则表示已经还完！更新SQL逾期记录表 否则只更新mySql还款记录表
bool isUpdateSqlOverdueData = collectMoneyInfo.CollectMoney == collectMoneyInfo.ShouldCollectMoney ? true : false;
if (!isUpdateSqlOverdueData)
{
if (mysql)
{
isSucceed.IsSucceed = true;
dbContextTransaction.Commit();
}
else
{
isSucceed.IsSucceed = false;
dbContextTransaction.Rollback();
}
}
else
{
using (OperationManagerDbContext dbSql = new OperationManagerDbContext())
{
using (var dbContextTransactionSql = dbSql.Database.BeginTransaction())
{
bool sql = false;
//更新签约信息表 XD_Contractinfo
//ContractInfo contractModel = dbSql.ContractInfo.Where(w => w.Ordernum == collectMoneyInfo.OrderNum && w.STATUS == EnumStatus.Valid).FirstOrDefault();
//if (contractModel == null)
// contractModel = new ContractInfo();
//contractModel.RepaymentStatus = EnumRepayment.RepaymentFinish;
//dbSql.ContractInfo.AddOrUpdate(contractModel);
////添加还款明细XD_RepaymentDetails
//List<RepaymentDetails> overdueModelLst = dbSql.RepaymentDetails.Where(c => c.Ordernum == collectMoneyInfo.OrderNum&&c.RepaymentStatus== EnumRepaymentStatus.PaymentOverdue).ToList();
//foreach (var item in overdueModelLst)
//{
// item.RepaymentStatus = EnumRepaymentStatus.PaymentAllOverdue;
//}
//dbSql.RepaymentDetails.AddOrUpdate(overdueModelLst.ToArray());
////更新新逾期统计表OverdueStatistics
//OverdueStatistics overdueStatistics = dbSql.OverdueStatistics.Where(w => w.Ordernum == collectMoneyInfo.OrderNum).FirstOrDefault();
//if (overdueStatistics == null)
// return new WebModelIsSucceed() { IsSucceed = false, ErrorMessage = "订单逾期状态异常，还款失败！" };
//overdueStatistics.LastDrawTime = DateTime.Now;//最后还款时间
//overdueStatistics.PeriodsType = EnumCollectionPeriodsType.CollectionPeriodsTypeFinish;
//overdueStatistics.CollectionStatus = EnumCollectionStatus.CollectionStatusFinish;
//dbSql.OverdueStatistics.AddOrUpdate(overdueStatistics);
////更新逾期明细表(按月记录) OverdueDetailed
//List<OverdueDetailed> overdueDetailedLst = new List<OverdueDetailed>();
//overdueDetailedLst = dbSql.OverdueDetailedModel.Where(c => c.Ordernum == collectMoneyInfo.OrderNum).ToList();
//foreach (var item in overdueDetailedLst)
//{
// item.DisposeStatus = EnumDisposeStatus.DisposeStatusAll;
//}
//dbSql.OverdueDetailedModel.AddOrUpdate(overdueDetailedLst.ToArray());
//sql = await dbSql.SaveChangesAsync() > 0 ? true : false;
if (mysql && sql)
{
isSucceed.IsSucceed = true;
dbContextTransaction.Commit();
dbContextTransactionSql.Commit();
}
else
{
isSucceed.IsSucceed = false;
dbContextTransaction.Rollback();
dbContextTransactionSql.Rollback();
}
}
}
}
return(isSucceed);
}
}
}
