示例#1
0
        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>
        /// <param name="msg"></param>
        /// <returns></returns>
        bool CheckVal(out string msg)
        {
            bool flag = false;

            msg = "";

            string sID = ViewState["ecid"].ToString();

            txt_ECCode.Value      = txt_ECCode.Value.Trim();
            txt_ECName.Value      = txt_ECName.Value.Trim();
            txt_ECIndex.Value     = txt_ECIndex.Value.Trim();
            txt_ECMaxValue.Value  = txt_ECMaxValue.Value.Trim();
            txt_ECMinValue.Value  = txt_ECMaxValue.Value.Trim();
            txt_ECWeight.Value    = txt_ECWeight.Value.Trim();
            txt_ECDenom.Value     = txt_ECDenom.Value.Trim();
            txt_ECCalcClass.Value = txt_ECCalcClass.Value.Trim();

            /////////////////////////////////////////////////////////////////////
            //
            if (txt_ECCode.Value.Equals(""))
            {
                msg += "代码不能为空!\r\n";
                flag = true;
                return(flag);
            }
            else
            {
                if (!Regex.IsMatch(txt_ECCode.Value, "[A-Za-z0-9_]*$"))
                {
                    msg += "代码只能由数字、字母和下划线组成!\r\n";
                    flag = true;
                    return(flag);
                }

                //在SQL表中是否存在
                if (ECTagDal.CodeExist(txt_ECCode.Value, sID) ||
                    ALLDal.CodeExist(txt_ECCode.Value, sID))
                {
                    msg += "命名已存在,请检查!\r\n";
                    flag = true;
                    return(flag);
                }
            }

            if (txt_ECName.Value.Equals(""))
            {
                msg += "名称不能为空!\r\n";
                flag = true;
                return(flag);
            }

            if (txt_ECIndex.Value.Equals(""))
            {
                msg += "序号不能为空!\r\n";
                flag = true;
                return(flag);
            }
            else
            {
                if (!Regex.IsMatch(txt_ECIndex.Value, "[0-9]*$"))
                {
                    msg += "序号只能由数字组成!\r\n";
                    flag = true;
                    return(flag);
                }
            }

            if (!txt_ECMaxValue.Value.Equals(""))
            {
                if (!Regex.IsMatch(txt_ECMaxValue.Value, @"^\d*[.]?\d*$"))
                {
                    msg += "最值只能为数字组成!\r\n";
                }
            }

            if (!txt_ECMinValue.Value.Equals(""))
            {
                if (!Regex.IsMatch(txt_ECMinValue.Value, @"^\d*[.]?\d*$"))
                {
                    msg += "最值只能为数字组成!\r\n";
                }
            }

            if (txt_ECWeight.Value.Equals(""))
            {
                msg += "权重不能为空!\r\n";
                flag = true;
                return(flag);
            }
            else
            {
                if (!Regex.IsMatch(txt_ECWeight.Value, @"^\d*[.]?\d*$"))
                {
                    msg += "权重只能为数字组成!\r\n";
                }
            }

            if (txt_ECDenom.Value.Equals(""))
            {
                msg += "分母不能为空!\r\n";
                flag = true;
                return(flag);
            }
            else
            {
                double dout = 0;
                if (!double.TryParse(txt_ECDenom.Value, out dout) || dout == 0)
                {
                    msg += "分母格式不正确且不能为0!\r\n";
                }
            }

            if (txt_ECCalcClass.Value.Equals(""))
            {
                msg += "计算等级不能为空!\r\n";
                flag = true;
                return(flag);
            }
            else
            {
                if (!Regex.IsMatch(txt_ECCalcClass.Value, "[0-9]*$"))
                {
                    msg += "计算等级只能由数字组成!\r\n";
                    flag = true;
                    return(flag);
                }
            }

            return(flag);
        }
示例#3
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);
            }
        }