📄 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 + -