public bool UpdateUser(int rowHandle)
{
string sql = "";
string userCode = gridView.GetRowCellValue(rowHandle, colUserCode).ToString();
string userName = gridView.GetRowCellValue(rowHandle, colUserName).ToString();
string userPsw = gridView.GetRowCellValue(rowHandle, colUserPsw).ToString();
string userKind = gridView.GetRowCellValue(rowHandle, colUserKind).ToString();
int userKindNo = User.GetUserKindNo(userKind);
if (string.IsNullOrEmpty(userName))
{
return(false);
}
userPsw = encrypt.EncryptString(userPsw);
sql = String.Format("Update T_User Set UserCode = '{0}', UserName='******', UserPsw='{2}',UserRight='{3}' where UserCode = '{4}'",
userCode.Replace("'", "''"),
userName.Replace("'", "''"),
userPsw.Replace("'", "''"),
userKindNo,
userCode.Replace("'", "''"));
return(Database.ExecuteSQL(sql, "UserGridView-UpdateUser") == 1 ? true : false);
}
