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);
}
}
