public void Update(DS_CompanyInfo CompanyInfo)
{
using (var ct = new DS_CompanyInfoDataContext(DbHelperSQL.Connection))
{
ct.DS_CompanyInfo.Attach(CompanyInfo, true);
ct.SubmitChanges();
}
}
public void Add(DS_CompanyInfo CompanyInfo)
{
using (var ct = new DS_CompanyInfoDataContext(DbHelperSQL.Connection))
{
ct.DS_CompanyInfo.InsertOnSubmit(CompanyInfo);
ct.SubmitChanges();
}
}
public void Delete(int ID)
{
using (var ct = new DS_CompanyInfoDataContext(DbHelperSQL.Connection))
{
DS_CompanyInfo st = ct.DS_CompanyInfo.Single(a => a.ID == ID);
ct.DS_CompanyInfo.DeleteOnSubmit(st);
ct.SubmitChanges();
}
}
/// <summary>
/// 注册
/// </summary>
/// <param name="Member"></param>
/// <param name="Company"></param>
public void Register(DS_Members Member, DS_CompanyInfo Company)
{
using (DbConnection con = DbHelperSQL.GetConnection())
{
var tran = con.BeginTransaction();
var mbct = new DS_MembersDataContext(con);
mbct.Transaction = tran;
mbct.DS_Members.InsertOnSubmit(Member);
mbct.SubmitChanges();
var comct = new DS_CompanyInfoDataContext(con);
comct.Transaction = tran;
Company.MenberID = Member.ID;
comct.DS_CompanyInfo.InsertOnSubmit(Company);
comct.SubmitChanges();
tran.Commit();
}
}
