/// <summary> /// 将DataRedar转换为List /// </summary> private List <FoWoSoft.Data.Model.WorkFlowForm> DataReaderToList(SqlDataReader dataReader) { List <FoWoSoft.Data.Model.WorkFlowForm> List = new List <FoWoSoft.Data.Model.WorkFlowForm>(); FoWoSoft.Data.Model.WorkFlowForm model = null; while (dataReader.Read()) { model = new FoWoSoft.Data.Model.WorkFlowForm(); model.ID = dataReader.GetGuid(0); model.Name = dataReader.GetString(1); model.Type = dataReader.GetGuid(2); model.CreateUserID = dataReader.GetGuid(3); model.CreateUserName = dataReader.GetString(4); model.CreateTime = dataReader.GetDateTime(5); model.LastModifyTime = dataReader.GetDateTime(6); if (!dataReader.IsDBNull(7)) { model.Html = dataReader.GetString(7); } if (!dataReader.IsDBNull(8)) { model.SubTableJson = dataReader.GetString(8); } if (!dataReader.IsDBNull(9)) { model.EventsJson = dataReader.GetString(9); } if (!dataReader.IsDBNull(10)) { model.Attribute = dataReader.GetString(10); } model.Status = dataReader.GetInt32(11); List.Add(model); } return(List); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string html = context.Request["html"]; string name = context.Request["name"]; string att = context.Request["att"]; string id = context.Request["id"]; Guid gid; if (!id.IsGuid(out gid) || name.IsNullOrEmpty() || att.IsNullOrEmpty() || html.IsNullOrEmpty()) { context.Response.Write("参数错误!"); return; } FoWoSoft.Platform.WorkFlowForm WFF = new FoWoSoft.Platform.WorkFlowForm(); FoWoSoft.Data.Model.WorkFlowForm wff = WFF.Get(gid); if (wff == null) { context.Response.Write("未找到表单!"); return; } string fileName = id + ".aspx"; System.Text.StringBuilder serverScript = new System.Text.StringBuilder("<%@ Page Language=\"C#\"%>\r\n<%\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("\tFoWoSoft.Platform.Dictionary BDictionary = new FoWoSoft.Platform.Dictionary();\r\n"); serverScript.Append("\tFoWoSoft.Platform.WorkFlow BWorkFlow = new FoWoSoft.Platform.WorkFlow();\r\n"); serverScript.Append("\tFoWoSoft.Platform.WorkFlowTask BWorkFlowTask = new FoWoSoft.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/Forms/flowform.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n"); serverScript.Append("<script src=\"Scripts/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 = <%=BWorkFlow.GetFormDataJsonString(initData)%>;\r\n"); serverScript.Append("\tvar fieldStatus = \"1\"==\"<%=Request.QueryString[\"isreadonly\"]%>\"? {} : <%=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 = context.Server.MapPath("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(context.Server.HtmlDecode(html)); sw.Close(); stream.Close(); string attr = wff.Attribute; string appType = LitJson.JsonMapper.ToObject(attr)["apptype"].ToString(); FoWoSoft.Platform.AppLibrary App = new FoWoSoft.Platform.AppLibrary(); var app = App.GetByCode(id); bool isAdd = false; if (app == null) { app = new FoWoSoft.Data.Model.AppLibrary(); app.ID = Guid.NewGuid(); app.Code = id; isAdd = true; } app.Address = "/Platform/WorkFlowFormDesigner/Forms/" + fileName; app.Note = "流程表单"; app.OpenMode = 0; app.Params = ""; app.Title = name.Trim(); app.Type = appType.IsGuid() ? appType.ToGuid() : new FoWoSoft.Platform.Dictionary().GetIDByCode("FormTypes"); if (isAdd) { App.Add(app); } else { App.Update(app); } FoWoSoft.Platform.Log.Add("发布了流程表单", app.Serialize() + "内容:" + html, FoWoSoft.Platform.Log.Types.流程相关); wff.Status = 1; WFF.Update(wff); context.Response.Write("发布成功!"); }
/// <summary> /// 更新 /// </summary> public int Update(FoWoSoft.Data.Model.WorkFlowForm model) { return(dataWorkFlowForm.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(FoWoSoft.Data.Model.WorkFlowForm model) { return(dataWorkFlowForm.Add(model)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string html = context.Request["html"]; string name = context.Request["name"]; string att = context.Request["att"]; string id = context.Request["id"]; string type = context.Request["type"]; string subtable = context.Request["subtable"]; string formEvents = context.Request["formEvents"]; if (name.IsNullOrEmpty()) { context.Response.Write("表单名称不能为空!"); return; } Guid formID; if (!id.IsGuid(out formID)) { context.Response.Write("表单ID无效!"); return; } FoWoSoft.Platform.WorkFlowForm WFF = new FoWoSoft.Platform.WorkFlowForm(); FoWoSoft.Data.Model.WorkFlowForm wff = WFF.Get(formID); bool isAdd = false; string oldXML = string.Empty; if (wff == null) { wff = new FoWoSoft.Data.Model.WorkFlowForm(); wff.ID = formID; wff.CreateUserID = FoWoSoft.Platform.Users.CurrentUserID; wff.CreateUserName = FoWoSoft.Platform.Users.CurrentUserName; wff.CreateTime = FoWoSoft.Utility.DateTimeNew.Now; wff.Status = 0; isAdd = true; } else { oldXML = wff.Serialize(); } wff.Type = type.ToGuid(); wff.Attribute = att; wff.Html = html; wff.LastModifyTime = FoWoSoft.Utility.DateTimeNew.Now; wff.Name = name; wff.SubTableJson = subtable; wff.EventsJson = formEvents; if (isAdd) { WFF.Add(wff); FoWoSoft.Platform.Log.Add("添加了流程表单", wff.Serialize(), FoWoSoft.Platform.Log.Types.流程相关); } else { WFF.Update(wff); FoWoSoft.Platform.Log.Add("修改了流程表单", "", FoWoSoft.Platform.Log.Types.流程相关, oldXML, wff.Serialize()); } context.Response.Write("保存成功!"); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">FoWoSoft.Data.Model.WorkFlowForm实体类</param> public int Update(FoWoSoft.Data.Model.WorkFlowForm model) { string sql = @"UPDATE WorkFlowForm SET Name=@Name,Type=@Type,CreateUserID=@CreateUserID,CreateUserName=@CreateUserName,CreateTime=@CreateTime,LastModifyTime=@LastModifyTime,Html=@Html,SubTableJson=@SubTableJson,EventsJson=@EventsJson,Attribute=@Attribute,Status=@Status WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Name", SqlDbType.NVarChar, 1000) { Value = model.Name }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.CreateUserID }, new SqlParameter("@CreateUserName", SqlDbType.NVarChar, 100) { Value = model.CreateUserName }, new SqlParameter("@CreateTime", SqlDbType.DateTime, 8) { Value = model.CreateTime }, new SqlParameter("@LastModifyTime", SqlDbType.DateTime, 8) { Value = model.LastModifyTime }, model.Html == null ? new SqlParameter("@Html", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@Html", SqlDbType.Text, -1) { Value = model.Html }, model.SubTableJson == null ? new SqlParameter("@SubTableJson", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@SubTableJson", SqlDbType.Text, -1) { Value = model.SubTableJson }, model.EventsJson == null ? new SqlParameter("@EventsJson", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@EventsJson", SqlDbType.Text, -1) { Value = model.EventsJson }, model.Attribute == null ? new SqlParameter("@Attribute", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Attribute", SqlDbType.VarChar, -1) { Value = model.Attribute }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">FoWoSoft.Data.Model.WorkFlowForm实体类</param> /// <returns>操作所影响的行数</returns> public int Add(FoWoSoft.Data.Model.WorkFlowForm model) { string sql = @"INSERT INTO WorkFlowForm (ID,Name,Type,CreateUserID,CreateUserName,CreateTime,LastModifyTime,Html,SubTableJson,EventsJson,Attribute,Status) VALUES(@ID,@Name,@Type,@CreateUserID,@CreateUserName,@CreateTime,@LastModifyTime,@Html,@SubTableJson,@EventsJson,@Attribute,@Status)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Name", SqlDbType.NVarChar, 1000) { Value = model.Name }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.CreateUserID }, new SqlParameter("@CreateUserName", SqlDbType.NVarChar, 100) { Value = model.CreateUserName }, new SqlParameter("@CreateTime", SqlDbType.DateTime, 8) { Value = model.CreateTime }, new SqlParameter("@LastModifyTime", SqlDbType.DateTime, 8) { Value = model.LastModifyTime }, model.Html == null ? new SqlParameter("@Html", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@Html", SqlDbType.Text, -1) { Value = model.Html }, model.SubTableJson == null ? new SqlParameter("@SubTableJson", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@SubTableJson", SqlDbType.Text, -1) { Value = model.SubTableJson }, model.EventsJson == null ? new SqlParameter("@EventsJson", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@EventsJson", SqlDbType.Text, -1) { Value = model.EventsJson }, model.Attribute == null ? new SqlParameter("@Attribute", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Attribute", SqlDbType.VarChar, -1) { Value = model.Attribute }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status } }; return(dbHelper.Execute(sql, parameters)); }