Example #1
0
        protected void btnAddCycle_Click(object sender, EventArgs e)
        {
            int index = CycleDal.CycleIDCounts();

            string sID = PageControl.GetGuid();

            CycleEntity ote = new CycleEntity();

            ote.CycleID         = sID;
            ote.CycleName       = "TX";
            ote.CycleDesc       = "10分钟";
            ote.CycleValue      = 10;
            ote.CycleNote       = "分钟计算周期";
            ote.CycleCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
            ote.CycleModifyTime = ote.CycleCreateTime;

            if (CycleDal.Insert(ote))
            {
                //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();");
            }
            else
            {
                MessageBox.popupClientMessage(this.Page, "添加错误!", "call();");
            }

            gvCycle.EditIndex = index;

            BindGrid();
        }
Example #2
0
        void BindGrid()
        {
            DataTable dt = CycleDal.GetSearchList();

            gvCycle.DataSource = dt;

            gvCycle.DataBind();
        }
Example #3
0
        protected void gvCycle_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            string Cycleid = e.CommandArgument.ToString();

            if (e.CommandName == "dataDelete")
            {
                if (CycleDal.DeleteCycle(Cycleid))
                {
                    MessageBox.popupClientMessage(this.Page, "删除成功!", "call();");
                    BindGrid();
                }
                else
                {
                    MessageBox.popupClientMessage(this.Page, "删除错误!", "call();");
                }
            }
        }
Example #4
0
        //////////////////////////////////////////////////////////////////////////////
        #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 Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                btnApply.Attributes.Add("onclick", "setDivPos('Lay1');Lay1.style.visibility='';progress_update();");

                //机组信息
                DataTable dt = KPI_UnitDal.GetUnits("");
                foreach (DataRow dr in dt.Rows)
                {
                    ddl_UnitID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
                }

                //设备信息
                dt = KPI_SeqDal.GetSeqs();
                foreach (DataRow dr in dt.Rows)
                {
                    ddl_SeqID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
                }

                //指标信息
                dt = KpiDal.GetKpis();
                foreach (DataRow dr in dt.Rows)
                {
                    ddl_KpiID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
                }

                //单位信息
                dt = EngunitDal.GetEngunits();
                foreach (DataRow dr in dt.Rows)
                {
                    ddl_EngunitID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
                }

                //周期信息
                dt = CycleDal.GetCycles();
                foreach (DataRow dr in dt.Rows)
                {
                    ddl_CycleID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
                }

                //网页集信息
                //信息在KPI_Constant表中
                dt = KPI_ConstantDal.GetECWebs();
                foreach (DataRow dr in dt.Rows)
                {
                    ddl_ECWeb.Items.Add(new ListItem(dr["Name"].ToString(), dr["Value"].ToString()));
                }

                //判断是否新建或编辑
                if (Request.QueryString["ecid"] != null)
                {
                    ViewState["ecid"] = Request.QueryString["ecid"].ToString();

                    BindValues();
                }
                else
                {
                    //添加
                    ViewState["ecid"] = "";

                    //
                    ddl_ECIsValid.Value   = "1";
                    ddl_ECIsCalc.Value    = "1";
                    ddl_ECIsDisplay.Value = "1";
                    ddl_ECIsTotal.Value   = "1";

                    SetECCodeAndName();

                    txt_ECIndex.Value     = "100";
                    txt_ECWeight.Value    = "1";
                    txt_ECDenom.Value     = "1";
                    txt_ECCalcClass.Value = "1";
                }

                btnApply.Visible = true;
            }
        }
Example #6
0
        protected void gvCycle_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string keyid = ((HtmlInputHidden)(gvCycle.Rows[e.RowIndex].Cells[0].FindControl("Cycleid"))).Value;

            string eName  = ((TextBox)(gvCycle.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim().ToUpper();
            string eDesc  = ((TextBox)(gvCycle.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
            string eValue = ((TextBox)(gvCycle.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
            string eNote  = ((TextBox)(gvCycle.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim();

            string msg = "";

            if (eName == "")
            {
                msg += "名称不能为空!\r\n";
            }

            if (!Regex.IsMatch(eValue, "^[0-9]+$"))
            {
                msg += "周期只能为数字!\r\n";
            }

            if ((int.Parse(eValue) <= 60 && 60 % int.Parse(eValue) != 0) ||
                (int.Parse(eValue) > 60 && int.Parse(eValue) % 60 != 0))
            {
                msg += "周期只能为分钟的倍数!\r\n";
            }

            if ((eName != "TN" || eName != "TD") && double.Parse(eValue) == 0)
            {
                msg += "除TN,TD外,计算周期不能为0";
            }

            if (msg != "")
            {
                MessageBox.popupClientMessage(this.Page, msg);
                return;
            }

            if (CycleDal.CycleNameExists(eName, keyid))
            {
                MessageBox.popupClientMessage(this.Page, "该周期已存在!", "call();");
                return;
            }


            CycleEntity mEntity = new CycleEntity();

            mEntity.CycleID    = keyid;
            mEntity.CycleName  = eName;
            mEntity.CycleDesc  = eDesc;
            mEntity.CycleValue = int.Parse(eValue);
            mEntity.CycleNote  = eNote;

            //mEntity.CycleCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
            mEntity.CycleModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");

            if (!CycleDal.Update(mEntity))
            {
                MessageBox.popupClientMessage(this.Page, "编辑错误!", "call();");
            }
            else
            {
                MessageBox.popupClientMessage(this.Page, "编辑成功!", "call();");

                gvCycle.EditIndex = -1;

                BindGrid();
            }
        }
Example #7
0
        protected bool ImportFromExcelToModify(DataSet ds)
        {
            string strError = "";

            try
            {
                System.Data.DataTable dt = ds.Tables[0];

                int nAll     = dt.Rows.Count;
                int nModify  = 0;
                int nNoExist = 0;

                foreach (System.Data.DataRow dr in dt.Rows)
                {
                    if (dr["SelectX"].ToString().ToLower() == "x")
                    {
                        string ECCode = dr["ECCode"].ToString().Trim();
                        strError = ECCode;

                        //判断是否存在
                        if (!ECTagDal.CodeExist(ECCode, ""))
                        {
                            //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();");
                            nNoExist += 1;
                            continue;
                        }

                        //main tag
                        string keyid = ECTagDal.GetECIDByCode(ECCode);


                        ECTagEntity mEntity = new ECTagEntity();

                        mEntity.ECID = keyid;
                        string UnitName = dr["UnitName"].ToString().Trim();
                        mEntity.UnitID = KPI_UnitDal.GetUnitID(UnitName);
                        string SeqName = dr["SeqName"].ToString().Trim();
                        mEntity.SeqID = KPI_SeqDal.GetSeqID(SeqName);
                        string KpiName = dr["KpiName"].ToString().Trim();
                        mEntity.KpiID = KpiDal.GetKpiID(KpiName);
                        string EngunitName = dr["EngunitName"].ToString().Trim();
                        mEntity.EngunitID = EngunitDal.GetEngunitID(EngunitName);
                        string CycleName = dr["CycleName"].ToString().Trim();
                        mEntity.CycleID = CycleDal.GetCycleID(CycleName);

                        mEntity.ECCode    = dr["ECCode"].ToString().Trim();
                        mEntity.ECName    = dr["ECName"].ToString().Trim();
                        mEntity.ECDesc    = dr["ECDesc"].ToString().Trim();
                        mEntity.ECIndex   = int.Parse(dr["ECIndex"].ToString().Trim());
                        mEntity.ECWeb     = dr["ECWeb"].ToString().Trim();
                        mEntity.ECIsValid = int.Parse(dr["ECIsValid"].ToString().Trim());

                        mEntity.ECIsCalc    = int.Parse(dr["ECIsCalc"].ToString().Trim());
                        mEntity.ECIsAsses   = int.Parse(dr["ECIsAsses"].ToString().Trim());
                        mEntity.ECIsZero    = int.Parse(dr["ECIsZero"].ToString().Trim());
                        mEntity.ECIsDisplay = int.Parse(dr["ECIsDisplay"].ToString().Trim());
                        mEntity.ECIsTotal   = int.Parse(dr["ECIsTotal"].ToString().Trim());
                        mEntity.ECDesign    = dr["ECDesign"].ToString().Trim();

                        mEntity.ECOptimal = dr["ECOptimal"].ToString().Trim();
                        if (dr["ECMaxValue"].ToString().Trim() != "")
                        {
                            mEntity.ECMaxValue = decimal.Parse(dr["ECMaxValue"].ToString().Trim());
                        }
                        if (dr["ECMinValue"].ToString().Trim() != "")
                        {
                            mEntity.ECMinValue = decimal.Parse(dr["ECMinValue"].ToString().Trim());
                        }
                        mEntity.ECWeight    = decimal.Parse(dr["ECWeight"].ToString().Trim());
                        mEntity.ECCalcClass = int.Parse(dr["ECCalcClass"].ToString().Trim());
                        mEntity.ECFilterExp = dr["ECFilterExp"].ToString().Trim();

                        mEntity.ECCalcExp       = dr["ECCalcExp"].ToString().Trim();
                        mEntity.ECCalcDesc      = dr["ECCalcDesc"].ToString().Trim();
                        mEntity.ECIsSnapshot    = int.Parse(dr["ECIsSnapshot"].ToString().Trim());
                        mEntity.ECXLineType     = int.Parse(dr["ECXLineType"].ToString().Trim());
                        mEntity.ECXLineGetType  = int.Parse(dr["ECXLineGetType"].ToString().Trim());
                        mEntity.ECXLineXRealTag = dr["ECXLineXRealTag"].ToString().Trim();

                        mEntity.ECXLineYRealTag = dr["ECXLineYRealTag"].ToString().Trim();
                        mEntity.ECXLineZRealTag = dr["ECXLineZRealTag"].ToString().Trim();
                        mEntity.ECXLineXYZ      = dr["ECXLineXYZ"].ToString().Trim();
                        mEntity.ECScoreExp      = dr["ECScoreExp"].ToString().Trim();
                        mEntity.ECCurveGroup    = dr["ECCurveGroup"].ToString().Trim();
                        mEntity.ECIsSort        = int.Parse(dr["ECIsSort"].ToString().Trim());
                        mEntity.ECType          = int.Parse(dr["ECType"].ToString().Trim());

                        mEntity.ECSort    = int.Parse(dr["ECSort"].ToString().Trim());
                        mEntity.ECScore   = dr["ECScore"].ToString().Trim();
                        mEntity.ECExExp   = dr["ECExExp"].ToString().Trim();
                        mEntity.ECExScore = dr["ECExScore"].ToString().Trim();
                        mEntity.ECNote    = dr["ECNote"].ToString().Trim();

                        mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
                        mEntity.ECModifyTime = mEntity.ECCreateTime;


                        ECTagDal.Update(mEntity);

                        nModify += 1;
                    }
                }

                string strInfor = "标签点总数为:{0}个, 修改成功:{1}个,不存在标签点: {2}个。";
                strInfor = string.Format(strInfor, nAll, nModify, nNoExist);

                MessageBox.popupClientMessage(this.Page, strInfor, "call();");

                return(true);
            }
            catch (Exception ee)
            {
                //
                MessageBox.popupClientMessage(this.Page, strError + ": " + ee.Message, "call();");

                return(false);
            }
        }