public int Insert(P_Admin p_Admin) { using (var conn = ConnectionFactory.GetDBConn(ConnectionFactory.DBConnNames.GisPlateform)) { return(conn.Execute(DapperExtentions.MakeInsertSql(p_Admin), p_Admin)); } }
/// <summary> /// 修改用户 /// </summary> /// <param name="iAdminID"></param> /// <param name="admin"></param> public MessageEntity Put(int iAdminID, [FromBody] P_Admin admin) { if (admin == null) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } var checkAdmin = base.CommonDAL.IsUserExist(admin.cAdminName, admin.CJobNumber, iAdminID, out string errorMsg); if (checkAdmin != null && !string.IsNullOrEmpty(checkAdmin.cAdminName)) { if (string.IsNullOrEmpty(errorMsg)) { if (checkAdmin.cAdminName == admin.cAdminName) { return(MessageEntityTool.GetMessage(ErrorType.NotUnique, "", "用户名称不能重复")); } if (checkAdmin.CJobNumber == admin.CJobNumber) { return(MessageEntityTool.GetMessage(ErrorType.NotUnique, "", "用户工号不能重复")); } } else { return(MessageEntityTool.GetMessage(ErrorType.SqlError, errorMsg)); } } admin.iAdminID = iAdminID; return(base.CommonDAL.UpdateUser(admin)); }
/// <summary> /// 事件工单查询(个人处理-待办处理) /// </summary> /// <param name="startTime">开始时间</param> /// <param name="endTime">结束时间</param> /// <param name="EventFromId">事件来源</param> /// <param name="eventType">事件类型</param> /// <param name="DeptId">上报部门id</param> /// <param name="EventContenct">查询条件(事件来源:类型、上报人、编号)</param> /// <param name="ExecPersonId">执行人ID(个人处理--待办处理传入字段)</param> /// <param name="EventID">事件ID</param> /// <param name="OperId">事件处理状态步骤ID 0:无效 1: 待处理 2:待接受 3:待处置 4到场 5:处置中 5:延期确认 6:待审核 7:审核完成 11:待处理 12:回复完成 null:待分派</param> /// <param name="IsValid">是否有效 1有效 0无效 2 退回 3 回复 4:退单 5延期 6 延期确认</param> /// <param name="sort">排序字段默认EventID</param> /// <param name="ordering">desc/asc</param> /// <param name="num">默认20</param> /// <param name="page">默认1</param> /// <returns></returns> public MessageEntity Get(DateTime?startTime = null, DateTime?endTime = null, int?EventFromId = null, int?eventType = null, int?EventID = null, string OperId = "", int?IsValid = null, int?DeptId = null, string EventContenct = "", string ExecPersonId = null, string sort = "EventID", string ordering = "desc", int num = 20, int page = 1) { string iDeptIDs = "0"; //获取登陆人员部门权限 if (ExecPersonId != "" && ExecPersonId != null) { P_Admin _Admin = base.CommonDAL.GetUserInfo(ExecPersonId, out string errorMsg); if (_Admin != null && _Admin.iDeptIDs != "" && _Admin.iDeptIDs != null) { iDeptIDs = _Admin.iDeptIDs; } } var messageEntity = _eventManage.GetEventWorkorderListForMaintain(startTime, endTime, EventFromId, eventType, EventID, OperId, IsValid, DeptId, EventContenct, ExecPersonId, iDeptIDs, sort, ordering, num, page); return(messageEntity); }
/// <summary> /// 保存用户加密cookie /// </summary> /// <param name = "admin" ></param> private string CreateAuthention(P_Admin admin) { #region 加密票据 //FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, JsonConvert.SerializeObject(admin), DateTime.Now, DateTime.Now.AddDays(1), true, ""); ////加密票据 //string authTicket = FormsAuthentication.Encrypt(ticket); ////存储为cookie //Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, authTicket) //{ // Expires = ticket.Expiration, //}); var payload = new Dictionary <string, object> { { "UserId", admin.iAdminID }, { "UserName", admin.cAdminName }, { "ExpireTime", DateTime.Now.AddDays(1) }, { "IP", "" } }; return(JwtHelper.SetJwtEncode(payload)); #endregion }
public MessageEntity UpdateUser(P_Admin admin) { base.UpdateEntity(admin, ConnectionFactory.DBConnNames.GisPlateform, out MessageEntity messageEntity); return(messageEntity); }