/// <summary>
/// 执行查询返回DataSet
/// </summary>
/// <param name="TableName">表名</param>
/// <param name="ConditionForSelect">自定义条件</param>
/// <param name="PageIndex">页索引号</param>
/// <returns>Dataset</returns>
public DataSet GetDSQuery(string TableName, SQLCondition ConditionForSelect, params string[] FieldNames)
{
int MaxCount = 0;
DataHelper dh = new DataHelper(_DataBaseName);
return(GetDSQuery(dh, TableName, ConditionForSelect != null ? ConditionForSelect.ToString(dh) : string.Empty, -1, -1, ref MaxCount, FieldNames));
}
/// <summary>
/// 执行CheckExist命令
/// </summary>
/// <param name="FiledName">字段名称</param>
/// <param name="FileValue">值</param>
/// <param name="conditionForCheckExist">自定义条件</param>
/// <returns></returns>
public int DoCheckExist(SQLCondition conditionForCheckExist)
{
try
{
DataHelper dh = new DataHelper(this.DatabaseName);
DbCommand Command = this.GetCheckExistCommand(dh, conditionForCheckExist.ToString(dh));
return(Convert.ToInt32(dh.ExecuteScalar(Command)));
}
catch (Exception exp)
{
//Logging.SaveLog(ELogType.ORM, exp, string.Empty);
throw exp;
}
}
/// <summary>
/// 执行Delete命令
/// </summary>
/// <param name="EntityInstance">实体对象实例</param>
/// <param name="conditionForUpdate">SQLCondition实例</param>
/// <returns>受影响的行数</returns>
public int DoDelete(BaseEntity EntityInstance, SQLCondition conditionForUpdate)
{
if (conditionForUpdate == null)
{
return(DoDelete(EntityInstance, string.Empty));
}
try
{
DataHelper dh = new DataHelper(this.DatabaseName);
MySqlCommand Command = this.GenerateDeleteCommand(dh, EntityInstance, conditionForUpdate.ToString(dh));
return(dh.ExecuteNonQuery(Command));
}
catch (Exception exp)
{
//Logging.SaveLog(ELogType.ORM, exp, string.Empty);
throw exp;
}
}
/// <summary>
/// 执行查询返回DataSet
/// </summary>
/// <param name="TableName">表名</param>
/// <param name="ConditionForSelect">自定义条件</param>
/// <param name="PageSize">页行数</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="FieldNames">自定义字段</param>
/// <param name="FieldNames">自定义字段</param>
/// <returns>Dataset</returns>
public DataSet GetDSQuery(string TableName, SQLCondition ConditionForSelect, int PageIndex, int PageSize, ref int RecordCount, params string[] FieldNames)
{
DataHelper dh = new DataHelper(_DataBaseName);
return(GetDSQuery(dh, TableName, ConditionForSelect != null ? ConditionForSelect.ToString(dh) : string.Empty, PageIndex, PageSize, ref RecordCount, FieldNames));
}
/// <summary>
/// 执行查询返回首字段值
/// </summary>
/// <param name="TableName">表名</param>
/// <param name="ConditionForSelect">自定义条件</param>
/// <param name="FieldName">首字段</param>
/// <returns>值</returns>
public object ScalarQuery(string TableName, SQLCondition ConditionForSelect, string FieldName)
{
DataHelper dh = new DataHelper(_DataBaseName);
return(ScalarQuery(dh, TableName, ConditionForSelect != null ? ConditionForSelect.ToString(dh) : string.Empty, FieldName));
}
/// <summary>
/// 执行查询返回DataReader
/// </summary>
/// <param name="TableName">表名</param>
/// <param name="ConditionForSelect">自定义条件</param>
/// <param name="FieldNames">自定义字段</param>
/// <returns>DataReader</returns>
public IDataReader GetDRQuery(string TableName, SQLCondition ConditionForSelect, params string[] FieldNames)
{
DataHelper dh = new DataHelper(_DataBaseName);
return(GetDRQuery(dh, TableName, ConditionForSelect != null ? ConditionForSelect.ToString(dh) : string.Empty, FieldNames));
}
