示例#1
0
        /// <summary>
        /// 批量提交工时表
        /// </summary>
        void SubmitManySheet(HttpContext context)
        {
            bool result = false;
            int  temp   = 0;

            if (!string.IsNullOrEmpty(context.Request.QueryString["Array"]))
            {
                var arr = new Tools.Serialize().DeserializeJson <string[]>(context.Request.QueryString["Array"]);
                if (arr != null && arr.Length > 0)
                {
                    var bll = new BLL.WorkEntryBLL();
                    foreach (var thisArr in arr)
                    {
                        var thisSub = thisArr.Split('_');
                        if (thisSub.Length == 2)
                        {
                            if (!bll.SubmitWorkEntry(DateTime.Parse(thisSub[1]), long.Parse(thisSub[0]), LoginUserId))
                            {
                                temp++;
                            }
                        }
                    }
                }
            }
            if (temp == 0)
            {
                result = true;
            }
            WriteResponseJson(result);
        }
示例#2
0
        /// <summary>
        /// 获取所有可用的工作流
        /// </summary>
        /// <returns></returns>
        public List <WorkflowRuleDto> GetAllWorkflow()
        {
            var srlz         = new Tools.Serialize();
            var workflowList = dal.FindListBySql <WorkflowRuleDto>("select * from sys_workflow where delete_time=0 and is_active=1");

            foreach (var wf in workflowList)
            {
                if (!string.IsNullOrEmpty(wf.event_json))
                {
                    wf.eventJson = srlz.DeserializeJson <List <dynamic> >(wf.event_json);
                }
                if (!string.IsNullOrEmpty(wf.condition_json))
                {
                    wf.conditionJson = srlz.DeserializeJson <List <dynamic> >(wf.condition_json);
                }
                if (!string.IsNullOrEmpty(wf.update_json))
                {
                    wf.updateJson = srlz.DeserializeJson <List <dynamic> >(wf.update_json);
                }
                if (!string.IsNullOrEmpty(wf.email_send_from))
                {
                    wf.emailJson = srlz.DeserializeJson <List <dynamic> >(wf.email_send_from);
                }
            }

            return(workflowList);
        }
示例#3
0
        /// <summary>
        /// 根据生效时间计算生效时间开始的首周期所占整周期的天数百分比(保留4位小数)
        /// </summary>
        /// <param name="context"></param>
        private void CalcServiceAdjustPercent(HttpContext context)
        {
            long     contractId = long.Parse(context.Request.QueryString["contractId"]);
            long     serviceId  = long.Parse(context.Request.QueryString["serviceId"]);
            DateTime date       = DateTime.Parse(context.Request.QueryString["date"]);
            var      result     = new Tools.Serialize().SerializeJson(new ContractServiceBLL().CalcServiceAdjustDatePercent(contractId, serviceId, date));

            context.Response.Write(result);
        }
示例#4
0
        /// <summary>
        /// 工单创建修改事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void TicketAddEditEvent(object sender, sdk_task_dal.InsertEventArgs e)
        {
            var ticket = sender as sdk_task;

            if (ticket.type_id != (int)DicEnum.TASK_TYPE.SERVICE_DESK_TICKET &&
                ticket.type_id != (int)DicEnum.TASK_TYPE.RECURRING_TICKET_MASTER)
            {
                return;
            }

            sys_workflow_log_dal logDal = new sys_workflow_log_dal();

            foreach (var wf in workflowList)
            {
                if (wf.workflow_object_id == (int)DicEnum.WORKFLOW_OBJECT.TICKET)
                {
                    foreach (var evt in wf.eventJson)
                    {
                        if (((string)evt["event"]).Equals(e.EventType))                                   // 新增事件
                        {
                            if (((string)evt["value"]).Equals("1") || ((string)evt["value"]).Equals("2")) // 任何人或员工新增
                            {
                                string sql = GetWorkflowSql(wf.id, wf.workflow_object_id, ticket.id);
                                if (string.IsNullOrEmpty(sql))
                                {
                                    continue;
                                }

                                var workflowSql = new Tools.Serialize().DeserializeJson <List <dynamic> >(sql);
                                foreach (var wfsql in workflowSql)
                                {
                                    if (string.IsNullOrEmpty((string)wfsql["update"]))
                                    {
                                        continue;
                                    }

                                    if (dal.ExecuteSQL((string)wfsql["update"]) > 0)
                                    {
                                        logDal.AddWorkflowLog(wf.id, ticket.id, (string)wfsql["update"]);
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
示例#5
0
        /// <summary>
        /// 新增编辑快速查询记录
        /// </summary>
        public void SearchHistoryManage(HttpContext context)
        {
            var result = false;
            var id     = context.Request.QueryString["id"];

            if (!string.IsNullOrEmpty(id))
            {
                var search = new DAL.sys_recent_search_dal().FindById(long.Parse(id));
                if (search != null)
                {
                    result = new DispatchBLL().ManageSearch(search, LoginUserId);
                }
            }
            else
            {
                var searchText     = context.Request.QueryString["searchText"];
                var searchType     = context.Request.QueryString["searchType"];
                var searchTypeName = context.Request.QueryString["searchTypeName"];
                var url            = context.Request.QueryString["url"];
                var searchDto      = new DTO.QuickSearchDto()
                {
                    Condition  = searchText,
                    Name       = searchTypeName,
                    SearchType = searchType
                };
                var conditions = new Tools.Serialize().SerializeJson(searchDto);
                var search     = new DAL.sys_recent_search_dal().GetByCon(conditions, url);
                if (search != null)
                {
                    result = new DispatchBLL().ManageSearch(search, LoginUserId);
                }
                else
                {
                    search = new Core.sys_recent_search()
                    {
                        conditions = conditions,
                        url        = url,
                        title      = "",
                    };
                    result = new DispatchBLL().ManageSearch(search, LoginUserId);
                }
            }
            context.Response.Write(new Tools.Serialize().SerializeJson(result));
        }
示例#6
0
        /// <summary>
        /// 根据商机模板填充商机内容
        /// </summary>
        /// <param name="context"></param>
        /// <param name="formTemp_id"></param>
        public void GetFormTemplate(HttpContext context, long formTemp_id)
        {
            var formTemplate = new FormTemplateBLL().GetOpportunityTmpl((int)formTemp_id);

            if (formTemplate != null)
            {
                var json = new Tools.Serialize().SerializeJson(formTemplate);
                if (formTemplate.account_id != null)
                {
                    var companyName = new CompanyBLL().GetCompany((long)formTemplate.account_id);
                    if (companyName != null)
                    {
                        json  = json.Substring(0, json.Length - 1);
                        json += ",\"ParentComoanyName\":\"" + companyName.name + "\"}";
                    }
                }
                context.Response.Write(json);
            }
        }
示例#7
0
        /// <summary>
        /// 获取小窗口及小窗口的小部件
        /// </summary>
        private void GetWidget()
        {
            var id     = long.Parse(request.QueryString["id"]);
            var info   = bll.GetWidgetById(id);
            var guages = bll.GetGuageChildren(id);

            var srlz = new Tools.Serialize();

            if (info.type_id != (int)DicEnum.WIDGET_TYPE.GUAGE && info.type_id != (int)DicEnum.WIDGET_TYPE.HTML)
            {
                object filter = null;
                if (!string.IsNullOrEmpty(info.filter_json))
                {
                    filter = srlz.DeserializeJson <List <dynamic> >(info.filter_json);
                }
                info.filter_json = null;
                object[] result = new object[] { info, guages, filter };
                WriteResponseJson(result);
            }
            else if (info.type_id == (int)DicEnum.WIDGET_TYPE.GUAGE)
            {
                List <object> filters = new List <object>();
                foreach (var guage in guages)
                {
                    if (!string.IsNullOrEmpty(guage.filter_json))
                    {
                        filters.Add(srlz.DeserializeJson <List <dynamic> >(guage.filter_json));
                    }
                    else
                    {
                        filters.Add(null);
                    }
                    guage.filter_json = null;
                }
                object[] result = new object[] { info, guages, filters };
                WriteResponseJson(result);
            }
        }
示例#8
0
        /// <summary>
        /// 获取一条工作流规则信息,并反序列化json
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public WorkflowRuleDto GetWorkflowJson(long id)
        {
            var srlz = new Tools.Serialize();
            var wf   = dal.FindSignleBySql <WorkflowRuleDto>($"select * from sys_workflow where id={id} and delete_time=0 ");

            if (!string.IsNullOrEmpty(wf.event_json))
            {
                wf.eventJson = srlz.DeserializeJson <List <dynamic> >(wf.event_json);
            }
            if (!string.IsNullOrEmpty(wf.condition_json))
            {
                wf.conditionJson = srlz.DeserializeJson <List <dynamic> >(wf.condition_json);
            }
            if (!string.IsNullOrEmpty(wf.update_json))
            {
                wf.updateJson = srlz.DeserializeJson <List <dynamic> >(wf.update_json);
            }
            if (!string.IsNullOrEmpty(wf.email_send_from))
            {
                wf.emailJson = srlz.DeserializeJson <List <dynamic> >(wf.email_send_from);
            }

            return(wf);
        }