/// <summary>
/// 根据条件查询表
/// </summary>
/// <param name="dbHelper">数据库帮助类</param>
/// <param name="tableStructure">表结构</param>
/// <param name="fieldName">条件筛选的字段</param>
/// <param name="fieldValue">条件筛选的字段值，可空</param>
/// <param name="orderbyString">排序语句，此值为null时根据UPDATEDATE排序</param>
/// <returns></returns>
public static DataTable QueryTable(DbHelper dbHelper, TableStructure tableStructure, string fieldName, string fieldValue, string orderbyString)
{
FieldClass fieldClass = tableStructure.Fields.FirstOrDefault(v => v.Name == fieldName);
return(QueryTable(dbHelper, tableStructure, fieldClass, fieldValue, orderbyString));
}
/// <summary>
/// 根据条件查询表
/// </summary>
/// <param name="dbHelper">数据库帮助类</param>
/// <param name="tableStructure">表结构</param>
/// <param name="fieldClass">条件筛选的字段</param>
/// <param name="fieldValue">条件筛选的字段值，可空</param>
/// <param name="orderByString">排序语句，此值为null时根据UPDATEDATE排序</param>
/// <returns></returns>
public static DataTable QueryTable(DbHelper dbHelper, TableStructure tableStructure, FieldClass fieldClass, string fieldValue, string orderByString)
{
string whereClause = null;
if (!string.IsNullOrEmpty(fieldValue))
{
if (fieldClass.FieldType == typeof(string))
{
whereClause = $"{fieldClass.Name} like '%{fieldValue}%'";
}
else if (fieldClass.FieldType == typeof(DateTime))
{
whereClause = $"{fieldClass.Name} = #{fieldValue}#";
}
else
{
whereClause = $"{fieldClass.Name} = {fieldValue}";
}
}
return(QueryTable(dbHelper, tableStructure, whereClause, orderByString));
}
/// <summary>
/// 向表结构中添加字段信息
/// </summary>
/// <param name="fieldClass"></param>
public void AddField(FieldClass fieldClass)
{
this.Fields.Add(fieldClass);
}