private void GetUrlDict(Match m, ref string url, string nextPageText, List <string> levelUrlList, string startPos, string endPos, OnEnqueueUrls enqueueUrl)
{
string str = m.Value.Substring(5);//去除dict:
if (!string.IsNullOrEmpty(str))
{
string errMsg = string.Empty;
DictList dictList = XmlHelper.LoadFromXml <DictList>(Program.GetConfigPath(@"dict.xml"), ref errMsg);
Dict dictEntity = dictList.Where(q => q.CategoryName.Value == str).FirstOrDefault();
if (dictEntity.DictItemList == null || dictEntity.DictItemList.Count == 0)
{
string tempUrl0 = url.Substring(0, m.Index - 1);
string tempCode = "";
string tempUrl1 = string.Empty;
int lastIndex = m.Index + m.Length + 1;
if (url.Length > lastIndex)
{
tempUrl1 = url.Substring(lastIndex);
}
string tempUrl = tempUrl0 + tempCode + tempUrl1;
url = GetMatchUrl(tempUrl, nextPageText, levelUrlList, startPos, endPos, enqueueUrl);
if (_GatherUrlItemSingleFlag)
{
return;
}
enqueueUrl(url, nextPageText, levelUrlList, startPos, endPos);
}
else
{
string tempUrl0 = url.Substring(0, m.Index - 1);
string tempUrl1 = string.Empty;
int index = 1;
foreach (var item in dictEntity.DictItemList)
{
string tempCode = item.DictName.Value;
int lastIndex = m.Index + m.Length + 1;
if (url.Length > lastIndex)
{
tempUrl1 = url.Substring(lastIndex);
}
string tempUrl = tempUrl0 + tempCode + tempUrl1;
url = GetMatchUrl(tempUrl, nextPageText, levelUrlList, startPos, endPos, enqueueUrl);
if (_GatherUrlItemSingleFlag)
{
return;
}
if (index == dictEntity.DictItemList.Count)
{
break;
}
enqueueUrl(url, nextPageText, levelUrlList, startPos, endPos);
index++;
}
}
}
}
public frmDict()
{
InitializeComponent();
string errMsg = string.Empty;
dictList = XmlHelper.LoadFromXml <DictList>(Program.GetConfigPath(@"dict.xml"), ref errMsg);
if (!string.IsNullOrEmpty(errMsg))
{
return;
}
foreach (var item in dictList)
{
TreeNode node = tvCategory.Nodes["tvDict"].Nodes.Add(item.CategoryName.Value);
node.ImageIndex = 14;
node.SelectedImageIndex = 15;
}
tvCategory.ExpandAll();
}
public IEnumerator <Step> StartStep(IEnumerator <Step> iEnumerator)
{
if (iEnumerator == null)
{
return(iEnumerator);
}
if (!iEnumerator.MoveNext())
{
return(iEnumerator);
}
if (mStepGroups == null)
{
mStepGroups = new DictList <IEnumerator <Step>, StepGroup>();
}
var newGroup = new StepGroup(iEnumerator);
if (!newGroup.Run())
{
mStepGroups.Add(iEnumerator, newGroup);
}
return(iEnumerator);
}
public void ReadFile(XFileInfo fileinfo)
{
string path_excel = fileinfo.Name;
var time_start = DateTime.Now;
if (File.Exists(path_excel))
{
FileStream fsExcel = File.OpenRead(path_excel);
IWorkbook wk = new XSSFWorkbook(fsExcel);
int stcount = wk.NumberOfSheets;
for (int stc = 0; stc < stcount; stc++)
{
ISheet sheet = wk.GetSheetAt(stc);
string sheetName = sheet.SheetName;
string[] nodes = sheetName.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
string pagename = sheet.SheetName;
string pagenamecn = sheet.SheetName;
if (nodes.Length >= 2)
{
pagename = nodes[1];
pagenamecn = nodes[0];
}
var page = new PageInfo(pagename);
page.NameCn = pagenamecn;
page.NameFile = Path.GetFileName(path_excel);
page.ValidType = fileinfo.ValidType;
IRow rowHeadC = sheet.GetRow(1);
if (rowHeadC == null)
{
continue;
}
for (int k = 0; k <= rowHeadC.LastCellNum; k++)
{
ICell cell = rowHeadC.GetCell(k);
if (cell != null)
{
page.HeadC.Add(cell.ToString());
}
else
{
page.HeadC.Add("");
}
}
IRow rowHead = sheet.GetRow(2);
if (rowHead == null)
{
continue;
}
for (int k = 0; k <= rowHead.LastCellNum; k++)
{
ICell cell = rowHead.GetCell(k);
if (cell != null)
{
string strheadenum = cell.ToString();
string[] strheadenumnodes = strheadenum.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
if (strheadenumnodes.Length >= 2)
{
page.Head.Add(strheadenumnodes[0]);
page.HeadEnum.Add(strheadenumnodes[1]);
}
else
{
page.Head.Add(strheadenum);
page.HeadEnum.Add(strheadenum);
}
}
else
{
page.Head.Add("");
page.HeadEnum.Add("");
}
}
IRow rowTypeClient = sheet.GetRow(3);
if (rowTypeClient == null)
{
continue;
}
for (int k = 0; k <= page.Head.Count; k++)
{
ICell cell = rowTypeClient.GetCell(k);
if (cell != null)
{
string TypeClient = cell.ToString();
if (TypeClient == "float")
{
TypeClient = "double";
}
page.TypeClient.Add(TypeClient);
}
else
{
page.TypeClient.Add("");
}
}
IRow rowTypeServer = sheet.GetRow(4);
if (rowTypeServer == null)
{
continue;
}
for (int k = 0; k <= page.Head.Count; k++)
{
ICell cell = rowTypeServer.GetCell(k);
if (cell != null)
{
page.TypeServer.Add(cell.ToString());
}
else
{
page.TypeServer.Add("");
}
}
for (int j = 5; j <= sheet.LastRowNum; j++)
{
IRow row = sheet.GetRow(j);
if (row == null)
{
continue;
}
if (row.GetCell(0) == null)
{
continue;
}
if (row.GetCell(0).ToString() == "")
{
continue;
}
var listrowvalue = new List <string>();
for (int k = 0; k < page.Head.Count; k++)
{
ICell cell = row.GetCell(k);
string s_value = GetTextFromCell(cell);
if (s_value == "")
{
s_value = "0";
}
if (!string.IsNullOrEmpty(page.HeadEnum[k]))
{
if (DictListEnums.TryGetValue(page.HeadEnum[k], out var DictList))
{
if (DictList.ContainsKey(s_value))
{
s_value = DictList[s_value];
}
}
}
listrowvalue.Add(s_value);
}
page.ListValue.Add(listrowvalue);
}
if (page.IsLegal())
{
DictPages.Add(page.Name, page);
}
}
}
UpdateFileTs(fileinfo, DateTime.Now - time_start);
}
//支出类型
private void MI_ZhiChuType_Click(object sender, EventArgs e)
{
DictList frmDictList = new DictList("支出类型");
this.ShowMdiForm(frmDictList);
}
//信用卡管理
private void MI_XinYongKa(object sender, EventArgs e)
{
DictList frmDictList = new DictList("信用卡");
this.ShowMdiForm(frmDictList);
}
//银行卡管理
private void MI_BankCard_Click(object sender, EventArgs e)
{
DictList frmDictList = new DictList("银行卡");
this.ShowMdiForm(frmDictList);
}
