示例#1
0
文件: LoginUsr.cs 项目: xin1231/test
    //''' 登出

    public void LogOut()
    {
        //'加到session及cookie
        context.Session["UsrCde"] = "";
        context.Session["UsrNme"] = "";
        context.Session["UsrUid"] = "";
        context.Session["UsrEml"] = "";



        IZCls.Cookie CookieVar = new IZCls.Cookie();
        CookieVar.AddValue("UsrCde", "");
        CookieVar.AddValue("UsrNme", "");
        CookieVar.AddValue("UsrUid", "");
        CookieVar.AddValue("UsrEml", "");


        CookieVar.SetCookieValue(context.Response, CookieName, CookieVar.GetStr(), 1); //'寫入cookie


        context.Session.Abandon();

        WebFormBase.SetCookieValue(context.Response, CookieName, "", -1);

        WebFormBase.ShowJavaScriptMsgBack(context.Response, "謝謝您的光臨", "../" + AdminDefPath + "Login.aspx");
    }
示例#2
0
文件: LoginUsr.cs 项目: xin1231/test
    // ''' <summary>
    //''' 檢查帳號密碼
    //''' </summary>
    //''' <param name="UID"></param>
    //''' <param name="PWD"></param>
    //''' <remarks></remarks>

    public void chkUidPwd(String UIDt, String PWDt)
    {
        if (UIDt == "")
        {
            WebFormBase.ShowJavaScriptMsgBack(context.Response, "請填帳號", "");
        }
        if (PWDt == "")
        {
            WebFormBase.ShowJavaScriptMsgBack(context.Response, "請填密碼", "");
        }
        IzDataSource IzDataSource = new IzDataSource();

        IzDataSource.SelectString = "select * from tbUsr where tbUsrFlg=1 and tbUsrStu=1 and tbUsrUid=@tbUsrUid and tbUsrPwd=@tbUsrPwd";
        IzDataSource.ParametersAdd("tbUsrUid", UIDt);
        IzDataSource.ParametersAdd("tbUsrPwd", PWDt);
        System.Data.DataTable tbUsr = IzDataSource.SelectDataTable();
        if (tbUsr.Rows.Count > 0)
        {
            //'加到session及cookie
            context.Session["UsrCde"] = tbUsr.Rows[0]["tbUsrCde"].ToString();
            context.Session["UsrNme"] = tbUsr.Rows[0]["tbUsrNme"].ToString();
            context.Session["UsrUid"] = tbUsr.Rows[0]["tbUsrUid"].ToString();
            context.Session["UsrEml"] = tbUsr.Rows[0]["tbUsrEml"].ToString();

            IZCls.Cookie CookieVar = new IZCls.Cookie();
            CookieVar.AddValue("UsrCde", context.Session["UsrCde"].ToString());
            CookieVar.AddValue("UsrNme", context.Session["UsrNme"].ToString());
            CookieVar.AddValue("UsrUid", context.Session["UsrUid"].ToString());
            CookieVar.AddValue("UsrEml", context.Session["UsrEml"].ToString());

            CookieVar.SetCookieValue(context.Response, CookieName, CookieVar.GetStr(), 3); //'寫入cookie



            //'寫入登入紀錄
            //IzDataSource.ExecuteSQLNoneQuery("insert into tbLog(tbUsrCde,tbLogLdt,tbLogLip) values('" & context.Session("UsrCde") & "',getdate(),'" & context.Request.UserHostAddress & "')")

            //Dim tbUsrLcn As System.Data.DataTable = IzDataSource.GenDataTable("select count(*) from tbLog where tbUsrCde='" & context.Session("UsrCde") & "'")
            //IzDataSource.ExecuteSQLNoneQuery("update tbUsr set tbUsrLcn=" & tbUsrLcn.Rows(0).Item(0) & " where tbUsrCde='" & context.Session("UsrCde") & "'")
            //tbUsrLcn.Dispose()
        }
        else
        {
            WebFormBase.ShowJavaScriptMsgBack(context.Response, "帳號密碼錯誤!", "");
        }
        tbUsr.Dispose();
        IzDataSource.Dispose();
    }