/// <summary> /// 获取任务文件列表 /// </summary> /// <param name="block"></param> /// <param name="blockstatus"></param> /// <param name="starttime"></param> /// <param name="msg"></param> /// <returns></returns> public static DataTable getTaskList(string block, out int blockstatus, out DateTime starttime, out string msg) { Trans.Db.Model.NBlock_Info BlockInfo = Trans.Db.Data.NBlock_Info.Get("BlockCode=@Block", "", new object[] { block }, true); if (BlockInfo.BlockCode != block) { starttime = new DateTime(1900, 1, 1); blockstatus = -1; msg = ""; return(null); } starttime = BlockInfo.StartTime; blockstatus = BlockInfo.Status; msg = ""; if (BlockInfo.UploadSuccess.Year > 2000) { msg = msg + "上传完成于:" + BlockInfo.UploadSuccess.ToString("HH:mm:ss") + "<br/>"; } if (BlockInfo.BackupSuccess.Year > 2000) { msg = msg + "备份完成于:" + BlockInfo.BackupSuccess.ToString("HH:mm:ss") + "<br/>"; } if (BlockInfo.CoverSuccess.Year > 2000) { msg = msg + "覆盖完成于:" + BlockInfo.CoverSuccess.ToString("HH:mm:ss") + "<br/>"; } if (BlockInfo.CancelTime.Year > 2000) { msg = msg + "用户取消于:" + BlockInfo.CancelTime.ToString("HH:mm:ss") + "<br/>"; } if (BlockInfo.ErrorFinishTime.Year > 2000) { msg = msg + "出错取消于:" + BlockInfo.ErrorFinishTime.ToString("HH:mm:ss") + "<br/>"; } return(Trans.Db.Data.NBlock_Info.GetTable("BlockCode=@Block", "RowId ASC", "*", new object[] { block }, true)); }
public bool RollBackSite() { try { //Trans.DataLayer.Model.Block BlockInfo = UploadTrace.GetBlockInfo(this.block); Trans.Db.Model.NBlock_Info BlockInfo = Trans.Db.Data.NBlock_Info.Get("BlockCode=@BlockCode", "", new object[] { this.block }, true); //string VMark = BlockInfo.VMark; string VMark = BlockInfo.ActionMark; this._BackupBlock = VMark; string name = this.SiteObj.SiteBaseInfo.NAME; DataTable rollBackTaskList = UploadTrace.getRollBackTaskList(this.block); List <TaskFileInfo> list = new List <TaskFileInfo>(); foreach (DataRow dataRow in (InternalDataCollectionBase)rollBackTaskList.Rows) { string SrcPath = dataRow["FilePath"].ToString().Replace("..", ""); string AimPath = dataRow["FilePath"].ToString(); list.Add(new TaskFileInfo(SrcPath, AimPath)); } int count = this.SiteObj.SiteBaseInfo.SERVLIST.Count; int num = 1; foreach (WebSiteServer ServObj in this.SiteObj.SiteBaseInfo.SERVLIST) { string serverstatus = num.ToString() + "/" + count.ToString(); foreach (TaskFileInfo FileObj in list) { if (this._coverErrorServer == null)// || !(FileObj.FileName == this._coverErrorFile.FileName) || !(ServObj.NAME == this._coverErrorServer.NAME)) { this.RollbackServ(ServObj, FileObj, name, this.block, serverstatus); } else { return(false); } } ++num; } return(true); } catch { return(false); } }
/// <summary> /// 获取任务文件列表 /// </summary> /// <param name="block"></param> /// <param name="blockstatus"></param> /// <param name="starttime"></param> /// <param name="msg"></param> /// <returns></returns> public static DataTable getTaskList(string block, out int blockstatus, out DateTime starttime, out string msg) { // blockstatus = -1; // msg = ""; // starttime = new DateTime(1900, 1, 1); // string cmdText = "select * from Block(nolock) where VAL=@block order by ID asc"; // SqlConnection connection1 = new SqlConnection(UploadTrace.ConnString); // msg = ""; // connection1.Open(); // SqlCommand sqlCommand = new SqlCommand(cmdText, connection1); // sqlCommand.Parameters.Add(new SqlParameter("@block", (object)block)); // DateTime result1 = new DateTime(1900, 1, 1); // DateTime result2 = new DateTime(1900, 1, 1); // DateTime result3 = new DateTime(1900, 1, 1); // DateTime result4 = new DateTime(1900, 1, 1); // DateTime result5 = new DateTime(1900, 1, 1); // SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); // if (sqlDataReader.Read()) // { // int.TryParse(sqlDataReader["status"].ToString(), out blockstatus); // DateTime.TryParse(sqlDataReader["StartTime"].ToString(), out starttime); // DateTime.TryParse(sqlDataReader["UploadSuccess"].ToString(), out result1); // DateTime.TryParse(sqlDataReader["BackupSuccess"].ToString(), out result2); // DateTime.TryParse(sqlDataReader["CoverSuccess"].ToString(), out result3); // DateTime.TryParse(sqlDataReader["CancelTime"].ToString(), out result4); // DateTime.TryParse(sqlDataReader["ErrorFinishTime"].ToString(), out result5); // if (result1.Year > 2000) // msg = msg + "上传完成于:" + result1.ToString("HH:mm:ss") + "<br/>"; // if (result2.Year > 2000) // msg = msg + "备份完成于:" + result2.ToString("HH:mm:ss") + "<br/>"; // if (result3.Year > 2000) // msg = msg + "覆盖完成于:" + result3.ToString("HH:mm:ss") + "<br/>"; // if (result4.Year > 2000) // msg = msg + "用户取消于:" + result4.ToString("HH:mm:ss") + "<br/>"; // if (result5.Year > 2000) // msg = msg + "出错取消于:" + result5.ToString("HH:mm:ss") + "<br/>"; // connection1.Close(); // DataTable dataTable = new DataTable(); // SqlConnection connection2 = new SqlConnection(UploadTrace.ConnString); // connection2.Open(); // SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(new SqlCommand("select * from BlockTaskList(nolock) where Block=@block order by RowID asc", connection2) // { // Parameters = { // new SqlParameter("@block", (object) block) //} // }); // DataSet dataSet = new DataSet(); // ((DataAdapter)sqlDataAdapter).Fill(dataSet); // connection2.Close(); // return dataSet.Tables[0]; // } // else // { // connection1.Close(); // return (DataTable)null; // } blockstatus = -1; Trans.Db.Model.NBlock_Info BlockInfo = Trans.Db.Data.NBlock_Info.Get("BlockCode=@Block", "", new object[] { block }, true); if (BlockInfo.BlockCode != block) { starttime = new DateTime(1900, 1, 1); blockstatus = -1; msg = ""; return(null); } starttime = BlockInfo.StartTime; blockstatus = BlockInfo.Status; msg = ""; if (BlockInfo.UploadSuccess.Year > 2000) { msg = msg + "上传完成于:" + BlockInfo.UploadSuccess.ToString("HH:mm:ss") + "<br/>"; } if (BlockInfo.BackupSuccess.Year > 2000) { msg = msg + "备份完成于:" + BlockInfo.BackupSuccess.ToString("HH:mm:ss") + "<br/>"; } if (BlockInfo.CoverSuccess.Year > 2000) { msg = msg + "覆盖完成于:" + BlockInfo.CoverSuccess.ToString("HH:mm:ss") + "<br/>"; } if (BlockInfo.CancelTime.Year > 2000) { msg = msg + "用户取消于:" + BlockInfo.CancelTime.ToString("HH:mm:ss") + "<br/>"; } if (BlockInfo.ErrorFinishTime.Year > 2000) { msg = msg + "出错取消于:" + BlockInfo.ErrorFinishTime.ToString("HH:mm:ss") + "<br/>"; } return(Trans.Db.Data.NBlock_Task.GetTable("BlockCode=@Block", "ID ASC", "*", new object[] { block }, true)); }