/// <summary>
/// 获取仪器列表
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public static async Task <List <HWCfgInstrumentModel> > GetInstrumentModelList(string name)
{
var list = new List <HWCfgInstrumentModel>();
var sql = "select * from HWCfgInstrument where HWName='{0}'";
sql = string.Format(sql, name);
using (var conn = DBFactory.Create())
{
try
{
conn.Open();
var cmd = conn.CreateCommand() as DbCommand;
cmd.CommandText = sql;
var reader = await cmd.ExecuteReaderAsync();
while (reader.Read())
{
var model = new HWCfgInstrumentModel
{
ID = reader["ID"].ToInt32(),
InstrumentName = reader["InstrumentName"].ToString(),
HWName = reader["HWName"].ToString()
};
list.Add(model);
}
}
catch (Exception e)
{
}
return(list);
}
}
public static async void Insert(HWCfgInstrumentModel model)
{
try
{
var sql = "insert into HWCfgInstrument values({0},'{1}','{2}',{3})";
sql = string.Format(sql, model.ID, model.InstrumentName, model.HWName, model.Active);
using (var conn = DBFactory.Create())
{
conn.Open();
var cmd = conn.CreateCommand() as DbCommand;
cmd.CommandText = sql;
await cmd.ExecuteNonQueryAsync();
}
}
catch (Exception e)
{
}
}
/// <summary>
/// 添加仪器
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmiInstrumentAdd_Click(object sender, EventArgs e)
{
var window = new FrmInstrumentType();
var dialog = window.ShowDialog();
if (dialog == DialogResult.OK)
{
var node = new TreeNode(window.InstrumentName);
node.ContextMenuStrip = GetSecondContextMenuStrip(node);
root.Nodes.Add(node);
if (root.IsExpanded == false)
{
root.Expand();
}
var instrument = new HWCfgInstrumentModel
{
InstrumentName = window.InstrumentName,
HWName = hwFile.HWName,
};
node.Tag = hwFile.HWName + splitchar + node.Text;
instrumentList.Add(instrument);
}
}
