static ProtocolDB()
{
helper.SetConnectionString($"{AppDomain.CurrentDomain.BaseDirectory}data\\prollite.db");
string sql = $"SELECT [PCID],[PCName],[ParentID],[CreateTime] FROM [ProtocolClassification]";
//获取所有分类
classificationModels = DT2ProtocolClassificationModel(helper.ExecuteQuery(sql));
if (classificationModels == null)
{
classificationModels = new List <ProtocolClassificationModel>();
}
string settingSql = "SELECT [UseNamespace],[NamespaceContent] FROM [ProtocolSetting]";
settingModel = DT2ProtocolSettingModel(helper.ExecuteQuery(settingSql));
if (settingModel == null)
{
settingModel = new ProtocolSettingModel()
{
UseNamespace = false,
NamespaceContent = ""
};
AddSetting();
}
}
private static ProtocolSettingModel DT2ProtocolSettingModel(DataTable _dt)
{
if (_dt != null && _dt.Rows.Count > 0)
{
ProtocolSettingModel model = new ProtocolSettingModel();
model.NamespaceContent = _dt.Rows[0]["NamespaceContent"].ToString();
model.UseNamespace = Convert.ToBoolean(_dt.Rows[0]["UseNamespace"]);
}
return(null);
}
