07 2020 档案

摘要：using (var db = GetDbContext()) { using (var trans = db.Database.BeginTransaction()) { int i = 1; var RecordId = findings.Select(p => p.RecordId).Dist 阅读全文

摘要：C#连接并操作Oracle数据库 1.NuGet安装Oracle.ManagedDataAccess 2.引用using Oracle.ManagedDataAccess;using Oracle.ManagedDataAccess.Types;using Oracle.ManagedDataAcc 阅读全文

摘要：System.DateTime today = DateTime.Now.Date;string str = string.Empty;foreach (System.Data.DataRow dr in data.Rows){ string status = dr["Risk"].ToString 阅读全文

摘要：编程遇到一个问题四个类字段都是三十多个，其中有十多个是相同的，需要将一个类的字段赋值给另外一个类，开始是一个个赋值，写了几百行，后来同事提醒用反射 例子1: 1 public IEnumerable<MaintenanceRecord> getPMMaintenanceRecord2() //简化写 阅读全文

摘要：汇总列表中各物品的数量 var list = (from t in lst group t by t.SparePartNo into g select new { g.Key, sum = g.Sum(p => p.SparePartQty), Total = g.Count() }).ToLis 阅读全文