public ActionResult Index(string code) { U_WeChatUserID userInfo = new U_WeChatUserID(); string accessToken = Common.WeChatPush.WeChatTools.GetAccessoken(); string userInfoStr = Common.WeChatPush.WeChatTools.GetUserInfoByCode(accessToken, code); userInfo = Common.JsonHelper.JsonToModel <U_WeChatUserID>(userInfoStr);//用户ID //userInfo.UserId = "18936495119"; Business_Personnel_Information personInfoModel = _logic.GetUserInfo(userInfo.UserId); Personnel_Info Personnel = getPersonnelInfo(personInfoModel); Master_Organization organizationDetail = new Master_Organization(); organizationDetail = _ol.GetOrganizationDetail(personInfoModel.OwnedFleet.ToString()); Business_SurveyVaccination bsv = GetSurveyVaccination(userInfo.UserId); if (bsv == null) { bsv = new Business_SurveyVaccination(); bsv.Name = personInfoModel != null ? personInfoModel.Name : ""; bsv.UserID = userInfo.UserId; } //if (Personnel != null) //{ // bhs.Fleet = Personnel.MotorcadeName; // bhs.LicensePlate = Personnel.CabLicense; //} return(View(bsv)); }
public Business_SurveyVaccination GetSurveyVaccination(string userID) { Business_SurveyVaccination bsv = null; using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { bsv = _dbMsSql.Queryable <Business_SurveyVaccination>().Where(c => c.UserID == userID).FirstOrDefault(); } return(bsv); }
public JsonResult SaveSurveyVaccination(Business_SurveyVaccination bsv) { string result = "0"; try { var newUrlName = ""; var FileData = System.Web.HttpContext.Current.Request.Files; if (FileData.Count > 0) { newUrlName = SaveImageFile(FileData, bsv.UserID, bsv.Name); } using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { var isAny = _dbMsSql.Queryable <Business_SurveyVaccination>().Any(x => x.UserID == bsv.UserID); if (!isAny) { bsv.VGUID = Guid.NewGuid(); bsv.CreatedTime = DateTime.Now; bsv.CreatedUser = bsv.Name; bsv.ChangeUser = bsv.Name; bsv.ChangeTime = DateTime.Now; bsv.Attachment = newUrlName; _dbMsSql.Insert(bsv); } else { var index = 0; if (bsv.Attachment != "" && bsv.Attachment != null) { index = Regex.Matches(bsv.Attachment, ";").Count; } if (index == 1 && newUrlName == "") { newUrlName = bsv.Attachment; } _dbMsSql.Update <Business_SurveyVaccination>( new { IsInoculation = bsv.IsInoculation, FirstDate = bsv.FirstDate, FirstAddress = bsv.FirstAddress, SecondDate = bsv.SecondDate, SecondAddress = bsv.SecondAddress, Attachment = newUrlName, UserID = bsv.UserID, Name = bsv.Name, ChangeUser = bsv.Name, ChangeTime = DateTime.Now }, c => c.UserID == bsv.UserID); } } } catch (Exception ex) { LogHelper.WriteLog(ex.ToString()); result = "1"; } return(Json(result)); }