private void load_apparatus(string q) { config.Load_DTG(q, apparatusGridview); }
private void frmListStockout_Load(object sender, EventArgs e) { sql = "SELECT `TRANSACTIONNUMBER` as ID,concat(`FIRSTNAME`, `LASTNAME`) as 'CUSTOMER',`NAME` as 'ITEMNAME', `DESCRIPTION`, `PRICE`, `TRANSACTIONDATE` as DATE, o.`QTY`, `TOTALPRICE` FROM `tblperson` p,`tblstock_in_out` o ,`tblitems` i WHERE REMARKS='StockOut' and i.`ITEMID`=o.`ITEMID` and p.`SUPLIERCUSTOMERID`=o.`SUPLIERCUSTOMERID` and p.TYPE = 'Customer'" + " AND (NAME like '%" + txtsearch.Text + "%' OR TRANSACTIONNUMBER like '%" + txtsearch.Text + "%')"; config.Load_DTG(sql, dtglist); }
public void btnItems_Click(object sender, EventArgs e) { sql = "SELECT Item, COUNT(*) Total FROM tblreg GROUP BY Item ;"; config.Load_DTG(sql, dataGridView1); designdatagridview(); }
private void ReportForm_Load(object sender, EventArgs e) { config.Load_DTG("exec sp_ShowReportsInExp " + exp_id + " ", reportGridview); reportGridview.Columns["Author"].Visible = false; }
private void txtSearch_TextChanged(object sender, EventArgs e) { sql = "SELECT `SECTIONID` as 'ID', `SECTION`,LEVEL FROM `tblsection` WHERE SECTION LIKE '%" + txtSearch.Text + "%'"; config.Load_DTG(sql, dtgList); }
private void btnItemLoad_Click(object sender, EventArgs e) { sql = "SELECT * from Item ;"; config.Load_DTG(sql, dgvItems); dgvItems.Columns[0].Visible = false; designdatagridview(); }
private void frmListReturned_Load(object sender, EventArgs e) { sql = "SELECT concat(`FIRSTNAME`, `LASTNAME`) as 'CLIENTE',`STOCKRETURNNUMBER` as 'TRANSACCION#',`NAME` as 'PRODUCTO', `RETURNDATE` FROM `tblstock_return` r, `tblitems` i,`tblperson` p WHERE i.`ITEMID`=r.`ITEMID` and r.`OWNER_CUS_ID` =p.`SUPLIERCUSTOMERID` and p.TYPE not in ('Suplier')" + " AND STOCKRETURNNUMBER LIKE '%" + txtsearch.Text + "%'"; config.Load_DTG(sql, dtglist); }