Пример #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string userIdStr = Session["userId"].ToString();
            string roleIdStr = Session["roleId"].ToString();
            if (roleIdStr == "1")
            {
                LoadLookup.LoadProgram(ddlProgram, "xxx", true);
                ddlProgram.SelectedValue = "0";
                LoadLookup.LoadMemberOnProgram(0, ddlMember);
                LoadLookup.LoadResource(ddlResource, "xxx");
            }
            if (roleIdStr == "2")
            {
                string        connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString;
                SqlConnection conn          = new SqlConnection(connectionStr);
                string        sqlStatement;
                sqlStatement = "select" +
                               " right('0' + convert(varchar, lp.l_program_id),2) + '-' + lp.program_name as program" +
                               " from pub_user pu" +
                               " inner join program_leader pl" +
                               " on pu.client_id = pl.client_id" +
                               " inner join l_program lp" +
                               " on pl.l_program_id = lp.l_program_id" +
                               " where pu.pub_user_id = " +
                               userIdStr;

                SqlCommand command = new SqlCommand(sqlStatement, conn);
                conn.Open();
                string program    = "";
                object programObj = (object)command.ExecuteScalar();
                if (programObj != DBNull.Value)
                {
                    program = programObj.ToString();
                }
                conn.Close();
                LoadLookup.LoadProgram(ddlProgram, program, true);

                //ddlProgram.SelectedValue = "0";
                //LoadLookup.LoadMemberOnProgram(0, ddlMember);

                //ddlProgram.Enabled = false;
                int programId = Convert.ToInt32(ddlProgram.SelectedValue);
                LoadLookup.LoadMemberOnProgram(programId, ddlMember);

                //SelectProgram(sender, e);
            }

            HttpCookie _dateCookies = Request.Cookies["dates"];
            if (_dateCookies != null)
            {
                txtStartDate.Text = _dateCookies["startDate"];
                txtEndDate.Text   = _dateCookies["endDate"];
            }
        }
        //string scriptStr = "function ShowConfirmation(){return confirm('hahaha');}";
        //Page.ClientScript.RegisterStartupScript(this.GetType(), "Hello", scriptStr, true);
        //Button1.Attributes.Add("OnClick", "javascript:return ShowConfirmation();");
    }