private void GetData(frmUserInfo ofrmUserInfo) { oUserInfo.UserId = ofrmUserInfo.iUserId; oUserInfo.UserCode = ofrmUserInfo.txtNo.Text.Trim(); oUserInfo.UserName = ofrmUserInfo.txtUserName.Text.Trim(); oUserInfo.PassWord = ofrmUserInfo.txtPassWord.Text.Trim(); oUserInfo.PermsDept = PublicUtility.GetCheckList(ofrmUserInfo.chkListDept); oUserInfo.PermsRole = PublicUtility.GetCheckList(ofrmUserInfo.chkListRole); }
private void gridView1_DoubleClick(object sender, EventArgs e) { int iUserId = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID").ToString()); frmUserInfo ofrmUserInfo = new frmUserInfo(); FillData(0, ofrmUserInfo); initForm(iUserId, ofrmUserInfo); ofrmUserInfo.ShowDialog(this); }
private void btnAdd_Click(object sender, EventArgs e) { frmUserInfo ofrmUserInfo = new frmUserInfo(); iOperType = 0; initForm(0, ofrmUserInfo); ofrmUserInfo.ShowDialog(this); if (ofrmUserInfo.DialogResult == DialogResult.OK) { GetData(ofrmUserInfo); SaveInfo(); } }
private void btnEdit_Click(object sender, EventArgs e) { iOperType = 1; int iUserId = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID").ToString()); frmUserInfo ofrmUserInfo = new frmUserInfo(); FillData(0, ofrmUserInfo); initForm(iUserId, ofrmUserInfo); ofrmUserInfo.ShowDialog(this); if (ofrmUserInfo.DialogResult == DialogResult.OK) { GetData(ofrmUserInfo); SaveInfo(); } }
private void FillData(int iId, frmUserInfo ofrmUserInfo) { if (gridView1.FocusedRowHandle > 0) { ofrmUserInfo.iUserId = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID").ToString()); ofrmUserInfo.txtId.Text = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID").ToString(); ofrmUserInfo.txtNo.Text = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "USERCODE").ToString(); ofrmUserInfo.txtUserName.Text = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "USERNAME").ToString(); //ofrmUserInfo.txtPassWord.Text = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "PASSWORD").ToString(); //ofrmUserInfo.txtPassWordPre.Text = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "PASSWORD").ToString(); oUserInfo.UserId = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID").ToString()); oUserInfo.UserCode = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "USERCODE").ToString(); oUserInfo.UserName = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "USERNAME").ToString(); oUserInfo.PassWord = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "PASSWORD").ToString(); oUserInfo.PermsDept = PublicUtility.GetCheckList(ofrmUserInfo.chkListDept); oUserInfo.PermsRole = PublicUtility.GetCheckList(ofrmUserInfo.chkListRole); } }
private void initForm(int iUserId, frmUserInfo ofrmUserInfo) { string sDeptSql = "SELECT DEPTID,DEPTNAME," + "CONVERT(Bit,CASE WHEN(SELECT DEPTID FROM T_USER_DEPT WHERE DEPTID = A.DEPTID AND USERID = " + iUserId.ToString() + ") IS NULL THEN 0 ELSE 1 END) AS ISCHECK " + "FROM T_DEPT A"; ofrmUserInfo.chkListDept.DataSource = PublicUtility.GetDataTable(sDeptSql); ofrmUserInfo.chkListDept.DisplayMember = "DEPTNAME"; ofrmUserInfo.chkListDept.ValueMember = "DEPTID"; ofrmUserInfo.chkListDept.CheckMember = "ISCHECK"; string sRoleSql = "SELECT ROLEID,ROLENAME," + "CONVERT(Bit,CASE WHEN(SELECT ROLEID FROM T_USER_ROLE WHERE ROLEID = A.ROLEID AND USERID = " + iUserId.ToString() + ") IS NULL THEN 0 ELSE 1 END) AS ISCHECK " + "FROM T_ROLE A "; ofrmUserInfo.chkListRole.DataSource = PublicUtility.GetDataTable(sRoleSql); ofrmUserInfo.chkListRole.DisplayMember = "ROLENAME"; ofrmUserInfo.chkListRole.ValueMember = "ROLEID"; ofrmUserInfo.chkListRole.CheckMember = "ISCHECK"; }