ccflow 删除Dtl&数据合并

来源：互联网发布：mysql和postgresql 编辑：程序博客网时间：2024/06/05 09:58

D:\CCFLOW20140610\trunk\Components\BP.En30\Sys\MapData\MapData.cs

//删除Dtl

            foreach (DataRow dr in Sys_MapDtl.Rows)
            {
                try
                {
                    DBAccess.RunSQL("DROP TABLE " + dr["No"].ToString());
                }
                catch
                {
                }
            }
            //remove

            //Sys.MapDtls dtls = new BP.Sys.MapDtls(this.No);
            //foreach (MapDtl dtl in dtls)
            //{
            //    try
            //    {
            //        DBAccess.RunSQL("DROP TABLE " + dtl.PTable);
            //    }
            //    catch
            //    {
            //    }
            //    dtl.Delete();
            //}

数据合并

D:\CCFLOW20140610\trunk\CCFormDesigner\Ctrl\BPDtl.cs

#region 处理选中.

     //add
        private string _No = null;
        public string No
        {
            get
            {
                return _No;
            }
            set
            { _No = value; }
        }

public BPDtl(string name)
        {
            Adjust adjust = new Adjust();
            adjust.Bind(this);
            this.BindDrag();
            this.Name = name;
            this.Foreground = new SolidColorBrush(Colors.Green);
            this.FontStyle = FontStyles.Normal;
            this.Width = 400;
            this.Height = 200;
            this.BorderThickness = new Thickness(5);
            //this.LoadDtl();//remove
            this.SizeChanged += new SizeChangedEventHandler(BPDtl_SizeChanged);
        }

public void LoadDtl()
        {
            FF.CCFormSoapClient da = Glo.GetCCFormSoapClientServiceInstance();
            //da.RunSQLReturnTableAsync("SELECT * FROM Sys_MapAttr WHERE FK_MapData='" + this.Name + "'");
            da.RunSQLReturnTableAsync("SELECT * FROM Sys_MapAttr WHERE FK_MapData='" + this.No + "'");
            da.RunSQLReturnTableCompleted += new EventHandler<FF.RunSQLReturnTableCompletedEventArgs>(da_RunSQLReturnTableCompleted);
        }

void da_New_DoTypeCompleted(object sender, FF.DoTypeCompletedEventArgs e)
        {
            if (e.Result != null)
            {
                MessageBox.Show(e.Result, "提示", MessageBoxButton.OK);
                return;
            }

            this.LoadDtl();
            string url = Glo.BPMHost + "/WF/MapDef/MapDefDtlFreeFrm.aspx?DoType=Edit&FK_MapData=" + Glo.FK_MapData + "&FK_MapDtl=" + this.No + Glo.TimeKey;
            //string url = Glo.BPMHost + "/WF/MapDef/MapDefDtlFreeFrm.aspx?DoType=Edit&FK_MapData=" + Glo.FK_MapData + "&FK_MapDtl=" + this.Name + Glo.TimeKey;
            Glo.WinOpen(url, 700, 1100);
        }

D:\CCFLOW20140610\trunk\CCFormDesigner\MainPage.xaml.cs

public MainPage()
{

//add

          FF.CCFormSoapClient ws = Glo.GetCCFormSoapClientServiceInstance();
            ws.RunSQLReturnStringAsync("select DataStoreModel from WF_Flow where No='" + Glo.FK_Flow + "'");
            ws.RunSQLReturnStringCompleted += new EventHandler<FF.RunSQLReturnStringCompletedEventArgs>(ws_RunSQLReturnStringCompleted);

}

        void ws_RunSQLReturnStringCompleted(object sender, FF.RunSQLReturnStringCompletedEventArgs e)
        {
            _FK_MapDataFlow = e.Result;

        }

private string _FK_MapDataFlow = null;
        public string FK_MapDataFlow()
        {

            if ("1" == _FK_MapDataFlow)
            {
                return "ND" + Glo.FK_Flow;
            }
            else
            {
                return Glo.FK_MapData;
            }

}

case "Sys_MapDtl":
                            foreach (DataRow dr in dt.Rows)
                            {
                                BPDtl dtl = new BPDtl(dr["No"]);
                                dtl.No = dr["No"].ToString();//add

dtl.LoadDtl();//add

……

}

case ToolBox.Dtl:
                    int num = 1;
                    foreach (UIElement ctl in this.workSpace.Children)
                    {
                        BPDtl dtl = ctl as BPDtl;
                        if (dtl == null)
                            continue;
                        num++;
                    }

                    BPDtl newDtl = new BPDtl();
                    newDtl.Name = this.FK_MapDataFlow() + "Dtl" + num;
                    newDtl.No = Glo.FK_MapData + "Dtl" + num;//add

break;

private void Save_Click(object sender, RoutedEventArgs e)
{

BPDtl dtlCtl = ctl as BPDtl;
                if (dtlCtl != null)
                {
                    DataRow mapDtl = dtlDT.NewRow();
                    mapDtl["No"] = dtlCtl.No;//edit by haisheng
                    //mapDtl["No"] = dtlCtl.Name;
                    mapDtl["FK_MapData"] = Glo.FK_MapData;

}

0 0