/// <summary>
/// 根据字段名称获取字典
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public static Dictionary <string, string> GetDictionaryByName(string name)
{
if (name == null)
{
return(null);
}
Dictionary <string, string> dic = new Dictionary <string, string>();
if (CustomDictionary(name, ref dic))
{
return(dic);
}
CONSTCLSDal constclsDal = new CONSTCLSDal();
CONSTDal constDal = new CONSTDal();
CONSTCLS catalog = new CONSTCLS();
// 获取目录
catalog = constclsDal.GetModel(c => c.CONSTCLSNAME == name);
if (catalog == null)
{
return(null);
}
List <CONST> constList = new List <CONST>();
// 获取字典List
constList = constDal.GetListBy(c => c.CONSTSLSID == catalog.CONSTSLSID);
if (constList == null)
{
return(null);
}
foreach (var item in constList)
{
// 去掉重复键值
if (dic.ContainsKey(item.CONSTVALUE))
{
continue;
}
dic.Add(item.CONSTVALUE, item.CONSTTRANS);
}
// 字典排序
dic = dic.OrderBy(p => p.Key).ToDictionary(p => p.Key, o => o.Value);
return(dic);
}
private void ImportDictionary()
{
var view = new TaskInfoDialog();
var result = DialogHost.Show(view, "RootDialog");
TaskInfoDialogViewModel taskInfoDialog = TaskInfoDialogViewModel.getInstance();
TaskMessage taskMessage = new TaskMessage();
taskMessage.Title = "执行导入字典目录任务";
taskMessage.Progress = 0.0;
taskInfoDialog.Messages.Add(taskMessage);
Task task = new Task(() =>
{
App.Current.Dispatcher.Invoke((Action)(() =>
{
taskMessage.DetailMessages.Add("开始导入。。");
}));
// 导入BDCS_CONSTCLS
BaseDal <CONSTCLS> baseDal = new BaseDal <CONSTCLS>();
StreamReader sr = new StreamReader(@"C:\Users\Administrator\Desktop\BDCS_CONSTCLS 1.txt", Encoding.Default);
String line;
int index = 0;
while ((line = sr.ReadLine()) != null)
{
string[] s = line.Split(',');
CONSTCLS c = new CONSTCLS();
c.MBBSM = int.Parse(s[0].Trim());
c.CONSTSLSID = int.Parse(s[1].Trim());
c.CONSTCLSNAME = s[2].Trim();
c.CONSTCLSTYPE = s[3].Trim();
c.BZ = s[4].Trim();
baseDal.Add(c);
index++;
double per = index / 79.0 * 100;
taskMessage.Progress = per;
App.Current.Dispatcher.Invoke((Action)(() =>
{
taskMessage.DetailMessages.Add("字典目录表：进度" + per.ToString("#0.#0") + "%");
}));
}
index = 0;
taskMessage.Progress = 0.0;
BaseDal <CONST> baseDal2 = new BaseDal <CONST>();
StreamReader sr2 = new StreamReader(@"C:\Users\Administrator\Desktop\BDCS_CONST 1.txt", Encoding.Default);
String line2;
while ((line2 = sr2.ReadLine()) != null)
{
string[] s = line2.Split(',');
CONST c = new CONST();
c.MBBSM = int.Parse(s[0].Trim());
c.CONSTSLSID = int.Parse(s[1].Trim());
c.CONSTVALUE = s[2].Trim();
c.CONSTTRANS = s[3].Trim();
if (s[4].Trim() != "")
{
c.PARENTNODE = int.Parse(s[4].Trim());
}
else
{
c.PARENTNODE = null;
}
if (s[5].Trim() != "")
{
c.CONSTORDER = int.Parse(s[5].Trim());
}
else
{
c.CONSTORDER = null;
}
c.BZ = s[6].Trim();
c.CREATETIME = null;
c.MODIFYTIME = null;
c.REPORTVALUE = s[9].Trim();
c.GJCONSTTRANS = s[10].Trim();
c.SFSY = s[11].Trim();
c.GJVALUE = s[12].Trim();
baseDal2.Add(c);
index++;
double per = index / 1918.0 * 100;
taskMessage.Progress = per;
App.Current.Dispatcher.Invoke((Action)(() =>
{
taskMessage.DetailMessages.Add("字典表：进度" + per.ToString("#0.#0") + "%");
}));
}
});
task.Start();
task.ContinueWith(t =>
{
ThreadPool.QueueUserWorkItem(delegate
{
SynchronizationContext.SetSynchronizationContext(new
System.Windows.Threading.DispatcherSynchronizationContext(System.Windows.Application.Current.Dispatcher));
SynchronizationContext.Current.Post(pl =>
{
taskMessage.DetailMessages.Add("导入完成。");
}, null);
});
});
}
