public FrmMain(HWCfgFileModel hwFile)
{
InitializeComponent();
this.hwFile = hwFile;
dgModel.AutoGenerateColumns = false;
dgModule.AutoGenerateColumns = false;
BuildActiveCombobox();
}
private void dgFiles_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
var model = dgFiles.Rows[e.RowIndex].DataBoundItem as HWCfgFileModel;
this.HWFile = model;
txtFileName.Text = model.HWName;
}
public static async void SaveHWCfgFileModel(HWCfgFileModel model)
{
var sql = "insert into HWCfgFileList values('{0}','{1}','{2}',{3})";
sql = string.Format(sql, model.HWName, model.HWTime, model.Author, model.SystemDefault);
using (var conn = DBFactory.Create())
{
conn.Open();
var cmd = conn.CreateCommand() as DbCommand;
cmd.CommandText = sql;
await cmd.ExecuteNonQueryAsync();
}
}
public static async void UpdateHWCfgFileModel(HWCfgFileModel model)
{
var sql = "update HWCfgFileList set SystemDefault={0} where HWName='{1}'";
sql = string.Format(sql, model.SystemDefault, model.HWName);
using (var conn = DBFactory.Create())
{
conn.Open();
var cmd = conn.CreateCommand() as DbCommand;
cmd.CommandText = sql;
await cmd.ExecuteNonQueryAsync();
}
}
/// <summary>
/// 文件列表
/// </summary>
/// <returns></returns>
public static async Task <List <HWCfgFileModel> > CfgList()
{
var list = new List <HWCfgFileModel>();
var sql = "select * from HWCfgFileList";
using (var conn = DBFactory.Create())
{
conn.Open();
var cmd = conn.CreateCommand() as DbCommand;
cmd.CommandText = sql;
var reader = await cmd.ExecuteReaderAsync();
while (reader.Read())
{
var model = new HWCfgFileModel();
model.HWName = reader["HWName"].ToString();
model.HWTime = reader["HWTime"].ToString().ToDateTime();
model.Author = reader["Author"].ToString();
model.SystemDefault = reader["SystemDefault"].ToInt32();
list.Add(model);
}
return(list);
}
}
