private void bt_OK_Click(object sender, EventArgs e) { var dataTable = GetAllFields(flp_DataField); var NoInputFields = dataTable.GetTableFields().Where(f => !f.IsExtend && f.NoNull && f.Value == "").ToArray(); if (NoInputFields.Length > 0) { MessageBox.Show("\"" + NoInputFields.FirstOrDefault().Name + "\"没有填入值"); return; } dataTable.UpdateFieldValue("修改人", UserLogin.UserName); dataTable.UpdateFieldValue("修改时间", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); int recordID = 0; if (CurrentTable.GetTableFields().Where(f => f.Name.ToUpper() == "ID").FirstOrDefault().Value != "") { recordID = DBHelper.GetDBHelper().UpdateTableField(dataTable); } else { recordID = DBHelper.GetDBHelper().InsertIntoTable(dataTable); } if (recordID > 0) { UpdateDocList(dataTable.TableName, recordID); } this.DialogResult = DialogResult.OK; }
private bool CreateFromFieldTable(IFieldTable table, WorkingStateEnum workingState) { TableName = table.TableName; if (table == null) { return(false); } var proList = workingState.GetType().GetField(workingState.ToString()).GetCustomAttributes(typeof(Exportable), false).FirstOrDefault(); this.Text = proList != null ? (proList as Exportable).Name.ToString() : ""; var fields = table.GetTableFields(); tableLayoutPanel1.SuspendLayout(); flp_DataField.SuspendLayout(); if (fields.Where(f => !f.IsExtend).Select(f => f.Name).Any(f => flp_DataField.Controls.Find(f, true).Length == 0)) { flp_DataField.Controls.Clear(); } foreach (TableField field in fields) { if (!field.IsExtend) { AddTextField(flp_DataField, field); } } flp_DataField.ResumeLayout(false); flp_DataField.PerformLayout(); tableLayoutPanel1.ResumeLayout(false); tableLayoutPanel1.PerformLayout(); return(true); }
public int CreateTable(IConnector connector, IFieldTable table, bool withCommon = true, bool withoutExtend = true) { string sql = @"Create Table " + table.TableName + " ("; var fields = table.GetTableFields(withCommon, withoutExtend); foreach (TableField field in fields) { sql += field.Name + " " + FixFieldType(field.Type) + (field.NoNull? " NOT NULL " : "") + ","; } if (sql.Last() == ',') { sql = sql.Remove(sql.LastIndexOf(',')); } sql += ")"; int iResult = connector.Excute(sql); connector.SetFieldMark(table.TableName, table.TableDiscript, table.GetTableFields(withCommon, withoutExtend)); return(iResult); }
/// <summary> /// 向职能表中插入一条记录 /// </summary> /// <param name="table"></param> /// <returns></returns> public int InsertIntoTable(IFieldTable table, bool withCommon = true) { var tableFields = table.GetTableFields(withCommon).Where(f => f.Name.ToUpper() != "ID").ToArray(); return(InsertIntoTable(table.TableName, tableFields)); //Connection conn = null; //conn = dataSource.getConnection(); //FileInputStream fis = new FileInputStream(new File(demo.zip)); ////sql根据自己的实际情况去写,file_content字段属性是varbinary(max); //PreparedStream pre = conn.prepareStatment("insert into table (file_content) values(?)"); //pre.setBlob(1, fis); //这就是关键的一步,是不是很简单粗暴 //pre.execute(); }
/// <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 void DeviceCareWarnForm_Load(object sender, EventArgs e) { comboBox1.DataSource = DBHelper.GetDBHelper().GetTableNames().Select(kv => kv.Key).ToArray(); comboBox1.DisplayMember = "报表名称"; comboBox1.SelectedIndexChanged += (obj, ee) => { IFieldTable table = DBHelper.GetDBHelper().GetTableFields(comboBox1.Text); comboBox2.DataSource = table.GetTableFields(false).Where(f => f.Type == "smalldatetime" || f.Type == "date").Select(f => f.Name).ToArray(); }; dataGridView1.DataSourceChanged += (obj, ee) => { foreach (DataGridViewColumn col in dataGridView1.Columns) { if (col.HeaderText != "设备表名" && col.HeaderText != "保养时间" && col.HeaderText != "保养周期") { col.Visible = false; } } }; dataGridView1.DataSource = DBHelper.GetDBHelper().GetDataFromTable(0, 0, "保养提醒", ""); }
/// <summary> /// 重新布局界面 /// </summary> /// <param name="tableName"></param> /// <param name="table"></param> /// <param name="enable"></param> public void CreateFromFieldTable(IFieldTable table, WorkingStateEnum workingState) { this.DataWorkingState = workingState; CurrentTable = table; var fields = table.GetTableFields(); tableLayoutPanel1.SuspendLayout(); flp_SearchField.SuspendLayout(); flp_SearchField.Controls.Clear(); foreach (TableField field in fields) { //添加查询字段 if (field.IsSearched) { AddTextField(flp_SearchField, field, true); } } flp_SearchField.ResumeLayout(false); flp_SearchField.PerformLayout(); tableLayoutPanel1.ResumeLayout(false); tableLayoutPanel1.PerformLayout(); }
/// <summary> /// 更新职能表中的某一条记录 /// </summary> /// <param name="table"></param> /// <returns></returns> public int UpdateTableField(IFieldTable table) { var tableFields = table.GetTableFields(); return(UpdateTableField(table.TableName, tableFields.Where(f => f.Name.ToUpper() == "ID").FirstOrDefault().Value, tableFields)); }
/// <summary> /// 重新布局界面 /// </summary> /// <param name="tableName"></param> /// <param name="table"></param> /// <param name="enable"></param> public bool CreateFromFieldTable(IFieldTable table, WorkingStateEnum workingState, bool uploadFile) { RecordID = table.GetFieldValue("ID"); if (GoalTables.Contains(TableName) && workingState == WorkingStateEnum.View) { DataDetailFrom ddf = new DataDetailFrom(this.TableModeName) { Text = bt_CreateDetail.Text, Name = this.TableName, DataID = RecordID }; ddf.ShowDialog(); this.DialogResult = DialogResult.OK; return(false); } TableName = table.TableName; pictureBox1.Image = null; if (table == null) { return(false); } CurrentTable = table; lv_Doc.Items.Clear(); if (uploadFile) { OpenFileDialogForm ofd = new OpenFileDialogForm(); if (ofd.ShowDialog() == DialogResult.OK) { foreach (var file in ofd.FileNames) { lv_Doc.Items.Add(new ListViewItem(Path.GetFileName(file)) { Name = file }); } } else { this.DialogResult = DialogResult.Cancel; return(false); } } var proList = workingState.GetType().GetField(workingState.ToString()).GetCustomAttributes(typeof(Exportable), false).FirstOrDefault(); this.Text = proList != null?(proList as Exportable).Name.ToString():""; var fields = table.GetTableFields(); tableLayoutPanel1.SuspendLayout(); flp_DataField.SuspendLayout(); if (fields.Where(f => !f.IsExtend).Select(f => f.Name).Any(f => flp_DataField.Controls.Find(f, true).Length == 0)) { flp_DataField.Controls.Clear(); } foreach (TableField field in fields) { if (field.IsExtend) { if (field.Name == "ID" && field.Value != "") { var files = DBHelper.GetDBHelper().GetTableRecordDocList(table.TableName, field.Value); if (files.Length > 0) { lv_Doc.Items.AddRange(files.Select(f => new ListViewItem(Path.GetFileName(f)) { Name = f }).ToArray()); } } continue; } AddTextField(flp_DataField, field); } flp_DataField.ResumeLayout(false); flp_DataField.PerformLayout(); tableLayoutPanel1.ResumeLayout(false); tableLayoutPanel1.PerformLayout(); return(true); }
/// <summary> /// 重新布局界面 /// </summary> /// <param name="tableName"></param> /// <param name="table"></param> /// <param name="enable"></param> public bool CreateFromFieldTable(IFieldTable table, WorkingStateEnum workingState, bool uploadFile) { TableName = table.TableName; pictureBox1.Image = null; if (table == null) { return(false); } CurrentTable = table; lv_Doc.Items.Clear(); if (uploadFile) { OpenFileDialogForm ofd = new OpenFileDialogForm(); if (ofd.ShowDialog() == DialogResult.OK) { foreach (var file in ofd.FileNames) { lv_Doc.Items.Add(new ListViewItem(Path.GetFileName(file)) { Name = file }); } } else { this.DialogResult = DialogResult.Cancel; return(false); } } var proList = workingState.GetType().GetField(workingState.ToString()).GetCustomAttributes(typeof(Exportable), false).FirstOrDefault(); this.Text = proList != null?(proList as Exportable).Name.ToString():""; var fields = table.GetTableFields(); tableLayoutPanel1.SuspendLayout(); DataTable dt = new DataTable(); List <string> values = new List <string>(); dt.Columns.AddRange(fields.Where(f => !f.IsExtend || f.Name != "ID").Select(f => new DataColumn(f.Name)).ToArray()); dt.Rows.Add(fields.Where(f => !f.IsExtend || f.Name != "ID").Select(f => f.Value).ToArray()); string id = fields.Where(f => f.Name == "ID").Select(f => f.Value).FirstOrDefault(); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", dt)); this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet2", GetImages(id))); this.reportViewer1.RefreshReport(); foreach (TableField field in fields) { if (field.IsExtend) { if (field.Name == "ID" && field.Value != "") { RecordID = field.Value; var files = DBHelper.GetDBHelper().GetTableRecordDocList(table.TableName, field.Value); if (files.Length > 0) { lv_Doc.Items.AddRange(files.Select(f => new ListViewItem(Path.GetFileName(f)) { Name = f }).ToArray()); } break; } } } tableLayoutPanel1.ResumeLayout(false); tableLayoutPanel1.PerformLayout(); return(true); }
private void SaveData(bool msgBox = false) { if (!DBHelper.GetDBHelper().ExistTable(Name + DataDetailFlag)) { List <TableField> fields = new List <TableField>(); fields.Add(new TableField() { Name = "DataID" }); fields.AddRange(GetTable(TotalDataTable, Name + DataDetailFlag).GetTableFields(false, false).ToArray()); DBHelper.GetDBHelper().CreateTable(TableMode, Name + DataDetailFlag, fields.ToArray(), false, false); } //if(DataID!="") // DBHelper.GetDBHelper().DelDataFromTable(Name + DataDetailFlag, DataID, "DataID"); //DataTable dt = DBHelper.GetDBHelper().GetDataFromTable(0, 0, Name + DataDetailFlag, "DataID='" + DataID + "'"); foreach (DataRow row in TotalDataTable.Rows) { IFieldTable tableFields = GetFieldTable(TotalDataTable, row, Name + DataDetailFlag); tableFields.AddField(new TableField() { Name = "DataID", Type = TableField.FieldTypeList[TableFieldType.文本], Value = DataID }); if (!TotalDataTable.Columns.Contains("ID")) { DBHelper.GetDBHelper().InsertIntoTable(tableFields, false); } else { DBHelper.GetDBHelper().UpdateTableField(Name + DataDetailFlag, row["ID"].ToString(), tableFields.GetTableFields(false)); } } TotalDataTable = DBHelper.GetDBHelper().GetDataFromTable(0, 0, Name + DataDetailFlag, "DataID ='" + DataID + "'"); if (msgBox && MessageBox.Show("保存完成!是否退出?", "退出?", MessageBoxButtons.YesNo) == DialogResult.Yes) { this.Close(); } }