You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
|
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;
} } }
|