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