using SqlSugar; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; using WCS_Client.Extensions; namespace WCS_Client.Workflow { /// /// 异常日志 /// public class ExceptionLogWorkflow { /// /// 为任务数据表新增列 /// /// 数据源 /// 数据库链接 public static void DataTableAddColumn(DataTable dataTable, SqlSugarClient db) { //新增列 string Continued = "Continued"; dataTable.addDataColumn(new List { Continued }); //开始时间&结束时间 string STARTTIME = "STARTTIME", UPDATETIME = "UPDATETIME"; //向新增列写入数据 for (int i = 0; i < dataTable.Rows.Count; i++) { dataTable.Rows[i][Continued] = Math.Round(((DateTime)dataTable.Rows[i][UPDATETIME] - (DateTime)dataTable.Rows[i][STARTTIME]).TotalMinutes, 2); dataTable.AcceptChanges(); } } } }