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