public List <T> Query <T>(string sql, params object[] parameterValues) { using (var ct = new DS_CompanyInfoDataContext(DbHelperSQL.Connection)) { return(ct.ExecuteQuery <T>(sql, parameterValues).ToList()); } }
public DS_CompanyInfo GetSingleByMemberID(int MemberID) { using (var ct = new DS_CompanyInfoDataContext(DbHelperSQL.Connection)) { return(ct.DS_CompanyInfo.Single(a => a.MenberID == MemberID)); } }
public DS_CompanyInfo GetSingle(int ID) { using (var ct = new DS_CompanyInfoDataContext(DbHelperSQL.Connection)) { return(ct.DS_CompanyInfo.Single(a => a.ID == ID)); } }
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(); } }
public List <DS_CompanyInfo> Query(string condition, string orderby, params object[] param) { using (var ct = new DS_CompanyInfoDataContext(DbHelperSQL.Connection)) { IQueryable <DS_CompanyInfo> CompanyInfoList = ct.DS_CompanyInfo; if (!string.IsNullOrEmpty(condition)) { CompanyInfoList = CompanyInfoList.Where(condition, param); } if (!string.IsNullOrEmpty(orderby)) { CompanyInfoList = CompanyInfoList.OrderBy(orderby); } return(CompanyInfoList.ToList()); } }
/// <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(); } }
public List <DS_CompanyInfo> Query(string condition, string orderby, int startIndex, int pageSize, ref int pageCount, params object[] param) { using (var ct = new DS_CompanyInfoDataContext(DbHelperSQL.Connection)) { IQueryable <DS_CompanyInfo> CompanyInfoList = ct.DS_CompanyInfo; if (!string.IsNullOrEmpty(condition)) { CompanyInfoList = CompanyInfoList.Where(condition, param); } if (!string.IsNullOrEmpty(orderby)) { CompanyInfoList = CompanyInfoList.OrderBy(orderby); } pageCount = CompanyInfoList.Count(); return(CompanyInfoList.Skip(startIndex).Take(pageSize).ToList()); } }