private void DBBind()
{
string strPoID = this.txtPoID.Text.Trim();
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
DataSet dsout = StoBusi.GetPoStockDetailSum(strPoID);
if (dsout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
this.TableConvert(dsout.Tables["detail"], "cnvcDeptName", "NewDept");
this.TableConvert(dsout.Tables["detail"], "cnvcRowState", "tbNameCodeToStorage", "vcCommSign='PoState'");
this.TableConvert(dsout.Tables["detail"], "cnvcGroupName", "ComputationGroup");
this.TableConvert(dsout.Tables["detail"], "cnvcStockUnit", "ComputationUnit");
Session["podetailtomod"] = dsout.Tables["detail"];
DataView dvOut1 = new DataView(dsout.Tables["detail"]);
this.Datagrid2.PageSize = 10;
this.Datagrid2.EditItemIndex = -1;
this.Datagrid2.DataSource = dvOut1;
this.Datagrid2.DataBind();
foreach (DataGridItem dgi in this.Datagrid2.Items)
{
if (dgi.Cells[13].Text.Trim() == "完成")
{
((Button)dgi.Cells[19].Controls[0]).Visible = false;
((Button)dgi.Cells[20].Controls[0]).Visible = false;
}
}
this.TableConvert(dsout.Tables["sum"], "计量单位组", "ComputationGroup");
this.TableConvert(dsout.Tables["sum"], "单位", "ComputationUnit");
UcPageView1.MyDataGrid.Caption = "采购订单汇总表";
UcPageView1.MyDataGrid.PageSize = 20;
DataView dvOut2 = new DataView(dsout.Tables["sum"]);
this.UcPageView1.MyDataSource = dvOut2;
this.UcPageView1.BindGrid();
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
