/// <summary>
/// 从ini文件中读取。
/// </summary>
/// <param name="path"></param>
public void LoadFromIni(string path)
{
IniAccess ia = new IniAccess(path);
ia.Section = Section;
LoadFromIni(ia);
}
/// <summary>
/// 保存至Ini文件。
/// </summary>
/// <param name="path"></param>
public void SaveToIni(string path)
{
IniAccess ia = new IniAccess(path);
ia.Section = Section;
SaveToIni(ia);
}
private void ConTestForm_Load(object sender, EventArgs e)
{
Control.CheckForIllegalCrossThreadCalls = false;
IniAccess.CreateFile(FilePath);
cbConnectionType.SelectedIndex = 0;
string[] constrs = File.ReadAllLines(FilePath, Encoding.Default);
foreach (string constr in constrs)
{
SQLConnection sm = SQLConnection.FromDesString(constr, true);
if (sm != null)
{
cms.Add(sm);
cbServer.Items.Add(sm.DataSource);
}
}
// init UI
if (cms.Count > 0)
{
Connection = cms[0];
cbDatabase.Items.Add(Connection.InitialCatalog);
cbDatabase.SelectedIndex = 0;
btnSave.Enabled = true;
}
UpdateUI();
}
/// <summary>
/// 从ini文件中读取。
/// </summary>
/// <param name="ia"></param>
public void LoadFromIni(IniAccess ia)
{
string v = ia.ReadValue(FullName);
if (NeedCrypto && v != null && v.Length > 0)
{
v = DESCrypto.Decrypt(v);
}
SetValue(v);
}
public virtual void OnFormClosing()
{
IniAccess ia = new IniAccess(Program.AppCfgPath);
ia.Section = this.Name;
for (int i = 0; i < pmlist.Count; i++)
{
pmlist[i].SaveToIni(ia);
}
}
/// <summary>
/// 保存至Ini文件。
/// </summary>
/// <param name="ia"></param>
public void SaveToIni(IniAccess ia)
{
if (NeedSave)
{
string s = GetValue();
if (NeedCrypto)
{
s = DESCrypto.Encrypt(s);
}
ia.WriteValue(FullName, s);
}
}
/// <summary>
/// 将连接字符串保存到INI文件中。用户名密码会自动加密。
/// </summary>
/// <param name="iniPath"></param>
/// <returns></returns>
public bool SaveToIni(string iniPath)
{
try
{
IniAccess.CreateFile(iniPath);
IniAccess ia = new IniAccess(iniPath);
ia.Section = "System";
ia.WriteValue("DataSource", DataSource);
ia.WriteValue("InitialCatalog", InitialCatalog);
ia.WriteValue("UserID", DESCrypto.Encrypt(UserID));
ia.WriteValue("Password", DESCrypto.Encrypt(Password));
ia.WriteValue("TrustedConnection", TrustedConnection.ToString());
}
catch (Exception e1)
{
Console.WriteLine(e1.Message);
return(false);
}
return(true);
}
/// <summary>
/// 从给定的INI文件中读取连接字符串。用户名密码会自动加密。
/// </summary>
/// <param name="iniPath"></param>
/// <returns></returns>
public bool LoadFromIni(string iniPath)
{
try
{
IniAccess ia = new IniAccess(iniPath);
ia.Section = "System";
DataSource = ia.ReadValue("DataSource");
InitialCatalog = ia.ReadValue("InitialCatalog");
UserID = ia.ReadValue("UserID");
Password = ia.ReadValue("Password");
UserID = DESCrypto.Decrypt(UserID);
Password = DESCrypto.Decrypt(Password);
string s = ia.ReadValue("TrustedConnection");
if (s != null && s.Length > 0)
{
trustedConnection = bool.Parse(s);
}
}
catch { return(false); }
return(true);
}
public override bool TransferFile(string path)
{
IniAccess ia = new IniAccess("userconfig.ini");
string catalogfile = ia.ReadValue("catalog");
QCatalog catalog = QCatalog.GetCatlog(File.Exists(catalogfile) ? catalogfile : "catalog.dfd");
Workbook wb = new Workbook();
wb.LoadFromFile(path);
Worksheet sheet = wb.Worksheets[0];
QFile qf = new QFile();
qf[1001] = sheet[3, 2].Value;
qf[1053] = sheet[3, 4].Value;
qf[1086] = sheet[3, 5].Value;
qf[1110] = sheet[3, 6].Value; // 1100 -> 1110
qf[1101] = sheet[2, 1].Value;
qf[1102] = sheet[3, 1].Value;
int rowid = 5;
while (true)
{
if (isEmpty(sheet, rowid))
{
break;
}
QCharacteristic qc = new QCharacteristic();
qf.Charactericstics.Add(qc);
string pid = sheet[rowid, 1].Value != null ? sheet[rowid, 1].Value.ToString() : "";
qc[2001] = pid.Replace('(', ' ').Replace(')', ' ').Trim();
qc[2002] = sheet[rowid, 2].Value;
qc[2005] = sheet[rowid, 13].Value.Contains("是") ? 4 : 1; // 不包括是时为 1 还是0 ，文档中有错误。
qc[2022] = 4;
qc[2101] = sheet[rowid, 3].Value;
qc[2113] = sheet[rowid, 4].Value;
qc[2112] = sheet[rowid, 5].Value;
qc[2120] = 1;
qc[2121] = 1;
qc[2142] = "mm";
qc[8500] = 5;
qc[8501] = 0;
QDataItem di = new QDataItem();
di.SetValue(sheet[rowid, 6].Value);
di.date = sheet[3, 10].DateTimeValue;
di[0006] = sheet[3, 3].Value;
di[0008] = catalog.getCatalogPID("K4093", sheet[3, 11].Value);
di[0010] = catalog.getCatalogPID("K4063", sheet[rowid, 11].Value);
di[0011] = sheet[rowid, 10].Value;
di[0012] = catalog.getCatalogPID("K4072", sheet[rowid, 10].Value);
di[0061] = catalog.getCatalogPID("K4273", sheet[3, 7].Value);
qc.data.Add(di);
// Console.WriteLine("{0}, {0}, {0}, {0}", di[0008], di[0010], di[0012], di[0061]);
rowid++;
}
qf.ToDMode();
SaveDfqByFilename(qf, Path.GetFileNameWithoutExtension(path) + ".dfq");
return(base.TransferFile(path));
}
