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);
}