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)");
}
}
}
