private void btn_apply_style_Click(object sender, RibbonControlEventArgs e) {//更新样式 try { MagazineStyle.GetInstance().Name = cb_style.Text; PublicVar.SetCurrentStyleJObject(); CommonFunction.RefreshStyle(); } catch (Exception ex) { LogHelper.WriteLog(typeof(BIMTRibbon), ex); } }
private void currentStyle_TextChanged(object sender, RibbonControlEventArgs e) { try { if (DialogResult.Yes == MessageBox.Show(null, "是否应用" + cb_style.Text + "的参考文献样式?", "切换样式", MessageBoxButtons.YesNo)) { MagazineStyle _style = MagazineStyle.GetInstance(); _style.Name = cb_style.Text; PublicVar.SetCurrentStyleJObject(); CommonFunction.RefreshStyle(); QuotationStyle style = new QuotationStyle(MagazineStyle.GetInstance().Name); style.WriteContent(); } } catch (Exception ex) { LogHelper.WriteLog(typeof(BIMTRibbon), ex); } }
static void Main(string[] args) { string OptionsPath = Environment.CurrentDirectory.ToString() + '/'; //1. ini 파일에서 접속정보 가져옴 PublicVar pVar = new PublicVar(OptionsPath); //2. DB에서 테이블 목록 가져옴 DataTable dt = new DBCon(pVar).SelectDB($@" SELECT DISTINCT A.[TABLE_NAME] '테이블명' FROM INFORMATION_SCHEMA.COLUMNS A ORDER BY '테이블명'", null); //3. 테이블 목록을 좌측 글자 기준으로 쪼갬 ex:LSTD, LSE 등 var tableNameList = (from DataRow dr in dt.Rows select dr[0].ToString()).ToList(); List <List <string> > splitList = new List <List <string> >(); var l = (from string s in tableNameList select s.Split('_')[0]).Distinct(); foreach (var item in l) { splitList.Add((from string s in l where s == item select s).ToList()); } DataSet ds = new DataSet("Tables"); DBCon dBCon = new DBCon(pVar); //테이블 이름별로 쿼리해서 저장 foreach (string name in tableNameList) { Console.WriteLine($"{name} 테이블 쿼리 중"); FillTables(dBCon, ref ds, name); } // 4, 5, 6, 엑셀 파일 만들고 쪼개고 저장하고 마무리 하는건 알아서 던지자. xsldoc.WorkThat(splitList, ds); }
/// <summary> /// 刷新样式列表 /// 2016-06-23 /// wuhailong /// </summary> public void RefreshStyleList() { try { cb_style.Items.Clear(); //下拉框赋值 List <string> _list = CommonFunction.GetFileName(PublicVar.StyleDir, "*.json"); List <string> _listEn = new List <string>(); List <string> _listCn = new List <string>(); //_listCn.Add("参考文献样式"); foreach (string item in _list) { if (CommonFunction.IsCnString(item)) { _listCn.Add(item); //RibbonFactory rf = Globals.Factory.GetRibbonFactory(); //RibbonDropDownItem di = rf.CreateRibbonDropDownItem(); //di.Label = item; //comboBox1.Items.Add(di); } else { _listEn.Add(item); } } _listCn.Sort(); string _strTemp = _listCn[0]; int _myCount = 0; for (int i = 0; i < _listCn.Count; i++) { if (_listCn[i] == "参考文献样式") { _myCount = i; break; } } _listCn[0] = "参考文献样式"; _listCn[_myCount] = _strTemp; foreach (string item in _listCn) { RibbonFactory rf = Globals.Factory.GetRibbonFactory(); RibbonDropDownItem di = rf.CreateRibbonDropDownItem(); di.Label = item; cb_style.Items.Add(di); } _listEn.Sort(); foreach (string item in _listEn) { RibbonFactory rf = Globals.Factory.GetRibbonFactory(); RibbonDropDownItem di = rf.CreateRibbonDropDownItem(); di.Label = item; cb_style.Items.Add(di); } PublicVar.SetCurrentStyleJObject(); } catch (Exception EX) { LogHelper.WriteLog(typeof(BIMTRibbon), EX); } }