Esempio n. 1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string sqlDept = "select LSDeptID from LS_tblDepartment";
            string sqlJob  = "SELECT LSJobTitleID FROM LS_tblJobTitle";
            string sqlNat  = "SELECT LSNationalityID FROM dbo.LS_tblNationality";

            DataAccess DA = new DataAccess();

            var dataDept = DA.ExecuteReader(sqlDept);
            var dataJob  = DA.ExecuteReader(sqlJob);
            var dataNat  = DA.ExecuteReader(sqlNat);

            DeptID.DataTextField  = "LSDeptID";
            DeptID.DataSource     = dataDept;
            DeptID.DataValueField = "LSDeptID";
            DeptID.DataBind();

            JobTitleID.DataTextField  = "LSJobTitleID";
            JobTitleID.DataValueField = "LSJobTitleID";
            JobTitleID.DataSource     = dataJob;
            JobTitleID.DataBind();

            NationalityID.DataTextField  = "LSNationalityID";
            NationalityID.DataValueField = "LSNationalityID";
            NationalityID.DataSource     = dataNat;
            NationalityID.DataBind();
            load();
        }
        public override int GetHashCode()
        {
            int hashCode = 13;

            hashCode = (hashCode * 7) + DeptID.GetHashCode();
            hashCode = (hashCode * 7) + PhoneID.GetHashCode();
            return(hashCode);
        }
Esempio n. 3
0
        /// <summary>验证数据,通过抛出异常的方式提示验证失败。</summary>
        /// <param name="isNew">是否插入</param>
        public override void Valid(Boolean isNew)
        {
            // 如果没有脏数据,则不需要进行任何处理
            if (!HasDirty)
            {
                return;
            }

            // 这里验证参数范围,建议抛出参数异常,指定参数名,前端用户界面可以捕获参数异常并聚焦到对应的参数输入框
            if (DeptID.IsNullOrEmpty())
            {
                throw new ArgumentNullException(nameof(DeptID), "部门编号不能为空!");
            }

            // 在新插入数据或者修改了指定字段时进行修正
            //if (isNew && !Dirtys[nameof(CreateTime)]) CreateTime = DateTime.Now;
            //if (!Dirtys[nameof(UpdateTime)]) UpdateTime = DateTime.Now;
            //if (isNew && !Dirtys[nameof(CreateIP)]) CreateIP = ManageProvider.UserHost;
            //if (!Dirtys[nameof(UpdateIP)]) UpdateIP = ManageProvider.UserHost;

            // 检查唯一索引
            // CheckExist(isNew, __.id, __.DeptID);
        }
Esempio n. 4
0
        /// <summary>
        /// 界面打开时加载数据
        /// </summary>
        /// <param name="sender">控件</param>
        /// <param name="e">参数</param>
        private void FrmDept_OpenWindowBefore(object sender, EventArgs e)
        {
            treeDeptLayer.SelectedIndexChanged -= treeDeptLayer_SelectedIndexChanged;
            InvokeController("LoadBasicWorkers");
            if (treeDeptLayer.SelectedNode != null)
            {
                InvokeController("LoadDeptList", cboWorker.SelectedValue, treeDeptLayer.SelectedNode.Name, string.Empty);
            }

            //超级用户
            if ((InvokeController("this") as AbstractController).LoginUserInfo.IsAdmin == 2)
            {
                cboWorker.Enabled = true;
            }
            else
            {
                cboWorker.Enabled = false;
            }

            treeDeptLayer.SelectedIndexChanged += treeDeptLayer_SelectedIndexChanged;
            DeptID.Hide();
            toolbarDel.Enabled  = false;
            toolMenuDel.Enabled = false;
        }