private void ReNameFields(Worksheet ws)
{
PrograssBar innerPbar = new PrograssBar();
innerPbar.BarLength = 10;
string strFieldEnglishTxt;
string strFieldTxt;
int iMax = 30;
for (int j = 1; j < 100; j++)
{
ws.Cells[2, j].Value = ws.Cells[1, j].Value;
strFieldTxt = ws.Cells[1, j].Value as string;
if (strFieldTxt != null)
{
strFieldTxt = strFieldTxt.Trim();
//fieldNames.Add(strFieldTxt);
if (fieldsDic.ContainsKey(strFieldTxt) == true)
{
fieldsDic.TryGetValue(strFieldTxt, out strFieldEnglishTxt);
ws.Cells[1, j].Value = strFieldEnglishTxt;
}
else
{
unTranslatedFields.Add(strFieldTxt);
//AddDic dc = new AddDic();
//dc.strHanzi = strFieldTxt;
//if (dc.ShowDialog()==DialogResult.OK)
//{
// strFieldEnglishTxt = dc.strEnglisTxt;
// ws.Cells[1, j].Value = strFieldEnglishTxt;
// /// 添加到字典中
// fieldsDic.Add(strFieldTxt, strFieldEnglishTxt);
//}
//else
//{
// MessageBox.Show(ws.Name + "字段：" + strFieldTxt + "没有翻译，请检查");
//}
}
////var strPinyinName = PinYinConverterHelp.GetTotalPingYin(strTabColName);
////strPinYinColName = strPinyinName.TotalPingYin.First<string>().ToUpper();
//ws.Cells[2, j].Value = strEnglishColName;
}
else
{
iMax = j;
break;
}
LB_TabColuProgress.Text = innerPbar.ProgressMsg("修改" + ws.Name + "表的字段", j, iMax);
}
}
private void BT_OpenFile_Click(object sender, EventArgs e)
{
//Console.WriteLine("全拼音：" + String.Join(",", pingyins.TotalPingYin));
// Console.WriteLine("首音：" + String.Join(",", pingyins.FirstPingYin));
List <string> sheetNames = new List <string>();
List <string> newSheetNamesList = new List <string>();
string strTabColName = string.Empty;
string strNewSheetName = string.Empty;
string strPinYinColName = string.Empty;
if (openFile.ShowDialog() == DialogResult.OK)
{
RegisterLib.PrograssBar prgBar = new PrograssBar();
prgBar.BarLength = 20;
//pb.Max
ExcelHelper helper = new ExcelHelper();
Worksheet ws;
foreach (var fileName in openFile.FileNames)
{
helper.OpenFile(fileName);
prgBar.MaxValue = helper.Sheets.Count;
for (int i = 0; i < helper.Sheets.Count; i++)
{
ws = helper.Sheets[i + 1] as Worksheet;
//if (ws.Name.Contains("表名对照")==true)
//{
// ws.Delete();
//}
sheetNames.Add(ws.Name);
LB_SheetNames.Items.Add(ws.Name);
LB_TotalProgress.Text = prgBar.ProgressMsg(string.Format("正在重命名sheet,第{0}个/总共{1}个", i + 1, helper.Sheets.Count), i, helper.Sheets.Count);
///获取新的sheet名称
var pingyins = PinYinConverterHelp.GetTotalPingYin(ws.Name);
strNewSheetName = pingyins.FirstPingYin.First <string>().ToUpper();
strNewSheetName = GetReNameRulsPrefix(ws.Name) + strNewSheetName;
if (newSheetNamesList.Contains(strNewSheetName))
{
strNewSheetName += i.ToString();
}
ws.Name = strNewSheetName;
newSheetNamesList.Add(ws.Name);
LB_NewSheetNames.Items.Add(ws.Name);
if (ws.Name.StartsWith("TB"))
{
///修改每个sheet的表名称为汉语拼音
ReNameFields(ws);
}
}
//File.WriteAllLines("D:\\Dic.txt", fieldNames.ToArray());
////将表明保存在excel中。
Worksheet newSheet = helper.Sheets.Add() as Worksheet;
try
{
if (newSheet != null)
{
newSheet.Name = "表名对照";
}
}
catch (Exception)
{
MessageBox.Show("表名对照保存为：" + newSheet.Name);
}
for (int x = 1; x < sheetNames.Count; x++)
{
newSheet.Cells[x, 1].Value = sheetNames[x - 1];
newSheet.Cells[x, 2].Value = newSheetNamesList[x - 1];
}
string newFile = fileName.Replace(".", "_OK.");
helper.SaveAsNewFile(newFile);// (fileName);
helper.WorkBook.Close();
helper.Excel.Quit();
MessageBox.Show("文件" + fileName + "改名完成");
//string[] sheetNames = ExcelHelper.GetSheetNames(fileName);
//LB_SheetNames.DataSource = sheetNames;
//LB_ReNamedSheetNames.DataSource = sheetReNames;
}
}
File.WriteAllLines(@"未翻译字段.txt", unTranslatedFields.ToArray(), Encoding.UTF8);
File.WriteAllLines(@"字典.txt", TB_DIC.Lines, Encoding.UTF8);
}
private static void InitializeComponets() {
PrograssBar.SimpleLoadingProcedure("Loading Components", 100, ConsoleColor.Red, ConsoleColor.Green, Console.BackgroundColor, Console.BackgroundColor, 1, 200);
}
private static void InitializeModules() {
PrograssBar.SimpleLoadingProcedure("Loading Modules", 100, ConsoleColor.White, ConsoleColor.White, Console.BackgroundColor, Console.BackgroundColor, 10, 500);
CORE.CoreControler.CreateNewStation();
EasyLogging.SimpleLog("SAM", "Loading Mopdules", "output", ConsoleColor.Yellow);
SAM.DATA.Station.PrintAllModuleInfo();
}
