菜鸟求救 麻烦高手帮忙改下 不显示数据啊
//为result添加DataColumn对象
result.Columns.Add(new DataColumn("rvencode", typeof(string)));//供应商代码
result.Columns.Add(new DataColumn("rvenname", typeof(string)));//名称
result.Columns.Add(new DataColumn("rinvcode", typeof(string)));//存货编码
result.Columns.Add(new DataColumn("rinvname", typeof(string)));//存或名称
result.Columns.Add(new DataColumn("rlastpo", typeof(string)));//最近po
result.Columns.Add(new DataColumn("rlastquality", typeof(float)));//最近采购数量
result.Columns.Add(new DataColumn("rlastisum", typeof(float)));//最近采购金额
result.Columns.Add(new DataColumn("rliunitprice", typeof(float)));//系统最低价
result.Columns.Add(new DataColumn("rmiunitprice", typeof(float)));//系统最高价
result.Columns.Add(new DataColumn("rniunitprice", typeof(Single)));//最新价
result.Columns.Add(new DataColumn("raiunitprice", typeof(Single)));//平均价
result.Columns.Add(new DataColumn("rtyearaver", typeof(Single)));//今年平均价
result.Columns.Add(new DataColumn("rbyearaver", typeof(Single)));//去年平均价
result.Columns.Add(new DataColumn("rtyearjqaver", typeof(Single)));//今年加权平均价
result.Columns.Add(new DataColumn("rbyearjqaver", typeof(Single)));//去年加权平均价
//strsql = strsql + "select cvencode,cinvcode from PO_Pomian,PO_Podetails";
//if (txtvendor1.Text.Trim() != "")
//{
// strsql = strsql + " where cvencode>='" + txtvendor1.Text.Trim() + "' and cvencode <= '" + txtvendor2.Text.Trim() + "'";
//}
//if (txtinvcode1.Text.Trim() != "")
//{
// strsql = strsql + " and cinvcode>='" + txtinvcode1.Text.Trim() + "' and cinvcode <='" + txtinvcode2.Text.Trim() + "'";
//}
//if (dtp1.Checked)
//{
// strsql = strsql + " and dPODate >='" + dtp1.Value + "' and dPODate <='" + dtp2.Value + "'";
//}
//strsql = strsql + " group BY cinvcode,cvencode";
strsqla = strsqla + "select cinvcode,cvencode from po_poview where 1=1";
if (txtvendor1.Text.Trim() != "")
{
strsqla = strsqla + " and cvencode='" + txtvendor1.Text.Trim() + "'and cvencode <= '" + txtvendor2.Text.Trim() + "'";
}
if (txtinvcode1.Text.Trim() != "")
{
strsqla = strsqla + " and cinvcode='" + txtinvcode1.Text.Trim() + "' and cinvcode <='" + txtinvcode2.Text.Trim() + "'";
}
if (dtp1.Checked)
{
strsqla = strsqla + " and dPODate >='" + dtp1.Value + "' and dPODate <='" + dtp2.Value + "'";
}
strsqla = strsqla + " group BY cinvcode,cvencode";
conn.Open();
SqlDataAdapter sqldtp = new SqlDataAdapter(strsqla, conn);
DataSet dt = new DataSet();
sqldtp.Fill(dt);
while (i <= (dt.Tables[0].Rows.Count - 1))
{
strsqlb = "";
strsqlb = strsqlb + "select vendor.cvencode,vendor.cvenname, inventory.cinvcode,inventory.cinvname,po_poview.cpoid,po_poview.iQuantity,po_poview.iunitprice,po_poview.isum,po_poview.dpodate";
strsqlb = strsqlb + " from Inventory inner join PO_POVIEW on Inventory.cInvCode= PO_POVIEW.cInvCode inner join vendor on PO_POVIEW.cVenCode = vendor.cvencode";
strsqlb = strsqlb + " where inventory.cinvcode = '" + dt.Tables[0].Rows[i]["cinvcode"].ToString() + "'";
strsqlb = strsqlb + " order by po_poview.dpodate desc";
SqlDataAdapter sqldap = new SqlDataAdapter(strsqlb, conn);
DataSet ddt = new DataSet();
sqldap.Fill(ddt);
DataRow drow = result.NewRow();
drow["rvencode"] = dtb.Rows[0]["cvencode"].ToString();//供应商代码
drow["rvenname"] = dtb.Rows[0]["cvenname"].ToString();//名称
drow["rinvcode"] = dtb.Rows[0]["cinvcode"].ToString();//存货代码
drow["rinvname"] = dtb.Rows[0]["cinvname"].ToString();//存货名称
drow["rlastpo"] = dtb.Rows[0]["cpoid"].ToString();//最近PO
drow["rlastquality"] = dtb.Rows[0]["iQuantity"];//数量
drow["rlastisum"] = dtb.Rows[0]["isum"];//金额
drow["rliunitprice"] = dtb.Compute("min(iunitprice)", "true"); //最低价
drow["rmiunitprice"] = dtb.Compute("max(iunitprice)", "true");//最高价
drow["rniunitprice"] = dtb.Rows[0]["iunitprice"];//最新价
drow["raiunitprice"] = dtb.Compute("Avg(iunitprice)", "");//平均价
//今年平均价
if ((int)dtb.Compute("count(iunitprice)", "dpodate >='2012-1-1'") > 0)
{
drow["rtyearaver"] = Convert.ToSingle(dtb.Compute("sum(iunitprice)", "dpodate >='2012-1-1'")) / Convert.ToSingle(dtb.Compute("count(iunitprice)", "dpodate >='2012-1-1'"));
}
else
{
drow["rtyearaver"] = 0;
}
//去年平均价
if ((int)dtb.Compute("count(iunitprice)", "dpodate>='2011-1-1'and dpodate<='2011-12-31'") > 0)
{
drow["rbyearaver"] = Convert.ToSingle(dtb.Compute("sum(iunitprice)", "dpodate>='2011-1-1'and dpodate<='2011-12-31'")) / Convert.ToSingle(dtb.Compute("count(iunitprice)", "dpodate>='2011-1-1'and dpodate<='2011-12-31'"));
}
else
{
drow["rbyearaver"] = "0";
}
//今年加权平均价
if ((int)dtb.Compute("count(isum)", "dpodate >='2012-1-1'") > 0)
{
drow["rtyearjqaver"] = Convert.ToSingle(dtb.Compute("sum(isum)", "dpodate >='2012-1-1'")) / Convert.ToSingle(dtb.Compute("count(isum)", "dpodate >='2012-1-1'"));
}
else
{
drow["rtyearjqaver"] = "0";
}
//去年加权平均价
if ((int)dtb.Compute("count(isum)", "dpodate>='2011-1-1'and dpodate<='2011-12-31'") > 0)
{
drow["rbyearjqaver"] = Convert.ToSingle(dtb.Compute("sum(isum)", "dpodate>='2011-1-1'and dpodate<='2011-12-31'")) / Convert.ToSingle(dtb.Compute("count(isum)", "dpodate>='2011-1-1' and dpodate<='2011-12-31'"));
}
else
{
drow["rbyearjqaver"] = "0";
}
result.Rows.Add(drow);
i++;
//dtb.Clear();
}
this.dataGridView1.DataSource = result.DefaultView;
}
[解决办法]
加上dataGridView1.databind();
只是指定了数据源，没有绑定，所以数据不显示。
