?? service.cs
字號:
?using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.Text;
// NOTE: If you change the class name "Service" here, you must also update the reference to "Service" in Web.config.
public class Service : IService
{
#region IService Members
//獲取通訊錄表
public List<addresslist> GetAllAddress()
{
DataClassesDataContext db = new DataClassesDataContext();
var add = from a in db.addresslists
select a;
return add.ToList<addresslist>();
}
//存入一個電話記錄
public addresslist SaveAAddress(addresslist address)
{
DataClassesDataContext db = new DataClassesDataContext();
if (address.編號 > 0)
{
db.addresslists.Attach(address, true);
}
else { db.addresslists.InsertOnSubmit(address); }
db.SubmitChanges();
return address;
}
//獲取圖書館書籍
public List<librarylist> GetAllBooks()
{
DataClassesDataContext db = new DataClassesDataContext();
var book = from b in db.librarylists
select b;
return book.ToList<librarylist>();
}
//根據書名查詢書籍
public List<librarylist> GetBookWithName(string bookname)
{
DataClassesDataContext db = new DataClassesDataContext();
var book = from b in db.librarylists
where b.書名==bookname
select b;
return book.ToList<librarylist>();
}
//根據編號查詢書籍
public List<librarylist> GetBookWithMark(string marknum)
{
DataClassesDataContext db = new DataClassesDataContext();
var book = from b in db.librarylists
where b.書標號 == marknum
select b;
return book.ToList<librarylist>();
}
//根據作者查詢書籍
public List<librarylist> GetBookWithAuthor(string author)
{
DataClassesDataContext db = new DataClassesDataContext();
var book = from b in db.librarylists
where b.作者 == author
select b;
return book.ToList<librarylist>();
}
//根據姓名刪除聯系人
public void DeleteAAdd(string name)
{
DataClassesDataContext db = new DataClassesDataContext();
var result = from r in db.addresslists
where r.姓名 == name
select r;
db.addresslists.DeleteAllOnSubmit(result);
db.SubmitChanges();
}
#endregion
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -