/// <summary>
/// 获取某一个类型的所有记录；
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public static DataTable GetAllDataTable <T>()
{
TableAttribute tba = GetTableAttribute <T>();
string sqlcmd = "select * from [";
string tablename = tba.TableName;
sqlcmd += tablename + "]";
bool iscache = tba.IsCahche;
DataTable dt = GetTableByName(tablename);
if (dt != null)
{
return(dt);
}
else
{
dt = IDataSourceTypeFactory.Create().ExecuteTable(sqlcmd);
if (dt != null && tba.IsCahche)
{
dt.TableName = tablename;
Cache.Add(dt);
return(dt);
}
return(null);
}
}
/// <summary>
/// 根据实体对象和IDataSourceType对象删除一条记录，
/// 该实体必须明确主键值才能删除记录；如果该实体没有主键可自己编写SQL代码删除；
/// </summary>
/// <typeparam name="T">要删除的表对应的实体对象</typeparam>
/// <param name="t">Model实体</param>
/// <param name="idatasource">IDataSourceType数据源类型对象</param>
/// <returns>删除是否成功；1成功，0失败</returns>
public static int DeleteModelById <T>(T t, IDataSourceType idatasource) where T : new()
{
string sqlstring; //保存要执行的T-SQL语句
List <IDataParameter> paramlist = (List <IDataParameter>)GetDeleteModelParameterT_SQL <T>(t, out sqlstring); //获取利用Model删除时的语句和参数列表
if (idatasource != null)
{
return(IDataSourceTypeFactory.Create().ExecuteNonQuery(CommandType.Text, sqlstring, paramlist.ToArray()));
}
return(IDataSourceTypeFactory.Create().ExecuteNonQuery(CommandType.Text, sqlstring, paramlist.ToArray()));
}
public static int InsertModelId <T>(T t, IDataSourceType idatasource) where T : new()
{
string sqlstring = string.Empty;
List <IDataParameter> parame = (List <IDataParameter>)GetInsertModelParameterT_SQL <T>(t, out sqlstring);
if (idatasource != null)
{
return((int)idatasource.ExecuteScalar(CommandType.Text, sqlstring, parame.ToArray()));
}
return((int)IDataSourceTypeFactory.Create().ExecuteScalar(CommandType.Text, sqlstring, parame.ToArray()));
}
public static DataTable GetNumDataTable <T>(string Where, int num)
{
TableAttribute tba = GetTableAttribute <T>();
string sqlcmd = "select TOP " + num.ToString() + " * from [";
string tablename = tba.TableName;
sqlcmd += tablename + "] where ";
// sqlcmd += " where ";
sqlcmd += Where;
DataTable dt = new DataTable();
dt = IDataSourceTypeFactory.Create().ExecuteTable(sqlcmd);
if (dt != null)
{
return(dt);
}
return(null);
}
public static int ExeSql(string SqlCmd)
{
return(IDataSourceTypeFactory.Create().ExecuteNonQuery(SqlCmd));
}