public parmType(DataRow drow) { id = Convert.ToInt32(drow[0].ToString()); typename = drow.Field<string>(1); sortorder = Convert.ToInt32(drow[2].ToString()); shortname = drow.Field<string>(3); }
public TacticBrand (DataRow row) { if (row.Table.Columns.Contains("TacticID")) TacticID = row.Field<int>("TacticID"); if (row.Table.Columns.Contains("BrandID")) BrandID = row.Field<int>("BrandID"); }
/// <summary> /// Initializes a new instance of the <see cref="board_stats_Result"/> class. /// </summary> /// <param name="dr"> /// The dr. /// </param> public board_stats_Result(DataRow dr) { this.NumPosts = dr.Field<int>("NumPosts"); this.NumTopics = dr.Field<int>("NumTopics"); this.NumUsers = dr.Field<int>("NumUsers"); this.BoardStart = dr.Field<DateTime>("BoardStart"); }
public DimTime(DataRow row) { this.TimeId = row.Field<int>("timeid"); this.Hour = row.Field<Int16>("hour"); this.Minute = row.Field<Int16>("minute"); this.Second = row.Field<Int16>("second"); }
public ServiceLineModel(DataRow row) { DiagnosisCodeGroupID = row.Field<int>("DiagnosisCodeGroupID"); Description = row.Field<string>("Description"); DisplayOrder = row.Field<int>("DisplayOrder"); Active = row.Field<bool>("Active"); }
public LookupListModel(DataRow row) { ID = row.Field<int>("ID"); Name = row.Field<string>("Name"); Description = row.Field<string>("Description"); ParentID = row.Field<int?>("ParentID"); }
public DeckCloudUploadInformation(DataRow row) { // Get the upload parameters. Action = row.Field<string>("action"); ContentType = row.Field<string>("Content-Type"); XAmzDate = row.Field<string>("x-amz-date"); Authorization = row.Field<string>("Authorization"); }
private static Session PopulateSession(DataRow session) { return new Session { SessionId = session.Field<Guid>("SessionId").ToString(), UserId = session.Field<int>("UserId") }; }
protected override bool LoadFromDatabase(DataRow row) { Index = row.Field<short>("index"); ID = row.Field<int>("id"); Level = row.Field<ushort>("level"); Type = (EHotkeyType)row.Field<int>("type"); return true; }
public TacticDiagnosisGroup (DataRow row) { if (row.Table.Columns.Contains("TacticDiagnosisGroupID")) TacticDiagnosisGroupID = row.Field<int>("TacticDiagnosisGroupID"); if (row.Table.Columns.Contains("DiagnosisCodeGroupID")) DiagnosisCodeGroupID = row.Field<int>("DiagnosisCodeGroupID"); if (row.Table.Columns.Contains("TacticID")) TacticID = row.Field<int>("TacticID"); }
private void AddCapture(DataRow dr) { CaptureTesting capture = new CaptureTesting(); capture.captureId = dr.Field<String>("captureId"); capture.capturedOn = dr.Field<DateTime?>("capturedOn"); capture.numberFrames = dr.Field<Int32>("numberFrames"); list.Add(capture); }
private static PersonDTO HydrateEmployeeDTO(DataRow dr) { PersonDTO result = new PersonDTO(); result.BusinessEntityId = dr.Field<int>("BusinessEntityID"); result.PersonType = dr.Field<string>("PersonType"); result.NameStyle = dr.Field<bool>("NameStyle"); result.Title = dr.Field<string>("Title"); return result; }
public Settings (DataRow row) { if (row.Table.Columns.Contains("Key")) Key = row.Field<string>("Key"); if (row.Table.Columns.Contains("Value")) Value = row.Field<string>("Value"); if (row.Table.Columns.Contains("Description")) Description = row.Field<string>("Description"); }
public void AddResumeRow(DataRow x) { XSSFRow row = this._Sheet.CreateRow(this._RowIndexResume) as XSSFRow; row.CreateCell(00, CellType.NUMERIC).SetCellValue(x.Field<int>("DESID")); row.CreateCell(01, CellType.NUMERIC).SetCellValue(x.Field<int>("Cajas")); row.CreateCell(02, CellType.NUMERIC).SetCellValue(x.Field<int>("Registros")); row.CreateCell(03, CellType.NUMERIC).SetCellValue(x.Field<int>("Imagenes")); row.CreateCell(04, CellType.STRING).SetCellValue(x.Field<long>("PesoEstimado").FormatBytes()); }
private static TagType PopulateTagType(DataRow tagType) { return new TagType { TagTypeId = tagType.Field<int>("TagTypeId"), TypeName = tagType.Field<string>("TypeName"), Points = tagType.Field<int>("Points"), LockoutTimePeriod = tagType.Field<int>("LockoutTimePeriod") }; }
private static AddressTypeDTO HydrateAddressTypeDTO(DataRow dr) { AddressTypeDTO result = new AddressTypeDTO(); result.AddressTypeId = dr.Field<int>("AddressTypeId"); result.Name = dr.Field<string>("Name"); result.RowGuid = dr.Field<Guid>("rowguid"); result.ModifiedDate = dr.Field<DateTime>("ModifiedDate"); return result; }
/// <summary> /// Constructor used on the slave side when reading published schema change events /// </summary> /// <param name="row">DataRow from querying schema change table</param> public SchemaChange(DataRow row) { DdeID = row.Field<int>("CscDdeID"); EventType = (SchemaChangeType)Enum.Parse(typeof(SchemaChangeType), row.Field<string>("CscEventType")); SchemaName = row.Field<string>("CscSchema"); TableName = row.Field<string>("CscTableName"); ColumnName = row.Field<string>("CscColumnName"); NewColumnName = row.Field<string>("CscNewColumnName"); DataType = new DataType(row.Field<string>("CscBaseDataType"), row.Field<int?>("CscCharacterMaximumLength"), row.Field<int?>("CscNumericPrecision"), row.Field<int?>("CscNumericScale")); }
public TacticCampaignClientOrganization (DataRow row) { if (row.Table.Columns.Contains("TacticID")) TacticID = row.Field<int>("TacticID"); if (row.Table.Columns.Contains("CampaignID")) CampaignID = row.Field<int>("CampaignID"); if (row.Table.Columns.Contains("ClientOrganizationID")) ClientOrganizationID = row.Field<int>("ClientOrganizationID"); if (row.Table.Columns.Contains("CostExpediturePercent")) CostExpediturePercent = row.Field<decimal>("CostExpediturePercent"); }
public TacticEncounterType (DataRow row) { if (row.Table.Columns.Contains("TacticID")) TacticID = row.Field<int>("TacticID"); if (row.Table.Columns.Contains("EncounterTypeID")) EncounterTypeID = row.Field<int>("EncounterTypeID"); if (row.Table.Columns.Contains("UpdatedDT")) UpdatedDT = row.Field<DateTime>("UpdatedDT"); if (row.Table.Columns.Contains("UpdatedBy")) UpdatedBy = row.Field<string>("UpdatedBy"); }
public ChangeTrackingBatch(DataRow row) { CTID = row.Field<Int64>("CTID"); long? start = row.Field<Int64?>("syncStartVersion"); if (start.HasValue) { SyncStartVersion = start.Value; } long? stop = row.Field<Int64?>("syncStopVersion"); if (stop.HasValue) { SyncStopVersion = stop.Value; } SyncBitWise = row.Field<Int32>("syncBitWise"); if (row.Table.Columns.Contains("syncStartTime")) { SyncStartTime = row.Field<DateTime>("syncStartTime"); } }
public Age (DataRow row) { if (row.Table.Columns.Contains("AgeID")) AgeID = row.Field<int>("AgeID"); if (row.Table.Columns.Contains("Description")) Description = row.Field<string>("Description"); if (row.Table.Columns.Contains("LowerLimit")) LowerLimit = row.Field<int?>("LowerLimit"); if (row.Table.Columns.Contains("UpperLimit")) UpperLimit = row.Field<int?>("UpperLimit"); if (row.Table.Columns.Contains("AgeRangeOrder")) AgeRangeOrder = row.Field<int>("AgeRangeOrder"); }
public StarkArea (DataRow row) { if (row.Table.Columns.Contains("StarkAreaID")) StarkAreaID = row.Field<int>("StarkAreaID"); if (row.Table.Columns.Contains("ClientOrganizationID")) ClientOrganizationID = row.Field<int>("ClientOrganizationID"); if (row.Table.Columns.Contains("Zipcode")) Zipcode = row.Field<string>("Zipcode"); if (row.Table.Columns.Contains("CarrierRoute")) CarrierRoute = row.Field<string>("CarrierRoute"); if (row.Table.Columns.Contains("ServiceAreaTypeID")) ServiceAreaTypeID = row.Field<int?>("ServiceAreaTypeID"); }
public static Catalogo ConvertToItem(DataRow dr) { Catalogo item = null; if (dr != null) { item = new Catalogo(); if (dr.Table.Columns.Contains("COD_ITEM")) { item.COD_ITEM = dr.Field<string>("COD_ITEM"); } if (dr.Table.Columns.Contains("CATEGORIA")) { item.CATEGORIA = (eCategoria)Enum.Parse(typeof(eCategoria), dr.Field<string>("CATEGORIA")); } if (dr.Table.Columns.Contains("UNIDAD_MEDIDA")) { item.UNIDAD_MEDIDA = (eUnidadMedida)Enum.Parse(typeof(eUnidadMedida), dr.Field<string>("UNIDAD_MEDIDA")); } } return item; }
public static Usuario ConvertToUsuario(DataRow dr) { Usuario user = null; if (dr != null) { user = new Usuario(); if (dr.Table.Columns.Contains("COD_EMPLEADO")) { user.COD_EMPLEADO = dr.Field<string>("COD_EMPLEADO"); } if (dr.Table.Columns.Contains("NOMBRE")) { user.NOMBRE = dr.Field<string>("NOMBRE"); } if (dr.Table.Columns.Contains("PASSWORD")) { user.PASSWORD = dr.Field<string>("PASSWORD"); } if (dr.Table.Columns.Contains("TIPO_USER")) { user.TIPO = (eTipoUsuario) dr.Field<int>("TIPO_USER"); } if (dr.Table.Columns.Contains("ACTIVO")) { user.ACTIVO = dr.Field<bool>("ACTIVO");} } return user; }
public CompetingIn(DataRow row) { this.CompetitionId = row.Field<Int16>("competitionid"); this.CarId = row.Field<Int16>("carid"); row["username"] = row["username"] is DBNull ? "" : row["username"]; this.Username = row.Field<string>("username"); row["score"] = row["score"] is DBNull ? 0.0 : row["score"]; this.Score = (double)row.Field<Single>("score"); row["attempts"] = row["attempts"] is DBNull ? 0 : row["attempts"]; this.Attempts = row.Field<int>("attempts"); }
/// <summary> /// Initializes a new instance of the <see cref="board_poststats_Result"/> class. /// </summary> /// <param name="dr"> /// The dr. /// </param> public board_poststats_Result(DataRow dr) { this.Posts = dr.Field<int?>("Posts"); this.Topics = dr.Field<int?>("Topics"); this.Forums = dr.Field<int?>("Forums"); this.LastPostInfoID = dr.Field<int?>("LastPostInfoID"); this.LastPost = dr.Field<DateTime?>("LastPost"); this.LastUserID = dr.Field<int?>("LastUserID"); this.LastUser = dr.Field<string>("LastUser"); this.LastUserDisplayName = dr.Field<string>("LastUserDisplayName"); this.LastUserStyle = dr.Field<string>("LastUserStyle"); }
public DimDate(DataRow row) { this.DateId = row.Field<int>("dateid"); this.Year = row.Field<Int16>("year"); this.Month = row.Field<Int16>("month"); this.Day = row.Field<Int16>("day"); this.DayOfWeek = row.Field<Int16>("dayofweek"); this.Weekend = row.Field<bool>("weekend"); this.Holiday = row.Field<bool>("holiday"); this.Quarter = row.Field<Int16>("quarter"); this.Season = row.Field<Int16>("season"); }
public UploadValidationFailure ValidateIndicator(DataRow uploadedRow, int rowNumber) { //Do other indicator validation var columnName = UploadColumnNames.IndicatorId; try { var indicatorId = (int)uploadedRow.Field<double>(columnName); if (indicatorId < 1) { return new UploadValidationFailure(rowNumber, columnName, "Invalid " + columnName, null); } //Check that the indicator exists if (!DoesIndicatorMetaDataExist(new SimpleUpload { IndicatorId = indicatorId })) { return new UploadValidationFailure(rowNumber, columnName, "Indicator does not exist", null); } } catch (Exception ex) { //Indicator is invalid for another reason - Log this and exit return new UploadValidationFailure(rowNumber, columnName, "Invalid " + columnName, ex.Message); } return null; }
private void GetSelectedRow() { System.Data.DataRow Row = gridView1.GetDataRow(gridView1.GetSelectedRows()[0]); this.SelectedSalesOrderId = Row.Field <string>(SalesIdString); if (!Enum.TryParse <SalesStatus>(Row[StatusString].ToString(), out selectedOrderStatus)) { this.selectedOrderStatus = SalesStatus.Unknown; } // CustomerOrderType does not have default, failing if something else. this.SelectedOrderType = (CustomerOrderType)Enum.Parse(typeof(CustomerOrderType), Row[OrderTypeString].ToString()); this.selectedOrderPickupDeliveryMode = Row.Field <string>(DeliveryModeString); }
public override Model.Data CalcValue(System.Data.DataRow dr) { double phy, waterlevel; if (Formaulaid == 1) // 振弦公式:含温度修正 { var fre = Convert.ToSingle(dr["Value1"]); var tmp = Convert.ToSingle(dr["Value2"]); phy = _kParam * (Math.Pow(fre, 2) - Math.Pow(_iniFrequency, 2)) + _cParam * (tmp - _iniTemperature); // MPa waterlevel = phy * 1000 / 9.8; // m } else // 7 水位公式 11 干滩长度计算 { var fre = Convert.ToSingle(dr["Value1"]); phy = _kParam * (Math.Pow(_iniFrequency, 2) - Math.Pow(fre, 2)); // MPa waterlevel = phy * 1000 / 9.8; // m } if (SafetyFactor == SAFE_FACT.saturation_line) // 浸润线 { // 水深+安装高程 waterlevel += _waterDeep; return(new DataSaturationLine { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), height = waterlevel }); } else if (SafetyFactor == SAFE_FACT.beach) // 干滩 { var beachlen = (_H - (waterlevel + _h)) / _sloperatio; return(new DataBeachLen { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), waterlevel = waterlevel, beachlen = beachlen }); } else { throw new Exception("当前传感器指定检测因素下的计算未实现"); } }
public Car(DataRow row) { this.CarId = row.Field<Int16>("carid"); if (row.Table.Columns.Contains("cartype")) { this.CarType = row.Field<string>("cartype"); this.Brand = row.Field<string>("brand"); this.Model = row.Field<string>("model"); this.FuelConsumption = row.Field<double>("fuelconsumption"); this.EnergyConsumption = row.Field<double>("energyconsumption"); this.Weight = row.Field<double>("weight"); this.Capacity = row.Field<Int16>("capacity"); } row["imei"] = row["imei"] is DBNull ? 0 : row["imei"]; this.IMEI = row.Field<Int64>("imei"); row["username"] = row["username"] is DBNull ? "" : row["username"]; this.Username = row.Field<string>("username"); }
public BetSheet(DataRow row) { this.SheetId = row.Field<int>(SHEETID); this.UserId = row.Field<int>(USERID); this.Num = row.Field<string>(NUM); this.BetCompany = row.Field<string>(BETCOMPANY); this.BetAmount = row.Field<string>(BETAMOUNT); this.Status = (BetStatus)row.Field<int>(STATUS); this.IPAddress = row.Field<string>(IPADDRESS); this.CreateTime = row.Field<DateTime>(CREATETIME); }
public void SaveIDToDataRow(System.Data.DataTable dt, System.Data.DataRow dr, long newID) { long oldID = dr.Field <long>("MPAItemID"); dt.PrimaryKey[0].ReadOnly = false; dt.Rows.Find(oldID).BeginEdit(); dt.Rows.Find(oldID)["MPAItemID"] = newID; dt.Rows.Find(oldID).EndEdit(); dt.PrimaryKey[0].ReadOnly = true; }
public override Reader Read(System.Data.DataRow row) { return(new Reader() { Id = Convert.ToInt32(row.Field <decimal>("reader_id")), PassportNumber = Convert.ToInt32(row.Field <decimal>("reader_passport_id")), FirstName = row.Field <string>("reader_first_name"), LastName = row.Field <string>("reader_last_name"), MiddleName = row.Field <string>("reader_middle_name"), Address = row.Field <string>("reader_address"), Phone = row.Field <string>("reader_phone"), Card = new Card() { Id = Convert.ToInt32(row.Field <decimal>("card_id")), IssueDate = row.Field <DateTime>("card_issue_date"), ExpiryDate = row.Field <DateTime>("card_expiry_date") } }); }
public override Model.Data CalcValue(System.Data.DataRow dr) { return(new DataTempAndHumi { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), tmperature = dr["Value2"] != DBNull.Value ? Convert.ToSingle(dr["Value2"]) : 0, huminity = dr["Value1"] != DBNull.Value ? Convert.ToSingle(dr["Value1"]) : 0 }); }
public override Model.Data CalcValue(System.Data.DataRow dr) { float rain = Convert.ToSingle(dr["Value1"]); return(new DataRainfall { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), rainfall = rain }); }
public override Model.Data CalcValue(System.Data.DataRow dr) { var stress = Convert.ToSingle(dr["Value1"]);//应力 return(new DataBeamForce() { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), stress = stress }); }
public override Model.Data CalcValue(System.Data.DataRow dr) { float emptyHeight = Convert.ToSingle(dr["Value1"]); // 空高值 var data = new Data { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), DataSet = new List <double>() }; data.DataSet.Add(emptyHeight); return(data); }
public override Model.Data CalcValue(System.Data.DataRow dr) { float xangle = Convert.ToSingle(dr["Value1"]); float yangle = Convert.ToSingle(dr["Value2"]); if (SafetyFactor == SAFE_FACT.deep_displace) // 内部位移 { var xValue = (_spacingLength * Math.Sin(xangle * Math.PI / 180)) - (_spacingLength * Math.Sin(_xInit * Math.PI / 180)); var yValue = (_spacingLength * Math.Sin(yangle * Math.PI / 180)) - (_spacingLength * Math.Sin(_yInit * Math.PI / 180)); return(new DataDeepDisplacement { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), XDisplacement = xValue, YDisplacement = yValue }); } else if (SafetyFactor == SAFE_FACT.bridge_incline) { return(new DataBridgeIncline { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), xangle = xangle - _xInit, yangle = yangle - _yInit }); } else { throw new Exception("当前传感器指定检测因素下的计算未实现"); } }
public override Model.Data CalcValue(System.Data.DataRow dr) { //var wave = Convert.ToSingle(dr["Value1"]);//波长 var strain = Convert.ToSingle(dr["Value1"]); //应变 var temp = Convert.ToSingle(dr["Value2"]); //温度 return(new DataFbgStrain() { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), strain = strain, temperature = temp }); }
public override Model.Data CalcValue(System.Data.DataRow dr) { float x = Convert.ToSingle(dr["Value1"]); float y = Convert.ToSingle(dr["Value2"]); float z = Convert.ToSingle(dr["Value3"]); return(new DataSurfaceDisplacement { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), XDisplacement = (x - _XInit) * 1000, YDisplacement = (y - _YInit) * 1000, ZDisplacement = (z - _ZInit) * 1000 }); }
public override Model.Data CalcValue(System.Data.DataRow dr) { var displacement = Convert.ToSingle(dr["Value1"]); if (SAFE_FACT.bearingdisplace == SafetyFactor) // 支座位移 { return(new DataSurfaceDisplacement { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), XDisplacement = displacement - _initval, YDisplacement = 0, ZDisplacement = 0 }); } return(null); }
public static string[,] getbudgetData() { DataAbstract DA = new DataAbstract(); DataSet accountData = DA.returnAccounts(userID); System.Data.DataTable accountsTable = accountData.Tables[0]; //table holding all account entries for the user int accountCount = accountsTable.Rows.Count; //the total number of accounts for the user int totalBudgetCount = 0; //grab each account under the userID, grab the goals for each account, sum number of all goals for (int num = 0; num < accountCount; ++num) { System.Data.DataRow accountRow = accountsTable.Rows[num]; object s = accountRow.Field <object>("AcctNumber"); long accountNum = Convert.ToInt64(s); totalBudgetCount += DA.returnBudgets(accountNum).Tables[0].Rows.Count; } string[,] result = new string[totalBudgetCount, 9]; //will hold data for all goals in all accounts int total = 0; //populate the 2D array for (int i = 0; i < accountCount; ++i) //variable i iterates through accounts { System.Data.DataRow accountRow = accountsTable.Rows[i]; long accountNum = Convert.ToInt64(accountRow.Field <object>("AcctNumber")); DataSet D = DA.returnBudgets(accountNum); System.Data.DataTable T = D.Tables[0]; //Gets the actual Goals Table, filtered appropriately int rowCount = T.Rows.Count; //Number of entries for (int j = 0; j < rowCount; ++j) //variable j iterates through budgets of an account { //RAW DATABASE OBJECTS object BudgetIDData, CategoryIDData, StartDateData, EndDateData, MaxAmtData, CompletedData, FailedData, CurrentAmt; //BUDGET INFOS TO BECOME STRINGS string BudgetID, CategoryID, AcctNumber, StartDate, EndDate, MaxAmt, Completed, Failed, Current; System.Data.DataRow DR = T.Rows[j]; //gets the current row we're copying //BudgetID BudgetIDData = DR.Field <object>("BudgetID"); BudgetID = Convert.ToString(BudgetIDData); //CategoryID CategoryIDData = DR.Field <object>("CategoryID"); CategoryID = DA.returnCategoryName(Convert.ToInt32(CategoryIDData)); //AcctNumber AcctNumber = Convert.ToString(accountNum); //StartDate StartDateData = DR.Field <object>("StartDate"); StartDate = Convert.ToDateTime(StartDateData).ToString("M dd, yyyy"); //EndDate EndDateData = DR.Field <object>("EndDate"); EndDate = Convert.ToDateTime(EndDateData).ToString("M dd, yyyy"); //MaxAmy MaxAmtData = DR.Field <object>("MaxAmt"); MaxAmt = Convert.ToInt32(MaxAmtData).ToString("C2"); //Completed? CompletedData = DR.Field <object>("Completed"); Completed = Convert.ToString(CompletedData); //Failed? FailedData = DR.Field <object>("Failed"); Failed = Convert.ToString(FailedData); CurrentAmt = DR.Field <object>("CurrentAmt"); Current = Convert.ToString(CurrentAmt); result[total, 0] = BudgetID; result[total, 1] = CategoryID; result[total, 2] = AcctNumber; result[total, 3] = StartDate; result[total, 4] = EndDate; result[total, 5] = MaxAmt; result[total, 6] = Completed; // "false" or "true" result[total, 7] = Failed; // "false" or "true" result[total, 8] = Current; ++total; } //end goal } return(result); }
public override Model.Data CalcValue(System.Data.DataRow dr) { float pre = Convert.ToSingle(dr["Value1"]); if (SafetyFactor == SAFE_FACT.seepage) { // MPa->mH2O float h = pre * 1000f / 9.8f; float seepage = 0.0f; switch (wiretype) { case WeirType.Triangle: seepage = CalcFlowTriangle(h); break; case WeirType.Rectangle: seepage = CalcFlowRectangle(h); break; case WeirType.Trapezoid: seepage = CalcFlowKeystone(h); break; default: break; } // L/s->m3/s seepage *= 0.001f; return(new DataSeepage { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), pressure = pre, seepage = seepage }); } else if (SafetyFactor == SAFE_FACT.water_level) { // MPa->mH2O float h = pre * 1000f / 9.8f; return(new Data { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), DataSet = new List <double>() }); //data.DataSet.Add(h - initheight); } else if (SafetyFactor == SAFE_FACT.saturation_line) { // MPa->mH2O double h = pre * 1000f / 9.8f + initheight; return(new DataSaturationLine { Safetyfactor = SafetyFactor, SensorId = Convert.ToInt32(Id), CollectTime = dr.Field <DateTime>("CollectTime"), height = h }); } else { throw new Exception("当前传感器指定检测因素下的计算未实现"); } }
private string ConvertDotNetToSQLType(System.Data.DataRow row) { var dataType = row.Field <System.Type>("DataType").ToString(); string dataTypeName = null; if (row.Table.Columns.Contains("DataTypeName")) { dataTypeName = row.Field <string>("DataTypeName"); } switch (dataType) { case "System.Double": { return("float"); }; case "System.Boolean": { return("bit"); } case "System.String": { var columnSize = row.Field <int?>("ColumnSize"); if (string.IsNullOrEmpty(dataTypeName)) { dataTypeName = "nvarchar"; } string columnSizeStr = "MAX"; if (columnSize == null || columnSize <= 0 || (dataTypeName == "varchar" && columnSize > 8000) || (dataTypeName == "nvarchar" && columnSize > 4000)) { columnSizeStr = "MAX"; } else { columnSizeStr = columnSize.ToString(); } return($"{dataTypeName}({columnSizeStr})"); } case "System.Decimal": { var numericScale = row.Field <int>("NumericScale"); var numericPrecision = row.Field <int>("NumericPrecision"); if (numericScale == 0) { if (numericPrecision < 10) { return("int"); } else { return("bigint"); } } if (!string.IsNullOrEmpty(dataTypeName) && dataTypeName.EndsWith("*money")) { return(dataTypeName); } if (numericScale != 255) { return($"decimal({numericPrecision}, {numericScale})"); } return("decimal(38,4)"); } case "System.Byte": { return("tinyint"); } case "System.Int16": { return("smallint"); } case "System.Int32": { return("int"); } case "System.Int64": { return("bigint"); } case "System.DateTime": { return("datetime2(0)"); } case "System.Byte[]": { return("varbinary(max)"); } case "System.Xml.XmlDocument": { return("xml"); } default: { return("nvarchar(MAX)"); } } }