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);
}
