C# DataView.Dispose方法代码示例

 public string GetfeederActivationCode(string fid)
 {
     CheckHasRows();
     DataView dv = new DataView(dtfeeder);
     dv.RowFilter = "feederNumber = " + fid;
     string returnval = "";
     if (dv.Count > 0)
     {
         returnval = dv[0]["FeederActivationCode"].ToString();
     }
     dv.Dispose();
     return returnval;
 }

 public double GetfeederPosX(string fid)
 {
     CheckHasRows();
     DataView dv = new DataView(dtfeeder);
     dv.RowFilter = "feederNumber = " + fid;
     double returnval = 0.0;
     if (dv.Count > 0)
     {
         returnval = double.Parse(dv[0]["PosX"].ToString());
     }
     dv.Dispose();
     return returnval;
 }

 public void addData(int iAddCnt, int iScrollingRowIndex, DataView dv)
 {
     try
     {
         int iRowCnt = base.dgvLogData.Rows.Count + iAddCnt;
         int count = base.m_dvLogData.Count;
         int num3 = 0;
         if (iAddCnt >= base.iMaxLogCnt)
         {
             base.m_dtLogData.Rows.Clear();
             num3 = iAddCnt - base.iMaxLogCnt;
         }
         else if (iRowCnt > base.iMaxLogCnt)
         {
             for (int i = 1; i <= (iRowCnt - base.iMaxLogCnt); i++)
             {
                 base.m_dvLogData.Delete((int) (count - i));
             }
         }
         base.m_dvLogData.Sort = "";
         DataRow row = null;
         int num5 = 0;
         while (num3 < iAddCnt)
         {
             row = dv[num3].Row;
             num5 = base.dgvLogData.SelectedRows.Count;
             base.m_dtLogData.ImportRow(row);
             num3++;
         }
         base.SetCurrentRow(base.dgvLogData, iRowCnt, base.iMaxLogCnt, iAddCnt);
         num5 = base.dgvLogData.SelectedRows.Count;
         row = null;
         base.m_dvLogData.Sort = "ReceTime DESC";
         if (num5 == 0)
         {
             base.dgvLogData.ClearSelection();
         }
         if (iScrollingRowIndex >= 0)
         {
             base.dgvLogData.FirstDisplayedScrollingRowIndex = iScrollingRowIndex;
         }
         base.dgvLogData.Refresh();
         dv.Dispose();
         dv = null;
     }
     catch
     {
     }
 }

 public double GetComponentsHeight(string fid)
 {
     if (dscomponents.Tables.Count == 0)
     {
         POPComponentsTable();
     }
     DataView dv = new DataView(dscomponents.Tables[0]);
     dv.RowFilter = "ComponentCode = " + fid;
     double returnval = 0.0;
     if (dv.Count > 0)
     {
         returnval = double.Parse(dv[0]["ComponentHeight"].ToString());
     }
     dv.Dispose();
     return returnval;
 }

 public string GetfeederNumber(string fid)
 {
     if (ds.Tables.Count == 0)
     {
         POPFeedersTable();
     }
     DataView dv = new DataView(ds.Tables[0]);
     dv.RowFilter = "feederNumber = " + fid;
     string returnval = "";
     if (dv.Count > 0)
     {
         returnval = dv[0][0].ToString();
     }
     dv.Dispose();
     return returnval;
 }

 public double GetfeederPosX(string fid)
 {
     if (ds.Tables.Count == 0)
     {
         POPFeedersTable();
     }
     DataView dv = new DataView(ds.Tables[0]);
     dv.RowFilter = "feederNumber = " + fid;
     double returnval = 0.0;
     if (dv.Count > 0)
     {
         returnval = double.Parse(dv[0][2].ToString());
     }
     dv.Dispose();
     return returnval;
 }

 public string GetComponentPackage(string fid)
 {
     if (dscomponents.Tables.Count == 0)
     {
         POPComponentsTable();
     }
     DataView dv = new DataView(dscomponents.Tables[0]);
     dv.RowFilter = "ComponentCode = " + fid;
     string returnval = "";
     if (dv.Count > 0)
     {
         returnval = dv[0]["Package"].ToString();
     }
     dv.Dispose();
     return returnval;
 }

 public bool GetFeederPickPlusChipHeight(string fid)
 {
     CheckHasRows();
     DataView dv = new DataView(dtfeeder);
     dv.RowFilter = "feederNumber = " + fid;
     bool returnval = false;
     if (dv.Count > 0)
     {
         if (dv[0]["PickPlusChipHeight"].ToString().Equals("True"))
         {
             returnval = true;
         }
         else
         {
             returnval = false;
         }
     }
     dv.Dispose();
     return returnval;
 }

        public bool GetComponentTapeFeeder(string fid)
        {
            if (dscomponents.Tables.Count == 0)
            {
                POPComponentsTable();
            }
            DataView dv = new DataView(dscomponents.Tables[0]);
            dv.RowFilter = "ComponentCode = " + fid;
            bool returnval = false;
            if (dv.Count > 0)
            {

                if (dv[0]["TapeFeeder"].ToString().Equals("True"))
                {
                    returnval = true;
                }
                else
                {
                    returnval = false;
                }
            }
            dv.Dispose();
            return returnval;
        }

        private void worker_DoWork(object sender, DoWorkEventArgs e)
        {
           // run all background tasks here
            BackgroundWorker worker = sender as BackgroundWorker;
            DataTable dtComponents = dsData.Tables["Components"];
            DataView dv = new DataView(dtComponents);
            dv.RowFilter = "Pick = 1";
            int currentrow = 0;
            int totalrows = dv.Count;

            Nozzle1Xoffset = dh.Nozzle1Xoffset;
            Nozzle1Yoffset = dh.Nozzle1Yoffset;
            Nozzle2Xoffset = dh.Nozzle2Xoffset;
            Nozzle2Yoffset = dh.Nozzle2Yoffset;

            if (totalrows > 0)
            {

                /* Components table columns
                    ComponentCode
                    ComponentName
                    PlacementX
                    PlacementY
                    PlacementRotate
                    PlacementNozzle
                 
                 * component list
                 * ComponentCode
                 * ComponentValue
                 * Package
                 * 
                 * PlacementHeight
                 * FeederHeight
                 * FeederX
                 * FeederY
                 * VerifywithCamera
                 * TapeFeeder
               
                  
                 * */
                double pcbHeight = double.Parse(dsData.Tables["BoardInfo"].Rows[0][1].ToString());
               
                double feedrate = 20000;
                double feederPosX = 0;
                double feederPosY = 0;
                double feederPosZ = 0;
                double placePosX = 0;
                double placePosY = 0;
                //double placePosZ = 0;
               // double placePosA = 0;
               // double placePosRotateZ = 0;
               // double placePosRotateB = 0;
                double ComponentRotation = 0;
                double PlacementHeight = 0;
                int PlacementNozzle = 1;
                bool TapeFeeder = false;

                while (currentrow < totalrows)
                {

                    if (backgroundWorkerBuildPCB.CancellationPending)
                    {
                        e.Cancel = true;
                        dv.Dispose();
                        break;
                    }
                    PlacementNozzle = int.Parse(dv[currentrow]["PlacementNozzle"].ToString());


                    feederPosX = CalcXLocation(comp.GetFeederX(dv[currentrow]["ComponentCode"].ToString()),PlacementNozzle);
                    feederPosY = CalcYLocation(comp.GetFeederY(dv[currentrow]["ComponentCode"].ToString()),PlacementNozzle);

                    feederPosZ = comp.GetFeederHeight(dv[currentrow]["ComponentCode"].ToString());
                    PlacementHeight = comp.GetPlacementHeight(dv[currentrow]["ComponentCode"].ToString()) - pcbHeight;

                    TapeFeeder = comp.GetComponentTapeFeeder(dv[currentrow]["ComponentCode"].ToString()); 

                    placePosX = CalcXLocation(double.Parse(dv[currentrow]["PlacementX"].ToString()),PlacementNozzle);
                    placePosY = CalcYLocation(double.Parse(dv[currentrow]["PlacementY"].ToString()), PlacementNozzle);

                    ComponentRotation = double.Parse(dv[currentrow]["PlacementRotate"].ToString());


                    PlacementNozzle = int.Parse(dv[currentrow]["PlacementNozzle"].ToString());


                    if (currentrow == 0)
                    {
                        SetFeederOutputs(comp.GetFeederID(dv[currentrow]["ComponentCode"].ToString())); // send feeder to position
                    }
                   


                    kf.MoveSingleFeed(feedrate, feederPosX, feederPosY, ClearHeight, ClearHeight, 0, 0);


                    if (comp.GetComponentTapeFeeder(dv[currentrow]["ComponentCode"].ToString()))
                    {

                        while (!usbController.getFeederReadyStatus())
//.........这里部分代码省略.........

 private string Index_Ch_GetNav(string paramStr)
 {
     string paramValue = "";
     string str2 = "";
     string str3 = "";
     string str4 = "10";
     string str5 = "";
     this.GetParamValue(paramStr, "navcss", ref paramValue);
     this.GetParamValue(paramStr, "arrange", ref str2);
     this.GetParamValue(paramStr, "compart", ref str3);
     this.GetParamValue(paramStr, "navcount", ref str4);
     this.GetParamValue(paramStr, "target", ref str5);
     DataTable table = this.ChannelBll.GetList(false).ToTable();
     DataView view = new DataView(table);
     view.RowFilter = "isdisabled=0";
     StringBuilder builder = new StringBuilder();
     for (int i = 1; i <= view.Count; i++)
     {
         int chId = (int)view[i - 1]["chid"];
         string str6 = view[i - 1]["content"].ToString();
         string str7 = view[i - 1]["chname"].ToString();
         if (str2 == "true")
         {
             if (((i % int.Parse(str4)) == 0) && (i != view.Count))
             {
                 builder.Append(string.Format("<a href=\"{0}\" target=\"{1}\" title=\"{2}\" class=\"{3}\">{4}</a><br/>", new object[] { this.GetChannelUrl(chId), str5, str6, paramValue, str7 }));
             }
             else if (i == view.Count)
             {
                 builder.Append(string.Format("<a href=\"{0}\" target=\"{1}\" title=\"{2}\" class=\"{3}\">{4}</a>", new object[] { this.GetChannelUrl(chId), str5, str6, paramValue, str7 }));
             }
             else
             {
                 builder.Append(string.Format("<a href=\"{0}\" target=\"{1}\" title=\"{2}\" class=\"{3}\">{4}</a>{5}", new object[] { this.GetChannelUrl(chId), str5, str6, paramValue, str7, str3 }));
             }
         }
         else
         {
             builder.Append(string.Format("{0}<a href=\"{1}\" target=\"{2}\" title=\"{3}\" class=\"{4}\">{5}</a></br>", new object[] { str3, this.GetChannelUrl(chId), str5, str6, paramValue, str7 }));
         }
     }
     table.Dispose();
     view.Dispose();
     return builder.ToString();
 }

 private string GetIndexSpNav(string paramStr)
 {
     string paramValue = "";
     string str2 = "";
     string str3 = "";
     string str4 = "10";
     string str5 = "";
     this.GetParamValue(paramStr, "navcss", ref paramValue);
     this.GetParamValue(paramStr, "arrange", ref str2);
     this.GetParamValue(paramStr, "compart", ref str3);
     this.GetParamValue(paramStr, "navcount", ref str4);
     this.GetParamValue(paramStr, "target", ref str5);
     DataTable specials = this.SpecialBll.GetSpecials(0);
     DataView view = new DataView(specials);
     view.RowFilter = "islock=0";
     StringBuilder builder = new StringBuilder();
     for (int i = 0; i < view.Count; i++)
     {
         int specialId = (int)view[i]["ID"];
         string str6 = view[i]["SpecialCName"].ToString();
         if (str2 == "true")
         {
             if (i == int.Parse(str4))
             {
                 builder.Append("<a href='");
                 builder.Append(this.GetSpecialUrl(specialId, 1));
                 builder.Append("' target='");
                 builder.Append(str5);
                 builder.Append("' class='");
                 builder.Append(paramValue);
                 builder.Append("'>");
                 builder.Append(str6);
                 builder.Append("</a><br/>");
             }
             else if (i >= (view.Count - 1))
             {
                 builder.Append("<a href='");
                 builder.Append(this.GetSpecialUrl(specialId, 1));
                 builder.Append("' target='");
                 builder.Append(str5);
                 builder.Append("' class='");
                 builder.Append(paramValue);
                 builder.Append("'>");
                 builder.Append(str6);
                 builder.Append("</a>");
             }
             else
             {
                 builder.Append("<a href='");
                 builder.Append(this.GetSpecialUrl(specialId, 1));
                 builder.Append("' target='");
                 builder.Append(str5);
                 builder.Append("' class='");
                 builder.Append(paramValue);
                 builder.Append("'>");
                 builder.Append(str6);
                 builder.Append("</a>");
                 builder.Append(str3);
             }
         }
         else
         {
             builder.Append(str3);
             builder.Append("<a href='");
             builder.Append(this.GetSpecialUrl(specialId, 1));
             builder.Append("' target='");
             builder.Append(str5);
             builder.Append("' class='");
             builder.Append(paramValue);
             builder.Append("'>");
             builder.Append(str6);
             builder.Append("</a><br/>");
         }
     }
     specials.Dispose();
     view.Dispose();
     return builder.ToString();
 }

        public string bindPageInstitute(DataTable dtInstitute, DataTable dtInstAdmis)
        {
            string xAxis = "";
            string xData = "";
            string xData2 = "";

            StringBuilder builder = new StringBuilder();

            builder.Append("$(function () {");
            builder.Append("$('#container1').highcharts({").AppendLine();
            builder.Append("chart: {").AppendLine();
            builder.Append("type: 'bar'").AppendLine();
            builder.Append(" },").AppendLine();
            builder.Append("title: {").AppendLine();
            builder.Append("text: 'Institute Wise Admission (" + dtInstitute.Rows[0]["AcademicYear"].ToString() + ")' ").AppendLine();
            builder.Append(" },").AppendLine();
            builder.Append("subtitle: {").AppendLine();
            builder.Append("text: ''").AppendLine();
            builder.Append("},").AppendLine();
            builder.Append("xAxis: { type: 'category'").AppendLine();
            //for (int cnt = 0; cnt < dtResult.Rows.Count; cnt++)
            //{
            //    if (cnt == (dtResult.Rows.Count - 1))
            //    {
            //        xAxis = xAxis + "'" + dtResult.Rows[cnt]["Institute"].ToString() + "'";
            //    }
            //    else
            //        xAxis = xAxis + "'" + dtResult.Rows[cnt]["Institute"].ToString() + "',";
            //}
            //builder.Append("categories: [" + xAxis.ToString() + " ],").AppendLine();
            //builder.Append("crosshair: true").AppendLine();
            builder.Append(" },").AppendLine();
            builder.Append("yAxis: {  title: { text: 'No Of Students' }},").AppendLine();
            builder.Append("legend: { enabled: false },").AppendLine();
            builder.Append("tooltip: {headerFormat: '<span style='font-size:10px'>{point.key}</span><table>',").AppendLine();
            builder.Append("pointFormat: '<tr><td style='color:{series.color};padding:0'>{series.name}: </td>' +").AppendLine();
            builder.Append("'<td style='padding:0'><b>{point.y:.1f} Students </b></td></tr>',").AppendLine();
            builder.Append("footerFormat: '</table>', shared: true,useHTML: true },").AppendLine();
            builder.Append("plotOptions: { series: { pointPadding: 0, borderWidth: 0, dataLabels: { enabled: true } }},").AppendLine();
            //builder.Append("legend: {layout: 'vertical', align: 'right', verticalAlign: 'top', x: -40, y: 80, floating: true, borderWidth: 1, backgroundColor: ((Highcharts.theme && Highcharts.theme.legendBackgroundColor) || '#FFFFFF'), shadow: true},").AppendLine();
            builder.Append("series: [{").AppendLine();
            builder.Append("name: 'Institute', colorByPoint: true,").AppendLine();

            for (int cnt = 0; cnt < dtInstitute.Rows.Count; cnt++)
            {
                DataView dv = new DataView(dtInstAdmis);
                dv.RowFilter = " Institute = '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "'";
                DataTable dt = new DataTable();
                string dataInner = "";
                if (dv != null)
                {
                    dt = dv.ToTable();
                    dv.Dispose();

                    if (dt.Rows.Count > 0)
                    {
                        for (int cnt1 = 0; cnt1 < dt.Rows.Count; cnt1++)
                        {
                            if (cnt1 == (dt.Rows.Count - 1))
                            {
                                dataInner = dataInner + "" + " [ '" + dt.Rows[cnt1]["AdmissionType"].ToString() + "', " + dt.Rows[cnt1]["TotalStudent"].ToString() + "]";
                            }
                            else
                            {

                                dataInner = dataInner + "" + " [ '" + dt.Rows[cnt1]["AdmissionType"].ToString() + "', " + dt.Rows[cnt1]["TotalStudent"].ToString() + "],";
                            }
                        }
                    }
                    else
                    {
                        dataInner = "";
                    }
                }
                if (cnt == (dtInstitute.Rows.Count - 1))
                {
                    xData = xData + "" + " { name: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', y: " + dtInstitute.Rows[cnt]["TotalStudent"].ToString() + ", drilldown: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "'}";

                    if (dataInner !="")
                        xData2 = xData2 + "" + " { name: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', id: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', data: [" + dataInner + " ]}";
                }
                else
                {
                    xData = xData + "" + " { name: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', y: " + dtInstitute.Rows[cnt]["TotalStudent"].ToString() + ", drilldown: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "'},";
                    if (dataInner!="")
                        xData2 = xData2 + "" + " { name: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', id: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "',data: [" + dataInner + " ]},";
                }
            }
            builder.Append("data: [" + xData + "]").AppendLine();
            builder.Append("}] ").AppendLine();
            builder.Append(", drilldown: { series: [").AppendLine();
            builder.Append("" + xData2 + "").AppendLine();
            builder.Append("] } ").AppendLine(); ///series End

            builder.Append("}); }); ").AppendLine();
            string innerString = builder.ToString().Replace("style='", "style=\"").Replace("'>", "\">");

            return innerString;
              //  System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Submitted", innerString, true);
        }

    private void Bind()
    {
        int ChType = 1;
        B_Dictionary dictionBll = new B_Dictionary();
        DataTable chTypeDt = dictionBll.GetDictionary(ChType);

        for (int i = 0; i < chTypeDt.Rows.Count; i++)
        {
            TreeNode chTypeNode = new TreeNode();
            chTypeNode.ToolTip = "分类右键操作$" + chTypeDt.Rows[i]["id"].ToString();
            chTypeNode.Text = chTypeDt.Rows[i]["DicName"].ToString();
            chTypeNode.ImageUrl = "~/system/images/category.gif";
            chTypeNode.NavigateUrl = "~/system/info/ChannelList.aspx?ChType=" + chTypeDt.Rows[i]["id"].ToString();
            chTypeNode.Target = "ContentIframe";
            tvNav.Nodes.Add(chTypeNode);
        }
        TreeNode chTypeOtherNode = new TreeNode();
        chTypeOtherNode.ToolTip = "分类右键操作$0";
        chTypeOtherNode.Text = "其他";
        chTypeOtherNode.ImageUrl = "~/system/images/category.gif";
        chTypeOtherNode.NavigateUrl = "~/system/info/ChannelList.aspx?ChType=0";
        chTypeOtherNode.Target = "ContentIframe";
        tvNav.Nodes.Add(chTypeOtherNode);

        B_Channel channelBll = new B_Channel();
        B_Column columnBll = new B_Column();
        DataView channelDv = channelBll.GetList(false);

        for (int i = 0; i < tvNav.Nodes.Count-1; i++)
        {
            int chType = int.Parse(chTypeDt.Rows[i]["id"].ToString());

            DataTable chDt = channelDv.ToTable();

            DataView chTypeDv = new DataView(chDt);
            chTypeDv.RowFilter=string.Format("[chtype]={0}",chType);
            for (int j = 0; j < chTypeDv.Count; j++)
            {
                TreeNode channelNode = new TreeNode();
                channelNode.ToolTip = "频道右键操作$" + chTypeDv[j]["ChId"].ToString() + "$" + chTypeDv[j]["ChType"].ToString();
                channelNode.Text = chTypeDv[j]["ChName"].ToString();
                channelNode.ImageUrl = "~/system/images/folder.gif";
                channelNode.NavigateUrl = "~/system/info/ColumnList.aspx?ChId=" + chTypeDv[j]["ChId"];
                channelNode.Target = "ContentIframe";
                tvNav.Nodes[i].ChildNodes.Add(channelNode);
            }

            for (int j = 0; j < chTypeDv.Count; j++)
            {
                DataView dv = columnBll.GetColumnListByChannelId((int)chTypeDv[j]["ChId"]);
                DataTable dt = dv.ToTable();
                dv.Dispose();
                BindColumn(0, tvNav.Nodes[i].ChildNodes[j], dt, (int)chTypeDv[j]["ModelType"], (int)chTypeDv[j]["ChId"]);
            }
            chDt.Dispose();
            chTypeDv.Dispose();
        }
        DataTable chDt2 = channelDv.ToTable();
        DataView chTypeDv2 = new DataView(chDt2);
        chTypeDv2.RowFilter = "[chtype]=0 or [chtype] is null";
        for (int j = 0; j < chTypeDv2.Count; j++)
        {
            TreeNode channelNode = new TreeNode();
            channelNode.ToolTip = "频道右键操作$" + chTypeDv2[j]["ChId"].ToString() + "$" + chTypeDv2[j]["ChType"].ToString();
            channelNode.Text = chTypeDv2[j]["ChName"].ToString();
            channelNode.ImageUrl = "~/system/images/folder.gif";
            channelNode.NavigateUrl = "~/system/info/ColumnList.aspx?ChId=" + chTypeDv2[j]["ChId"];
            channelNode.Target = "ContentIframe";
            tvNav.Nodes[tvNav.Nodes.Count - 1].ChildNodes.Add(channelNode);
        }
        for (int j = 0; j < chTypeDv2.Count; j++)
        {
            DataView dv = columnBll.GetColumnListByChannelId((int)chTypeDv2[j]["ChId"]);
            DataTable dt = dv.ToTable();
            dv.Dispose();
            BindColumn(0, tvNav.Nodes[tvNav.Nodes.Count - 1].ChildNodes[j], dt, (int)chTypeDv2[j]["ModelType"], (int)chTypeDv2[j]["ChId"]);
        }
        chDt2.Dispose();
        chTypeDv2.Dispose();
    }

    private void PopulateDropDowns()
    {
        //getting all the drop downs and applying filter
        foreach (Control ctrl in pageControls)
        {
            if (ctrl.GetType().Name == "DropDownList")
            {
                DropDownList ddl = (DropDownList)ctrl;
                DataView dv = new DataView(lookUp, "ControlName='" + ddl.ID + "'", "SortOrder ", DataViewRowState.CurrentRows);

                if (dv.Count > 0)
                {
                    ddl.Items.Add(new ListItem("", ""));
                    ddl.AppendDataBoundItems = true;
                    ddl.DataSource = dv;
                    ddl.DataTextField = "FieldValue";
                    ddl.DataValueField = "FieldDescription";
                    ddl.DataBind();

                    //checking for duplicate values
                    Dictionary<string, string> dups = new Dictionary<string, string>();
                    int dupCount = 1;
                    foreach (ListItem liDups in ddl.Items)
                    {
                        if (dups.ContainsKey(liDups.Value))
                        {
                            liDups.Value += "~" + dupCount.ToString();
                            dupCount++;
                        }
                        else
                        {
                            dups.Add(liDups.Value, "");
                        }
                    }

                    //selecting the default value
                    string defaultValue = dv[0]["DefaultValue"] == DBNull.Value ? "" : dv[0]["DefaultValue"].ToString();
                    ListItem li = ddl.Items.FindByValue(defaultValue);
                    if (li != null)
                    {
                        li.Selected = true;
                        //break;
                    }
                }
                dv.Dispose();
            }
        }
    }