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;
}
}