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));
}
