本文整理汇总了C#中System.Data.DataRow.Select方法的典型用法代码示例。如果您正苦于以下问题:C# DataRow.Select方法的具体用法?C# DataRow.Select怎么用?C# DataRow.Select使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataRow
的用法示例。
在下文中一共展示了DataRow.Select方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SavedRouteClass
public SavedRouteClass(DataRow dr, DataRow[] syslist)
{
this.Id = (long)dr["id"];
this.Name = (string)dr["name"];
if (dr["start"] != DBNull.Value)
this.StartDate = (DateTime?)dr["start"];
if (dr["end"] != DBNull.Value)
this.EndDate = (DateTime?)dr["end"];
this.Systems = syslist.Select(s => (string)s["systemname"]).ToList();
}
示例2: GenerateCheckReports
public void GenerateCheckReports(string gardenName, DateTime[] dates, Action notify)
{
var dt = new ClassesDataAccess().GetClassAndGrade();
var rows = new DataRow[dt.Rows.Count];
dt.Rows.CopyTo(rows, 0);
foreach (var date in dates)
{
KillProcess();
var dir = excelPath + @"report\成长记录报表\" + date.ToString("yyyy");
if (!Directory.Exists(dir))
Directory.CreateDirectory(dir);
var checkInDays = new UtilDataAccess().GetAttendDays(date, date.AddMonths(1).AddDays(-1));
var hierarchy = new GrowUpReportDataAccess().GetGrowUpCheckReports(rows.Select(r => r["info_className"].ToString()).ToArray(), date);
GenerateCheckReportsPersonByPerson(gardenName, hierarchy, checkInDays, date, dir, notify);
GenerateCheckReportsClassByClass(gardenName, hierarchy, checkInDays, date, dir, notify);
GenerateCheckReportsGradeByGrade(gardenName, hierarchy, checkInDays, date, dir, notify);
}
}
示例3: CreateSearchSql
/// <summary>
/// 生成查询语句
/// </summary>
/// <param name="conStr">数据库连接</param>
/// <param name="tableName">表名</param>
/// <param name="owner">表来源</param>
/// <param name="drs">数据</param>
/// <returns></returns>
public static string CreateSearchSql(string conStr, string tableName, string owner, DataRow[] drs)
{
if (drs.Length > 0)
{
//TableSchema st = new TableSchema(new DatabaseSchema(new SqlSchemaProvider(), conStr), tableName, owner, DateTime.MinValue);
DataTable st = new DBHelper(conStr).ExecuteTable(string.Format(ConfigurationSettings.AppSettings["ColumnSearchSql"], tableName));
return string.Format("select * from {0} where ({1})", tableName, string.Join(") or (", drs.Select(c => string.Join(" and ", st.AsEnumerable().Where(d => d["pk"].ToString() == "0").ToArray().Select(d => string.Format(" {0}='{1}' ", d["name"], c[d["name"].ToString()])).ToArray())).ToArray()));
}
else
return string.Empty;
}
示例4: ColumnNameToList
/// <summary>
/// Utility function used to transpose the DataRow array's returned
/// by calls to the ADO.NET functionality from PowerShell.
/// </summary>
/// <param name="adoData"></param>
/// <returns></returns>
public static List<string> ColumnNameToList(DataRow[] adoData)
{
var colNameList = new List<string>();
if(adoData== null || adoData.Length <= 0)
return colNameList;//empty list, match the ctor
colNameList.AddRange(
adoData.Select(dr => dr[Qry.Catalog.COLUMN_NAME].ToString())
.Where(colName => !string.IsNullOrWhiteSpace(colName)));
return colNameList;
}