/// <summary>
/// 执行合并
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OK_Click(object sender, RoutedEventArgs e)
{
///list<object> 转换成正确类型
IList <FileNameCustom> currencies = model.FileNameCustoms;
model.SetPaths(currencies);
int count = model.FileNameCustoms.Count;
for (int a = 0; a < count; a++)
{
FileNameCustom custom = model.FileNameCustoms[a];
if (!Utils.CheckFileExists(custom.FilePath))
{
model.FileNameCustoms.RemoveAt(a);
a--;
count--;
}
}
MyAction myAction = new MyAction(new Action(() =>
{
ExcelWrite.MergeExcel(model);
}), "合并表格", "完成");
CommHelper.FastTask(myAction);
SoftwareConfig.SaveRedis(ExcelMergeModel.RedisKey, model);
}
private void OK_Click(object sender, RoutedEventArgs e)
{
bool? isCopy = IsCopyRadio.IsChecked;
string tem;
if (isCopy.Value)
{
tem = "复制";
}
else
{
tem = "更名或者移动";
}
int successCount = 0;
int falseCount = 0;
var fileReplaceNameModels = filePagerPage.GetAllList <FileReplaceNameModel>();
if (fileReplaceNameModels.Count > 0)
{
if (MessageBoxCustom.MessageBoxShow("你将" + tem + fileReplaceNameModels.Count + " 个文件"))
{
foreach (FileReplaceNameModel model in fileReplaceNameModels)
{
WaitFormCustom.ShowCustom();
string path = model.FilePath;
string saveName = model.NewFileName;
string saveDir = Path.GetDirectoryName(saveName);
if (saveDir == "")
{
model.Success = false;
continue;
}
if (!Utils.CheckDirExists(saveDir))
{
Directory.CreateDirectory(saveDir);
}
if (Utils.CheckFileExists(path))
{
if (isCopy.Value)
{
File.Copy(path, saveName, true);
}
else
{
File.Move(path, saveName);
}
successCount++;
model.Success = true;
}
else
{
model.Success = false;
falseCount++;
}
}
WaitFormCustom.CloseWaitForm("成功：" + successCount + " 个文件,失败：" + falseCount + " 个文件");
}
}
}
/// <summary>
/// 替换word中的内容
/// </summary>
/// <param name="replaceViewModels"></param>
/// <param name="fileNameCustom"></param>
public static void ReplaceText(IList <ReplaceViewModel> replaceViewModels, FileNameCustom fileNameCustom)
{
string path = fileNameCustom.FilePath;
if (Utils.CheckFileExists(path))
{
Document doc = new Document(path);
ReplaceText(replaceViewModels, doc);
doc.Save(path);
}
}
private void AddExcelFile_Click(object sender, RoutedEventArgs e)
{
string path = FileUtils.SelectSingleExcelFile();
if (Utils.CheckFileExists(path))
{
IList <string> paths = SheetToList(path);
if (paths != null)
{
AddFile(paths);
}
}
}
private void OpenExcel_Click(object sender, RoutedEventArgs e)
{
string path = FileUtils.SelectSingleExcelFile();
if (Utils.CheckFileExists(path))
{
Dictionary <string, string> dic = SheetToDic(path);
if (dic != null)
{
IList <FileReplaceNameModel> fileReplaceNameModels = new List <FileReplaceNameModel>();
foreach (string srcPath in dic.Keys)
{
FileReplaceNameModel model = new FileReplaceNameModel {
FilePath = srcPath, NewFileName = dic[srcPath]
};
fileReplaceNameModels.Add(model);
}
filePagerPage.AddObject(fileReplaceNameModels);
}
}
}
/// <summary>
/// 内容，1为开始，2为包含，3结束，4相等,不填为相等
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SelectRepalceFile_Click(object sender, RoutedEventArgs e)
{
IList <string> paths = FileUtils.SelectExcelFiles();
if (Utils.CheckListExists(paths))
{
IList <ReplaceViewModel> list = new List <ReplaceViewModel>();
foreach (string path in paths)
{
if (Utils.CheckFileExists(path))
{
ISheet sheet = ExcelRead.ReadExcelSheet(path, 0);
foreach (IRow row in sheet)
{
var replaceModel = new ReplaceViewModel();
for (int a = 0; a < 3; a++)
{
ICell cell = row.GetCell(a);
if (cell == null || cell.CellType == CellType.Blank)
{
if (a == 3)
{
cell = row.CreateCell(a);
cell.SetCellValue(4);
}
break;
}
cell.SetCellType(CellType.String);
string value = cell.StringCellValue;
switch (a)
{
case 0:
replaceModel.OldText = value;
break;
case 1:
replaceModel.NewText = value;
break;
case 2:
int gx;
if (int.TryParse(value, out gx))
{
switch (gx)
{
case 0:
replaceModel.StrRelation = MyUtils.StrRelation.StartsWith;
break;
case 1:
replaceModel.StrRelation = MyUtils.StrRelation.Contains;
break;
case 2:
replaceModel.StrRelation = MyUtils.StrRelation.EndsWith;
break;
case 3:
replaceModel.StrRelation = MyUtils.StrRelation.Equals;
break;
}
}
else
{
replaceModel.StrRelation = MyUtils.StrRelation.Equals;
}
break;
}
}
list.Add(replaceModel);
}
}
}
replacePagerPage.AddObject(list);
}
}