void btn_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(Pub1.GetTBByID("TB_SelectStatement").Text))
{
EasyUiHelper.AddEasyUiMessagerAndBack(this, "查询语句不能为空", "错误", "error");
return;
}
string url = "SFGuide.aspx?Step=3&FK_SFDBSrc=" + this.FK_SFDBSrc + "&DDL_ColValue=" + this.Pub1.GetDDLByID("DDL_ColValue").SelectedItemStringVal;
url += "&LB_Table=" + this.Pub1.GetLBByID("LB_Table").SelectedItemStringVal;
url += "&DDL_ColText=" + this.Pub1.GetDDLByID("DDL_ColText").SelectedItemStringVal;
url += "&DDL_ColParentNo=" + this.Pub1.GetDDLByID("DDL_ColParentNo").SelectedItemStringVal;
url += "&TB_SelectStatement=" + Uri.EscapeDataString(Pub1.GetTBByID("TB_SelectStatement").Text);
url += "&DDL_SFTableType=" + Pub1.GetDDLByID("DDL_SFTableType").SelectedItemStringVal;
Response.Redirect(url, true);
}
void btn_Create_Click(object sender, EventArgs e)
{
SFTable table = new SFTable();
table = this.Pub1.Copy(table) as SFTable;
table.FK_SFDBSrc = Request.QueryString["FK_SFDBSrc"];
table.SrcTable = this.Request.QueryString["LB_Table"];
table.FK_Val = "FK_" + table.SrcTable;
table.ColumnText = this.Request.QueryString["DDL_ColText"];
table.ColumnValue = this.Request.QueryString["DDL_ColValue"];
table.ParentValue = this.Request.QueryString["DDL_ColParentNo"];
table.SelectStatement = Uri.UnescapeDataString(Request.QueryString["TB_SelectStatement"]);
table.SFTableType = int.Parse(Request.QueryString["DDL_SFTableType"]);
if (table.SFTableType == 1)
{
table.IsTree = true;
}
else
{
table.IsTree = false;
table.ParentValue = null;
}
if (BP.DA.DBAccess.IsExitsObject(table.No))
{
EasyUiHelper.AddEasyUiMessagerAndBack(this, "@对象（" + table.No + "）已经存在.", "错误", "error");
return;
}
var sql = "CREATE VIEW " + table.No + ""
+ " AS "
+ table.SelectStatement;
BP.DA.DBAccess.RunSQL(sql);
table.Save();
EasyUiHelper.AddEasyUiMessagerAndGo(this, "创建成功！查看数据……", "提示", "info", "../../MapDef/SFTableEditData.aspx?RefNo=" + table.No);
}
void btn_Create_WebService_Click(object sender, EventArgs e)
{
SFTable table = new SFTable();
table = this.Pub1.Copy(table) as SFTable;
table.SrcType = SrcType.WebServices; //9表示WebService数据源表类型，added by liuxc,2015-9-12
if (string.IsNullOrWhiteSpace(table.No) || string.IsNullOrWhiteSpace(table.Name) || string.IsNullOrWhiteSpace(table.TableDesc) || string.IsNullOrWhiteSpace(table.SrcTable))
{
EasyUiHelper.AddEasyUiMessagerAndBack(this, "@编号、名称、Url、接口名称必须填写.", "错误", "error");
return;
}
if (table.IsExit(SFTableAttr.No, table.No))
{
EasyUiHelper.AddEasyUiMessagerAndBack(this, "@对象（" + table.No + "）已经存在.", "错误", "error");
return;
}
table.Save();
EasyUiHelper.AddEasyUiMessagerAndGo(this, "创建成功！", "提示", "info", "SFGuide.aspx?Step=1");
}
void btn_Save_Click(object sender, EventArgs e)
{
//Button btn = sender as Button;
var btn = sender as LinkBtn;
if (btn.ID == NamesOfBtn.Delete)
{
DBAccess.RunSQL("DELETE FROM WF_Cond WHERE ToNodeID=" + this.ToNodeID + " AND DataFrom=" + (int)ConnDataFrom.Form);
this.Response.Redirect(this.Request.RawUrl, true);
return;
}
if (this.GetOperVal == "" || this.GetOperVal == null)
{
this.Alert("您没有设置条件，请在值文本框中输入值。");
return;
}
DBAccess.RunSQL("DELETE FROM WF_Cond WHERE (" + CondAttr.NodeID + "=" + this.FK_Node + " AND ToNodeID=" + this.ToNodeID + ") AND DataFrom!=" + (int)ConnDataFrom.Form);
Cond cond = new Cond();
cond.HisDataFrom = ConnDataFrom.Form;
cond.NodeID = this.FK_MainNode;
cond.ToNodeID = this.FK_MainNode;
cond.FK_Attr = this.FK_Attr;
cond.FK_Node = this.DDL_Node.SelectedItemIntVal;
cond.FK_Operator = this.DDL_Oper.SelectedItemStringVal;
cond.OperatorValue = this.GetOperVal;
cond.OperatorValueT = this.GetOperValText;
cond.FK_Flow = this.FK_Flow;
cond.HisCondType = this.HisCondType;
if (btn.ID == "Btn_SaveAnd")
{
cond.CondOrAnd = CondOrAnd.ByAnd;
}
else
{
cond.CondOrAnd = CondOrAnd.ByOr;
}
#region 方向条件，全部更新.
Conds conds = new Conds();
QueryObject qo = new QueryObject(conds);
qo.AddWhere(CondAttr.NodeID, this.FK_MainNode);
qo.addAnd();
qo.AddWhere(CondAttr.DataFrom, (int)ConnDataFrom.Form);
qo.addAnd();
qo.AddWhere(CondAttr.CondType, (int)this.HisCondType);
if (this.ToNodeID != 0)
{
qo.addAnd();
qo.AddWhere(CondAttr.ToNodeID, this.ToNodeID);
}
int num = qo.DoQuery();
foreach (Cond item in conds)
{
item.CondOrAnd = cond.CondOrAnd;
item.Update();
}
#endregion
/* 执行同步*/
string sqls = "UPDATE WF_Node SET IsCCFlow=0";
sqls += "@UPDATE WF_Node SET IsCCFlow=1 WHERE NodeID IN (SELECT NODEID FROM WF_Cond a WHERE a.NodeID= NodeID AND CondType=1 )";
BP.DA.DBAccess.RunSQLs(sqls);
string sql = "UPDATE WF_Cond SET DataFrom=" + (int)ConnDataFrom.Form + " WHERE NodeID=" + cond.NodeID + " AND FK_Node=" + cond.FK_Node + " AND ToNodeID=" + this.ToNodeID;
switch (this.HisCondType)
{
case CondType.Flow:
case CondType.Node:
// case CondType.FLRole:
cond.MyPK = BP.DA.DBAccess.GenerOID().ToString(); //cond.NodeID + "_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.Insert();
BP.DA.DBAccess.RunSQL(sql);
this.Response.Redirect("Cond.aspx?MyPK=" + cond.MyPK + "&FK_Flow=" + cond.FK_Flow + "&FK_Node=" + cond.FK_Node + "&FK_MainNode=" + cond.NodeID + "&CondType=" + (int)cond.HisCondType + "&FK_Attr=" + cond.FK_Attr + "&ToNodeID=" + this.Request.QueryString["ToNodeID"], true);
break;
case CondType.Dir:
// cond.MyPK = cond.NodeID +"_"+ this.Request.QueryString["ToNodeID"]+"_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.MyPK = BP.DA.DBAccess.GenerOID().ToString(); //cond.NodeID + "_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.ToNodeID = this.ToNodeID;
cond.Insert();
BP.DA.DBAccess.RunSQL(sql);
this.Response.Redirect("Cond.aspx?MyPK=" + cond.MyPK + "&FK_Flow=" + cond.FK_Flow + "&FK_Node=" + cond.FK_Node + "&FK_MainNode=" + cond.NodeID + "&CondType=" + (int)cond.HisCondType + "&FK_Attr=" + cond.FK_Attr + "&ToNodeID=" + this.Request.QueryString["ToNodeID"], true);
break;
default:
throw new Exception("未设计的情况。");
}
EasyUiHelper.AddEasyUiMessager(this, "保存成功！");
}
void btn_Create_Local_Click(object sender, EventArgs e)
{
SFTable table = new SFTable();
table = this.Pub1.Copy(table) as SFTable;
table.FK_SFDBSrc = Request.QueryString["FK_SFDBSrc"];
table.SrcTable = table.No;
table.ColumnText = "Name";
table.ColumnValue = "No";
table.IsTree = false;
if (BP.DA.DBAccess.IsExitsObject(table.No))
{
//判断已经存在的表是否符合NoName规则，如果符合，则自动加入到SFTable中
var src = new SFDBSrc(this.FK_SFDBSrc);
var columns = src.GetColumns(table.No);
var cols = new List <string>();
foreach (DataRow dr in columns.Rows)
{
cols.Add(dr["name"].ToString());
}
var regColValue = cols.FirstOrDefault(o => regs[0].Contains(o.ToLower()));
var regColText = cols.FirstOrDefault(o => regs[1].Contains(o.ToLower()));
var regColParentNo = cols.FirstOrDefault(o => regs[2].Contains(o.ToLower()));
if (regColValue != null && regColText != null && regColParentNo != null)
{
table.SFTableType = 1;
table.IsTree = true;
table.ColumnValue = regColValue;
table.ColumnText = regColText;
table.ParentValue = regColParentNo;
table.FK_SFDBSrc = "local";
table.Save();
EasyUiHelper.AddEasyUiMessagerAndGo(this, "您所创建的“" + table.No + "” 名称的字典表，本地库已经存在，已成功注册！编辑数据……", "提示", "info", "../../MapDef/SFTableEditData.aspx?RefNo=" + table.No);
}
else if (regColValue != null && regColText != null)
{
table.SFTableType = 0;
table.IsTree = false;
table.ColumnValue = regColValue;
table.ColumnText = regColText;
table.ParentValue = null;
table.FK_SFDBSrc = "local";
table.Save();
EasyUiHelper.AddEasyUiMessagerAndGo(this, "您所创建的“" + table.No + "” 名称的字典表，本地库已经存在，已成功注册！编辑数据……", "提示", "info", "../../MapDef/SFTableEditData.aspx?RefNo=" + table.No);
}
else
{
EasyUiHelper.AddEasyUiMessagerAndBack(this, "@对象（" + table.No + "）已经存在.", "错误", "error");
}
return;
}
var sql = new StringBuilder();
sql.AppendLine(string.Format("CREATE TABLE dbo.{0}", table.No));
sql.AppendLine("(");
sql.AppendLine("No NVARCHAR(50) NOT NULL PRIMARY KEY,");
sql.AppendLine("Name NVARCHAR(100) NULL");
sql.AppendLine(") ");
BP.DA.DBAccess.RunSQL(sql.ToString());
sql.Clear();
sql.Append("INSERT INTO [dbo].[{0}] ([No], [Name]) VALUES ('0{1}', 'Item{1}')");
for (var i = 1; i < 4; i++)
{
BP.DA.DBAccess.RunSQL(string.Format(sql.ToString(), table.No, i));
}
sql.Clear();
sql.AppendFormat(
"EXECUTE sp_addextendedproperty N'MS_Description', N'{0}', N'SCHEMA', N'dbo', N'TABLE', N'{1}', NULL, NULL",
table.Name, table.No);
BP.DA.DBAccess.RunSQL(sql.ToString());
table.Save();
EasyUiHelper.AddEasyUiMessagerAndGo(this, "创建成功！编辑数据……", "提示", "info", "../../MapDef/SFTableEditData.aspx?RefNo=" + table.No);
}
