/*=============================== * Display Record Form * -------------------------------*/ void User_Show() { // User Show begin bool ActionInsert = true; if (p_User_user_id.Value.Length > 0) { string sWhere = ""; sWhere += "user_id=" + CCUtility.ToSQL(p_User_user_id.Value, CCUtility.FIELD_TYPE_Number); // User Open Event begin // User Open Event end string sSQL = "select * from users where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "User") > 0) { row = ds.Tables[0].Rows[0]; User_user_id.Value = CCUtility.GetValue(row, "user_id"); User_user_name.Text = Server.HtmlEncode(CCUtility.GetValue(row, "user_name").ToString()); User_login.Text = Server.HtmlEncode(CCUtility.GetValue(row, "login").ToString()); User_pass.Text = CCUtility.GetValue(row, "pass"); User_notify_new.Checked = CCUtility.GetValue(row, "notify_new").ToLower().Equals("1".ToLower()); User_notify_original.Checked = CCUtility.GetValue(row, "notify_original").ToLower().Equals("1".ToLower()); User_notify_reassignment.Checked = CCUtility.GetValue(row, "notify_reassignment").ToLower().Equals("1".ToLower()); User_allow_upload.Text = Server.HtmlEncode(CCUtility.GetValFromLOV(CCUtility.GetValue(row, "allow_upload"), User_allow_upload_lov).ToString()); User_security_level.Text = Server.HtmlEncode(CCUtility.GetValFromLOV(CCUtility.GetValue(row, "security_level"), User_security_level_lov).ToString()); ActionInsert = false; // User ShowEdit Event begin // User ShowEdit Event end } } if (ActionInsert) { String pValue; if (Session["UserID"] != null) { pValue = Session["UserID"].ToString(); } else { pValue = ""; } User_user_id.Value = pValue; User_update.Visible = false; // User ShowInsert Event begin // User ShowInsert Event end } // User Open Event begin // User Open Event end // User Show Event begin // User Show Event end // User Show end // User Close Event begin // User Close Event end }