/// <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(""); } }