?? service.cs
字號:
?using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public Service () {
//如果使用設計的組件,請取消注釋以下行
//InitializeComponent();
}
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public bool InsertBookRoom(string bookUser,string bookDate,string bookRoom,string bookRoomCount)
{
SqlConnection con = null;
try
{
string sqlConn = "workstation id=HZ_IT_ZHONGJ;packet size=4096;integrated security=SSPI;data source=.;persist security info=False;initial catalog=hotel";
// string sqlConn = "server=.;database=hotel;uid=sa;pwd=;Max Pool Size=20000;";
con = new SqlConnection(sqlConn);
string sqlStr = "INSERT INTO BookRoom VALUES('" + bookUser + "','" + bookDate + "','" + bookRoom + "','" + bookRoomCount + "')";
SqlCommand cmd = new SqlCommand(sqlStr, con);
con.Open();
cmd.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -