public static HtmlBuilder Tr(
            this HtmlBuilder hb,
            Context context,
            SiteSettings ss,
            DataRow dataRow,
            IEnumerable <Column> columns,
            bool checkAll,
            bool editRow,
            bool checkRow,
            string idColumn,
            FormDataSet formDataSet = null)
        {
            var dataId      = dataRow.Long(idColumn).ToString();
            var dataVersion = dataRow.Int("Ver");
            var isHistory   = dataRow.Bool("IsHistory");
            var EditColumns = !isHistory
                ? columns.ToDictionary(
                column => column.ColumnName,
                column => EditColumn(
                    context: context,
                    column: column))
                : new Dictionary <string, bool>();

            return(hb.Tr(
                       attributes: new HtmlAttributes()
                       .Class("grid-row")
                       .DataId(dataId)
                       .DataVer(dataVersion)
                       .DataLatest(1, _using: !isHistory)
                       .Add(name: "data-history", value: "1", _using: isHistory),
                       action: () =>
            {
                if (editRow)
                {
                    hb.Td(action: () => hb
                          .Button(
                              title: Displays.Reload(context: context),
                              controlCss: "button-icon",
                              onClick: $"$p.getData($(this)).Id={dataId};$p.send($(this));",
                              icon: "ui-icon-refresh",
                              action: "ReloadRow",
                              method: "post",
                              _using: !isHistory)
                          .Button(
                              title: Displays.Copy(context: context),
                              controlCss: "button-icon",
                              onClick: $"$p.getData($(this)).OriginalId={dataId};$p.send($(this));",
                              icon: "ui-icon-copy",
                              action: "CopyRow",
                              method: "post",
                              _using: !isHistory && context.CanCreate(ss: ss))
                          .Hidden(
                              controlId: $"{ss.ReferenceType}_Timestamp_{ss.SiteId}_{dataId}",
                              css: "timestamp",
                              value: dataRow
                              .Field <DateTime>("UpdatedTime")
                              .ToString("yyyy/M/d H:m:s.fff")));
                }
                else if (checkRow)
                {
                    hb.Td(action: () => hb
                          .CheckBox(
                              controlCss: "grid-check",
                              _checked: checkAll,
                              dataId: dataId,
                              _using: !isHistory));
                }
                var depts = new Dictionary <string, DeptModel>();
                var groups = new Dictionary <string, GroupModel>();
                var registrations = new Dictionary <string, RegistrationModel>();
                var users = new Dictionary <string, UserModel>();
                var sites = new Dictionary <string, SiteModel>();
                var issues = new Dictionary <string, IssueModel>();
                var results = new Dictionary <string, ResultModel>();
                columns.ForEach(column =>
                {
                    var key = column.TableName();
                    switch (column.SiteSettings?.ReferenceType)
                    {
                    case "Depts":
                        var deptModel = depts.Get(key);
                        if (deptModel == null)
                        {
                            deptModel = new DeptModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                tableAlias: column.TableAlias);
                            depts.Add(key, deptModel);
                            ss.SetColumnAccessControls(
                                context: context,
                                mine: deptModel.Mine(context: context));
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            deptModel: deptModel);
                        break;

                    case "Groups":
                        var groupModel = groups.Get(key);
                        if (groupModel == null)
                        {
                            groupModel = new GroupModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                tableAlias: column.TableAlias);
                            groups.Add(key, groupModel);
                            ss.SetColumnAccessControls(
                                context: context,
                                mine: groupModel.Mine(context: context));
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            groupModel: groupModel);
                        break;

                    case "Registrations":
                        var registrationModel = registrations.Get(key);
                        if (registrationModel == null)
                        {
                            registrationModel = new RegistrationModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                tableAlias: column.TableAlias);
                            registrations.Add(key, registrationModel);
                            ss.SetColumnAccessControls(
                                context: context,
                                mine: registrationModel.Mine(context: context));
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            registrationModel: registrationModel);
                        break;

                    case "Users":
                        var userModel = users.Get(key);
                        if (userModel == null)
                        {
                            userModel = new UserModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                tableAlias: column.TableAlias);
                            users.Add(key, userModel);
                            ss.SetColumnAccessControls(
                                context: context,
                                mine: userModel.Mine(context: context));
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            userModel: userModel);
                        break;

                    case "Sites":
                        var siteModel = sites.Get(key);
                        if (siteModel == null)
                        {
                            siteModel = new SiteModel(
                                context: context,
                                dataRow: dataRow,
                                formData: editRow
                                            ? formDataSet?.FirstOrDefault(o =>
                                                                          o.Id == dataRow.Long("SiteId"))?.Data
                                            : null,
                                tableAlias: column.TableAlias);
                            sites.Add(key, siteModel);
                            ss.SetColumnAccessControls(
                                context: context,
                                mine: siteModel.Mine(context: context));
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            siteModel: siteModel);
                        break;

                    case "Issues":
                        var issueModel = issues.Get(key);
                        if (issueModel == null)
                        {
                            issueModel = new IssueModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                formData: editRow
                                            ? formDataSet?.FirstOrDefault(o =>
                                                                          o.Id == dataRow.Long("IssueId"))?.Data
                                            : null,
                                tableAlias: column.TableAlias);
                            issues.Add(key, issueModel);
                            ss.SetColumnAccessControls(
                                context: context,
                                mine: issueModel.Mine(context: context));
                        }
                        if (EditColumns.Get(column.ColumnName))
                        {
                            hb.Td(action: () => hb.Field(
                                      context: context,
                                      column: column,
                                      issueModel: issueModel,
                                      ss: column.SiteSettings,
                                      controlOnly: true,
                                      idSuffix: issueModel.IdSuffix()));
                        }
                        else
                        {
                            hb.TdValue(
                                context: context,
                                ss: column.SiteSettings,
                                column: column,
                                issueModel: issueModel);
                        }
                        break;

                    case "Results":
                        var resultModel = results.Get(key);
                        if (resultModel == null)
                        {
                            resultModel = new ResultModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                formData: editRow
                                            ? formDataSet?.FirstOrDefault(o =>
                                                                          o.Id == dataRow.Long("ResultId"))?.Data
                                            : null,
                                tableAlias: column.TableAlias);
                            results.Add(key, resultModel);
                            ss.SetColumnAccessControls(
                                context: context,
                                mine: resultModel.Mine(context: context));
                        }
                        if (EditColumns.Get(column.ColumnName))
                        {
                            hb.Td(action: () => hb.Field(
                                      context: context,
                                      column: column,
                                      resultModel: resultModel,
                                      ss: column.SiteSettings,
                                      controlOnly: true,
                                      idSuffix: resultModel.IdSuffix()));
                        }
                        else
                        {
                            hb.TdValue(
                                context: context,
                                ss: column.SiteSettings,
                                column: column,
                                resultModel: resultModel);
                        }
                        break;
                    }
                });
            }));
        }
示例#2
0
 /// <summary>
 /// 更新组织
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public bool UpdateDept(DeptModel model)
 {
     return(DeptDAL.ProxyInstance.UpdateDept(model));
 }
示例#3
0
 /// <summary>
 /// 删除组织
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public bool DeleteDept(DeptModel model)
 {
     return(DeptDAL.ProxyInstance.DeleteDept(model));
 }
        public string Data(
            Context context,
            SiteSettings ss,
            DeptModel deptModel)
        {
            var column = ss.GetColumn(
                context: context,
                columnName: From);

            if (column?.CanRead(
                    context: context,
                    ss: ss,
                    mine: deptModel.Mine(context: context)) == true)
            {
                switch (column.ColumnName)
                {
                case "TenantId":
                    return(deptModel.TenantId.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "DeptId":
                    return(deptModel.DeptId.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "Ver":
                    return(deptModel.Ver.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "DeptCode":
                    return(deptModel.DeptCode.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "Dept":
                    return(deptModel.Dept.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "DeptName":
                    return(deptModel.DeptName.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "Body":
                    return(deptModel.Body.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "Title":
                    return(deptModel.Title.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "Disabled":
                    return(deptModel.Disabled.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "Comments":
                    return(deptModel.Comments.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "Creator":
                    return(deptModel.Creator.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "Updator":
                    return(deptModel.Updator.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "CreatedTime":
                    return(deptModel.CreatedTime.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "UpdatedTime":
                    return(deptModel.UpdatedTime.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "VerUp":
                    return(deptModel.VerUp.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                case "Timestamp":
                    return(deptModel.Timestamp.ToLookup(
                               context: context,
                               ss: ss,
                               column: column,
                               type: Type));

                default:
                    switch (Def.ExtendedColumnTypes.Get(column.Name))
                    {
                    case "Class":
                        return(deptModel.GetClass(column: column).ToLookup(
                                   context: context,
                                   ss: ss,
                                   column: column,
                                   type: Type));

                    case "Num":
                        return(deptModel.GetNum(column: column).ToLookup(
                                   context: context,
                                   ss: ss,
                                   column: column,
                                   type: Type));

                    case "Date":
                        return(deptModel.GetDate(column: column).ToLookup(
                                   context: context,
                                   ss: ss,
                                   column: column,
                                   type: Type));

                    case "Description":
                        return(deptModel.GetDescription(column: column).ToLookup(
                                   context: context,
                                   ss: ss,
                                   column: column,
                                   type: Type));

                    case "Check":
                        return(deptModel.GetCheck(column: column).ToLookup(
                                   context: context,
                                   ss: ss,
                                   column: column,
                                   type: Type));

                    case "Attachments":
                        return(deptModel.GetAttachments(column: column).ToLookup(
                                   context: context,
                                   ss: ss,
                                   column: column,
                                   type: Type));

                    default:
                        return(string.Empty);
                    }
                }
            }
            return(string.Empty);
        }
示例#5
0
 /// <summary>
 /// 新增组织
 /// </summary>
 /// <param name="model"></param>
 public void InsertDept(DeptModel model)
 {
     DeptDAL.ProxyInstance.InsertDept(model);
 }
示例#6
0
        public IntegrationResponse SyncDept([FromBody] DeptModel source)
        {
            var result = _lisService.SyncDept(source);

            return(result);
        }
示例#7
0
        public static HtmlBuilder Tr(
            this HtmlBuilder hb,
            Context context,
            SiteSettings ss,
            List <Column> columns,
            DataRow dataRow,
            bool editRow,
            bool checkRow,
            string idColumn,
            RecordSelector recordSelector = null,
            FormDataSet formDataSet       = null)
        {
            var dataId      = dataRow.Long(idColumn);
            var dataVersion = dataRow.Int("Ver");
            var isHistory   = dataRow.Bool("IsHistory");
            ServerScriptModelRow serverScriptRowValues = null;
            var depts         = new Dictionary <string, DeptModel>();
            var groups        = new Dictionary <string, GroupModel>();
            var registrations = new Dictionary <string, RegistrationModel>();
            var users         = new Dictionary <string, UserModel>();
            var sites         = new Dictionary <string, SiteModel>();
            var issues        = new Dictionary <string, IssueModel>();
            var results       = new Dictionary <string, ResultModel>();

            switch (ss.ReferenceType)
            {
            case "Issues":
                var issueModel = new IssueModel(
                    context: context,
                    ss: ss,
                    dataRow: dataRow,
                    formData: editRow
                            ? formDataSet?.FirstOrDefault(o =>
                                                          o.Id == dataRow.Long("IssueId"))?.Data
                            : null);
                ss.ClearColumnAccessControlCaches(baseModel: issueModel);
                serverScriptRowValues = issueModel?.SetByBeforeOpeningRowServerScript(
                    context: context,
                    ss: ss);
                issues.Add("Issues", issueModel);
                break;

            case "Results":
                var resultModel = new ResultModel(
                    context: context,
                    ss: ss,
                    dataRow: dataRow,
                    formData: editRow
                            ? formDataSet?.FirstOrDefault(o =>
                                                          o.Id == dataRow.Long("ResultId"))?.Data
                            : null);
                ss.ClearColumnAccessControlCaches(baseModel: resultModel);
                serverScriptRowValues = resultModel?.SetByBeforeOpeningRowServerScript(
                    context: context,
                    ss: ss);
                results.Add("Results", resultModel);
                break;
            }
            ;
            var extendedRowCss = serverScriptRowValues?.ExtendedRowCss;

            extendedRowCss = extendedRowCss.IsNullOrEmpty() ? string.Empty : " " + extendedRowCss;
            return(hb.Tr(
                       attributes: new HtmlAttributes()
                       .Class("grid-row" + extendedRowCss)
                       .DataId(dataId.ToString())
                       .DataVer(dataVersion)
                       .DataLatest(1, _using: !isHistory)
                       .Add(name: "data-history", value: "1", _using: isHistory)
                       .Add(name: "data-locked", value: "1", _using: dataRow.Bool("Locked")),
                       action: () =>
            {
                if (editRow)
                {
                    hb.Td(action: () => hb
                          .Button(
                              title: Displays.Reload(context: context),
                              controlCss: "button-icon",
                              onClick: $"$p.getData($(this)).Id={dataId};$p.send($(this));",
                              icon: "ui-icon-refresh",
                              action: "ReloadRow",
                              method: "post",
                              _using: !isHistory)
                          .Button(
                              title: Displays.Copy(context: context),
                              controlCss: "button-icon",
                              onClick: $"$p.getData($(this)).OriginalId={dataId};$p.send($(this));",
                              icon: "ui-icon-copy",
                              action: "CopyRow",
                              method: "post",
                              _using: !isHistory && context.CanCreate(ss: ss))
                          .Hidden(
                              controlId: $"{ss.ReferenceType}_Timestamp_{ss.SiteId}_{dataId}",
                              css: "timestamp",
                              value: dataRow
                              .Field <DateTime>("UpdatedTime")
                              .ToString("yyyy/M/d H:m:s.fff")));
                }
                else if (checkRow)
                {
                    hb.Td(action: () => hb
                          .CheckBox(
                              controlCss: "grid-check",
                              _checked: recordSelector.Checked(dataId),
                              dataId: dataId.ToString(),
                              _using: !isHistory));
                }
                columns.ForEach(column =>
                {
                    var key = column.TableName();
                    switch (column.SiteSettings?.ReferenceType)
                    {
                    case "Depts":
                        var deptModel = depts.Get(key);
                        if (deptModel == null)
                        {
                            deptModel = new DeptModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                tableAlias: column.TableAlias);
                            depts.Add(key, deptModel);
                            ss.ClearColumnAccessControlCaches(baseModel: deptModel);
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            deptModel: deptModel);
                        break;

                    case "Groups":
                        var groupModel = groups.Get(key);
                        if (groupModel == null)
                        {
                            groupModel = new GroupModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                tableAlias: column.TableAlias);
                            groups.Add(key, groupModel);
                            ss.ClearColumnAccessControlCaches(baseModel: groupModel);
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            groupModel: groupModel);
                        break;

                    case "Registrations":
                        var registrationModel = registrations.Get(key);
                        if (registrationModel == null)
                        {
                            registrationModel = new RegistrationModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                tableAlias: column.TableAlias);
                            registrations.Add(key, registrationModel);
                            ss.ClearColumnAccessControlCaches(baseModel: registrationModel);
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            registrationModel: registrationModel);
                        break;

                    case "Users":
                        var userModel = users.Get(key);
                        if (userModel == null)
                        {
                            userModel = new UserModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                tableAlias: column.TableAlias);
                            users.Add(key, userModel);
                            ss.ClearColumnAccessControlCaches(baseModel: userModel);
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            userModel: userModel);
                        break;

                    case "Sites":
                        var siteModel = sites.Get(key);
                        if (siteModel == null)
                        {
                            siteModel = new SiteModel(
                                context: context,
                                dataRow: dataRow,
                                formData: editRow
                                            ? formDataSet?.FirstOrDefault(o =>
                                                                          o.Id == dataRow.Long("SiteId"))?.Data
                                            : null,
                                tableAlias: column.TableAlias);
                            sites.Add(key, siteModel);
                            ss.ClearColumnAccessControlCaches(baseModel: siteModel);
                        }
                        hb.TdValue(
                            context: context,
                            ss: column.SiteSettings,
                            column: column,
                            siteModel: siteModel);
                        break;

                    case "Issues":
                        var issueModel = issues.Get(key);
                        if (issueModel == null)
                        {
                            issueModel = new IssueModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                formData: editRow
                                            ? formDataSet?.FirstOrDefault(o =>
                                                                          o.Id == dataRow.Long("IssueId"))?.Data
                                            : null,
                                tableAlias: column.TableAlias);
                            issues.Add(key, issueModel);
                            ss.ClearColumnAccessControlCaches(baseModel: issueModel);
                        }
                        if (!issueModel.Locked &&
                            !issueModel.ReadOnly &&
                            !isHistory &&
                            EditColumn(
                                context: context,
                                ss: ss,
                                column: column,
                                mine: issueModel.Mine(context: context)) &&
                            column.CanEdit(
                                context: context,
                                ss: ss,
                                baseModel: issueModel))
                        {
                            hb.Td(
                                css: column.TextAlign == SiteSettings.TextAlignTypes.Right
                                            ? " right-align"
                                            : string.Empty,
                                action: () => hb.Field(
                                    context: context,
                                    column: column,
                                    issueModel: issueModel,
                                    ss: column.SiteSettings,
                                    controlOnly: true,
                                    idSuffix: issueModel.IdSuffix()));
                        }
                        else
                        {
                            hb.TdValue(
                                context: context,
                                ss: column.SiteSettings,
                                column: column,
                                issueModel: issueModel,
                                serverScriptValues: serverScriptRowValues
                                ?.Columns
                                ?.Get(column?.ColumnName));
                        }
                        break;

                    case "Results":
                        var resultModel = results.Get(key);
                        if (resultModel == null)
                        {
                            resultModel = new ResultModel(
                                context: context,
                                ss: column.SiteSettings,
                                dataRow: dataRow,
                                formData: editRow
                                            ? formDataSet?.FirstOrDefault(o =>
                                                                          o.Id == dataRow.Long("ResultId"))?.Data
                                            : null,
                                tableAlias: column.TableAlias);
                            results.Add(key, resultModel);
                            ss.ClearColumnAccessControlCaches(baseModel: resultModel);
                        }
                        if (!resultModel.Locked &&
                            !resultModel.ReadOnly &&
                            !isHistory &&
                            EditColumn(
                                context: context,
                                ss: ss,
                                column: column,
                                mine: resultModel.Mine(context: context)) &&
                            column.CanEdit(
                                context: context,
                                ss: ss,
                                baseModel: resultModel))
                        {
                            hb.Td(
                                css: column.TextAlign == SiteSettings.TextAlignTypes.Right
                                            ? " right-align"
                                            : string.Empty,
                                action: () => hb.Field(
                                    context: context,
                                    column: column,
                                    resultModel: resultModel,
                                    ss: column.SiteSettings,
                                    controlOnly: true,
                                    idSuffix: resultModel.IdSuffix()));
                        }
                        else
                        {
                            hb.TdValue(
                                context: context,
                                ss: column.SiteSettings,
                                column: column,
                                resultModel: resultModel,
                                serverScriptValues: serverScriptRowValues
                                ?.Columns
                                ?.Get(column?.ColumnName));
                        }
                        break;
                    }
                });
            }));
        }
        private List <DeptModel> Srch(int codee, int chkr, RequesVal objj)
        {
            var currentUser = User.Identity.Name.Substring(0, 6);

            var xList = new List <DeptModel>();

            var cbt = 0;

            string csvHandlerLine = "";

            string[] csvHandler;

            var obj = new DeptModel()
            {
            };

            using (StreamReader CsvReader = new StreamReader(Server.MapPath("~/CSV/Dept_List.csv")))
            {
                string inputLine = "";

                while ((inputLine = CsvReader.ReadLine()) != null)
                {
                    cbt++;

                    if (cbt != 1)
                    {
                        csvHandlerLine = inputLine.Trim().Replace(" ", "");

                        char[] delimiterChars = { '\"', ',' };

                        csvHandler = csvHandlerLine.Split(delimiterChars);

                        if (chkr.Equals(1)) // Department
                        {
                            if (csvHandler[0].Equals(currentUser))
                            {
                                obj = new DeptModel()
                                {
                                    Code = csvHandler[codee].ToString(), Name = csvHandler[2].ToString()
                                };

                                if (!xList.Any(s => s.Code.Equals(obj.Code)))
                                {
                                    xList.Add(obj);
                                }
                            }
                        }
                        else if (chkr.Equals(2)) // Sub-Department
                        {
                            if (csvHandler[0].Equals(currentUser) && csvHandler[1].Equals(objj.dept) && !csvHandler[3].Equals(0))
                            {
                                obj = new DeptModel()
                                {
                                    Code = csvHandler[3].ToString(), Name = csvHandler[4].ToString()
                                };

                                if (!xList.Any(s => s.Code.Equals(obj.Code)))
                                {
                                    xList.Add(obj);
                                }
                            }
                        }
                        else if (chkr.Equals(3)) // Class
                        {
                            if (csvHandler[0].Equals(currentUser) && csvHandler[1].Equals(objj.dept) && csvHandler[3].Equals(objj.sdept) && !csvHandler[5].Equals(0))
                            {
                                obj = new DeptModel()
                                {
                                    Code = csvHandler[5].ToString(), Name = csvHandler[6].ToString()
                                };

                                if (!xList.Any(s => s.Code.Equals(obj.Code)))
                                {
                                    xList.Add(obj);
                                }
                            }
                        }
                        else if (chkr.Equals(4)) // Sub-Class
                        {
                            if (csvHandler[0].Equals(currentUser) && csvHandler[1].Equals(objj.dept) && csvHandler[3].Equals(objj.sdept) && csvHandler[5].Equals(objj.iclass) && !csvHandler[7].Equals(0))
                            {
                                obj = new DeptModel()
                                {
                                    Code = csvHandler[7].ToString(), Name = csvHandler[8].ToString()
                                };

                                if (!xList.Any(s => s.Code.Equals(obj.Code)))
                                {
                                    xList.Add(obj);
                                }
                            }
                        }
                    }
                }

                CsvReader.Close();
            }

            return(xList);
        }
示例#9
0
        private string SearchFormatText(Context context, SiteSettings ss, DataRow dataRow)
        {
            var text = SearchFormat;

            switch (ss.ReferenceType)
            {
            case "Depts":
                var deptModel = new DeptModel(
                    context: context,
                    ss: ss,
                    dataRow: dataRow);
                var deptMine = deptModel.Mine(context: context);
                ss.IncludedColumns(SearchFormat)
                .Where(column => column.CanRead(
                           context: context,
                           ss: ss,
                           mine: null))
                .ForEach(column =>
                         text = text.Replace(
                             $@"[{column.ColumnName}]",
                             $@"{deptModel.ToDisplay(
                                    context: context,
                                    ss: ss,
                                    column: column,
                                    mine: deptMine)}"));
                break;

            case "Groups":
                var groupModel = new GroupModel(
                    context: context,
                    ss: ss,
                    dataRow: dataRow);
                var groupMine = groupModel.Mine(context: context);
                ss.IncludedColumns(SearchFormat)
                .Where(column => column.CanRead(
                           context: context,
                           ss: ss,
                           mine: null))
                .ForEach(column =>
                         text = text.Replace(
                             $@"[{column.ColumnName}]",
                             $@"{groupModel.ToDisplay(
                                    context: context,
                                    ss: ss,
                                    column: column,
                                    mine: groupMine)}"));
                break;

            case "Users":
                var userModel = new UserModel(
                    context: context,
                    ss: ss,
                    dataRow: dataRow);
                var userMine = userModel.Mine(context: context);
                ss.IncludedColumns(SearchFormat)
                .Where(column => column.CanRead(
                           context: context,
                           ss: ss,
                           mine: null))
                .ForEach(column =>
                         text = text.Replace(
                             $@"[{column.ColumnName}]",
                             $@"{userModel.ToDisplay(
                                    context: context,
                                    ss: ss,
                                    column: column,
                                    mine: userMine)}"));
                break;

            case "Issues":
                var issueModel = new IssueModel(
                    context: context,
                    ss: ss,
                    dataRow: dataRow);
                var issueMine = issueModel.Mine(context: context);
                ss.IncludedColumns(SearchFormat)
                .Where(column => column.CanRead(
                           context: context,
                           ss: ss,
                           mine: null))
                .ForEach(column =>
                         text = text.Replace(
                             $@"[{column.ColumnName}]",
                             $@"{issueModel.ToDisplay(
                                    context: context,
                                    ss: ss,
                                    column: column,
                                    mine: issueMine)}"));
                break;

            case "Results":
                var resultModel = new ResultModel(
                    context: context,
                    ss: ss,
                    dataRow: dataRow);
                var resultMine = resultModel.Mine(context: context);
                ss.IncludedColumns(SearchFormat)
                .Where(column => column.CanRead(
                           context: context,
                           ss: ss,
                           mine: null))
                .ForEach(column =>
                         text = text.Replace(
                             $@"[{column.ColumnName}]",
                             $@"{resultModel.ToDisplay(
                                    context: context,
                                    ss: ss,
                                    column: column,
                                    mine: resultMine)}"));
                break;
            }
            return(text);
        }
 /// <summary>
 /// 编辑单条Dept
 /// </summary>
 /// <param name="model">地块信息实体</param>
 /// <returns></returns>
 public MessageModel UpdateSingleDept(DeptModel model)
 {
     return(deptAccess.UpdateSingleEntity(model));
 }
 /// <summary>
 /// 新增单条Dept
 /// </summary>
 /// <param name="model">地块信息实体</param>
 /// <returns></returns>
 public MessageModel InsertSingleDept(DeptModel model)
 {
     return(deptAccess.InsertSingleEntity(model));
 }
示例#12
0
        public Dictionary <string, string> LookupData(
            Context context,
            SiteSettings ss,
            Link link,
            long id)
        {
            var currentSs = ss.Destinations.Get(link.SiteId);
            var canRead   = false;

            if (currentSs == null)
            {
                canRead = true;
                switch (link?.TableName)
                {
                case "Depts":
                    currentSs = SiteSettingsUtilities.DeptsSiteSettings(context: context);
                    break;

                case "Users":
                    currentSs = SiteSettingsUtilities.UsersSiteSettings(context: context);
                    break;

                case "Groups":
                    currentSs = SiteSettingsUtilities.GroupsSiteSettings(context: context);
                    break;

                default:
                    canRead = false;
                    break;
                }
            }
            else
            {
                canRead = Permissions.CanRead(
                    context: context,
                    siteId: currentSs.SiteId,
                    id: id);
            }
            var formData = link.Lookups.ToDictionary(
                lookup => $"{currentSs.ReferenceType}_{lookup.To}",
                lookup => string.Empty);

            if (id > 0 &&
                currentSs != null &&
                canRead)
            {
                link.Lookups.ForEach(lookup =>
                {
                    formData.AddOrUpdate(
                        $"{currentSs.ReferenceType}_{lookup.To}",
                        string.Empty);
                });
                switch (currentSs.ReferenceType)
                {
                case "Issues":
                    var issueModel = new IssueModel(
                        context: context,
                        ss: currentSs,
                        issueId: id);
                    link.Lookups.ForEach(lookup =>
                                         formData.AddOrUpdate(
                                             $"{ss.ReferenceType}_{lookup.To}",
                                             lookup.Data(
                                                 context: context,
                                                 ss: currentSs,
                                                 issueModel: issueModel)));
                    break;

                case "Results":
                    var resultModel = new ResultModel(
                        context: context,
                        ss: currentSs,
                        resultId: id);
                    link.Lookups.ForEach(lookup =>
                                         formData.AddOrUpdate(
                                             $"{ss.ReferenceType}_{lookup.To}",
                                             lookup.Data(
                                                 context: context,
                                                 ss: currentSs,
                                                 resultModel: resultModel)));
                    break;

                case "Depts":
                    var deptModel = new DeptModel(
                        context: context,
                        ss: currentSs,
                        deptId: id.ToInt());
                    link.Lookups.ForEach(lookup =>
                                         formData.AddOrUpdate(
                                             $"{ss.ReferenceType}_{lookup.To}",
                                             lookup.Data(
                                                 context: context,
                                                 ss: currentSs,
                                                 deptModel: deptModel)));
                    break;

                case "Users":
                    var userModel = new UserModel(
                        context: context,
                        ss: currentSs,
                        userId: id.ToInt());
                    link.Lookups.ForEach(lookup =>
                                         formData.AddOrUpdate(
                                             $"{ss.ReferenceType}_{lookup.To}",
                                             lookup.Data(
                                                 context: context,
                                                 ss: currentSs,
                                                 userModel: userModel)));
                    break;

                case "Groups":
                    var groupModel = new GroupModel(
                        context: context,
                        ss: currentSs,
                        groupId: id.ToInt());
                    link.Lookups.ForEach(lookup =>
                                         formData.AddOrUpdate(
                                             $"{ss.ReferenceType}_{lookup.To}",
                                             lookup.Data(
                                                 context: context,
                                                 ss: currentSs,
                                                 groupModel: groupModel)));
                    break;
                }
            }
            return(formData);
        }
示例#13
0
 public bool UpdateDept(DeptModel model)
 {
     return(Update <DeptModel>(model, model.depart_id));
 }
示例#14
0
 public bool DeleteDept(DeptModel model)
 {
     return(DeleteByKey(model.depart_id));
 }
示例#15
0
 public void InsertDept(DeptModel model)
 {
     Insert <DeptModel>(model);
 }
示例#16
0
        /// <summary>
        /// 编辑组织机构信息
        /// </summary>
        /// <param name="model">保存信息</param>
        /// <returns></returns>
        public static bool SaveDeptInfo(DeptModel model)
        {
            //获取登陆用户信息
            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];

            //设置公司代码
            model.CompanyCD      = userInfo.CompanyCD;
            model.ModifiedUserID = userInfo.UserID;
            //定义返回变量
            bool isSucc = false;
            //操作日志
            LogInfoModel logModel = InitLogInfo(model.DeptNO);

            //更新
            if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
            {
                try
                {
                    logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
                    //执行更新操作
                    isSucc = DeptInfoDBHelper.UpdateDeptInfo(model);
                }
                catch (Exception ex)
                {
                    //输出系统日志
                    WriteSystemLog(userInfo, ex);
                }
            }
            //插入
            else
            {
                try
                {
                    logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
                    //执行插入操作
                    isSucc = DeptInfoDBHelper.InsertDeptInfo(model);
                }
                catch (Exception ex)
                {
                    //输出系统日志
                    WriteSystemLog(userInfo, ex);
                }
            }
            //更新成功时
            if (isSucc)
            {
                //设置操作成功标识
                logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
            }
            //更新不成功
            else
            {
                //设置操作成功标识
                logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
            }

            //登陆日志
            LogDBHelper.InsertLog(logModel);

            return(isSucc);
        }