static void Main(string[] args)
{
#region ChineseChar 小试
//string str = Console.ReadLine();
//var ch = str[0];
//Console.WriteLine($"汉字:{ch}");
//ChineseChar cc = new ChineseChar(ch);
//var pinyins = cc.Pinyins.ToList();
//pinyins.ForEach(p =>
//{
// Console.WriteLine($"拼音：{p}");
//});
#endregion
for (int i = 0; i < 10; i++)
{
Console.WriteLine("请输入中文：");
string str = Console.ReadLine();
var pingyins = PinYinConverterHelp.GetTotalPingYin(str);
Console.WriteLine("全拼音：" + String.Join(",", pingyins.TotalPingYin));
Console.WriteLine("首音：" + String.Join(",", pingyins.FirstPingYin));
Console.WriteLine();
}
}
static void Main(string[] args)
{
for (int i = 0; i < 10; i++)
{
Console.WriteLine("请输入中文：");
string str = Console.ReadLine();
var pingyins = PinYinConverterHelp.GetTotalPingYin(str);
Console.WriteLine("全拼音：" + String.Join(",", pingyins.TotalPingYin));
Console.WriteLine("首音：" + String.Join(",", pingyins.FirstPingYin));
Console.WriteLine();
}
}
public void GenerateEmptyKey()
{
if (!option.generateEmptyKey)
{
return;
}
string patt = @"[^A-Za-z0-9_\u4e00-\u9fa5]";
for (int i = 0; i < dataList.Count; i++)
{
Dictionary <string, string> rowData = dataList[i];
if (string.IsNullOrEmpty(rowData[option.keyField]))
{
string txt = "KEY_" + rowData[option.idField] + "_";
string str;
if (!string.IsNullOrEmpty(option.txtModuleField) && !string.IsNullOrEmpty(rowData[option.txtModuleField]))
{
str = rowData[option.txtModuleField];
str = Regex.Replace(str, patt, string.Empty);
str = PinYinConverterHelp.GetFullPing(str, string.Empty);
txt += str + "__";
}
str = rowData[option.txtNameField];
str = Regex.Replace(str, patt, string.Empty);
if (str.Length < 8)
{
str = PinYinConverterHelp.GetFullPing(str, string.Empty);
txt += str;
}
else
{
txt += PinYinConverterHelp.GetFullPing(str.Substring(0, 4), string.Empty) + "__" + PinYinConverterHelp.GetFullPing(str.Substring(str.Length - 4, 4), string.Empty);
}
rowData[option.keyField] = txt;
isChangKey = true;
//Console.WriteLine();
//Console.WriteLine(rowData[option.txtNameField]);
//Console.WriteLine(txt);
}
}
}
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);
}
