/// <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();
}
