private void button1_Click(object sender, EventArgs e)
{
try
{
MySqlConnection myConn = new MySqlConnection();
myConn.Host = "192.168.69.8";
myConn.Port = 3306;
myConn.UserId = "cody";
myConn.Password = "******";
myConn.Open();
MySqlCommand myCommand = new MySqlCommand(" SELECT * FROM registration.regUser ;", myConn);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
myDataAdapter.SelectCommand = myCommand;
DataTable dbDataSet = new DataTable();
myDataAdapter.Fill(dbDataSet);
BindingSource bSource = new BindingSource();
bSource.DataSource = dbDataSet;
dataGridView1.DataSource = bSource;
myDataAdapter.Update(dbDataSet);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public HistoryPresenterModel(IUnitInfoDatabase database)
{
if (database == null) throw new ArgumentNullException("database");
_database = database;
Debug.Assert(_database.Connected);
_queryList = new List<QueryParameters>();
_queryList.Add(new QueryParameters());
_queryList.Sort();
_queryBindingSource = new BindingSource();
_queryBindingSource.DataSource = _queryList;
_queryBindingSource.CurrentItemChanged += (s, e) =>
{
OnPropertyChanged("EditAndDeleteButtonsEnabled");
_currentPage = 1;
ResetBindings(true);
};
_historyList = new HistoryEntrySortableBindingList();
_historyList.Sorted += (s, e) =>
{
SortColumnName = e.Name;
SortOrder = e.Direction;
};
_historyBindingSource = new BindingSource();
_historyBindingSource.DataSource = _historyList;
_page = new PetaPoco.Page<HistoryEntry> { Items = new List<HistoryEntry>() };
}
public void SetDataSource(System.Windows.Forms.BindingSource dataSrc)
{
this.myDataSource = dataSrc;
data.baseDS.stockCodeDataTable tbl = (data.baseDS.stockCodeDataTable) this.myDataSource.DataSource;
this.bizSectorLb.DataBindings.Clear();
this.bizSectorLb.DataBindings.Add(new System.Windows.Forms.Binding("myItemString", this.myDataSource, tbl.bizSectorsColumn.ColumnName, true));
}
private void Cliente_Load(object sender, EventArgs e)
{
cmbTipo.DataSource = _billData.GetIdentificationType();
cmbTipo.ValueMember = "Id";
cmbTipo.DisplayMember = "Description";
if (cmbTipo.Items.Count > 0)
{
cmbTipo.SelectedIndex = 0;
}
else
{
MessageBox.Show("Error - revise la configuración del sistema");
}
BindingSource clientSource = new BindingSource();
clientSource.DataSource = new List<ClientModel>();
dtgCliente.DataSource = clientSource;
((DataGridViewComboBoxColumn)dtgCliente.Columns["TypeList"])
.DataSource = _billData.GetIdentificationType();
((DataGridViewComboBoxColumn)dtgCliente.Columns["TypeList"])
.DisplayMember = "Description";
((DataGridViewComboBoxColumn)dtgCliente.Columns["TypeList"])
.ValueMember = "Id";
((DataGridViewComboBoxColumn)dtgCliente.Columns["TypeList"])
.DataPropertyName = "IdIdentificationType";
}
private void AddEscada(int code)
{
System.Windows.Forms.BindingSource escadaSucesso;
Igrejafont10DataSetTableAdapters.EscadaSucessoTableAdapter escadaTableAdapter;
escadaSucesso = new System.Windows.Forms.BindingSource(this.components);
((System.ComponentModel.ISupportInitialize)(escadaSucesso)).BeginInit();
escadaSucesso.DataMember = "EscadaSucesso";
escadaSucesso.DataSource = this.igrejafont10DataSet;
((System.ComponentModel.ISupportInitialize)(escadaSucesso)).EndInit();
escadaTableAdapter = new GerenciamentoCelulas.Igrejafont10DataSetTableAdapters.EscadaSucessoTableAdapter();
escadaTableAdapter.ClearBeforeFill = true;
GerenciamentoCelulas.Igrejafont10DataSet.EscadaSucessoRow newmember = igrejafont10DataSet.EscadaSucesso.NewEscadaSucessoRow();
newmember.Codigo = code;
newmember.OracaoEntrega = "";
newmember.DecisaoIgreja = "";
newmember.Discipulado = "";
newmember.PreEncontro = "";
newmember.Encontro = "";
newmember.PosEncontro = "";
newmember.Encontreiro = "";
newmember.Batismo = "";
newmember.EM = "";
newmember.DizimosOfertas = "";
newmember.CasamentoLegal = "";
newmember.TADEL = "";
newmember.MDA2 = "";
newmember.TLC = "";
newmember.CoLider = "";
igrejafont10DataSet.EscadaSucesso.Rows.Add(newmember);
escadaSucesso.EndEdit();
escadaTableAdapter.Update(igrejafont10DataSet.EscadaSucesso);
}
public void UpdateGridViewConsultas()
{
List <AgendamentoConsultaGridView> consultasAgendadas = new List <AgendamentoConsultaGridView>();
conn.Open();
com.Connection = conn;
SqlCommand cmd = new SqlCommand("select agendamento.dataProximaConsulta, agendamento.horaProximaConsulta, p.Nome, p.Nif from AgendamentoConsulta agendamento INNER JOIN Paciente p ON agendamento.IdPaciente = p.IdPaciente WHERE agendamento.IdEnfermeiro = " + enfermeiro.IdEnfermeiro + " AND agendamento.dataProximaConsulta = '" + dataConsulta.Value.ToString("MM/dd/yyyy") + "' AND ConsultaRealizada= 0 ORDER BY agendamento.horaProximaConsulta", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string dataConsulta = DateTime.ParseExact(reader["dataProximaConsulta"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
AgendamentoConsultaGridView agendamento = new AgendamentoConsultaGridView
{
dataProximaConsulta = dataConsulta,
horaProximaConsulta = (string)reader["horaProximaConsulta"],
NomePaciente = (string)reader["Nome"],
NifPaciente = Convert.ToInt32(reader["Nif"]),
};
consultasAgendadas.Add(agendamento);
}
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = consultasAgendadas
};
dataGridViewConsultas.DataSource = bindingSource1;
dataGridViewConsultas.Columns[0].HeaderText = "Hora Consulta";
dataGridViewConsultas.Columns[1].HeaderText = "Data Consulta";
dataGridViewConsultas.Columns[2].HeaderText = "Nome Utente";
dataGridViewConsultas.Columns[3].HeaderText = "Nif Paciente";
conn.Close();
}
public frmSales()
{
InitializeComponent();
bsSales = new BindingSource();
dgvSales.AutoGenerateColumns = false;
BindSalesData();
}
private void button1_Click(object sender, EventArgs e)
{
System.Windows.Forms.BindingSource membros;
Igrejafont10DataSetTableAdapters.Membros1TableAdapter membrosTableAdapter1;
membros = new System.Windows.Forms.BindingSource(this.components);
((System.ComponentModel.ISupportInitialize)(membros)).BeginInit();
membros.DataMember = "Membros1";
membros.DataSource = this.igrejafont10DataSet;
((System.ComponentModel.ISupportInitialize)(membros)).EndInit();
membrosTableAdapter1 = new GerenciamentoCelulas.Igrejafont10DataSetTableAdapters.Membros1TableAdapter();
membrosTableAdapter1.ClearBeforeFill = true;
membrosTableAdapter1.Fill(igrejafont10DataSet.Membros1);
membros.Position = membros.Find("Codigo", dataGridView.CurrentRow.Cells[0].Value.ToString());
DataRowView row = (DataRowView)membros.Current;
row["Celula"] = "0";
membros.EndEdit();
membrosTableAdapter1.Update(igrejafont10DataSet.Membros1);
membrosTableAdapter.FillBy(igrejafont10DataSet.Membros);
FiltraMembros();
}
public void HienthiDataGridview(System.Windows.Forms.DataGridView dg, System.Windows.Forms.BindingNavigator bn,
TextBox txtMaSp, TextBox txtTenSp, ComboBox cmbDVT, NumericUpDown numSL, NumericUpDown numDonGiaNhap, NumericUpDown numGiaBanSi, NumericUpDown numGiaBanLe)
{
System.Windows.Forms.BindingSource bs = new System.Windows.Forms.BindingSource();
bs.DataSource = factory.DanhsachSanPham();
txtMaSp.DataBindings.Clear();
txtMaSp.DataBindings.Add("Text", bs, "ID");
txtTenSp.DataBindings.Clear();
txtTenSp.DataBindings.Add("Text", bs, "TEN_SAN_PHAM");
cmbDVT.DataBindings.Clear();
cmbDVT.DataBindings.Add("SelectedValue", bs, "ID_DON_VI_TINH");
numSL.DataBindings.Clear();
numSL.DataBindings.Add("Value", bs, "SO_LUONG");
numDonGiaNhap.DataBindings.Clear();
numDonGiaNhap.DataBindings.Add("Value", bs, "DON_GIA_NHAP");
numGiaBanSi.DataBindings.Clear();
numGiaBanSi.DataBindings.Add("Value", bs, "GIA_BAN_SI");
numGiaBanLe.DataBindings.Clear();
numGiaBanLe.DataBindings.Add("Value", bs, "GIA_BAN_LE");
bn.BindingSource = bs;
dg.DataSource = bs;
}
private void UpdateDataGridViewAvaliacaoObjetivoBebe()
{
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = listaAvaliacaoObjetivaBebe
};
dataGridViewAvaliacaoObjetivaBebe.DataSource = bindingSource1;
dataGridViewAvaliacaoObjetivaBebe.Columns[0].HeaderText = "Data da Avaliação Objetiva";
dataGridViewAvaliacaoObjetivaBebe.Columns[1].HeaderText = "Peso (KG)";
dataGridViewAvaliacaoObjetivaBebe.Columns[2].HeaderText = "Altura (cm)";
dataGridViewAvaliacaoObjetivaBebe.Columns[3].HeaderText = "Pressão Arterial";
dataGridViewAvaliacaoObjetivaBebe.Columns[4].HeaderText = "Temperatura";
dataGridViewAvaliacaoObjetivaBebe.Columns[5].HeaderText = "Saturação Oxigénio";
dataGridViewAvaliacaoObjetivaBebe.Columns[6].HeaderText = "INR";
dataGridViewAvaliacaoObjetivaBebe.Columns[7].HeaderText = "Perimetro (cm)";
dataGridViewAvaliacaoObjetivaBebe.Columns[8].HeaderText = "Tipo de Aleitamento";
dataGridViewAvaliacaoObjetivaBebe.Columns[9].HeaderText = "Nome Leite Artificial";
dataGridViewAvaliacaoObjetivaBebe.Columns[10].HeaderText = "Tipo de Parto";
dataGridViewAvaliacaoObjetivaBebe.Columns[11].HeaderText = "Parto Distócico";
dataGridViewAvaliacaoObjetivaBebe.Columns[12].HeaderText = "Epidural";
dataGridViewAvaliacaoObjetivaBebe.Columns[13].HeaderText = "Episiotomia";
dataGridViewAvaliacaoObjetivaBebe.Columns[14].HeaderText = "Reanimação Fetal";
dataGridViewAvaliacaoObjetivaBebe.Columns[15].HeaderText = "Índice APGAR";
dataGridViewAvaliacaoObjetivaBebe.Columns[16].HeaderText = "Fototerapia";
dataGridViewAvaliacaoObjetivaBebe.Columns[17].HeaderText = "Observações";
dataGridViewAvaliacaoObjetivaBebe.Columns[18].HeaderText = "IMC";
}
private void Form1_Load(object sender, EventArgs e)
{
viewPorts = new BindingSource();
windows = new BindingSource();
viewPorts.DataSource = typeof(ViewPort);
windows.DataSource = typeof(ViewPortForm);
if (File.Exists(configFile))
{
loadedCfg = Helpers.LoadConfig(configFile);
viewPorts.DataSource = (BindingList<ViewPort>)loadedCfg.ViewPorts;
}
else
{// should move this to helper
MessageBox.Show(configFile + " not found! Please create a config File", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button1
, MessageBoxOptions.ServiceNotification);
this.Close();
}
foreach (ViewPort vp in viewPorts)
{
ViewPortForm vpWindow = new ViewPortForm(vp);
vpWindow.Size = new Size(vp.SizeX, vp.SizeY);
vpWindow.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
vpWindow.Text = vp.Name;
vpWindow.Show();
vpWindow.DesktopLocation = new Point(vp.ScreenPositionX, vp.ScreenPositionY);
windows.Add(vpWindow);
}
}
public Cliente()
{
InitializeComponent();
bindingSource = new System.Windows.Forms.BindingSource();
this.bindingSource.DataSource = socioNegocio;
asignarDataBinding(this);
}
private void create()
{
this.FormClosing += this.Form1_FormClosing;
this.bindingSource1 = new BindingSource(this.components);
this.dataSource = new List <Props>( )
{
new Props("prop0", "value0"),
new Props("prop1", "value1"),
new Props("prop2", "value2"),
new Props("prop3", "value3"),
new Props("prop0", "value0"),
new Props("prop1", "value1"),
new Props("prop2", "value2"),
new Props("prop3", "value3"),
};
//
this.SuspendLayout( );
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit( );
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).BeginInit( );
((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).BeginInit( );
{
this.bindingSource1.DataSource = typeof(Props);
this.bindingSource1.Add(this.dataSource);
this.createLayoutControl( );
}
((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).EndInit( );
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).EndInit( );
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).EndInit( );
this.ResumeLayout(false);
this.PerformLayout( );
}
//void bs_AddingNew(object sender, AddingNewEventArgs e)
//{
// // check if client full name already exists
// if (((List<Client>)(bs.DataSource)).
// Any(x => x.FullName == ((Client)(e.NewObject)).FullName))
// {
// }
//}
public void SetCmbBoxBindingSrc(List<Client> clients)
{
bs = new BindingSource(clients, null);
// bs.AddingNew += new AddingNewEventHandler(bs_AddingNew);
//bs.
cmbBox_existingClients.DisplayMember = "FullName";
}
public override void CargarDatos()
{
//Cheques = d.GetDataTable(d.GetChequesConSaldo());
this.LlenarCheques();
string dato = "";
string factura = "";
if (empresas.SelectedValue != null)
{
dato = empresas.SelectedValue.ToString();
}
if (txtFactura.Text != "")
{
factura = " and ( comprobante like '" + txtFactura.Text + "' or comprobanterelacion like '" + txtFactura.Text + "')" ;
}
if (dato != "0" && dato != null && dato != "")
{
dato = " and id_Cliente = " + dato;
b = d.GetData("Select * From (Select C.id,id_transaccion,fecha,modopago, tipotransaccion, id_cliente, tipocomprobante, comprobante, tipocomprobanterelacion ,comprobanterelacion, detalle, ingreso, egreso, nrocheque, bancocheque,fechapago as fechapagocheque, id_cheque from CuentaCorriente C left outer join Cheque Ch on ch.id = c.id_cheque where tipoctacte = 1 Union All Select 0 as id,id_transaccion,fecha,modopago, 1 as tipotransaccion, proveedor as ID_Cliente,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, importe + iva as Ingreso, 0 as egreso, '' as nrocheque, null as bancocheque, '' as fechapagocheque,null as id_cheque from Compra Union All Select 0 as id,id_transaccion,fecha,modopago, 7 as tipotransaccion, proveedor as ID_Cliente,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, importe + iva as Ingreso, 0 as egreso, '' as nrocheque, null as bancocheque, '' as fechapagocheque, null as id_cheque from Gasto Union All Select 0 as id,id_transaccion,fecha,modopago, 9 as tipotransaccion, proveedor as ID_Cliente,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, importe + iva as Ingreso, 0 as egreso, '' as nrocheque, null as bancocheque, '' as fechapagocheque, null as id_cheque from Inversion ) where 1=1 " + dato + Fecha("and", "=", "") + factura + " order by fecha desc", MaxRecords, MinimoRecord);
}
else
{
dato = "";
b = d.GetData("Select * From (Select C.id,id_transaccion,fecha,modopago, tipotransaccion, id_cliente, tipocomprobante, comprobante, tipocomprobanterelacion ,comprobanterelacion, detalle, ingreso, egreso, nrocheque, bancocheque,fechapago as fechapagocheque, id_cheque from CuentaCorriente C left outer join Cheque Ch on ch.id = c.id_cheque where tipoctacte = 1 Union All Select 0 as id,id_transaccion,fecha,modopago, 1 as tipotransaccion, proveedor as ID_Cliente,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, importe + iva as Ingreso, 0 as egreso, '' as nrocheque, null as bancocheque, '' as fechapagocheque , null as id_cheque from Compra Union All Select 0 as id,id_transaccion,fecha,modopago, 7 as tipotransaccion, proveedor as ID_Cliente,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, importe + iva as Ingreso, 0 as egreso, '' as nrocheque, null as bancocheque, '' as fechapagocheque, null as id_cheque from Gasto Union All Select 0 as id,id_transaccion,fecha,modopago, 9 as tipotransaccion, proveedor as ID_Cliente,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, importe + iva as Ingreso, 0 as egreso, '' as nrocheque, null as bancocheque, '' as fechapagocheque, null as id_cheque from Inversion) where 1=1 " + Fecha("and", "=", "") + factura + " order by fecha desc", MaxRecords, MinimoRecord);
}
string saldoQuery = "Select sum(ingreso) -sum(egreso) as saldo From (Select id,id_transaccion,fecha,modopago, tipotransaccion, id_cliente, tipocomprobante, comprobante, detalle, ingreso, egreso,comprobanterelacion from CuentaCorriente where tipoctacte = 1 Union All Select 0 as id,id_transaccion,fecha,modopago, 1 as tipotransaccion, proveedor as ID_Cliente,tipocomprobante, comprobante, detalle, importe + iva as Ingreso, 0 as egreso, null as comprobanterelacion from Compra Union All Select 0 as id,id_transaccion,fecha,modopago, 7 as tipotransaccion, proveedor as ID_Cliente,tipocomprobante, comprobante, detalle, importe + iva as Ingreso, 0 as egreso, null as comprobanterelacion from Gasto Union All Select 0 as id,id_transaccion,fecha,modopago, 1 as tipotransaccion, proveedor as ID_Cliente,tipocomprobante, comprobante, detalle, importe + iva as Ingreso, 0 as egreso,null as comprobanterelacion from Inversion) where id_cliente in (Select id from empresa where tipoempresa = 1) " + Fecha("and", "<=", "") + dato + factura;
DataSet ds = d.GetDataSet(saldoQuery);
saldo.Text = ds.Tables[0].Rows[0]["saldo"].ToString();
dataGridView1.DataSource = b;
}
private void FormGrid_Load(object sender, EventArgs e)
{
this.bindingSource = new System.Windows.Forms.BindingSource();
this.bindingSource.DataMember = "Estoque";
this.bindingSource.DataSource = this.dsEstoque;
this.dataGrid1.DataSource = this.bindingSource;
}
public OknoGlowne()
{
InitializeComponent();
Dane = new DataTable();
for (int i = 0; i < 80; i++) Dane.Columns.Add();
//Dane.Columns.
for (int i = 0; i < 79; i++) Dane.Rows.Add();
Mapa.RowTemplate.Height = 5;
BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = Dane;
Mapa.DataSource = bindingSource;
for (int i = 0; i < 80; i++) Mapa.Columns[i].Width = 5;
BaudRateBox.Items.Add("250000");
BaudRateBox.Items.Add("9600");
BaudRateBox.SelectedIndex = 0;
COMPortBox.Items.Add("COM7");
COMPortBox.SelectedIndex = 0;
USART.BaudRate = 250000;
USART.PortName = "COM7";
}
private void UpdateDataGridView()
{
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = listaTratamentosAnteriores
};
dataGridViewTratamentos.DataSource = bindingSource1;
dataGridViewTratamentos.Columns[0].HeaderText = "Data do Tratamento";
dataGridViewTratamentos.Columns[1].HeaderText = "Nome do Tratamento";
dataGridViewTratamentos.Columns[2].HeaderText = "Número do Tratamento";
dataGridViewTratamentos.Columns[3].HeaderText = "Dimensões";
dataGridViewTratamentos.Columns[4].HeaderText = "Grau Úlcera Pressao";
dataGridViewTratamentos.Columns[5].HeaderText = "Tipo Exsudado";
dataGridViewTratamentos.Columns[6].HeaderText = "Quantidade Exsudado";
dataGridViewTratamentos.Columns[7].HeaderText = "Cheiro Exsudado";
dataGridViewTratamentos.Columns[8].HeaderText = "Tecido Predominante";
dataGridViewTratamentos.Columns[9].HeaderText = "Área Circundante";
dataGridViewTratamentos.Columns[10].HeaderText = "Agente de Limpeza";
dataGridViewTratamentos.Columns[11].HeaderText = "Ferida";
dataGridViewTratamentos.Columns[12].HeaderText = "Área Circundante";
dataGridViewTratamentos.Columns[13].HeaderText = "Penso";
dataGridViewTratamentos.Columns[14].HeaderText = "Tamanho Penso";
dataGridViewTratamentos.Columns[15].HeaderText = "Suporte Penso";
dataGridViewTratamentos.Columns[16].HeaderText = "Observações";
dataGridViewTratamentos.Columns[17].HeaderText = "Próximo Tratamento";
dataGridViewTratamentos.Columns[18].HeaderText = "Escala da Dor";
dataGridViewTratamentos.Columns[19].HeaderText = "Tipo de Queimadura";
dataGridViewTratamentos.Columns[20].HeaderText = "IPTB";
dataGridViewTratamentos.Columns[21].HeaderText = "Tipo de Úlcera";
}
private void btnRetirarProdutoLista_Click(object sender, EventArgs e)
{
if (listaProdutosConsulta.Count > 0)
{
int i = dataGridViewProdutosConsulta.CurrentCell.RowIndex;
VerProdutosConsulta listar = null;
foreach (var produto in listaProdutos)
{
// var sad = dataGridViewEncomenda.Rows[i].Cells[4];
if (produto.id == Convert.ToInt32(dataGridViewProdutosConsulta.Rows[i].Cells[2].Value.ToString()))
{
listar = produto;
}
}
foreach (var item in listaProdutosConsulta)
{
if (listar != null && listar.id == item.id)
{
listar = item;
}
}
listaProdutosConsulta.Remove(listar);
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = listaProdutosConsulta
};
dataGridViewProdutosConsulta.DataSource = bindingSource1;
}
}
private void verExcisoes()
{
TratamentoExcisoes tratamentoExcisoes = new TratamentoExcisoes();
conn.Open();
com.Connection = conn;
SqlCommand cmd = new SqlCommand("select excisoes.data, excisoes.numeroTratamento, excisoes.corpoEstranho, excisoes.dermica, excisoes.Observacoes, excisoes.dataProximoTratamento from TratamentoExcisoes excisoes JOIN Paciente pac ON excisoes.IdPaciente = pac.IdPaciente WHERE excisoes.IdPaciente = @IdPaciente ORDER By excisoes.data asc", conn);
cmd.Parameters.AddWithValue("@IdPaciente", paciente.IdPaciente);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tratamentoExcisoes = new TratamentoExcisoes
{
dataTratamento = Convert.ToDateTime(reader["data"]),
nrTratamento = ((reader["numeroTratamento"] == DBNull.Value) ? null : (int?)reader["numeroTratamento"]),
corpoEstranho = ((reader["corpoEstranho"] == DBNull.Value) ? "" : (string)reader["corpoEstranho"]),
dermica = ((reader["dermica"] == DBNull.Value) ? "" : (string)reader["dermica"]),
Observacoes = ((reader["Observacoes"] == DBNull.Value) ? "" : (string)reader["Observacoes"]),
dataProximoTratamento = (reader["dataProximoTratamento"].ToString() == "" ? "" : DateTime.ParseExact(reader["dataProximoTratamento"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy")),
};
listaExcisoes.Add(tratamentoExcisoes);
}
conn.Close();
UpdateDataGridViewExcisoes();
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = listaExcisoes
};
dataGridViewTratamentoExcisoes.DataSource = bindingSource1;
}
public ArticleModifierPresenter(IArticleModifierView view)
{
_view = view;
listeArticlesToDisplay.AddRange(listeArticles);
source = new BindingSource(listeArticlesToDisplay, null);
}
private void button11_Click(object sender, EventArgs e)
{
string con = "server=Crazyboy-PC;Initial Catalog=master;Integrated Security=SSPI";
string sql = "select Cbill,Cstyle,Csum,Ctime,CID,Gno from cash where Ctime='" + dateTimePicker2.Text.ToString() + "'";
SqlConnection mycon = new SqlConnection(con);
SqlCommand cmd = new SqlCommand(sql, mycon);
if (mycon.State == ConnectionState.Closed)
mycon.Open();
SqlDataReader dr = cmd.ExecuteReader();
dataGridView1.DataSource = 0;
if (dr.HasRows)
{
BindingSource bs = new BindingSource();
bs.DataSource = dr;
this.dataGridView1.DataSource = bs;
dataGridView1.Columns[0].HeaderCell.Value = "账单号";
dataGridView1.Columns[1].HeaderCell.Value = "消费类型";
dataGridView1.Columns[2].HeaderCell.Value = "消费金额";
dataGridView1.Columns[3].HeaderCell.Value = "消费时间";
dataGridView1.Columns[4].HeaderCell.Value = "收银员";
dataGridView1.Columns[5].HeaderCell.Value = "客房号";
}
mycon.Close();
//关闭连接并释放资源
if (ConnectionState.Open == mycon.State)
{
mycon.Close();
}
mycon.Dispose();
}
public void UpdateDataGridView()
{
try
{
episiotomia.Clear();
conn.Open();
com.Connection = conn;
SqlCommand cmd = new SqlCommand("select data, fev, fvc, fr, caracteristicaSuperficial, caracteristicaProfunda, caracteristicaAdbominal, caracteristicaToracica, caracteristicaMista, escalaDor, observacoes from Episiotomia ORDER BY data asc", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string data = DateTime.ParseExact(reader["data"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
Episiotomia esp = new Episiotomia
{
dataEpisiotomia = data,
fev = ((reader["fev"] == DBNull.Value) ? "" : (string)reader["fev"]),
fvc = ((reader["fvc"] == DBNull.Value) ? "" : (string)reader["fvc"]),
numerofr = ((reader["fr"] == DBNull.Value) ? null : (int?)reader["fr"]),
superficial = ((reader["caracteristicaSuperficial"] == DBNull.Value) ? "" : (string)reader["caracteristicaSuperficial"]),
profunda = ((reader["caracteristicaProfunda"] == DBNull.Value) ? "" : (string)reader["caracteristicaProfunda"]),
abdominal = ((reader["caracteristicaAdbominal"] == DBNull.Value) ? "" : (string)reader["caracteristicaAdbominal"]),
toracica = ((reader["caracteristicaToracica"] == DBNull.Value) ? "" : (string)reader["caracteristicaToracica"]),
mista = ((reader["caracteristicaMista"] == DBNull.Value) ? "" : (string)reader["caracteristicaMista"]),
escalaDor = ((reader["escalaDor"] == DBNull.Value) ? "" : (string)reader["escalaDor"]),
observacoes = ((reader["observacoes"] == DBNull.Value) ? "" : (string)reader["observacoes"]),
};
episiotomia.Add(esp);
}
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = episiotomia
};
dataGridViewEspirometria.DataSource = bindingSource1;
dataGridViewEspirometria.Columns[0].HeaderText = "Data da Episiotomia";
dataGridViewEspirometria.Columns[1].HeaderText = "FEV";
dataGridViewEspirometria.Columns[2].HeaderText = "FVC";
dataGridViewEspirometria.Columns[3].HeaderText = "FR";
dataGridViewEspirometria.Columns[4].HeaderText = "Característica Superficial";
dataGridViewEspirometria.Columns[5].HeaderText = "Característica Profunda";
dataGridViewEspirometria.Columns[6].HeaderText = "Característica Abdominal";
dataGridViewEspirometria.Columns[7].HeaderText = "Característica Toracica";
dataGridViewEspirometria.Columns[8].HeaderText = "Característica Mista";
dataGridViewEspirometria.Columns[9].HeaderText = "Dor";
dataGridViewEspirometria.Columns[10].HeaderText = "Observações";
conn.Close();
dataGridViewEspirometria.Update();
dataGridViewEspirometria.Refresh();
}
catch (Exception)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
MessageBox.Show("Por erro interno é impossível visualizar os dados!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Book(DataTable table)
: this()
{
BindingSource bs = new BindingSource();
bs.DataSource = table;
dgvBook.DataSource = bs;
dgvBook.Columns["ID"].Visible = false;
dgvBook.Columns["Name"].HeaderText = "Наименование";
// Автозаполнение только для одной колонки, в будущем возможно потребуется сделать для всех (в цикле)
dgvBook.Columns["Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
if (dgvBook.Columns.Contains("IconPath"))
dgvBook.Columns["IconPath"].HeaderText = "Иконка";
// Только для справочника Осадки, добавление колонки с кнопкой
// TODO: 2014-08-30 Disable ToolTip for buttons
var buttonColumn = new DataGridViewButtonColumn();
buttonColumn.Name = "SelectIconBtn";
buttonColumn.HeaderText = string.Empty;
buttonColumn.Width = 22;
buttonColumn.UseColumnTextForButtonValue = true;
buttonColumn.Text = "...";
if (table.TableName == "fallout")
{
dgvBook.Columns.Add(buttonColumn);
}
dgvBook.CellContentClick += dgvBook_CellContentClick;
}
public void SetDataSource(System.Windows.Forms.BindingSource dataSrc)
{
this.myDataSource = dataSrc;
data.baseDS.stockCodeDataTable tbl = (data.baseDS.stockCodeDataTable) this.myDataSource.DataSource;
this.codeEd.DataBindings.Clear();
this.codeEd.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.myDataSource, tbl.codeColumn.ColumnName, true));
this.enNameEd.DataBindings.Clear();
this.enNameEd.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.myDataSource, tbl.nameColumn.ColumnName, true));
this.nameEd.DataBindings.Clear();
this.nameEd.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.myDataSource, tbl.nameEnColumn.ColumnName, true));
this.addressEd1.DataBindings.Clear();
this.addressEd1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.myDataSource, tbl.address1Column.ColumnName, true));
this.addressEd2.DataBindings.Clear();
this.addressEd2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.myDataSource, tbl.address2Column.ColumnName, true));
this.phoneEd.DataBindings.Clear();
this.phoneEd.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.myDataSource, tbl.phoneColumn.ColumnName, true));
this.faxEd.DataBindings.Clear();
this.faxEd.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.myDataSource, tbl.faxColumn.ColumnName, true));
this.emailEd.DataBindings.Clear();
this.emailEd.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.myDataSource, tbl.emailColumn.ColumnName, true));
this.websiteEd.DataBindings.Clear();
this.websiteEd.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.myDataSource, tbl.websiteColumn.ColumnName, true));
this.countryCb.DataBindings.Clear();
this.countryCb.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.myDataSource, tbl.countryColumn.ColumnName, true));
}
public void TestBook()
{
try
{
DBManager manager1 = new DBManager();
SqlConnection connection = manager1.Connection();
string seletQuery = "select * from Books Order by Name";
SqlCommand selectCmd = new SqlCommand(seletQuery, connection);
connection.Open();
SqlDataAdapter myAdapter = new SqlDataAdapter();
myAdapter.SelectCommand = selectCmd;
dt = new DataTable();
myAdapter.Fill(dt);
BindingSource bSource = new BindingSource();
bSource.DataSource = dt;
dataGridView1.DataSource = dt;
myAdapter.Update(dt);
//return null;
}
catch (Exception obj)
{
throw new Exception("Error", obj);
}
}
public void CargarDatos(object oDatos)
{
this.oBinding = new BindingSource(oDatos, "");
this.dgvListado.DataSource = null;
this.dgvListado.DataSource = this.oBinding;
this.dgvListado.AutoResizeColumns();
}
private void afiseazaStudentiCazati(object sender, EventArgs e)
{
int nr = Convert.ToInt32(textBox3.Text);
double min = Convert.ToDouble(textBox4.Text);
double max = Convert.ToDouble(textBox5.Text);
List<FisaCazare> fise = new List<FisaCazare>();
foreach (DataRowView drv in studentiBindingSource.List)
{
int suma = 0;
int n = 0;
foreach (DataRow dr in databaseDataSet.Tables[1].Rows)
if (drv["Nr_matricol"].ToString().Equals(dr["Nr_matricol"].ToString()))
{
suma += Convert.ToInt32(dr["Nota"].ToString());
n++;
}
FisaCazare fisa = new FisaCazare(drv["Nume"].ToString(), drv["Prenume"].ToString(), drv["Facultate"].ToString(), Convert.ToInt32(drv["An"].ToString()), Math.Round((double)suma / n,2));
fise.Add(fisa);
}
List<FisaCazare> SortedList = fise.OrderByDescending(o => o.Medie).ToList().FindAll(c => (c.Medie<=max) && (c.Medie>=min));
while (SortedList.Count > nr)
SortedList.RemoveAt(SortedList.Count - 1);
var bindingList = new BindingList<FisaCazare>(SortedList);
var source = new BindingSource(bindingList, null);
dataGridView1.DataSource = source;
}
private void FatuSemana_Load(object sender, EventArgs e)
{
this.label4.DataBindings.Clear();
dataSistema = DateTime.Now.ToShortDateString();
string data="",sDataF="";
data = dataSistema;
DateTime d = Convert.ToDateTime(data);
sDataF = d.ToString("yyyyMMdd");
try
{
MySqlConnection con = new MySqlConnection("SERVER=localhost;" + " DATABASE=banco_rr_sacoles;" + " UID=root;" + "PASSWORD=12345;");
MySqlDataAdapter sql = new MySqlDataAdapter("SELECT SUM( total ) AS total FROM faturamento WHERE data BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) and '" + sDataF + "'", con);
//SELECT DATE_SUB(CURDATE(), INTERVAL 7 DAY);
DataTable dt = new DataTable();
sql.Fill(dt);
BindingSource source = new BindingSource();
source.DataSource = dt;
this.label4.DataBindings.Add("Text", source, "total", true);
string total = label4.Text;
Decimal tt = Convert.ToDecimal(total);
String tot = tt.ToString("N", new CultureInfo("pt-BR"));
tbxFaturamento.Text = ("R$ " + (String.Format("{0:0.00}",tt))).ToString();
con.Close();
}
catch (Exception ex)
{
ex.Message.ToString();
//throw new Exception("Erro de comandos: " + ex.Message);
}
}
public override void CargarDatos()
{
string dato = "";
string dato1 = "";
string factura = "";
if (empresas.SelectedValue != null)
{
dato = empresas.SelectedValue.ToString();
}
if (txtFactura.Text != "")
{
factura = " and ( comprobante like '" + txtFactura.Text + "' or comprobanterelacion like '" + txtFactura.Text + "')" ;
}
if (dato != "0" && dato != null && dato != "")
{
dato1 = " where id_empleado = " + dato;
dato = " and id_empleado = " + dato;
b = d.GetData("Select * From (Select C.id,id_transaccion,fecha,modopago, tipotransaccion, id_empleado, tipocomprobante, comprobante, tipocomprobanterelacion ,comprobanterelacion, detalle, ingreso, egreso, nrocheque, bancocheque,fechapago as fechapagocheque, id_cheque from CuentaCorrienteempleado C left outer join Cheque Ch on ch.id = c.id_cheque where tipoctacte = 3 Union All Select 0 as id,id_transaccion,fecha,modopago, 8 as tipotransaccion, ID_Empleado ,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, 0 as Ingreso, importe as egreso, '' as nrocheque, null as bancocheque, '' as fechapagocheque,null as id_cheque from ValeEmpleado ) where 1 = 1 " + dato + Fecha("and", "=", "") + factura + " order by fecha desc", MaxRecords, MinimoRecord);
}
else
{
dato = "";
b = d.GetData("Select * From (Select C.id,id_transaccion,fecha,modopago, tipotransaccion, id_empleado, tipocomprobante, comprobante, tipocomprobanterelacion ,comprobanterelacion, detalle, ingreso, egreso, nrocheque, bancocheque,fechapago as fechapagocheque, id_cheque from CuentaCorrienteempleado C left outer join Cheque Ch on ch.id = c.id_cheque where tipoctacte = 3 Union All Select 0 as id,id_transaccion,fecha,modopago, 8 as tipotransaccion, ID_Empleado ,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, 0 as Ingreso, importe as egreso, '' as nrocheque, null as bancocheque, '' as fechapagocheque , null as id_cheque from ValeEmpleado) where 1 = 1 " + Fecha("and", "=", "") + factura + " order by fecha desc", MaxRecords, MinimoRecord);
}
string saldoQuery = "Select sum(ingreso) -sum(egreso) as saldo From (Select ingreso, egreso,fecha from CuentaCorrienteempleado where tipoctacte = 3 " + dato + " Union All Select importe as Ingreso, 0 as egreso,fecha from ValeEmpleado " + dato1 + ") where 1 = 1 " + Fecha("and", "<=", "");
DataSet ds = d.GetDataSet(saldoQuery);
saldo.Text = ds.Tables[0].Rows[0]["saldo"].ToString();
dataGridView1.DataSource = b;
}
private void btn_ver_Click(object sender, EventArgs e)
{
if (cbExport.SelectedItem == "articulos")
{
MySqlCommand cmdDataBase = new MySqlCommand("select * from articulos ;", bd.cnn);
try
{
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = cmdDataBase;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bSource = new BindingSource();
bSource.DataSource = dbdataset;
dataGridView1.DataSource = bSource;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Seleccione el Item", "", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
/// <summary>
/// Constructor.
/// </summary>
public DisplaySetCreationConfigurationComponentControl(DisplaySetCreationConfigurationComponent component)
:base(component)
{
_component = component;
InitializeComponent();
_bindingSource = new BindingSource {DataSource = _component.Options};
_modality.DataSource = _bindingSource;
_modality.DisplayMember = "Modality";
_createSingleImageDisplaySets.DataBindings.Add("Checked", _bindingSource, "CreateSingleImageDisplaySets", false, DataSourceUpdateMode.OnPropertyChanged);
_createSingleImageDisplaySets.DataBindings.Add("Enabled", _bindingSource, "CreateSingleImageDisplaySetsEnabled", false, DataSourceUpdateMode.OnPropertyChanged);
_createAllImagesDisplaySet.DataBindings.Add("Checked", _bindingSource, "CreateAllImagesDisplaySet", false, DataSourceUpdateMode.OnPropertyChanged);
_createAllImagesDisplaySet.DataBindings.Add("Enabled", _bindingSource, "CreateAllImagesDisplaySetEnabled", false, DataSourceUpdateMode.OnPropertyChanged);
_showOriginalSeries.DataBindings.Add("Checked", _bindingSource, "ShowOriginalSeries", false, DataSourceUpdateMode.OnPropertyChanged);
_showOriginalSeries.DataBindings.Add("Enabled", _bindingSource, "ShowOriginalSeriesEnabled", false, DataSourceUpdateMode.OnPropertyChanged);
_splitEchos.DataBindings.Add("Checked", _bindingSource, "SplitMultiEchoSeries", false, DataSourceUpdateMode.OnPropertyChanged);
_splitEchos.DataBindings.Add("Enabled", _bindingSource, "SplitMultiEchoSeriesEnabled", false, DataSourceUpdateMode.OnPropertyChanged);
_showOriginalMultiEchoSeries.DataBindings.Add("Checked", _bindingSource, "ShowOriginalMultiEchoSeries", false, DataSourceUpdateMode.OnPropertyChanged);
_showOriginalMultiEchoSeries.DataBindings.Add("Enabled", _bindingSource, "ShowOriginalMultiEchoSeriesEnabled", false, DataSourceUpdateMode.OnPropertyChanged);
_splitMixedMultiframeSeries.DataBindings.Add("Checked", _bindingSource, "SplitMixedMultiframes", false, DataSourceUpdateMode.OnPropertyChanged);
_splitMixedMultiframeSeries.DataBindings.Add("Enabled", _bindingSource, "SplitMixedMultiframesEnabled", false, DataSourceUpdateMode.OnPropertyChanged);
_showOriginalMixedMultiframeSeries.DataBindings.Add("Checked", _bindingSource, "ShowOriginalMixedMultiframeSeries", false, DataSourceUpdateMode.OnPropertyChanged);
_showOriginalMixedMultiframeSeries.DataBindings.Add("Enabled", _bindingSource, "ShowOriginalMixedMultiframeSeriesEnabled", false, DataSourceUpdateMode.OnPropertyChanged);
_invertImages.DataBindings.Add("Checked", _bindingSource, "ShowGrayscaleInverted", false, DataSourceUpdateMode.OnPropertyChanged);
_invertImages.DataBindings.Add("Enabled", _bindingSource, "ShowGrayscaleInvertedEnabled", false, DataSourceUpdateMode.OnPropertyChanged);
}
public void SetDataSource(System.Windows.Forms.BindingSource dataSrc)
{
this.myDataSource = dataSrc;
databases.baseDS.stockCodeDataTable tbl = (databases.baseDS.stockCodeDataTable)this.myDataSource.DataSource;
this.bizSectorLb.DataBindings.Clear();
this.bizSectorLb.DataBindings.Add(new System.Windows.Forms.Binding("myItemString", this.myDataSource, tbl.bizSectorsColumn.ColumnName, true));
}
private void clears()
{
txtNameSearch.Text = "Enter all or part of a name here...";
txtCCSearch.Text = "Scan a customer card here...";
try
{
connectionString = ConfigurationManager.AppSettings["DBConnectionString"] + frmHomeScreen.mUserFile;
string query = "select * from customer order by last_name;";
OleDbDataAdapter da = new OleDbDataAdapter(query, connectionString);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
BindingSource bs = new BindingSource();
bs.DataSource = dt;
dgvCustomers.DataSource = bs;
da.Update(dt);
databaseHandler d = new databaseHandler();
d.closeDatabaseConnection();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void AddData(string sPathEn, string sPathVi)
{
try
{
string[] filePathEn = Directory.GetFiles(sPathEn, "*.ini");
string[] filePathVi = Directory.GetFiles(sPathVi, "*.ini");
var bindingSource = new BindingSource();
data = new List<SimpleDataFile>();
for (int i = 0; i < filePathEn.Length; i++)
{
string[] aPathVi = filePathVi.Where(w => (Path.GetFileName(w).Remove(0, 6) == Path.GetFileName(filePathEn[i]).Remove(0, 6))).ToArray();
string pathvi = "";
string Tenfilevi = "";
if (aPathVi.Length > 0)
{
pathvi = aPathVi[0];
Tenfilevi = Path.GetFileName(aPathVi[0]);
keyLang = Tenfilevi.Split('.')[0];
}
bindingSource.Add(new SimpleDataFile { Chon = false, TenFileEn = Path.GetFileName(filePathEn[i]), TenFileVi = Tenfilevi, PathEn = filePathEn[i], PathVi = pathvi });
data.Add(new SimpleDataFile { Chon = false, TenFileEn = Path.GetFileName(filePathEn[i]), TenFileVi = Tenfilevi, PathEn = filePathEn[i], PathVi = pathvi });
}
gvEn.DataSource = bindingSource;
}
catch (Exception ex)
{
MessageBox.Show("Có lỗi xảy ra khi load dữ liệu");
}
}
private void GetData()
{
//Set command
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "ReportOnClients";
cmd.CommandType = CommandType.StoredProcedure;
//Set adapter
SqlDataAdapter daClients = new SqlDataAdapter();
DataSet dsClients = new DataSet();
BindingSource bsClients = new BindingSource();
try
{
conn.Open();
daClients.SelectCommand = cmd;
daClients.Fill(dsClients);
bsClients.DataSource = dsClients.Tables[0];
//Bind to dgv
dgvClientsLookingToRent.DataSource = bsClients;
}
catch(Exception exc)
{
MessageBox.Show(exc.ToString());
}
finally
{
conn.Close();
}
}
public override void CargarDatos()
{
string dato = "";
string factura = "";
if (empresas.SelectedValue != null)
{
dato = empresas.SelectedValue.ToString();
}
if (txtFactura.Text != "")
{
factura = " and ( comprobante like '" + txtFactura.Text + "' or comprobanterelacion like '" + txtFactura.Text + "')";
}
if (dato != "0" && dato != null && dato != "")
{
dato = " and id_Cliente = " + dato;
b = d.GetData("Select * From (Select c.id,id_transaccion,fecha,modopago, tipotransaccion, id_cliente, tipocomprobante, comprobante, tipocomprobanterelacion ,comprobanterelacion, detalle, ingreso, egreso, nrocheque, bancocheque, fechapago as fechapagocheque, Descuento from CuentaCorriente C left outer join Cheque CH on C.ID_Cheque = CH.ID where tipoctacte = 2 Union All Select 0 as id,id_transaccion,fecha,modopago, 2 as tipotransaccion, ID_Cliente,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, 0 as Ingreso, importe + iva as egreso, '' as nrocheque, null as bancocheque, null as fechapagocheque, null as Descuento from Venta ) where 1 = 1 " + dato + Fecha("and", "=", ".") + factura + " order by fecha desc", MaxRecords, MinimoRecord);
}
else
{
dato = "";
b = d.GetData("Select * From (Select c.id,id_transaccion,fecha,modopago, tipotransaccion, id_cliente, tipocomprobante, comprobante, tipocomprobanterelacion ,comprobanterelacion, detalle, ingreso, egreso, nrocheque, bancocheque, fechapago as fechapagocheque, Descuento from CuentaCorriente C left outer join Cheque CH on C.ID_Cheque = CH.ID where tipoctacte = 2 Union All Select 0 as id,id_transaccion,fecha,modopago, 2 as tipotransaccion, ID_Cliente,tipocomprobante, comprobante, null as tipocomprobanterelacion , '' as comprobanterelacion, detalle, 0 as Ingreso, importe + iva as egreso, '' as nrocheque, null as bancocheque, null as fechapagocheque , null as Descuento from Venta ) where 1 = 1 " + Fecha("and", "=", ".") + factura + " order by fecha desc", MaxRecords, MinimoRecord);
}
string saldoQuery = "Select sum(ingreso) -sum(egreso) as saldo From (Select id,id_transaccion,fecha,modopago, tipotransaccion, id_cliente, tipocomprobante, comprobante, detalle, ingreso, egreso,comprobanterelacion from CuentaCorriente where tipoctacte = 2 Union All Select 0 as id,id_transaccion,fecha,modopago, 2 as tipotransaccion, ID_Cliente,tipocomprobante, comprobante, detalle, 0 as Ingreso, importe + iva as egreso, null as comprobanterelacion from Venta ) where id_cliente in (Select id from empresa where tipoempresa = 2) " + Fecha("and", "<=", ".") + dato + factura;
DataSet ds = d.GetDataSet(saldoQuery);
saldo.Text = ds.Tables[0].Rows[0]["saldo"].ToString();
dataGridView1.DataSource = b;
}
private void AutoSave()
{
if (lastSavedFile != "") {
dataGridView1.EndEdit();
BindingSource bs = new BindingSource();
//dat = (DataTable) (dataGridView1.DataSource);
//dat.AcceptChanges();
//dat.TableName = "saveData";
//dat.WriteXml("data.xsd", XmlWriteMode.WriteSchema);
//BindingSource bs = (BindingSource)dataGridView1.DataSource;
DataTable dt = dataGridView1.DataSource as DataTable;
//dataGridView1.Update();
if (dt != null){
dt.TableName = "AutoDataSave";
//SaveFileDialog fileDialog = new SaveFileDialog();
dt.WriteXml(lastSavedFile, XmlWriteMode.WriteSchema);
System.Windows.Forms.MessageBox.Show("Data Saved");
}
}
else {
lastSavedFile = "temp";
}
}
public void getUsuarios()
{
//Variables
DataTable dt = new DataTable();
BindingSource bs = new BindingSource();
List <clsUsuario> Usuario = new List <clsUsuario>();
clsUsuario c = new clsUsuario();
//Lenamos el DS de Categorias
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", "");
Data.DataModule.FillDataSet(spCatUsuarioDS, "spCatUsuario", Params.ToArray());
dt = spCatUsuarioDS.Tables["spCatUsuario"];
Usuario = c.FillList(dt);
bs.DataSource = Usuario;
this.lueUsuario.Properties.DataSource = bs.List;
//this.lueCambiaEstacion.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("EstacionID", "Banco ID"));
this.lueUsuario.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre"));
this.lueUsuario.Properties.DisplayMember = "Nombre";
this.lueUsuario.Properties.ValueMember = "UsuarioID";
this.lueUsuario.Properties.DropDownRows = Usuario.Count;
}
public void LoadAllBook()
{
try
{
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
string selectQuery = "SELECT * From Books";
SqlCommand cmd = new SqlCommand(selectQuery, connection);
//connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
dataTable = new DataTable();
adapter.Fill(dataTable);
BindingSource binding = new BindingSource();
binding.DataSource = dataTable;
dataGridView1.DataSource = dataTable;
adapter.Update(dataTable);
}
catch ( SqlException exception)
{
MessageBox.Show(exception.Message);
}
}
private void BindModel()
{
var mod = this.Manager.ActiveModel;
BindingSource bsMod = new BindingSource();
bsMod.DataSource = mod;
BindingSource bsPermits = new BindingSource();
bsPermits.DataSource = this.Manager.Permits;
Permits.DataSource = bsPermits;
BindingSource bsReminders = new BindingSource();
bsReminders.DataSource = mod.Reminders;
gridControlReminders.DataSource = bsReminders;
DriverID.DataBindings.Clear();
DriverID.DataBindings.Add("DriverID", bsMod, mod.GetName(p => p.DriverID), true, DataSourceUpdateMode.OnPropertyChanged);
LicenseID.DataBindings.Clear();
LicenseID.DataBindings.Add("EditValue", bsMod, mod.GetName(p => p.LicenseID), true, DataSourceUpdateMode.OnPropertyChanged);
IssueDate.DataBindings.Clear();
IssueDate.DataBindings.Add("EditValue", bsMod, mod.GetName(p => p.IssueDate), true, DataSourceUpdateMode.OnPropertyChanged);
ExpirationDate.DataBindings.Clear();
ExpirationDate.DataBindings.Add("EditValue", bsMod, mod.GetName(p => p.ExpirationDate), true, DataSourceUpdateMode.OnPropertyChanged);
MVRReviewDate.DataBindings.Clear();
MVRReviewDate.DataBindings.Add("EditValue", bsMod, mod.GetName(p => p.MVRReviewDate), true, DataSourceUpdateMode.OnPropertyChanged);
for (int i = 0; i < this.Manager.Permits.Count; i++)
{
var per = this.Manager.Permits[i];
Permits.SetItemChecked(i, per.IsCheck);
}
}
private void fillgridDef()
{
id = -1;
buttonDel.Visible = false;
buttonEdit.Visible = false;
buttonIns.Visible = false;
buttonCancel.Visible = false;
DBConnect NewcConnection = new DBConnect();
NewcConnection.dbConnection();
MySqlCommand querysql = new MySqlCommand("Select * From deficiencias", DBConnect.db);
try
{
MySqlDataAdapter dados = new MySqlDataAdapter();
dados.SelectCommand = querysql;
DataTable tabela = new DataTable();
dados.Fill(tabela);
BindingSource fonte = new BindingSource();
fonte.DataSource = tabela;
dataGridView1.DataSource = fonte;
this.dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Deficiencia";
dados.Update(tabela);
dataGridView1.AutoResizeColumns();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
DBConnect.db.Close();
textBoxDef.Clear();
}
private void button3_Click(object sender, EventArgs e)
{
this.webBrowser1.ScriptErrorsSuppressed = true;
this.webBrowser2.ScriptErrorsSuppressed = true;
XDocument docRss = XDocument.Load("http://tw.news.yahoo.com/rss/weather");
this.webBrowser1.DocumentText = docRss.ToString();
var query = from item in docRss.Descendants("item")
select new
{
標題 = item.Element("title").Value,
說明 = item.Element("description").Value,
發佈日期 = item.Element("pubDate").Value
};
dataGridView1.DataSource = query.ToList();
//for BindingSource====================
BindingSource bs = new BindingSource();
dataGridView4.DataSource = bs;
bs.DataSource = query.ToList();
this.webBrowser2.DataBindings.Add("DocumentText", bs, "說明");
//this.dataRepeater2.DataSource = query.ToList();
}
private void loadHeroDiary()
{
// Load the latest Hero Diary entries
using (SQLiteConnection conn = new SQLiteConnection(@"Data Source=" + dbPath + @"\gv.db;Version=3;New=False;Compress=True;"))
{
conn.Open();
using (SQLiteCommand cmd = conn.CreateCommand())
{
string commandText = "select Diary_ID as ID, Updated, EntryTime, Entry from Diary where HeroName=@HeroName order by Diary_ID desc limit 1000";
cmd.CommandText = commandText;
cmd.Parameters.AddWithValue("@HeroName", this.HeroName);
SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
DataSet ds = new DataSet();
da = new SQLiteDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = ds.Tables[0];
grdDiary.DataSource = bindingSource;
grdDiary.AutoGenerateColumns = true;
grdDiary.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders;
grdDiary.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
}
}
private void AddEditOrderView_Load(object sender, EventArgs e)
{
BindingSource bindings = new BindingSource();
bindings.DataSource = presenter;
customerComboBox.DataBindings.Clear();
customerComboBox.DataBindings.Add("DataSource", bindings, "Customers");
customerComboBox.DataBindings.Add("SelectedItem", bindings, "Customer");
priceEdit.Text = Convert.ToString(presenter.TotalCost);
statusComboBox.DataBindings.Clear();
statusComboBox.DataBindings.Add("DataSource", bindings, "Statuses");
statusComboBox.DataBindings.Add("SelectedItem", bindings, "Status");
goodsComboBox.DataBindings.Clear();
goodsComboBox.DataBindings.Add("DataSource", bindings, "GoodsList");
commentsListBox.DataBindings.Clear();
commentsListBox.DataBindings.Add("DataSource", bindings, "Comments");
commentTextEdit.DataBindings.Clear();
commentTextEdit.DataBindings.Add("Text", bindings, "Message");
addEditViewModelBindingSource.DataSource = presenter;
goodsRowGridControl.DataBindings.Add("DataSource", addEditViewModelBindingSource, "vm");
goodsComboBox.DataBindings.Add("SelectedItem", addEditViewModelBindingSource, "SelectedGood");
countOfGoodTextEdit.DataBindings.Add("Text", addEditViewModelBindingSource, "CountOfGood");
}
public void UpdateGridViewConsultas()
{
try
{
agendamentos.Clear();
conn.Open();
com.Connection = conn;
// string date = DateTime.ParseExact(DateTime.Now.ToString("MM/dd/yyyy"), "dd/MM/yyyy", null).ToString("MM/dd/yyyy");
// DateTime date = DateTime.Now;
string mm = DateTime.Now.ToString("MM/dd/yyyy");
// string aa = DateTime.Now.ToString("dd/MM/yyyy");
SqlCommand cmd = new SqlCommand("select agendamento.dataProximaConsulta, agendamento.horaProximaConsulta, p.Nome, p.Nif from AgendamentoConsulta agendamento INNER JOIN Paciente p ON agendamento.IdPaciente = p.IdPaciente WHERE agendamento.IdEnfermeiro = " + enfermeiro.IdEnfermeiro + " AND ConsultaRealizada= 0 AND agendamento.dataProximaConsulta >= @data ORDER BY agendamento.horaProximaConsulta", conn);
cmd.Parameters.AddWithValue("@data", mm);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string dataConsulta = DateTime.ParseExact(reader["dataProximaConsulta"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
AgendamentoConsultaGridView agendamento = new AgendamentoConsultaGridView
{
dataProximaConsulta = dataConsulta,
horaProximaConsulta = (string)reader["horaProximaConsulta"],
NomePaciente = (string)reader["Nome"],
NifPaciente = Convert.ToInt32(reader["Nif"]),
};
agendamentos.Add(agendamento);
}
auxiliar = agendamentos;
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = auxiliar
};
dataGridViewMarcacoes.DataSource = bindingSource1;
dataGridViewMarcacoes.Columns[0].HeaderText = "Hora Consulta";
dataGridViewMarcacoes.Columns[1].HeaderText = "Data Consulta";
dataGridViewMarcacoes.Columns[2].HeaderText = "Nome Utente";
dataGridViewMarcacoes.Columns[3].HeaderText = "Nif Paciente";
conn.Close();
CurrencyManager currencyManager1 = (CurrencyManager)BindingContext[dataGridViewMarcacoes.DataSource];
currencyManager1.SuspendBinding();
// dataGridViewMarcacoes.CurrentCell = null;
// dataGridViewMarcacoes.Rows[dataGridViewMarcacoes.Rows.Count -1].Disable = false;
}
catch (Exception)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
MessageBox.Show("Por erro interno é impossível visualizar os dados!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void HienthiVANBANGDataGridview(System.Windows.Forms.DataGridView dg)
{
System.Windows.Forms.BindingSource bs = new System.Windows.Forms.BindingSource();
DataTable tbl = data.DanhsachVANBANG();
bs.DataSource = tbl;
dg.DataSource = bs;
}
public void HienthiPHONGBANDALAMVIECDataGridview(System.Windows.Forms.DataGridView dg, string manv)
{
System.Windows.Forms.BindingSource bs = new System.Windows.Forms.BindingSource();
DataTable tbl = data.DANHSACHPHONGBANDALAMVIEC(manv);
bs.DataSource = tbl;
dg.DataSource = bs;
}
public void HienthiHINHTHUCKTHUONGDataGridview(System.Windows.Forms.DataGridView dg)
{
System.Windows.Forms.BindingSource bs = new System.Windows.Forms.BindingSource();
DataTable tbl = data.DanhsachPHUCAP();
bs.DataSource = tbl;
dg.DataSource = bs;
}
public void load_sale()
{
var bind = new System.Windows.Forms.BindingSource {
DataSource = billsitem
};
billitemgrid.DataSource = bind;
}
private void comboBoxDespesa_SelectedValueChanged(object sender, EventArgs e)
{
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = filtrosDePesquisa()
};
dataGridViewDespesas.DataSource = bindingSource1;
}
public void HienthiNganhDaoTaoDataGridview(System.Windows.Forms.DataGridView dg)
{
System.Windows.Forms.BindingSource bs = new System.Windows.Forms.BindingSource();
DataTable tbl = data.DanhsachChuyenNganh();
bs.DataSource = tbl;
dg.DataSource = bs;
}
private void dataConsulta_ValueChanged(object sender, EventArgs e)
{
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = filtrosDePesquisa()
};
dataGridViewMarcacoes.DataSource = bindingSource1;
}
private void t_usersBindingSource_CurrentChanged(object sender, EventArgs e)
{
System.Windows.Forms.BindingSource bs = sender as BindingSource;
if (null != (DataRowView)bs.Current)
{
}
}
private void bLoadSoldTickets_Click(object sender, EventArgs e)
{
var bindingSource = new System.Windows.Forms.BindingSource();
dt = bs.viewBileteVandute(Convert.ToInt32(tb_specIdSoldTickets.Text));
bSource.DataSource = dt;
dgv_soldTickets.DataSource = bSource;
}
private void bLoadSpec_Click(object sender, EventArgs e)
{
var bindingSource = new System.Windows.Forms.BindingSource();
dt = ss.viewSpectacol();
bSource.DataSource = dt;
dgv_spec.DataSource = bSource;
}
private void UpdateDataGridView()
{
try
{
listaEncomendas.Clear();
conn.Open();
com.Connection = conn;
SqlCommand cmd = new SqlCommand("select enc.IdEncomenda, enc.Nfatura, fornecedor.nome, enc.dataRegistoEncomenda, enc.dataEntregaPrevista, enc.dataEntregaReal from Fornecedor fornecedor JOIN Encomenda enc ON fornecedor.IdFornecedor = enc.idFornecedor WHERE enc.dataEntregaReal IS NULL ORDER BY enc.IdEncomenda", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string dataRegistoEnc = DateTime.ParseExact(reader["dataRegistoEncomenda"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
string dataEntregaPrev = DateTime.ParseExact(reader["dataEntregaPrevista"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
string dataEntregaR = "";
if (reader["dataEntregaReal"].ToString() != "")
{
dataEntregaR = DateTime.ParseExact(reader["dataEntregaReal"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
}
Encomendas encomendas = new Encomendas
{
IdEncomenda = (int)reader["IdEncomenda"],
NFatura = (string)reader["Nfatura"],
nome = (string)reader["nome"],
dataRegisto = dataRegistoEnc,
dataEntregaPrevista = dataEntregaPrev,
dataEntregaReal = dataEntregaR,
};
listaEncomendas.Add(encomendas);
}
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = listaEncomendas
};
dataGridViewEncomendas.DataSource = bindingSource1;
dataGridViewEncomendas.Columns[0].HeaderText = "Número da Encomenda";
dataGridViewEncomendas.Columns[1].HeaderText = "Nome Fornecedor";
dataGridViewEncomendas.Columns[2].HeaderText = "Data de Registo da Encomanda";
dataGridViewEncomendas.Columns[3].HeaderText = "Data de Entrega Prevista";
dataGridViewEncomendas.Columns[4].HeaderText = "Data de Entrega Real";
dataGridViewEncomendas.Columns[5].Visible = false;
conn.Close();
auxiliar = listaEncomendas;
dataGridViewEncomendas.Update();
dataGridViewEncomendas.Refresh();
}
catch (Exception)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
MessageBox.Show("Por erro interno é impossível selecionar os dados!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void verTratamentos()
{
try
{
TratamentosAnteriores tratamentos = new TratamentosAnteriores();
conn.Open();
com.Connection = conn;
SqlCommand cmd = new SqlCommand("select tratamentoPac.data, tratamento.nomeTratamento, tratamentoPac.numeroTratamento, tratamentoPac.dimensoes, tratamentoPac.grauUlceraPressao, tratamentoPac.exsudadoTipo, tratamentoPac.exsudadoQuantidade, tratamentoPac.exsudadoCheiro, tratamentoPac.tecidoPredominante, tratamentoPac.areaCircundante, tratamentoPac.agenteLimpeza, tratamentoPac.aplicacaoFerida, tratamentoPac.aplicacaoAreaCircundante, tratamentoPac.aplicacaoPenso, tratamentoPac.aplicacaoTamanho, tratamentoPac.aplicacaoSuportePenso, tratamentoPac.ProximoTratamento, tratamentoPac.Observacoes, tratamentoPac.EscalaDor, queimadura.tipoQueimadura, tratamentoPac.IPTB, ulcera.tipoUlcera from Tratamento tratamento LEFT JOIN TratamentoPaciente tratamentoPac ON tratamento.IdTratamento = tratamentoPac.IdTratamento LEFT JOIN Paciente pac ON tratamentoPac.IdTratamento = pac.IdPaciente LEFT JOIN tipoQueimadura queimadura ON tratamentoPac.tipoQueimadura = queimadura.IdTipoQueimadura LEFT JOIN tipoUlcera ulcera ON tratamentoPac.tipoUlcera = ulcera.IdTipoUlcera where tratamentoPac.IdPaciente = @IdPaciente ORDER BY tratamentoPac.data asc, tratamento.nomeTratamento asc", conn);
cmd.Parameters.AddWithValue("@IdPaciente", paciente.IdPaciente);
SqlDataReader reader = cmd.ExecuteReader();
// Paciente paciente = null;
while (reader.Read())
{
tratamentos = new TratamentosAnteriores
{
dataTratamento = Convert.ToDateTime(reader["data"]),
tipoTratamento = ((reader["nomeTratamento"] == DBNull.Value) ? "" : (string)reader["nomeTratamento"]),
nrTratamento = ((reader["numeroTratamento"] == DBNull.Value) ? null : (int?)reader["numeroTratamento"]),
dimensoes = ((reader["dimensoes"] == DBNull.Value) ? "" : (string)reader["dimensoes"]),
grauUlceraPressao = ((reader["grauUlceraPressao"] == DBNull.Value) ? "" : (string)reader["grauUlceraPressao"]),
exsudadoTipo = ((reader["exsudadoTipo"] == DBNull.Value) ? "" : (string)reader["exsudadoTipo"]),
exsudadoQuantidade = ((reader["exsudadoQuantidade"] == DBNull.Value) ? null : (int?)reader["exsudadoQuantidade"]),
exsudadoCheiro = ((reader["exsudadoCheiro"] == DBNull.Value) ? "" : (string)reader["exsudadoCheiro"]),
tecidoPredominante = ((reader["tecidoPredominante"] == DBNull.Value) ? "" : (string)reader["tecidoPredominante"]),
areaCircundante = ((reader["areaCircundante"] == DBNull.Value) ? "" : (string)reader["areaCircundante"]),
agenteLimpeza = ((reader["agenteLimpeza"] == DBNull.Value) ? "" : (string)reader["agenteLimpeza"]),
aplicacaoFerida = ((reader["aplicacaoFerida"] == DBNull.Value) ? "" : (string)reader["aplicacaoFerida"]),
aplicacaoAreaCircundante = ((reader["aplicacaoAreaCircundante"] == DBNull.Value) ? "" : (string)reader["aplicacaoAreaCircundante"]),
aplicacaoPenso = ((reader["aplicacaoPenso"] == DBNull.Value) ? "" : (string)reader["aplicacaoPenso"]),
aplicacaoTamanho = ((reader["aplicacaoTamanho"] == DBNull.Value) ? null : (int?)reader["aplicacaoTamanho"]),
aplicacaoSuportePenso = ((reader["aplicacaoSuportePenso"] == DBNull.Value) ? "" : (string)reader["aplicacaoSuportePenso"]),
Observacoes = ((reader["Observacoes"] == DBNull.Value) ? "" : (string)reader["Observacoes"]),
ProximoTratamento = (reader["ProximoTratamento"].ToString() == "" ? "" : DateTime.ParseExact(reader["ProximoTratamento"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy")),
EscalaDor = ((reader["EscalaDor"] == DBNull.Value) ? "" : (string)reader["EscalaDor"]),
tipoQueimadura = ((reader["tipoQueimadura"] == DBNull.Value) ? "" : (string)reader["tipoQueimadura"]),
IPTB = ((reader["IPTB"] == DBNull.Value) ? "" : (string)reader["IPTB"]),
tipoUlcera = ((reader["tipoUlcera"] == DBNull.Value) ? "" : (string)reader["tipoUlcera"]),
};
listaTratamentosAnteriores.Add(tratamentos);
}
conn.Close();
UpdateDataGridView();
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = listaTratamentosAnteriores
};
dataGridViewTratamentos.DataSource = bindingSource1;
}
catch (Exception)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
MessageBox.Show("Por erro interno é impossível visualizar os dados!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void VerCateterismo_Load(object sender, EventArgs e)
{
var bindingSource2 = new System.Windows.Forms.BindingSource {
DataSource = cateterismoPaciente
};
dataGridViewCateterismo.DataSource = bindingSource2;
UpdateDataGridView();
}
public void HienthiCHUYENMONDataGridview(System.Windows.Forms.DataGridView dg, string manv)
{
System.Windows.Forms.BindingSource bs = new System.Windows.Forms.BindingSource();
DataTable tbl = data.DanhsachCHUYENMON(manv);
bs.DataSource = tbl;
//bn.BindingSource = bs;
dg.DataSource = bs;
}
