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