using System;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Collections;
using System.Text;
using System.Configuration;
using System.Web.Script.Services;
using System.Collections.Generic;

namespace OT.Web
{
    /// <summary>
    /// WebService1 的摘要描述
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // 若要允許使用 ASP.NET AJAX 從指令碼呼叫此 Web 服務，請取消註解下一行。
     [System.Web.Script.Services.ScriptService]
    public class WebService1 : System.Web.Services.WebService
    {

        [WebMethod]
        //public string HelloWorld()
        //{
        //    return "Hello World";
        //}
        public string LoginVerification(string strUserId, string strPwd)
        {

            //連線SQL資料庫
            SqlConnection cn =     new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());

            //將Department為一個查詢用的參數，去查詢UserDataForm資料表

            SqlCommand cmd =
                    new SqlCommand("SELECT  MemberID,Password FROM    OTB_SYS_Members WHERE  MemberID like @id", cn);

            cmd.Parameters.AddWithValue("@id", strUserId.Trim());
            cn.Open();

            SqlDataReader dr = cmd.ExecuteReader();
            //將查詢的資料傳到tbl資料表輸出

            DataTable tbl = new DataTable("DepartmentUser");
            string pwd = Ap_Code.SecurityUtil.DESEncrypt(strPwd, System.Configuration.ConfigurationManager.AppSettings["DefaultCryptionKey"].Trim(), System.Configuration.ConfigurationManager.AppSettings["DefaultCryptionIV"].Trim());
            tbl.Load(dr);
            int intCount = tbl.Rows.Count;
            string ChkPwd = string.Empty;
            if (intCount != 0)
            {
                ChkPwd = tbl.Rows[0]["Password"].ToString();
            }
            string strreturn = (intCount == 0) ? "A00068" : (ChkPwd != pwd) ? "A00069" : "ok";

            cn.Close();
            return strreturn;

        }
        [WebMethod]
        [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
        public int GetUsers(string name, int age)
        {
            SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());

            //將Department為一個查詢用的參數，去查詢UserDataForm資料表

            SqlCommand cmd =
                    new SqlCommand("select page_cd ,count(*) as click_qt from trdata.dbo.tvlpageclick group by page_cd  order by page_cd", cn);

            cmd.Parameters.AddWithValue("@id", name.Trim());
            cn.Open();

            SqlDataReader dr = cmd.ExecuteReader();
            //將查詢的資料傳到tbl資料表輸出

            DataTable tbl = new DataTable("DepartmentUser");
            List<string> res = new List<string>();
            for (int i = 1; i <= tbl.Rows.Count; i++)
            {
                res.Add(tbl.Rows[i][1] + "," + tbl.Rows[i][1]);
            }
            // return res.ToArray();
            return tbl.Rows.Count;

        }
    }
}