/// <summary>
/// 填写应用程序更新记录表
/// </summary>
/// <param name="fileName"></param>
private void ModifyRecordFile(string writeFile, string readFile)
{
//TODO:程序修改应用更新记录表文件
//从本地的修改列表文件读取内容
//写入需要更新的文件末尾
//excel文件的读写操作
ExcelOperator excel = new ExcelOperator();
excel.ReadFilePath = readFile;
excel.WriteFilePath = writeFile;
excel.CopyData();
}
/// <summary>
///
/// </summary>
/// <returns></returns>
private IList <string> ExtractCodeFiles()
{
ExcelOperator excelOp = new ExcelOperator();
excelOp.ReadFilePath = base.RecordLocalPath;
DataTable dtbJava = excelOp.ReadJava();
DataTable dtbUi = excelOp.ReadUI();
IList <string> relativePath = new List <string>();
string fullPath = null;
string path = null;
string name = null;
char[] pathSplit = @"\/".ToCharArray();
if (dtbJava != null && dtbJava.Rows.Count > 0)
{
//获得java文件的完整路径
foreach (DataRow dr in dtbJava.Rows)
{
path = dr[ExcelOperator.JAVA_PATH_COLUMN].ToString();
name = dr[ExcelOperator.JAVA_FILENAME_COLUMN].ToString();
if (string.IsNullOrEmpty(path) || string.IsNullOrEmpty(name))
{
continue;
}
fullPath = path.Trim(pathSplit) + @"\" + name;
relativePath.Add(fullPath);
}
}
if (dtbUi != null && dtbUi.Rows.Count > 0)
{
//获得UI文件的完整路径
foreach (DataRow dr in dtbUi.Rows)
{
path = dr[ExcelOperator.UI_PATH_COLUMN].ToString();
name = dr[ExcelOperator.UI_FILENAME_COLUMN].ToString();
if (string.IsNullOrEmpty(path) || string.IsNullOrEmpty(name))
{
continue;
}
fullPath = path.Trim(pathSplit) + @"\" + name;
relativePath.Add(fullPath);
}
}
return(relativePath);
}
/// <summary>
/// 抽取SQL类型的数据文件列表
/// </summary>
/// <returns></returns>
private IList <string> ExtractSqlFiles()
{
ExcelOperator excelOp = new ExcelOperator();
excelOp.ReadFilePath = base.RecordLocalPath;
DataTable dtb = excelOp.ReadSQL();
IList <string> relativePath = new List <string>();
string fullPath = null;
string name = null;
foreach (DataRow dr in dtb.Rows)
{
name = dr[ExcelOperator.SQL_FILENAME_COLUMN].ToString();
if (string.IsNullOrEmpty(name))
{
continue;
}
fullPath = this.SqlDocLocalFolder.TrimEnd(pathSplit) + @"\" + name;
relativePath.Add(fullPath);
}
return(relativePath);
}
