/// <summary>
/// 绑定数据
/// </summary>
void BindValues()
{
DataTable dt = CurveTagDal.GetTagLists("");
gvCurve.DataSource = dt;
gvCurve.DataBind();
}
protected void btnXLineSave_Click(object sender, EventArgs e)
{
if (CurveID == "")
{
MessageBox.popupClientMessage(this.Page, "请选择具体曲线！", "call();");
return;
}
int xlinetype = int.Parse(ddl_CurveType.SelectedValue);
int xlinegetype = int.Parse(ddl_CurveGetType.SelectedValue);
double dout = 0;
string xlinexyz = "";
if (xlinetype == 0)
{
if (!double.TryParse(tbxXLineXYZ.Text, out dout))
{
MessageBox.popupClientMessage(this.Page, "定值格式不正确！无法保存！", "call();");
return;
}
}
else if (xlinetype == 1)
{
if (dtXLine.Rows.Count < 2)
{
MessageBox.popupClientMessage(this.Page, "区间定义不完整！无法保存！", "call();");
return;
}
}
else if (xlinetype == 2)
{
if (dtXLine.Rows.Count < 2 && dtXLine.Columns.Count < 2)
{
MessageBox.popupClientMessage(this.Page, "区间定义不完整！无法保存！", "call();");
return;
}
}
CurveTagEntity mEntity = CurveTagDal.GetEntity(CurveID);
mEntity.CurveType = xlinetype;
mEntity.CurveGetType = xlinegetype;
mEntity.CurveXRealTag = ddl_CurveXRealTag.SelectedValue != "NULLDATA" ? ddl_CurveXRealTag.SelectedValue : "";
mEntity.CurveYRealTag = ddl_CurveYRealTag.SelectedValue != "NULLDATA" ? ddl_CurveYRealTag.SelectedValue : "";
mEntity.CurveZRealTag = "";
xlinexyz = ECTagDal.SetXLineXYZ(xlinetype, dtXLine, dout);
mEntity.CurveXYZ = xlinexyz;
CurveTagDal.Update(mEntity);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//btnApply.Attributes.Add("onclick", "setDivPos('Lay1');Lay1.style.visibility='';progress_update();");
//数据信息
DataTable dt = KPI_RealTagDal.GetRealXYZLists();
ddl_ECXLineXRealTag.Items.Add(new ListItem("默认机组负荷", "NULLDATA"));
ddl_ECXLineYRealTag.Items.Add(new ListItem("默认机组负荷", "NULLDATA"));
foreach (DataRow dr in dt.Rows)
{
ddl_ECXLineXRealTag.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
ddl_ECXLineYRealTag.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//初始化列表
dtCurve = CurveTagDal.GetCurvesByGroup();
foreach (DataRow dr in dtCurve.Rows)
{
rblCurveTags.Items.Add(new ListItem(dr["Name"].ToString(), dr["Group"].ToString()));
}
//初始化
dtScore = ECTagDal.GetInitScore();
//判断是否新建或编辑
if (Request.QueryString["ecid"] != null)
{
ViewState["ecid"] = Request.QueryString["ecid"].ToString();
btnAddScore.Enabled = true;
BindValues();
}
else
{
//添加
ViewState["ecid"] = "";
btnAddScore.Enabled = false;
}
tbxXLineXYZ.Text = "0.00";
gvXLine.ShowHeader = false;
BindXLine(true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//指标信息
//if (Request.QueryString["webcode"] != null)
//{
// WebCode = Request.QueryString["webcode"].ToString();
//}
//else
//{
// WebCode = "";
//}
//初始化指标集合
DataTable dt = ECTagDal.GetKPIs("");
ECCode.DataSource = dt;
ECCode.DataBind();
dt = CurveTagDal.GetCurvesByCode();
KeyTarget1.Items.Add(new ListItem("", "NOTAG"));
KeyTarget2.Items.Add(new ListItem("", "NOTAG"));
foreach (DataRow dr in dt.Rows)
{
KeyTarget1.Items.Add(new ListItem(dr["Name"].ToString(), dr["Code"].ToString()));
KeyTarget2.Items.Add(new ListItem(dr["Name"].ToString(), dr["Code"].ToString()));
}
//ddlECTag1.DataSource = dt;
//ddlECTag1.DataTextField = "Name";
//ddlECTag1.DataValueField = "Code";
//ddlECTag1.DataBind();
//ddlECTag2.DataSource = dt;
//ddlECTag2.DataTextField = "Name";
//ddlECTag2.DataValueField = "Code";
//ddlECTag2.DataBind();
//绑定名称
BindTextBox(ECCode.SelectedValue);
//类型集合
BindKeys();
}
}
protected void gvCurve_RowCommand(object sender, GridViewCommandEventArgs e)
{
//string[] keyvalue = e.CommandArgument.ToString().Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
//string keyid = "";
//string keytype = "";
//if (keyvalue.Length == 2)
//{
// keyid = keyvalue[0];
// keytype = keyvalue[1];
//}
string curveid = e.CommandArgument.ToString();
if (e.CommandName == "dataDelete")
{
if (CurveTagDal.DeleteTag(curveid))
{
BindValues();
MessageBox.popupClientMessage(this.Page, "删除成功！", "call();");
}
//MessageBox.popupClientMessage(this.Page, "删除错误！", "call();");
}
else if (e.CommandName == "dataCopy")
{
//CurveID = curveid;
if (CurveTagDal.CopyCurveTag(curveid))
{
MessageBox.popupClientMessage(this.Page, "复制成功，请修改相关配置！", "call();");
BindXLine(true);
}
else
{
MessageBox.popupClientMessage(this.Page, "复制错误, xxx_copy的名称已存在！", "call();");
}
}
else if (e.CommandName == "dataConfig")
{
CurveID = curveid;
BindXLine(true);
}
}
//////////////////////////////////////////////////////////////////////////////
#region Define Functions
/// <summary>
///
/// </summary>
/// <returns></returns>
public bool KPIInitialVar()
{
try {
//是否取服务器时间
bTimeMode = KPI_SystemDal.GetKPITimeMode() == 1 ? true : false;
//偏置时间
nOffset = KPI_SystemDal.GetKPIOffset();
//初始所有List<>
ltUnits = KPI_UnitDal.GetValidEntity();
ltSeqs = KPI_SeqDal.GetValidEntity();
ltKpis = KpiDal.GetValidEntity();
//实时、手录、曲线指标
ltReals = KPI_RealTagDal.GetAllEntity();
ltInputs = KPI_InputTagDal.GetAllEntity();
ltCurves = CurveTagDal.GetAllEntity();
//计算周期
List <CycleEntity> ltCYs = CycleDal.GetAllEntity();
dicCYs = new Dictionary <string, CycleEntity>();
foreach (CycleEntity cye in ltCYs)
{
dicCYs[cye.CycleID] = cye;
}
//经济指标
ltECs = ECTagDal.GetValidEntity();
ltXLines = ECTagDal.GetAllXLineEntity();
ltScores = ECTagDal.GetAllScoreEntity();
/////////////////////////////////////////////////////////////////
//安全指标
dicUnitStatus = new Dictionary <string, bool>();
dicUnitPEs = new Dictionary <string, double>();
dicTags = new Dictionary <string, double>();
dicRealTag = new Dictionary <string, RealTag>();
}
catch (Exception ex) {
LogUtil.LogMessage(ex.ToString());
return(false);
}
return(true);
}
protected void btnAddCurve_Click(object sender, EventArgs e)
{
int index = CurveTagDal.CurveIDCounts();
string sID = PageControl.GetGuid();
CurveTagEntity ote = new CurveTagEntity();
ote.CurveID = sID;
ote.CurveCode = "InputCode";
ote.CurveName = "InputName";
ote.CurveDesc = "";
ote.CurveGroup = "InputGroup";
ote.CurveMonth = "1,2,3,4,5,6,7,8,9,10,11,12,";
ote.CurveIsValid = 0;
ote.CurveIndex = 100;
ote.CurveType = 0;
ote.CurveGetType = 0;
ote.CurveXRealTag = "";
ote.CurveYRealTag = "";
ote.CurveZRealTag = "";
ote.CurveXYZ = "";
ote.CurveNote = "";
ote.CurveCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.CurveModifyTime = ote.CurveCreateTime;
if (CurveTagDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
gvCurve.EditIndex = index;
BindValues();
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
}
void BindXLine(bool binit)
{
if (CurveID == "")
{
return;
}
int xlinetype = int.Parse(ddl_CurveType.SelectedValue);
int xlinegettype = int.Parse(ddl_CurveGetType.SelectedValue);
double dout = 0;
//bool bResult = true;
if (binit)
{
mEntity = CurveTagDal.GetEntity(CurveID);
lblInfor.Text = "当前曲线为： " + mEntity.CurveCode + mEntity.CurveName;
xlinetype = mEntity.CurveType;
xlinegettype = mEntity.CurveGetType;
dtXLine = new DataTable();
ddl_CurveType.SelectedValue = xlinetype.ToString();
ddl_CurveGetType.SelectedValue = xlinegettype.ToString();
ECTagDal.GetXLineXYZ(xlinetype, mEntity.CurveXYZ, out dtXLine, out dout);
}
//if (binit)
//{
//}
if (xlinetype == 0)
{
lblGetType.Visible = false;
ddl_CurveGetType.Visible = false;
spanX.Visible = false;
spanXX.Visible = false;
spanY.Visible = false;
spanYY.Visible = false;
btnAddX.Visible = false;
btnAddY.Visible = false;
//
tbxXLineXYZ.Visible = true;
tbxXLineXYZ.Text = dout.ToString("0.000");
gvXLine.Visible = false;
gvXLine.DataSource = null;
gvXLine.DataBind();
}
else if (xlinetype == 1)
{
lblGetType.Visible = true;
ddl_CurveGetType.Visible = true;
spanX.Visible = true;
spanXX.Visible = true;
spanY.Visible = false;
spanYY.Visible = false;
btnAddX.Visible = true;
btnAddY.Visible = true;
ddl_CurveXRealTag.SelectedValue = mEntity.CurveXRealTag != "" ? mEntity.CurveXRealTag : "NULLDATA";
//ddl_CurveYRealTag.SelectedValue = mEntity.CurveYRealTag != "" ? mEntity.CurveYRealTag : "NULLDATA";
tbxXLineXYZ.Visible = false;
//tbxXLineXYZ.Text = dout.ToString("0.000");
gvXLine.Visible = true;
gvXLine.DataSource = dtXLine;
gvXLine.DataBind();
}
else if (xlinetype == 2)
{
lblGetType.Visible = true;
ddl_CurveGetType.Visible = true;
spanX.Visible = true;
spanXX.Visible = true;
spanY.Visible = true;
spanYY.Visible = true;
btnAddX.Visible = true;
btnAddY.Visible = true;
ddl_CurveXRealTag.SelectedValue = mEntity.CurveXRealTag != "" ? mEntity.CurveXRealTag : "NULLDATA";
ddl_CurveYRealTag.SelectedValue = mEntity.CurveYRealTag != "" ? mEntity.CurveYRealTag : "NULLDATA";
tbxXLineXYZ.Visible = false;
//tbxXLineXYZ.Text = dout.ToString("0.000");
gvXLine.Visible = true;
gvXLine.DataSource = dtXLine;
gvXLine.DataBind();
}
}
protected void gvCurve_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
HtmlInputHidden key = (HtmlInputHidden)gvCurve.Rows[e.RowIndex].Cells[0].FindControl("curveid");
string sID = key.Value;
string sCode = ((TextBox)(gvCurve.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
string sName = ((TextBox)(gvCurve.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
string sDesc = ((TextBox)(gvCurve.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
string sGroup = ((TextBox)(gvCurve.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim();
string sMonth = ((TextBox)(gvCurve.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim();
string sValid = ((DropDownList)(gvCurve.Rows[e.RowIndex].Cells[6].FindControl("ddlValid"))).SelectedValue;
string msg = "";
if (sCode == "")
{
msg += "代码不能为空！\r\n";
}
if (sName == "")
{
msg += "名称不能为空！\r\n";
}
if (msg != "")
{
MessageBox.popupClientMessage(this.Page, msg);
return;
}
//代码是否重复
if (CurveTagDal.CodeExist(sCode, sID) || ALLDal.CodeExist(sCode, sID))
{
MessageBox.popupClientMessage(this.Page, "已存在相同的代码!");
return;
}
//更新
CurveTagEntity ote = new CurveTagEntity();
ote.CurveID = sID;
ote.CurveCode = sCode;
ote.CurveName = sName;
ote.CurveDesc = sDesc;
ote.CurveGroup = sGroup;
ote.CurveMonth = sMonth;
ote.CurveIndex = 100;
ote.CurveIsValid = int.Parse(sValid);
ote.CurveModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
if (CurveTagDal.Update(ote))
{
MessageBox.popupClientMessage(this.Page, "编辑成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "编辑错误！", "call();");
}
gvCurve.EditIndex = -1;
BindValues();
}
protected void btnXLineSave_Click(object sender, EventArgs e)
{
int xlinetype = int.Parse(ddl_ECXLineType.SelectedValue);
int xlinegetype = int.Parse(ddl_ECXLineGetType.SelectedValue);
double dout = 0;
string xtag = ddl_ECXLineXRealTag.SelectedValue != "NULLDATA" ? ddl_ECXLineXRealTag.SelectedValue : "";
string ytag = ddl_ECXLineYRealTag.SelectedValue != "NULLDATA" ? ddl_ECXLineYRealTag.SelectedValue : "";
string ztag = "";
string xlinexyz = "";
string curvegroup = "";
if (xlinetype == 0)
{
if (!double.TryParse(tbxXLineXYZ.Text, out dout))
{
MessageBox.popupClientMessage(this.Page, "定值格式不正确！无法保存！", "call();");
return;
}
}
else if (xlinetype == 1)
{
if (dtXLine.Rows.Count < 2)
{
MessageBox.popupClientMessage(this.Page, "区间定义不完整！无法保存！", "call();");
return;
}
xlinexyz = ECTagDal.SetXLineXYZ(xlinetype, dtXLine, dout);
}
else if (xlinetype == 2)
{
if (dtXLine.Rows.Count < 2 && dtXLine.Columns.Count < 2)
{
MessageBox.popupClientMessage(this.Page, "区间定义不完整！无法保存！", "call();");
return;
}
xlinexyz = ECTagDal.SetXLineXYZ(xlinetype, dtXLine, dout);
}
// ==3
else if (xlinetype == 4)
{
//
foreach (ListItem ltm in rblCurveTags.Items)
{
if (ltm.Selected)
{
curvegroup = ltm.Value;
break;
}
}
DataTable dtc = CurveTagDal.GetCurvesByGroup(curvegroup);
if (dtc.Rows.Count >= 1)
{
xtag = dtc.Rows[0]["CurveXRealTag"].ToString();
ytag = dtc.Rows[0]["CurveYRealTag"].ToString();
ztag = "";
//借用此字段 存储曲线Group中的CurveType 类型
xlinexyz = dtc.Rows[0]["CurveType"].ToString();
}
}
mEntity.ECXLineXRealTag = xtag;
mEntity.ECXLineYRealTag = ytag;
mEntity.ECXLineZRealTag = ztag;
mEntity.ECXLineXYZ = xlinexyz;
mEntity.ECCurveGroup = curvegroup;
ECTagDal.Update(mEntity);
txtFlag.Value = "0";
}
