public GetDataPiontHistoryDataResponse GetDataPiontHistoryData(GetDataPointHistoryDataRequest request)
{
GetDataPiontHistoryDataResponse response = new GetDataPiontHistoryDataResponse();
try
{
Query query = new Query();
query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DataPoint.Id, request.DataPointId, CriteriaOperator.Equal));
query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, request.BeginTime, CriteriaOperator.GreaterThanOrEqual));
query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, request.EndTime, CriteriaOperator.LesserThanOrEqual));
query.QueryOperator = QueryOperator.And;
query.OrderByProperty = OrderByClause.Create <DataPointHistoryData>(p => p.DateTime, false);
IEnumerable <DataPointHistoryData> dataPointHistoryDatas =
dataPointHistoryDataRepository.FindBy(query);
response.DataPointHistoryDataView =
dataPointHistoryDatas.ConvetToDataPointHistoryDataView();
}
catch (Exception ex)
{
string message = "查询失败!错误信息:/n" + ex.Message;
response = new GetDataPiontHistoryDataResponse()
{
ResponseSucceed = false,
Message = "查询失败"
};
LoggingFactory.GetLogger().WriteDebugLogger(message);
return(response);
}
return(response);
}
public IEnumerable <GroupTreeNode> GetProductLineTreeNode(GroupTreeNode factoryTreeNode)
{
IList <GroupTreeNode> result = new List <GroupTreeNode>();
Query query = new Query("ProductLine");
query.AddCriterion("CompanyID", "a", factoryTreeNode.CompanyID, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
query.AddCriterion("FactoryID", "b", factoryTreeNode.FactoryID, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
DataTable dt = dataFactory.Query(query);
foreach (DataRow row in dt.Rows)
{
GroupTreeNode item = new GroupTreeNode();
item.ProductLineID = int.Parse(row["ID"].ToString().Trim());
item.CompanyID = int.Parse(row["CompanyID"].ToString().Trim());
item.FactoryID = int.Parse(row["FactoryID"].ToString().Trim());
item.Name = row["Name"].ToString().Trim();
item.Address = row["Address"].ToString().Trim();
item.CommissioningDate = row["CommissioningDate"].ToString();
item.Products = row["Products"].ToString().Trim();
item.children = null;
result.Add(item);
}
return(result);
}
/// <summary>
/// 获取职工信息
/// </summary>
/// <param name="organizationId">组织机构ID</param>
/// <param name="searchName">检索关键字</param>
/// <returns></returns>
public static DataTable GetStaffInfo(string organizationId, string searchName = "", string searchId = "", string searchTeamName = "")
{
string connectionString = ConnectionStringFactory.NXJCConnectionString;
ISqlServerDataFactory dataFactory = new SqlServerDataFactory(connectionString);
Query query = new Query("system_StaffInfo");
query.AddCriterion("OrganizationID", organizationId, CriteriaOperator.Equal);
// 添加检索关键字约束
if (!string.IsNullOrWhiteSpace(searchName + searchId + searchTeamName))
{
searchName = "%" + searchName + "%";
searchId = "%" + searchId + "%";
searchTeamName = "%" + searchTeamName + "%";
query.AddCriterion("Name", searchName, CriteriaOperator.Like);
query.AddCriterion("StaffInfoID", searchId, CriteriaOperator.Like);
query.AddCriterion("WorkingTeamName", searchTeamName, CriteriaOperator.Like);
}
// 添加排序（启用降序，工号升序）
query.AddOrderByClause(new OrderByClause("Enabled", true));
query.AddOrderByClause(new OrderByClause("StaffInfoID", false));
DataTable m_StaffInfoTable = dataFactory.Query(query);
DataRow[] m_dataRows = m_StaffInfoTable.Select("StaffType <> 'superior' or StaffType is null");
DataTable m_StaffInfoTableNew = m_StaffInfoTable.Clone();
for (int i = 0; i < m_dataRows.Length; i++)
{
m_StaffInfoTableNew.Rows.Add(m_dataRows[i].ItemArray);
}
return(m_StaffInfoTableNew);
}
public DeleteDataPointHistoryDataResponse DeleteDataPointHistoryData(DeleteDataPointHistoryDataRequst requst)
{
DeleteDataPointHistoryDataResponse response = new DeleteDataPointHistoryDataResponse();
try
{
Query query = new Query();
query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, requst.BeginTime, CriteriaOperator.GreaterThanOrEqual));
query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, requst.EndTime, CriteriaOperator.LesserThanOrEqual));
query.QueryOperator = QueryOperator.And;
dataPointHistoryDataRepository.Remove(query);
unitOfWork.Commit();
}
catch (Exception ex)
{
string message = "删除失败!错误信息:/n" + ex.Message;
response = new DeleteDataPointHistoryDataResponse()
{
ResponseSucceed = false,
Message = "删除失败"
};
LoggingFactory.GetLogger().WriteDebugLogger(message);
return(response);
}
return(response);
}
/// <summary>
/// 添加职工信息
/// </summary>
/// <param name="organizationId"></param>
/// <param name="staffInfoId"></param>
/// <param name="workingTeamName"></param>
/// <param name="name"></param>
/// <param name="sex"></param>
/// <param name="phoneNumber"></param>
/// <returns>添加结果</returns>
public static string InsertStaffInfo(string organizationId, string staffInfoId, string workingTeamName, string name, bool sex, string phoneNumber)
{
string connectionString = ConnectionStringFactory.NXJCConnectionString;
ISqlServerDataFactory dataFactory = new SqlServerDataFactory(connectionString);
// 检查是否存在此职工
Query query = new Query("system_StaffInfo");
query.AddCriterion("OrganizationID", organizationId, CriteriaOperator.Equal);
query.AddCriterion("staffInfoId", staffInfoId, CriteriaOperator.Equal);
if (dataFactory.Query(query).Rows.Count > 0)
{
return("添加失败，已存在此工号。");
}
int executeResult = 0;
// 添加记录
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = @"INSERT INTO [dbo].[system_StaffInfo]
([StaffInfoID]
,[OrganizationID]
,[WorkingTeamName]
,[Name]
,[Sex]
,[PhoneNumber]
,[Enabled])
VALUES
(@staffInfoId
,@organizationId
,@workingTeamName
,@name
,@sex
,@phoneNumber
,1)";
command.Parameters.Add(new SqlParameter("staffInfoId", staffInfoId));
command.Parameters.Add(new SqlParameter("organizationId", organizationId));
command.Parameters.Add(new SqlParameter("workingTeamName", workingTeamName));
command.Parameters.Add(new SqlParameter("name", name));
command.Parameters.Add(new SqlParameter("sex", sex));
command.Parameters.Add(new SqlParameter("phoneNumber", phoneNumber));
connection.Open();
executeResult = command.ExecuteNonQuery();
}
if (executeResult == 1)
{
return("添加成功。");
}
else
{
return("添加失败。");
}
}
public void TestCreatQuery()
{
Query query = new Query();
query.AddCriterion(Criterion.Create <DataPoint>(p => p.Number, 10, CriteriaOperator.LesserThanOrEqual));
query.AddCriterion(Criterion.Create <DataPoint>(p => p.ModuleBelongTo.Id, 2, CriteriaOperator.Equal));
query.OrderByProperty = OrderByClause.Create <DataPoint>(p => p.Name, true);
}
public void TestFindByQueryAndCount()
{
AdoUnitOfWork unitOfWork = new AdoUnitOfWork();
DataPointRepository dataPointRepository = new DataPointRepository(unitOfWork);
Query query = new Query();
query.AddCriterion(Criterion.Create <DataPoint>(p => p.Number, 10, CriteriaOperator.LesserThanOrEqual));
query.AddCriterion(Criterion.Create <DataPoint>(p => p.ModuleBelongTo.Id, 2, CriteriaOperator.Equal));
query.OrderByProperty = OrderByClause.Create <DataPoint>(p => p.Name, true);
IEnumerable <DataPoint> result = dataPointRepository.FindBy(query, 1, 1);
}
private void GetLevelOfProductLine(DataTable dt, string levelCode, int productLineId = 0)
{
int codeNumber = 0;
Query query = new Query("ProductLine");
if (productLineId != 0)
{
query.AddCriterion("ProductLineID", productLineId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
}
dataFactory.Query(query);
DataTable productLineTable = dataFactory.Query(query);
foreach (DataRow productLineRow in productLineTable.Rows)
{
codeNumber++;
DataRow row = dt.NewRow();
row["LevelCode"] = levelCode + codeNumber.ToString("00");
row["ID"] = (int)productLineRow["ProductLineID"];
row["Type"] = "生产线";
row["Name"] = productLineRow["Name"].ToString();
row["ProductLineType"] = (int)productLineRow["Type"];
dt.Rows.Add(row);
}
}
private void GetLevelOfFactory(DataTable dt, string levelCode, int factoryId = 0)
{
int codeNumber = 0;
Query query = new Query("Factory");
if (factoryId != 0)
{
query.AddCriterion("FactoryID", factoryId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
}
dataFactory.Query(query);
DataTable factoryTable = dataFactory.Query(query);
foreach (DataRow factoryRow in factoryTable.Rows)
{
codeNumber++;
DataRow row = dt.NewRow();
row["LevelCode"] = levelCode + codeNumber.ToString("00");
row["ID"] = (int)factoryRow["FactoryID"];
row["Type"] = "分厂";
row["Name"] = factoryRow["Name"].ToString();
dt.Rows.Add(row);
GetLevelOfProductLine(dt, row["LevelCode"].ToString());
}
}
public TZ FindBy(Guid id)
{
Query query = new Query("TZ");
query.AddCriterion("KeyID", id, CriteriaOperator.Equal);
DataTable table = dataFactory.Query(query);
if (table.Rows.Count > 0)
{
TZ result = new TZ();
result.TableName = table.Rows[0]["TableName"].ToString().Trim();
result.KeyID = (Guid)table.Rows[0]["KeyID"];
result.ProductLineID = int.Parse(table.Rows[0]["ProductLineID"].ToString().Trim());
result.ReportID = int.Parse(table.Rows[0]["ReportID"].ToString().Trim());
result.Date = table.Rows[0]["Date"].ToString().Trim();
result.CreationDate = (DateTime)table.Rows[0]["CreationDate"];
result.ModifierID = table.Rows[0]["ModifierID"].ToString().Trim();
result.Version = (DateTime)table.Rows[0]["Version"];
result.ModifiedFlag = (bool)table.Rows[0]["ModifiedFlag"];
result.Remarks = table.Rows[0]["Remarks"].ToString().Trim();
return(result);
}
else
{
return(new TZ());
}
}
public GetDataPointByModuleResponse GetDataPointInfoByModule(GetDataPointByModuleRequest request)
{
GetDataPointByModuleResponse response = new GetDataPointByModuleResponse();
try
{
Query query = new Query();
query.AddCriterion(Criterion.Create <DataPoint>(p => p.ModuleBelongTo.Id, request.ModuleId, CriteriaOperator.Equal));
query.OrderByProperty = OrderByClause.Create <DataPoint>(p => p.Number, false);
IEnumerable <DataPoint> dataPoints = _dataPointRepository.FindBy(query);
response.DataPointInfoViews = dataPoints.ConverToDataPointInfoViews();
}
catch (Exception ex)
{
string message = "查询失败!错误信息:/n" + ex.Message;
response = new GetDataPointByModuleResponse()
{
ResponseSucceed = false,
Message = "查询失败"
};
LoggingFactory.GetLogger().WriteDebugLogger(message);
return(response);
}
return(response);
}
public void TestFindByQuery()
{
AdoUnitOfWork unitOfWork = new AdoUnitOfWork();
DataPointHistoryDataRepository dataPointHistoryDataRepository = new DataPointHistoryDataRepository(unitOfWork);
Query query = new Query();
query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DataPoint.Id, 1, CriteriaOperator.Equal));
query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, new DateTime(2013, 5, 1), CriteriaOperator.GreaterThanOrEqual));
query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, DateTime.Now, CriteriaOperator.LesserThanOrEqual));
query.QueryOperator = QueryOperator.And;
query.OrderByProperty = OrderByClause.Create <DataPointHistoryData>(p => p.DateTime, false);
IEnumerable <DataPointHistoryData> result = dataPointHistoryDataRepository.FindBy(query);
Assert.IsTrue(result.Count() > 0);
}
public DataTable GetFormulaYearTable(Guid keyId, string tableName)
{
Query query = new Query(tableName);
query.AddCriterion("KeyID", keyId, CriteriaOperator.Equal);
DataTable dt = dataFactory.Query(query);
return(dt);
}
/// <summary>
/// 获取用电量
/// </summary>
/// <param name="productLineId"></param>
/// <param name="formulaGroupId"></param>
/// <returns></returns>
public static DataTable GetElectricPowerCount(int productLineId, Guid formulaGroupId)
{
double peakUnitPrice = 0.6876;
double valleyUnitPrice = 0.4310;
double flatUnitPrice = 0.2744;
string connectionString = ConnectionStringFactory.GetNXJCConnectionString();
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("table_ElectricPowerCount");
query.AddCriterion("ProductLineID", "productLineId", productLineId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
query.AddCriterion("FormulaGroupID", "formulaGroupId", formulaGroupId.ToString(), SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
DataTable result = factory.Query(query);
DataColumn PeakCost = new DataColumn("PeakCost");
result.Columns.Add(PeakCost);
DataColumn ValleyCost = new DataColumn("ValleyCost");
result.Columns.Add(ValleyCost);
DataColumn FlatCost = new DataColumn("FlatCost");
result.Columns.Add(FlatCost);
DataColumn TotalCost = new DataColumn("TotalCost");
result.Columns.Add(TotalCost);
foreach (DataRow row in result.Rows)
{
double peakCost = int.Parse(row["PeakPower"].ToString()) * peakUnitPrice;
double valleyCost = int.Parse(row["ValleyPower"].ToString()) * valleyUnitPrice;
double flatCost = int.Parse(row["FlatPower"].ToString()) * flatUnitPrice;
double totalCost = peakCost + valleyCost + flatCost;
row["PeakCost"] = peakCost;
row["ValleyCost"] = valleyCost;
row["FlatCost"] = flatCost;
row["TotalCost"] = totalCost;
}
return(result);
}
/// <summary>
/// 按分厂ID获取所有公式组
/// </summary>
/// <param name="factoryId"></param>
/// <returns></returns>
public static DataTable GetFormulaGroupsByFactoryId(int factoryId)
{
string connectionString = ConnectionStringFactory.GetNXJCConnectionString();
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("FormulaGroup");
query.AddCriterion("FactoryID", factoryId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
return(factory.Query(query));
}
/// <summary>
/// 按生产线ID获取所煤耗报警设置
/// </summary>
/// <param name="productLineId"></param>
/// <returns></returns>
public static DataTable GetCoalConsumptionAlarmSettingsByFactoryId(int productLineId)
{
string connectionString = ConnectionStringFactory.GetNXJCConnectionString();
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("CoalConsumptionAlarmParameterSetting");
query.AddCriterion("ProductLineID", productLineId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
return(factory.Query(query));
}
/// <summary>
/// 按生产线ID获取工段
/// </summary>
/// <param name="productLineId"></param>
/// <returns></returns>
public static DataTable GetWorkingTeamByProductLineId(int productLineId)
{
string connectionString = ConnectionStringFactory.NXJCConnectionString;
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("WorkingSection");
query.AddCriterion("ProductLineID", productLineId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
return(factory.Query(query));
}
/// <summary>
/// 按公式组ID获取公式组信息
/// </summary>
/// <param name="groupId"></param>
/// <returns></returns>
public static DataTable GetFormulaGroupInfoByGroupId(Guid groupId)
{
string connectionString = ConnectionStringFactory.NXJCConnectionString;
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("FormulaGroup");
query.AddCriterion("KeyID", groupId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
return(factory.Query(query));
}
/// <summary>
/// 按起始时间段获取停机记录
/// </summary>
/// <param name="productLineId"></param>
/// <param name="start"></param>
/// <param name="end"></param>
/// <returns></returns>
public static DataTable GetHaltLog(int productLineId, DateTime start)
{
string connectionString = ConnectionStringFactory.GetNXJCConnectionString();
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("MachineHaltLog");
query.AddCriterion("HaltTime", start, SqlServerDataAdapter.Infrastruction.CriteriaOperator.MoreThanOrEqual);
return(factory.Query(query));
}
/// <summary>
/// 获得DataSetInformation
/// </summary>
/// <param name="viewName"></param>
/// <returns></returns>
private IEnumerable <DataSetInformation> GetDataSetInformation(string organizationId)
{
IList <DataSetInformation> results = new List <DataSetInformation>();
Query query = new Query("EnergyConsumptionContrast");
//query.AddCriterion("ViewName", "viewName", viewName, CriteriaOperator.Equal);
query.AddCriterion("OrganizationID", "organizationId", organizationId, CriteriaOperator.Equal);
query.AddCriterion("Enabled", "enabled", "True", CriteriaOperator.Equal);
DataTable table = _dataFactory.Query(query);
foreach (DataRow item in table.Rows)
{
results.Add(new DataSetInformation
{
ViewId = item["VariableName"].ToString().Trim(),
FieldName = item["FieldName"].ToString().Trim(),
TableName = item["TableName"].ToString().Trim()
});
}
return(results);
}
/// <summary>
/// 按公式组ID获取所有公式
/// </summary>
/// <param name="groupId"></param>
/// <returns></returns>
public static DataTable GetFormulasByGroupId(Guid groupId)
{
string connectionString = ConnectionStringFactory.GetNXJCConnectionString();
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("Formula");
query.AddCriterion("GroupID", groupId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
query.OrderByClause = new SqlServerDataAdapter.Infrastruction.OrderByClause("LevelCode", false);
return(factory.Query(query));
}
public ReportResponse GetRepoersByType(ReportRequest request)
{
ReportResponse response = new ReportResponse();
Query query = new Query("Report");
query.AddCriterion("Type", request.ReportType, CriteriaOperator.Equal);
IEnumerable <Report> reports = reportRepository.FindBy(query);
response.Reports = reports;
return(response);
}
public Report FindBy(int id)
{
Query query = new Query("Report");
query.AddCriterion("ID", id, CriteriaOperator.Equal);
DataTable table = dataFactory.Query(query);
return(new Report
{
Id = int.Parse(table.Rows[0]["ID"].ToString().Trim()),
Name = table.Rows[0]["Name"].ToString().Trim(),
Type = (NXJC.Model.ReportForm.ReportType)table.Rows[0]["Type"],
Remarks = table.Rows[0]["Remarks"].ToString().Trim()
});
}
/// <summary>
///
/// </summary>
/// <param name="v_OrganizationID"></param>
/// <param name="v_type">1:熟料，2：水泥磨</param>
/// <param name="v_begin"></param>
/// <param name="v_end"></param>
/// <returns></returns>
public DataTable Get_Forecast_ProductionLineEnergy(string v_OrganizationID, string v_type, string v_begin, string v_end)
{
_string_error = "";//错误信息串
//string year = DateTime.Now.ToString("yyyy");
string year = v_end.Substring(0, 4);
DataTable temp = new DataTable();
if (v_type == "熟料") //熟料
{
temp = PredictHelper.GetClinkerData(v_OrganizationID, v_begin, v_end);
}
if (v_type == "水泥磨") //水泥磨
{
temp = PredictHelper.GetCementMillData(v_OrganizationID, v_begin, v_end);
}
AddAverageRow(temp, v_type); //增加均值行
CheckData(temp, v_type); //数据残缺度检查
Query query = new Query("forecast_ProductionLineEnergyConsumptionReference");
query.AddCriterion("OrganizationID", v_OrganizationID, CriteriaOperator.Equal);
DataTable temp_reference = _dataFactory.Query(query);
DataTable temp_history = temp_reference.Copy();
CrosswiseToLengthways(temp, temp_history, v_type);
Predict(temp_history, temp_reference);//第四步预测
DataTable temp_plan = tzHelper.GetReportData("tz_Plan", v_OrganizationID, year, "plan_EnergyConsumptionYearlyPlan");
if (temp_plan.Rows.Count == 0)
{
_string_error = _string_error + "生产线：" + v_OrganizationID + "的产量计划不存在！";
}
DataTable temp_result = new DataTable();
if (v_type == "熟料")
{ //熟料
temp_result = _dataFactory.Query("select * from forecast_ProductionLineEnergyConsumptionTemplate where Type ='熟料'");
} // 熟料
if (v_type == "水泥磨")
{ //水泥磨
temp_result = _dataFactory.Query("select * from forecast_ProductionLineEnergyConsumptionTemplate where Type ='水泥磨'");
} //水泥磨
Calculat(v_OrganizationID, temp_plan, temp_result, temp_history, v_type);
_dt = temp_result;
return(temp_result);
}
public ProductLine FindBy(int id)
{
Query query = new Query("ProductLine");
query.AddCriterion("ID", id, CriteriaOperator.Equal);
DataTable table = dataFactory.Query(query);
ProductLine result = new ProductLine
{
Id = int.Parse(table.Rows[0]["ID"].ToString().Trim()),
Address = table.Rows[0]["Address"].ToString().Trim(),
Name = table.Rows[0]["Name"].ToString().Trim(),
Remarks = table.Rows[0]["Remarks"].ToString().Trim(),
};
return(result);
}
public void TestDatapiontRepositoryFindByQueryMethod()
{
NHUnitOfWork nhUnitOfWork = new NHUnitOfWork();
DataPointRepository dataPointRepository = new DataPointRepository(nhUnitOfWork);
Query query = new Query();
query.AddCriterion(Criterion.Create <DataPoint>(p => p.DataType, DataType.S32, CriteriaOperator.Equal));
query.QueryOperator = QueryOperator.And;
//query.OrderByProperty = new OrderByClause() { PropertyName = "Number" ,Desc = true};
query.OrderByProperty = OrderByClause.Create <DataPoint>(p => p.Number, false);
List <DataPoint> dataPoints = (List <DataPoint>)dataPointRepository.FindBy(query);
Assert.NotNull(dataPoints);
}
/// <summary>
/// 初始化电能与产量数据库字典
/// </summary>
private static void InitializeMeterCatalogDictionary()
{
MeterCatalogDaictionary.Clear();
string connectionString = ConfigurationManager.ConnectionStrings["ManagementData"].ConnectionString;
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("DataBaseContrast");
query.AddCriterion("FactoryID", 0, CriteriaOperator.MoreThanOrEqual);
DataTable dt = factory.Query(query);
foreach (DataRow row in dt.Rows)
{
ProcessCatalogDictionary.Add(int.Parse(row["FactoryID"].ToString()), row["DataBaseName"].ToString().Trim());
}
}
/// <summary>
/// 获得DataSetInformation
/// </summary>
/// <param name="viewName"></param>
/// <returns></returns>
private IEnumerable <DataSetInformation> GetDataSetInformation(string viewName)
{
IList <DataSetInformation> results = new List <DataSetInformation>();
Query query = new Query("ContrastTable");
query.AddCriterion("ViewName", "viewName", viewName, CriteriaOperator.Equal);
DataTable table = dataFactory.Query(query);
foreach (DataRow item in table.Rows)
{
results.Add(new DataSetInformation
{
ViewId = item["VariableName"].ToString().Trim(),
FieldName = item["FieldName"].ToString().Trim(),
TableName = item["TableName"].ToString().Trim()
});
}
return(results);
}
/// <summary>
/// 获得视图变量路径信息
/// </summary>
/// <param name="viewName"></param>
/// <returns></returns>
public IEnumerable <DataPathInformation> GetDataPaths(int productLineId, string viewName)
{
string connectionString = ConnectionStringFactory.GetConnectionStringByProductLineID(productLineId, DatabaseType.DCSSystemDatabase);
ISqlServerDataFactory dataFactory = new SqlServerDataFactory(connectionString);
IList <DataPathInformation> results = new List <DataPathInformation>();
Query query = new Query("ContrastTable");
query.AddCriterion("ViewName", "viewName", viewName, CriteriaOperator.Equal);
DataTable table = dataFactory.Query(query);
foreach (DataRow item in table.Rows)
{
results.Add(new DataPathInformation
{
ViewId = item["VariableName"].ToString().Trim(),
FieldName = item["FieldName"].ToString().Trim(),
TableName = item["TableName"].ToString().Trim()
});
}
return(results);
}
/// <summary>
/// 按分厂ID获取数据库名（优先从缓存中查找）
/// </summary>
/// <param name="factoryID"></param>
/// <returns></returns>
private static string GetCatalogByFactoryID(int factoryID)
{
if (MeterCatalogDaictionary.ContainsKey(factoryID))
{
return(MeterCatalogDaictionary[factoryID]);
}
string connectionString = ConfigurationManager.ConnectionStrings["ManagementData"].ConnectionString;
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("DataBaseContrast");
query.AddCriterion("FactoryID", factoryID, CriteriaOperator.Equal);
DataTable dt = factory.Query(query);
if (dt.Rows.Count == 0)
{
throw new ApplicationException("没有此分公司");
}
MeterCatalogDaictionary.Add(factoryID, dt.Rows[0]["DataBaseName"].ToString().Trim());
return(MeterCatalogDaictionary[factoryID]);
}
