public IHttpActionResult Putqa_questions(string id, qa_questions qa_questions)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != qa_questions.Id)
{
return(BadRequest());
}
db.Entry(qa_questions).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!qa_questionsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Putmethod(long id, method method)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != method.Id)
{
return(BadRequest());
}
db.Entry(method).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!methodExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public bool AddComment(AddCommentParam param)
{
var fields = db.data_source_fields.FirstOrDefault(a => param.FieldId == a.Id);
if (fields == null)
{
return(false);
}
fields.FieldComment = param.Comment;
db.SaveChanges();
return(true);
}
public JsonResult FindPwd(UserAccount param)
{
if (!ModelState.IsValid)
{
return(Json(new ReturnResult(2, Global.VerifyModel(ModelState))));
}
var code = MeCache <string> .Get(string.Format(MeCacheKey.EmailVerifyCode, param.Account) + "找回密码");
if (code != param.VerifyCode_Email)
{
return(Json(new ReturnResult(2, "邮箱验证码错误")));
}
using (var db = new DataMigrationEntities())
{
var user_account = db.user_account.FirstOrDefault(a => a.Email == param.Account);
if (user_account == null)
{
return(Json(ReturnResult.NotExist));
}
user_account.Password = param.Password;
user_account.Modifier = "self";
user_account.ModifyTime = DateTime.Now;
db.SaveChanges();
return(Json(ReturnResult.Ok));
}
}
public IHttpActionResult Postmethod(AddFieldMappingParam param)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var field_Mappings = new List <field_mapping>();
foreach (var item in param.fieldMapping)
{
var field_mapping = new field_mapping()
{
OrderId = param.orderId,
Creator = "1",
CreateTime = DateTime.Now,
TypeCode = string.Empty,
MethodCount = 1,
MethodId = item.method,
ModifyTime = DateTime.Now,
Modifier = "1",
FieldIn = item.field,
FieldOut = item.toField,
};
field_Mappings.Add(field_mapping);
}
db.field_mapping.AddRange(field_Mappings);
db.SaveChanges();
return(Ok());
}
public JsonResult Login(UserAccount param)
{
var token = Guid.NewGuid().ToString();
UserInfo userInfo = null;
if (!ModelState.IsValid)
{
return(Json(Global.VerifyModel(ModelState)));
}
using (var db = new DataMigrationEntities())
{
var user_account = db.user_account.FirstOrDefault(a => a.Email == param.Account);
if (user_account == null)
{
//注册流程
//验证账号
var vCode = MeCache <string> .Get(string.Format(MeCacheKey.EmailVerifyCode, param));
if (string.IsNullOrWhiteSpace(vCode))
{
var json = SendVerifyCodeToEmail(param);
return(SendVerifyCode(param));
}
if (param.Code != vCode)
{
return(Json(ReturnResult.Fail(null)));
}
user_account = new user_account
{
CreateTime = DateTime.Now,
Creator = "login_api",
Modifier = string.Empty,
ModifyTime = DateTime.Now,
Email = param.Account,
Account = param.Account,
HeadPortrait = string.Empty,
Mobile = string.Empty,
Nickname = string.Empty,
Password = "******",
TrueName = string.Empty,
};
db.user_account.Add(user_account);
db.SaveChanges();
userInfo = SetCache(user_account, token);
return(Json(new ReturnResult(0, token, userInfo)));
}
if (user_account.Password != param.Code)
{
return(Json(new ReturnResult(2, TipString.密码错误)));
}
userInfo = SetCache(user_account, token);
return(Json(new ReturnResult(0, token, userInfo)));
}
}
public IHttpActionResult Putdata_source(long id, data_source data_source)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (db.data_source.Any(a => a.DataSourceName == data_source.DataSourceName))
{
return(BadRequest(ModelState));
}
if (id != data_source.Id)
{
return(BadRequest());
}
db.Entry(data_source).State = EntityState.Modified;
try
{
var count = db.SaveChanges();
if (count > 0)
{
}
}
catch (DbUpdateConcurrencyException)
{
if (!data_sourceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public JsonResult Register(UserAccount param)
{
if (!ModelState.IsValid)
{
return(Json(new ReturnResult(2, Global.VerifyModel(ModelState))));
}
var code = MeCache <string> .Get(string.Format(MeCacheKey.EmailVerifyCode, param.Account));
if (code != param.VerifyCode_Email)
{
return(Json(new ReturnResult(2, "邮箱验证码错误")));
}
using (var db = new DataMigrationEntities())
{
var user_account = db.user_account.FirstOrDefault(a => a.Email == param.Account);
if (user_account != null)
{
return(Json(ReturnResult.IsExist()));
}
user_account = new user_account
{
CreateTime = DateTime.Now,
Creator = "login_api",
Modifier = string.Empty,
ModifyTime = DateTime.Now,
Email = param.Account,
Account = param.Account,
HeadPortrait = string.Empty,
Mobile = string.Empty,
Nickname = string.Empty,
Password = param.Password,
TrueName = string.Empty,
};
db.user_account.Add(user_account);
db.SaveChanges();
return(Json(ReturnResult.Ok));
}
}
public IHttpActionResult Post(AnswerParam param)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var group = db.qa_questions_group.FirstOrDefault(a => a.Id == param.Select_Group);
if (group == null)
{
throw new CheckException("group不存在");
}
var qData = JsonConvert.DeserializeObject <List <qa_questionsView> >(param.SelectVar);
var ids = new List <string>();
GetIds(qData, ids);
List <qa_answer> qas = new List <qa_answer>();
foreach (var item in ids)
{
var q = db.qa_questions.FirstOrDefault(a => a.Id == item);
if (q != null)
{
var qa = new qa_answer();
qa.Id = Guid.NewGuid().ToString();
qa.LastUpdateUser = qa.Creater = "1";
qa.LastUpdateUserName = qa.CreaterName = "测试";
qa.LastUpdateTime = qa.CreateTime = DateTime.Now;
qa.Status = (sbyte)DataState.Normal;
qa.StatusDesc = DataState.Normal.GetDescription();
qa.LastUpdateUser = param.Select_Group;
qa.wt_id = q.Id;
qa.wt_score = q.score;
qa.dtr_id = param.UserName;
qas.Add(qa);
}
}
db.qa_answer.AddRange(qas);
var score = qas.Sum(a => a.wt_score);
var qa_score = new qa_score();
qa_score.Id = Guid.NewGuid().ToString();
qa_score.LastUpdateUser = qa_score.Creater = "1";
qa_score.LastUpdateUserName = qa_score.CreaterName = param.UserName;
qa_score.LastUpdateTime = qa_score.CreateTime = DateTime.Now;
qa_score.Status = (sbyte)DataState.Normal;
qa_score.StatusDesc = DataState.Normal.GetDescription();
qa_score.score = score;
qa_score.tz_id = param.Select_Group;
qa_score.tz_name = group.Name;
qa_score.dtr_id = param.UserName;
db.qa_score.Add(qa_score);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (qa_questionsExists(qa_score.Id))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = qa_score.Id }, param));
}