public static List<data> FindData(FindDataEntity entity)
{
List<data> result = new List<data>();
string sql = string.Format("SELECT TOP 10 * FROM [{0}] ", entity.TableName);
List<SqlParameter> parasList = new List<SqlParameter>();
if (entity.FilterItems != null && entity.FilterItems.Count > 0)
{
string whereStr = string.Empty;
for (int i = 0; i < entity.FilterItems.Count; i++)
{
if (i == 0)
{
whereStr += string.Format(" [{0}] =@{0}", entity.FilterItems[i].Name);
}
else
{
whereStr += string.Format(" AND [{0}] = @{0}", entity.FilterItems[i].Name);
}
parasList.Add(new SqlParameter("@" + entity.FilterItems[i].Name, entity.FilterItems[i].Value));
}
sql += " WHERE " + whereStr;
}
DataSet ds = SQLHelper.ExecuteQuery(GetConnection(), CommandType.Text, sql, parasList.ToArray());
if (ds.Tables.Count > 0)
{
DataTable table = ds.Tables[0];
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow dr = table.Rows[i];
data dataItem = new data();
List<dataItem> items = new List<dataItem>();
for (int j = 0; j < table.Columns.Count; j++)
{
dataItem item = new dataItem();
item.name = table.Columns[j].ColumnName;
item.value = dr[j].ToString();
items.Add(item);
}
dataItem.items = items;
result.Add(dataItem);
}
}
return result;
}
public SyncResult FindData(FindDataEntity entity)
{
SyncResult result = new SyncResult();
try
{
result.result = 1;
result.datas = SQLHelper.FindData(entity);
}
catch (Exception ex)
{
result.result = 0;
result.message = ex.ToString();
}
return result;
}