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