/*===============================
* 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
}
