public void SaveToFile(string fileName)
{
DataTable dtList = new DataTable("sqlbizs");
dtList.Columns.Add("业务名称", typeof(System.String));
foreach (DataTable dtBiz in _sqlDs.Tables)
{
SqlBiz sb = dtBiz as SqlBiz;
sb.SaveToFile(fileName + "_" + sb.BizName + ".dat");
DataRow drNew = dtList.NewRow();
drNew["业务名称"] = sb.BizName;
dtList.Rows.Add(drNew);
}
//using (FileStream fs = new FileStream(fileName + "_list.xml", FileMode.Create))
//{
MemoryStream ms = new MemoryStream();
dtList.WriteXml(ms, XmlWriteMode.WriteSchema);
ms.Position = 0;
Encrypt ept = new Encrypt(CONST_ENCRYPT_KEY, false);
ept.EncryptToFile(ms, fileName + "_list.dat");
//}
}
public void LoadFromFile(string fileName)
{
if (File.Exists(fileName + "_list.dat") == false)
{
return;
}
DataTable dtList = new DataTable("sqlbizs");
Encrypt cpt = new Encrypt(CONST_ENCRYPT_KEY, false);
MemoryStream ms = cpt.DecryptFromFile(fileName + "_list.dat");
ms.Position = 0;
dtList.ReadXml(ms);
if (dtList.Rows.Count <= 0)
{
return;
}
foreach (DataRow dr in dtList.Rows)
{
SqlBiz sb = new SqlBiz(dr["业务名称"].ToString());
sb.LoadFromFile(fileName + "_" + sb.BizName + ".dat");
_sqlDs.Tables.Add(sb);
}
}
public SqlBiz GetBiz(string bizName)
{
if (HasBiz(bizName) == false)
{
SqlBiz sb = new SqlBiz(bizName);
_sqlDs.Tables.Add(sb);
}
return(_sqlDs.Tables[bizName] as SqlBiz);
}
private void frmSqlManager_Load(object sender, EventArgs e)
{
tvSqls.Nodes.Clear();
if (_sqlManager.SqlBizs.Tables.Count <= 0)
{
return;
}
foreach (DataTable dtBiz in _sqlManager.SqlBizs.Tables)
{
SqlBiz sb = dtBiz as SqlBiz;
TreeNode pNode = tvSqls.Nodes.Add(sb.BizName);
pNode.Name = sb.BizName;
foreach (DataRow dr in sb.Rows)
{
TreeNode tnSub = pNode.Nodes.Add(dr[sb.KeyName].ToString());
tnSub.Name = dr[sb.KeyName].ToString();
}
}
}
