public List <ModelLabelArea> GetLabelAreaConfig(int tableType)
{
DataTable dt = new DataTable();
string sql = "select Id, Font, Size, Bold, Italic, Color, Position, TableLayoutPanelName from ShowLCD_LabelArea where TableType=" + tableType;
List <ModelLabelArea> listModel = new List <ModelLabelArea>();
try
{
dt = dbclass.TruyVan_TraVe_DataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
var model = new ModelLabelArea();
model.Id = int.Parse(row["Id"].ToString());
model.Font = row["Font"].ToString();
model.Size = float.Parse(row["Size"].ToString());
model.Bold = bool.Parse(row["Bold"].ToString());
model.Italic = bool.Parse(row["Italic"].ToString());
model.Color = row["Color"].ToString();
model.Position = int.Parse(row["Position"].ToString());
model.TableLayoutPanelName = row["TableLayoutPanelName"].ToString();
listModel.Add(model);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi không thể lấy thông tin cấu hình Panel của LCD: " + ex.Message, "Lỗi truy vấn CSDL", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(listModel);
}
private void butSaveLabelArea_Click(object sender, EventArgs e)
{
try
{
List <ModelLabelArea> listModel = new List <ModelLabelArea>();
for (int i = 0; i < gridViewLabelArea.RowCount; i++)
{
var model = new ModelLabelArea();
model.Id = int.Parse(gridViewLabelArea.GetRowCellValue(i, "Id").ToString());
model.Italic = bool.Parse(gridViewLabelArea.GetRowCellValue(i, "Italic").ToString());
model.Bold = bool.Parse(gridViewLabelArea.GetRowCellValue(i, "Bold").ToString());
model.Color = gridViewLabelArea.GetRowCellValue(i, "Color").ToString();
model.Font = gridViewLabelArea.GetRowCellValue(i, "Font").ToString();
model.Position = int.Parse(gridViewLabelArea.GetRowCellValue(i, "Position").ToString());
model.Size = float.Parse(gridViewLabelArea.GetRowCellValue(i, "Size").ToString());
model.TableLayoutPanelName = gridViewLabelArea.GetRowCellValue(i, "TableLayoutPanelName").ToString();
model.TableType = tableType;
listModel.Add(model);
}
lcdConfigDAO.SaveLabelAreaConfig(listModel);
LoadDataLabelArea();
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "Đã xảy ra lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}