private void GridGame(DataTable dt)
{
DataTable dtbl = new DataTable();
dtbl.Columns.Add("GP NO", typeof(String));
dtbl.Columns.Add("DATE", typeof(String));
dtbl.Columns.Add("PARTY NAME", typeof(String));
dtbl.Columns.Add("LOT NO", typeof(String));
dtbl.Columns.Add("STOCK NAME", typeof(String));
dtbl.Columns.Add("BRAND", typeof(String));
dtbl.Columns.Add("STOCK TYPE", typeof(String));
dtbl.Columns.Add("PKNG TYPE", typeof(String));
dtbl.Columns.Add("QTTY", typeof(String));
dtbl.Columns.Add("WEIGHT", typeof(String));
dtbl.Columns.Add("BM QTY", typeof(String));
dtbl.Columns.Add("BM END", typeof(String));
dtbl.Columns.Add("BM LENGTH", typeof(String));
dtbl.Columns.Add("BM TTL LENGTH", typeof(String));
int count = dt.Rows.Count;
int totlRows = dt.Rows.Count;
int rowNum = 0;
for (int i = 0; i < totlRows; i++)
{
dtbl.Rows.Add();
dtbl.Rows[rowNum]["GP NO"] = dt.Rows[i]["GP NO"].ToString();
dtbl.Rows[rowNum]["Date"] = dt.Rows[i]["Date"].ToString();
dtbl.Rows[rowNum]["PARTY NAME"] = dt.Rows[i]["PARTY NAME"].ToString();
dtbl.Rows[rowNum]["LOT NO"] = dt.Rows[i]["LOT NO"].ToString();
dtbl.Rows[rowNum]["STOCK NAME"] = dt.Rows[i]["STOCK NAME"].ToString();
dtbl.Rows[rowNum]["BRAND"] = dt.Rows[i]["BRAND"].ToString();
dtbl.Rows[rowNum]["STOCK TYPE"] = dt.Rows[i]["STOCK TYPE"].ToString();
dtbl.Rows[rowNum]["PKNG TYPE"] = dt.Rows[i]["PKNG TYPE"].ToString();
dtbl.Rows[rowNum]["QTTY"] = dt.Rows[i]["QTTY"].ToString();
dtbl.Rows[rowNum]["WEIGHT"] = dt.Rows[i]["WEIGHT"].ToString();
dtbl.Rows[rowNum]["BM QTY"] = dt.Rows[i]["BM QTY"].ToString();
dtbl.Rows[rowNum]["BM END"] = dt.Rows[i]["BM END"].ToString();
dtbl.Rows[rowNum]["BM LENGTH"] = dt.Rows[i]["BM LENGTH"].ToString();
dtbl.Rows[rowNum]["BM TTL LENGTH"] = dt.Rows[i]["BM TTL LENGTH"].ToString();
rowNum++;
}
dsStock_Out ds = new dsStock_Out();
for (int i = 0; i < count; i++)
{
ds.dt_Stock_Out.Rows.Add();
ds.dt_Stock_Out.Rows[i]["GP NO"] = dtbl.Rows[i]["GP NO"];
ds.dt_Stock_Out.Rows[i]["Date"] = dtbl.Rows[i]["Date"];
ds.dt_Stock_Out.Rows[i]["PARTY NAME"] = dtbl.Rows[i]["PARTY NAME"];
ds.dt_Stock_Out.Rows[i]["LOT NO"] = dtbl.Rows[i]["LOT NO"];
ds.dt_Stock_Out.Rows[i]["STOCK NAME"] = dtbl.Rows[i]["STOCK NAME"];
ds.dt_Stock_Out.Rows[i]["BRAND"] = dtbl.Rows[i]["BRAND"];
ds.dt_Stock_Out.Rows[i]["STOCK TYPE"] = dtbl.Rows[i]["STOCK TYPE"];
ds.dt_Stock_Out.Rows[i]["PKNG TYPE"] = dtbl.Rows[i]["PKNG TYPE"];
ds.dt_Stock_Out.Rows[i]["QTTY"] = dtbl.Rows[i]["QTTY"];
ds.dt_Stock_Out.Rows[i]["WEIGHT"] = dtbl.Rows[i]["WEIGHT"];
ds.dt_Stock_Out.Rows[i]["BM QTY"] = dtbl.Rows[i]["BM QTY"];
ds.dt_Stock_Out.Rows[i]["BM END"] = dtbl.Rows[i]["BM END"];
ds.dt_Stock_Out.Rows[i]["BM LENGTH"] = dtbl.Rows[i]["BM LENGTH"];
ds.dt_Stock_Out.Rows[i]["BM TTL LENGTH"] = dt.Rows[i]["BM TTL LENGTH"];
}
crpStock_Out crp = new crpStock_Out();
crp.SetDataSource(ds);
ReportViewer rv = new ReportViewer();
rv.crystalReportViewer1.ReportSource = crp;
rv.crystalReportViewer1.Refresh();
rv.Show();
}
No comments:
Post a Comment