private async Task Laduj()
{
var dozwoloneLokalizacje = LokalizacjaHelper.DajDozwoloneLokalizacje(_lokalizacja);
var elementList = await _payoutService.GetWithFilter(x => x.CreatedOn > _aktualizacjaKasy && dozwoloneLokalizacje.Contains(_lokalizacja));
dataGridView1.DataSource = elementList;
dataGridView1.Columns["PayoutId"].Visible = false;
dataGridView1.Columns["CreatedOn"].HeaderText = "Data wypłaty";
dataGridView1.Columns["Description"].HeaderText = "Opis";
dataGridView1.Columns["Lokalizacja"].Visible = false;
if (!dataGridView1.Columns.Contains("UsunCol"))
{
DataGridViewButtonColumn col = new DataGridViewDisableButtonColumn();
col.UseColumnTextForButtonValue = true;
col.Visible = true;
col.Text = "Usuń";
col.Name = "UsunCol";
dataGridView1.Columns.Add(col);
}
dataGridView1.Columns["UsunCol"].Visible = true;
dataGridView1.Columns["UsunCol"].HeaderText = "Usuń";
}
private void Frm_IngresoStock_Load(object sender, EventArgs e)
{
try
{
MenuSistema.Cls_Menus menu = new MenuSistema.Cls_Menus();
menu.ObtenerPermisos(Id_Perfil, Convert.ToInt32(Tag.ToString()), ref lectura, ref escritura, ref elimina);
this.OperacionesDelUsuario();
// cargo en una coleccion los productos por unica vez
BLL.Procedures.H_ARTICULOSDEPOSITO _art = new BLL.Procedures.H_ARTICULOSDEPOSITO();
_articulosItem = _art.ItemList(); //le paso la colección de artículos
//también cargo los rubros por única vez
BLL.Procedures.RUBROARTICULOS _rubro = new BLL.Procedures.RUBROARTICULOS();
_rubrositem = _rubro.ItemList(); //le paso la colección de rubros
//carga los depósitos
CargarDepositos();
//CREO LA COLUMNA DE TIPO BUTTON
DataGridViewDisableButtonColumn column = new DataGridViewDisableButtonColumn();
column.Name = "Fvto";
column.HeaderText = "Fecha Vtos.";
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDetalleIngStock.Columns.Insert((int)Col_Detalle.VTOS, column);
//FIN CREAR COLUMNA
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void agregarColumnasCambiarProd()
{
DataGridViewDisableButtonColumn colBtnCambiar = new DataGridViewDisableButtonColumn();
colBtnCambiar.Name = "colBtnCambiar";
colBtnCambiar.Text = "Cambiar";
colBtnCambiar.UseColumnTextForButtonValue = true;
colBtnCambiar.HeaderText = "";
/*DataGridViewComboBoxColumn colCboCantidad = new DataGridViewComboBoxColumn();
* colCboCantidad.Name = "colCboCantidad";
* colCboCantidad.MaxDropDownItems = 10;
* colCboCantidad.DataSource = null;
* int numero = 0;
* colCboCantidad.ValueType = numero.GetType();
* for (int i = 1; i <= 20; i++)
* {
* colCboCantidad.Items.Add(i);
* }
* colCboCantidad.DataPropertyName="colCboCantidad";*/
DataGridViewTextBoxColumn colTxtCantidad = new DataGridViewTextBoxColumn();
colTxtCantidad.Name = "colTxtCantidad";
colTxtCantidad.HeaderText = "Cantidad";
dgCambiarProd.Columns.Add(colBtnCambiar);
//dgCambiarProd.Columns.Add(colCboCantidad);
dgCambiarProd.Columns.Add(colTxtCantidad);
}
public void Form1_Load(object sender, EventArgs e)
{
DataGridViewCheckBoxColumn column0 =
new DataGridViewCheckBoxColumn();
DataGridViewDisableButtonColumn column1 =
new DataGridViewDisableButtonColumn();
column0.Name = "CheckBoxes";
column1.Name = "Buttons";
dataGridView1.Columns.Add(column0);
dataGridView1.Columns.Add(column1);
dataGridView1.RowCount = 8;
dataGridView1.AutoSize = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
// Set the text for each button.
for (int i = 0; i < dataGridView1.RowCount; i++)
{
dataGridView1.Rows[i].Cells["Buttons"].Value =
"Button " + i.ToString();
}
dataGridView1.CellValueChanged +=
new DataGridViewCellEventHandler(dataGridView1_CellValueChanged);
dataGridView1.CurrentCellDirtyStateChanged +=
new EventHandler(dataGridView1_CurrentCellDirtyStateChanged);
dataGridView1.CellClick +=
new DataGridViewCellEventHandler(dataGridView1_CellClick);
this.Controls.Add(dataGridView1);
}
public void AddGridViewColumns()
{
var directoryColumn = gridView1.Columns["InstallationFolder"];
if (directoryColumn != null)
{
directoryColumn.Visible = false;
}
var registryColumn = gridView1.Columns["RegistryKey"];
if (registryColumn != null)
{
registryColumn.Visible = false;
}
var openColumn = new DataGridViewDisableButtonColumn
{
HeaderText = "Installation Folder",
Name = "OpenDirectory",
UseColumnTextForButtonValue = true,
Text = "Open",
SortMode = DataGridViewColumnSortMode.NotSortable
};
gridView1.Columns.Add(openColumn);
gridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void agregarBotonesDgDetDespacho()
{
DataGridViewDisableButtonColumn colBtnDespachar = new DataGridViewDisableButtonColumn();
colBtnDespachar.Name = "colBtnDespachar";
colBtnDespachar.Text = "Despachar";
colBtnDespachar.UseColumnTextForButtonValue = true;
colBtnDespachar.HeaderText = "Despachar";
grdDetDespacho.Columns.Add(colBtnDespachar);
}
private void agregarBotonesDgDespacho()
{
DataGridViewDisableButtonColumn colBtnDetalle = new DataGridViewDisableButtonColumn();
colBtnDetalle.Name = "colBtnDetalle";
colBtnDetalle.Text = "Ver Detalle";
colBtnDetalle.UseColumnTextForButtonValue = true;
colBtnDetalle.HeaderText = "";
grdDespachos.Columns.Add(colBtnDetalle);
}
void setButtonEnable(bool enable, int column, int row)
{
//DI00使用，HSC4不可以配置
DataGridViewDisableButtonColumn button = (DataGridViewDisableButtonColumn)dataGridView1.Columns[0];
DataGridViewButtonCell vCell = (DataGridViewButtonCell)dataGridView1[column, row];
if (vCell is DataGridViewDisableButtonCell)
{
((DataGridViewDisableButtonCell)vCell).Enabled = enable;
dataGridView1.Invalidate();
}
}
private void createColumn()
{
DataGridViewDisableButtonColumn buttonColumn = new DataGridViewDisableButtonColumn();
buttonColumn.Name = "配置";
DataGridViewTextBoxColumn cellColumn = new DataGridViewTextBoxColumn();
cellColumn.Name = "ID";
dataGridView1.Columns.Add(cellColumn);
dataGridView1.Columns.Add(buttonColumn);
}
private void ServerIndex_Load(object sender, EventArgs e)
{
init = true;
DataGridViewDisableButtonColumn buttonColumn = new DataGridViewDisableButtonColumn();
buttonColumn.Name = "配置";
buttonColumn.HeaderText = "配置";
DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn();
btn.Name = "info";
btn.HeaderText = "详细信息";
DataGridViewTextBoxColumn cellColumn = new DataGridViewTextBoxColumn();
cellColumn.Name = "ID";
cellColumn.HeaderText = "ID";
//DataGridViewTextBoxColumn celltype = new DataGridViewTextBoxColumn();
//celltype.Name = "Mode";
//celltype.HeaderText = "Mode";
buttonColumn.DefaultCellStyle.NullValue = ". . .";
btn.DefaultCellStyle.NullValue = ". . .";
dataGridView1.AllowUserToAddRows = false;
dataGridView1.Columns.Add(cellColumn);
dataGridView1.Columns.Add(buttonColumn);
dataGridView1.Columns.Add(btn);
//dataGridView1.Columns.Add(celltype);
if (dataGridView1.Columns.Count > 3)
{
dataGridView1.Columns.RemoveAt(0);
}
dataGridView1.RowCount = /*8*/ serverDataManager.listServer.Count;
dataGridView1.AutoSize = true;
dataGridView1.AllowUserToAddRows = false;
this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
for (int i = 0; i < serverDataManager.listServer.Count; i++)
{
ModbusServerData data = serverDataManager.listServer.ElementAt(i);
//ModbusServer.DataManager datamanage = serverDataManager;
//ModbusServerData data = serverDataManager.listServer[i];
dataGridView1.Rows[i].Cells["ID"].Value = data.ID;
//dataGridView1.Rows[i].Cells["配置"].Value = "..."/* + i.ToString()*/;
}
}
private void modbusmastermain_Load(object sender, EventArgs e)
{
DataGridViewDisableButtonColumn buttonColumn = new DataGridViewDisableButtonColumn();
buttonColumn.Name = columnConfig;
DataGridViewTextBoxColumn cellColumn = new DataGridViewTextBoxColumn();
cellColumn.Name = "ID";
dataGridView1.Columns.Add(cellColumn);
dataGridView1.Columns.Add(buttonColumn);
dataGridView1.RowCount = /*8*/ 1;
dataGridView1.AutoSize = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
}
private void GridArtigosFormatar()
{
grdArtigos.Columns[0].HeaderText = "Favorito";
grdArtigos.Columns[0].Name = "colFavorito";
grdArtigos.Columns[1].HeaderText = "Código";
grdArtigos.Columns[1].Visible = false;
grdArtigos.Columns[2].HeaderText = "Título";
grdArtigos.Columns[3].HeaderText = "Código Categoria";
grdArtigos.Columns[3].Visible = false;
grdArtigos.Columns[4].HeaderText = "Categoria";
DataGridViewDisableButtonColumn btcVisualizar = new DataGridViewDisableButtonColumn();
btcVisualizar.Name = "btnVisualizar";
btcVisualizar.HeaderText = "Visualizar";
btcVisualizar.UseColumnTextForButtonValue = true;
btcVisualizar.Text = "Visualizar";
DataGridViewDisableButtonColumn btcEditar = new DataGridViewDisableButtonColumn();
btcEditar.Name = "btnEditar";
btcEditar.HeaderText = "Editar";
btcEditar.UseColumnTextForButtonValue = true;
btcEditar.Text = "Editar";
DataGridViewDisableButtonColumn btcExcluir = new DataGridViewDisableButtonColumn();
btcExcluir.Name = "btnExcluir";
btcExcluir.HeaderText = "Excluir";
btcExcluir.UseColumnTextForButtonValue = true;
btcExcluir.Text = "Excluir";
grdArtigos.Columns.Add(btcVisualizar);
grdArtigos.Columns.Add(btcEditar);
grdArtigos.Columns.Add(btcExcluir);
GridArtigosRedimensionar();
}
private void createColumn()
{
DataGridViewDisableButtonColumn buttonColumn = new DataGridViewDisableButtonColumn();
buttonColumn.Name = "配置";
buttonColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
DataGridViewDisableButtonColumn buttonColumnDetail = new DataGridViewDisableButtonColumn();
buttonColumnDetail.Name = "详细信息";
buttonColumnDetail.SortMode = DataGridViewColumnSortMode.NotSortable;
//buttonColumnDetail.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
DataGridViewTextBoxColumn cellColumn = new DataGridViewTextBoxColumn();
cellColumn.Name = "ID";
cellColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns.Add(cellColumn);
dataGridView1.Columns.Add(buttonColumn);
dataGridView1.Columns.Add(buttonColumnDetail);
}
private void IngresoDetalleFacturas_Load(object sender, EventArgs e)
{
//this.dateTimeDesde.Value = Convert.ToDateTime(DateTime.Now.ToShortDateString());
//this.dateTimeHasta.Value = Convert.ToDateTime(DateTime.Now.ToShortDateString());
MenuSistema.Cls_Menus menu = new MenuSistema.Cls_Menus();
menu.ObtenerPermisos(Id_Perfil, Convert.ToInt32(Tag.ToString()), ref lectura, ref escritura, ref elimina);
this.OperacionesDelUsuario();
comboBox1.Items.Add(BarCode.BarCode.Code128SubTypes.CODE128_UCC);
comboBox1.SelectedIndex = comboBox1.FindString("CODE128");
//SETEO LA EMPRESA
if (Clases.Usuario.EmpresaLogeada.EmpresaIngresada.Trim() == "EGES")
{
this.comboBoxcodEmp.SelectedIndex = 0;
CargarProveedores("EGES");
}
else
{
this.comboBoxcodEmp.SelectedIndex = 1;
CargarProveedores("RSC");
}
//carga los depósitos
CargarDepositos();
//CREO LA COLUMNA DE TIPO BUTTON
DataGridViewDisableButtonColumn column = new DataGridViewDisableButtonColumn();
column.Name = "Fvto";
column.HeaderText = "Fecha Vtos.";
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDetalle.Columns.Insert((int)Col_DetalleOC.VTOS, column);
//FIN CREAR COLUMNA
}
private void frmGestionFacturas_Load(object sender, EventArgs e)
{
ucPaginador.PageSize = 10;
ucPaginador.Next.Click += Siguiente;
ucPaginador.Previous.Click += Anterior;
ucPaginador.First.Click += Primero;
ucPaginador.Last.Click += Ultimo;
ucPaginador.PageSizeControl.TextChanged += Actualizar;
var column1 = new DataGridViewDisableButtonColumn {
Width = 22
};
var column2 = new DataGridViewDisableButtonColumn {
Width = 22
};
dgvListado.Columns.Add(column1);
dgvListado.Columns.Add(column2);
dgvListado.Columns[5].DefaultCellStyle.Format = AppSettings.CurrencyColumnFormat;
Actualizar(null, null);
}
public void SetSolrGrid(IEnumerable <ISolrInfo> solrs, bool isRemote)
{
if (solrs == null)
{
return;
}
LoadSolrDropdown();
foreach (var solrUrl in solrs.Select(s => s.Url))
{
comboSolrInstances.Items.Add(solrUrl);
}
comboSolrInstances.Enabled = true;
var source = new BindingSource {
DataSource = solrs
};
dataGrid.Columns.Clear();
dataGrid.Rows.Clear();
dataGrid.Refresh();
dataGrid.AutoGenerateColumns = false;
var version = new DataGridViewTextBoxColumn
{
HeaderText = "Version", DataPropertyName = "Version", ReadOnly = true, Name = "Version", Width = 50,
};
version.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
version.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
var links = new DataGridViewLinkColumn
{
UseColumnTextForLinkValue = false,
Name = "Url",
HeaderText = "URL",
ReadOnly = true,
DataPropertyName = "Url",
ActiveLinkColor = Color.White,
LinkBehavior = LinkBehavior.SystemDefault,
LinkColor = Color.Blue,
TrackVisitedState = true,
VisitedLinkColor = Color.Blue,
AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill,
DefaultCellStyle = { SelectionBackColor = BackColor }
};
var buttons = new DataGridViewDisableButtonColumn
{
HeaderText = "Directory", DataPropertyName = "Directory", Text = "Open", Name = "Directory", Width = 55,
UseColumnTextForButtonValue = true
};
buttons.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGrid.BackgroundColor = Color.White;
dataGrid.RowHeadersVisible = false;
dataGrid.DataSource = source;
dataGrid.Columns.Add(version);
dataGrid.Columns.Add(links);
dataGrid.Columns.Add(buttons);
dataGrid.DataBindingComplete += (sender, args) => { ((DataGridView)sender).ClearSelection(); };
dataGrid.CellClick += CellClick;
dataGrid.CellToolTipTextNeeded += CellToolTipTextNeeded;
dataGrid.Visible = true;
labelSolrGrid.Text = solrs.Any() ? Messages.Profiles.Connectivity.InstancesFound : Messages.Profiles.Connectivity.Errors.InstancesNotFound;
dataGrid.SetButtonColumnEnable(2, !isRemote);
}
/// <summary>
/// 主观质控DataGridView数据绑定
/// </summary>
private void dgvSubjectiveShow()
{
try
{
string strSql = @"select t.id,
t.item 评分项目,
t.item_score 分值,
t.item_content 扣分标准,
a.textname 文书类别,
a.doc_name 文书名称,
a.textkind_id TEXTKIND_ID,
t.ITEM_PATIENTID 病人id,
isxg,
t.medical_mark_id,
docId,
t.item_type,
CASE
WHEN STATE IS NULL THEN
'未修改'
WHEN STATE = 0 THEN
'未修改'
WHEN STATE = 1 THEN
'已修改'
else
'已确认'
end 状态
from t_deduct_score t inner join t_patients_doc a on t.docid=a.tid
where t.ITEM_PATIENTID='" + inpat.Id + "' and t.item_type='Y' order by t.state";
DataSet ds = App.GetDataSet(strSql);
if (ds != null)
{
dgvSubjective.DataSource = ds.Tables[0].DefaultView;
dgvSubjective.Columns["id"].Visible = false;
dgvSubjective.Columns["病人id"].Visible = false;
dgvSubjective.Columns["评分项目"].Width = 100;
dgvSubjective.Columns["分值"].Width = 50;
dgvSubjective.Columns["扣分标准"].Width = 250;
dgvSubjective.Columns["medical_mark_id"].Visible = false;
dgvSubjective.Columns["item_type"].Visible = false;
dgvSubjective.Columns["isxg"].Visible = false;
dgvSubjective.Columns["docId"].Visible = false;
dgvSubjective.Columns["状态"].Visible = false;
dgvSubjective.Columns["文书名称"].Visible = false;
dgvSubjective.Columns["TEXTKIND_ID"].Visible = false;
DataGridViewDisableButtonColumn btn_1 = new DataGridViewDisableButtonColumn();
btn_1.Name = "colBtn_1";
btn_1.HeaderText = "状态";
btn_1.DataPropertyName = "状态";
dgvSubjective.Columns.Add(btn_1);
dgvSubjective.Columns["colBtn_1"].DisplayIndex = 0;
if (type == "D")//医生反馈界面，质控状态为未修改显示确认按钮
{
for (int i = 0; i < dgvSubjective.Rows.Count; i++)
{
if (dgvSubjective.Rows[i].Cells["colBtn_1"].Value.ToString() != "未修改")
{
DataGridViewDisableButtonCell buttonCell = (DataGridViewDisableButtonCell)dgvSubjective.Rows[i].Cells["colBtn_1"];
buttonCell.Enabled = false;
}
}
}
else //质控人接收反馈信息，质控状态为已修改显示确认按钮
{
for (int i = 0; i < dgvSubjective.Rows.Count; i++)
{
if (dgvSubjective.Rows[i].Cells["colBtn_1"].Value.ToString() != "已修改")
{
DataGridViewDisableButtonCell buttonCell = (DataGridViewDisableButtonCell)dgvSubjective.Rows[i].Cells["colBtn_1"];
buttonCell.Enabled = false;
}
}
}
for (int i = 0; i < dgvSubjective.Columns.Count; i++)
{
dgvSubjective.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
}
catch
{
}
}
private void modbusmasterform_Load(object sender, EventArgs e)
{
LocalPLC.Base.xml.DataManageBase baseData = null;
UserControl1.UC.getDataManager(ref baseData);
this.dataGridView1.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;
comboBox_transform_channel.Items.Clear();
foreach (string serialname in baseData.serialDic.Keys)
{
comboBox_transform_channel.Items.Add(serialname);
}
comboBox_transform_channel.SelectedIndex = -1;
textBox_packet_interval.Text = masterData_.packet_interval.ToString();
try
{
DataGridViewTextBoxColumn cellColumnID = new DataGridViewTextBoxColumn();
cellColumnID.Name = "ID";
DataGridViewTextBoxColumn cellColumnName = new DataGridViewTextBoxColumn();
cellColumnName.Name = "名称";
DataGridViewTextBoxColumn cellColumnSlaveAddr = new DataGridViewTextBoxColumn();
cellColumnSlaveAddr.Name = "从站地址";
//DataGridViewTextBoxColumn cellColumnTimeout = new DataGridViewTextBoxColumn();
//cellColumnTimeout.Name = "响应超时(ms)";
DataGridViewTextBoxColumn cellColumnTimeoutCount = new DataGridViewTextBoxColumn();
cellColumnTimeoutCount.Name = "允许的超时次数";
DataGridViewTextBoxColumn cellColumnReconnectInvertal = new DataGridViewTextBoxColumn();
cellColumnReconnectInvertal.Name = "重连间隔";
DataGridViewTextBoxColumn cellColumnResetVariable = new DataGridViewTextBoxColumn();
cellColumnResetVariable.Name = "复位变量";
DataGridViewDisableButtonColumn buttonColumn = new DataGridViewDisableButtonColumn();
buttonColumn.Name = "通道";
//列标题自适应
dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
dataGridView1.Columns.Add(cellColumnID);
dataGridView1.Columns.Add(cellColumnName);
dataGridView1.Columns.Add(cellColumnSlaveAddr);
//dataGridView1.Columns.Add(cellColumnTimeout);
dataGridView1.Columns.Add(cellColumnTimeoutCount);
dataGridView1.Columns.Add(cellColumnReconnectInvertal);
dataGridView1.Columns.Add(cellColumnResetVariable);
dataGridView1.Columns.Add(buttonColumn);
dataGridView1.RowCount = 1 + masterData_.modbusDeviceList.Count;
int i = 0;
foreach (DeviceData devData in masterData_.modbusDeviceList)
{
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.ID].Value = devData.ID;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.NAME].Value = devData.nameDev;
//
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.SLAVE_ADDR].Value = devData.slaveAddr;
//dataGridView1.Rows[i].Cells[(int)COLUMNNAME.REPONSE_TIMEOUT].Value = devData.reponseTimeout;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.PERMIT_TIMEOUT_COUNT].Value = devData.permitTimeoutCount;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.RECONNECT_INTERVAL].Value = devData.reconnectInterval;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.RESET_VARIABLE].Value = devData.resetVaraible;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.CHANNEL].Value = "..." /* + i.ToString()*/;
i++;
}
//dataGridView1.RowCount = /*8*/ 1;
dataGridView1.AutoSize = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
//this.comboBox_transform_channel.Items.Add("COM1");
this.comboBox_transform_channel.Text = masterData_.transformChannel;
this.textBox_reponse_timeout.Text = masterData_.responseTimeout.ToString(); //ms
if (masterData_.transformMode == 0)
{
radioButton1.Checked = true;
radioButton2.Checked = false;
}
else if (masterData_.transformMode == 1)
{
radioButton2.Checked = true;
radioButton1.Checked = false;
}
}
catch (Exception t)
{
MessageBox.Show(t.Message);
return;
}
}
private void modbusmasterform_Load(object sender, EventArgs e)
{
DataGridViewTextBoxColumn cellColumnID = new DataGridViewTextBoxColumn();
cellColumnID.Name = "ID";
DataGridViewTextBoxColumn cellColumnName = new DataGridViewTextBoxColumn();
cellColumnName.Name = "名称";
DataGridViewTextBoxColumn cellColumnSlaveAddr = new DataGridViewTextBoxColumn();
cellColumnSlaveAddr.Name = "从站地址";
DataGridViewTextBoxColumn cellColumnTimeout = new DataGridViewTextBoxColumn();
cellColumnTimeout.Name = "响应超时(ms)";
DataGridViewTextBoxColumn cellColumnTimeoutCount = new DataGridViewTextBoxColumn();
cellColumnTimeoutCount.Name = "允许的超时次数";
DataGridViewTextBoxColumn cellColumnReconnectInvertal = new DataGridViewTextBoxColumn();
cellColumnReconnectInvertal.Name = "重连间隔";
DataGridViewTextBoxColumn cellColumnResetVariable = new DataGridViewTextBoxColumn();
cellColumnResetVariable.Name = "复位变量";
DataGridViewDisableButtonColumn buttonColumn = new DataGridViewDisableButtonColumn();
buttonColumn.Name = "通道";
//列标题自适应
dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
dataGridView1.Columns.Add(cellColumnID);
dataGridView1.Columns.Add(cellColumnName);
dataGridView1.Columns.Add(cellColumnSlaveAddr);
dataGridView1.Columns.Add(cellColumnTimeout);
dataGridView1.Columns.Add(cellColumnTimeoutCount);
dataGridView1.Columns.Add(cellColumnReconnectInvertal);
dataGridView1.Columns.Add(cellColumnResetVariable);
dataGridView1.Columns.Add(buttonColumn);
dataGridView1.RowCount = 1 + data_.modbusDeviceList.Count;
int i = 0;
foreach (DeviceData devData in data_.modbusDeviceList)
{
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.ID].Value = devData.ID;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.NAME].Value = devData.nameDev;
//
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.SLAVE_ADDR].Value = devData.slaveAddr;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.REPONSE_TIMEOUT].Value = devData.reponseTimeout;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.PERMIT_TIMEOUT_COUNT].Value = devData.permitTimeoutCount;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.RECONNECT_INTERVAL].Value = devData.reconnectInterval;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.RESET_VARIABLE].Value = devData.resetVaraible;
dataGridView1.Rows[i].Cells[(int)COLUMNNAME.CHANNEL].Value = "Button " + i.ToString();
i++;
}
//dataGridView1.RowCount = /*8*/ 1;
dataGridView1.AutoSize = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
this.comboBox_transform_channel.Items.Add("COM1");
this.comboBox_transform_channel.Text = data_.transformChannel;
this.textBox_reponse_timeout.Text = data_.responseTimeout.ToString(); //ms
if (data_.transformMode == 0)
{
radioButton1.Checked = true;
radioButton2.Checked = false;
}
else if (data_.transformMode == 1)
{
radioButton2.Checked = true;
radioButton1.Checked = false;
}
}
private void SetGridDataView()
{
_txtCell.Value = "...";
_btnCell.Value = "+++";
inputDataGrid.EditMode = DataGridViewEditMode.EditOnEnter;
inputDataGrid.ReadOnly = false;
inputDataGrid.ColumnCount = 2;
inputDataGrid.Columns[0].Name = "Column Name";
inputDataGrid.Columns[0].ReadOnly = true;
inputDataGrid.Columns[1].Name = "Data Type";
inputDataGrid.Columns[1].ReadOnly = true;
DataGridViewComboBoxColumn randomizerCombo = new DataGridViewComboBoxColumn();
_randomizerSourceInx = 2;
randomizerCombo.HeaderText = "Randomizer Source";
randomizerCombo.Items.AddRange(" ",
string.Join(" ", Regex.Split(enRandomDataType.RandomNamesAndLocations.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomDataType.RandomNumbers.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomDataType.RandomWords.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomDataType.RandomDatesAndTimes.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomDataType.RandomBooleans.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomDataType.CustomRandomValues.ToString(), @"(?<!^)(?=[A-Z])"))
);
randomizerCombo.DropDownWidth = 250;
randomizerCombo.Width = 250;
randomizerCombo.MaxDropDownItems = 15;
randomizerCombo.ReadOnly = false;
inputDataGrid.Columns.Add(randomizerCombo);
DataGridViewComboBoxColumn fieldNameCombo = new DataGridViewComboBoxColumn();
_randomizerFieldInx = 3;
fieldNameCombo.HeaderText = "Random Name Field";
fieldNameCombo.Items.AddRange(" ",
string.Join(" ", Regex.Split(enRandomNameField.NameType.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.Country.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.FirstName.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.MiddleInitial.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.LastName.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.Gender.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.BirthDate.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.AddressLine1.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.AddressLine2.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.City.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.Neighborhood.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.StateProvince.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.ZipPostalCode.ToString(), @"(?<!^)(?=[A-Z])")),
string.Join(" ", Regex.Split(enRandomNameField.StateProvinceName.ToString(), @"(?<!^)(?=[A-Z])"))
);
fieldNameCombo.DropDownWidth = 250;
fieldNameCombo.Width = 250;
fieldNameCombo.MaxDropDownItems = 15;
fieldNameCombo.ReadOnly = false;
inputDataGrid.Columns.Add(fieldNameCombo);
DataGridViewTextBoxColumn txtCol = new DataGridViewTextBoxColumn();
int txtInx = inputDataGrid.Columns.Add(txtCol);
_randomizerFileInx = txtInx;
txtCol.HeaderText = "Randomizer File";
txtCol.Width = 200;
txtCol.Name = "txt";
inputDataGrid.Columns[txtInx].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;
//DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn();
int btnInx = inputDataGrid.Columns.Add(btn);
_lookupButtonInx = btnInx;
btn.HeaderText = "File Lookup";
btn.Text = "...";
btn.DefaultCellStyle.Font = new System.Drawing.Font("Lucida Console", (float)10.0, FontStyle.Bold);
btn.Width = 65;
btn.Name = "btn";
btn.ReadOnly = true;
inputDataGrid.Columns[btnInx].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
btn.UseColumnTextForButtonValue = true;
_previousRandomizerSourceSelectedIndex = new int[_colSpecs.Count];
for (int r = 0; r < _colSpecs.Count; r++)
{
_previousRandomizerSourceSelectedIndex[r] = -1;
string randomDataSource = " ";
if (_colSpecs[r].RandomDataType != enRandomDataType.NotSpecified)
{
randomDataSource = string.Join(" ", Regex.Split(_colSpecs[r].RandomDataType.ToString(), @"(?<!^)(?=[A-Z])"));
}
string[] row;
row = new string[] { _colSpecs[r].DataTableColumnName, _colSpecs[r].DataTableColumnDataType.ToString(), randomDataSource, " ", " " };
int rowInx = inputDataGrid.Rows.Add(row);
DataGridViewDisableButtonCell buttonCell = (DataGridViewDisableButtonCell)inputDataGrid.Rows[rowInx].Cells[_lookupButtonInx];
buttonCell.Enabled = false;
DataGridViewComboBoxCell cboCell = (DataGridViewComboBoxCell)inputDataGrid.Rows[r].Cells[_randomizerFieldInx];
cboCell.Items.Clear();
cboCell.Items.Add(" ");
}
}
public void Form1_Load(object sender, EventArgs e)
{
DataGridViewCheckBoxColumn column0 =
new DataGridViewCheckBoxColumn();
DataGridViewDisableButtonColumn column1 =
new DataGridViewDisableButtonColumn();
DataGridViewComboBoxColumn column2 = new DataGridViewComboBoxColumn();
column2.Items.Add("test1");
column2.Items.Add("test2");
column0.Name = "CheckBoxes";
column1.Name = "Buttons";
column2.Name = "Combobox";
dataGridView1.Columns.Add(column0);
dataGridView1.Columns.Add(column1);
dataGridView1.Columns.Add(column2);
dataGridView1.RowCount = /*8*/ 1;
dataGridView1.AutoSize = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
// Set the text for each button.
int row = dataGridView1.RowCount;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
dataGridView1.Rows[i].Cells["Buttons"].Value =
"Button " + i.ToString();
dataGridView1.Rows[i].Cells["Combobox"].Value = "test2";
}
this.panel1.Controls.Clear();
this.panel1.Controls.Add(dataGridView1);
//dataGridView1.AutoGenerateColumns = true;
//var source = new BindingSource();
////使用List<>泛型集合填充DataGridView
//List<Student> students = new List<Student>();
//Student hat = new Student(true, "12", "Male");
//Student peter = new Student(false, "14", "Male");
//Student dell = new Student(true, "16", "Male");
//Student anne = new Student(false, "19", "Female");
//students.Add(hat);
//students.Add(peter);
//students.Add(dell);
//students.Add(anne);
//source.DataSource = students;
//this.dataGridView1.DataSource = source;
//this.dataGridView1.Refresh();
//dataGridView1.CellValueChanged +=
// new DataGridViewCellEventHandler(dataGridView1_CellValueChanged);
//dataGridView1.CurrentCellDirtyStateChanged +=
// new EventHandler(dataGridView1_CurrentCellDirtyStateChanged);
//dataGridView1.CellClick +=
// new DataGridViewCellEventHandler(dataGridView1_CellClick);
//this.Controls.Add(dataGridView1);
}
private void BindData()
{
//view绑定datatable
dtData = new DataTable();
dtData.Columns.Add("已配置", typeof(bool));
dtData.Columns.Add("变量名", typeof(string));
dtData.Columns.Add("地址", typeof(string));
dtData.Columns.Add("类型");
//dtData.Columns.Add("配置");
dtData.Columns.Add("注释");
//DataRow drData;
//drData = dtData.NewRow();
//drData[0] = 1;
//drData[1] = "HSP0";
//drData[2] = "未配置";
//drData[3] = ""; //类型
////drData[4] = 0; //
////drData[5] = "注释1";
//dtData.Rows.Add(drData);
//drData = dtData.NewRow();
//drData[0] = 2;
//drData[1] = "HSP1";
//drData[2] = "未配置";
//drData[3] = "";
////drData[4] = 0;
////drData[5] = "注释2";
//dtData.Rows.Add(drData);
//drData = dtData.NewRow();
//drData[0] = 1;
//drData[1] = "HSP2";
//drData[2] = "未配置";
//drData[3] = "";
////drData[4] = 0;
//dtData.Rows.Add(drData);
//drData = dtData.NewRow();
//drData[0] = 1;
//drData[1] = "HSP3";
//drData[2] = "未配置";
//drData[3] = "";
////drData[4] = 0;
//dtData.Rows.Add(drData);
this.dataGridView1.DataSource = dtData;
DataGridViewDisableButtonColumn uninstallButtonColumn = new DataGridViewDisableButtonColumn();
uninstallButtonColumn.Name = "配置";
uninstallButtonColumn.Text = "...";
uninstallButtonColumn.FlatStyle = FlatStyle.Standard;
uninstallButtonColumn.CellTemplate.Style.BackColor = Color.White;
uninstallButtonColumn.CellTemplate.Style.SelectionBackColor = Color.White;
uninstallButtonColumn.CellTemplate.Style.ForeColor = Color.Black;
uninstallButtonColumn.CellTemplate.Style.SelectionForeColor = Color.Black;
//uninstallButtonColumn.FlatStyle = FlatStyle.Popup;
//uninstallButtonColumn.DefaultCellStyle.ForeColor = Color.White;
//uninstallButtonColumn.DefaultCellStyle.BackColor = Color.Lavender;
//uninstallButtonColumn.DefaultCellStyle.SelectionBackColor = Color.Lavender;
//uninstallButtonColumn.DefaultCellStyle.SelectionForeColor = Color.White;
//显示按钮文本
uninstallButtonColumn.UseColumnTextForButtonValue = true;
int columnIndex = 4;
if (dataGridView1.Columns["配置"] == null)
{
dataGridView1.Columns.Insert(columnIndex, uninstallButtonColumn);
}
}
public void Form1_Load(object sender, EventArgs e)
{
DataGridViewCheckBoxColumn column0 =
new DataGridViewCheckBoxColumn();
DataGridViewDisableButtonColumn column1 =
new DataGridViewDisableButtonColumn();
column0.Name = "CheckBoxes";
column1.Name = "Buttons";
dataGridView1.Columns.Add(column0);
dataGridView1.Columns.Add(column1);
dataGridView1.RowCount = 8;
dataGridView1.AutoSize = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
// Set the text for each button.
for (int i = 0; i < dataGridView1.RowCount; i++)
{
dataGridView1.Rows[i].Cells["Buttons"].Value =
"Button " + i.ToString();
}
dataGridView1.CellValueChanged +=
new DataGridViewCellEventHandler(dataGridView1_CellValueChanged);
dataGridView1.CurrentCellDirtyStateChanged +=
new EventHandler(dataGridView1_CurrentCellDirtyStateChanged);
dataGridView1.CellClick +=
new DataGridViewCellEventHandler(dataGridView1_CellClick);
this.Controls.Add(dataGridView1);
}
private async Task LadujDzien(DateTime data)
{
var elementList = await _elementService.GetWithFilter(x => EntityFunctions.TruncateTime(x.DataSprzedazy) == data.Date && _dozwoloneLokalizacje.Contains(x.Lokalizacja));
var okulary = await _binocleService.GetWithFilterWithIncludes(x => EntityFunctions.TruncateTime(x.BuyDate) == data.Date && x.Zadatek > 0 && _dozwoloneLokalizacje.Contains(x.Person.Lokalizacja));
var dodatkoweElementy = new List <Element>();
foreach (var okular in okulary)
{
dodatkoweElementy.Add(new Element
{
DataSprzedazy = okular.BuyDate,
Cena = okular.Zadatek,
Ilosc = 1,
Nazwa = $"Zadatek {okular.Person.FirstName} {okular.Person.LastName}",
Lokalizacja = okular.Person.Lokalizacja,
CannotEdit = true,
FormaPlatnosci = okular.FormaPlatnosci
});
}
var dodatkoweDoplaty = new List <Element>();
var doplaty = await _doplataService.GetWithFilterWithIncludes(x => EntityFunctions.TruncateTime(x.DataDoplaty) == data.Date && _dozwoloneLokalizacje.Contains(x.Binocle.Person.Lokalizacja));
foreach (var doplata in doplaty)
{
var person = doplata.Binocle.Person;
dodatkoweDoplaty.Add(new Element
{
DataSprzedazy = doplata.DataDoplaty,
Cena = doplata.Kwota,
Ilosc = 1,
Nazwa = $"Dopłata {person.FirstName} {person.LastName}",
Lokalizacja = person.Lokalizacja,
CannotEdit = true,
FormaPlatnosci = doplata.FormaPlatnosci
});
}
var wyplaty = await _payoutService.GetWithFilter(x => EntityFunctions.TruncateTime(x.CreatedOn) == data.Date && _dozwoloneLokalizacje.Contains(x.Lokalizacja));
var dodatkoweWyplaty = new List <Element>();
foreach (var wyplata in wyplaty)
{
dodatkoweWyplaty.Add(new Element
{
DataSprzedazy = wyplata.CreatedOn,
Cena = wyplata.Amount,
Ilosc = 1,
Nazwa = $"Wypłata: {wyplata.Description}",
Lokalizacja = wyplata.Lokalizacja,
CannotEdit = true,
FormaPlatnosci = FormaPlatnosci.Gotowka
});
}
elementList.AddRange(dodatkoweWyplaty);
elementList.AddRange(dodatkoweElementy);
elementList.AddRange(dodatkoweDoplaty);
dataGridView1.DataSource = elementList;
dataGridView1.Columns["Nazwa"].Width = 240;
dataGridView1.Columns["DataUtworzenia"].Visible = false;
dataGridView1.Columns["ElementId"].Visible = false;
dataGridView1.Columns["CannotEdit"].Visible = false;
dataGridView1.Columns["Lokalizacja"].ReadOnly = true;
dataGridView1.Columns["DataUtworzenia"].HeaderText = "Data zakupu";
dataGridView1.Columns["FormaPlatnosci"].Visible = false;
if (!dataGridView1.Columns.Contains("FormaPlatnosciCombo"))
{
var col = new DataGridViewComboBoxColumn();
col.DataSource = Enum.GetValues(typeof(FormaPlatnosci));
col.ValueType = typeof(FormaPlatnosci);
col.Visible = true;
col.DataPropertyName = "FormaPlatnosci";
col.HeaderText = "Forma";
col.Name = "FormaPlatnosciCombo";
dataGridView1.Columns.Add(col);
}
if (!dataGridView1.Columns.Contains("UsunCol"))
{
DataGridViewButtonColumn col = new DataGridViewDisableButtonColumn();
col.UseColumnTextForButtonValue = true;
col.Visible = true;
col.Text = "Usuń";
col.Name = "UsunCol";
dataGridView1.Columns.Add(col);
}
dataGridView1.Columns["UsunCol"].Visible = true;
dataGridView1.Columns["UsunCol"].HeaderText = "Usuń";
foreach (DataGridViewRow row in dataGridView1.Rows)
{
((DataGridViewDisableButtonCell)row.Cells["UsunCol"]).Enabled = !((Element)row.DataBoundItem).CannotEdit;
((DataGridViewDisableButtonCell)row.Cells["UsunCol"]).ReadOnly = !((Element)row.DataBoundItem).CannotEdit;
}
dataGridView1.Refresh();
var sumaGotowka = elementList.Where(x => x.FormaPlatnosci == FormaPlatnosci.Gotowka).Sum(element => element.Cena * element.Ilosc);
var sumaKarta = elementList.Where(x => x.FormaPlatnosci == FormaPlatnosci.Karta).Sum(element => element.Cena * element.Ilosc);
var sumaWyplatDzien = dodatkoweWyplaty.Sum(x => x.Cena);
label3.Text = (sumaGotowka - sumaWyplatDzien).ToString(); // Nie bierzemy wypłat pod uwagę w podsumowaniu
label10.Text = sumaKarta.ToString();
label11.Text = (sumaKarta + sumaGotowka - sumaWyplatDzien).ToString();
}
