Infragistics中的UltraChart问题，解决给分，急。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。！！！！！！！！！！！

[frida111]

有两个问题
1、我怎么设置X轴和Y轴，比如说我X轴的数据已经得到了，怎么绑定上去？
2、我绑定后显示you must have at least one row and one numeric column而不显示曲线，是什么原因？

[ustbwuyi]

X轴不必另外绑定，你在绑定数据源的时候单独设置就可以了，给个例子吧

[ustbwuyi]

<igchart:UltraChart ID="ustbwuyi" Visible="false" runat="server" BackgroundImageFileName=""
ChartType="LineChart" EmptyChartText="Data Not Available. Please call UltraChart.Data.DataBind() after setting valid Data.DataSource"
ImageUrl="" Version="6.2" Width="765px" Height="422px">
<Axis>
<Z LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">
<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"
Visible="False" />
<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"
Visible="True" />
<Labels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Near" ItemFormatString=""
Orientation="Horizontal" VerticalAlign="Center" Visible="False">
<Layout Behavior="Auto">
</Layout>
<SeriesLabels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Near" Orientation="Horizontal"
VerticalAlign="Center">
<Layout Behavior="Auto">
</Layout>
</SeriesLabels>
</Labels>
</Z>
<Y2 LineThickness="1" TickmarkInterval="20" TickmarkStyle="Smart" Visible="False">
<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"
Visible="False" />
<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"
Visible="True" />
<Labels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Near" ItemFormatString="<DATA_VALUE:00.##>"
Orientation="Horizontal" VerticalAlign="Center" Visible="False">
<Layout Behavior="Auto">
</Layout>
<SeriesLabels Font="Verdana, 7pt" FontColor="Gray" FormatString="" HorizontalAlign="Near"
Orientation="Horizontal" VerticalAlign="Center">
<Layout Behavior="Auto">
</Layout>
</SeriesLabels>
</Labels>
</Y2>
<X Extent="46" LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="True">
<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"
Visible="False" />
<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"
Visible="True" />
<Labels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Near" ItemFormatString="<ITEM_LABEL>"
Orientation="VerticalLeftFacing" VerticalAlign="Center">
<Layout Behavior="Auto">
</Layout>
<SeriesLabels Font="Verdana, 7pt" FontColor="DimGray" FormatString="" HorizontalAlign="Near"
Orientation="VerticalLeftFacing" VerticalAlign="Center">
<Layout Behavior="Auto">
</Layout>
</SeriesLabels>
</Labels>
</X>
<Y Extent="29" LineThickness="1" TickmarkInterval="20" TickmarkStyle="Smart" Visible="True">
<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"
Visible="False" />
<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"
Visible="True" />
<Labels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Far" ItemFormatString="<DATA_VALUE:00.##>"
Orientation="Horizontal" VerticalAlign="Center">
<Layout Behavior="Auto">
</Layout>
<SeriesLabels Font="Verdana, 7pt" FontColor="DimGray" FormatString="" HorizontalAlign="Far"
Orientation="Horizontal" VerticalAlign="Center">
<Layout Behavior="Auto">
</Layout>
</SeriesLabels>
</Labels>
</Y>
<X2 LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">
<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"
Visible="False" />
<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"
Visible="True" />
<Labels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Far" ItemFormatString="<ITEM_LABEL>"
Orientation="VerticalLeftFacing" VerticalAlign="Center" Visible="False">
<Layout Behavior="Auto">
</Layout>
<SeriesLabels Font="Verdana, 7pt" FontColor="Gray" FormatString="" HorizontalAlign="Far"
Orientation="VerticalLeftFacing" VerticalAlign="Center">
<Layout Behavior="Auto">
</Layout>
</SeriesLabels>
</Labels>
</X2>
<Z2 LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">
<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"
Visible="False" />
<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"
Visible="True" />
<Labels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Near" ItemFormatString=""
Orientation="Horizontal" VerticalAlign="Center" Visible="False">
<Layout Behavior="Auto">
</Layout>
<SeriesLabels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Near" Orientation="Horizontal"
VerticalAlign="Center">
<Layout Behavior="Auto">
</Layout>
</SeriesLabels>
</Labels>
</Z2>
</Axis>
<Tooltips Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" />
<Effects>
<Effects>
<igchartprop:gradienteffect>
</igchartprop:gradienteffect>
</Effects>
</Effects>
<ColorModel AlphaLevel="150" ModelStyle="CustomLinear">
</ColorModel>
</igchart:UltraChart>

[ustbwuyi]

protected void Boating_Changed(object sender, EventArgs e)
{
KMS.Components.DpdataProvider DDP = new DpdataProvider();
string boatName = Boating.SelectedValue;
DataTable data = DDP.GetUltraChartData(boatName);
DataTable data1 = ConvertDataTable(data);
ustbwuyi.DataSource = data1;
ustbwuyi.DataBind();

}
public DataTable GetUltraChartData(string boatName)
{
//算起至时间
DateTime InitDay = GetStartTime(boatName);
DateTime NowDay = DateTime.Now;


DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("ColName", typeof(string)));
dt.Columns.Add(new DataColumn("TargetDate", typeof(int)));
dt.Columns.Add(new DataColumn("PlanDate", typeof(int)));


string All = GetAllCount(boatName).ToString();

for (DateTime time = InitDay; time < NowDay; time = time.AddDays(7))
{
int rshiFact = GetRshiPlanPer(boatName, time);
int ownerFactSend = GetFactSend(boatName, time);
int ownerFactQuit = GetFactQuit(boatName, time);

int rshiPlan = GetRshiPlanPer1(boatName, time);
int ownerPlanSend = GetFactSend1(boatName, time);
int ownerPlanQuit = GetFactQuit1(boatName, time);
int FactPer = int.Parse(rshiFact.ToString()) * 30 / int.Parse(All) + int.Parse(ownerFactSend.ToString()) * 20 / int.Parse(All) + int.Parse(ownerFactQuit.ToString()) * 50 / int.Parse(All);
int PlanPer = int.Parse(rshiPlan.ToString()) * 30 / int.Parse(All) + int.Parse(ownerPlanSend.ToString()) * 20 / int.Parse(All) + int.Parse(ownerPlanQuit.ToString()) * 50 / int.Parse(All);
DataRow dr = dt.NewRow();

string week = time.DayOfYear.ToString();
int week1 = int.Parse(week) / 7;

string year = time.Year.ToString();


dr["ColName"] = year.Substring(year.Length - 2, 2) + "-" + week1.ToString() + "周";
dr["TargetDate"] = FactPer;
dr["PlanDate"] = PlanPer;

dt.Rows.Add(dr);
}
return dt;


}
public DataTable ConvertDataTable(DataTable cdt)
{
DataTable dt = new DataTable();

for (int i = 0; i < cdt.Rows.Count; i++)
{
dt.Columns.Add(new DataColumn(cdt.Rows[i][0].ToString(), typeof(int)));
}

DataRow DrTargetCount = dt.NewRow();
DataRow DrReceiveCount = dt.NewRow();
for (int i = 0; i < dt.Columns.Count; i++)
{
DrTargetCount[i] = cdt.Rows[i][1];
DrReceiveCount[i] = cdt.Rows[i][2];
}
dt.Rows.Add(DrTargetCount);
dt.Rows.Add(DrReceiveCount);
return dt;
}