Exemple #1
0
 /// <summary>
 /// 绑定用户信息
 /// </summary>
 /// <param name="username"></param>
 private void BindUser()
 {
     UserParamManager upmg=new UserParamManager();
     userparam up = upmg.GetUser(Session["username"].ToString());
     realname.Text = up.Truename;
     telephone.Text = up.Phone;
     mobile.Text = up.Mobile;
     address.Text = up.Address;
 }
    protected void Button2_Click(object sender, EventArgs e)
    {
        UserParamManager upmg=new UserParamManager();
        GridView1.DataSource = upmg.GetAllUser();
        GridView1.DataBind();
        TabWebControl1.SelectedTabIndex = 1;

         Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
        Response.ContentEncoding = System.Text.Encoding.UTF7;
        Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        this.GridView1.RenderControl(oHtmlTextWriter);
        Response.Output.Write(oStringWriter.ToString());
        Response.Flush();
        Response.End();
    }
Exemple #3
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        UserParamManager upmg=new UserParamManager();
        if (username.Text.ToString().Trim() == "" || password.Text.ToString().Trim() == "")
        {
            ClientScript.RegisterStartupScript(this.GetType(), "提示", "<script>alert('用户名或密码必填')</script>");
        }
        else
        {
            if (upmg.login(username.Text.ToString().Trim(), password.Text.ToString().Trim()))
            {
                Session["username"] = username.Text.ToString().Trim();
                WebReportLogManager.AddNesWebReportLog(username.Text.ToString().Trim(), true);
                Response.Redirect("main.aspx");

            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('用户名或密码错误')</script>");
                password.Text = "";
                WebReportLogManager.AddNesWebReportLog(username.Text.ToString().Trim(), false);
            }
        }
    }
Exemple #4
0
        /// <summary>
        /// ���ض���ʱ�䵼������
        /// </summary>
        /// <param name="timesring"></param>
        /// <param name="timenow"></param>
        private void ImportData(string timesring, string timenow)
        {
            bool flag = false;
            UserParamManager upg = new UserParamManager();
            string[] a = timesring.Split(' ');
            if (a.Length == 0)
            {
                if (timesring == timenow&&flag==false)
                {

                    upg.DelAll();
                    listBox1.Items.Add("UserParam���ѳɹ����");
                    DataTable dt = new DataTable();
                    dt = GetDataTableFromMySql();
                    for (int j = 0; j < dt.Rows.Count; j++)
                    {
                        upg.AddUser(dt.Rows[j]["username"].ToString(), Function.PasswordMD5(dt.Rows[j]["password"].ToString()), ISO8859_GB2312(dt.Rows[j]["realname"].ToString()), ISO8859_GB2312(dt.Rows[j]["address"].ToString()), dt.Rows[j]["telephone"].ToString(), dt.Rows[j]["mobile"].ToString());
                        //listBox1.Items.Add(ISO8859_GB2312(dt.Rows[j]["address"].ToString()));
                    }
                    dt.Dispose();
                    listBox1.Items.Add("���ݿ��ѳɹ�����");
                    flag = true;
                }

            }
            else
            {
                string[] time = timesring.Split(' ');

                for (int i = 0; i < time.Length; i++)
                {

                    if (time[i] == timenow&&flag==false)
                    {

                        upg.DelAll();
                        listBox1.Items.Add("UserParam���ѳɹ����");
                        DataTable dt = new DataTable();
                        dt = GetDataTableFromMySql();
                        for (int j = 0; j < dt.Rows.Count; j++)
                        {
                            upg.AddUser(dt.Rows[j]["username"].ToString(), Function.PasswordMD5(dt.Rows[j]["password"].ToString()), ISO8859_GB2312(dt.Rows[j]["realname"].ToString()), ISO8859_GB2312(dt.Rows[j]["address"].ToString()), dt.Rows[j]["telephone"].ToString(), dt.Rows[j]["mobile"].ToString());
                            //listBox1.Items.Add(ISO8859_GB2312(dt.Rows[j]["address"].ToString()));
                        }
                        dt.Dispose();
                        listBox1.Items.Add("���ݿ��ѳɹ�����");
                        flag = true;
                    }

                }
            }
        }