private void btnDeclare_Click(object sender, EventArgs e)
{
System.Data.DataTable result = new System.Data.DataTable();
result.Columns.Add(new DataColumn("dr", typeof(String)));
result.Columns.Add(new DataColumn("drDate", typeof(DateTime)));
result.Columns.Add(new DataColumn("poNo", typeof(String)));
result.Columns.Add(new DataColumn("custname", typeof(String)));
result.Columns.Add(new DataColumn("address", typeof(String)));
result.Columns.Add(new DataColumn("tin", typeof(String)));
result.Columns.Add(new DataColumn("productCode", typeof(String)));
result.Columns.Add(new DataColumn("description", typeof(String)));
result.Columns.Add(new DataColumn("batch", typeof(String)));
result.Columns.Add(new DataColumn("exDate", typeof(DateTime)));
result.Columns.Add(new DataColumn("pack", typeof(String)));
result.Columns.Add(new DataColumn("pcs", typeof(Decimal)));
result.Columns.Add(new DataColumn("cases", typeof(int)));
result.Columns.Add(new DataColumn("terms", typeof(String)));
DataRow resultRow = result.NewRow();
var dt = DataSupport.RunDataSet("Select * from Global_drTrans dr join Global_drTransDetails D on dr.dr_Id = D.dr_Id join base_customer c on dr.custCode = c.custCode where dr.drNo = '" + txtdr.Text + "'").Tables[0];
foreach (DataRow row in dt.Rows)
{
resultRow = result.NewRow();
resultRow["dr"] = row["drNo"].ToString();
resultRow["drDate"] = row["drDate"].ToString();
resultRow["poNo"] = row["poNo"].ToString();
resultRow["custname"] = row["custName"].ToString();
resultRow["address"] = row["address"].ToString();
resultRow["tin"] = row["tinNo"].ToString();
resultRow["productCode"] = row["product_code"].ToString();
resultRow["description"] = row["description"].ToString();
resultRow["batch"] = row["batchno"].ToString();
if (row["expiryDate"].ToString() == "")
{
resultRow["exDate"] = DBNull.Value;
}
else
{
resultRow["exDate"] = row["expiryDate"].ToString();
}
resultRow["pack"] = row["packSize"].ToString();
resultRow["pcs"] = row["pcs"].ToString();
resultRow["cases"] = row["cases"].ToString();
resultRow["terms"] = DBNull.Value;
result.Rows.Add(resultRow);
}
var viewer = new Reports.ReportViewer();
ReportDocument ReportDocs = new ReportDocument();
if (cbxchoose.Text == "Extra Copy")
{
ReportDocs = new Reports.Extracopy.ExtraDr();
}
else
{
ReportDocs = new Reports.Dr();
}
ReportDocs.Database.Tables[0].SetDataSource(result);
viewer.Viewer.ReportSource = ReportDocs;
viewer.btnDeclare.Visible = false;
viewer.ShowDialog();
}
private void btnDeclare_Click(object sender, EventArgs e)
{
System.Data.DataTable result = new System.Data.DataTable();
result.Columns.Add(new DataColumn("dr", typeof(String)));
result.Columns.Add(new DataColumn("drDate", typeof(DateTime)));
result.Columns.Add(new DataColumn("poNo", typeof(String)));
result.Columns.Add(new DataColumn("custname", typeof(String)));
result.Columns.Add(new DataColumn("address", typeof(String)));
result.Columns.Add(new DataColumn("tin", typeof(String)));
result.Columns.Add(new DataColumn("productCode", typeof(String)));
result.Columns.Add(new DataColumn("description", typeof(String)));
result.Columns.Add(new DataColumn("batch", typeof(int)));
result.Columns.Add(new DataColumn("exDate", typeof(DateTime)));
result.Columns.Add(new DataColumn("pack", typeof(String)));
result.Columns.Add(new DataColumn("pcs", typeof(Decimal)));
result.Columns.Add(new DataColumn("cases", typeof(int)));
result.Columns.Add(new DataColumn("terms", typeof(String)));
DataRow resultRow = result.NewRow();
resultRow = result.NewRow();
resultRow["dr"] = txtDRNo.Text;
resultRow["drDate"] = txtDRDate.Text;
resultRow["poNo"] = txtREf.Text;
resultRow["custname"] = txtCustName.Text;
resultRow["address"] = txtaddress.Text;
resultRow["tin"] = txtTin.Text;
resultRow["terms"] = txtTerms.Text;
result.Rows.Add(resultRow);
foreach (DataGridViewRow dRow in dataGridView1.Rows)
{
if (dataGridView1.Rows.IndexOf(dRow) == dataGridView1.Rows.Count - 1)
{
break;
}
resultRow = result.NewRow();
resultRow["productCode"] = dRow.Cells[colCode.Name].Value.ToString();
resultRow["description"] = dRow.Cells[coldescription.Name].Value.ToString();
if (string.IsNullOrEmpty(dRow.Cells[colbatch.Name].Value as string))
{
resultRow["batch"] = "0";
}
else
{
resultRow["batch"] = dRow.Cells[colbatch.Name].Value.ToString();
}
if (dRow.Cells[colExdate.Name].Value == null)
{
resultRow["exDate"] = DBNull.Value;
}
else
{
resultRow["exDate"] = dRow.Cells[colExdate.Name].Value.ToString();
}
resultRow["pack"] = dRow.Cells[colPack.Name].Value.ToString();
resultRow["pcs"] = dRow.Cells[colpcs.Name].Value.ToString();
resultRow["cases"] = dRow.Cells[colcases.Name].Value.ToString();
result.Rows.Add(resultRow);
}
var viewer = new Reports.ReportViewer();
ReportDocument ReportDocs = new ReportDocument();
ReportDocs = new Reports.Dr();
ReportDocs.Database.Tables[0].SetDataSource(result);
viewer.Viewer.ReportSource = ReportDocs;
viewer.btnPrint.Visible = false;
viewer.ShowDialog();
if (viewer._status == "save")
{
save(); clear();
}
}
