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(); } }