예제 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (this.Request.QueryString["REID"] != null)
            {
                RegularExpressionDtls reDtls = new RegularExpressionDtls();
                reDtls.RetrieveAll();

                //删除现有的逻辑.
                BP.Sys.MapExts exts = new BP.Sys.MapExts();
                exts.Delete(MapExtAttr.AttrOfOper, this.KeyOfEn,
                            MapExtAttr.ExtType, BP.Sys.MapExtXmlList.RegularExpression);

                // 开始装载.
                foreach (RegularExpressionDtl dtl in reDtls)
                {
                    if (dtl.ItemNo != this.Request.QueryString["REID"])
                    {
                        continue;
                    }

                    BP.Sys.MapExt ext = new BP.Sys.MapExt();
                    ext.MyPK       = this.FK_MapData + "_" + this.KeyOfEn + "_" + MapExtXmlList.RegularExpression + "_" + dtl.ForEvent;
                    ext.FK_MapData = this.FK_MapData;
                    ext.AttrOfOper = this.KeyOfEn;
                    ext.Doc        = dtl.Exp;                         //表达公式.
                    ext.Tag        = dtl.ForEvent;                    //时间.
                    ext.Tag1       = dtl.Msg;                         //消息
                    ext.ExtType    = MapExtXmlList.RegularExpression; // 表达公式 .
                    ext.Insert();
                }
                //this.WinClose("1"); //关闭并返回一个值。
                return;
            }

            RegularExpressions res = new RegularExpressions();

            res.RetrieveAll();

            this.Pub1.AddH3("事件模版-点击名称选用它.");
            this.Pub1.AddHR();

            this.Pub1.AddUL();
            foreach (RegularExpression item in res)
            {
                this.Pub1.AddLi("<a href=\"javascript:DoIt('" + this.FK_MapData + "','" + this.KeyOfEn
                                + "','" + this.ForCtrl + "','" + item.No + "','" + item.Name
                                + "');\" >" + item.Name + "</a> - " + item.Note);
            }
            this.Pub1.AddULEnd();
        }
예제 #2
0
        /// <summary>
        /// 删除垃圾数据.
        /// </summary>
        public static void DeleteDB()
        {
            MapExts exts = new MapExts();

            exts.RetrieveAll();
            return;

            foreach (MapExt ext in exts)
            {
                if (ext.ExtType == MapExtXmlList.ActiveDDL)
                {
                    if (ext.AttrOfOper.Trim().Length == 0)
                    {
                        ext.Delete();
                        continue;
                    }

                    MapAttr attr = new MapAttr();
                    attr.MyPK = ext.AttrOfOper;
                    if (attr.IsExits == true)
                    {
                        ext.AttrOfOper = attr.KeyOfEn;
                        ext.Delete();

                        ext.MyPK = ext.ExtType + "_" + ext.FK_MapData + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive;
                        ext.Save();
                    }

                    if (ext.MyPK == ext.ExtType + "_" + ext.FK_MapData + "_" + ext.FK_MapData + "_" + ext.AttrOfOper)
                    {
                        ext.Delete(); //直接删除.

                        ext.MyPK = ext.ExtType + "_" + ext.FK_MapData + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive;
                        ext.Save();
                        continue;
                    }

                    if (ext.MyPK == ext.ExtType + "_" + ext.FK_MapData + "_" + ext.FK_MapData + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive)
                    {
                        ext.Delete(); //直接删除.
                        ext.MyPK = ext.ExtType + "_" + ext.FK_MapData + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive;
                        ext.Save();
                        continue;
                    }

                    if (ext.MyPK == ext.ExtType + "_" + ext.FK_MapData + "_" + ext.FK_MapData + "_" + ext.AttrsOfActive + "_" + ext.AttrOfOper)
                    {
                        ext.Delete(); //直接删除.
                        ext.MyPK = ext.ExtType + "_" + ext.FK_MapData + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive;
                        ext.Save();
                        continue;
                    }


                    //三个主键的情况.
                    if (ext.MyPK == ext.ExtType + "_" + ext.FK_MapData + "_" + ext.AttrOfOper)
                    {
                        ext.Delete();
                        ext.MyPK = ext.ExtType + "_" + ext.FK_MapData + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive;
                        ext.Save();
                        continue;
                    }

                    //三个主键的情况.
                    if (ext.MyPK == ext.ExtType + "_" + ext.FK_MapData + "_" + ext.AttrsOfActive)
                    {
                        ext.Delete();
                        ext.MyPK = ext.ExtType + "_" + ext.FK_MapData + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive;
                        ext.Save();
                        continue;
                    }
                }
            }
        }
예제 #3
0
        public void btn_SaveReTemplete_Click(object sender, EventArgs e)
        {
            ListBox lb = this.Pub1.FindControl("LBReTemplete") as ListBox;

            if (lb == null && lb.SelectedItem.Value == null)
            {
                return;
            }

            string newMyPk = "";
            RegularExpressionDtls reDtls = new RegularExpressionDtls();

            reDtls.RetrieveAll();

            //删除现有的逻辑.
            BP.Sys.MapExts exts = new BP.Sys.MapExts();


            string[] strs = this.RefNo.Split(',');
            foreach (string field in strs)
            {
                if (string.IsNullOrEmpty(field) == true)
                {
                    continue;
                }

                exts.Delete(MapExtAttr.FK_MapData, this.FK_MapData, MapExtAttr.AttrOfOper, field, MapExtAttr.ExtType, BP.Sys.MapExtXmlList.RegularExpression);
            }


            // 开始装载.
            foreach (RegularExpressionDtl dtl in reDtls)
            {
                if (dtl.ItemNo != lb.SelectedItem.Value)
                {
                    continue;
                }

                foreach (string field in strs)
                {
                    if (string.IsNullOrEmpty(field) == true)
                    {
                        continue;
                    }

                    BP.Sys.MapExt ext = new BP.Sys.MapExt();
                    ext.MyPK       = this.FK_MapData + "_" + field + "_" + MapExtXmlList.RegularExpression + "_" + dtl.ForEvent;
                    ext.FK_MapData = this.FK_MapData;
                    ext.AttrOfOper = field;
                    ext.Doc        = dtl.Exp;                         //表达公式.
                    ext.Tag        = dtl.ForEvent;                    //时间.
                    ext.Tag1       = dtl.Msg;                         //消息
                    ext.ExtType    = MapExtXmlList.RegularExpression; // 表达公式 .
                    ext.Insert();
                    newMyPk = ext.MyPK;
                }
            }

            if (this.RefNo != null && this.RefNo.Contains(","))
            {
                this.WinCloseWithMsg("已经保存成功.");
                return;
            }
            else
            {
                this.Response.Redirect("RegularExpression.aspx?FK_MapData=" + this.FK_MapData + "&RefNo=" + this.RefNo + "&ExtType=" + this.ExtType + "&MyPK=" + newMyPk + "&OperAttrKey=" + this.OperAttrKey + "&DoType=New", true);
            }
        }