/// <summary> /// /// </summary> void BindValues() { //需要显示的集合 string ECID = ViewState["ECID"].ToString(); if (ECID.Equals("")) { return; } string strStartTime = txt_ST.Value; string strEndTime = txt_ET.Value; DateTime dtST = DateTime.Now; DateTime dtET = DateTime.Now; if (!DateTime.TryParse(strStartTime, out dtST) || !DateTime.TryParse(strEndTime, out dtET) || dtST < dtET.AddHours(-48)) { MessageBox.popupClientMessage(this.Page, "时间格式不正确,并且间隔不能大于 48小时!"); return; } DataTable dt = ECSSArchiveDal.GetAllRecords(ECID, strStartTime, strEndTime); //绑定参数 gvEC.DataSource = dt; gvEC.DataBind(); }
/// <summary> /// /// </summary> void BindValues() { //判断 string QueryTime = txt_Month.Value; DateTime dtQT = DateTime.Now; if (!DateTime.TryParse(QueryTime, out dtQT)) { MessageBox.popupClientMessage(this.Page, "时间选择不正确!", "call();"); return; } // //查询前会处理。在DAL中增加1小时 string plantid = ddlPlant.SelectedValue; string ecweb = ViewState["ecweb"].ToString(); DataTable dtResult = ECSSArchiveDal.GetRaceForPlant(plantid, ecweb, dtQT); //绑定参数 gvBonus.DataSource = dtResult; gvBonus.DataBind(); }
/// <summary> /// 机组信息 /// </summary> void BindValue() { if (WebCode == "") { return; } DateTime StartTime = DateTime.Now; DateTime EndTime = DateTime.Now; //都是 日期的形式 if (!DateTime.TryParse(txt_ST.Value, out StartTime) || !DateTime.TryParse(txt_ET.Value, out EndTime) || StartTime >= EndTime) { MessageBox.popupClientMessage(this.Page, "时间格式不正确 或 时间范围不正确!"); return; } //加 1小时 StartTime = StartTime.AddHours(1); EndTime = EndTime.AddHours(1); string UnitID = ddlUnit.SelectedValue; //WebCode //得分、得分率、合格率、最大值、最小值、算数平均值、加权平均值、累计值、累计除法 string calctype = KPI_WebKeyDal.GetCalcType(WebCode); DataTable dtValue = ECSSArchiveDal.GetForShiftValue(UnitID, WebCode, calctype, StartTime, EndTime); DataTable dtGD = ConvertToTable(dtValue, calctype); //第1列为名称,必须为0; totalvalue = new double[dtGD.Columns.Count]; //初始化 for (int x = 0; x < totalvalue.Length; x++) { totalvalue[x] = 0; } gvData.DataSource = dtGD; gvData.DataBind(); }
/// <summary> /// 机组信息 /// </summary> void BindValue() { if (WebCode == "") { return; } DateTime StartTime = DateTime.Now; DateTime EndTime = DateTime.Now; //都是 日期的形式 if (!DateTime.TryParse(txt_ST.Value, out StartTime) || !DateTime.TryParse(txt_ET.Value, out EndTime) || StartTime >= EndTime) { MessageBox.popupClientMessage(this.Page, "时间格式不正确 或 时间范围不正确!"); return; } //加 1小时 StartTime = StartTime.AddHours(1); EndTime = EndTime.AddHours(1); string shiftname = ddlShift.SelectedItem.Text; if (shiftname == "全部") { shiftname = ""; } //WebCode //得分、得分率、合格率、最大值、最小值、算数平均值、加权平均值、累计值、累计除法 string calctype = KPI_WebKeyDal.GetCalcType(WebCode); DataTable dtValue = ECSSArchiveDal.GetForUnitValue(shiftname, WebCode, calctype, StartTime, EndTime); DataTable dtGD = ConvertToTable(dtValue, calctype); gvData.DataSource = dtGD; gvData.DataBind(); }
/// <summary> /// /// </summary> void BindValues() { //需要显示的集合 string ecweb = ViewState["ecweb"].ToString(); //if (ecweb.Equals("")) //{ // return; //} string unitid = ddlUnit.SelectedValue; //时间 DateTime dtST = DateTime.Parse(txt_ST.Value); DateTime dtET = DateTime.Parse(txt_ET.Value); DataTable dt = ECSSArchiveDal.GetScoreForUnit(unitid, ecweb, dtST, dtET); //绑定参数 gvScore.DataSource = dt; gvScore.DataBind(); }
/// <summary> /// /// </summary> void BindValues() { //判断 string QueryTime = txt_Month.Value; DateTime dtQT = DateTime.Now; if (!DateTime.TryParse(QueryTime, out dtQT)) { MessageBox.popupClientMessage(this.Page, "时间选择不正确!", "call();"); return; } string QueryMoney = tbxKPIMoney.Text; double dQM = 0.0; if (!double.TryParse(QueryMoney, out dQM) && dQM <= 0) { MessageBox.popupClientMessage(this.Page, "奖金金额不正确!", "call();"); return; } string plantid = ddlPlant.SelectedValue; string ecweb = ViewState["ecweb"].ToString(); // //查询前会处理。在DAL中增加1小时 dtMoney = ECSSArchiveDal.GetBonusForPlant(plantid, ecweb, dtQT, dQM); dBonus = dQM; //绑定参数 gvBonus.DataSource = dtMoney; gvBonus.DataBind(); }
public void BindValue() { DateTime StartTime = DateTime.Now; DateTime EndTime = DateTime.Now; //都是 日期的形式 if (!DateTime.TryParse(txt_ST.Value, out StartTime) || !DateTime.TryParse(txt_ET.Value, out EndTime) || StartTime >= EndTime) { MessageBox.popupClientMessage(this.Page, "时间格式不正确 或 时间范围不正确!"); return; } //不用添加 //加 1小时 //StartTime = StartTime.AddHours(1); //EndTime = EndTime.AddHours(1); //string UnitID = ddlUnit.SelectedValue; //WebCode totalvalue = 0; //平均值查询 DataTable dtValue = ECSSArchiveDal.GetForAvgValue(StartTime, EndTime); //值处理 foreach (DataRow dr in dtValue.Rows) { double dAVG = 0; double dDSG = 0; double dOPT = 0; double dMNY = 0; if (dr["KeyAVG"] != null && double.TryParse(dr["KeyAVG"].ToString(), out dAVG)) { //设计偏差与百分比 if (dr["KeyDesign"] != null && double.TryParse(dr["KeyDesign"].ToString(), out dDSG)) { dr["KeyOptDiff"] = (dAVG - dDSG).ToString("0.000"); if (dDSG == 0) { dr["KeyOptPercent"] = "100"; dMNY = 0; } else { dr["KeyOptPercent"] = ((dAVG - dDSG) / dDSG).ToString("0.000"); dMNY = double.Parse(dr["KeyDIffMoney"].ToString()) * (1 - Math.Abs((dAVG - dDSG) / dDSG)); } } //目标偏差与百分比 if (dr["KeyTarget"] != null && double.TryParse(dr["KeyTarget"].ToString(), out dOPT)) { dr["KeyTarDiff"] = (dAVG - dOPT).ToString("0.000"); if (dDSG == 0) { dr["KeyTarPercent"] = "100"; dMNY += 0; } else { dr["KeyTarPercent"] = ((dAVG - dDSG) / dDSG).ToString("0.000"); dMNY += double.Parse(dr["KeyOptMoney"].ToString()) * (1 - Math.Abs((dAVG - dOPT) / dOPT)); } } //奖金 dr["KeyMoney"] = dMNY.ToString("0.000"); totalvalue += dMNY; } } gvData.DataSource = dtValue; gvData.DataBind(); }