//
// GET: /DBConnection/
public ActionResult Index()
{
string query1 = string.Format("&appid={0}&tabid={1}", Request.QueryString["appid"], Request.QueryString["tabid"]);
RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection();
if (!Request.Form["DeleteBut"].IsNullOrEmpty())
{
string deleteID = Request.Form["checkbox_app"];
System.Text.StringBuilder delxml = new System.Text.StringBuilder();
foreach (string id in deleteID.Split(','))
{
Guid gid;
if (id.IsGuid(out gid))
{
delxml.Append(bdbconn.Get(gid).Serialize());
bdbconn.Delete(gid);
}
}
bdbconn.ClearCache();
RoadFlow.Platform.Log.Add("删除了数据连接", delxml.ToString(), RoadFlow.Platform.Log.Types.流程相关);
}
var connList = bdbconn.GetAll();
ViewBag.Query1 = query1;
return(View(connList));
}
protected void Page_Load(object sender, EventArgs e)
{
string query1 = string.Format("&appid={0}&tabid={1}", Request.QueryString["appid"], Request.QueryString["tabid"]);
RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection();
if (IsPostBack)
{
if (!Request.Form["DeleteBut"].IsNullOrEmpty())
{
string deleteID = Request.Form["checkbox_app"];
System.Text.StringBuilder delxml = new System.Text.StringBuilder();
foreach (string id in deleteID.Split(','))
{
Guid gid;
if (id.IsGuid(out gid))
{
delxml.Append(bdbconn.Get(gid).Serialize());
bdbconn.Delete(gid);
}
}
bdbconn.ClearCache();
RoadFlow.Platform.Log.Add("删除了数据连接", delxml.ToString(), RoadFlow.Platform.Log.Types.流程相关);
}
}
ConnList = bdbconn.GetAll();
Query1 = query1;
}
protected void Page_Load(object sender, EventArgs e)
{
string editid = Request.QueryString["id"];
RoadFlow.Platform.DBConnection bdbConn = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = null;
if (editid.IsGuid())
{
dbconn = bdbConn.Get(editid.ToGuid());
}
bool isAdd = !editid.IsGuid();
string oldXML = string.Empty;
if (dbconn == null)
{
dbconn = new RoadFlow.Data.Model.DBConnection();
dbconn.ID = Guid.NewGuid();
}
else
{
oldXML = dbconn.Serialize();
}
if (IsPostBack)
{
string Name = Request.Form["Name"];
string LinkType = Request.Form["LinkType"];
string ConnStr = Request.Form["ConnStr"];
string Note = Request.Form["Note"];
dbconn.Name = Name.Trim();
dbconn.Type = LinkType;
dbconn.ConnectionString = ConnStr;
dbconn.Note = Note;
if (isAdd)
{
bdbConn.Add(dbconn);
RoadFlow.Platform.Log.Add("添加了应用程序库", dbconn.Serialize(), RoadFlow.Platform.Log.Types.角色应用);
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true);
}
else
{
bdbConn.Update(dbconn);
RoadFlow.Platform.Log.Add("修改了应用程序库", "", RoadFlow.Platform.Log.Types.角色应用, oldXML, dbconn.Serialize());
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('修改成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true);
}
bdbConn.ClearCache();
}
if (dbconn != null)
{
this.Name.Value = dbconn.Name;
this.ConnStr.Value = dbconn.ConnectionString;
this.Note.Value = dbconn.Note;
}
this.TypeOptions.Text = bdbConn.GetAllTypeOptions(dbconn.Type);
}
public ActionResult Edit(FormCollection collection)
{
string editid = Request.QueryString["id"];
RoadFlow.Platform.DBConnection bdbConn = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = null;
if (editid.IsGuid())
{
dbconn = bdbConn.Get(editid.Convert <Guid>());
}
bool isAdd = !editid.IsGuid();
string oldXML = string.Empty;
if (dbconn == null)
{
dbconn = new RoadFlow.Data.Model.DBConnection();
dbconn.ID = Guid.NewGuid();
}
else
{
oldXML = dbconn.Serialize();
}
if (collection != null)
{
string Name = Request.Form["Name"];
string LinkType = Request.Form["LinkType"];
string ConnStr = Request.Form["ConnStr"];
string Note = Request.Form["Note"];
dbconn.Name = Name.Trim();
dbconn.Type = LinkType;
dbconn.ConnectionString = ConnStr;
dbconn.Note = Note;
if (isAdd)
{
bdbConn.Add(dbconn);
RoadFlow.Platform.Log.Add("添加了应用程序库", dbconn.Serialize(), RoadFlow.Platform.Log.Types.角色应用);
ViewBag.Script = "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();";
}
else
{
bdbConn.Update(dbconn);
RoadFlow.Platform.Log.Add("修改了应用程序库", "", RoadFlow.Platform.Log.Types.角色应用, oldXML, dbconn.Serialize());
ViewBag.Script = "alert('修改成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();";
}
bdbConn.ClearCache();
}
ViewBag.TypeOptions = bdbConn.GetAllTypeOptions(dbconn.Type);
return(View(dbconn));
}
public ActionResult Edit(FormCollection collection)
{
string text = base.Request.QueryString["id"];
RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dBConnection2 = null;
if (MyExtensions.IsGuid(text))
{
dBConnection2 = dBConnection.Get(MyExtensions.ToGuid(text));
}
bool flag = !MyExtensions.IsGuid(text);
string oldXML = string.Empty;
if (dBConnection2 == null)
{
dBConnection2 = new RoadFlow.Data.Model.DBConnection();
dBConnection2.ID = Guid.NewGuid();
}
else
{
oldXML = MyExtensions.Serialize((object)dBConnection2);
}
if (collection != null)
{
string text2 = base.Request.Form["Name"];
string type = base.Request.Form["LinkType"];
string connectionString = base.Request.Form["ConnStr"];
string note = base.Request.Form["Note"];
dBConnection2.Name = text2.Trim();
dBConnection2.Type = type;
dBConnection2.ConnectionString = connectionString;
dBConnection2.Note = note;
if (flag)
{
dBConnection.Add(dBConnection2);
RoadFlow.Platform.Log.Add("添加了数据库连接", MyExtensions.Serialize((object)dBConnection2), RoadFlow.Platform.Log.Types.数据连接);
base.ViewBag.Script = "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();";
}
else
{
dBConnection.Update(dBConnection2);
RoadFlow.Platform.Log.Add("修改了数据库连接", "", RoadFlow.Platform.Log.Types.数据连接, oldXML, MyExtensions.Serialize((object)dBConnection2));
base.ViewBag.Script = "alert('修改成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();";
}
dBConnection.ClearCache();
}
base.ViewBag.TypeOptions = dBConnection.GetAllTypeOptions(dBConnection2.Type);
return(View(dBConnection2));
}
public string Delete()
{
RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection();
string text = base.Request.Form["ids"];
StringBuilder stringBuilder = new StringBuilder();
string[] array = text.Split(',');
for (int i = 0; i < array.Length; i++)
{
Guid id = default(Guid);
if (MyExtensions.IsGuid(array[i], out id))
{
stringBuilder.Append(MyExtensions.Serialize((object)dBConnection.Get(id)));
dBConnection.Delete(id);
}
}
dBConnection.ClearCache();
RoadFlow.Platform.Log.Add("删除了数据连接", stringBuilder.ToString(), RoadFlow.Platform.Log.Types.流程相关);
return("删除成功!");
}