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 = "13524338060"; DateTime currentDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); Business_Personnel_Information personInfoModel = _logic.GetUserInfo(userInfo.UserId); //Business_VehicleRepairComplaints vrc = _bvrc.GetVehicleRepairComplaint(userInfo.UserId, currentDate); Business_VehicleRepairComplaints vrc = null; if (vrc == null) { vrc = new Business_VehicleRepairComplaints(); vrc.ReflectJobNumber = personInfoModel.JobNumber; //vrc.CarNumber = personInfoModel.LicensePlate; vrc.ContactNumber = personInfoModel.PhoneNumber; vrc.ReflectName = personInfoModel != null ? personInfoModel.Name : ""; vrc.ReflectDate = currentDate; vrc.CreateUser = userInfo.UserId; } return(View(vrc)); }
public Business_VehicleRepairComplaints GetVehicleRepairComplaint(string userid, DateTime date) { Business_VehicleRepairComplaints vehicleRepairComplaints = null; using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { vehicleRepairComplaints = _dbMsSql.Queryable <Business_VehicleRepairComplaints>().Where(c => c.CreateUser == userid & c.ReflectDate == date).FirstOrDefault(); } return(vehicleRepairComplaints); }
public ActionResult SaveVehicleRepairComplaints(Business_VehicleRepairComplaints vrc) { string result = "0"; try { _bvrc.UpdateBusiness_VehicleRepairComplaints(vrc); } catch (Exception ex) { Common.LogHelper.LogHelper.WriteLog(ex.ToString()); result = "1"; } return(Content(result)); }
public void UpdateBusiness_VehicleRepairComplaints(Business_VehicleRepairComplaints vehicleRepairComplaints) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { if (vehicleRepairComplaints.VGUID == Guid.Empty) { vehicleRepairComplaints.VGUID = Guid.NewGuid(); vehicleRepairComplaints.CreateDate = DateTime.Now; vehicleRepairComplaints.ChangeDate = DateTime.Now; vehicleRepairComplaints.ChangeUser = vehicleRepairComplaints.CreateUser; _dbMsSql.Insert(vehicleRepairComplaints); } else { vehicleRepairComplaints.ReflectDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); vehicleRepairComplaints.ChangeDate = DateTime.Now; vehicleRepairComplaints.ChangeUser = vehicleRepairComplaints.CreateUser; _dbMsSql.Update(vehicleRepairComplaints); } } }
public void UpdateBusiness_VehicleRepairComplaints(Business_VehicleRepairComplaints bvrc) { _bvrc.UpdateBusiness_VehicleRepairComplaints(bvrc); }