public IndicatorEditForm(IndicatorInfo indicator) { InitializeComponent(); CurrentIndicator = indicator; foreach (var item in Globals.GetTechnicalIndicatorList()) { comboIndicator.Properties.Items.Add(item); } if (indicator != null) { // means we are editing the indicator comboIndicator.Text = indicator.Name; comboInputValue.Text = indicator.InputValue; chkVisible.Checked = indicator.Visible; comboIndicator.Enabled = false; } else { comboIndicator.Text = Globals.GetTechnicalIndicatorList()[0]; comboInputValue.Text = "Close"; chkVisible.Checked = true; } }
public async Task <IActionResult> Edit(int id, [Bind("Id,FullName,ShortName,Unit")] IndicatorInfo indicatorInfo) { if (id != indicatorInfo.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(indicatorInfo); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!IndicatorInfoExists(indicatorInfo.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(indicatorInfo)); }
/// <summary> /// 得到绑定汽机或锅炉(TargetType:耗差类型:0可控耗差,1不可控耗差。ConsumeType:指标类型:0锅炉指标,1汽机指标) /// </summary> /// <returns></returns> public List <IndicatorInfo> GetInfo(string beginTime, string endTime, string unitId, string paraId, out string errMsg) { List <IndicatorInfo> list = new List <IndicatorInfo>(); List <VerticalInfo> infos = new List <VerticalInfo>(); IndicatorInfo sb = new IndicatorInfo(); DataTable dt = new DataTable(); DataTable dtTable = new DataTable(); dtTable = GetTableName(unitId, paraId, out errMsg); string tableName = dtTable.Rows.Count == 0 ? string.Empty : dtTable.Rows[0]["T_OUTTABLE"].ToString(); string unit = dtTable.Rows.Count == 0 ? string.Empty : dtTable.Rows[0]["T_UNIT"].ToString(); //得到实际值 if (!string.IsNullOrEmpty(tableName)) { dt = be.GetBase(tableName, beginTime, endTime, unitId, paraId, out errMsg); if (dt != null) { foreach (DataRow dr in dt.Rows) { sb.Name = String.IsNullOrEmpty(dr["T_DESC"].ToString()) ? String.Empty : dr["T_DESC"].ToString(); sb.RealValue = String.IsNullOrEmpty(dr["counts"].ToString()) ? 0 : Convert.ToDouble(dr["counts"].ToString()); sb.Unit = unit; list.Add(sb); } } } return(list); }
protected override void OnInit() { // Create instance of required indicator IndicatorInfo emaIndicatorInfo = Core.Instance.Indicators.All.FirstOrDefault(info => info.Name == "SuperTrend"); superTrendInd = Core.Instance.Indicators.CreateIndicator(emaIndicatorInfo); // Use previous stored settings if (superTrendIndSettings != null) { superTrendInd.Settings = superTrendIndSettings; } // Set default settings else { superTrendInd.Settings = new List <SettingItem> { new SettingItemInteger("ATR period", 11), new SettingItemDouble("Digit", 4), }; } // Add indicator AddIndicator(superTrendInd); }
private void btnSave_Click(object sender, EventArgs e) { this.DialogResult = DialogResult.OK; CurrentIndicator = GetCurrentIndicator(); this.Close(); }
/// <summary> /// 得到绑定汽机或锅炉(TargetType:指标类型:0锅炉指标,1汽机指标。ConsumeType:耗差类型:0可控耗差,1不可控耗差) /// </summary> /// <returns></returns> public List <IndicatorInfo> GetInfo(string beginTime, string endTime, string companyId, string plantId, string unitId, int TargetType, int ConsumeType, out string errMsg) { List <IndicatorInfo> list = new List <IndicatorInfo>(); List <FirstInfo> infos = new List <FirstInfo>(); infos = GetFirstInfo(companyId, plantId, unitId, TargetType, ConsumeType, out errMsg); foreach (var i in infos) { IndicatorInfo sb = new IndicatorInfo(); DataTable dt = new DataTable(); //dt = be.GetBase(i.TableName, beginTime, endTime, unitId, i.ParaId + "_el_B", TargetType, ConsumeType, out errMsg); ////得到基准值和指标类型和耗差类型 //if (dt != null) //{ // foreach (DataRow dr in dt.Rows) // { // sb.Name = String.IsNullOrEmpty(dr["T_DESC"].ToString()) ? String.Empty : dr["T_DESC"].ToString(); // sb.TargetType = String.IsNullOrEmpty(dr["I_TARGETTYPE"].ToString()) ? String.Empty : dr["I_TARGETTYPE"].ToString(); // sb.ConsumeType = String.IsNullOrEmpty(dr["I_CONSUMETYPE"].ToString()) ? String.Empty : dr["I_CONSUMETYPE"].ToString(); // sb.StandardValue = String.IsNullOrEmpty(dr["counts"].ToString()) ? 0 : Convert.ToDouble(dr["counts"].ToString()); // } //} //得到实际值 dt = be.GetBase(i.TableName, beginTime, endTime, unitId, i.ParaId, out errMsg); if (dt != null) { foreach (DataRow dr in dt.Rows) { sb.Name = String.IsNullOrEmpty(dr["T_DESC"].ToString()) ? String.Empty : dr["T_DESC"].ToString(); sb.TargetType = String.IsNullOrEmpty(dr["I_TARGETTYPE"].ToString()) ? String.Empty : dr["I_TARGETTYPE"].ToString(); sb.ConsumeType = String.IsNullOrEmpty(dr["I_CONSUMETYPE"].ToString()) ? String.Empty : dr["I_CONSUMETYPE"].ToString(); sb.RealValue = String.IsNullOrEmpty(dr["counts"].ToString()) ? 0 : Convert.ToDouble(dr["counts"].ToString()); } } ////得到耗差值 //dt =be.GetBase(i.TableName, beginTime, endTime, unitId, i.ParaId + "_el", TargetType, ConsumeType, out errMsg); //if (dt != null) //{ // foreach (DataRow dr in dt.Rows) // { // sb.ConsumeValue = String.IsNullOrEmpty(dr["counts"].ToString()) ? 0 : Convert.ToDouble(dr["counts"].ToString()); // } //} //参数单位 sb.Unit = i.Unit; list.Add(sb); } return(list); }
public async Task <IActionResult> Create([Bind("Id,FullName,ShortName,Unit")] IndicatorInfo indicatorInfo) { if (ModelState.IsValid) { _context.Add(indicatorInfo); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(indicatorInfo)); }
public void ProcessRequest(HttpContext context) { string param = context.Request["param"]; if (param != "") { if (param == "seachList") { string companId = String.IsNullOrEmpty(context.Request["companId"].ToString()) ? string.Empty : context.Request["companId"].ToString(); string plantId = String.IsNullOrEmpty(context.Request["plantId"].ToString()) ? string.Empty : context.Request["plantId"].ToString(); string unit = String.IsNullOrEmpty(context.Request["unit"].ToString()) ? string.Empty : context.Request["unit"].ToString(); //string time = String.IsNullOrEmpty(context.Request["time"].ToString())? string.Empty:context.Request["time"].ToString() ; string beginTime = String.IsNullOrEmpty(context.Request["beginTime"].ToString()) ? string.Empty : context.Request["beginTime"].ToString(); string endTime = String.IsNullOrEmpty(context.Request["endTime"].ToString()) ? string.Empty : context.Request["endTime"].ToString(); List <IndicatorInfo> infoList = new List <IndicatorInfo>(); List <IndicatorInfo> saveList = new List <IndicatorInfo>(); //获取汽机和锅炉的所有耗差类型。 infoList = bi.GetInfo(beginTime, endTime, companId, plantId, unit, -1, 1, out errMsg); //上线启用 //foreach (var info in infoList) for (int i = 0; i < infoList.Count; i++) { IndicatorInfo infos = new IndicatorInfo(); //info.Name = "主汽温度(°C)"; //info.StandardValue = 333.22; //info.RealValue = 54.32; //info.ConsumeValue = 87.09; if (!string.IsNullOrEmpty(infoList[i].Name)) { infos.Name = infoList[i].Name; infos.StandardValue = Math.Round(infoList[i].StandardValue, 2); infos.RealValue = Math.Round(infoList[i].RealValue, 2); infos.ConsumeValue = Math.Round(infoList[i].ConsumeValue, 2); saveList.Add(infos); } } int count = 0; object obj = new { total = count, rows = saveList }; string result = JsonConvert.SerializeObject(obj); context.Response.ContentType = "text/json;charset=gb2312;"; context.Response.Write(result); } } }
//private int ImportIndicator(DataRow row) //{ // int RetVal = -1; // IndicatorInfo IndicatorRecord; // IndicatorBuilder IndicatorBuilderObj; // IndicatorRecord = this.GetIndicatorInfo(row); // IndicatorBuilderObj = new IndicatorBuilder(this._TargetDBConnection, this._TargetDBQueries); // RetVal = IndicatorBuilderObj.ImportIndicator(IndicatorRecord, IndicatorRecord.Nid, this.SourceDBQueries, this.SourceDBConnection); // return RetVal; //} //private int ImportUnit(DataRow row) //{ // int RetVal = -1; // UnitInfo UnitRecord; // UnitBuilder UnitBuilderObj; // UnitRecord = this.GetUnitInfo(row); // UnitBuilderObj = new UnitBuilder(this._TargetDBConnection, this._TargetDBQueries); // RetVal = UnitBuilderObj.ImportUnit(UnitRecord, UnitRecord.Nid, this.SourceDBQueries, this.SourceDBConnection); // return RetVal; //} //private int ImportSubgroupVal(DataRow row) //{ // int RetVal = -1; // DI6SubgroupValBuilder SubgroupValBuilderObj = new DI6SubgroupValBuilder(this._TargetDBConnection, this._TargetDBQueries); // //import into target database // RetVal = SubgroupValBuilderObj.ImportSubgroupVal(Convert.ToInt32(row[SubgroupVals.SubgroupValNId]), this.SourceDBQueries, this.SourceDBConnection); // return RetVal; //} //private void ImportIUS(List<string> selectedNids, bool allSelected) //{ // int ProgressBarValue = 1; // int IndicatorNId = -1; // int UnitNId = -1; // int SGValNId = -1; // int MinValue=0; // int MaxValue=0; // DataRow[] Rows; // DataTable TempTable; // List<string> ImportedIndicatorNIDs = new List<string>(); // List<string> ImportedUnitNIDs = new List<string>(); // List<string> ImportedSGNIDs = new List<string>(); // IUSBuilder IusBuilderObj ; // if (this.ShowIUS) // { // // Get selected rows // if (allSelected) // { // Rows = this.SourceTable.Select("1=1"); // } // else // { // Rows = this.SourceTable.Select(this.TagValueColumnName + " IN ( " + string.Join(",", selectedNids.ToArray()) + ")"); // } // foreach (DataRow Row in Rows) // { // try // { // //import Indicator // IndicatorNId = Convert.ToInt32(Row[Indicator.IndicatorNId]); // if (!ImportedIndicatorNIDs.Contains(IndicatorNId.ToString())) // { // ImportedIndicatorNIDs.Add(IndicatorNId.ToString()); // IndicatorNId = this.ImportIndicator(Row); // } // // import unit // UnitNId = Convert.ToInt32(Row[Unit.UnitNId]); // if (!ImportedIndicatorNIDs.Contains(UnitNId.ToString())) // { // ImportedUnitNIDs.Add(UnitNId.ToString()); // UnitNId = this.ImportUnit(Row); // } // // import subgroupval // SGValNId=Convert.ToInt32(Row[SubgroupVals.SubgroupValNId]); // if (!ImportedSGNIDs.Contains(SGValNId.ToString())) // { // ImportedSGNIDs.Add(SGValNId.ToString()); // SGValNId = this.ImportSubgroupVal(Row); // } // //import IUS // if (IndicatorNId > 0 && UnitNId > 0 && SGValNId > 0) // { // //if(Convert.ToString(Row[Indicator_Unit_Subgroup.MaxValue]).Length>0) // //{ // //MaxValue= Convert.ToInt32(Row[Indicator_Unit_Subgroup.MaxValue]); // //} // //else // //{ // // MaxValue=0; // //} // //if(Convert.ToString(Row[Indicator_Unit_Subgroup.MinValue]).Length>0) // //{ // // MinValue= Convert.ToInt32(Row[Indicator_Unit_Subgroup.MinValue]); // //} // //else // //{ // // MinValue=0; // //} // IusBuilderObj = new IUSBuilder( this._TargetDBConnection, this._TargetDBQueries); // IusBuilderObj.ImportIUS(IndicatorNId, UnitNId, SGValNId, MinValue, MaxValue , this.SourceDBQueries, this.SourceDBConnection); // } // if (this.ShowSector) // { // this.ImportSector(Row); // } // } // catch (Exception) // { // throw; // } // this.RaiseIncrementProgessBarEvent(ProgressBarValue); // ProgressBarValue++; // } // } //} /// <summary> /// Imports records from source database to target database/template /// </summary> /// <param name="selectedNids"></param> /// <param name="allSelected">Set true to import all records</param> public override void ImportValues(List <string> selectedNids, bool allSelected) { DataRow Row; IndicatorInfo IndicatorRecord = null; IndicatorBuilder IndicatorBuilderObj = null; DI7MetadataCategoryBuilder MetadataCategoryBuilderObj = null; int ProgressBarValue = 1; // import indicator metadata categories MetadataCategoryBuilderObj = new DI7MetadataCategoryBuilder(this._TargetDBConnection, this._TargetDBQueries); MetadataCategoryBuilderObj.ImportAllMetadataCategories(this.SourceDBConnection, this.SourceDBQueries, MetadataElementType.Indicator); // import IUS or indicator foreach (string Nid in selectedNids) { try { Row = this.SourceTable.Select(this.TagValueColumnName + "=" + Nid)[0]; if (this._ShowIUS) { this.ImportForIUS(Row); } else { //import indicator IndicatorRecord = this.GetIndicatorInfo(Row); IndicatorBuilderObj = new IndicatorBuilder(this._TargetDBConnection, this._TargetDBQueries); IndicatorBuilderObj.ImportIndicator(IndicatorRecord, Convert.ToInt32(Nid), this.SourceDBQueries, this.SourceDBConnection); if (this._ShowSector) { this.ImportSector(Row); } } } catch (Exception) { throw; } this.RaiseIncrementProgessBarEvent(ProgressBarValue); ProgressBarValue++; } if (this._ShowIUS && this._ShowSector) { this.ImportSectors(selectedNids, allSelected); } }
private void BtnAddIndicator_Click(object sender, EventArgs e) { var f = new IndicatorEditForm(null); f.ShowDialog(); if (f.DialogResult == DialogResult.OK) { IndicatorInfo indicator = f.CurrentIndicator; var n = treeIndicators.Nodes.Add(new object[] { indicator.Name + " (" + indicator.Period + ")" }); n.Tag = indicator; } }
private void CurrentIndicator_Disposed(object sender, EventArgs e) { lock (_lock) { if (_currentIndicator != null) { _currentIndicator.Disposed -= CurrentIndicator_Disposed; _currentIndicator = null; } this.Title = null; this.IsWorking = false; ProcessQueue(); } }
private IndicatorInfo GetCurrentIndicator() { var ind = new IndicatorInfo(); ind.Name = comboIndicator.Text; ind.Visible = chkVisible.Checked; ind.InputValue = comboInputValue.Text; foreach (TreeListNode n in treeProperties.Nodes) { var vValue = n.GetValue(treeListColumn2); var vName = n.GetDisplayText(treeListColumn1); if (vName == X_PERIOD) { ind.Period = Convert.ToInt32(vValue); } else if (vName == X_STDEV) { ind.StdDev = (float)Convert.ToDouble(vValue); } else if (vName == X_LINE_COLOR) { ind.LineColor = (Color)vValue; } else if (vName == X_FAST_PERIOD) { ind.FastPeriod = Convert.ToInt32(vValue); } else if (vName == X_SLOW_PERIOD) { ind.SlowPeriod = Convert.ToInt32(vValue); } else if (vName == X_FAST_COLOR) { ind.FastColor = (Color)vValue; } else if (vName == X_SLOW_COLOR) { ind.SlowColor = (Color)vValue; } else { } } return(ind); }
protected override void OnInit() { // Create instance of required indicator IndicatorInfo emaIndicatorInfo = Core.Instance.Indicators.All.FirstOrDefault(info => info.Name == "Exponential Moving Average"); emaInd = Core.Instance.Indicators.CreateIndicator(emaIndicatorInfo); // Set indicator parameters emaInd.Settings = new List <SettingItem> { new SettingItemInteger("MaPeriod", 10) }; // Add AddIndicator(emaInd); }
//根据不同类型的机组获取信息 public void GetInfo() { string companyId = String.IsNullOrEmpty(Request["companyId"]) ? string.Empty : Request["companyId"].ToString(); string plantId = String.IsNullOrEmpty(Request["plantId"]) ? string.Empty : Request["plantId"].ToString(); string unit = String.IsNullOrEmpty(Request["unit"]) ? string.Empty : Request["unit"].ToString(); string beginTime = String.IsNullOrEmpty(Request["BeginTime"]) ? string.Empty : Request["BeginTime"].ToString(); string endTime = String.IsNullOrEmpty(Request["EndTime"]) ? string.Empty : Request["EndTime"].ToString(); List <IndicatorInfo> infoList = new List <IndicatorInfo>(); List <IndicatorInfo> saveList = new List <IndicatorInfo>(); //获取汽机和锅炉的所有耗差类型。 infoList = bi.GetInfo(beginTime, endTime, companyId, plantId, unit, 1, -1, out errMsg); //上线启用 IndicatorInfo infos; for (int i = 0; i < infoList.Count; i++) { infos = new IndicatorInfo(); if (!string.IsNullOrEmpty(infoList[i].Name)) { infos.Name = infoList[i].Name; infos.StandardValue = Math.Round(infoList[i].StandardValue, 2); infos.RealValue = Math.Round(infoList[i].RealValue, 2); infos.ConsumeValue = Math.Round(infoList[i].ConsumeValue, 2); infos.Unit = infoList[i].Unit; saveList.Add(infos); } } int count = saveList.Count; object obj = new { total = count, rows = saveList }; string result = JsonConvert.SerializeObject(obj); //Response.ContentType = "text/json;charset=utf-8;"; Response.Write(result); Response.End(); }
IDisposable IShowIndicatorViewService.ShowIndicator(string title, TimeSpan timeout) { var _indicatorInfo = new IndicatorInfo(title, timeout); lock (_lock) { // lazy load, also note we only keep a weak reference to the indicator info if (_indicators == null) { _indicators = new Queue <WeakReference>(); } _indicators.Enqueue(new WeakReference(_indicatorInfo)); ProcessQueue(); } // we initialize and return - note unlike status viewer, the timers are run together and not one-by-one _indicatorInfo.Initialize(); return(_indicatorInfo); }
private IndicatorInfo GetIndicatorInfo(DataRow row) { IndicatorInfo RetVal; try { //get unit from source table RetVal = new IndicatorInfo(); RetVal.Name = DICommon.RemoveQuotes(row[Indicator.IndicatorName].ToString()); RetVal.GID = row[Indicator.IndicatorGId].ToString(); RetVal.Global = Convert.ToBoolean(row[Indicator.IndicatorGlobal]); RetVal.Info = DICommon.RemoveQuotes(Convert.ToString(row[Indicator.IndicatorInfo])); RetVal.Nid = Convert.ToInt32(row[Indicator.IndicatorNId]); } catch (Exception ex) { RetVal = null; ExceptionFacade.ThrowException(ex); } return(RetVal); }
private void ProcessQueue() { lock (_lock) { if (_currentIndicator != null || _indicators == null || _indicators.Count == 0) { return; } var _indicatorReference = _indicators.Dequeue(); if (_indicatorReference != null && _indicatorReference.IsAlive) { _currentIndicator = (IndicatorInfo)_indicatorReference.Target; if (_currentIndicator != null) { if (_currentIndicator.IsDisposed) { this.Title = null; _currentIndicator = null; } else { this.Title = _currentIndicator.Title; _currentIndicator.Disposed += CurrentIndicator_Disposed; _currentIndicator.Initialize(); } } _indicatorReference.Target = null; _indicatorReference = null; } // if no current active indicator, the process queue this.IsWorking = (_currentIndicator != null); if (!this.IsWorking) { ProcessQueue(); } } }
private void TreeIndicators_DoubleClick(object sender, EventArgs e) { TreeListHitInfo hi = treeIndicators.CalcHitInfo(treeIndicators.PointToClient(Control.MousePosition)); if (hi.Node != null) { IndicatorInfo indicator = (IndicatorInfo)hi.Node.Tag; var f = new IndicatorEditForm(indicator); f.ShowDialog(); if (f.DialogResult == DialogResult.OK) { indicator = f.CurrentIndicator; hi.Node.SetValue(treeListColumn1, indicator.Name + " (" + indicator.Period + ")"); hi.Node.Tag = indicator; treeIndicators.Refresh(); } } }
public static IIndicator CreateIndicator(Bars bars, IndicatorInfo info) { Log.Instance.Trace("CreateIndicator {0}", info); IIndicator indicator; BarsSingleValues baseIndicator; switch (info.Base) { case IndicatorBase.Open: baseIndicator = new BarsOpen(bars); break; case IndicatorBase.Close: baseIndicator = new BarsClose(bars); break; case IndicatorBase.High: baseIndicator = new BarsHigh(bars); break; case IndicatorBase.Low: baseIndicator = new BarsLow(bars); break; default: return null; } switch (info.Type) { case IndicatorType.EMA: indicator = new Ema(baseIndicator, info.Period); break; case IndicatorType.Simple: indicator = new Simple(baseIndicator, info.Period); break; default: return null; } return indicator; }
public ChildExampleViewController(IndicatorInfo itemInfo) : base(null, null) { this.ItemInfo = itemInfo; }
public void ProcessRequest(HttpContext context) { string unit = String.IsNullOrEmpty(context.Request["unit"].ToString()) ? string.Empty : context.Request["unit"].ToString(); //string time = String.IsNullOrEmpty(context.Request["time"].ToString())? string.Empty:context.Request["time"].ToString() ; string beginTime = String.IsNullOrEmpty(context.Request["beginTime"].ToString()) ? string.Empty : context.Request["beginTime"].ToString(); string endTime = String.IsNullOrEmpty(context.Request["endTime"].ToString()) ? string.Empty : context.Request["endTime"].ToString(); string timeType = String.IsNullOrEmpty(context.Request["timeType"].ToString()) ? string.Empty : context.Request["timeType"].ToString(); string quarterType = String.IsNullOrEmpty(context.Request["quarterType"].ToString()) ? string.Empty : context.Request["quarterType"].ToString(); //根据选择的时间段,设置开始时间和结束时间 switch (quarterType) { case "0": //指定时间段 break; case "1": //月度平均值 DateTime dt1 = new DateTime(); dt1 = Convert.ToDateTime(beginTime.Substring(0, 7) + "-01"); beginTime = dh.GetFirstDayOfMonth(dt1).ToString(); endTime = dh.GetLastDayOfMonth(dt1).ToString(); break; case "2": //季度平均值 switch (quarterType) { case "0": //一季度 string ti = beginTime.Substring(0, 4) + "-01-01"; beginTime = ti; endTime = beginTime.Substring(0, 4) + "-03-31"; break; case "1": //二季度 string ti1 = beginTime.Substring(0, 4) + "-04-01"; beginTime = ti1; endTime = beginTime.Substring(0, 4) + "-06-30"; break; case "2": //三季度 string ti2 = beginTime.Substring(0, 4) + "-07-01"; beginTime = ti2; endTime = beginTime.Substring(0, 4) + "-09-30"; break; case "3": //四季度 string ti3 = beginTime.Substring(0, 4) + "-10-01"; beginTime = ti3; endTime = beginTime.Substring(0, 4) + "-12-31"; break; } break; case "3": //年度平均值 string tim = beginTime.Substring(0, 4); beginTime = tim + "01-01"; endTime = tim + "-12-31"; break; } List <IndicatorInfo> infoList = new List <IndicatorInfo>(); //获取锅炉的所有耗差类型。 infoList = bl.GetInfo(beginTime, endTime, unit, -1, 0, out errMsg); //foreach (var info in infoList) //{ for (int i = 0; i < 10; i++) { IndicatorInfo infos = new IndicatorInfo(); infos.Name = "主汽温度(°C)"; infos.StandardValue = 333.22; infos.RealValue = 54.32; infos.ConsumeValue = 87.09; //上线启用 //infos.Name = info.Name; //infos.StandardValue = info.StandardValue; //infos.RealValue = info.RealValue; //infos.ConsumeValue = info.ConsumeValue; infoList.Add(infos); } //} string content = infoList.ToJsonItem(); int count = 0; object obj = new { total = count, rows = infoList }; string result = JsonConvert.SerializeObject(obj); context.Response.ContentType = "text/json;charset=gb2312;"; context.Response.Write(result); }
public void GetBCList() { //string companyId = Request["company"].ToString(); //string plantId = Request["plant"].ToString(); //string unitId = Request["unit"].ToString(); //string beginTime = Request["beginTime"].ToString(); //string endTime = Request["endTime"].ToString(); //int page = Convert.ToInt32(Request["page"].ToString()); //int rows = Convert.ToInt32(Request["rows"].ToString()); //int sCount = (page - 1) * rows + 1; //int eCount = page * rows; ////总的行数。 //int count = 0; //DataTable dt = bl.GetInitByCondition(companyId, plantId, unitId, beginTime, endTime, sCount, eCount, out count, out errMsg); ////int count =dt.Rows.Count; //IList<Hashtable> list = new List<Hashtable>(); //foreach (DataRow item in dt.Rows) //{ // Hashtable ht = new Hashtable(); // ht.Add("T_CODE", item["T_CODE"]); // ht.Add("T_UNITDESC", item["T_UNITDESC"].ToString()); // ht.Add("D_CAPABILITY", item["D_CAPABILITY"].ToString()); // ht.Add("I_GAAG", item["I_GAAG"].ToString()); // ht.Add("I_PH", item["I_PH"].ToString()); // ht.Add("I_AH", item["I_AH"].ToString()); // ht.Add("I_SH", item["I_SH"].ToString()); // ht.Add("I_UOH", item["I_UOH"].ToString()); // ht.Add("I_FOH", item["I_FOH"].ToString()); // ht.Add("I_EUNDH", item["I_EUNDH"].ToString()); // list.Add(ht); //} //object obj = new //{ // total = count, // rows = list //}; //string result = JsonConvert.SerializeObject(obj); //Response.Write(result); //Response.End(); string unit = String.IsNullOrEmpty(Request["unit"].ToString()) ? string.Empty : Request["unit"].ToString(); string time = String.IsNullOrEmpty(Request["time"].ToString()) ? string.Empty : Request["time"].ToString(); string beginTime = String.IsNullOrEmpty(Request["beginTime"].ToString()) ? string.Empty : Request["beginTime"].ToString(); string endTime = String.IsNullOrEmpty(Request["endTime"].ToString()) ? string.Empty : Request["endTime"].ToString(); string timeType = String.IsNullOrEmpty(Request["timeType"].ToString()) ? string.Empty : Request["timeType"].ToString(); string quarterType = String.IsNullOrEmpty(Request["quarterType"].ToString()) ? string.Empty : Request["quarterType"].ToString(); //根据选择的时间段,设置开始时间和结束时间 switch (quarterType) { case "0": //指定时间段 break; case "1": //月度平均值 DateTime dt1 = new DateTime(); dt1 = Convert.ToDateTime(beginTime.Substring(0, 7) + "-01"); beginTime = dh.GetFirstDayOfMonth(dt1).ToString(); endTime = dh.GetLastDayOfMonth(dt1).ToString(); break; case "2": //季度平均值 switch (quarterType) { case "0": //一季度 string ti = beginTime.Substring(0, 4) + "-01-01"; beginTime = ti; endTime = beginTime.Substring(0, 4) + "-03-31"; break; case "1": //二季度 string ti1 = beginTime.Substring(0, 4) + "-04-01"; beginTime = ti1; endTime = beginTime.Substring(0, 4) + "-06-30"; break; case "2": //三季度 string ti2 = beginTime.Substring(0, 4) + "-07-01"; beginTime = ti2; endTime = beginTime.Substring(0, 4) + "-09-30"; break; case "3": //四季度 string ti3 = beginTime.Substring(0, 4) + "-10-01"; beginTime = ti3; endTime = beginTime.Substring(0, 4) + "-12-31"; break; } break; case "3": //年度平均值 string tim = beginTime.Substring(0, 4); beginTime = tim + "01-01"; endTime = tim + "-12-31"; break; } List <IndicatorInfo> infoList = new List <IndicatorInfo>(); //获取汽机的所有耗差类型。 //infoList = bl.GetInfo(beginTime, endTime, unit, -1, 1, out errMsg); for (int i = 0; i < 10; i++) { IndicatorInfo info = new IndicatorInfo(); info.Name = "主汽温度(°C)"; info.StandardValue = 333.22; info.RealValue = 54.32; info.ConsumeValue = 87.09; } //string content = infoList.ToJsonItem(); //int count = 0; //object obj = new //{ // total = count, // rows = infoList //}; string result = JsonConvert.SerializeObject(infoList); //Response.ContentType = "text/json;charset=gb2312;"; Response.Write(result); }
private void InitPropertyList(IndicatorInfo indicator) { var hasPeriod = false; var hasStDev = false; var hasLineColor = false; var hasFastPeriod = false; var hasSlowPeriod = false; var hasFastColor = false; var hasSlowColor = false; var indName = (indicator != null) ? indicator.Name : comboIndicator.Text; if (indName == Globals.IND_ParabolicSAR || indName == Globals.IND_CCI || indName == Globals.IND_ATR || indName == Globals.IND_ADX || indName == Globals.IND_WilliamsR) { comboInputValue.Visible = false; lblInputValue.Visible = false; } else { comboInputValue.Visible = true; lblInputValue.Visible = true; } if (indName == Globals.IND_SimpleMovingAverage) { hasPeriod = true; hasLineColor = true; } else if (indName == Globals.IND_ExponentialMovingAverage) { hasPeriod = true; hasLineColor = true; } else if (indName == Globals.IND_ParabolicSAR) { hasLineColor = true; } else if (indName == Globals.IND_BollingerBands) { hasPeriod = true; hasStDev = true; hasLineColor = true; } else if (indName == Globals.IND_MACD) { hasFastPeriod = true; hasSlowPeriod = true; hasFastColor = true; hasSlowColor = true; } else if (indName == Globals.IND_RSI) { hasLineColor = true; hasPeriod = true; } else if (indName == Globals.IND_CCI || indName == Globals.IND_ATR || indName == Globals.IND_ADX || indName == Globals.IND_WilliamsR) { hasPeriod = true; hasLineColor = true; } else if (indName == Globals.IND_SD) { hasPeriod = true; hasStDev = true; hasLineColor = true; } treeProperties.ClearNodes(); if (indicator == null) { indicator = new IndicatorInfo(); } if (hasPeriod) { var pValue = (indicator != null) ? indicator.Period : 14; var n = treeProperties.Nodes.Add(new object[] { X_PERIOD, pValue }); } if (hasStDev) { var pValue = (indicator != null) ? indicator.StdDev : 2.0f; var n = treeProperties.Nodes.Add(new object[] { X_STDEV, pValue }); } if (hasLineColor) { var pValue = (indicator != null) ? indicator.LineColor : Color.LawnGreen; var n = treeProperties.Nodes.Add(new object[] { X_LINE_COLOR, pValue }); } if (hasFastPeriod) { var pValue = (indicator != null) ? indicator.FastPeriod : 12; var n = treeProperties.Nodes.Add(new object[] { X_FAST_PERIOD, pValue }); } if (hasSlowPeriod) { var pValue = (indicator != null) ? indicator.SlowPeriod : 24; var n = treeProperties.Nodes.Add(new object[] { X_SLOW_PERIOD, pValue }); } if (hasFastColor) { var pValue = (indicator != null) ? indicator.FastColor : Color.LawnGreen; var n = treeProperties.Nodes.Add(new object[] { X_FAST_COLOR, pValue }); } if (hasSlowColor) { var pValue = (indicator != null) ? indicator.SlowColor : Color.LawnGreen; var n = treeProperties.Nodes.Add(new object[] { X_SLOW_COLOR, pValue }); } }
/// <summary> /// 得到绑定汽机或锅炉(TargetType:耗差类型:0可控耗差,1不可控耗差。ConsumeType:指标类型:0锅炉指标,1汽机指标) /// </summary> /// <returns></returns> public List <IndicatorInfo> GetInfo(string beginTime, string endTime, string unitId, int TargetType, int ConsumeType, out string errMsg) { List <IndicatorInfo> list = new List <IndicatorInfo>(); List <TmpInfoE> infos = new List <TmpInfoE>(); infos = GetFirstInfo(unitId, out errMsg); if (TargetType == 0 || TargetType == 1) { infos = infos.Where(info => info.TargetType == TargetType).ToList(); } if (ConsumeType == 0 || ConsumeType == 1) { infos = infos.Where(info => info.ConsumeType == ConsumeType).ToList(); } foreach (var i in infos) { IndicatorInfo sb = new IndicatorInfo(); sb.Name = i.Desc; sb.TargetType = i.TargetType.ToString(); sb.ConsumeType = i.ConsumeType.ToString(); DataTable dt = new DataTable(); dt = GetBase(i.TableName, beginTime, endTime, unitId, i.ParaId + "_B", out errMsg); //得到基准值和指标类型和耗差类型 if (dt != null) { foreach (DataRow dr in dt.Rows) { sb.StandardValue = String.IsNullOrEmpty(dr["counts"].ToString()) ? 0 : Convert.ToDouble(dr["counts"].ToString()); } } //得到实际值 dt = GetBase(i.TableName, beginTime, endTime, unitId, i.ParaId.Remove(i.ParaId.Length - 3, 3), out errMsg); if (dt != null) { foreach (DataRow dr in dt.Rows) { sb.RealValue = String.IsNullOrEmpty(dr["counts"].ToString()) ? 0 : Convert.ToDouble(dr["counts"].ToString()); } } //得到耗差值 dt = GetBase(i.TableName, beginTime, endTime, unitId, i.ParaId, out errMsg); if (dt != null) { foreach (DataRow dr in dt.Rows) { sb.ConsumeValue = String.IsNullOrEmpty(dr["counts"].ToString()) ? 0 : Convert.ToDouble(dr["counts"].ToString()); } } list.Add(sb); } return(list); }
public TableChildExampleViewController(UITableViewStyle style, IndicatorInfo itemInfo) : base(style) { this.ItemInfo = itemInfo; }
public override void Import(string selectedGIds) { int ProgressCounter = 0; DataTable Table = null; string selectedNids = string.Empty; selectedNids = selectedGIds; // Initialize progress bar this.RaiseProgressBarInitialize(selectedGIds.Split(',').GetUpperBound(0) + 1); IndicatorBuilder TrgIndicatorBuilderObj = null; IndicatorBuilder SourceIndicatorBuilder = null; IndicatorInfo IndicatorInfoObj = null; Dictionary <string, DataRow> FileWithNids = new Dictionary <string, DataRow>(); DIConnection SourceDBConnection = null; DIQueries SourceDBQueries = null; //-- Step 1: Get TempTable with Sorted SourceFileName Table = this._TargetDBConnection.ExecuteDataTable(this.ImportQueries.GetImportIndicator(selectedNids)); //-- Step 2:Initialise Indicator Builder with Target DBConnection TrgIndicatorBuilderObj = new IndicatorBuilder(this.TargetDBConnection, this.TargetDBQueries); //-- Step 3: Import Nids for each SourceFile foreach (DataRow Row in Table.Copy().Rows) { try { string SourceFileWPath = Convert.ToString(Row[MergetTemplateConstants.Columns.COLUMN_SOURCEFILENAME]); SourceDBConnection = new DIConnection(DIServerType.MsAccess, String.Empty, String.Empty, SourceFileWPath, String.Empty, MergetTemplateConstants.DBPassword); SourceDBQueries = DataExchange.GetDBQueries(SourceDBConnection); // Get Source Indicator Info SourceIndicatorBuilder = new IndicatorBuilder(SourceDBConnection, SourceDBQueries); IndicatorInfoObj = SourceIndicatorBuilder.GetIndicatorInfo(FilterFieldType.NId, Convert.ToString(Row[MergetTemplateConstants.Columns.COLUMN_SRCNID]), FieldSelection.Light); // Import INdicator By Nid TrgIndicatorBuilderObj.ImportIndicator(IndicatorInfoObj, Convert.ToInt32(Row[MergetTemplateConstants.Columns.COLUMN_SRCNID]), SourceDBQueries, SourceDBConnection); ProgressCounter += 1; this.RaiseProgressBarIncrement(ProgressCounter); } catch (Exception ex) { ExceptionFacade.ThrowException(ex); } finally { if (SourceDBConnection != null) { SourceDBConnection.Dispose(); } if (SourceDBQueries != null) { SourceDBQueries.Dispose(); } } } this._AvailableTable = this.GetAvailableTable(); this._UnmatchedTable = this.GetUnmatchedTable(); // Close ProgressBar this.RaiseProgressBarClose(); }
public void ProcessRequest(HttpContext context) { string unit = context.Request["unit"] == null ? string.Empty : context.Request["unit"].ToString(); //string time = String.IsNullOrEmpty(context.Request["time"].ToString())? string.Empty:context.Request["time"].ToString() ; string beginTime = context.Request["beginTime"] == null ? string.Empty : context.Request["beginTime"].ToString(); string endTime = context.Request["endTime"] == null? string.Empty : context.Request["endTime"].ToString(); string timeType = context.Request["timeType"] == null ? string.Empty : context.Request["timeType"].ToString(); string quarterType = context.Request["quarterType"] == null ? string.Empty : context.Request["quarterType"].ToString(); //根据选择的时间段,设置开始时间和结束时间 switch (timeType) { case "0": //指定时间段 break; case "1": //月度平均值 DateTime dt1 = new DateTime(); dt1 = Convert.ToDateTime(beginTime.Substring(0, 7) + "-01"); beginTime = dh.GetFirstDayOfMonth(dt1).ToString().Replace("/", "-"); endTime = dh.GetLastDayOfMonth(dt1).ToString().Replace("/", "-"); break; case "2": //季度平均值 switch (quarterType) { case "0": //一季度 string ti = beginTime.Substring(0, 4) + "-01-01 00:00:00"; beginTime = ti; endTime = beginTime.Substring(0, 4) + "-03-31 23:59:59"; break; case "1": //二季度 string ti1 = beginTime.Substring(0, 4) + "-04-01 00:00:00"; beginTime = ti1; endTime = beginTime.Substring(0, 4) + "-06-30 23:59:59"; break; case "2": //三季度 string ti2 = beginTime.Substring(0, 4) + "-07-01 00:00:00"; beginTime = ti2; endTime = beginTime.Substring(0, 4) + "-09-30 23:59:59"; break; case "3": //四季度 string ti3 = beginTime.Substring(0, 4) + "-10-01 00:00:00"; beginTime = ti3; endTime = beginTime.Substring(0, 4) + "-12-31 23:59:59"; break; } break; case "3": //年度平均值 string tim = beginTime.Substring(0, 4); beginTime = tim + "-01-01 00:00:00"; endTime = tim + "-12-31 23:59:59"; break; } List <IndicatorInfo> infoList = new List <IndicatorInfo>(); List <IndicatorInfo> saveList = new List <IndicatorInfo>(); //获取汽机和锅炉的所有耗差类型。 infoList = bl.GetInfo(beginTime, endTime, unit, -1, -1, out errMsg); List <IndicatorInfo> tmpList = infoList.Where(info => info.ConsumeType == "0" || info.ConsumeType == "1").ToList(); //上线启用 //foreach (var info in infoList) for (int i = 0; i < tmpList.Count; i++) { IndicatorInfo infos = new IndicatorInfo(); //info.Name = "主汽温度(°C)"; //info.StandardValue = 333.22; //info.RealValue = 54.32; //info.ConsumeValue = 87.09; if (!string.IsNullOrEmpty(tmpList[i].Name)) { infos.Name = tmpList[i].Name; infos.StandardValue = Math.Round(tmpList[i].StandardValue, 2); infos.RealValue = Math.Round(tmpList[i].RealValue, 2); infos.ConsumeValue = Math.Round(tmpList[i].ConsumeValue, 2); saveList.Add(infos); } } //IndicatorInfo infos = new IndicatorInfo(); //infos.Name = "主汽温度(°C)"; //infos.StandardValue = 538.22; //infos.RealValue = 533.32; //infos.ConsumeValue = 0.64; //infoList.Add(infos); //infos = new IndicatorInfo(); //infos.Name = "主汽压力(Mpa)"; //infos.StandardValue = 16.70; //infos.RealValue = 16.43; //infos.ConsumeValue = 0.21; //infoList.Add(infos); int count = 0; object obj = new { total = count, rows = saveList }; string result = JsonConvert.SerializeObject(obj); context.Response.ContentType = "text/json;charset=gb2312;"; context.Response.Write(result); }