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";
}
