/// <summary>
/// 获取单行数据
/// </summary>
/// <param name="ItemID"></param>
/// <returns></returns>
public string GetDataView(string ItemID)
{
var TableModel = this.GetTableModel();
if (TableModel.TableType == 1)//表格数据
{
string sql = string.Format("SELECT TOP(1)* FROM ({0}) AS NewCyFsTable WHERE NewCyFsTable.{1}='{2}'", TableModel.SQL, TableModel.PrimaryKey, ItemID);
System.Data.DataTable tableJson = DAL.SQLDBHelpercs.ExecuteReaderTable(sql, null);
if (tableJson != null && tableJson.Rows.Count > 0)
{
return(JsonHelper.DataTableToJsonWithJsonNet(tableJson));
}
else
{
return("");
}
}
else if (TableModel.TableType == 2)//XML数据
{
var TableFielModelList = this.GetTableFieldModel();
System.Data.DataTable dataTable = BaseClass.GetDataTableColumns(TableModel.SQL);
var tableJson = BaseClass.GetDataViewForXML(dataTable, TableModel.TableName, ItemID);
if (tableJson != null && tableJson.Rows.Count > 0)
{
return(JsonHelper.DataTableToJsonWithJsonNet(tableJson));
}
else
{
return("");
}
}
else
{
return("");
}
}
