//public int AddWorkLogs(RLib.DB.DbConn dbconn, DateTime date, List<Model.TaskWorkLog> models) //{ // if (models == null || models.Count == 0) // return 0; // string sql = "insert into " + Pub.BuildWTbName(date) + "(taskid,nodeid,dispatchid,logtype,logtext,servertime) values "; // string vt = " (@taskid_{0},@nodeid_{0},@dispatchid_{0},@logtype_{0},@logtext_{0},@servertime_{0})"; // List<string> valsql = new List<string>(); // List<RLib.DB.ProcedureParameter> paras = new List<RLib.DB.ProcedureParameter>(); // for (int i = 0; i < models.Count; i++) // { // valsql.Add(string.Format(vt, i)); // paras.Add(new RLib.DB.ProcedureParameter("@taskid_" + i, models[i].TaskId)); // paras.Add(new RLib.DB.ProcedureParameter("@nodeid_" + i, models[i].NodeId)); // paras.Add(new RLib.DB.ProcedureParameter("@dispatchid_" + i, models[i].DispatchId ?? "")); // paras.Add(new RLib.DB.ProcedureParameter("@logtype_" + i, models[i].LogType)); // paras.Add(new RLib.DB.ProcedureParameter("@logtext_" + i, models[i].LogText ?? "")); // paras.Add(new RLib.DB.ProcedureParameter("@servertime_" + i, models[i].ServerTime)); // } // string insqlsql = sql + string.Join(",", valsql); // int r = dbconn.ExecuteSql(insqlsql, paras); // return r; //} public int AddWorkLogs(RLib.DB.DbConn dbconn, DateTime date, List <Model.TaskWorkLog> models) { var tbname = Pub.BuildWTbName(date); if (models == null || models.Count == 0) { return(0); } //区分大小写 System.Data.DataTable tb = new System.Data.DataTable(tbname); tb.Columns.Add("taskId"); tb.Columns.Add("nodeId"); tb.Columns.Add("dispatchId"); tb.Columns.Add("logType"); tb.Columns.Add("logText"); tb.Columns.Add("serverTime"); foreach (var a in models) { tb.Rows.Add( a.TaskId, a.NodeId, a.DispatchId ?? "", a.LogType, a.LogText, a.ServerTime ); } dbconn.BuckCopy(tb, null, null); return(models.Count); }