protected void BindGrid()
{
int TotalNum = 0;
DataView dv = new FrameSearchDesign().Select(txtTitle.Text.Trim(),txtDescription.Text.Trim(), Pager.PageSize, Pager.CurrentPageIndex, out TotalNum);
grdList.DataSource = dv;
grdList.DataBind();
FrameCommon FC = new FrameCommon();
//���÷�ҳ��Ϣ
FC.SetPagerInfo(Pager, TotalNum, Pager.PageSize, Pager.CurrentPageIndex);
//����һ��js����������ǿ��ִ��datagrid����ɫ�任���粻�ã���updatapanel�����ݸ��º�������datagridcolor.js��ִ��
CallJsFun("ChangeColor();");
}
/// <summary>
/// ά��״̬ʱ����ԭ�ȵ�ֵ����
/// </summary>
/// <param name="DesignGuid"></param>
protected void SetValue(string DesignGuid)
{
DataView dv = new FrameSearchDesign().Select(DesignGuid);
txtSearchName.Text = dv[0]["SearchName"].ToString();
txtSQL.Text = dv[0]["SQL"].ToString();
txtCSCode.Text = dv[0]["CSCode"].ToString();
txtSearchFields.Text = dv[0]["SearchFields"].ToString();
txtLabel.Text = dv[0]["Labels"].ToString();
hidSWFName.Value = dv[0]["ChartType"].ToString();
txtSeriesName.Text = dv[0]["SeriesName"].ToString();
txtCaption.Text = dv[0]["ChartCaption"].ToString();
txtXName.Text = dv[0]["XName"].ToString();
txtYName.Text = dv[0]["YName"].ToString();
txtWidth.Text = dv[0]["ChartWidth"].ToString();
txtHeight.Text = dv[0]["ChartHeight"].ToString();
txtDescription.Text = dv[0]["Description"].ToString();
//�������ַ����з�������ֵ
FrameCommon FC=new FrameCommon();
string ConfigValue = dv[0]["ConfigValue"].ToString();
string numfix = FC.FindValueFromStr(ConfigValue, "numberSuffix=", " ");
if (numfix != "")
{
txtFlag.Text = numfix.Replace("'","");
rbAfter.Checked = true;
}
else
{
numfix = FC.FindValueFromStr(ConfigValue, "numberPrefix=", " ");
if (numfix != "")
{
txtFlag.Text = numfix.Replace("'", "");
rbBefore.Checked = true;
}
}
if (ConfigValue.IndexOf("labelDisplay='Rotate'") != -1)
{
rbXLBRotate.Checked = true;
}
else if (ConfigValue.IndexOf("labelDisplay='Stagger'") != -1)
{
rbXLBStagger.Checked = true;
}
else
{
rbXLBNormal.Checked = true;
}
string Angle = FC.FindValueFromStr(ConfigValue, "bgAngle=", " ").Replace("'","");
if (Angle.Trim() != "")
{
txtAngle.Text = Angle.Trim();
string BgColor = FC.FindValueFromStr(ConfigValue, "bgColor=", " ").Replace("'", "");
txtColorFrom.Text = BgColor.Split(',')[0];
txtColorFrom.Style.Add("color", "#" + txtColorFrom.Text);
txtColorTo.Text = BgColor.Split(',')[1];
txtColorTo.Style.Add("color", "#" + txtColorTo.Text);
}
//����ѡ���ͼ�����ƣ�ģ�����¼�
switch (hidSWFName.Value.ToLower())
{
case "column2d.swf":
hidFlash.Value = "rbSingleC2D";
hidState.Value = "Single";
rbSingle.Checked = true;
rbSingleC2D.Checked = true;
trSingle.Style["display"] = "block";
break;
case "column3d.swf":
hidFlash.Value = "rbSingleC3D";
hidState.Value = "Single";
rbSingle.Checked = true;
rbSingleC3D.Checked = true;
trSingle.Style["display"] = "block";
break;
case "pie2d.swf":
hidFlash.Value = "rbSingleP2D";
hidState.Value = "Single";
rbSingle.Checked = true;
rbSingleP2D.Checked = true;
trSingle.Style["display"] = "block";
break;
case "pie3d.swf":
hidFlash.Value = "rbSingleP3D";
hidState.Value = "Single";
rbSingle.Checked = true;
rbSingleP3D.Checked = true;
trSingle.Style["display"] = "block";
break;
case "line.swf":
hidFlash.Value = "rbSingleL2D";
hidState.Value = "Single";
rbSingle.Checked = true;
rbSingleL2D.Checked = true;
trSingle.Style["display"] = "block";
break;
case "mscolumn2d.swf":
hidFlash.Value = "rbMultiC2D";
hidState.Value = "Multi";
rbMulti.Checked = true;
rbMultiC2D.Checked = true;
trMulti.Style["display"] = "block";
break;
case "mscolumn3d.swf":
hidFlash.Value = "rbMultiC3D";
hidState.Value = "Multi";
rbMulti.Checked = true;
rbMultiC3D.Checked = true;
trMulti.Style["display"] = "block";
break;
case "msline.swf":
hidFlash.Value = "rbMultiL2D";
hidState.Value = "Multi";
rbMulti.Checked = true;
rbMultiL2D.Checked = true;
trMulti.Style["display"] = "block";
break;
case "stackedColumn2d.swf":
hidFlash.Value = "rbStackedC2D";
hidState.Value = "Stacked";
rbStacked.Checked = true;
rbStackedC2D.Checked = true;
trStacked.Style["display"] = "block";
break;
case "stackedColumn3d.swf":
hidFlash.Value = "rbStackedC3D";
hidState.Value = "Stacked";
rbStacked.Checked = true;
rbStackedC3D.Checked = true;
trStacked.Style["display"] = "block";
break;
default: break;
}
this.KeepState();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
//��ȡ��ѯ��������Ϣ
string DesignGuid = Request.QueryString["DesignGuid"].ToString();
DataView dv = new FrameSearchDesign().Select(DesignGuid);
string SqlStr = dv[0]["SQL"].ToString();
string[] SearchFields = dv[0]["SearchFields"].ToString().Split(';');
string Labels = dv[0]["Labels"].ToString();
string SeriesName = dv[0]["SeriesName"].ToString();
string Caption = dv[0]["ChartCaption"].ToString();
string XName = dv[0]["XName"].ToString();
string YName = dv[0]["YName"].ToString();
string ChartWidth = dv[0]["ChartWidth"].ToString().Trim();
ChartWidth =( ChartWidth == "" ? "450" : ChartWidth);
string ChartHeight = dv[0]["ChartHeight"].ToString().Trim();
ChartHeight = (ChartHeight == "" ? "350" : ChartHeight);
string ChartType = dv[0]["ChartType"].ToString();
string ConfigValue = dv[0]["ConfigValue"].ToString();
string VarFlag = ""; //SQL�������ͣ�OracleΪ����SQLServerΪ@
if (SqlStr.IndexOf(":") > 0)
VarFlag = ":";
else if (SqlStr.IndexOf("@") > 0)
VarFlag = "@";
//����в����������滻��SQL��
if(ViewState["MyControl"].ToString()!="")
{
string[] MyControlList = ViewState["MyControl"].ToString().Split(';');
for (int i = 0; i < MyControlList.Length; i++)
{
string[] ControlInfo = MyControlList[i].ToString().Split(':');
if (ControlInfo[1] == "string")
{
TextBox txt = new TextBox();
txt = (TextBox)trHolder.FindControl(ControlInfo[0]);
if (txt.Text.Trim() == "")
{
//���Ϊ�գ�����Ҫ��SQL�и��ֶ�ɾ��
SqlStr = DeleteSQLVar(SqlStr, ControlInfo[0], SearchFields);
}
else
{
//�滻
SqlStr = SqlStr.Replace(" like " + VarFlag + ControlInfo[0], " like '%" + txt.Text.Trim() + "%'");
SqlStr = SqlStr.Replace(VarFlag + ControlInfo[0], "'" + txt.Text.Trim() + "'");
}
}
else if (ControlInfo[1] == "number")
{
ZJGEport.WebControls35.TextBoxControls.NumericTextBox ntb = new ZJGEport.WebControls35.TextBoxControls.NumericTextBox();
ntb = (ZJGEport.WebControls35.TextBoxControls.NumericTextBox)trHolder.FindControl(ControlInfo[0]);
// ShowJsMessage(ntb.Text);
if (ntb.Text.Trim() == "")
{
//���Ϊ�գ�����Ҫ��SQL�и��ֶ�ɾ��
SqlStr = DeleteSQLVar(SqlStr, ControlInfo[0], SearchFields);
}
else
{
//�滻������ǣ�����like�������like����Ҫǰ���%
SqlStr = SqlStr.Replace(VarFlag + ControlInfo[0], ntb.Text);
}
}
else if (ControlInfo[1] == "datetime")
{
//���datebox����datefromto
if (ControlInfo[0].IndexOf("&") == -1) //datebox
{
ZJGEport.WebControls35.DateTextBox dtb = new ZJGEport.WebControls35.DateTextBox();
dtb = (ZJGEport.WebControls35.DateTextBox)trHolder.FindControl(ControlInfo[0]);
if (dtb.Text.Trim() == "")
{
SqlStr = DeleteSQLVar(SqlStr, ControlInfo[0], SearchFields);
}
else
{
if (VarFlag == "@")
SqlStr = SqlStr.Replace(VarFlag + ControlInfo[0], "'" + dtb.Text + "'");
else if(VarFlag == ":")
SqlStr = SqlStr.Replace(VarFlag + ControlInfo[0], "TO_DATE('" + dtb.Text + "','yyyy-mm-dd')");
}
}
else //datefromto
{
ZJGEport.WebControls35.DateFromTo dft = new ZJGEport.WebControls35.DateFromTo();
dft = (ZJGEport.WebControls35.DateFromTo)trHolder.FindControl(ControlInfo[0]);
//��dateFromTo�����
string From = dft.FromText.Trim();
if (From == "")
{
From = "1900/1/1";
}
string To=dft.ToText.Trim();
if (To == "")
{
To = "2099/1/1";
}
//��ȡ������������
string DateFromVar = ControlInfo[0].Split('&')[0];
string DateToVar = ControlInfo[0].Split('&')[1];
if (VarFlag == "@")
{
SqlStr = SqlStr.Replace(VarFlag + DateFromVar, "'" + From + "'");
SqlStr = SqlStr.Replace(VarFlag + DateToVar, "'" + To + "'");
}
else if (VarFlag == ":")
{
SqlStr = SqlStr.Replace(VarFlag + DateFromVar, "TO_DATE('" + From + "','yyyy-mm-dd')");
SqlStr = SqlStr.Replace(VarFlag + DateToVar, "TO_DATE('" + To + "','yyyy-mm-dd')");
}
}
}
}
}
dv = new FrameSearchDesign().GetDataBySQL(SqlStr);
if (dv.Count == 0)
{
ShowJsMessage("û�����ݿ�����ʾ��");
return;
}
StringBuilder strXML = new StringBuilder();
//���ݲ�ͬ��ͼ�����ͼ���ͷ
int palette = new System.Random().Next(1, 6);
strXML.Append("<chart palette='" + palette + "' caption='");
strXML.Append(Caption);
strXML.Append("' xAxisName='");
strXML.Append(XName);
strXML.Append("' yAxisName='");
strXML.Append(YName);
strXML.Append("' rotateYAxisName='0' baseFontSize='12' alternateHGridColor='FCB541' lineColor='FCB541' divLineColor='FCB541' showValues='1' decimals='0' formatNumberScale='0' useRoundEdges='1' " + ConfigValue + " >");
//����ͼ������ݲ��֣���Ϊ��ϵ�кͶ�ϵ��
//��ϵ�в���
if (ChartType.ToLower() == "column2d.swf" || ChartType.ToLower() == "column3d.swf" || ChartType.ToLower() == "line.swf" || ChartType.ToLower() == "pie2d.swf" || ChartType.ToLower() == "pie3d.swf")
{
for (int i = 0; i < dv.Count; i++)
{
strXML.AppendFormat("<set label='{0}' value='{1}' />", dv[i][Labels].ToString(), dv[i][SeriesName].ToString());
}
}
else //��ϵ�в��ֺͶ�ϵ�в���
{
}
strXML.Append("</chart>");
string outPut = FusionCharts.RenderChartHTML("/ChartsView/" + ChartType, "", strXML.ToString(), "chart1", ChartWidth, ChartHeight, false, false);
phChart.Controls.Add(new LiteralControl(outPut));
}
protected void ViewChart()
{
ViewState["MyControl"] = ""; //���ڱ��浱ǰ�ؼ���ID�Ϳؼ������ͣ�
string DesignGuid = Request.QueryString["DesignGuid"].ToString();
DataView dv = new FrameSearchDesign().Select(DesignGuid);
this.CurrentPosition = dv[0]["ChartCaption"].ToString();
string SQL = dv[0]["SQL"].ToString();
//������������ؼ�
string[] SearchFields = dv[0]["SearchFields"].ToString().Split(';');
//����ͬһ��������ֻ����һ�Σ�����ʱ�����͵ģ�����ǡ�������һ��ʱ��ѡ����ڡ�> <����Χ���͵ģ�����һ��datefomto
ArrayList oneTimeVar = new ArrayList();
for (int i = 0; i < SearchFields.Length; i++)
{
if (SearchFields[i].Trim() != "" && !oneTimeVar.Contains(SearchFields[i].Trim()))
oneTimeVar.Add(SearchFields[i].Trim());
}
for (int i = 0; i < oneTimeVar.Count; i++)
{
if (oneTimeVar[i].ToString() != ":::")
{
bool IsDateTimeType = false;
if (oneTimeVar[i].ToString().Split(':')[3].ToLower() == "datetime")
IsDateTimeType = true;
TableCell tc = new TableCell();
string[] Lables = oneTimeVar[i].ToString().Split(':');
Label lb = new Label();
lb.Text = " " + Lables[0];
tc.Controls.Add(lb); //��ӿؼ�����
trHolder.Controls.Add(tc);
if (!IsDateTimeType) //������ʱ���Ϳؼ�
{
//�жϴ����������͵������
TableCell tc1 = new TableCell();
if (Lables[3].ToString().Trim().ToLower() == "string")
{
TextBox tb = new TextBox();
tb.ID = Lables[2].ToString().Trim();
if (ViewState["MyControl"].ToString() == "")
{
ViewState["MyControl"] = tb.ID + ":string";
}
else
{
ViewState["MyControl"] =ViewState["MyControl"].ToString()+ ";" + tb.ID + ":string";
}
tb.Width = Unit.Pixel(150);
tb.MaxLength = 20;
tc1.Controls.Add(tb);
}
else if (Lables[3].ToString().Trim().ToLower() == "number")
{
ZJGEport.WebControls35.TextBoxControls.NumericTextBox ntb = new ZJGEport.WebControls35.TextBoxControls.NumericTextBox();
ntb.ID = Lables[2].ToString().Trim();
if (ViewState["MyControl"].ToString() == "")
{
ViewState["MyControl"] = ntb.ID + ":number";
}
else
{
ViewState["MyControl"] = ViewState["MyControl"].ToString() + ";" + ntb.ID + ":number";
}
ntb.Width = Unit.Pixel(60);
ntb.MaxLength = 10;
tc1.Controls.Add(ntb);
}
trHolder.Controls.Add(tc1);
}
else //����DateTime�ؼ�
{
TableCell tc1 = new TableCell();
//���ݸò�ѯ�ֶ�����Ӧ��SQL�ֶη���������ֻ����һ������datetime��������������������datefromto
string label2 = Lables[1].ToString().Trim();
int k = 0;
for (; k < oneTimeVar.Count; k++)
{
string[] tmp = oneTimeVar[k].ToString().Split(':');
if (k != i && label2 == tmp[1].Trim() && tmp[3].Trim().ToLower() == "datetime")
{
//����datefromto
ZJGEport.WebControls35.DateFromTo dft = new ZJGEport.WebControls35.DateFromTo();
dft.ID = Lables[2].Trim()+"&"+tmp[2].Trim();
if (ViewState["MyControl"].ToString() == "")
{
ViewState["MyControl"] = dft.ID + ":datetime";
}
else
{
ViewState["MyControl"] = ViewState["MyControl"].ToString() + ";" + dft.ID + ":datetime";
}
dft.FromWidth = Unit.Pixel(80);
dft.ToWidth = Unit.Pixel(80);
tc1.Controls.Add(dft);
//��������Ӧ���ֶ�����������ѹ��������ֶ��ٴι���
oneTimeVar[k] = ":::";
oneTimeVar[i] = ":::";
break;
}
}
//���û���ҵ�����datetime
if (k == oneTimeVar.Count)
{
ZJGEport.WebControls35.DateTextBox dtb = new ZJGEport.WebControls35.DateTextBox();
dtb.ID = Lables[2].ToString().Trim();
if (ViewState["MyControl"].ToString() == "")
{
ViewState["MyControl"] = dtb.ID + ":datetime";
}
else
{
ViewState["MyControl"] = ViewState["MyControl"].ToString() + ";" + dtb.ID + ":datetime";
}
dtb.Width = Unit.Pixel(80);
dtb.ID = Lables[2].ToString().Trim();
tc1.Controls.Add(dtb);
oneTimeVar[i] = ":::";
}
trHolder.Controls.Add(tc1);
}
}
}
}
