private void bt_Save_Click(object sender, EventArgs e)
{
IFieldTable table = DBHelper.GetDBHelper().GetTableFields("保养提醒");
table.UpdateFieldValue(new TableField()
{
Name = "设备表名", Value = comboBox1.Text
});
table.UpdateFieldValue(new TableField()
{
Name = "保养时间", Value = comboBox2.Text
});
table.UpdateFieldValue(new TableField()
{
Name = "保养周期", Value = numericUpDown1.Value.ToString()
});
if (dataGridView1.DataSource != null)
{
DataTable dt = dataGridView1.DataSource as DataTable;
if (dt.Select("设备表名='" + comboBox1.Text + "' and 保养时间='" + comboBox2.Text + "'").Length > 0)
{
DBHelper.GetDBHelper().UpdateTableField(table);
return;
}
}
table.UpdateFieldValue("修改人", UserLogin.UserName);
table.UpdateFieldValue("修改时间", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
DBHelper.GetDBHelper().InsertIntoTable(table);
dataGridView1.DataSource = DBHelper.GetDBHelper().GetDataFromTable(0, 0, "保养提醒", "");
}
/// <summary>
/// 获到当前所有文 本框 的值 ，并返回到对象中
/// </summary>
/// <returns></returns>
private IFieldTable GetAllFields(FlowLayoutPanel flp)
{
TableField[] fieldList = CurrentTable.GetTableFields().Where(f => !f.IsExtend).ToArray();
foreach (TableField field in fieldList)
{
Control tb = flp.Controls.Find(field.Name, true).FirstOrDefault() as Control;
if (tb == null)
{
continue;
}
if (tb is ComboBox)
{
field.Value = (tb as ComboBox).SelectedValue.ToString();
}
//else if(tb is PictureBox)
//{
// using (System.IO.MemoryStream ms = new System.IO.MemoryStream())
// {
// (tb as PictureBox).Image.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
// byte[] byteImage = new Byte[ms.Length];
// field.Value = ms.ToArray();
// //string strB64 = Convert.ToBase64String(byteImage);
// }
//}
else
{
field.Value = tb.Text;
}
CurrentTable.UpdateFieldValue(field);
}
return(CurrentTable);
}
/// <summary>
/// 获到当前所有文 本框 的值 ，并返回到对象中
/// </summary>
/// <returns></returns>
private IFieldTable GetAllFields(FlowLayoutPanel flp)
{
TableField[] fieldList = CurrentTable.GetTableFields().Where(f => !f.IsExtend).ToArray();
foreach (TableField field in fieldList)
{
Control tb = flp.Controls.Find(field.Name, true).FirstOrDefault() as Control;
if (tb == null)
{
continue;
}
field.Value = tb.Text;
CurrentTable.UpdateFieldValue(field);
}
return(CurrentTable);
}
private IFieldTable GetFieldTable(DataGridViewRow dataRow)
{
IFieldTable table = DBHelper.GetDBHelper().GetTableFields(this.TableName);
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
if (dataRow.Cells[col.Index].Value != null)
{
table.UpdateFieldValue(new TableField()
{
Name = col.Name, Value = dataRow.Cells[col.Index].Value.ToString()
});
}
}
return(table);
}
private IFieldTable GetFieldTable(DataTable dt, DataRow dataRow, string tableName)
{
IFieldTable table = DBHelper.GetDBHelper().GetTableFields(tableName);
foreach (DataColumn col in dt.Columns)
{
if (dataRow[col] != null)
{
table.UpdateFieldValue(new TableField()
{
Name = col.ColumnName, Value = dataRow[col].ToString()
});
}
}
return(table);
}
