Пример #1
0
        public static string GetFormTitle(FormInfo formInfo)
        {
            var text = "表单管理 (0)";

            if (formInfo == null)
            {
                return(text);
            }

            if (formInfo.TotalCount == 0)
            {
                formInfo.TotalCount = LogDao.GetCount(formInfo.Id);
                if (formInfo.TotalCount > 0)
                {
                    FormDao.Update(formInfo);
                }
            }

            text = $"{(formInfo.ContentId > 0 ? "表单管理" : formInfo.Title)} ({formInfo.TotalCount})";
            if (!formInfo.IsReply)
            {
                return(text);
            }

            if (formInfo.TotalCount - formInfo.RepliedCount > 0)
            {
                text = $@"<span class=""text-danger"">{text}</span>";
            }

            return(text);
        }
        public IHttpActionResult Submit()
        {
            try
            {
                var request = Context.GetCurrentRequest();
                var siteId  = request.GetQueryInt("siteId");
                if (!request.IsAdminLoggin || !request.AdminPermissions.HasSitePermissions(siteId, ApplicationUtils.PluginId))
                {
                    return(Unauthorized());
                }

                var contentIdList = TranslateUtils.StringCollectionToIntList(request.GetPostString("contentIds"));

                foreach (var contentId in contentIdList)
                {
                    DataDao.Delete(siteId, contentId);
                    LogDao.DeleteByDataId(contentId);
                }

                return(Ok(new
                {
                    Value = contentIdList
                }));
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }
Пример #3
0
        public IHttpActionResult Submit()
        {
            try
            {
                var request  = Context.GetCurrentRequest();
                var formInfo = FormManager.GetFormInfoByPost(request);
                if (formInfo == null)
                {
                    return(NotFound());
                }
                if (!request.IsAdminLoggin || !request.AdminPermissions.HasSitePermissions(formInfo.SiteId, FormUtils.PluginId))
                {
                    return(Unauthorized());
                }

                var logId   = request.GetPostInt("logId");
                var logInfo = LogDao.GetLogInfo(logId);
                if (logInfo == null)
                {
                    return(NotFound());
                }

                logInfo.ReplyContent = request.GetPostString("replyContent");

                LogDao.Reply(formInfo, logInfo);

                return(Ok(new{}));
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }
Пример #4
0
        public static void LogSwitchTo(int siteId, int channelId, int contentID, string switchToDepartmentName, string administratorName, int departmentId)
        {
            var logInfo = new LogInfo(0, siteId, channelId, contentID, departmentId, administratorName, ELogTypeUtils.GetValue(ELogType.SwitchTo), Utils.GetIpAddress(), DateTime.Now,
                                      $"{DepartmentManager.GetDepartmentName(departmentId)}({administratorName})转办办件至{switchToDepartmentName} ");

            LogDao.Insert(logInfo);
        }
Пример #5
0
        void IActionFilter.OnActionExecuting(ActionExecutingContext filterContext)
        {
            Usuario usuarioLogado = SessionHelper.UsuarioLogado;

            //Se nenhum usuário está conectado então sai não guarda log
            if (usuarioLogado == null || noLog)
            {
                return;
            }

            string descricao = "";

            descricao += getBetterDescriptionAsPossible(filterContext);

            if (descricao.Length > 1000)
            {
                descricao = descricao.Substring(0, 1000) + "...";
            }
            var nomeUsuario = usuarioLogado.login;

            Log log = new Log
            {
                nomeUsuario = nomeUsuario,
                menu        = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName,
                opcao       = filterContext.ActionDescriptor.ActionName,
                acao        = descricao,
                method      = filterContext.HttpContext.Request.HttpMethod,
                data        = filterContext.HttpContext.Timestamp,
            };

            LogDao.Save(log);
        }
Пример #6
0
        /**
         * 異動角色檔
         **/
        public void updateRole(RoleMgrModel roleMgrModel, CODE_ROLE codeRoleO, SqlConnection conn, SqlTransaction transaction)
        {
            try
            {
                CodeRoleDao codeRoleDao = new CodeRoleDao();

                //新增LOG
                Log log = new Log();
                log.CFUNCTION = "角色管理-修改";
                log.CACTION   = "U";
                log.CCONTENT  = codeRoleDao.roleLogContent(codeRoleO);
                LogDao.Insert(log, Session["UserID"].ToString());

                //異動角色檔
                codeRoleO.DATA_STATUS     = "2";
                codeRoleO.LAST_UPDATE_UID = Session["UserID"].ToString();
                codeRoleO.LAST_UPDATE_DT  = DateTime.Now;
                codeRoleO.FREEZE_UID      = Session["UserID"].ToString();
                codeRoleO.FREEZE_DT       = DateTime.Now;

                int cnt = codeRoleDao.Update(codeRoleO, conn, transaction);
            }
            catch (Exception e)
            {
                logger.Error("[updateRole]其它錯誤:" + e.ToString());
                throw e;
                //新增角色檔失敗
                // return Json(new { success = false, errors = e.ToString() }, JsonRequestBehavior.AllowGet);
            }
        }
Пример #7
0
        public static void LogNew(int siteId, int channelId, int contentID, string realName, string toDepartmentName)
        {
            var logInfo = new LogInfo(0, siteId, channelId, contentID, 0, string.Empty, ELogTypeUtils.GetValue(ELogType.New), Utils.GetIpAddress(), DateTime.Now,
                                      $"前台{realName}提交办件{toDepartmentName}");

            LogDao.Insert(logInfo);
        }
Пример #8
0
        public IHttpActionResult Export()
        {
            try
            {
                var request  = Context.GetCurrentRequest();
                var formInfo = FormManager.GetFormInfoByPost(request);
                if (formInfo == null)
                {
                    return(NotFound());
                }
                if (!request.IsAdminLoggin || !request.AdminPermissions.HasSitePermissions(formInfo.SiteId, FormUtils.PluginId))
                {
                    return(Unauthorized());
                }

                var fieldInfoList = FieldManager.GetFieldInfoList(formInfo.Id);
                var logs          = LogDao.GetLogInfoList(formInfo.Id, false, 0, formInfo.TotalCount);

                var head = new List <string> {
                    "序号"
                };
                foreach (var fieldInfo in fieldInfoList)
                {
                    head.Add(fieldInfo.Title);
                }
                head.Add("添加时间");

                var rows = new List <List <string> >();

                var index = 1;
                foreach (var log in logs)
                {
                    var row = new List <string>
                    {
                        index++.ToString()
                    };
                    foreach (var fieldInfo in fieldInfoList)
                    {
                        row.Add(log.GetString(fieldInfo.Title));
                    }
                    row.Add(log.AddDate.ToString("yyyy-MM-dd HH:mm"));

                    rows.Add(row);
                }

                var relatedPath = "表单数据.csv";

                CsvUtils.Export(Context.PluginApi.GetPluginPath(FormUtils.PluginId, relatedPath), head, rows);
                var downloadUrl = Context.PluginApi.GetPluginUrl(FormUtils.PluginId, relatedPath);

                return(Ok(new
                {
                    Value = downloadUrl
                }));
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }
Пример #9
0
        public static void LogTranslate(int siteId, int channelId, int contentID, string nodeName, string administratorName, int departmentId)
        {
            var logInfo = new LogInfo(0, siteId, channelId, contentID, departmentId, administratorName, ELogTypeUtils.GetValue(ELogType.Translate), Utils.GetIpAddress(), DateTime.Now,
                                      $"{DepartmentManager.GetDepartmentName(departmentId)}({administratorName})从分类“{nodeName}”转移办件至此 ");

            LogDao.Insert(logInfo);
        }
Пример #10
0
        public static void Log(int siteId, int channelId, int contentID, string logType, string administratorName, int departmentId)
        {
            var logInfo = new LogInfo(0, siteId, channelId, contentID, departmentId, administratorName, logType, Utils.GetIpAddress(), DateTime.Now, string.Empty);

            var departmentName = DepartmentManager.GetDepartmentName(departmentId);

            ELogType eLogType = ELogTypeUtils.GetEnumType(logType);

            if (eLogType == ELogType.Accept)
            {
                logInfo.Summary = $"{departmentName}({administratorName})受理办件";
            }
            else if (eLogType == ELogType.Deny)
            {
                logInfo.Summary = $"{departmentName}({administratorName})拒绝受理办件";
            }
            else if (eLogType == ELogType.Reply)
            {
                logInfo.Summary = $"{departmentName}({administratorName})回复办件";
            }
            else if (eLogType == ELogType.Comment)
            {
                logInfo.Summary = $"{departmentName}({administratorName})批示办件";
            }
            else if (eLogType == ELogType.Redo)
            {
                logInfo.Summary = $"{departmentName}({administratorName})要求返工";
            }
            else if (eLogType == ELogType.Check)
            {
                logInfo.Summary = $"{departmentName}({administratorName})审核通过";
            }
            LogDao.Insert(logInfo);
        }
Пример #11
0
        /// <summary>
        /// 處理角色存取項目異動
        /// </summary>
        /// <param name="roleId"></param>
        /// <param name="aplyNO"></param>
        /// <param name="conn"></param>
        /// <param name="transaction"></param>
        private void procRoleItemHis(string roleId, string aplyNo, SqlConnection conn, SqlTransaction transaction)
        {
            CodeRoleItemHisDao       codeRoleItemHisDao = new CodeRoleItemHisDao();
            List <CodeRoleItemModel> cRoleItemList      = codeRoleItemHisDao.qryByAplyNo(aplyNo, "");

            if (cRoleItemList != null)
            {
                if (cRoleItemList.Count > 0)
                {
                    CodeRoleItemDao codeRoleItemDao = new CodeRoleItemDao();

                    foreach (CodeRoleItemModel d in cRoleItemList)
                    {
                        CODE_ROLE_ITEM dItem = new CODE_ROLE_ITEM();
                        Log            log   = new Log();

                        switch (d.execAction)
                        {
                        case "A":
                            dItem.ROLE_ID         = roleId;
                            dItem.ITEM_ID         = d.itemId;
                            dItem.AUTH_TYPE       = d.authType;
                            dItem.LAST_UPDATE_UID = Session["UserID"].ToString();
                            dItem.LAST_UPDATE_DT  = DateTime.Now;


                            //新增資料
                            codeRoleItemDao.Insert(dItem, conn, transaction);


                            //新增LOG
                            log.CFUNCTION = "角色管理(存取項目)-新增";
                            log.CACTION   = "A";
                            log.CCONTENT  = codeRoleItemDao.logContent(dItem);
                            LogDao.Insert(log, Session["UserID"].ToString());

                            break;

                        case "D":
                            dItem = codeRoleItemDao.getRoleItemByKey(roleId, d.itemId, d.authType);

                            //新增LOG
                            log.CFUNCTION = "角色管理(存取項目)-刪除";
                            log.CACTION   = "D";
                            log.CCONTENT  = codeRoleItemDao.logContent(dItem);
                            LogDao.Insert(log, Session["UserID"].ToString());

                            //刪除資料
                            codeRoleItemDao.Delete(dItem, conn, transaction);

                            break;

                        default:
                            break;
                        }
                    }
                }
            }
        }
Пример #12
0
        public IHttpActionResult Submit()
        {
            try
            {
                var request  = Context.GetCurrentRequest();
                var formInfo = FormManager.GetFormInfoByPost(request);
                if (formInfo == null)
                {
                    return(NotFound());
                }
                if (!request.IsAdminLoggin || !request.AdminPermissions.HasSitePermissions(formInfo.SiteId, FormUtils.PluginId))
                {
                    return(Unauthorized());
                }

                var logId = request.GetPostInt("logId");

                var logInfo = logId > 0
                    ? LogDao.GetLogInfo(logId)
                    : new LogInfo
                {
                    FormId  = formInfo.Id,
                    AddDate = DateTime.Now
                };
                var fieldInfoList = FieldManager.GetFieldInfoList(formInfo.Id);
                foreach (var fieldInfo in fieldInfoList)
                {
                    if (request.IsPostExists(fieldInfo.Title))
                    {
                        var value = request.GetPostString(fieldInfo.Title);
                        if (fieldInfo.FieldType == InputType.Date.Value || fieldInfo.FieldType == InputType.DateTime.Value)
                        {
                            var dt = FormUtils.ToDateTime(request.GetPostString(fieldInfo.Title));
                            logInfo.Set(fieldInfo.Title, dt.ToLocalTime());
                        }

                        else
                        {
                            logInfo.Set(fieldInfo.Title, value);
                        }
                    }
                }

                if (logId == 0)
                {
                    LogDao.Insert(formInfo, logInfo);
                }
                else
                {
                    LogDao.Update(logInfo);
                }

                return(Ok(new{}));
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }
Пример #13
0
        /// <summary>
        /// 装饰器
        /// </summary>
        static void Method2()
        {
            LogDao dao = new LogDao(new DaoImpl());

            dao.insert();
            dao.update();
            dao.delete();
        }
Пример #14
0
        /// <summary>
        /// 處理使用者角色異動
        /// </summary>
        /// <param name="roleId"></param>
        /// <param name="aplyNO"></param>
        /// <param name="conn"></param>
        /// <param name="transaction"></param>
        private void procUserRoleHis(CODE_USER cODEUSERO, string aplyNo, SqlConnection conn, SqlTransaction transaction)
        {
            CodeUserRoleHisDao       codeUserRoleHisDao = new CodeUserRoleHisDao();
            List <CodeUserRoleModel> cRoleList          = codeUserRoleHisDao.qryByAplyNo(aplyNo);

            if (cRoleList != null)
            {
                if (cRoleList.Count > 0)
                {
                    CodeUserRoleDao codeUserRoleDao = new CodeUserRoleDao();

                    foreach (CodeUserRoleModel d in cRoleList)
                    {
                        CODE_USER_ROLE dRole = new CODE_USER_ROLE();
                        Log            log   = new Log();

                        switch (d.execAction)
                        {
                        case "A":
                            dRole.USER_ID    = cODEUSERO.USER_ID;
                            dRole.ROLE_ID    = d.roleId;
                            dRole.CREATE_UID = cODEUSERO.LAST_UPDATE_UID;
                            dRole.CREATE_DT  = cODEUSERO.LAST_UPDATE_DT;


                            //新增資料
                            codeUserRoleDao.insert(dRole, conn, transaction);


                            //新增LOG
                            log.CFUNCTION = "使用者管理(角色授權)-新增";
                            log.CACTION   = "A";
                            log.CCONTENT  = codeUserRoleDao.logContent(dRole);
                            LogDao.Insert(log, Session["UserID"].ToString());

                            break;

                        case "D":
                            dRole = codeUserRoleDao.qryByKey(cODEUSERO.USER_ID, d.roleId);

                            //新增LOG

                            log.CFUNCTION = "使用者管理(角色授權)-刪除";
                            log.CACTION   = "D";
                            log.CCONTENT  = codeUserRoleDao.logContent(dRole);
                            LogDao.Insert(log, Session["UserID"].ToString());

                            //刪除資料
                            codeUserRoleDao.delete(dRole, conn, transaction);
                            break;

                        default:
                            break;
                        }
                    }
                }
            }
        }
Пример #15
0
        /// <summary>Faz a autenticação do usuário</sumary>
        public ObjResult Authenticate(string username, string password, string system_flag)
        {
            connection = db.GetCon();
            ObjResult     objResult    = new ObjResult();
            List <string> listMessages = new List <String>();

            try
            {
                connection.Open();

                LogDao     logDao = new LogDao(connection, null);
                UserLogged user   = new UserDao(connection, null).Authenticate(username, password, system_flag);

                // Se a autenticação for bem sucedida, gerar o token JWT
                if (user.id != 0)
                {
                    var tokenHandler    = new JwtSecurityTokenHandler();
                    var configuration   = Builder.GetConfiguration();
                    var key             = Encoding.ASCII.GetBytes(configuration.GetSection("Permissions:SecretKey").Value);
                    var tokenDescriptor = new SecurityTokenDescriptor
                    {
                        Subject = new ClaimsIdentity(new Claim[]
                        {
                            new Claim("use_id", user.id.ToString())
                        }),
                        Expires            = DateTime.UtcNow.AddDays(1),
                        SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
                    };
                    var token = tokenHandler.CreateToken(tokenDescriptor);
                    user.token = tokenHandler.WriteToken(token);

                    logDao.Post(new Log(user.id, "User", "Login", username, ""));
                    objResult.resultStatus = "success";
                    objResult.data         = user;
                }
                else
                {
                    logDao.Post(new Log(0, "User", "ErroLogin", username, username + " : " + password));

                    listMessages.Add("Usuário ou senha inválidos.");
                    objResult.resultStatus   = "error";
                    objResult.resultMessages = listMessages;
                }
            }
            catch (Exception e)
            {
                listMessages.Add(e.Message);
                objResult.resultStatus   = "error";
                objResult.resultMessages = listMessages;
            }
            finally
            {
                connection.Close();
            }

            return(objResult);
        }
Пример #16
0
        /// <summary>
        /// 處理角色功能異動
        /// </summary>
        /// <param name="roleId"></param>
        /// <param name="aplyNO"></param>
        /// <param name="conn"></param>
        /// <param name="transaction"></param>
        private void procRoleFuncHis(string roleId, string aplyNo, SqlConnection conn, SqlTransaction transaction)
        {
            CodeRoleFuncHisDao      codeRoleFuncHisDao = new CodeRoleFuncHisDao();
            List <RoleFuncHisModel> cRoleFuncList      = codeRoleFuncHisDao.qryByAplyNo(aplyNo);

            if (cRoleFuncList != null)
            {
                if (cRoleFuncList.Count > 0)
                {
                    CodeRoleFunctionDao roleFuncDao = new CodeRoleFunctionDao();

                    foreach (RoleFuncHisModel d in cRoleFuncList)
                    {
                        CODE_ROLE_FUNC dFunc = new CODE_ROLE_FUNC();
                        Log            log   = new Log();
                        switch (d.execAction)
                        {
                        case "A":
                            dFunc.ROLE_ID         = roleId;
                            dFunc.SYS_CD          = "TREASURY";
                            dFunc.FUNC_ID         = d.cFunctionID;
                            dFunc.LAST_UPDATE_UID = Session["UserID"].ToString();
                            dFunc.LAST_UPDATE_DT  = DateTime.Now;


                            //新增資料
                            roleFuncDao.Insert(dFunc, conn, transaction);


                            //新增LOG
                            log.CFUNCTION = "角色管理(功能授權)-新增";
                            log.CACTION   = "A";
                            log.CCONTENT  = roleFuncDao.logContent(dFunc);
                            LogDao.Insert(log, Session["UserID"].ToString());

                            break;

                        case "D":
                            dFunc = roleFuncDao.getFuncRoleByKey(roleId, d.cFunctionID);

                            //新增LOG
                            log.CFUNCTION = "角色管理(功能授權)-刪除";
                            log.CACTION   = "D";
                            log.CCONTENT  = roleFuncDao.logContent(dFunc);
                            LogDao.Insert(log, Session["UserID"].ToString());

                            //刪除資料
                            roleFuncDao.Delete(dFunc, conn, transaction);
                            break;

                        default:
                            break;
                        }
                    }
                }
            }
        }
        public ObjResult Save(UserPermission obj, int user_id, string action)
        {
            connection = db.GetCon();
            connection.Open();
            int id;

            ObjResult objResult                  = new ObjResult();
            UserPermissionBusiness bus           = new UserPermissionBusiness(connection);
            List <string>          messages_list = new List <string>();

            //validações
            try
            {
                messages_list = bus.Validate(obj, user_id, action);
                if (messages_list.Count > 0)
                {
                    objResult.resultStatus   = "error";
                    objResult.resultMessages = messages_list;
                    connection.Close();
                    return(objResult);
                }
            }
            finally
            {
                connection.Close();
            }

            NpgsqlTransaction transaction = null;

            try
            {
                connection.Open();
                transaction = connection.BeginTransaction();
                UserPermissionDao dao = new UserPermissionDao(connection, transaction);
                id = dao.Post(obj);

                LogDao logDao = new LogDao(connection, transaction);
                logDao.Post(new Log(user_id, "UserPermission", action, id.ToString(), JsonConvert.SerializeObject(obj)));

                objResult.resultStatus = "success";
                objResult.data         = id;
                transaction.Commit();
            }
            catch (Exception ex)
            {
                if (transaction != null)
                {
                    transaction.Rollback();
                }
                throw new Exception(ex.ToString());
            }
            finally
            {
                connection.Close();
            }
            return(objResult);
        }
Пример #18
0
        public static LogDao ToApp(this Log log)
        {
            LogDao logDao = new LogDao();

            logDao.LogID     = log.LogID;
            logDao.Descricao = log.Descricao;
            logDao.DataHora  = log.DataHora;

            return(logDao);
        }
Пример #19
0
        public static Log ToBd(this LogDao logDao)
        {
            Log log = new Log();

            log.LogID     = logDao.LogID;
            log.Descricao = logDao.Descricao;
            log.DataHora  = logDao.DataHora;

            return(log);
        }
Пример #20
0
 public void Incluir(LogDao logDao)
 {
     try
     {
         logRepository.Incluir(logDao.ToBd());
     }
     catch (Exception ex)
     {
     }
 }
Пример #21
0
        public IHttpActionResult Delete()
        {
            try
            {
                var request  = Context.GetCurrentRequest();
                var formInfo = FormManager.GetFormInfoByPost(request);
                if (formInfo == null)
                {
                    return(NotFound());
                }
                if (!request.IsAdminLoggin || !request.AdminPermissions.HasSitePermissions(formInfo.SiteId, FormUtils.PluginId))
                {
                    return(Unauthorized());
                }

                var logId   = request.GetPostInt("logId");
                var logInfo = LogDao.GetLogInfo(logId);
                if (logInfo == null)
                {
                    return(NotFound());
                }

                LogDao.Delete(formInfo, logInfo);

                var pages = Convert.ToInt32(Math.Ceiling((double)formInfo.TotalCount / FormUtils.PageSize));
                if (pages == 0)
                {
                    pages = 1;
                }
                var page = request.GetQueryInt("page", 1);
                if (page > pages)
                {
                    page = pages;
                }
                var logInfoList = LogDao.GetLogInfoList(formInfo, false, page);

                var logs = new List <Dictionary <string, object> >();
                foreach (var info in logInfoList)
                {
                    logs.Add(info.ToDictionary());
                }

                return(Ok(new
                {
                    Value = logs,
                    Count = formInfo.TotalCount,
                    Pages = pages,
                    Page = page
                }));
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }
Пример #22
0
        public IHttpActionResult Get()
        {
            try
            {
                var request  = Context.GetCurrentRequest();
                var formInfo = FormManager.GetFormInfoByGet(request);
                if (formInfo == null)
                {
                    return(NotFound());
                }
                if (!request.IsAdminLoggin || !request.AdminPermissions.HasSitePermissions(formInfo.SiteId, FormUtils.PluginId))
                {
                    return(Unauthorized());
                }

                var fieldInfoList      = FieldManager.GetFieldInfoList(formInfo.Id);
                var listAttributeNames = FormUtils.StringCollectionToStringList(formInfo.Additional.ListAttributeNames);
                var allAttributeNames  = FormManager.GetAllAttributeNames(formInfo, fieldInfoList);

                var pages = Convert.ToInt32(Math.Ceiling((double)formInfo.TotalCount / FormUtils.PageSize));
                if (pages == 0)
                {
                    pages = 1;
                }
                var page = request.GetQueryInt("page", 1);
                if (page > pages)
                {
                    page = pages;
                }
                var logInfoList = LogDao.GetLogInfoList(formInfo, false, page);

                var logs = new List <Dictionary <string, object> >();
                foreach (var logInfo in logInfoList)
                {
                    logs.Add(logInfo.ToDictionary());
                }

                return(Ok(new
                {
                    Value = logs,
                    Count = formInfo.TotalCount,
                    Pages = pages,
                    Page = page,
                    FieldInfoList = fieldInfoList,
                    AllAttributeNames = allAttributeNames,
                    ListAttributeNames = listAttributeNames,
                    formInfo.IsReply
                }));
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }
Пример #23
0
        /// <summary>
        /// 异常日志
        /// </summary>
        /// <param name="entity"></param>
        public static void WriteExceptionLog(string method, string message)
        {
            LogDao             logDao = new LogDao();
            ExceptionLogEntity entity = new ExceptionLogEntity()
            {
                ExceptionMessage = message,
                ExceptionModule  = method
            };

            logDao.InsertExceptionLog(entity);
        }
Пример #24
0
        public JsonResult execInsert(String cParentFunctionID, String cFunctionName, int iSortBy, String cFlag, String vFunctionUrl, String vFunctionMemo)
        {
            CodeFuncDao codeFuncDao = new CodeFuncDao();

            if (codeFuncDao.chkFuncName("", cFunctionName) != null)
            {
                var jsonData = new { success = false, err = "功能名稱:”功能名稱”已存在,請重新輸入!" };
                return(Json(jsonData, JsonRequestBehavior.AllowGet));
            }

            CODE_FUNC func = new CODE_FUNC();

            func.SYS_CD         = "TREASURY";
            func.PARENT_FUNC_ID = cParentFunctionID;
            func.FUNC_NAME      = cFunctionName;
            func.FUNC_LEVEL     = 2;
            func.FUNC_MEMO      = vFunctionMemo;
            func.FUNC_URL       = vFunctionUrl;
            func.FUNC_ORDER     = iSortBy;
            func.IS_DISABLED    = cFlag;
            func.CREATE_UID     = Session["UserID"].ToString();

            string strConn = DbUtil.GetDBTreasuryConnStr();

            using (SqlConnection conn = new SqlConnection(strConn))
            {
                conn.Open();

                SqlTransaction transaction = conn.BeginTransaction("Transaction");

                try
                {
                    func = codeFuncDao.insert(func, conn, transaction);

                    Log log = new Log();
                    log.CFUNCTION = "功能維護作業-新增";
                    log.CACTION   = "A";
                    log.CCONTENT  = codeFuncDao.funcLogContent(func);
                    LogDao.Insert(log, Session["UserID"].ToString());

                    transaction.Commit();

                    var jsonData = new { success = true, id = func.FUNC_ID.Trim() };
                    return(Json(jsonData, JsonRequestBehavior.AllowGet));
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    logger.Error("[execInsert]其它錯誤:" + e.ToString());
                    var jsonData = new { success = false, err = "其它錯誤,請洽系統管理員!!" };
                    return(Json(jsonData, JsonRequestBehavior.AllowGet));
                }
            }
        }
Пример #25
0
 public LogController LogInsert(LogController Log)
 {
     try
     {
         LogDao DAO = new LogDao();
         return(DAO.LogInsert(Log));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Пример #26
0
 // GET: Admin/Log
 public ActionResult Index()
 {
     if (((User)Session[Constants.USER_INFO]).GroupID == Constants.GROUP_ADMIM)
     {
         SetActiveSlideBar(Constants.SLIDEBAR_AD_SYSTEM);
         var LogModel = new LogDao().ListAllLog();
         new LogDao().SetLog("Admin_Log_Index", null, ((User)Session[Constants.USER_INFO]).ID);
         return(View(LogModel));
     }
     SetAlert("Tài khoản của bạn không có quyền", Constants.ALERTTYPE_ERROR);
     new LogDao().SetLog("Admin_Log_Index", "Tài khoản của bạn không có quyền", ((User)Session[Constants.USER_INFO]).ID);
     return(RedirectToAction("Index", "Home"));
 }
Пример #27
0
 public static void NewApplication(DataInfo dataInfo)
 {
     LogDao.Insert(new LogInfo
     {
         Id      = 0,
         SiteId  = dataInfo.SiteId,
         DataId  = dataInfo.Id,
         UserId  = 0,
         AddDate = DateTime.Now,
         Summary =
             $"{(dataInfo.IsOrganization ? dataInfo.OrgName : dataInfo.CivicName)}({(dataInfo.IsOrganization ? "公民" : "法人/其他组织")})提交申请"
     });
 }
Пример #28
0
        public static void WriteBusinessLog(string method, string messageOne, string messageTwo)
        {
            LogDao logDao = new LogDao();

            BusinessLogEntity entity = new BusinessLogEntity()
            {
                LogType    = method,
                MessageOne = messageOne,
                MessageTwo = messageTwo
            };

            logDao.InsertBusinessLog(entity);
        }
Пример #29
0
        public override void Startup(IService service)
        {
            FormDao      = new FormDao(ConnectionString, DataApi);
            LogDao       = new LogDao(ConnectionString, DataApi);
            FieldDao     = new FieldDao(ConnectionString, DataApi);
            FieldItemDao = new FieldItemDao(ConnectionString, DataApi);

            service
            .AddSiteMenu(siteId =>
            {
                var formInfoList = FormDao.GetFormInfoListNotInChannel(siteId);
                var menus        = formInfoList.Select(formInfo => new Menu
                {
                    Text = $"{formInfo.Title}",
                    Href = $"{nameof(PageLogs)}.aspx?formId={formInfo.Id}"
                }).ToList();

                menus.Add(new Menu
                {
                    Text = "表单管理",
                    Href = $"{nameof(PageManagement)}.aspx"
                });

                return(new Menu
                {
                    Text = "表单",
                    IconClass = "ion-android-list",
                    Menus = menus
                });
            })
            .AddContentLink(new HyperLink
            {
                Text        = "表单管理",
                NavigateUrl = $"{nameof(PageLogs)}.aspx"
            })
            .AddDatabaseTable(FormDao.TableName, FormDao.Columns)
            .AddDatabaseTable(LogDao.TableName, LogDao.Columns)
            .AddDatabaseTable(FieldDao.TableName, FieldDao.Columns)
            .AddDatabaseTable(FieldItemDao.TableName, FieldItemDao.Columns)
            .AddStlElementParser(StlForm.ElementName, StlForm.Parse)
            ;

            service.ContentTranslateCompleted += Service_ContentTranslateCompleted;
            service.ContentDeleteCompleted    += Service_ContentDeleteCompleted;

            service.ApiPost += ServiceOnApiPost;
            service.ApiGet  += Service_ApiGet;

            Instance = this;
        }
Пример #30
0
        /// <summary>
        /// 新增申請覆核
        /// </summary>
        /// <param name="data"></param>
        /// <param name="currentUserId">目前使用者ID</param>
        /// <returns></returns>
        public MSGReturnModel <List <SpecifiedTimeTreasurySearchDetailViewModel> > InsertApplyData(SpecifiedTimeTreasuryApplyViewModel data, string currentUserId, SpecifiedTimeTreasurySearchViewModel searchData)
        {
            var result = new MSGReturnModel <List <SpecifiedTimeTreasurySearchDetailViewModel> >();

            result.RETURN_FLAG = false;
            result.DESCRIPTION = Ref.MessageType.Apply_Audit_Fail.GetDescription();
            string logStr = string.Empty; //log

            using (TreasuryDBEntities db = new TreasuryDBEntities())
            {
                var _data = db.TREA_OPEN_REC
                            .Add(MappingTableForInsert(data, currentUserId));

                logStr += _data.modelToString(logStr);

                var validateMessage = db.GetValidationErrors().getValidateString();
                if (validateMessage.Any())
                {
                    result.DESCRIPTION = validateMessage;
                }
                else
                {
                    try
                    {
                        db.SaveChanges();
                        #region LOG
                        //新增LOG
                        Log log = new Log();
                        log.CFUNCTION = "申請覆核";
                        log.CACTION   = "C";
                        log.CCONTENT  = logStr;
                        LogDao.Insert(log, currentUserId);
                        #endregion
                        result.RETURN_FLAG = true;
                        result.DESCRIPTION = Ref.MessageType.Apply_Audit_Success.GetDescription();;
                    }
                    catch (DbUpdateException ex)
                    {
                        result.DESCRIPTION = ex.exceptionMessage();
                    }
                }

                if (result.RETURN_FLAG)
                {
                    result.Datas = GetSearchDetail(searchData);
                }
            }
            return(result);
        }