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); }