public IEnumerable <Pair> SelectFromProcedure(string procedureName, int plateId, string serialNum)
{
using (var adapter = new NifudaDataTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
throw new ConnectionException(SettingsContext.GlobalSettings.NifudaConnectionString);
}
using (var command = new SqlCommand(procedureName, adapter.Connection)
{
CommandType = CommandType.StoredProcedure
})
{
command.Parameters.Add(new SqlParameter("@plateID", plateId.ToString()));
command.Parameters.Add(new SqlParameter("@sn", serialNum));
using (SqlDataReader rdr = command.ExecuteReader())
{
while (rdr.Read())
{
yield return(new Pair {
Item1 = rdr["Object_path"].ToString(), Item2 = rdr["Value"].ToString()
});
}
}
}
}
}
public (Result, string) Insert(IEnumerable <CalibrationResults> data, object state = null)
{
using (var adapter = new CalibrationDataTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
return(Result.Unsuccess, $"Database connection error");
}
var methodInfo = typeof(CalibrationDataTableAdapter).GetMethod("Insert");
foreach (var obj in data)
{
var tupleParameters = obj.PropertiesToTuple();
var values = methodInfo.GetParameters().Select(info =>
tupleParameters.FirstOrDefault(p =>
p.Name.ToLower() ==
info.Name.ToLower()).Value ?? "");
if (values == null)
{
continue;
}
methodInfo.Invoke(adapter, values.ToArray());
}
return(Result.Success, $"Ok");
}
}
public (Result, string) Update(IEnumerable <InputData> data, object state = null)
{
using (var adapter = new NifudaDataTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
return(Result.Unsuccess, $"Database connection error");
}
int fieldsCount = (new NifudaDataSet.NifudaDataTableDataTable()).Columns.Count;
var methodInfo = typeof(NifudaDataTableAdapter).GetMethod("Update",
Enumerable.Range(0, fieldsCount).Select(i => typeof(string)).ToArray());
foreach (var obj in data)
{
var tupleParameters = obj.PropertiesToTuple();
var values = methodInfo.GetParameters().Select(info =>
tupleParameters.FirstOrDefault(p =>
p.Name.ToLower()
== info.Name.ToLower()).Value ?? "");
if (values == null)
{
continue;
}
methodInfo.Invoke(adapter, values.ToArray());
}
return(Result.Success, $"Ok");
}
}
private bool CheckFilePath()
{
if (!SafeCheck.IsMap(this._uploadPath))
{
this._uploadPath = IOFiles.GetFolderMapPath(this._uploadPath);
}
IOFiles.CreatedFolder(this._uploadPath);
if (IOFiles.IsFolder(this._uploadPath))
{
return(true);
}
this._uploadtype = UploadUnitType.存储文件夹错误;
return(false);
}
// Результат обязательно проверить на NULL! Выбирает дипазон 10 минут от заданной даты и ищет максимально близкое значение.
// Если в диапазоне не оказалось значений, возвращает NULL
public TemperatureFrame SelectLastByDate(DateTime time)
{
using (var adapter = new TemperatureTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
throw new ConnectionException(SettingsContext.GlobalSettings.NifudaConnectionString);
}
var dataTable = adapter.GetDataBetweenDate(time - new TimeSpan(0, 5, 0), time + new TimeSpan(0, 5, 0));
return(dataTable.AdaptWithSameProperties <TemperatureFrame, TemperatureDataTableRow>()
.OrderBy(t => Math.Abs((t.Time - time).Ticks))
.FirstOrDefault());
}
}
private bool CheckExt(string Files)
{
bool flag = false;
if (!this.IsOther)
{
if (SafeCheck.IsJPGstr(Files, this.FileExt))
{
return(true);
}
this._IsThumbnail = false;
return(flag);
}
if (SafeCheck.IsOther(Files, this.FileExt))
{
flag = true;
}
return(flag);
}
public IEnumerable <CalibrationResults> SelectBySerial(string serial, object state = null)
{
using (var adapter = new CalibrationDataTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
throw new ConnectionException(SettingsContext.GlobalSettings.NifudaConnectionString);
}
var dataTable = adapter.GetDataBy(serial);
foreach (var obj in dataTable.AdaptWithSameProperties <CalibrationResults,
CalibrationDataTableRow>())
{
yield return(obj);
}
}
}
public IEnumerable <TemperatureFrame> Select(object state = null)
{
using (var adapter = new TemperatureTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
throw new ConnectionException(SettingsContext.GlobalSettings.NifudaConnectionString);
}
var dataTable = adapter.GetData();
foreach (var obj in dataTable.AdaptWithSameProperties <TemperatureFrame,
TemperatureDataTableRow>())
{
yield return(obj);
}
}
}
public IEnumerable <IndexNOResult> SelectDataByIndex(string index, object state)
{
using (var adapter = new IndexNODataTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
throw new ConnectionException(SettingsContext.GlobalSettings.NifudaConnectionString);
}
var dataTable = adapter.GetDataBySapIndexNO(index);
foreach (var obj in dataTable.AdaptWithSameProperties <IndexNOResult,
IndexNODataTableRow>())
{
yield return(obj);
}
}
}
public IEnumerable <MaxigrafPlateSetting> SelectByPlateId(int plateId, object state = null)
{
using (var adapter = new MaxigrafPlatesSettingDataTableTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
throw new ConnectionException(SettingsContext.GlobalSettings.NifudaConnectionString);
}
var dataTable = adapter.GetData(plateId);
foreach (var obj in dataTable.AdaptWithSameProperties <MaxigrafPlateSetting,
MaxigrafPlatesSettingDataTableRow>())
{
yield return(obj);
}
}
}
public (Result, string) Delete(IEnumerable <MaxigrafPlateSetting> data, object state = null)
{
using (var adapter = new MaxigrafPlatesSettingDataTableTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
return(Result.Unsuccess, $"Database connection error");
}
foreach (var obj in data)
{
adapter.Delete(obj.Num);
}
return(Result.Success, $"Ok");
}
}
public IEnumerable <InputData> SelectDataByIndexNo(string IndexNo, object state = null)
{
using (var adapter = new NifudaDataTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
throw new ConnectionException(SettingsContext.GlobalSettings.NifudaConnectionString);
}
var dataTable = adapter.GetDataByIndex(IndexNo);
foreach (var obj in dataTable.AdaptWithSameProperties <InputData,
NifudaDataSet.NifudaDataTableRow>())
{
yield return(obj);
}
}
}
public IEnumerable <InputData> SelectByEmptyBarCode(object state = null)
{
using (var adapter = new NifudaDataTableAdapter
{
Connection = new SqlConnection(SettingsContext.GlobalSettings.NifudaConnectionString)
})
{
if (!SafeCheck.IsValidConnection(adapter.Connection))
{
throw new ConnectionException(SettingsContext.GlobalSettings.NifudaConnectionString);
}
var dataTable = new NifudaDataSet.NifudaDataTableDataTable();
adapter.FillByEmptyBarCode(new NifudaDataSet.NifudaDataTableDataTable(dataTable));
foreach (var obj in dataTable.AdaptWithSameProperties <InputData,
NifudaDataSet.NifudaDataTableRow>())
{
yield return(obj);
}
}
}
