/// <summary> /// 保存部门信息 /// </summary> /// <param name="organizationModel"></param> /// <param name="isEdit"></param> /// <returns></returns> public bool Save(Master_Organization organizationModel, bool isEdit) { using (SqlSugarClient dbMsSql = SugarDao.SugarDao_MsSql.GetInstance()) { bool result = false; if (isEdit)//编辑 { var model = new { OrganizationName = organizationModel.OrganizationName, //OrganizationCode = organizationModel.OrganizationCode, Description = organizationModel.Description, ChangeDate = organizationModel.ChangeDate, ChangeUser = organizationModel.ChangeUser }; result = dbMsSql.Update <Master_Organization>(model, i => i.Vguid == organizationModel.Vguid); //存入操作日志表 string logData = JsonHelper.ModelToJson(organizationModel); _ll.SaveLog(4, 3, CurrentUser.GetCurrentUser().LoginName, organizationModel.OrganizationName, logData); } else//新增 { result = dbMsSql.Insert(organizationModel, false) != DBNull.Value; //存入操作日志表 string logData = JsonHelper.ModelToJson(organizationModel); _ll.SaveLog(1, 2, CurrentUser.GetCurrentUser().LoginName, organizationModel.OrganizationName, logData); } return(result); } }
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_HomecomingSurvey bhs = _hsl.GetHomecomingSurvey(userInfo.UserId, DateTime.Now.Year.ToString()); if (bhs == null) { bhs = new Business_HomecomingSurvey(); bhs.Name = personInfoModel != null ? personInfoModel.Name : ""; bhs.Year = DateTime.Now.Year.ToString(); bhs.CreatedUser = userInfo.UserId; } bhs.OrganizationName = organizationDetail.OrganizationName; if (Personnel != null) { bhs.Fleet = Personnel.MotorcadeName; bhs.LicensePlate = Personnel.CabLicense; } return(View(bhs)); }
/// <summary> /// 通过vguid获取部门详细信息 /// </summary> /// <param name="vguid"></param> /// <returns></returns> public JsonResult GetOrganizationDetail(string vguid) { Master_Organization organizationDetail = new Master_Organization(); organizationDetail = _ol.GetOrganizationDetail(vguid); return(Json(organizationDetail, JsonRequestBehavior.AllowGet)); }
public void getPartnerInfo(Business_Personnel_Information personInfoModel) { Master_Organization organizationDetail = new Master_Organization(); organizationDetail = _ol.GetOrganizationDetail(personInfoModel.OwnedFleet.ToString()); var ownedCompany = personInfoModel.OwnedCompany; if (ownedCompany == "全部") { ownedCompany = getAllOwnedCompany(organizationDetail.Description, "11"); } Personnel_Info Personnel = new Personnel_Info(); Personnel.IdCard = personInfoModel.IDNumber; Personnel.OldMotorcadeName = personInfoModel.OwnedFleet; //公司 Personnel.OldOrganization = ownedCompany; //车队 Personnel.Organization = organizationDetail.Description; //Personnel.Organization = "第一服务中心"; Personnel.MotorcadeName = ownedCompany;//车队 var key = PubGet.GetUserKey + personInfoModel.Vguid + "K"; var csche = CacheManager <Personnel_Info> .GetInstance().Get(key); if (csche != null) { CacheManager <Personnel_Info> .GetInstance().Remove(key); } CacheManager <Personnel_Info> .GetInstance().Add(key, Personnel, 8 * 60 * 60 * 1000); var newfleet = Personnel.MotorcadeName;//现车队 ViewBag.MotorcadeName = newfleet; //ViewBag.Date = getTaxiSummary(); ViewBag.Validate = true; ViewBag.Code = personInfoModel.Vguid; }
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)); }
/// <summary> /// 保存部门信息 /// </summary> /// <param name="organizationModel"></param> /// <param name="isEdit"></param> /// <returns></returns> public bool Save(Master_Organization organizationModel, bool isEdit) { Master_Organization organization = new Master_Organization(); if (isEdit)//编辑 { organization = GetOrganizationDetail(organizationModel.Vguid.ToString()); organization.OrganizationName = organizationModel.OrganizationName; //organization.OrganizationCode = organizationModel.OrganizationCode; organization.Description = organizationModel.Description; organization.ChangeUser = Common.CurrentUser.GetCurrentUser().LoginName; organization.ChangeDate = DateTime.Now; } else//新增 { //organization = new Master_Organization(); organization.OrganizationName = organizationModel.OrganizationName; //organization.OrganizationCode = organizationModel.OrganizationCode; organization.ParentVguid = organizationModel.ParentVguid; organization.Vguid = Guid.NewGuid(); organization.Description = organizationModel.Description; organization.CreatedUser = Common.CurrentUser.GetCurrentUser().LoginName; organization.CreatedDate = DateTime.Now; organization.ChangeDate = DateTime.Now; } return(_os.Save(organization, isEdit)); }
public JsonResult SaveCleaningInfo(string companyVGUID, string location, string type, string description, string code) { var model = new ActionResultModel <string>(); var cm = CacheManager <Business_Personnel_Information> .GetInstance()[PubGet.GetUserKey + code]; var cabLicense = ""; var cabOrgName = ""; Master_Organization organizationDetail = new Master_Organization(); organizationDetail = _ol.GetOrganizationDetail(cm.OwnedFleet.ToString()); var manOrgName = organizationDetail.OrganizationName; using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance2()) { var manData = _dbMsSql.SqlQuery <Personnel_Info>(@"select Organization,CabLicense from [DZ_DW].[dbo].[Visionet_DriverInfo_View] where IdCard=@ID and status='1'", new { ID = cm.IDNumber }).FirstOrDefault(); if (manData != null) { cabLicense = manData.CabLicense; cabOrgName = manData.Organization; } } using (SqlSugarClient _db = SugarDao_MsSql.GetInstance()) { Business_SecondaryCleaning cleaning = new Business_SecondaryCleaning(); cleaning.Vguid = Guid.NewGuid(); cleaning.Type = type; cleaning.Description = description; cleaning.Location = location; cleaning.Personnel = cm.UserID; cleaning.OperationDate = DateTime.Now; cleaning.CompanyVguid = companyVGUID; cleaning.CouponType = description; cleaning.CabLicense = cabLicense; cleaning.CabOrgName = cabOrgName; cleaning.ManOrgName = manOrgName; cleaning.CreatedUser = cm.Name; cleaning.CreatedDate = DateTime.Now; cleaning.ChangeDate = DateTime.Now; cleaning.ChangeUser = cm.Name; model.isSuccess = _db.Insert(cleaning, false) != DBNull.Value; model.respnseInfo = model.isSuccess == true?cleaning.CreatedDate.TryToString() : "0"; //同时修改权益表中优惠券状态 UpdateMyRights(_db, description, cm.Vguid); } return(Json(model, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 判断同一部门下是否存在同名称部门 /// </summary> /// <param name="organizationModel"></param> /// <returns></returns> public bool CheckIsExist(Master_Organization organizationModel, string isEdit) { using (SqlSugarClient dbMsSql = SugarDao.SugarDao_MsSql.GetInstance()) { bool result = false; bool isEditor = isEdit != "0"; if (isEditor)//编辑 { result = dbMsSql.Queryable <Master_Organization>().Where(i => i.ParentVguid == organizationModel.ParentVguid && i.Vguid != organizationModel.Vguid).Any(i => i.OrganizationName == organizationModel.OrganizationName); } else//新增 { result = dbMsSql.Queryable <Master_Organization>().Where(i => i.ParentVguid == organizationModel.ParentVguid).Any(i => i.OrganizationName == organizationModel.OrganizationName); } return(result); } }
/// <summary> /// 保存部门信息 /// </summary> /// <param name="organizationModel"></param> /// <param name="isEdit"></param> /// <returns></returns> public JsonResult Save(Master_Organization organizationModel, string isEdit) { var models = new ActionResultModel <String>(); models.isSuccess = false; models.isSuccess = _ol.CheckIsExist(organizationModel, isEdit);//判断同一部门下是否存在同名称部门 if (!models.isSuccess) { models.isSuccess = _ol.Save(organizationModel, isEdit == "0" ? false : true); models.respnseInfo = models.isSuccess == true ? "1" : "0"; } else { models.respnseInfo = "2";//同一部门下存在同名称部门 } return(Json(models, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(string code) { string accessToken = Common.WeChatPush.WeChatTools.GetAccessoken(); U_WeChatUserID userInfo = new U_WeChatUserID(); string userInfoStr = Common.WeChatPush.WeChatTools.GetUserInfoByCode(accessToken, code); userInfo = Common.JsonHelper.JsonToModel <U_WeChatUserID>(userInfoStr);//用户ID //userInfo.UserId = "13671595340";//合伙人 //userInfo.UserId = "18936495119";//司机 Business_Personnel_Information personInfoModel = GetUserInfo(userInfo.UserId);//获取人员表信息 if (personInfoModel.DepartmenManager == 10 || personInfoModel.DepartmenManager == 11) { //合伙人;高级合伙人 getPartnerInfo(personInfoModel); } else if (personInfoModel.DepartmenManager == 12) { //公司经理 getManagerInfo(personInfoModel); } else if (personInfoModel.DepartmenManager == 1) { //司机;从Visionet_DriverInfo_View表中取出最新数据 Personnel_Info Personnel = getPersonnelInfo(personInfoModel); if (Personnel != null) { Master_Organization organizationDetail = new Master_Organization(); organizationDetail = _ol.GetOrganizationDetail(personInfoModel.OwnedFleet.ToString()); Personnel.OldMotorcadeName = personInfoModel.OwnedFleet; //公司 Personnel.OldOrganization = personInfoModel.OwnedCompany; //车队 var key = PubGet.GetUserKey + personInfoModel.Vguid + "K"; var csche = CacheManager <Personnel_Info> .GetInstance().Get(key); if (csche != null) { CacheManager <Personnel_Info> .GetInstance().Remove(key); } CacheManager <Personnel_Info> .GetInstance().Add(key, Personnel, 8 * 60 * 60 * 1000); var data = GetTaxiInfo(personInfoModel.Vguid.ToString()); if (data == "" || data == null) { return(View("/Areas/PartnerInquiryManagement/Views/DriverCheck/Index2.cshtml")); } else { ViewBag.Code = personInfoModel.Vguid; return(View("/Areas/PartnerInquiryManagement/Views/DriverCheck/Index.cshtml")); } } else { return(View("/Areas/PartnerInquiryManagement/Views/DriverCheck/Index2.cshtml")); } } else { //ViewBag.Validate = false; //ViewBag.Date = DateTime.Now.ToString("yyyy-MM-dd"); return(View("/Areas/PartnerInquiryManagement/Views/PartnerHomePage/Index2.cshtml")); } return(View()); }
/// <summary> /// 判断同一部门下是否存在同名称部门 /// </summary> /// <param name="organizationModel"></param> /// <returns></returns> public bool CheckIsExist(Master_Organization organizationModel, string isEdit) { return(_os.CheckIsExist(organizationModel, isEdit)); }