private void dgvAdvDetail_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
FormAddAudit form = new FormAddAudit();
SupplierAuditMaster supplier = new SupplierAuditMaster();
supplier.SupplierNo = int.Parse(tbSupNo.Text);
supplier.SupplierAddress = tbAddress.Text;
supplier.SupplierName = tbName.Text;
supplier.SupplierStatus = 1;
supplier.SupplierTP01 = tbTPNo1.Text;
supplier.SupplierTP02 = tbTpNo2.Text;
supplier.PayMode = tbPayMode.Text;
supplier.RouteName = tbRoute.Text;
SupplierAudit audit = new SupplierAudit();
audit.Amount = float.Parse(dgvAdvDetail.Rows[e.RowIndex].Cells["Advance"].Value.ToString()); //Trn.Date
audit.TrnDate = DateTime.Parse(dgvAdvDetail.Rows[e.RowIndex].Cells["Trn.Date"].Value.ToString());
audit.TrnNumber = dgvAdvDetail.Rows[e.RowIndex].Cells["VoucherNo"].Value.ToString();
form.selSupplier = supplier;
form.audit = audit;
form.Owner = this;
form.StartPosition = FormStartPosition.CenterParent;
form.ShowDialog();
}
public List <SupplierAuditMaster> GetSupplierAuditMasters()
{
List <SupplierAuditMaster> suppliers = new List <SupplierAuditMaster>();
sql = " Select * from SupplierAUditMaster";
//SqlCommand sqlcmd = new SqlCommand(sql);
dB = new DBAccess();
DataTable suptable = dB.GetDataTable(sql, DBAccess.AUDIT);
SupplierAuditMaster all = new SupplierAuditMaster();
all.SupplierName = "All";
all.id = -1;
suppliers.Add(all);
foreach (DataRow dr in suptable.Rows)
{
SupplierAuditMaster master = new SupplierAuditMaster();
master.id = int.Parse(dr["id"].ToString());
master.SupplierName = dr["SupplierName"].ToString();
master.SupplierAddress = dr["SupplierAddress"].ToString();
master.SupplierNo = int.Parse(dr["SupplierNo"].ToString());
master.SupplierTP01 = dr["SupplierTP01"].ToString();
master.SupplierTP02 = dr["SupplierTP02"].ToString();
master.PayMode = dr["PayMode"].ToString();
master.RouteName = dr["RouteName"].ToString();
master.SupplierStatus = int.Parse(dr["SupplierStatus"].ToString());
suppliers.Add(master);
}
dB = null;
return(suppliers);
}
public DataTable GetAuditReport(SupplierAuditMaster supplier)
{
if (supplier == null)
{
sql = "Select * from SupplierAUditMaster m inner join SupplierAuditDetail d on m.id = d.SupplierId";
}
else
{
sql = "Select * from SupplierAUditMaster m inner join SupplierAuditDetail d on m.id = d.SupplierId where m.SupplierNo = " + supplier.SupplierNo;
}
dB = new DBAccess();
return(dB.GetDataTable(sql, DBAccess.AUDIT));
}
public FormAddAudit()
{
InitializeComponent();
selSupplier = new SupplierAuditMaster();
auditEntry = new SupplierAuditEntry();
}