C# DataSet.get_Tables方法代码示例

		public static DataSet GetParameterOptions(int paramId, int thisParamVal, DataSet optionDS)
		{
			int maskI = 255;
			DataSet dataSet = new DataSet();
			DataTable dataTable = new DataTable();
			IEnumerator enumerator = optionDS.get_Tables().get_Item(0).get_Columns().GetEnumerator();
			try
			{
				while (enumerator.MoveNext())
				{
					DataColumn dataColumn = (DataColumn)enumerator.get_Current();
					dataTable.get_Columns().Add(new DataColumn(dataColumn.get_ColumnName(), dataColumn.get_DataType()));
				}
			}
			finally
			{
				IDisposable disposable = enumerator as IDisposable;
				if (disposable != null)
				{
					disposable.Dispose();
				}
			}
			dataTable.get_Columns().Add(new DataColumn("Selected", typeof(bool)));
			dataTable.get_Columns().Add(new DataColumn("ValueText", typeof(string)));
			dataTable.get_Columns().Add(new DataColumn("Checked", typeof(string)));
			enumerator = optionDS.get_Tables().get_Item(0).get_Rows().GetEnumerator();
			try
			{
				while (enumerator.MoveNext())
				{
					DataRow dataRow = (DataRow)enumerator.get_Current();
					int num = Convert.ToInt32(dataRow.get_Item("fldParamGroupID"));
					int num2 = Convert.ToInt32(dataRow.get_Item("fldOptionVal"));
					int num3 = Convert.ToInt32(dataRow.get_Item("fldTypeID"));
					try
					{
						maskI = Convert.ToInt32(dataRow.get_Item("fldMask").ToString(), 2);
					}
					catch
					{
						maskI = 255;
					}
					switch (num3)
					{
					case 1:
					case 4:
					{
						DataRow dataRow2 = dataTable.NewRow();
						IEnumerator enumerator2 = optionDS.get_Tables().get_Item(0).get_Columns().GetEnumerator();
						try
						{
							while (enumerator2.MoveNext())
							{
								DataColumn dataColumn2 = (DataColumn)enumerator2.get_Current();
								dataRow2.set_Item(dataColumn2.get_ColumnName(), dataRow.get_Item(dataColumn2.get_ColumnName()));
							}
						}
						finally
						{
							IDisposable disposable = enumerator2 as IDisposable;
							if (disposable != null)
							{
								disposable.Dispose();
							}
						}
						string text = "0x" + num2.ToString("X2");
						bool flag;
						if (num3 == 1)
						{
							flag = Common.IsSelected(maskI, num2, thisParamVal);
						}
						else
						{
							flag = ((num2 & thisParamVal) == num2);
						}
						dataRow2.set_Item("Selected", flag);
						if (flag)
						{
							dataRow2.set_Item("Checked", "Checked");
						}
						dataRow2.set_Item("ValueText", text);
						dataTable.get_Rows().Add(dataRow2);
						break;
					}
					case 2:
					{
						num = 1;
						int i = 48;
						while (i < 122)
						{
							if (i <= 57 || (i >= 65 && i <= 90) || i >= 97)
							{
								DataRow dataRow3 = dataTable.NewRow();
								string text = Convert.ToChar(i).ToString();
								bool flag = Common.IsSelected(maskI, i, thisParamVal);
								dataRow3.set_Item("fldOptionVal", i);
								dataRow3.set_Item("fldTypeID", num3);
								dataRow3.set_Item("fldTypeDesc", Constants.OptionType.ASCII.ToString());
								dataRow3.set_Item("fldFullDesc", text);
								dataRow3.set_Item("fldOptionGroup", 1);
//.........这里部分代码省略.........

		public static ICollection GetDataSourceSelector(DataSet gds, int valField, int textField)
		{
			DataTable dataTable = new DataTable(gds.get_Tables().get_Item(0).get_TableName());
			dataTable.get_Columns().Add(new DataColumn(Constants.DropDownColumnTypes.Val, typeof(string)));
			dataTable.get_Columns().Add(new DataColumn(Constants.DropDownColumnTypes.Text, typeof(string)));
			DataRow dataRow = dataTable.NewRow();
			dataRow.set_Item(0, 0);
			dataRow.set_Item(1, Constants.Unassigned);
			dataTable.get_Rows().Add(dataRow);
			int count = gds.get_Tables().get_Item(0).get_Rows().get_Count();
			if (count > 0)
			{
				IEnumerator enumerator = gds.get_Tables().get_Item(0).get_Rows().GetEnumerator();
				try
				{
					while (enumerator.MoveNext())
					{
						DataRow dataRow2 = (DataRow)enumerator.get_Current();
						dataRow = dataTable.NewRow();
						dataRow.set_Item(0, dataRow2.get_Item(valField));
						dataRow.set_Item(1, dataRow2.get_Item(textField));
						dataTable.get_Rows().Add(dataRow);
					}
				}
				finally
				{
					IDisposable disposable = enumerator as IDisposable;
					if (disposable != null)
					{
						disposable.Dispose();
					}
				}
			}
			return new DataView(dataTable);
		}

		private void FillT5(ref DataSet ds, ref string message, int importType)
		{
			bool flag = false;
			int num = 0;
			int num2 = 0;
			string text = "";
			string text2 = "";
			string text3 = "";
			string text4 = "";
			int count = ds.get_Tables().get_Item(0).get_Rows().get_Count();
			int count2 = ds.get_Tables().get_Item(0).get_Columns().get_Count();
			int i = 0;
			while (i < count && !flag)
			{
				DataRow dataRow = ds.get_Tables().get_Item(0).get_Rows().get_Item(i);
				for (int j = 0; j < count2; j++)
				{
					string text5 = dataRow.get_Item(j).ToString().Trim();
					int num3 = text5.ToLower().IndexOf("parameter number", 0);
					if (num3 >= 0)
					{
						flag = true;
						num = i + 1;
						num2 = j;
						break;
					}
				}
				i++;
			}
			int num4 = 0;
			string text6 = "";
			if (flag)
			{
				for (i = num; i < count; i++)
				{
					DataRow dataRow2 = ds.get_Tables().get_Item(0).get_Rows().get_Item(i);
					string text7 = dataRow2.get_Item(num2).ToString().Trim();
					string text8 = dataRow2.get_Item(num2 + 1).ToString().Trim();
					string text9 = dataRow2.get_Item(num2 + 2).ToString().Trim();
					string text10 = dataRow2.get_Item(num2 + 3).ToString().Trim();
					string text11 = dataRow2.get_Item(num2 + 4).ToString().Trim();
					string text12 = dataRow2.get_Item(num2 + 5).ToString().Trim();
					string text13 = dataRow2.get_Item(num2 + 6).ToString().Trim();
					string text14 = dataRow2.get_Item(num2 - 1).ToString().Trim();
					if (text14 != "")
					{
						if (importType == 1)
						{
							text3 = text14.Replace("Block No ", "");
						}
						else
						{
							text3 = Convert.ToInt32(text14, 16).ToString();
						}
					}
					if (text7 != "")
					{
						text = text7.Trim(ParamSpec.TrimChars);
						text = text.Trim();
						DataRow dataRow3 = this.ss.Parameters.NewRow();
						dataRow3.set_Item("fldParameter", text);
						dataRow3.set_Item("fldName", text8);
						dataRow3.set_Item("fldFrame", text3);
						this.ss.Parameters.get_Rows().Add(dataRow3);
						num4 = 0;
						text2 = "";
						text6 = "";
					}
					if (text9 != "")
					{
						text2 = text9;
					}
					if (text11 != "")
					{
						DataRow dataRow4 = this.ss.Options.NewRow();
						dataRow4.set_Item("fldParameter", text);
						dataRow4.set_Item("fldDescription", text2);
						dataRow4.set_Item("fldSubDesc", text10);
						string value = this.GetValue(text13, text12, out text4);
						dataRow4.set_Item("fldValue", value);
						dataRow4.set_Item("fldError", value == "");
						try
						{
							dataRow4.set_Item("fldMask", text4.Substring(0, 8));
						}
						catch
						{
							dataRow4.set_Item("fldMask", text4);
						}
						if (dataRow4.get_Item("fldMask").ToString() != text6)
						{
							num4++;
						}
						text6 = dataRow4.get_Item("fldMask").ToString();
						dataRow4.set_Item("fldSplit", num4.ToString());
						dataRow4.set_Item("fldFormat", text12 + text13);
						dataRow4.set_Item("fldFormat", dataRow4.get_Item("fldFormat").ToString().Replace("0x0x", "0x"));
						dataRow4.set_Item("fldType", text11);
						dataRow4.set_Item("fldError", text11 == "");
						this.ss.Options.get_Rows().Add(dataRow4);
//.........这里部分代码省略.........

		private void FillEUCD(ref DataSet ds)
		{
			bool flag = false;
			int num = 0;
			string text = "";
			string text2 = "";
			int num2 = 0;
			int count = ds.get_Tables().get_Item(0).get_Rows().get_Count();
			int count2 = ds.get_Tables().get_Item(0).get_Columns().get_Count();
			int i = 0;
			while (i < count && !flag)
			{
				DataRow dataRow = ds.get_Tables().get_Item(0).get_Rows().get_Item(i);
				for (int j = 0; j < count2; j++)
				{
					string text3 = dataRow.get_Item(j).ToString().Trim();
					if (text3.ToLower() == "nbr")
					{
						flag = true;
						num = i + 1;
						num2 = j;
						break;
					}
				}
				i++;
			}
			if (flag)
			{
				for (i = num; i < count; i++)
				{
					DataRow dataRow2 = ds.get_Tables().get_Item(0).get_Rows().get_Item(i);
					string text4 = dataRow2.get_Item(num2).ToString().Trim();
					string text5 = dataRow2.get_Item(num2 + 1).ToString().Trim();
					string text6 = dataRow2.get_Item(num2 + 2).ToString().Trim();
					string text7 = dataRow2.get_Item(num2 + 11).ToString().Trim();
					string paramValue = dataRow2.get_Item(num2 + 8).ToString().Trim();
					try
					{
						text2 = text7.Substring(0, text7.ToLower().IndexOf("byte"));
						text2 = text2.Replace(":", "");
						text2 = text2.Replace("Block", "");
						text2 = text2.Trim();
					}
					catch
					{
						text2 = "";
					}
					if (text4 != "")
					{
						text = text4.Trim(ParamSpec.TrimChars);
						text = text.Trim();
						DataRow dataRow3 = this.ss.Parameters.NewRow();
						dataRow3.set_Item("fldParameter", text);
						dataRow3.set_Item("fldName", text5);
						dataRow3.set_Item("fldFrame", text2.Trim());
						this.ss.Parameters.get_Rows().Add(dataRow3);
					}
					if (text6 != "")
					{
						DataRow dataRow4 = this.ss.Options.NewRow();
						dataRow4.set_Item("fldParameter", text);
						dataRow4.set_Item("fldDescription", text6);
						dataRow4.set_Item("fldSplit", "1");
						dataRow4.set_Item("fldMask", "11111111");
						string text8 = Common.ConvertToInt(paramValue, 2).ToString();
						dataRow4.set_Item("fldValue", text8);
						dataRow4.set_Item("fldError", text8 == "");
						dataRow4.set_Item("fldType", Constants.Config.DefaultParamType);
						this.ss.Options.get_Rows().Add(dataRow4);
					}
				}
				return;
			}
		}

		protected override void ReadXmlSerializable(XmlReader reader)
		{
			this.Reset();
			DataSet dataSet = new DataSet();
			dataSet.ReadXml(reader);
			if (dataSet.get_Tables().get_Item("Frame") != null)
			{
				base.get_Tables().Add(new MulticanDataset.FrameDataTable(dataSet.get_Tables().get_Item("Frame")));
			}
			base.set_DataSetName(dataSet.get_DataSetName());
			base.set_Prefix(dataSet.get_Prefix());
			base.set_Namespace(dataSet.get_Namespace());
			base.set_Locale(dataSet.get_Locale());
			base.set_CaseSensitive(dataSet.get_CaseSensitive());
			base.set_EnforceConstraints(dataSet.get_EnforceConstraints());
			base.Merge(dataSet, false, 1);
			this.InitVars();
		}

		protected MulticanDataset(SerializationInfo info, StreamingContext context)
		{
			string text = (string)info.GetValue("XmlSchema", typeof(string));
			if (text != null)
			{
				DataSet dataSet = new DataSet();
				dataSet.ReadXmlSchema(new XmlTextReader(new StringReader(text)));
				if (dataSet.get_Tables().get_Item("Frame") != null)
				{
					base.get_Tables().Add(new MulticanDataset.FrameDataTable(dataSet.get_Tables().get_Item("Frame")));
				}
				base.set_DataSetName(dataSet.get_DataSetName());
				base.set_Prefix(dataSet.get_Prefix());
				base.set_Namespace(dataSet.get_Namespace());
				base.set_Locale(dataSet.get_Locale());
				base.set_CaseSensitive(dataSet.get_CaseSensitive());
				base.set_EnforceConstraints(dataSet.get_EnforceConstraints());
				base.Merge(dataSet, false, 1);
				this.InitVars();
			}
			else
			{
				this.InitClass();
			}
			base.GetSerializationData(info, context);
			CollectionChangeEventHandler collectionChangeEventHandler = new CollectionChangeEventHandler(this.SchemaChanged);
			base.get_Tables().add_CollectionChanged(collectionChangeEventHandler);
			base.get_Relations().add_CollectionChanged(collectionChangeEventHandler);
		}

//.........这里部分代码省略.........
								break;
							}
						}
						num3++;
					}
				}
				finally
				{
					IDisposable disposable = enumerator as IDisposable;
					if (disposable != null)
					{
						disposable.Dispose();
					}
				}
				if (vehicleModule.BuildTypes.get_Count() != arrayList.get_Count())
				{
					throw new CarConfigException("Incorrect no of blocks in import file compared to those in the database.");
				}
				int i = 1;
				for (int j = 0; j < vehicleModule.BuildTypes.get_Count(); j++)
				{
					int num10 = 1;
					BuildType buildType = (BuildType)vehicleModule.BuildTypes.get_Item(j);
					VDFBlock vDFBlock3 = (VDFBlock)arrayList.get_Item(j);
					int size = vDFBlock3.Size;
					if (buildType.FrameCount)
					{
						for (i = num3; i < size + num3; i++)
						{
							ConfigByte configByte3 = (ConfigByte)this.Params.get_Item(i - 1);
							if (num10 == 1)
							{
								dataSet = DataAccess.GetVehicleFrameParameterIDs(configByte3.ParamValue.ToString(), buildType.ID, this.VehicleInstId);
								if (dataSet.get_Tables().get_Item(0).get_Rows().get_Count() == 0)
								{
									text = text + "Frame 0x" + configByte3.ParamValueHex.ToString() + " does not exist in the database.  All bytes will not be imported.<br>";
									error = true;
								}
								else
								{
									num4 = configByte3.ParamValue;
								}
							}
							else if (dataSet.get_Tables().get_Item(0).get_Rows().get_Count() > 0)
							{
								try
								{
									DataRow dataRow = dataSet.get_Tables().get_Item(0).get_Rows().get_Item(num10 - 2);
									DataAccess.UpdateParamInst(this.VehicleInstId.ToString(), dataRow.get_Item(0).ToString(), configByte3.ParamValue.ToString(), 1, this.UserName, reason);
								}
								catch (SqlException)
								{
									throw;
								}
								catch
								{
									string text2 = text;
									text = string.Concat(new string[]
									{
										text2,
										"Frame 0x",
										num4.ToString("x2"),
										" byte ",
										(num10 - 1).ToString(),
										" missing from the database.<br>"
									});