/// <summary> /// 得到流程运行时地址 /// </summary> /// <param name="app"></param> /// <returns></returns> public string GetFlowRunAddress(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()); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <Data.Model.AppLibrary> DataReaderToList(SqlDataReader dataReader) { List <Data.Model.AppLibrary> List = new List <Data.Model.AppLibrary>(); Data.Model.AppLibrary model = null; while (dataReader.Read()) { model = new Data.Model.AppLibrary(); model.ID = dataReader.GetGuid(0); model.Title = dataReader.GetString(1); model.Address = dataReader.GetString(2); model.Type = dataReader.GetGuid(3); 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); } if (!dataReader.IsDBNull(11)) { model.UseMember = dataReader.GetString(11); } List.Add(model); } return(List); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">Data.Model.AppLibrary实体类</param> /// <returns>操作所影响的行数</returns> public int Add(Data.Model.AppLibrary model) { string sql = @"INSERT INTO AppLibrary (ID,Title,Address,Type,OpenMode,Width,Height,Params,Manager,Note,Code,UseMember) VALUES(:ID,:Title,:Address,:Type,:OpenMode,:Width,:Height,:Params,:Manager,:Note,:Code,:UseMember)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Char, 36) { 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.Char, 36) { 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.Clob) { Value = DBNull.Value } : new OracleParameter(":UseMember", OracleDbType.Clob) { Value = model.UseMember } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">Data.Model.AppLibrary实体类</param> public int Update(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.Char, 36) { 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.Clob) { Value = DBNull.Value } : new OracleParameter(":UseMember", OracleDbType.Clob) { Value = model.UseMember }, new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">Data.Model.AppLibrary实体类</param> /// <returns>操作所影响的行数</returns> public int Add(Data.Model.AppLibrary model) { string sql = @"INSERT INTO AppLibrary (ID,Title,Address,Type,OpenMode,Width,Height,Params,Manager,Note,Code,UseMember) VALUES(@ID,@Title,@Address,@Type,@OpenMode,@Width,@Height,@Params,@Manager,@Note,@Code,@UseMember)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Title", SqlDbType.NVarChar, 510) { Value = model.Title }, new SqlParameter("@Address", SqlDbType.VarChar, 200) { Value = model.Address }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, new SqlParameter("@OpenMode", SqlDbType.Int, -1) { Value = model.OpenMode }, model.Width == null ? new SqlParameter("@Width", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@Width", SqlDbType.Int, -1) { Value = model.Width }, model.Height == null ? new SqlParameter("@Height", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@Height", SqlDbType.Int, -1) { Value = model.Height }, model.Params == null ? new SqlParameter("@Params", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Params", SqlDbType.VarChar, -1) { Value = model.Params }, model.Manager == null ? new SqlParameter("@Manager", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Manager", SqlDbType.VarChar, -1) { Value = model.Manager }, model.Note == null ? new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = model.Note }, model.Code == null ? new SqlParameter("@Code", SqlDbType.VarChar, 50) { Value = DBNull.Value } : new SqlParameter("@Code", SqlDbType.VarChar, 50) { Value = model.Code }, model.UseMember == null ? new SqlParameter("@UseMember", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@UseMember", SqlDbType.VarChar, -1) { Value = model.UseMember } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">Data.Model.AppLibrary实体类</param> public int Update(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" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Title", SqlDbType.NVarChar, 510) { Value = model.Title }, new SqlParameter("@Address", SqlDbType.VarChar, 200) { Value = model.Address }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, new SqlParameter("@OpenMode", SqlDbType.Int, -1) { Value = model.OpenMode }, model.Width == null ? new SqlParameter("@Width", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@Width", SqlDbType.Int, -1) { Value = model.Width }, model.Height == null ? new SqlParameter("@Height", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@Height", SqlDbType.Int, -1) { Value = model.Height }, model.Params == null ? new SqlParameter("@Params", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Params", SqlDbType.VarChar, -1) { Value = model.Params }, model.Manager == null ? new SqlParameter("@Manager", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Manager", SqlDbType.VarChar, -1) { Value = model.Manager }, model.Note == null ? new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = model.Note }, model.Code == null ? new SqlParameter("@Code", SqlDbType.VarChar, 50) { Value = DBNull.Value } : new SqlParameter("@Code", SqlDbType.VarChar, 50) { Value = model.Code }, model.UseMember == null ? new SqlParameter("@UseMember", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@UseMember", SqlDbType.VarChar, -1) { Value = model.UseMember }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
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("参数错误!"); } Business.Platform.WorkFlowForm WFF = new Business.Platform.WorkFlowForm(); 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("\tBusiness.Platform.Dictionary BDictionary = new Business.Platform.Dictionary();\r\n"); serverScript.Append("\tBusiness.Platform.WorkFlow BWorkFlow = new Business.Platform.WorkFlow();\r\n"); serverScript.Append("\tBusiness.Platform.WorkFlowTask BWorkFlowTask = new Business.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 = @Html.Raw(fieldStatus);\r\n"); serverScript.Append("\tvar displayModel = '@DisplayModel';\r\n"); serverScript.Append("\t$(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(); Business.Platform.AppLibrary App = new Business.Platform.AppLibrary(); var app = App.GetByCode(id); bool isAdd = false; if (app == null) { app = new 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 Business.Platform.Dictionary().GetIDByCode("FormTypes"); if (isAdd) { App.Add(app); } else { App.Update(app); } Business.Platform.Log.Add("发布了流程表单", app.Serialize() + "内容:" + html, Business.Platform.Log.Types.流程相关); wff.Status = 1; WFF.Update(wff); return("发布成功!"); }
/// <summary> /// 更新 /// </summary> public int Update(Data.Model.AppLibrary model) { return(dataAppLibrary.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(Data.Model.AppLibrary model) { return(dataAppLibrary.Add(model)); }
public ActionResult Edit(FormCollection collection) { string editID = Request.QueryString["id"]; string type = Request.QueryString["typeid"]; Business.Platform.AppLibrary bappLibrary = new Business.Platform.AppLibrary(); 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 Data.Model.AppLibrary(); appLibrary.ID = Guid.NewGuid(); ViewBag.TypeOptions = new Business.Platform.AppLibrary().GetTypeOptions(type); ViewBag.OpenOptions = new Business.Platform.Dictionary().GetOptionsByCode("appopenmodel", value: ""); } else { oldXML = appLibrary.Serialize(); ViewBag.TypeOptions = new Business.Platform.AppLibrary().GetTypeOptions(appLibrary.Type.ToString()); ViewBag.OpenOptions = new Business.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"]; 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 (isAdd) { bappLibrary.Add(appLibrary); Business.Platform.Log.Add("添加了应用程序库", appLibrary.Serialize(), Business.Platform.Log.Types.角色应用); ViewBag.Script = "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } else { bappLibrary.Update(appLibrary); Business.Platform.Log.Add("修改了应用程序库", "", Business.Platform.Log.Types.角色应用, oldXML, appLibrary.Serialize()); ViewBag.Script = "alert('修改成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } bappLibrary.ClearCache(); new Business.Platform.RoleApp().ClearAllDataTableCache(); } return(View(appLibrary)); }