private List <RoadFlow.Data.Model.WorkFlowForm> DataReaderToList(SqlDataReader dataReader) { List <RoadFlow.Data.Model.WorkFlowForm> workFlowFormList = new List <RoadFlow.Data.Model.WorkFlowForm>(); while (dataReader.Read()) { RoadFlow.Data.Model.WorkFlowForm workFlowForm = new RoadFlow.Data.Model.WorkFlowForm(); workFlowForm.ID = dataReader.GetGuid(0); workFlowForm.Name = dataReader.GetString(1); workFlowForm.Type = dataReader.GetGuid(2); workFlowForm.CreateUserID = dataReader.GetGuid(3); workFlowForm.CreateUserName = dataReader.GetString(4); workFlowForm.CreateTime = dataReader.GetDateTime(5); workFlowForm.LastModifyTime = dataReader.GetDateTime(6); if (!dataReader.IsDBNull(7)) { workFlowForm.Html = dataReader.GetString(7); } if (!dataReader.IsDBNull(8)) { workFlowForm.SubTableJson = dataReader.GetString(8); } if (!dataReader.IsDBNull(9)) { workFlowForm.EventsJson = dataReader.GetString(9); } if (!dataReader.IsDBNull(10)) { workFlowForm.Attribute = dataReader.GetString(10); } workFlowForm.Status = dataReader.GetInt32(11); workFlowFormList.Add(workFlowForm); } return(workFlowFormList); }
public string Save() { string str1 = this.Request["html"]; string str2 = this.Request["name"]; string str3 = this.Request["att"]; string str4 = this.Request["id"]; string str5 = this.Request["type"]; string str6 = this.Request["subtable"]; string str7 = this.Request["formEvents"]; if (str2.IsNullOrEmpty()) { return("表单名称不能为空!"); } Guid test; if (!str4.IsGuid(out test)) { return("表单ID无效!"); } RoadFlow.Platform.WorkFlowForm workFlowForm = new RoadFlow.Platform.WorkFlowForm(); RoadFlow.Data.Model.WorkFlowForm model = workFlowForm.Get(test); bool flag = false; string oldXML = string.Empty; if (model == null) { model = new RoadFlow.Data.Model.WorkFlowForm(); model.ID = test; model.CreateUserID = RoadFlow.Platform.Users.CurrentUserID; model.CreateUserName = RoadFlow.Platform.Users.CurrentUserName; model.CreateTime = DateTimeNew.Now; model.Status = 0; flag = true; } else { oldXML = model.Serialize(); } model.Attribute = str3; model.Html = str1; model.LastModifyTime = DateTimeNew.Now; model.Name = str2; model.Type = str5.ToGuid(); model.SubTableJson = str6; model.EventsJson = str7; if (flag) { workFlowForm.Add(model); RoadFlow.Platform.Log.Add("添加了流程表单", model.Serialize(), RoadFlow.Platform.Log.Types.流程相关, "", "", (RoadFlow.Data.Model.Users)null); } else { workFlowForm.Update(model); RoadFlow.Platform.Log.Add("修改了流程表单", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, model.Serialize(), (RoadFlow.Data.Model.Users)null); } return("保存成功!"); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <RoadFlow.Data.Model.WorkFlowForm> DataReaderToList(OracleDataReader dataReader) { List <RoadFlow.Data.Model.WorkFlowForm> List = new List <RoadFlow.Data.Model.WorkFlowForm>(); RoadFlow.Data.Model.WorkFlowForm model = null; while (dataReader.Read()) { model = new RoadFlow.Data.Model.WorkFlowForm(); model.ID = dataReader.GetString(0).ToGuid(); model.Name = dataReader.GetString(1); model.Type = dataReader.GetString(2).ToGuid(); model.CreateUserID = dataReader.GetString(3).ToGuid(); 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 int Add(RoadFlow.Data.Model.WorkFlowForm model) { string sql = "INSERT INTO WorkFlowForm\r\n\t\t\t\t(ID,Name,Type,CreateUserID,CreateUserName,CreateTime,LastModifyTime,Html,SubTableJson,EventsJson,Attribute,Status) \r\n\t\t\t\tVALUES(@ID,@Name,@Type,@CreateUserID,@CreateUserName,@CreateTime,@LastModifyTime,@Html,@SubTableJson,@EventsJson,@Attribute,@Status)"; SqlParameter[] sqlParameterArray = new SqlParameter[12]; 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("@Name", SqlDbType.NVarChar, 1000); sqlParameter2.Value = (object)model.Name; sqlParameterArray[index2] = sqlParameter2; int index3 = 2; SqlParameter sqlParameter3 = new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1); sqlParameter3.Value = (object)model.Type; sqlParameterArray[index3] = sqlParameter3; int index4 = 3; SqlParameter sqlParameter4 = new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1); sqlParameter4.Value = (object)model.CreateUserID; sqlParameterArray[index4] = sqlParameter4; int index5 = 4; SqlParameter sqlParameter5 = new SqlParameter("@CreateUserName", SqlDbType.NVarChar, 100); sqlParameter5.Value = (object)model.CreateUserName; sqlParameterArray[index5] = sqlParameter5; int index6 = 5; SqlParameter sqlParameter6 = new SqlParameter("@CreateTime", SqlDbType.DateTime, 8); sqlParameter6.Value = (object)model.CreateTime; sqlParameterArray[index6] = sqlParameter6; int index7 = 6; SqlParameter sqlParameter7 = new SqlParameter("@LastModifyTime", SqlDbType.DateTime, 8); sqlParameter7.Value = (object)model.LastModifyTime; sqlParameterArray[index7] = sqlParameter7; int index8 = 7; SqlParameter sqlParameter8; if (model.Html != null) { SqlParameter sqlParameter9 = new SqlParameter("@Html", SqlDbType.Text, -1); sqlParameter9.Value = (object)model.Html; sqlParameter8 = sqlParameter9; } else { sqlParameter8 = new SqlParameter("@Html", SqlDbType.Text, -1); sqlParameter8.Value = (object)DBNull.Value; } sqlParameterArray[index8] = sqlParameter8; int index9 = 8; SqlParameter sqlParameter10; if (model.SubTableJson != null) { SqlParameter sqlParameter9 = new SqlParameter("@SubTableJson", SqlDbType.Text, -1); sqlParameter9.Value = (object)model.SubTableJson; sqlParameter10 = sqlParameter9; } else { sqlParameter10 = new SqlParameter("@SubTableJson", SqlDbType.Text, -1); sqlParameter10.Value = (object)DBNull.Value; } sqlParameterArray[index9] = sqlParameter10; int index10 = 9; SqlParameter sqlParameter11; if (model.EventsJson != null) { SqlParameter sqlParameter9 = new SqlParameter("@EventsJson", SqlDbType.Text, -1); sqlParameter9.Value = (object)model.EventsJson; sqlParameter11 = sqlParameter9; } else { sqlParameter11 = new SqlParameter("@EventsJson", SqlDbType.Text, -1); sqlParameter11.Value = (object)DBNull.Value; } sqlParameterArray[index10] = sqlParameter11; int index11 = 10; SqlParameter sqlParameter12; if (model.Attribute != null) { SqlParameter sqlParameter9 = new SqlParameter("@Attribute", SqlDbType.VarChar, -1); sqlParameter9.Value = (object)model.Attribute; sqlParameter12 = sqlParameter9; } else { sqlParameter12 = new SqlParameter("@Attribute", SqlDbType.VarChar, -1); sqlParameter12.Value = (object)DBNull.Value; } sqlParameterArray[index11] = sqlParameter12; int index12 = 11; SqlParameter sqlParameter13 = new SqlParameter("@Status", SqlDbType.Int, -1); sqlParameter13.Value = (object)model.Status; sqlParameterArray[index12] = sqlParameter13; SqlParameter[] parameter = sqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
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("\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 = @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()); html = HttpUtility.HtmlDecode(html); html = html.Replace("+", "%2B"); sw.Write(HttpUtility.UrlDecode(html)); sw.Close(); stream.Close(); string attr = wff.Attribute; string appType = LitJson.JsonMapper.ToObject(attr)["apptype"].ToString(); RoadFlow.Platform.AppLibraryBLL App = new RoadFlow.Platform.AppLibraryBLL(); var app = App.GetByCode(id); bool isAdd = false; if (app == null) { app = new RoadFlow.Data.Model.AppLibraryModel(); 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.Convert <Guid>() : new RoadFlow.Platform.DictionaryBLL().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 string Save() { string html = Request["html"]; string name = Request["name"]; string att = Request["att"]; string id = Request["id"]; string type = Request["type"]; string subtable = Request["subtable"]; string formEvents = Request["formEvents"]; if (name.IsNullOrEmpty()) { return("表单名称不能为空!"); } Guid formID; if (!id.IsGuid(out formID)) { return("表单ID无效!"); } RoadFlow.Platform.WorkFlowForm WFF = new RoadFlow.Platform.WorkFlowForm(); RoadFlow.Data.Model.WorkFlowForm wff = WFF.Get(formID); bool isAdd = false; string oldXML = string.Empty; if (wff == null) { wff = new RoadFlow.Data.Model.WorkFlowForm(); wff.ID = formID; wff.Type = type.Convert <Guid>(); wff.CreateUserID = RoadFlow.Platform.UsersBLL.CurrentUserID; wff.CreateUserName = RoadFlow.Platform.UsersBLL.CurrentUserName; wff.CreateTime = DateTime.Now; wff.Status = 0; isAdd = true; } else { oldXML = wff.Serialize(); } wff.Attribute = att; wff.Html = html; wff.LastModifyTime = DateTime.Now; wff.Name = name; wff.SubTableJson = subtable; wff.EventsJson = formEvents; if (isAdd) { WFF.Add(wff); RoadFlow.Platform.Log.Add("添加了流程表单", wff.Serialize(), RoadFlow.Platform.Log.Types.流程相关); } else { WFF.Update(wff); RoadFlow.Platform.Log.Add("修改了流程表单", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, wff.Serialize()); } return("保存成功!"); }
/// <summary> /// 更新 /// </summary> public int Update(RoadFlow.Data.Model.WorkFlowForm model) { return(dataWorkFlowForm.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(RoadFlow.Data.Model.WorkFlowForm model) { return(dataWorkFlowForm.Add(model)); }
public int Add(RoadFlow.Data.Model.WorkFlowForm model) { string sql = "INSERT INTO workflowform\r\n\t\t\t\t(ID,Name,Type,CreateUserID,CreateUserName,CreateTime,LastModifyTime,Html,SubTableJson,EventsJson,Attribute,Status) \r\n\t\t\t\tVALUES(@ID,@Name,@Type,@CreateUserID,@CreateUserName,@CreateTime,@LastModifyTime,@Html,@SubTableJson,@EventsJson,@Attribute,@Status)"; MySqlParameter[] mySqlParameterArray = new MySqlParameter[12]; 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("@Name", MySqlDbType.Text, -1); mySqlParameter2.Value = (object)model.Name; mySqlParameterArray[index2] = mySqlParameter2; int index3 = 2; MySqlParameter mySqlParameter3 = new MySqlParameter("@Type", MySqlDbType.VarChar, 36); mySqlParameter3.Value = (object)model.Type; mySqlParameterArray[index3] = mySqlParameter3; int index4 = 3; MySqlParameter mySqlParameter4 = new MySqlParameter("@CreateUserID", MySqlDbType.VarChar, 36); mySqlParameter4.Value = (object)model.CreateUserID; mySqlParameterArray[index4] = mySqlParameter4; int index5 = 4; MySqlParameter mySqlParameter5 = new MySqlParameter("@CreateUserName", MySqlDbType.VarChar, 50); mySqlParameter5.Value = (object)model.CreateUserName; mySqlParameterArray[index5] = mySqlParameter5; int index6 = 5; MySqlParameter mySqlParameter6 = new MySqlParameter("@CreateTime", MySqlDbType.DateTime, -1); mySqlParameter6.Value = (object)model.CreateTime; mySqlParameterArray[index6] = mySqlParameter6; int index7 = 6; MySqlParameter mySqlParameter7 = new MySqlParameter("@LastModifyTime", MySqlDbType.DateTime, -1); mySqlParameter7.Value = (object)model.LastModifyTime; mySqlParameterArray[index7] = mySqlParameter7; int index8 = 7; MySqlParameter mySqlParameter8; if (model.Html != null) { MySqlParameter mySqlParameter9 = new MySqlParameter("@Html", MySqlDbType.LongText, -1); mySqlParameter9.Value = (object)model.Html; mySqlParameter8 = mySqlParameter9; } else { mySqlParameter8 = new MySqlParameter("@Html", MySqlDbType.LongText, -1); mySqlParameter8.Value = (object)DBNull.Value; } mySqlParameterArray[index8] = mySqlParameter8; int index9 = 8; MySqlParameter mySqlParameter10; if (model.SubTableJson != null) { MySqlParameter mySqlParameter9 = new MySqlParameter("@SubTableJson", MySqlDbType.LongText, -1); mySqlParameter9.Value = (object)model.SubTableJson; mySqlParameter10 = mySqlParameter9; } else { mySqlParameter10 = new MySqlParameter("@SubTableJson", MySqlDbType.LongText, -1); mySqlParameter10.Value = (object)DBNull.Value; } mySqlParameterArray[index9] = mySqlParameter10; int index10 = 9; MySqlParameter mySqlParameter11; if (model.EventsJson != null) { MySqlParameter mySqlParameter9 = new MySqlParameter("@EventsJson", MySqlDbType.LongText, -1); mySqlParameter9.Value = (object)model.EventsJson; mySqlParameter11 = mySqlParameter9; } else { mySqlParameter11 = new MySqlParameter("@EventsJson", MySqlDbType.LongText, -1); mySqlParameter11.Value = (object)DBNull.Value; } mySqlParameterArray[index10] = mySqlParameter11; int index11 = 10; MySqlParameter mySqlParameter12; if (model.Attribute != null) { MySqlParameter mySqlParameter9 = new MySqlParameter("@Attribute", MySqlDbType.LongText, -1); mySqlParameter9.Value = (object)model.Attribute; mySqlParameter12 = mySqlParameter9; } else { mySqlParameter12 = new MySqlParameter("@Attribute", MySqlDbType.LongText, -1); mySqlParameter12.Value = (object)DBNull.Value; } mySqlParameterArray[index11] = mySqlParameter12; int index12 = 11; MySqlParameter mySqlParameter13 = new MySqlParameter("@Status", MySqlDbType.Int32, 11); mySqlParameter13.Value = (object)model.Status; mySqlParameterArray[index12] = mySqlParameter13; MySqlParameter[] parameter = mySqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
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; } RoadFlow.Platform.WorkFlowForm WFF = new RoadFlow.Platform.WorkFlowForm(); RoadFlow.Data.Model.WorkFlowForm wff = WFF.Get(formID); bool isAdd = false; string oldXML = string.Empty; if (wff == null) { wff = new RoadFlow.Data.Model.WorkFlowForm(); wff.ID = formID; wff.CreateUserID = RoadFlow.Platform.Users.CurrentUserID; wff.CreateUserName = RoadFlow.Platform.Users.CurrentUserName; wff.CreateTime = RoadFlow.Utility.DateTimeNew.Now; wff.Status = 0; isAdd = true; } else { oldXML = wff.Serialize(); } wff.Type = type.ToGuid(); wff.Attribute = att; wff.Html = html; wff.LastModifyTime = RoadFlow.Utility.DateTimeNew.Now; wff.Name = name; wff.SubTableJson = subtable; wff.EventsJson = formEvents; if (isAdd) { WFF.Add(wff); RoadFlow.Platform.Log.Add("添加了流程表单", wff.Serialize(), RoadFlow.Platform.Log.Types.流程相关); } else { WFF.Update(wff); RoadFlow.Platform.Log.Add("修改了流程表单", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, wff.Serialize()); } context.Response.Write("保存成功!"); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.WorkFlowForm实体类</param> public int Update(RoadFlow.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" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":Name", OracleDbType.NVarchar2, 1000) { Value = model.Name }, new OracleParameter(":Type", OracleDbType.Varchar2, 40) { Value = model.Type }, new OracleParameter(":CreateUserID", OracleDbType.Varchar2, 40) { Value = model.CreateUserID }, new OracleParameter(":CreateUserName", OracleDbType.NVarchar2, 100) { Value = model.CreateUserName }, new OracleParameter(":CreateTime", OracleDbType.Date, 8) { Value = model.CreateTime }, new OracleParameter(":LastModifyTime", OracleDbType.Date, 8) { Value = model.LastModifyTime }, model.Html == null ? new OracleParameter(":Html", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Html", OracleDbType.Clob) { Value = model.Html }, model.SubTableJson == null ? new OracleParameter(":SubTableJson", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":SubTableJson", OracleDbType.Clob) { Value = model.SubTableJson }, model.EventsJson == null ? new OracleParameter(":EventsJson", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":EventsJson", OracleDbType.Clob) { Value = model.EventsJson }, model.Attribute == null ? new OracleParameter(":Attribute", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Attribute", OracleDbType.Clob) { Value = model.Attribute }, new OracleParameter(":Status", OracleDbType.Int32) { Value = model.Status }, new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.WorkFlowForm实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.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)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID }, new OracleParameter(":Name", OracleDbType.NVarchar2, 1000) { Value = model.Name }, new OracleParameter(":Type", OracleDbType.Varchar2, 40) { Value = model.Type }, new OracleParameter(":CreateUserID", OracleDbType.Varchar2, 40) { Value = model.CreateUserID }, new OracleParameter(":CreateUserName", OracleDbType.NVarchar2, 100) { Value = model.CreateUserName }, new OracleParameter(":CreateTime", OracleDbType.Date, 8) { Value = model.CreateTime }, new OracleParameter(":LastModifyTime", OracleDbType.Date, 8) { Value = model.LastModifyTime }, model.Html == null ? new OracleParameter(":Html", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Html", OracleDbType.Clob) { Value = model.Html }, model.SubTableJson == null ? new OracleParameter(":SubTableJson", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":SubTableJson", OracleDbType.Clob) { Value = model.SubTableJson }, model.EventsJson == null ? new OracleParameter(":EventsJson", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":EventsJson", OracleDbType.Clob) { Value = model.EventsJson }, model.Attribute == null ? new OracleParameter(":Attribute", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Attribute", OracleDbType.Clob) { Value = model.Attribute }, new OracleParameter(":Status", OracleDbType.Int32) { Value = model.Status } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.WorkFlowForm实体类</param> public int Update(RoadFlow.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">RoadFlow.Data.Model.WorkFlowForm实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.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)); }
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("发布成功!"); }
public int Add(RoadFlow.Data.Model.WorkFlowForm model) { string sql = "INSERT INTO WorkFlowForm\r\n\t\t\t\t(ID,Name,Type,CreateUserID,CreateUserName,CreateTime,LastModifyTime,Html,SubTableJson,EventsJson,Attribute,Status) \r\n\t\t\t\tVALUES(:ID,:Name,:Type,:CreateUserID,:CreateUserName,:CreateTime,:LastModifyTime,:Html,:SubTableJson,:EventsJson,:Attribute,:Status)"; OracleParameter[] oracleParameterArray = new OracleParameter[12]; 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(":Name", OracleDbType.NVarchar2, 1000); oracleParameter2.Value = (object)model.Name; oracleParameterArray[index2] = oracleParameter2; int index3 = 2; OracleParameter oracleParameter3 = new OracleParameter(":Type", OracleDbType.Varchar2, 40); oracleParameter3.Value = (object)model.Type; oracleParameterArray[index3] = oracleParameter3; int index4 = 3; OracleParameter oracleParameter4 = new OracleParameter(":CreateUserID", OracleDbType.Varchar2, 40); oracleParameter4.Value = (object)model.CreateUserID; oracleParameterArray[index4] = oracleParameter4; int index5 = 4; OracleParameter oracleParameter5 = new OracleParameter(":CreateUserName", OracleDbType.NVarchar2, 100); oracleParameter5.Value = (object)model.CreateUserName; oracleParameterArray[index5] = oracleParameter5; int index6 = 5; OracleParameter oracleParameter6 = new OracleParameter(":CreateTime", OracleDbType.Date, 8); oracleParameter6.Value = (object)model.CreateTime; oracleParameterArray[index6] = oracleParameter6; int index7 = 6; OracleParameter oracleParameter7 = new OracleParameter(":LastModifyTime", OracleDbType.Date, 8); oracleParameter7.Value = (object)model.LastModifyTime; oracleParameterArray[index7] = oracleParameter7; int index8 = 7; OracleParameter oracleParameter8; if (model.Html != null) { OracleParameter oracleParameter9 = new OracleParameter(":Html", OracleDbType.Clob); oracleParameter9.Value = (object)model.Html; oracleParameter8 = oracleParameter9; } else { oracleParameter8 = new OracleParameter(":Html", OracleDbType.Clob); oracleParameter8.Value = (object)DBNull.Value; } oracleParameterArray[index8] = oracleParameter8; int index9 = 8; OracleParameter oracleParameter10; if (model.SubTableJson != null) { OracleParameter oracleParameter9 = new OracleParameter(":SubTableJson", OracleDbType.Clob); oracleParameter9.Value = (object)model.SubTableJson; oracleParameter10 = oracleParameter9; } else { oracleParameter10 = new OracleParameter(":SubTableJson", OracleDbType.Clob); oracleParameter10.Value = (object)DBNull.Value; } oracleParameterArray[index9] = oracleParameter10; int index10 = 9; OracleParameter oracleParameter11; if (model.EventsJson != null) { OracleParameter oracleParameter9 = new OracleParameter(":EventsJson", OracleDbType.Clob); oracleParameter9.Value = (object)model.EventsJson; oracleParameter11 = oracleParameter9; } else { oracleParameter11 = new OracleParameter(":EventsJson", OracleDbType.Clob); oracleParameter11.Value = (object)DBNull.Value; } oracleParameterArray[index10] = oracleParameter11; int index11 = 10; OracleParameter oracleParameter12; if (model.Attribute != null) { OracleParameter oracleParameter9 = new OracleParameter(":Attribute", OracleDbType.Clob); oracleParameter9.Value = (object)model.Attribute; oracleParameter12 = oracleParameter9; } else { oracleParameter12 = new OracleParameter(":Attribute", OracleDbType.Clob); oracleParameter12.Value = (object)DBNull.Value; } oracleParameterArray[index11] = oracleParameter12; int index12 = 11; OracleParameter oracleParameter13 = new OracleParameter(":Status", OracleDbType.Int32); oracleParameter13.Value = (object)model.Status; oracleParameterArray[index12] = oracleParameter13; OracleParameter[] parameter = oracleParameterArray; return(this.dbHelper.Execute(sql, parameter)); }