public void BindGv()
{
if (!string.IsNullOrEmpty(base.Request["id"].ToString()))
{
string strWhere = "AND r.ResourceId IN ( select CID from Res_ResourceRelation where FID='" + base.Request["id"].ToString() + "')";
//string strWhere = " AND r.ResourceId IN ('067ef1eb-3386-4a00-8133-d33154337057','0842da52-2cf1-40ba-86e4-058a1e8fc16d')";
cn.justwin.BLL.Resource resource = new cn.justwin.BLL.Resource();
DataTable table = resource.Query(this.AspNetPager1.PageSize, this.AspNetPager1.CurrentPageIndex, strWhere, "");//string condition, string priceTypeCondition);
System.Collections.Generic.IList <PriceType> priceTypes = PriceType.GetPriceTypes(base.UserCode);
if (this.gvResource.Columns.Count < 14 + priceTypes.Count)
{
int num = 9;
foreach (PriceType current in priceTypes)
{
BoundField boundField = new BoundField();
boundField.DataField = current.PriceTypeName;
boundField.HeaderText = current.PriceTypeName;
this.gvResource.Columns.Insert(num++, boundField);
}
}
//table.Columns.Remove("采购价");
//table.Columns.Remove("目标成本价");
//table.Columns.Remove("最后采购价");
table.Columns.Add("NUM");
foreach (DataRow dr in table.Rows)
{
DataTable dt = publicDbOpClass.DataTableQuary("select NUM from Res_ResourceRelation where CID ='" + dr["ResourceId"].ToString() + "' and FID='" + base.Request["id"].ToString() + "'");
if (dt.Rows.Count == 1)
{
dr["NUM"] = dt.Rows[0]["NUM"];
}
else
{
dr["NUM"] = "0";
}
}
this.gvResource.DataSource = table;
this.gvResource.DataBind();
}
else
{
this.gvResource.DataSource = null;
this.gvResource.DataBind();
}
}
