void BindListBox()
{
string ecid = ViewState["ecid"].ToString();
DataTable dt = KPI_RealTagDal.GetTAGs();
lbx_TAG.DataSource = dt;
lbx_TAG.DataTextField = "Name";
lbx_TAG.DataValueField = "Code";
lbx_TAG.DataBind();
dt = ECTagDal.GetKPIs(ecid);
lbx_KPI.DataSource = dt;
lbx_KPI.DataTextField = "Name";
lbx_KPI.DataValueField = "Code";
lbx_KPI.DataBind();
ExpDone Parser = new ExpDone();
Dictionary <String, String> dic = Parser.CustomFunctionsListing();
ddlCustomFunction.Items.Add(new ListItem("请选择", "NULL"));
foreach (KeyValuePair <String, String> kvp in dic)
{
ddlCustomFunction.Items.Add(new ListItem(kvp.Value, kvp.Key));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//指标信息
string WebCode = "";
if (Request.QueryString["webcode"] != null)
{
WebCode = Request.QueryString["webcode"].ToString();
}
else
{
WebCode = "";
}
lblInfor.Text = WebCode;
//初始化指标集合
DataTable dt = ECTagDal.GetKPIs("");
this.ECCode.DataSource = dt;
this.ECCode.DataBind();
//绑定名称
BindTextBox(ECCode.SelectedValue);
SISKPI.KPIDataSetTableAdapters.GetCalcTypeTableAdapter a = new SISKPI.KPIDataSetTableAdapters.GetCalcTypeTableAdapter();
this.KeyCalcType.DataSource = a.GetData();
this.KeyCalcType.DataBind();
//类型集合
BindKeys(WebCode);
}
}
/// <summary>
/// 绑定数据
/// </summary>
void BindValues()
{
string ECID = ViewState["ecid"].ToString();
if (ECID == "")
{
btnAddScore.Enabled = false;
return;
}
mEntity = ECTagDal.GetEntity(ECID);
if (mEntity == null)
{
return;
}
lbl_ECCode.Text = "指标代码：" + mEntity.ECCode;
lbl_ECName.Text = "指标名称：" + mEntity.ECName;
cbx_ECIsSnapshot.Checked = mEntity.ECIsSnapshot == 1 ? true : false;
BindScore(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <returns></returns>
bool Insert(string ecid)
{
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ecid;
//mEntity.UnitID = ddl_UnitID.SelectedValue;
//mEntity.SeqID = ddl_SeqID.Value.Trim();
//mEntity.KpiID = ddl_KpiID.SelectedValue;
//mEntity.EngunitID = ddl_EngunitID.Value.Trim();
//mEntity.CycleID = ddl_CycleID.Value.Trim();
//mEntity.ECIsValid = int.Parse(ddl_ECIsValid.Value);
//mEntity.ECIsCalc = int.Parse(ddl_ECIsCalc.Value);
//mEntity.ECIsDisplay = int.Parse(ddl_ECIsDisplay.Value);
//mEntity.ECIsTotal = int.Parse(ddl_ECIsTotal.Value);
//mEntity.ECCode = txt_ECCode.Value.Trim();
//mEntity.ECName = txt_ECName.Value.Trim();
//mEntity.ECDesc = txt_ECDesc.Value.Trim();
//mEntity.ECIndex = int.Parse(txt_ECIndex.Value.Trim());
//mEntity.ECWeb = ddl_ECWeb.Value;
////
//mEntity.ECDesign = txt_ECDesign.Value;
//mEntity.ECOptimal = txt_ECOptimal.Value;
//mEntity.ECMaxValue = int.Parse(txt_ECMaxValue.Value.Trim());
//mEntity.ECMinValue = int.Parse(txt_ECMinValue.Value.Trim());
//mEntity.ECWeight = int.Parse(txt_ECWeight.Value.Trim());
//mEntity.ECNote = txt_ECNote.Value.Trim();
//mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
//mEntity.ECModifyTime = mEntity.ECCreateTime;
return(ECTagDal.Insert(mEntity));
}
protected void btnScoreSave_Click(object sender, EventArgs e)
{
if (mEntity == null)
{
MessageBox.popupClientMessage(this.Page, "使用系数前,请先绑定指标实体！", "call();");
return;
}
string scoreexp = "";
foreach (DataRow dr in dtScore.Rows)
{
string scoreexpindex = dr["ScoreCalcExp"].ToString();
scoreexpindex += ",";
scoreexpindex += dr["ScoreGainExp"].ToString();
scoreexpindex += ",";
scoreexpindex += dr["ScoreOptimal"].ToString();
scoreexpindex += ",";
scoreexpindex += dr["ScoreAlarm"].ToString();
scoreexpindex += ",";
scoreexpindex += dr["ScoreIsValid"].ToString();
scoreexpindex += ";";
scoreexp += scoreexpindex;
}
mEntity.ECScoreExp = scoreexp;
ECTagDal.Update(mEntity);
txtFlag.Value = "0";
}
void BindGrid()
{
gvTable = ECTagDal.GetSearchListForSort();
gvTag.DataSource = gvTable;
gvTag.DataBind();
}
protected void btnXLineDel_Click(object sender, EventArgs e)
{
int xlinetype = int.Parse(ddl_CurveType.SelectedValue);
tbxXLineXYZ.Text = "0.00";
dtXLine = ECTagDal.GetInitXYZ(xlinetype);
BindXLine(false);
}
/// <summary>
/// 绑定数据
/// </summary>
void BindValues()
{
string ECID = ViewState["ecid"].ToString();
if (ECID == "")
{
return;
}
ECTagEntity mEntity = ECTagDal.GetEntity(ECID);
ddl_UnitID.SelectedValue = mEntity.UnitID;
ddl_SeqID.Value = mEntity.SeqID;
ddl_KpiID.SelectedValue = mEntity.KpiID;
ddl_EngunitID.Value = mEntity.EngunitID;
ddl_CycleID.Value = mEntity.CycleID;
ddl_ECIsValid.Value = mEntity.ECIsValid.ToString();
ddl_ECIsCalc.Value = mEntity.ECIsCalc.ToString();
ddl_ECIsAsses.Value = mEntity.ECIsAsses.ToString();
ddl_ECIsZero.Value = mEntity.ECIsZero.ToString();
ddl_ECIsDisplay.Value = mEntity.ECIsDisplay.ToString();
ddl_ECIsTotal.Value = mEntity.ECIsTotal.ToString();
ddl_ECWeb.Value = mEntity.ECWeb;
txt_ECCode.Value = mEntity.ECCode;
txt_ECName.Value = mEntity.ECName;
txt_ECDesc.Value = mEntity.ECDesc;
txt_ECIndex.Value = mEntity.ECIndex.ToString();
txt_ECDesign.Value = mEntity.ECDesign;
if (mEntity.ECMaxValue == decimal.MinValue)
{
txt_ECMaxValue.Value = "";
}
else
{
txt_ECMaxValue.Value = mEntity.ECMaxValue.ToString();
}
if (mEntity.ECMinValue == decimal.MinValue)
{
txt_ECMinValue.Value = "";
}
else
{
txt_ECMinValue.Value = mEntity.ECMinValue.ToString();
}
//txt_ECMinValue.Value = mEntity.ECMinValue.ToString();
txt_ECWeight.Value = mEntity.ECWeight.ToString();
txt_ECDenom.Value = mEntity.ECDenom.ToString();
txt_ECCalcClass.Value = mEntity.ECCalcClass.ToString();
txt_ECNote.Value = mEntity.ECNote;
}
protected void btnSearchKPI_Click(object sender, EventArgs e)
{
string ecid = ViewState["ecid"].ToString();
string name = txt_KPI.Value;
DataTable dt = ECTagDal.GetKPIs(ecid);
lbx_KPI.DataSource = dt;
lbx_KPI.DataTextField = "Name";
lbx_KPI.DataValueField = "Code";
lbx_KPI.DataBind();
}
protected void rblRMType_SelectedIndexChanged(object sender, EventArgs e)
{
if (rblRMType.SelectedValue == "0")
{
cbxRMKPIID.Visible = false;
ddlRMKPIID.Visible = true;
ddlRMKPIID.Items.Clear();
DataTable dt = KPI_UnitDal.GetUnits("");
foreach (DataRow dr in dt.Rows)
{
ddlRMKPIID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
}
else if (rblRMType.SelectedValue == "1")
{
cbxRMKPIID.Visible = false;
ddlRMKPIID.Visible = true;
ddlRMKPIID.Items.Clear();
DataTable dt = KPI_SeqDal.GetSeqs();
foreach (DataRow dr in dt.Rows)
{
ddlRMKPIID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
}
else if (rblRMType.SelectedValue == "2")
{
cbxRMKPIID.Visible = false;
ddlRMKPIID.Visible = true;
ddlRMKPIID.Items.Clear();
DataTable dt = KpiDal.GetKpis();
foreach (DataRow dr in dt.Rows)
{
ddlRMKPIID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
}
else if (rblRMType.SelectedValue == "3")
{
cbxRMKPIID.Visible = true;
cbxRMKPIID.Items.Clear();
ddlRMKPIID.Visible = false;
ddlRMKPIID.Items.Clear();
DataTable dt = ECTagDal.GetECs();
foreach (DataRow dr in dt.Rows)
{
cbxRMKPIID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
}
}
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);
}
/// <summary>
/// 更新数据
/// </summary>
/// <returns></returns>
bool Update()
{
string ecid = ViewState["ecid"].ToString();
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ecid;
mEntity.UnitID = ddl_UnitID.SelectedValue;
mEntity.SeqID = ddl_SeqID.Value.Trim();
mEntity.KpiID = ddl_KpiID.SelectedValue;
mEntity.EngunitID = ddl_EngunitID.Value.Trim();
mEntity.CycleID = ddl_CycleID.Value.Trim();
mEntity.ECIsValid = int.Parse(ddl_ECIsValid.Value);
mEntity.ECIsCalc = int.Parse(ddl_ECIsCalc.Value);
mEntity.ECIsAsses = int.Parse(ddl_ECIsAsses.Value);
mEntity.ECIsZero = int.Parse(ddl_ECIsZero.Value);
mEntity.ECIsDisplay = int.Parse(ddl_ECIsDisplay.Value);
mEntity.ECIsTotal = int.Parse(ddl_ECIsTotal.Value);
mEntity.ECCode = txt_ECCode.Value.Trim();
mEntity.ECName = txt_ECName.Value.Trim();
mEntity.ECDesc = txt_ECDesc.Value.Trim();
//if (txt_ECIndex.Value != "")
//{}
mEntity.ECIndex = int.Parse(txt_ECIndex.Value);
mEntity.ECWeb = ddl_ECWeb.Value;
//
mEntity.ECDesign = txt_ECDesign.Value;
mEntity.ECOptimal = txt_ECOptimal.Value;
if (txt_ECMaxValue.Value != "")
{
mEntity.ECMaxValue = decimal.Parse(txt_ECMaxValue.Value);
}
if (txt_ECMinValue.Value != "")
{
mEntity.ECMinValue = decimal.Parse(txt_ECMinValue.Value);
}
mEntity.ECWeight = decimal.Parse(txt_ECWeight.Value.Trim());
mEntity.ECDenom = decimal.Parse(txt_ECDenom.Value.Trim());
mEntity.ECCalcClass = int.Parse(txt_ECCalcClass.Value.Trim());
mEntity.ECNote = txt_ECNote.Value.Trim();
//mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
mEntity.ECModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
return(ECTagDal.Update(mEntity));
}
/// <summary>
/// 绑定数据
/// </summary>
void BindValues()
{
string ECID = ViewState["ecid"].ToString();
ECTagEntity mEntity = ECTagDal.GetEntity(ECID);
lbl_ECCode.Text = "指标代码：" + mEntity.ECCode;
lbl_ECName.Text = "指标名称：" + mEntity.ECName;
//
tbx_ECCalcExp.Text = mEntity.ECCalcExp;
tbx_ECCalcDesc.Text = mEntity.ECCalcDesc;
}
public void KPI_SubWeb_Add(HttpContext context)
{
//KeyID,WebCode,ECCode,ECName,KeyEngunit,KeyCalcType,KeyIndex
string KeyID = Guid.NewGuid().ToString();
string WebCode = context.Request["WebCode"];
string ECCode = context.Request["ECCode"];
string ECName = context.Request["ECName"];
string KeyEngunit = context.Request["KeyEngunit"];
string KeyCalcType = context.Request["KeyCalcType"];
string KeyIndex = context.Request["KeyIndex"];
int iKeyIndex = 0;
if (!int.TryParse(KeyIndex, out iKeyIndex))
{
context.Response.Write("{\"status\":\"序号数字不合法！\"}");
return;
}
if (KPI_WebKeyDal.KeyExists(ECCode, WebCode))
{
context.Response.Write("{\"status\":\"该指标已存在！\"}");
return;
}
KPI_WebKeyEntity kwk = new KPI_WebKeyEntity();
//
kwk.KeyID = KeyID;
kwk.ECID = ECTagDal.GetECIDByCode(ECCode);
kwk.ECCode = ECCode;
kwk.ECName = ECName;
kwk.WebCode = WebCode;
kwk.KeyEngunit = KeyEngunit;
kwk.KeyCalcType = int.Parse(KeyCalcType);
kwk.KeyIndex = iKeyIndex;
kwk.KeyIsValid = 1;
kwk.KeyNote = "";
kwk.KeyCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
kwk.KeyModifyTime = kwk.KeyCreateTime;
if (KPI_WebKeyDal.Insert(kwk))
{
context.Response.Write("{\"status\":\"ok\"}");
}
else
{
context.Response.Write("{\"status\":\"添加失败！\"}");
return;
}
}
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 bool ImportFromExcelToDelete(DataSet ds)
{
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nDelete = 0;
int nEmpty = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
string ECCode = dr["ECCode"].ToString().Trim();
//判断是否存在
if (!ECTagDal.CodeExist(ECCode, ""))
{
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
nEmpty += 1;
continue;
}
else
{
//main tag
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ECTagDal.GetECIDByCode(ECCode);
ECTagDal.Delete(mEntity);
nDelete += 1;
}
}
}
string strInfor = "标签点总数为：{0}个, 删除成功:{1}个，空标签点: {2}个。";
strInfor = string.Format(strInfor, nAll, nDelete, nEmpty);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
return(true);
}
catch (Exception ee)
{
//
MessageBox.popupClientMessage(this.Page, ee.Message, "call();");
return(false);
}
}
/// <summary>
/// 更新数据
/// </summary>
/// <returns></returns>
bool Update()
{
string ecid = ViewState["ecid"].ToString();
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ecid;
mEntity.ECCalcExp = tbx_ECCalcExp.Text;//.Replace("'", "''");
mEntity.ECCalcDesc = tbx_ECCalcDesc.Text;
mEntity.ECModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
return(ECTagDal.Update(mEntity));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
btnDelete.Attributes.Add("onclick", "return confirm('确认删除吗?');");
//机组信息
DataTable dt = KPI_UnitDal.GetUnits("");
ddl_UnitID.Items.Add(new ListItem("所有机组集", "ALL"));
foreach (DataRow dr in dt.Rows)
{
ddl_UnitID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//设备信息
dt = KPI_SeqDal.GetSeqs();
ddl_SeqID.Items.Add(new ListItem("所有设备集", "ALL"));
foreach (DataRow dr in dt.Rows)
{
ddl_SeqID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//指标信息
dt = KpiDal.GetKpis();
ddl_KpiID.Items.Add(new ListItem("所有指标集", "ALL"));
foreach (DataRow dr in dt.Rows)
{
ddl_KpiID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//周期集信息
//dt = KPI_CycleDal.GetCycles();
//ddl_CycleID.Items.Add(new ListItem("所有周期", "ALL"));
//foreach (DataRow dr in dt.Rows)
//{
// ddl_CycleID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
//}
//实时指标信息
dt = ECTagDal.GetECs();
ddl_ECID.Items.Add(new ListItem("所有指标", "ALL"));
foreach (DataRow dr in dt.Rows)
{
ddl_ECID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
BindEC();
}
}
//private static int brcalc = 0;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = ECTagDal.GetECs();
foreach (DataRow dr in dt.Rows)
{
ddl_EC.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
txt_ST.Value = "2012-12-15 08:00:00";
txt_ET.Value = "2012-12-15 21:00:00";
BindValues();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
//查询条件
string UnitID = "";
string SeqID = "";
string KpiID = "";
string ECID = "";
//机组信息
if (ddl_UnitID.Value != "ALL")
{
UnitID = ddl_UnitID.Value;
}
//设备信息
if (ddl_SeqID.Value != "ALL")
{
SeqID = ddl_SeqID.Value;
}
//指标信息
if (ddl_KpiID.Value != "ALL")
{
KpiID = ddl_KpiID.Value;
}
//周期集信息
//if (ddl_CycleID.Value != "ALL")
//{
// CycleID = ddl_CycleID.Value;
//}
//实时指标信息
if (ddl_ECID.Value != "ALL")
{
ECID = ddl_ECID.Value;
}
//设备信息
if (ECTagDal.DeleteECTagForCondition(UnitID, SeqID, KpiID, ECID))
{
MessageBox.popupClientMessage(this.Page, "删除成功", "call();");
BindEC();
}
}
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();
}
}
/// <summary>
/// //设备信息
/// </summary>
void BindEC()
{
//查询条件
string UnitID = "";
string SeqID = "";
string KpiID = "";
string ECID = "";
//机组信息
if (ddl_UnitID.Value != "ALL")
{
UnitID = ddl_UnitID.Value;
}
//设备信息
if (ddl_SeqID.Value != "ALL")
{
SeqID = ddl_SeqID.Value;
}
//指标信息
if (ddl_KpiID.Value != "ALL")
{
KpiID = ddl_KpiID.Value;
}
//周期集信息
//if (ddl_CycleID.Value != "ALL")
//{
// CycleID = ddl_CycleID.Value;
//}
//实时指标信息
if (ddl_ECID.Value != "ALL")
{
ECID = ddl_ECID.Value;
}
//设备信息
DataTable dtTags = ECTagDal.GetSearchList(UnitID, SeqID, KpiID, ECID);
gvEC.DataSource = dtTags;
gvEC.DataBind();
}
protected void btnApply_Click(object sender, EventArgs e)
{
if (gvTable.Rows.Count <= 0)
{
return;
}
for (int i = 0; i < gvTable.Rows.Count; i++)
{
ECTagEntity csE = new ECTagEntity();
csE.ECID = gvTable.Rows[i]["ECID"].ToString();
csE.ECIndex = i + 1;
ECTagDal.Update(csE);
}
MessageBox.popupClientMessage(this.Page, "排序成功！", "call();");
}
void BindECs()
{
string UnitID = ddl_UnitID.SelectedValue;
if (UnitID.Equals(""))
{
return;
}
ddl_ECID.Items.Clear();
DataTable dt = ECTagDal.GetECByUnit(UnitID);
foreach (DataRow dr in dt.Rows)
{
ddl_ECID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
}
public void BindTextBox(string ECCode)
{
string[] strnt = ECTagDal.GetNameEngunit(ECCode).Split(new string[] { ",", ";" }, StringSplitOptions.RemoveEmptyEntries);
if (strnt.Length == 2)
{
ECName.Text = strnt[0];
KeyEngunit.Text = strnt[1];
}
else if (strnt.Length == 1)
{
ECName.Text = strnt[0];
KeyEngunit.Text = "";
}
else
{
ECName.Text = "";
KeyEngunit.Text = "";
}
}
//////////////////////////////////////////////////////////////////////////////
#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);
}
void BindScore(bool binit)
{
if (mEntity == null)
{
return;
}
if (binit)
{
if (mEntity.ECScoreExp != null && mEntity.ECScoreExp.Trim() != "")
{
dtScore = ECTagDal.GetScoreExp(mEntity.ECScoreExp.ToString());
}
}
gvScore.DataSource = dtScore;
gvScore.DataBind();
}
/// <summary>
/// 更新数据
/// </summary>
/// <returns></returns>
bool Update()
{
string ecid = ViewState["ecid"].ToString();
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ecid;
mEntity.ECIsSort = cbx_ECIsSort.Checked ? 1 : 0;
mEntity.ECType = int.Parse(ddl_ECType.SelectedValue);
mEntity.ECSort = int.Parse(ddl_ECSort.Value);
mEntity.ECScore = txt_ECScore.Value;
mEntity.ECExExp = txt_ECExExp.Value;
mEntity.ECExScore = txt_ECExScore.Value;
mEntity.ECModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
return(ECTagDal.Update(mEntity));
}
protected void cbx_ECIsSort_CheckedChanged(object sender, EventArgs e)
{
string ecid = ViewState["ecid"].ToString();
if (ecid == "")
{
btnApply.Enabled = false;
return;
}
else
{
btnApply.Enabled = true;
}
ECTagEntity ect = new ECTagEntity();
ect.ECID = ecid;
ect.ECIsSort = cbx_ECIsSort.Checked ? 1 : 0;
ECTagDal.Update(ect);
}
protected void gvEC_RowCommand(object sender, GridViewCommandEventArgs e)
{
string keyid = e.CommandArgument.ToString();
if (e.CommandName == "dataDelete")
{
if (ECTagDal.DeleteTag(keyid))
{
MessageBox.popupClientMessage(this.Page, "删除成功！", "call();");
BindEC();
}
else
{
MessageBox.popupClientMessage(this.Page, "删除错误！", "call();");
}
}
else if (e.CommandName == "dataView")
{
Response.Redirect("KPI_SubECTagConfig1.aspx?ecid=" + keyid);
}
else if (e.CommandName == "dataCopy")
{
//Response.Redirect("KPI_SubECTagConfig1.aspx?ecid=" + keyid);
//string newid = PageControl.GetGuid();
if (ECTagDal.CopyECTag(keyid))
{
MessageBox.popupClientMessage(this.Page, "复制成功，请修改相关配置！", "call();");
BindEC();
}
else
{
MessageBox.popupClientMessage(this.Page, "复制错误, Copy_xxx的名称已存在！", "call();");
}
}
}
