public SScoreInfo GetInfoByPrimeKey(string id)
{
SScoreInfo info = new SScoreInfo();
string sql = " SELECT * FROM " + info.TableName + " WHERE " + info.PrimeKeyName + "=@" + info.PrimeKeyName;
if (info.ImportByReader(dh.ExecuteReader(sql, new DataParameter(id, info.PrimeKeyName, DbType.String))))
{
return info;
}
return null;
} public SScoreInfo GetInfoByName(String userName)
{
SScoreInfo info = new SScoreInfo();
string sql = " SELECT * FROM " + info.TableName + " WHERE UserName=@UserName" ;
if (info.ImportByReader(dh.ExecuteReader(sql, new DataParameter(userName, "UserName", DbType.String))))
{
return info;
}
return null;
} public bool IsExistByPrimeKey(string id)
{
SScoreInfo SScoreInfo = new SScoreInfo();
string wherefield = " AND " + SScoreInfo.PrimeKeyName + "=@" + SScoreInfo.PrimeKeyName;
DataParameter dp = new DataParameter(id, SScoreInfo.PrimeKeyName, DbType.String);
return 0 != dh.PageByCount(SScoreInfo.TableName, wherefield, dp);
}
public DataTable GetPageTableBySearch(int pageSize, int pageIndex, params string[] fields)
{
SScoreInfo iInfo = new SScoreInfo();
return dh.PageByTable(iInfo.TableName, BuildWhere(fields), pageSize, pageIndex, "*", this.OrderField);
} public DataTable GetTableByGroupName(string groupname)
{ return dh.ExecuteTable("Select * from SScore");
}
{
SScoreInfo info = new SScoreInfo();
string sql = " SELECT * FROM " + info.TableName + " WHERE " + info.PrimeKeyName + "=@" + info.PrimeKeyName;
if (info.ImportByReader(dh.ExecuteReader(sql, new DataParameter(id, info.PrimeKeyName, DbType.String))))
{
return info;
}
return null;
} public SScoreInfo GetInfoByName(String userName)
{
SScoreInfo info = new SScoreInfo();
string sql = " SELECT * FROM " + info.TableName + " WHERE UserName=@UserName" ;
if (info.ImportByReader(dh.ExecuteReader(sql, new DataParameter(userName, "UserName", DbType.String))))
{
return info;
}
return null;
} public bool IsExistByPrimeKey(string id)
{
SScoreInfo SScoreInfo = new SScoreInfo();
string wherefield = " AND " + SScoreInfo.PrimeKeyName + "=@" + SScoreInfo.PrimeKeyName;
DataParameter dp = new DataParameter(id, SScoreInfo.PrimeKeyName, DbType.String);
return 0 != dh.PageByCount(SScoreInfo.TableName, wherefield, dp);
}
public DataTable GetPageTableBySearch(int pageSize, int pageIndex, params string[] fields)
{
SScoreInfo iInfo = new SScoreInfo();
return dh.PageByTable(iInfo.TableName, BuildWhere(fields), pageSize, pageIndex, "*", this.OrderField);
} public DataTable GetTableByGroupName(string groupname)
{ return dh.ExecuteTable("Select * from SScore");
}
public SScoreInfo GetInfoByPrimeKey(string id)
{
SScoreInfo info = new SScoreInfo(); //实例化一个实体
string sql = " SELECT * FROM " + info.TableName + " WHERE " + info.PrimeKeyName + "=@" + info.PrimeKeyName; //info.TableName 表名 就是拼接SQL 语句 select * from table where PrimeKeyName=
if (info.ImportByReader(dh.ExecuteReader(sql, new DataParameter(id, info.PrimeKeyName, DbType.String)))) //给参数赋值 调用共通的方法。
{
return info; //如果有内容返回
}
return null; //没有返回NULL
}