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);
}
/// <summary>
/// Adds all the items from one field table in this one. Will overwrite any items in the current table
/// with the same key.
/// </summary>
/// <param name="ft">the source field table</param>
public void AddAll(IFieldTable ft)
{
foreach (DictionaryEntry dictionaryEntry in ft)
{
this[(string)dictionaryEntry.Key] = dictionaryEntry.Value;
}
}
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, "保养提醒", "");
}
public void CreateFromField(IFieldTable table, DataGridViewRow row, WorkingStateEnum workingState, bool uploadFile)
{
var file = Directory.GetFiles("RDLC").Where(f => this.TemplateName.Equals(Path.GetFileNameWithoutExtension(f))).FirstOrDefault();
if (workingState == WorkingStateEnum.View && file != null)
{
ViewDataForm ndf = new ViewDataForm(file);
if (ndf.CreateFromFieldTable(table, WorkingStateEnum.View, false))
{
ndf.TableName = table.TableName;
if (ndf.ShowDialog() == DialogResult.OK)
{
DataSource = DBHelper.GetDBHelper().GetDataFromTable(0, 0, TemplateName, "");
}
}
}
else if (row != null && RegulationTables.Contains(this.TableName))
{
string fileName = "";
foreach (DataGridViewColumn col in row.DataGridView.Columns)
{
if (col.HeaderText.Contains("名称"))
{
fileName = row.Cells[col.Name].Value.ToString();
}
}
if (fileName == "")
{
fileName = this.TableName + row.Cells["ID"].Value.ToString();
}
Byte[] bytes = DBHelper.GetDBHelper().GetDocFromTableRecordBytes(this.TableName, row.Cells["ID"].Value.ToString(), fileName);
MemoryStream stream = new MemoryStream(bytes);
RegulationFrom rf = new RegulationFrom()
{
Text = this.TableName, TableName = this.TableName, EditEnable = false, RegulationFileStream = stream, CurrentFieldTable = table
};
rf.ShowDialog();
}
else
{
NewDataForm ndf = new NewDataForm()
{
TableName = this.TableName, TableModeName = this.TableModeName
};
if (ndf.CreateFromFieldTable(table, workingState, uploadFile))
{
ndf.TableName = table.TableName;
if (ndf.ShowDialog() == DialogResult.OK)
{
DataSource = DBHelper.GetDBHelper().GetDataFromTable(0, 0, TableName, "");
}
}
}
}
private void CreateTable(DataGridView dgv, string tableName)
{
DBHelper.GetDBHelper().CreateTable(TableMode, tableName, GetTable(dgv, tableName).GetTableFields(false, false), false, false);
foreach (DataGridViewRow row in dgv.Rows)
{
IFieldTable tableFields = GetFieldTable(dgv, row, tableName);
tableFields.TableName = tableName;
DBHelper.GetDBHelper().InsertIntoTable(tableFields, false);
}
}
/// <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();
}
private void RegulationFrom_Load(object sender, EventArgs e)
{
if (RegulationFileStream != null)
{
this.rtb_Regulation.OpenWord(RegulationFileStream);
rtb_Regulation.ReadOnly = !EditEnable;
bt_Save.Visible = EditEnable;
bt_Paste.Visible = EditEnable;
}
if (CurrentFieldTable == null)
{
CurrentFieldTable = DBHelper.GetDBHelper().GetTableFields(this.TableName);
}
CreateFromFieldTable(CurrentFieldTable, WorkingStateEnum.Creating);
}
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);
}
public void EditRow(DataGridViewRow row, WorkingStateEnum state = WorkingStateEnum.Editting)
{
if (state == WorkingStateEnum.View && !RowReportTables.Contains(this.TableName))
{
if (CreateFromField(dataGridView1.DataSource as DataTable, row, WorkingStateEnum.View, false))
{
return;
}
}
DataWorkingState = WorkingStateEnum.Creating;
IFieldTable table = GetFieldTable(row);
CreateFromField(table, row, state, false);
this.DataWorkingState = WorkingStateEnum.Search;
}
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);
}
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);
}
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();
}
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();
}
}
/// <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);
}
/// <summary>
/// Adds all the items from one field table in this one. Will overwrite any items in the current table
/// with the same key.
/// </summary>
/// <param name="ft">the source field table</param>
public void AddAll(IFieldTable ft)
{
foreach ( DictionaryEntry dictionaryEntry in ft )
{
this[(string)dictionaryEntry.Key] = dictionaryEntry.Value;
}
}
/// <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>
/// Bind a queue to the specified exchange.
/// </summary>
/// <param name="queueName">Name of queue to bind</param>
/// <param name="exchangeName">Name of exchange to bind to</param>
/// <param name="routingKey">Routing key</param>
/// <param name="args">Table of arguments for the binding. Used to bind with a Headers Exchange</param>
public void Bind(string queueName, string exchangeName, string routingKey, IFieldTable args)
{
DoBind(queueName, exchangeName, routingKey, (FieldTable)args);
}
/// <summary>
/// Declare a new queue with the specified set of arguments.
/// </summary>
/// <param name="queueName">Name of the queue</param>
/// <param name="isDurable">True if the queue should be durable</param>
/// <param name="isExclusive">True if the queue should be exclusive to this channel</param>
/// <param name="isAutoDelete">True if the queue should be deleted when the channel closes</param>
/// <param name="args">Optional arguments to Queue.Declare</param>
public void DeclareQueue(string queueName, bool isDurable, bool isExclusive, bool isAutoDelete, IFieldTable args)
{
DoQueueDeclare(queueName, isDurable, isExclusive, isAutoDelete, args);
}
public void DoQueueDeclare(string queueName, bool isDurable, bool isExclusive, bool isAutoDelete, IFieldTable args, bool isPassive)
{
_logger.Debug(string.Format("DeclareQueue name={0} durable={1} exclusive={2}, auto-delete={3}",
queueName, isDurable, isExclusive, isAutoDelete));
AMQFrame queueDeclare = QueueDeclareBody.CreateAMQFrame(_channelId, 0, queueName, isPassive, isDurable, isExclusive,
isAutoDelete, false, (FieldTable) args);
lock (_connection.FailoverMutex)
{
_connection.ConvenientProtocolWriter.SyncWrite(queueDeclare, typeof(QueueDeclareOkBody));
}
// AS FIXME: wasnae me
_replayFrames.Add(QueueDeclareBody.CreateAMQFrame(_channelId, 0, queueName, false, isDurable, isExclusive,
isAutoDelete, true, null));
}
private void DataEditPanel_Load(object sender, EventArgs e)
{
dataGridView1.Visible = false;
dataGridView1.DataSourceChanged += (obj, ee) =>
{
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
if (col.ValueType == typeof(DateTime))
{
if (col.HeaderText == "修改时间")
{
col.DefaultCellStyle.Format = "yyyy/MM/dd HH:mm:ss";
}
else
{
col.DefaultCellStyle.Format = "yyyy/MM/dd";
}
}
}
if (dataGridView1.Columns.Contains("ID"))
{
dataGridView1.Columns["ID"].Visible = false;
}
if (dataGridView1.Columns.Contains("ShowDoc"))
{
dataGridView1.Columns.Remove("ShowDoc");
}
DataGridViewTextBoxColumn colDefault = new DataGridViewTextBoxColumn();
colDefault.Name = "ShowDoc";
colDefault.HeaderText = " ";
colDefault.DefaultCellStyle.Font = new Font(dataGridView1.Font, FontStyle.Underline);
colDefault.DefaultCellStyle.ForeColor = Color.Blue;
int colIndex = dataGridView1.Columns.Add(colDefault);
dataGridView1.Visible = true;
};
dataGridView1.CellFormatting += (obj, ee) =>
{
if (ee.RowIndex < 0)
{
return;
}
if (ee.ColumnIndex >= 0 && dataGridView1.Columns[ee.ColumnIndex].Name == "ShowDoc")
{
dataGridView1.Rows[ee.RowIndex].Cells[ee.ColumnIndex].Value = "浏览";
}
};
dataGridView1.CellContentClick += (obj, ee) =>
{
if (ee.ColumnIndex < 0 || ee.RowIndex < 0)
{
return;
}
if (dataGridView1.Columns[ee.ColumnIndex].Name == "ShowDoc")
{
DataWorkingState = WorkingStateEnum.Creating;
IFieldTable table = GetFieldTable(dataGridView1.Rows[ee.RowIndex]);
ShowDocForm ndf = new ShowDocForm();
if (ndf.CreateFromFieldTable(table, DataWorkingState, false))
{
ndf.TableName = table.TableName;
if (ndf.ShowDialog() == DialogResult.OK)
{
DataSource = DBHelper.GetDBHelper().GetDataFromTable(0, 0, TableName, "");
}
}
this.DataWorkingState = WorkingStateEnum.Search;
}
};
dataGridView1.CellMouseDoubleClick += (obj, ee) =>
{
if (ee.RowIndex < 0)
{
return;
}
if (!RowReportTables.Contains(this.TableName))
{
if (CreateFromField(dataGridView1.DataSource as DataTable, dataGridView1.Rows[ee.RowIndex], WorkingStateEnum.View, false))
{
return;
}
}
dataGridView1.Rows[ee.RowIndex].Selected = true;
IFieldTable table = GetFieldTable(dataGridView1.SelectedRows[0]);
CreateFromField(table, dataGridView1.Rows[ee.RowIndex], WorkingStateEnum.View, false);
};
tableLayoutPanel1.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(tableLayoutPanel1, true, null);
tableLayoutPanel2.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(tableLayoutPanel2, true, null);
this.flp_SearchField.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(flp_SearchField, true, null);
#region 读取报表配置文件
string RowReportTableString = Common.CommonConfigurationManager.GetAppConfig("单行报表");
if (RowReportTableString == "")
{
RowReportTables = new string[] {
"安全技术交底表",
"安全检查记录表",
"安全生产会议记录",
"安全生产奖励通知单",
"安全教育培训记录表",
"安全生产违约处理通知单",
"安全隐患整改回复单",
"安全隐患整改通知单",
"应急救援预案演练记录表",
"三级安全教育登记卡",
"生产管理制度",
"设备安全检查记录表"
};
RowReportTableString = string.Join(",", RowReportTables);
CommonConfigurationManager.UpdateAppConfig("单行报表", RowReportTableString);
}
else
{
RowReportTables = RowReportTableString.Split(',');
}
string GoalTableString = Common.CommonConfigurationManager.GetAppConfig("评价报表");
if (GoalTableString == "")
{
GoalTables = new string[] {
"施工单位安全生产条件核查表",
"施工单位平安工地考核评价表"
};
GoalTableString = string.Join(",", GoalTables);
CommonConfigurationManager.UpdateAppConfig("评价报表", GoalTableString);
}
else
{
GoalTables = GoalTableString.Split(',');
}
string RegulationTableString = Common.CommonConfigurationManager.GetAppConfig("制度方案报表");
if (RegulationTableString == "")
{
RegulationTables = new string[] {
"生产管理制度",
"工程专项施工方案",
"临时用电方案"
};
RegulationTableString = string.Join(",", RegulationTables);
CommonConfigurationManager.UpdateAppConfig("制度方案报表", RegulationTableString);
}
else
{
RegulationTables = RegulationTableString.Split(',');
}
#endregion
}
/// <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));
}
private ContextMenuStrip CreateDataGridViewMenu(int rowIndex)
{
ContextMenuStrip cms = new ContextMenuStrip();
cms.ShowImageMargin = false;
cms.ShowCheckMargin = false;
cms.ShowItemToolTips = false;
cms.Font = this.Font;
ToolStripButton itemNew = new ToolStripButton();
itemNew.Text = "新建记录";
itemNew.Click += (obj, ee) =>
{
CreateNew();
};
cms.Items.Add(itemNew);
if (rowIndex < 0)
{
return(cms);
}
DataGridViewRow row = dataGridView1.Rows[rowIndex];
ToolStripButton itemEdit = new ToolStripButton();
itemEdit.Text = "编辑";
itemEdit.Click += (obj, ee) =>
{
EditRow(row);
};
cms.Items.Add(itemEdit);
ToolStripButton itemView = new ToolStripButton();
itemView.Text = "查看";
itemView.Click += (obj, ee) =>
{
EditRow(row, WorkingStateEnum.View);
};
cms.Items.Add(itemView);
ToolStripButton itemDel = new ToolStripButton();
itemDel.Text = "删除记录";
itemDel.Click += (obj, ee) =>
{
DeleteRow(row);
};
if (!this.TableName.Contains("制度"))
{
cms.Items.Add(itemDel);
}
ToolStripButton itemUpload = new ToolStripButton();
itemUpload.Text = "文档上传";
itemUpload.Click += (obj, ee) =>
{
if (dataGridView1.SelectedRows.Count == 0 || this.TableName == "")
{
return;
}
IFieldTable table = GetFieldTable(row);
if (this.TableName.Contains("制度"))
{
CreateFromField(table, null, WorkingStateEnum.Editting, false);
}
else
{
CreateFromField(table, null, WorkingStateEnum.Editting, true);
}
};
if (this.TableName.Contains("制度"))
{
itemUpload.Text = "文档管理";
}
cms.Items.Add(itemUpload);
return(cms);
}
public int CreateTable(IConnector connector, string tableName, string tableDiscript, TableField[] fields, bool withCommon = true, bool withoutextend = true)
{
IFieldTable table = GetTableFromField(tableName, tableDiscript, fields);
return(CreateTable(connector, table, withCommon, withoutextend));
}
private void DoQueueDeclare(string queueName, bool isDurable, bool isExclusive, bool isAutoDelete, IFieldTable args)
{
DoQueueDeclare(queueName, isDurable, isExclusive, isAutoDelete, args, false);
}
