public string Delete() { RoadFlow.Platform.AppLibrary appLibrary = new RoadFlow.Platform.AppLibrary(); string text = base.Request.Form["ids"]; StringBuilder stringBuilder = new StringBuilder(); using (TransactionScope transactionScope = new TransactionScope()) { string[] array = text.Split(','); for (int i = 0; i < array.Length; i++) { Guid id = default(Guid); if (MyExtensions.IsGuid(array[i], out id)) { RoadFlow.Data.Model.AppLibrary appLibrary2 = appLibrary.Get(id); if (appLibrary2 != null) { stringBuilder.Append(MyExtensions.Serialize(appLibrary2)); appLibrary.Delete(id); new RoadFlow.Platform.AppLibraryButtons1().DeleteByAppID(id); new RoadFlow.Platform.AppLibrarySubPages().DeleteByAppID(id); } } } new RoadFlow.Platform.Menu().ClearAllDataTableCache(); new RoadFlow.Platform.AppLibraryButtons1().ClearCache(); new RoadFlow.Platform.AppLibrarySubPages().ClearCache(); RoadFlow.Platform.Log.Add("删除了一批应用程序库", stringBuilder.ToString(), RoadFlow.Platform.Log.Types.菜单权限); transactionScope.Complete(); } return("删除成功!"); }
/// <summary> /// 得到流程运行时地址 /// </summary> /// <param name="app"></param> /// <returns></returns> public string GetFlowRunAddress(RoadFlow.Data.Model.AppLibrary app, string query = "") { StringBuilder sb = new StringBuilder(); if (app.Params.IsNullOrEmpty()) { if (!app.Address.Contains("?")) { sb.Append(app.Address); sb.Append("?1=1"); } } else { if (app.Address.Contains("?")) { sb.Append(app.Address); sb.Append("&"); sb.Append(app.Params.TrimStart('?').TrimStart('&')); } else { sb.Append(app.Address); sb.Append("?"); sb.Append(app.Params.TrimStart('?').TrimStart('&')); } } if (!query.IsNullOrEmpty()) { sb.Append("&"); sb.Append(query.TrimStart('?').TrimStart('&')); } return(sb.ToString()); }
public string Delete() { RoadFlow.Platform.AppLibrary appLibrary1 = new RoadFlow.Platform.AppLibrary(); string str1 = this.Request.Form["ids"]; StringBuilder stringBuilder = new StringBuilder(); using (TransactionScope transactionScope = new TransactionScope()) { string str2 = str1; char[] chArray = new char[1] { ',' }; foreach (string str3 in str2.Split(chArray)) { Guid test; if (str3.IsGuid(out test)) { RoadFlow.Data.Model.AppLibrary appLibrary2 = appLibrary1.Get(test, false); if (appLibrary2 != null) { stringBuilder.Append(appLibrary2.Serialize()); appLibrary1.Delete(test); new RoadFlow.Platform.AppLibraryButtons1().DeleteByAppID(test); new RoadFlow.Platform.AppLibrarySubPages().DeleteByAppID(test); } } } new RoadFlow.Platform.Menu().ClearAllDataTableCache(); new RoadFlow.Platform.AppLibraryButtons1().ClearCache(); new RoadFlow.Platform.AppLibrarySubPages().ClearCache(); RoadFlow.Platform.Log.Add("删除了一批应用程序库", stringBuilder.ToString(), RoadFlow.Platform.Log.Types.菜单权限, "", "", (RoadFlow.Data.Model.Users)null); transactionScope.Complete(); } return("删除成功!"); }
protected void Page_Load(object sender, EventArgs e) { string editID = Request.QueryString["id"]; string type = Request.QueryString["typeid"]; if (editID.IsGuid()) { appLibrary = bappLibrary.Get(editID.ToGuid()); } if (!IsPostBack) { if (appLibrary != null) { this.Title1.Value = appLibrary.Title; this.Address.Value = appLibrary.Address; this.TypeOptions.Text = new RoadFlow.Platform.AppLibrary().GetTypeOptions(appLibrary.Type.ToString()); this.OpenModelOptions.Text = new RoadFlow.Platform.Dictionary().GetOptionsByCode("appopenmodel", value: appLibrary.OpenMode.ToString()); this.Params.Value = appLibrary.Params; this.Width.Value = appLibrary.Width.ToString(); this.Height.Value = appLibrary.Height.ToString(); this.UseMember.Value = appLibrary.UseMember; this.Note.Value = appLibrary.Note; } else { this.TypeOptions.Text = new RoadFlow.Platform.AppLibrary().GetTypeOptions(""); this.OpenModelOptions.Text = new RoadFlow.Platform.Dictionary().GetOptionsByCode("appopenmodel"); } } }
protected void Button1_Click(object sender, EventArgs e) { string title = Request.Form["title1"]; string address = Request.Form["address"]; string openModel = Request.Form["openModel"]; string width = Request.Form["width"]; string height = Request.Form["height"]; string params1 = Request.Form["Params"]; string note = Request.Form["note"]; string useMember = Request.Form["UseMember"]; string type = Request.Form["type"]; bool isAdd = false; string oldXML = string.Empty; if (appLibrary == null) { isAdd = true; appLibrary = new RoadFlow.Data.Model.AppLibrary(); appLibrary.ID = Guid.NewGuid(); } else { oldXML = appLibrary.Serialize(); } appLibrary.Address = address.Trim(); appLibrary.Height = height.ToIntOrNull(); appLibrary.Note = note; appLibrary.OpenMode = openModel.ToInt(); appLibrary.Params = params1; appLibrary.Title = title; appLibrary.Type = type.ToGuid(); appLibrary.Width = width.ToIntOrNull(); if (!useMember.IsNullOrEmpty()) { appLibrary.UseMember = useMember; } else { appLibrary.UseMember = null; } if (isAdd) { bappLibrary.Add(appLibrary); RoadFlow.Platform.Log.Add("添加了应用程序库", appLibrary.Serialize(), RoadFlow.Platform.Log.Types.角色应用); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true); } else { bappLibrary.Update(appLibrary); RoadFlow.Platform.Log.Add("修改了应用程序库", "", RoadFlow.Platform.Log.Types.角色应用, oldXML, appLibrary.Serialize()); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('修改成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true); } bappLibrary.UpdateUseMemberCache(appLibrary.ID); bappLibrary.ClearCache(); new RoadFlow.Platform.RoleApp().ClearAllDataTableCache(); }
public string GetTypeByID(Guid id) { RoadFlow.Data.Model.AppLibrary appLibrary = this.Get(id, false); if (appLibrary != null) { return(appLibrary.Type.ToString()); } return(""); }
private List <RoadFlow.Data.Model.AppLibrary> DataReaderToList(OracleDataReader dataReader) { List <RoadFlow.Data.Model.AppLibrary> appLibraryList = new List <RoadFlow.Data.Model.AppLibrary>(); while (dataReader.Read()) { RoadFlow.Data.Model.AppLibrary appLibrary = new RoadFlow.Data.Model.AppLibrary(); appLibrary.ID = dataReader.GetString(0).ToGuid(); appLibrary.Title = dataReader.GetString(1); appLibrary.Address = dataReader.GetString(2); appLibrary.Type = dataReader.GetString(3).ToGuid(); appLibrary.OpenMode = dataReader.GetInt32(4); if (!dataReader.IsDBNull(5)) { appLibrary.Width = new int?(dataReader.GetInt32(5)); } if (!dataReader.IsDBNull(6)) { appLibrary.Height = new int?(dataReader.GetInt32(6)); } if (!dataReader.IsDBNull(7)) { appLibrary.Params = dataReader.GetString(7); } if (!dataReader.IsDBNull(8)) { appLibrary.Manager = dataReader.GetString(8); } if (!dataReader.IsDBNull(9)) { appLibrary.Note = dataReader.GetString(9); } if (!dataReader.IsDBNull(10)) { appLibrary.Code = dataReader.GetString(10); } if (!dataReader.IsDBNull(11)) { appLibrary.Ico = dataReader.GetString(11); } if (!dataReader.IsDBNull(12)) { appLibrary.Color = dataReader.GetString(12); } appLibraryList.Add(appLibrary); } return(appLibraryList); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <RoadFlow.Data.Model.AppLibrary> DataReaderToList(OracleDataReader dataReader) { List <RoadFlow.Data.Model.AppLibrary> List = new List <RoadFlow.Data.Model.AppLibrary>(); RoadFlow.Data.Model.AppLibrary model = null; while (dataReader.Read()) { model = new RoadFlow.Data.Model.AppLibrary(); model.ID = dataReader.GetString(0).ToGuid(); model.Title = dataReader.GetString(1); model.Address = dataReader.GetString(2); model.Type = dataReader.GetString(3).ToGuid(); model.OpenMode = dataReader.GetInt32(4); if (!dataReader.IsDBNull(5)) { model.Width = dataReader.GetInt32(5); } if (!dataReader.IsDBNull(6)) { model.Height = dataReader.GetInt32(6); } if (!dataReader.IsDBNull(7)) { model.Params = dataReader.GetString(7); } if (!dataReader.IsDBNull(8)) { model.Manager = dataReader.GetString(8); } if (!dataReader.IsDBNull(9)) { model.Note = dataReader.GetString(9); } if (!dataReader.IsDBNull(10)) { model.Code = dataReader.GetString(10); } List.Add(model); } return(List); }
public int Add(RoadFlow.Data.Model.AppLibrary model) { string sql = "INSERT INTO AppLibrary\r\n\t\t\t\t(ID,Title,Address,Type,OpenMode,Width,Height,Params,Manager,Note,Code,Ico,Color) \r\n\t\t\t\tVALUES(:ID,:Title,:Address,:Type,:OpenMode,:Width,:Height,:Params,:Manager,:Note,:Code,:Ico,:Color)"; OracleParameter[] oracleParameterArray = new OracleParameter[13]; int index1 = 0; OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2, 40); oracleParameter1.Value = (object)model.ID; oracleParameterArray[index1] = oracleParameter1; int index2 = 1; OracleParameter oracleParameter2 = new OracleParameter(":Title", OracleDbType.NVarchar2, 510); oracleParameter2.Value = (object)model.Title; oracleParameterArray[index2] = oracleParameter2; int index3 = 2; OracleParameter oracleParameter3 = new OracleParameter(":Address", OracleDbType.Varchar2, 200); oracleParameter3.Value = (object)model.Address; oracleParameterArray[index3] = oracleParameter3; int index4 = 3; OracleParameter oracleParameter4 = new OracleParameter(":Type", OracleDbType.Varchar2, 40); oracleParameter4.Value = (object)model.Type; oracleParameterArray[index4] = oracleParameter4; int index5 = 4; OracleParameter oracleParameter5 = new OracleParameter(":OpenMode", OracleDbType.Int32); oracleParameter5.Value = (object)model.OpenMode; oracleParameterArray[index5] = oracleParameter5; int index6 = 5; OracleParameter oracleParameter6; if (model.Width.HasValue) { OracleParameter oracleParameter7 = new OracleParameter(":Width", OracleDbType.Int32); oracleParameter7.Value = (object)model.Width; oracleParameter6 = oracleParameter7; } else { oracleParameter6 = new OracleParameter(":Width", OracleDbType.Int32); oracleParameter6.Value = (object)DBNull.Value; } oracleParameterArray[index6] = oracleParameter6; int index7 = 6; OracleParameter oracleParameter8; if (model.Height.HasValue) { OracleParameter oracleParameter7 = new OracleParameter(":Height", OracleDbType.Int32); oracleParameter7.Value = (object)model.Height; oracleParameter8 = oracleParameter7; } else { oracleParameter8 = new OracleParameter(":Height", OracleDbType.Int32); oracleParameter8.Value = (object)DBNull.Value; } oracleParameterArray[index7] = oracleParameter8; int index8 = 7; OracleParameter oracleParameter9; if (model.Params != null) { OracleParameter oracleParameter7 = new OracleParameter(":Params", OracleDbType.Clob); oracleParameter7.Value = (object)model.Params; oracleParameter9 = oracleParameter7; } else { oracleParameter9 = new OracleParameter(":Params", OracleDbType.Clob); oracleParameter9.Value = (object)DBNull.Value; } oracleParameterArray[index8] = oracleParameter9; int index9 = 8; OracleParameter oracleParameter10; if (model.Manager != null) { OracleParameter oracleParameter7 = new OracleParameter(":Manager", OracleDbType.Clob); oracleParameter7.Value = (object)model.Manager; oracleParameter10 = oracleParameter7; } else { oracleParameter10 = new OracleParameter(":Manager", OracleDbType.Clob); oracleParameter10.Value = (object)DBNull.Value; } oracleParameterArray[index9] = oracleParameter10; int index10 = 9; OracleParameter oracleParameter11; if (model.Note != null) { OracleParameter oracleParameter7 = new OracleParameter(":Note", OracleDbType.Clob); oracleParameter7.Value = (object)model.Note; oracleParameter11 = oracleParameter7; } else { oracleParameter11 = new OracleParameter(":Note", OracleDbType.Clob); oracleParameter11.Value = (object)DBNull.Value; } oracleParameterArray[index10] = oracleParameter11; int index11 = 10; OracleParameter oracleParameter12; if (model.Code != null) { OracleParameter oracleParameter7 = new OracleParameter(":Code", OracleDbType.Varchar2, 50); oracleParameter7.Value = (object)model.Code; oracleParameter12 = oracleParameter7; } else { oracleParameter12 = new OracleParameter(":Code", OracleDbType.Varchar2, 50); oracleParameter12.Value = (object)DBNull.Value; } oracleParameterArray[index11] = oracleParameter12; int index12 = 11; OracleParameter oracleParameter13; if (model.Ico != null) { OracleParameter oracleParameter7 = new OracleParameter(":Ico", OracleDbType.Varchar2); oracleParameter7.Value = (object)model.Ico; oracleParameter13 = oracleParameter7; } else { oracleParameter13 = new OracleParameter(":Ico", OracleDbType.Varchar2); oracleParameter13.Value = (object)DBNull.Value; } oracleParameterArray[index12] = oracleParameter13; int index13 = 12; OracleParameter oracleParameter14; if (model.Color != null) { OracleParameter oracleParameter7 = new OracleParameter(":Color", OracleDbType.Varchar2); oracleParameter7.Value = (object)model.Color; oracleParameter14 = oracleParameter7; } else { oracleParameter14 = new OracleParameter(":Color", OracleDbType.Varchar2); oracleParameter14.Value = (object)DBNull.Value; } oracleParameterArray[index13] = oracleParameter14; OracleParameter[] parameter = oracleParameterArray; return(this.dbHelper.Execute(sql, parameter)); }
/// <summary> /// 更新 /// </summary> public int Update(RoadFlow.Data.Model.AppLibrary model) { return(dataAppLibrary.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(RoadFlow.Data.Model.AppLibrary model) { return(dataAppLibrary.Add(model)); }
public ActionResult Edit(FormCollection collection) { string str1 = this.Request.QueryString["id"]; string str2 = this.Request.QueryString["typeid"]; RoadFlow.Platform.AppLibrary appLibrary = new RoadFlow.Platform.AppLibrary(); RoadFlow.Data.Model.AppLibrary model1 = (RoadFlow.Data.Model.AppLibrary)null; if (str1.IsGuid()) { model1 = appLibrary.Get(str1.ToGuid(), false); } bool flag1 = !str1.IsGuid(); string oldXML = string.Empty; int index1; if (model1 == null) { model1 = new RoadFlow.Data.Model.AppLibrary(); model1.ID = Guid.NewGuid(); // ISSUE: reference to a compiler-generated field if (AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__0 == null) { // ISSUE: reference to a compiler-generated field AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "TypeOptions", typeof(AppLibraryController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj1 = AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__0.Target((CallSite)AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__0, this.ViewBag, new RoadFlow.Platform.AppLibrary().GetTypeOptions(str2)); // ISSUE: reference to a compiler-generated field if (AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__1 == null) { // ISSUE: reference to a compiler-generated field AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__1 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "OpenOptions", typeof(AppLibraryController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj2 = AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__1.Target((CallSite)AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__1, this.ViewBag, new RoadFlow.Platform.Dictionary().GetOptionsByCode("appopenmodel", RoadFlow.Platform.Dictionary.OptionValueField.Value, "", "", true)); } else { oldXML = model1.Serialize(); // ISSUE: reference to a compiler-generated field if (AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__2 == null) { // ISSUE: reference to a compiler-generated field AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__2 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "TypeOptions", typeof(AppLibraryController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj1 = AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__2.Target((CallSite)AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__2, this.ViewBag, new RoadFlow.Platform.AppLibrary().GetTypeOptions(model1.Type.ToString())); // ISSUE: reference to a compiler-generated field if (AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__3 == null) { // ISSUE: reference to a compiler-generated field AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__3 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "OpenOptions", typeof(AppLibraryController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null) })); } // ISSUE: reference to a compiler-generated field Func <CallSite, object, string, object> target = AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__3.Target; // ISSUE: reference to a compiler-generated field CallSite <Func <CallSite, object, string, object> > p3 = AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__3; object viewBag = this.ViewBag; RoadFlow.Platform.Dictionary dictionary = new RoadFlow.Platform.Dictionary(); string code = "appopenmodel"; int num1 = 3; index1 = model1.OpenMode; string str3 = index1.ToString(); string attr = ""; int num2 = 1; string optionsByCode = dictionary.GetOptionsByCode(code, (RoadFlow.Platform.Dictionary.OptionValueField)num1, str3, attr, num2 != 0); object obj2 = target((CallSite)p3, viewBag, optionsByCode); } if (collection != null) { string str3 = collection["title"]; string str4 = collection["address"]; string str5 = collection["openModel"]; string str6 = collection["width"]; string str7 = collection["height"]; string str8 = collection["Params"]; string str9 = collection["Note"]; string str10 = collection["Ico"]; string str11 = collection["IcoColor"]; string str12 = collection["type"]; model1.Address = str4.Trim(); model1.Height = str7.ToIntOrNull(); model1.Note = str9; model1.OpenMode = str5.ToInt(); model1.Params = str8; model1.Title = str3; model1.Type = str12.ToGuid(); model1.Width = str6.ToIntOrNull(); model1.Ico = str10.IsNullOrEmpty() ? (string)null : str10; model1.Color = str11.IsNullOrEmpty() ? (string)null : str11.Trim(); string str13 = this.Request.QueryString["pagesize"]; string str14 = this.Request.QueryString["pagenumber"]; using (TransactionScope transactionScope = new TransactionScope()) { if (flag1) { appLibrary.Add(model1); RoadFlow.Platform.Log.Add("添加了应用程序库", model1.Serialize(), RoadFlow.Platform.Log.Types.菜单权限, "", "", (RoadFlow.Data.Model.Users)null); // ISSUE: reference to a compiler-generated field if (AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__4 == null) { // ISSUE: reference to a compiler-generated field AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__4 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Script", typeof(AppLibraryController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj = AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__4.Target((CallSite)AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__4, this.ViewBag, "alert('添加成功!');new RoadUI.Window().reloadOpener(undefined,undefined,\"query('" + str13 + "','" + str14 + "')\");new RoadUI.Window().close();"); } else { appLibrary.Update(model1); RoadFlow.Platform.Log.Add("修改了应用程序库", "", RoadFlow.Platform.Log.Types.菜单权限, oldXML, model1.Serialize(), (RoadFlow.Data.Model.Users)null); // ISSUE: reference to a compiler-generated field if (AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__5 == null) { // ISSUE: reference to a compiler-generated field AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__5 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Script", typeof(AppLibraryController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj = AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__5.Target((CallSite)AppLibraryController.\u003C\u003Eo__5.\u003C\u003Ep__5, this.ViewBag, "alert('修改成功!');new RoadUI.Window().reloadOpener(undefined,undefined,\"query('" + str13 + "','" + str14 + "')\");new RoadUI.Window().close();"); } RoadFlow.Platform.AppLibraryButtons1 appLibraryButtons1_1 = new RoadFlow.Platform.AppLibraryButtons1(); string str15 = this.Request.Form["buttonindex"] ?? ""; List <RoadFlow.Data.Model.AppLibraryButtons1> allByAppId = appLibraryButtons1_1.GetAllByAppID(model1.ID); List <RoadFlow.Data.Model.AppLibraryButtons1> appLibraryButtons1List = new List <RoadFlow.Data.Model.AppLibraryButtons1>(); char[] chArray = new char[1] { ',' }; string[] strArray = str15.Split(chArray); for (index1 = 0; index1 < strArray.Length; ++index1) { string index = strArray[index1]; string str16 = this.Request.Form["button_" + index]; string str17 = this.Request.Form["buttonname_" + index]; string str18 = this.Request.Form["buttonevents_" + index]; string str19 = this.Request.Form["buttonico_" + index]; string str20 = this.Request.Form["showtype_" + index]; string str21 = this.Request.Form["buttonsort_" + index]; if (!str17.IsNullOrEmpty() && !str18.IsNullOrEmpty()) { RoadFlow.Data.Model.AppLibraryButtons1 model2 = allByAppId.Find((Predicate <RoadFlow.Data.Model.AppLibraryButtons1>)(p => p.ID == index.ToGuid())); bool flag2 = false; if (model2 == null) { flag2 = true; model2 = new RoadFlow.Data.Model.AppLibraryButtons1(); model2.ID = Guid.NewGuid(); } else { appLibraryButtons1List.Add(model2); } model2.AppLibraryID = model1.ID; if (str16.IsGuid()) { model2.ButtonID = new Guid?(str16.ToGuid()); } model2.Events = str18; model2.Ico = str19; model2.Name = str17.Trim1(); model2.Sort = str21.ToInt(0); model2.ShowType = str20.ToInt(0); model2.Type = 0; if (flag2) { appLibraryButtons1_1.Add(model2); } else { appLibraryButtons1_1.Update(model2); } } } foreach (RoadFlow.Data.Model.AppLibraryButtons1 appLibraryButtons1_2 in allByAppId) { RoadFlow.Data.Model.AppLibraryButtons1 sub = appLibraryButtons1_2; if (appLibraryButtons1List.Find((Predicate <RoadFlow.Data.Model.AppLibraryButtons1>)(p => p.ID == sub.ID)) == null) { appLibraryButtons1_1.Delete(sub.ID); } } transactionScope.Complete(); appLibraryButtons1_1.ClearCache(); } new RoadFlow.Platform.Menu().ClearAllDataTableCache(); new RoadFlow.Platform.WorkFlow().ClearStartFlowsCache(); appLibrary.ClearCache(); } return((ActionResult)this.View((object)model1)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.AppLibrary实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.AppLibrary model) { string sql = @"INSERT INTO AppLibrary (ID,Title,Address,Type,OpenMode,Width,Height,Params,Manager,Note,Code) VALUES(:ID,:Title,:Address,:Type,:OpenMode,:Width,:Height,:Params,:Manager,:Note,:Code,:UseMember)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID }, new OracleParameter(":Title", OracleDbType.NVarchar2, 510) { Value = model.Title }, new OracleParameter(":Address", OracleDbType.Varchar2, 200) { Value = model.Address }, new OracleParameter(":Type", OracleDbType.Varchar2, 40) { Value = model.Type }, new OracleParameter(":OpenMode", OracleDbType.Int32) { Value = model.OpenMode }, model.Width == null ? new OracleParameter(":Width", OracleDbType.Int32) { Value = DBNull.Value } : new OracleParameter(":Width", OracleDbType.Int32) { Value = model.Width }, model.Height == null ? new OracleParameter(":Height", OracleDbType.Int32) { Value = DBNull.Value } : new OracleParameter(":Height", OracleDbType.Int32) { Value = model.Height }, model.Params == null ? new OracleParameter(":Params", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Params", OracleDbType.Clob) { Value = model.Params }, model.Manager == null ? new OracleParameter(":Manager", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Manager", OracleDbType.Clob) { Value = model.Manager }, model.Note == null ? new OracleParameter(":Note", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.Clob) { Value = model.Note }, model.Code == null ? new OracleParameter(":Code", OracleDbType.Varchar2, 50) { Value = DBNull.Value } : new OracleParameter(":Code", OracleDbType.Varchar2, 50) { Value = model.Code }, model.UseMember == null ? new OracleParameter(":UseMember", OracleDbType.Varchar2) { Value = DBNull.Value } : new OracleParameter(":UseMember", OracleDbType.Varchar2) { Value = model.UseMember } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.AppLibrary实体类</param> public int Update(RoadFlow.Data.Model.AppLibrary model) { string sql = @"UPDATE AppLibrary SET Title=:Title,Address=:Address,Type=:Type,OpenMode=:OpenMode,Width=:Width,Height=:Height,Params=:Params,Manager=:Manager,Note=:Note,Code=:Code,UseMember=:UseMember WHERE ID=:ID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":Title", OracleDbType.NVarchar2, 510) { Value = model.Title }, new OracleParameter(":Address", OracleDbType.Varchar2, 200) { Value = model.Address }, new OracleParameter(":Type", OracleDbType.Varchar2, 40) { Value = model.Type }, new OracleParameter(":OpenMode", OracleDbType.Int32) { Value = model.OpenMode }, model.Width == null ? new OracleParameter(":Width", OracleDbType.Int32) { Value = DBNull.Value } : new OracleParameter(":Width", OracleDbType.Int32) { Value = model.Width }, model.Height == null ? new OracleParameter(":Height", OracleDbType.Int32) { Value = DBNull.Value } : new OracleParameter(":Height", OracleDbType.Int32) { Value = model.Height }, model.Params == null ? new OracleParameter(":Params", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Params", OracleDbType.Clob) { Value = model.Params }, model.Manager == null ? new OracleParameter(":Manager", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Manager", OracleDbType.Clob) { Value = model.Manager }, model.Note == null ? new OracleParameter(":Note", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.Clob) { Value = model.Note }, model.Code == null ? new OracleParameter(":Code", OracleDbType.Varchar2, 50) { Value = DBNull.Value } : new OracleParameter(":Code", OracleDbType.Varchar2, 50) { Value = model.Code }, model.UseMember == null ? new OracleParameter(":UseMember", OracleDbType.Varchar2) { Value = DBNull.Value } : new OracleParameter(":UseMember", OracleDbType.Varchar2) { Value = model.UseMember }, new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
public ActionResult Edit(FormCollection collection) { string text = base.Request.QueryString["id"]; string value = base.Request.QueryString["typeid"]; RoadFlow.Platform.AppLibrary appLibrary = new RoadFlow.Platform.AppLibrary(); RoadFlow.Data.Model.AppLibrary appLibrary2 = null; if (MyExtensions.IsGuid(text)) { appLibrary2 = appLibrary.Get(MyExtensions.ToGuid(text)); } bool flag = !MyExtensions.IsGuid(text); string oldXML = string.Empty; if (appLibrary2 == null) { appLibrary2 = new RoadFlow.Data.Model.AppLibrary(); appLibrary2.ID = Guid.NewGuid(); base.ViewBag.TypeOptions = new RoadFlow.Platform.AppLibrary().GetTypeOptions(value); base.ViewBag.OpenOptions = new RoadFlow.Platform.Dictionary().GetOptionsByCode("appopenmodel"); } else { oldXML = MyExtensions.Serialize((object)appLibrary2); base.ViewBag.TypeOptions = new RoadFlow.Platform.AppLibrary().GetTypeOptions(appLibrary2.Type.ToString()); base.ViewBag.OpenOptions = new RoadFlow.Platform.Dictionary().GetOptionsByCode("appopenmodel", RoadFlow.Platform.Dictionary.OptionValueField.Value, appLibrary2.OpenMode.ToString()); } if (collection != null) { string title = collection["title"]; string text2 = collection["address"]; string text3 = collection["openModel"]; string text4 = collection["width"]; string text5 = collection["height"]; string @params = collection["Params"]; string note = collection["Note"]; string text6 = collection["Ico"]; string text7 = collection["IcoColor"]; value = collection["type"]; appLibrary2.Address = text2.Trim(); appLibrary2.Height = MyExtensions.ToIntOrNull(text5); appLibrary2.Note = note; appLibrary2.OpenMode = MyExtensions.ToInt(text3); appLibrary2.Params = @params; appLibrary2.Title = title; appLibrary2.Type = MyExtensions.ToGuid(value); appLibrary2.Width = MyExtensions.ToIntOrNull(text4); if (!MyExtensions.IsNullOrEmpty(text6)) { appLibrary2.Ico = text6; } else { appLibrary2.Ico = null; } if (!MyExtensions.IsNullOrEmpty(text7)) { appLibrary2.Color = text7.Trim(); } else { appLibrary2.Color = null; } string text8 = base.Request.QueryString["pagesize"]; string text9 = base.Request.QueryString["pagenumber"]; using (TransactionScope transactionScope = new TransactionScope()) { if (flag) { appLibrary.Add(appLibrary2); RoadFlow.Platform.Log.Add("添加了应用程序库", MyExtensions.Serialize((object)appLibrary2), RoadFlow.Platform.Log.Types.菜单权限); base.ViewBag.Script = "alert('添加成功!');new RoadUI.Window().reloadOpener(undefined,undefined,\"query('" + text8 + "','" + text9 + "')\");new RoadUI.Window().close();"; } else { appLibrary.Update(appLibrary2); RoadFlow.Platform.Log.Add("修改了应用程序库", "", RoadFlow.Platform.Log.Types.菜单权限, oldXML, MyExtensions.Serialize((object)appLibrary2)); base.ViewBag.Script = "alert('修改成功!');new RoadUI.Window().reloadOpener(undefined,undefined,\"query('" + text8 + "','" + text9 + "')\");new RoadUI.Window().close();"; } RoadFlow.Platform.AppLibraryButtons1 appLibraryButtons = new RoadFlow.Platform.AppLibraryButtons1(); string obj = base.Request.Form["buttonindex"] ?? ""; List <RoadFlow.Data.Model.AppLibraryButtons1> allByAppID = appLibraryButtons.GetAllByAppID(appLibrary2.ID); List <RoadFlow.Data.Model.AppLibraryButtons1> list = new List <RoadFlow.Data.Model.AppLibraryButtons1>(); string[] array = obj.Split(','); foreach (string index in array) { string text10 = base.Request.Form["button_" + index]; string text11 = base.Request.Form["buttonname_" + index]; string text12 = base.Request.Form["buttonevents_" + index]; string ico = base.Request.Form["buttonico_" + index]; string text13 = base.Request.Form["showtype_" + index]; string text14 = base.Request.Form["buttonsort_" + index]; if (!MyExtensions.IsNullOrEmpty(text11) && !MyExtensions.IsNullOrEmpty(text12)) { RoadFlow.Data.Model.AppLibraryButtons1 appLibraryButtons2 = allByAppID.Find((RoadFlow.Data.Model.AppLibraryButtons1 p) => p.ID == MyExtensions.ToGuid(index)); bool flag2 = false; if (appLibraryButtons2 == null) { flag2 = true; appLibraryButtons2 = new RoadFlow.Data.Model.AppLibraryButtons1(); appLibraryButtons2.ID = Guid.NewGuid(); } else { list.Add(appLibraryButtons2); } appLibraryButtons2.AppLibraryID = appLibrary2.ID; if (MyExtensions.IsGuid(text10)) { appLibraryButtons2.ButtonID = MyExtensions.ToGuid(text10); } appLibraryButtons2.Events = text12; appLibraryButtons2.Ico = ico; appLibraryButtons2.Name = MyExtensions.Trim1(text11); appLibraryButtons2.Sort = MyExtensions.ToInt(text14, 0); appLibraryButtons2.ShowType = MyExtensions.ToInt(text13, 0); appLibraryButtons2.Type = 0; if (flag2) { appLibraryButtons.Add(appLibraryButtons2); } else { appLibraryButtons.Update(appLibraryButtons2); } } } foreach (RoadFlow.Data.Model.AppLibraryButtons1 item in allByAppID) { if (list.Find((RoadFlow.Data.Model.AppLibraryButtons1 p) => p.ID == item.ID) == null) { appLibraryButtons.Delete(item.ID); } } transactionScope.Complete(); appLibraryButtons.ClearCache(); } new RoadFlow.Platform.Menu().ClearAllDataTableCache(); new RoadFlow.Platform.WorkFlow().ClearStartFlowsCache(); appLibrary.ClearCache(); } return(View(appLibrary2)); }
public string Publish() { string html = Request["html"]; string name = Request["name"]; string att = Request["att"]; string id = Request["id"]; Guid gid; if (!id.IsGuid(out gid) || name.IsNullOrEmpty() || att.IsNullOrEmpty() || html.IsNullOrEmpty()) { return("参数错误!"); } RoadFlow.Platform.WorkFlowForm WFF = new RoadFlow.Platform.WorkFlowForm(); RoadFlow.Data.Model.WorkFlowForm wff = WFF.Get(gid); if (wff == null) { return("未找到表单!"); } string fileName = id + ".cshtml"; System.Text.StringBuilder serverScript = new System.Text.StringBuilder("@{\r\n"); var attrJSON = LitJson.JsonMapper.ToObject(att); serverScript.Append("\tstring FlowID = Request.QueryString[\"flowid\"];\r\n"); serverScript.Append("\tstring StepID = Request.QueryString[\"stepid\"];\r\n"); serverScript.Append("\tstring GroupID = Request.QueryString[\"groupid\"];\r\n"); serverScript.Append("\tstring TaskID = Request.QueryString[\"taskid\"];\r\n"); serverScript.Append("\tstring InstanceID = Request.QueryString[\"instanceid\"];\r\n"); serverScript.Append("\tstring DisplayModel = Request.QueryString[\"display\"] ?? \"0\";\r\n"); serverScript.AppendFormat("\tstring DBConnID = \"{0}\";\r\n", attrJSON["dbconn"].ToString()); serverScript.AppendFormat("\tstring DBTable = \"{0}\";\r\n", attrJSON["dbtable"].ToString()); serverScript.AppendFormat("\tstring DBTablePK = \"{0}\";\r\n", attrJSON["dbtablepk"].ToString()); serverScript.AppendFormat("\tstring DBTableTitle = \"{0}\";\r\n", attrJSON["dbtabletitle"].ToString()); serverScript.Append("if(InstanceID.IsNullOrEmpty()){InstanceID = Request.QueryString[\"instanceid1\"];}"); serverScript.Append("\tRoadFlow.Platform.Dictionary BDictionary = new RoadFlow.Platform.Dictionary();\r\n"); serverScript.Append("\tRoadFlow.Platform.WorkFlow BWorkFlow = new RoadFlow.Platform.WorkFlow();\r\n"); serverScript.Append("\tRoadFlow.Platform.WorkFlowTask BWorkFlowTask = new RoadFlow.Platform.WorkFlowTask();\r\n"); serverScript.Append("\tstring fieldStatus = BWorkFlow.GetFieldStatus(FlowID, StepID);\r\n"); serverScript.Append("\tLitJson.JsonData initData = BWorkFlow.GetFormData(DBConnID, DBTable, DBTablePK, InstanceID, fieldStatus);\r\n"); serverScript.Append("\tstring TaskTitle = BWorkFlow.GetFromFieldData(initData, DBTable, DBTableTitle);\r\n"); serverScript.Append("}\r\n"); serverScript.Append("<link href=\"~/Scripts/FlowRun/Forms/flowform.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n"); serverScript.Append("<script src=\"~/Scripts/FlowRun/Forms/common.js\" type=\"text/javascript\" ></script>\r\n"); if (attrJSON.ContainsKey("hasEditor") && "1" == attrJSON["hasEditor"].ToString()) { serverScript.Append("<script src=\"~/Scripts/Ueditor/ueditor.config.js\" type=\"text/javascript\" ></script>\r\n"); serverScript.Append("<script src=\"~/Scripts/Ueditor/ueditor.all.min.js\" type=\"text/javascript\" ></script>\r\n"); serverScript.Append("<script src=\"~/Scripts/Ueditor/lang/zh-cn/zh-cn.js\" type=\"text/javascript\" ></script>\r\n"); serverScript.Append("<input type=\"hidden\" id=\"Form_HasUEditor\" name=\"Form_HasUEditor\" value=\"1\" />\r\n"); } string validatePropType = attrJSON.ContainsKey("validatealerttype") ? attrJSON["validatealerttype"].ToString() : "2"; serverScript.Append("<input type=\"hidden\" id=\"Form_ValidateAlertType\" name=\"Form_ValidateAlertType\" value=\"" + validatePropType + "\" />\r\n"); if (attrJSON.ContainsKey("autotitle") && attrJSON["autotitle"].ToString().ToLower() == "true") { serverScript.AppendFormat("<input type=\"hidden\" id=\"{0}\" name=\"{0}\" value=\"{1}\" />\r\n", string.Concat(attrJSON["dbtable"].ToString(), ".", attrJSON["dbtabletitle"].ToString()), "@(TaskTitle.IsNullOrEmpty() ? BWorkFlow.GetAutoTaskTitle(FlowID, StepID, Request.QueryString[\"groupid\"]) : TaskTitle)" ); } serverScript.AppendFormat("<input type=\"hidden\" id=\"Form_TitleField\" name=\"Form_TitleField\" value=\"{0}\" />\r\n", string.Concat(attrJSON["dbtable"].ToString(), ".", attrJSON["dbtabletitle"].ToString())); //serverScript.AppendFormat("<input type=\"hidden\" id=\"Form_Name\" name=\"Form_Name\" value=\"{0}\" />\r\n", attrJSON["name"].ToString()); serverScript.AppendFormat("<input type=\"hidden\" id=\"Form_DBConnID\" name=\"Form_DBConnID\" value=\"{0}\" />\r\n", attrJSON["dbconn"].ToString()); serverScript.AppendFormat("<input type=\"hidden\" id=\"Form_DBTable\" name=\"Form_DBTable\" value=\"{0}\" />\r\n", attrJSON["dbtable"].ToString()); serverScript.AppendFormat("<input type=\"hidden\" id=\"Form_DBTablePk\" name=\"Form_DBTablePk\" value=\"{0}\" />\r\n", attrJSON["dbtablepk"].ToString()); serverScript.AppendFormat("<input type=\"hidden\" id=\"Form_DBTableTitle\" name=\"Form_DBTableTitle\" value=\"{0}\" />\r\n", attrJSON["dbtabletitle"].ToString()); serverScript.AppendFormat("<input type=\"hidden\" id=\"Form_AutoSaveData\" name=\"Form_AutoSaveData\" value=\"{0}\" />\r\n", "1"); serverScript.Append("<script type=\"text/javascript\">\r\n"); serverScript.Append("\tvar initData = @Html.Raw(BWorkFlow.GetFormDataJsonString(initData));\r\n"); serverScript.Append("\tvar fieldStatus = \"1\"==\"@Request.QueryString[\"isreadonly\"]\" ? {} : @Html.Raw(fieldStatus);\r\n"); serverScript.Append("\tvar displayModel = '@DisplayModel';\r\n"); serverScript.Append("\t$(window).load(function (){\r\n"); serverScript.AppendFormat("\t\tformrun.initData(initData, \"{0}\", fieldStatus, displayModel);\r\n", attrJSON["dbtable"].ToString()); serverScript.Append("\t});\r\n"); serverScript.Append("</script>\r\n"); string file = Server.MapPath("~/Views/WorkFlowFormDesigner/Forms/" + fileName); System.IO.Stream stream = System.IO.File.Open(file, FileMode.OpenOrCreate, FileAccess.Write, FileShare.None); stream.SetLength(0); StreamWriter sw = new StreamWriter(stream, System.Text.Encoding.UTF8); sw.Write(serverScript.ToString()); sw.Write(Server.HtmlDecode(html)); sw.Close(); stream.Close(); string attr = wff.Attribute; string appType = LitJson.JsonMapper.ToObject(attr)["apptype"].ToString(); RoadFlow.Platform.AppLibrary App = new RoadFlow.Platform.AppLibrary(); var app = App.GetByCode(id); bool isAdd = false; if (app == null) { app = new RoadFlow.Data.Model.AppLibrary(); app.ID = Guid.NewGuid(); app.Code = id; isAdd = true; } app.Address = "/Views/WorkFlowFormDesigner/Forms/" + fileName; app.Note = "流程表单"; app.OpenMode = 0; app.Params = ""; app.Title = name.Trim(); app.Type = appType.IsGuid() ? appType.ToGuid() : new RoadFlow.Platform.Dictionary().GetIDByCode("FormTypes"); if (isAdd) { App.Add(app); } else { App.Update(app); } RoadFlow.Platform.Log.Add("发布了流程表单", app.Serialize() + "内容:" + html, RoadFlow.Platform.Log.Types.流程相关); wff.Status = 1; WFF.Update(wff); return("发布成功!"); }
public int Add(RoadFlow.Data.Model.AppLibrary model) { string sql = "INSERT INTO AppLibrary\r\n\t\t\t\t(ID,Title,Address,Type,OpenMode,Width,Height,Params,Manager,Note,Code,Ico,Color) \r\n\t\t\t\tVALUES(@ID,@Title,@Address,@Type,@OpenMode,@Width,@Height,@Params,@Manager,@Note,@Code,@Ico,@Color)"; SqlParameter[] sqlParameterArray = new SqlParameter[13]; int index1 = 0; SqlParameter sqlParameter1 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1); sqlParameter1.Value = (object)model.ID; sqlParameterArray[index1] = sqlParameter1; int index2 = 1; SqlParameter sqlParameter2 = new SqlParameter("@Title", SqlDbType.NVarChar, 510); sqlParameter2.Value = (object)model.Title; sqlParameterArray[index2] = sqlParameter2; int index3 = 2; SqlParameter sqlParameter3 = new SqlParameter("@Address", SqlDbType.VarChar, 200); sqlParameter3.Value = (object)model.Address; sqlParameterArray[index3] = sqlParameter3; int index4 = 3; SqlParameter sqlParameter4 = new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1); sqlParameter4.Value = (object)model.Type; sqlParameterArray[index4] = sqlParameter4; int index5 = 4; SqlParameter sqlParameter5 = new SqlParameter("@OpenMode", SqlDbType.Int, -1); sqlParameter5.Value = (object)model.OpenMode; sqlParameterArray[index5] = sqlParameter5; int index6 = 5; SqlParameter sqlParameter6; if (model.Width.HasValue) { SqlParameter sqlParameter7 = new SqlParameter("@Width", SqlDbType.Int, -1); sqlParameter7.Value = (object)model.Width; sqlParameter6 = sqlParameter7; } else { sqlParameter6 = new SqlParameter("@Width", SqlDbType.Int, -1); sqlParameter6.Value = (object)DBNull.Value; } sqlParameterArray[index6] = sqlParameter6; int index7 = 6; SqlParameter sqlParameter8; if (model.Height.HasValue) { SqlParameter sqlParameter7 = new SqlParameter("@Height", SqlDbType.Int, -1); sqlParameter7.Value = (object)model.Height; sqlParameter8 = sqlParameter7; } else { sqlParameter8 = new SqlParameter("@Height", SqlDbType.Int, -1); sqlParameter8.Value = (object)DBNull.Value; } sqlParameterArray[index7] = sqlParameter8; int index8 = 7; SqlParameter sqlParameter9; if (model.Params != null) { SqlParameter sqlParameter7 = new SqlParameter("@Params", SqlDbType.VarChar, -1); sqlParameter7.Value = (object)model.Params; sqlParameter9 = sqlParameter7; } else { sqlParameter9 = new SqlParameter("@Params", SqlDbType.VarChar, -1); sqlParameter9.Value = (object)DBNull.Value; } sqlParameterArray[index8] = sqlParameter9; int index9 = 8; SqlParameter sqlParameter10; if (model.Manager != null) { SqlParameter sqlParameter7 = new SqlParameter("@Manager", SqlDbType.VarChar, -1); sqlParameter7.Value = (object)model.Manager; sqlParameter10 = sqlParameter7; } else { sqlParameter10 = new SqlParameter("@Manager", SqlDbType.VarChar, -1); sqlParameter10.Value = (object)DBNull.Value; } sqlParameterArray[index9] = sqlParameter10; int index10 = 9; SqlParameter sqlParameter11; if (model.Note != null) { SqlParameter sqlParameter7 = new SqlParameter("@Note", SqlDbType.VarChar, -1); sqlParameter7.Value = (object)model.Note; sqlParameter11 = sqlParameter7; } else { sqlParameter11 = new SqlParameter("@Note", SqlDbType.VarChar, -1); sqlParameter11.Value = (object)DBNull.Value; } sqlParameterArray[index10] = sqlParameter11; int index11 = 10; SqlParameter sqlParameter12; if (model.Code != null) { SqlParameter sqlParameter7 = new SqlParameter("@Code", SqlDbType.VarChar, 50); sqlParameter7.Value = (object)model.Code; sqlParameter12 = sqlParameter7; } else { sqlParameter12 = new SqlParameter("@Code", SqlDbType.VarChar, 50); sqlParameter12.Value = (object)DBNull.Value; } sqlParameterArray[index11] = sqlParameter12; int index12 = 11; SqlParameter sqlParameter13; if (model.Ico != null) { SqlParameter sqlParameter7 = new SqlParameter("@Ico", SqlDbType.VarChar, 2000); sqlParameter7.Value = (object)model.Ico; sqlParameter13 = sqlParameter7; } else { sqlParameter13 = new SqlParameter("@Ico", SqlDbType.VarChar, 2000); sqlParameter13.Value = (object)DBNull.Value; } sqlParameterArray[index12] = sqlParameter13; int index13 = 12; SqlParameter sqlParameter14; if (model.Color != null) { SqlParameter sqlParameter7 = new SqlParameter("@Color", SqlDbType.VarChar, 50); sqlParameter7.Value = (object)model.Color; sqlParameter14 = sqlParameter7; } else { sqlParameter14 = new SqlParameter("@Color", SqlDbType.VarChar, 50); sqlParameter14.Value = (object)DBNull.Value; } sqlParameterArray[index13] = sqlParameter14; SqlParameter[] parameter = sqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Add(RoadFlow.Data.Model.AppLibrary model) { string sql = "INSERT INTO applibrary\r\n\t\t\t\t(ID,Title,Address,Type,OpenMode,Width,Height,Params,Manager,Note,Code,Ico,Color) \r\n\t\t\t\tVALUES(@ID,@Title,@Address,@Type,@OpenMode,@Width,@Height,@Params,@Manager,@Note,@Code,@Ico,@Color)"; MySqlParameter[] mySqlParameterArray = new MySqlParameter[13]; int index1 = 0; MySqlParameter mySqlParameter1 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36); mySqlParameter1.Value = (object)model.ID; mySqlParameterArray[index1] = mySqlParameter1; int index2 = 1; MySqlParameter mySqlParameter2 = new MySqlParameter("@Title", MySqlDbType.VarChar, (int)byte.MaxValue); mySqlParameter2.Value = (object)model.Title; mySqlParameterArray[index2] = mySqlParameter2; int index3 = 2; MySqlParameter mySqlParameter3 = new MySqlParameter("@Address", MySqlDbType.Text, -1); mySqlParameter3.Value = (object)model.Address; mySqlParameterArray[index3] = mySqlParameter3; int index4 = 3; MySqlParameter mySqlParameter4 = new MySqlParameter("@Type", MySqlDbType.VarChar, 36); mySqlParameter4.Value = (object)model.Type; mySqlParameterArray[index4] = mySqlParameter4; int index5 = 4; MySqlParameter mySqlParameter5 = new MySqlParameter("@OpenMode", MySqlDbType.Int32, 11); mySqlParameter5.Value = (object)model.OpenMode; mySqlParameterArray[index5] = mySqlParameter5; int index6 = 5; MySqlParameter mySqlParameter6; if (model.Width.HasValue) { MySqlParameter mySqlParameter7 = new MySqlParameter("@Width", MySqlDbType.Int32, 11); mySqlParameter7.Value = (object)model.Width; mySqlParameter6 = mySqlParameter7; } else { mySqlParameter6 = new MySqlParameter("@Width", MySqlDbType.Int32, 11); mySqlParameter6.Value = (object)DBNull.Value; } mySqlParameterArray[index6] = mySqlParameter6; int index7 = 6; MySqlParameter mySqlParameter8; if (model.Height.HasValue) { MySqlParameter mySqlParameter7 = new MySqlParameter("@Height", MySqlDbType.Int32, 11); mySqlParameter7.Value = (object)model.Height; mySqlParameter8 = mySqlParameter7; } else { mySqlParameter8 = new MySqlParameter("@Height", MySqlDbType.Int32, 11); mySqlParameter8.Value = (object)DBNull.Value; } mySqlParameterArray[index7] = mySqlParameter8; int index8 = 7; MySqlParameter mySqlParameter9; if (model.Params != null) { MySqlParameter mySqlParameter7 = new MySqlParameter("@Params", MySqlDbType.LongText, -1); mySqlParameter7.Value = (object)model.Params; mySqlParameter9 = mySqlParameter7; } else { mySqlParameter9 = new MySqlParameter("@Params", MySqlDbType.LongText, -1); mySqlParameter9.Value = (object)DBNull.Value; } mySqlParameterArray[index8] = mySqlParameter9; int index9 = 8; MySqlParameter mySqlParameter10; if (model.Manager != null) { MySqlParameter mySqlParameter7 = new MySqlParameter("@Manager", MySqlDbType.LongText, -1); mySqlParameter7.Value = (object)model.Manager; mySqlParameter10 = mySqlParameter7; } else { mySqlParameter10 = new MySqlParameter("@Manager", MySqlDbType.LongText, -1); mySqlParameter10.Value = (object)DBNull.Value; } mySqlParameterArray[index9] = mySqlParameter10; int index10 = 9; MySqlParameter mySqlParameter11; if (model.Note != null) { MySqlParameter mySqlParameter7 = new MySqlParameter("@Note", MySqlDbType.LongText, -1); mySqlParameter7.Value = (object)model.Note; mySqlParameter11 = mySqlParameter7; } else { mySqlParameter11 = new MySqlParameter("@Note", MySqlDbType.LongText, -1); mySqlParameter11.Value = (object)DBNull.Value; } mySqlParameterArray[index10] = mySqlParameter11; int index11 = 10; MySqlParameter mySqlParameter12; if (model.Code != null) { MySqlParameter mySqlParameter7 = new MySqlParameter("@Code", MySqlDbType.VarChar, 50); mySqlParameter7.Value = (object)model.Code; mySqlParameter12 = mySqlParameter7; } else { mySqlParameter12 = new MySqlParameter("@Code", MySqlDbType.VarChar, 50); mySqlParameter12.Value = (object)DBNull.Value; } mySqlParameterArray[index11] = mySqlParameter12; int index12 = 11; MySqlParameter mySqlParameter13; if (model.Ico != null) { MySqlParameter mySqlParameter7 = new MySqlParameter("@Ico", MySqlDbType.Text, -1); mySqlParameter7.Value = (object)model.Ico; mySqlParameter13 = mySqlParameter7; } else { mySqlParameter13 = new MySqlParameter("@Ico", MySqlDbType.Text, -1); mySqlParameter13.Value = (object)DBNull.Value; } mySqlParameterArray[index12] = mySqlParameter13; int index13 = 12; MySqlParameter mySqlParameter14; if (model.Color != null) { MySqlParameter mySqlParameter7 = new MySqlParameter("@Color", MySqlDbType.VarChar, 50); mySqlParameter7.Value = (object)model.Color; mySqlParameter14 = mySqlParameter7; } else { mySqlParameter14 = new MySqlParameter("@Color", MySqlDbType.VarChar, 50); mySqlParameter14.Value = (object)DBNull.Value; } mySqlParameterArray[index13] = mySqlParameter14; MySqlParameter[] parameter = mySqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public ActionResult Edit(FormCollection collection) { string editID = Request.QueryString["id"]; string type = Request.QueryString["typeid"]; RoadFlow.Platform.AppLibrary bappLibrary = new RoadFlow.Platform.AppLibrary(); RoadFlow.Data.Model.AppLibrary appLibrary = null; if (editID.IsGuid()) { appLibrary = bappLibrary.Get(editID.ToGuid()); } bool isAdd = !editID.IsGuid(); string oldXML = string.Empty; if (appLibrary == null) { appLibrary = new RoadFlow.Data.Model.AppLibrary(); appLibrary.ID = Guid.NewGuid(); ViewBag.TypeOptions = new RoadFlow.Platform.AppLibrary().GetTypeOptions(type); ViewBag.OpenOptions = new RoadFlow.Platform.Dictionary().GetOptionsByCode("appopenmodel", value: ""); } else { oldXML = appLibrary.Serialize(); ViewBag.TypeOptions = new RoadFlow.Platform.AppLibrary().GetTypeOptions(appLibrary.Type.ToString()); ViewBag.OpenOptions = new RoadFlow.Platform.Dictionary().GetOptionsByCode("appopenmodel", value: appLibrary.OpenMode.ToString()); } if (collection != null) { string title = collection["title"]; string address = collection["address"]; string openModel = collection["openModel"]; string width = collection["width"]; string height = collection["height"]; string params1 = collection["Params"]; string note = collection["note"]; string useMember = collection["UseMember"]; type = collection["type"]; appLibrary.Address = address.Trim(); appLibrary.Height = height.ToIntOrNull(); appLibrary.Note = note; appLibrary.OpenMode = openModel.ToInt(); appLibrary.Params = params1; appLibrary.Title = title; appLibrary.Type = type.ToGuid(); appLibrary.Width = width.ToIntOrNull(); if (!useMember.IsNullOrEmpty()) { appLibrary.UseMember = useMember; } else { appLibrary.UseMember = null; } if (isAdd) { bappLibrary.Add(appLibrary); RoadFlow.Platform.Log.Add("添加了应用程序库", appLibrary.Serialize(), RoadFlow.Platform.Log.Types.角色应用); ViewBag.Script = "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } else { bappLibrary.Update(appLibrary); RoadFlow.Platform.Log.Add("修改了应用程序库", "", RoadFlow.Platform.Log.Types.角色应用, oldXML, appLibrary.Serialize()); ViewBag.Script = "alert('修改成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } bappLibrary.UpdateUseMemberCache(appLibrary.ID); bappLibrary.ClearCache(); new RoadFlow.Platform.RoleApp().ClearAllDataTableCache(); } return(View(appLibrary)); }
public string Publish() { string s = this.Request["html"]; string str1 = this.Request["name"]; string str2 = this.Request["att"]; string str3 = this.Request["id"]; string str4 = this.Request["formats"]; Guid test; if (!str3.IsGuid(out test) || str1.IsNullOrEmpty() || str2.IsNullOrEmpty()) { return("参数错误!"); } RoadFlow.Platform.WorkFlowForm workFlowForm = new RoadFlow.Platform.WorkFlowForm(); RoadFlow.Data.Model.WorkFlowForm model1 = workFlowForm.Get(test); if (model1 == null) { return("请先保存表单再发布!"); } string str5 = str3 + ".cshtml"; StringBuilder stringBuilder = new StringBuilder("@{\r\n"); JsonData jsonData = JsonMapper.ToObject(str2); stringBuilder.Append("\tstring FlowID = Request.QueryString[\"flowid\"];\r\n"); stringBuilder.Append("\tstring StepID = Request.QueryString[\"stepid\"];\r\n"); stringBuilder.Append("\tstring GroupID = Request.QueryString[\"groupid\"];\r\n"); stringBuilder.Append("\tstring TaskID = Request.QueryString[\"taskid\"];\r\n"); stringBuilder.Append("\tstring InstanceID = Request.QueryString[\"instanceid\"];\r\n"); stringBuilder.Append("\tstring DisplayModel = Request.QueryString[\"display\"] ?? \"0\";\r\n"); stringBuilder.AppendFormat("\tstring DBConnID = \"{0}\";\r\n", (object)jsonData["dbconn"].ToString()); stringBuilder.AppendFormat("\tstring DBTable = \"{0}\";\r\n", (object)jsonData["dbtable"].ToString()); stringBuilder.AppendFormat("\tstring DBTablePK = \"{0}\";\r\n", (object)jsonData["dbtablepk"].ToString()); stringBuilder.AppendFormat("\tstring DBTableTitle = \"{0}\";\r\n", (object)jsonData["dbtabletitle"].ToString()); stringBuilder.Append("\tif(InstanceID.IsNullOrEmpty()){InstanceID = Request.QueryString[\"instanceid1\"];}\r\n"); stringBuilder.Append("\tRoadFlow.Platform.Dictionary BDictionary = new RoadFlow.Platform.Dictionary();\r\n"); stringBuilder.Append("\tRoadFlow.Platform.WorkFlow BWorkFlow = new RoadFlow.Platform.WorkFlow();\r\n"); stringBuilder.Append("\tRoadFlow.Platform.WorkFlowTask BWorkFlowTask = new RoadFlow.Platform.WorkFlowTask();\r\n"); stringBuilder.Append("\tstring fieldStatus = BWorkFlow.GetFieldStatus(FlowID, StepID);\r\n"); stringBuilder.Append("\tLitJson.JsonData initData = BWorkFlow.GetFormData(DBConnID, DBTable, DBTablePK, InstanceID, fieldStatus, \"" + str4 + "\");\r\n"); stringBuilder.Append("\tstring TaskTitle = BWorkFlow.GetFromFieldData(initData, DBTable, DBTableTitle);\r\n"); stringBuilder.Append("}\r\n"); stringBuilder.Append("<link href=\"~/Scripts/FlowRun/Forms/flowform.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n"); stringBuilder.Append("<script src=\"~/Scripts/FlowRun/Forms/common.js\" type=\"text/javascript\" ></script>\r\n"); if (jsonData.ContainsKey("hasEditor") && "1" == jsonData["hasEditor"].ToString()) { stringBuilder.Append("<script src=\"~/Scripts/Ueditor/ueditor.config.js\" type=\"text/javascript\" ></script>\r\n"); stringBuilder.Append("<script src=\"~/Scripts/Ueditor/ueditor.all.min.js\" type=\"text/javascript\" ></script>\r\n"); stringBuilder.Append("<script src=\"~/Scripts/Ueditor/lang/zh-cn/zh-cn.js\" type=\"text/javascript\" ></script>\r\n"); stringBuilder.Append("<input type=\"hidden\" id=\"Form_HasUEditor\" name=\"Form_HasUEditor\" value=\"1\" />\r\n"); } string str6 = jsonData.ContainsKey("validatealerttype") ? jsonData["validatealerttype"].ToString() : "2"; stringBuilder.Append("<input type=\"hidden\" id=\"Form_ValidateAlertType\" name=\"Form_ValidateAlertType\" value=\"" + str6 + "\" />\r\n"); if (jsonData.ContainsKey("autotitle") && jsonData["autotitle"].ToString().ToLower() == "true") { stringBuilder.AppendFormat("<input type=\"hidden\" id=\"{0}\" name=\"{0}\" value=\"{1}\" />\r\n", (object)(jsonData["dbtable"].ToString() + "." + jsonData["dbtabletitle"].ToString()), (object)"@(TaskTitle.IsNullOrEmpty() ? BWorkFlow.GetAutoTaskTitle(FlowID, StepID, Request.QueryString[\"groupid\"]) : TaskTitle)"); } stringBuilder.AppendFormat("<input type=\"hidden\" id=\"Form_TitleField\" name=\"Form_TitleField\" value=\"{0}\" />\r\n", (object)(jsonData["dbtable"].ToString() + "." + jsonData["dbtabletitle"].ToString())); stringBuilder.AppendFormat("<input type=\"hidden\" id=\"Form_DBConnID\" name=\"Form_DBConnID\" value=\"{0}\" />\r\n", (object)jsonData["dbconn"].ToString()); stringBuilder.AppendFormat("<input type=\"hidden\" id=\"Form_DBTable\" name=\"Form_DBTable\" value=\"{0}\" />\r\n", (object)jsonData["dbtable"].ToString()); stringBuilder.AppendFormat("<input type=\"hidden\" id=\"Form_DBTablePk\" name=\"Form_DBTablePk\" value=\"{0}\" />\r\n", (object)jsonData["dbtablepk"].ToString()); stringBuilder.AppendFormat("<input type=\"hidden\" id=\"Form_DBTableTitle\" name=\"Form_DBTableTitle\" value=\"{0}\" />\r\n", (object)jsonData["dbtabletitle"].ToString()); stringBuilder.AppendFormat("<input type=\"hidden\" id=\"Form_AutoSaveData\" name=\"Form_AutoSaveData\" value=\"{0}\" />\r\n", (object)"1"); stringBuilder.AppendFormat("<textarea id=\"Form_DBTableTitleExpression\" name=\"Form_DBTableTitleExpression\" style=\"display:none;width:0;height:0;\">{0}</textarea>\r\n", jsonData.ContainsKey("dbtabletitle1") ? (object)jsonData["dbtabletitle1"].ToString() : (object)""); stringBuilder.Append("<script type=\"text/javascript\">\r\n"); stringBuilder.Append("\tvar initData = @Html.Raw(BWorkFlow.GetFormDataJsonString(initData));\r\n"); stringBuilder.Append("\tvar fieldStatus = \"1\"==\"@Request.QueryString[\"isreadonly\"]\" ? {} : @Html.Raw(fieldStatus);\r\n"); stringBuilder.Append("\tvar displayModel = '@DisplayModel';\r\n"); stringBuilder.Append("\t$(window).load(function (){\r\n"); stringBuilder.AppendFormat("\t\tformrun.initData(initData, \"{0}\", fieldStatus, displayModel);\r\n", (object)jsonData["dbtable"].ToString()); stringBuilder.Append("\t});\r\n"); stringBuilder.Append("</script>\r\n"); FileStream fileStream = File.Open(this.Server.MapPath("~/Views/WorkFlowFormDesigner/Forms/" + str5), FileMode.OpenOrCreate, FileAccess.Write, FileShare.None); fileStream.SetLength(0L); StreamWriter streamWriter = new StreamWriter((Stream)fileStream, Encoding.UTF8); streamWriter.Write(stringBuilder.ToString()); streamWriter.Write(this.Server.HtmlDecode(s)); streamWriter.Close(); fileStream.Close(); string str7 = JsonMapper.ToObject(model1.Attribute)["apptype"].ToString(); RoadFlow.Platform.AppLibrary appLibrary = new RoadFlow.Platform.AppLibrary(); RoadFlow.Data.Model.AppLibrary model2 = appLibrary.GetByCode(str3, true); bool flag = false; if (model2 == null) { model2 = new RoadFlow.Data.Model.AppLibrary(); model2.ID = Guid.NewGuid(); model2.Code = str3; flag = true; } model2.Address = "/Views/WorkFlowFormDesigner/Forms/" + str5; model2.Note = "流程表单"; model2.OpenMode = 0; model2.Params = ""; model2.Title = str1.Trim(); model2.Type = str7.IsGuid() ? str7.ToGuid() : new RoadFlow.Platform.Dictionary().GetIDByCode("FormTypes"); if (flag) { appLibrary.Add(model2); } else { appLibrary.Update(model2); } RoadFlow.Platform.Log.Add("发布了流程表单", model2.Serialize() + "内容:" + s, RoadFlow.Platform.Log.Types.流程相关, "", "", (RoadFlow.Data.Model.Users)null); model1.Status = 1; workFlowForm.Update(model1); return("发布成功!"); }