/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <RoadFlow.Data.Model.WorkFlowButtons> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.WorkFlowButtons> List = new List <RoadFlow.Data.Model.WorkFlowButtons>();
RoadFlow.Data.Model.WorkFlowButtons model = null;
while (dataReader.Read())
{
model = new RoadFlow.Data.Model.WorkFlowButtons();
model.ID = dataReader.GetGuid(0);
model.Title = dataReader.GetString(1);
if (!dataReader.IsDBNull(2))
{
model.Ico = dataReader.GetString(2);
}
if (!dataReader.IsDBNull(3))
{
model.Script = dataReader.GetString(3);
}
if (!dataReader.IsDBNull(4))
{
model.Note = dataReader.GetString(4);
}
model.Sort = dataReader.GetInt32(5);
List.Add(model);
}
return(List);
}
private List <RoadFlow.Data.Model.WorkFlowButtons> DataReaderToList(MySqlDataReader dataReader)
{
List <RoadFlow.Data.Model.WorkFlowButtons> workFlowButtonsList = new List <RoadFlow.Data.Model.WorkFlowButtons>();
while (dataReader.Read())
{
RoadFlow.Data.Model.WorkFlowButtons workFlowButtons = new RoadFlow.Data.Model.WorkFlowButtons();
workFlowButtons.ID = dataReader.GetString(0).ToGuid();
workFlowButtons.Title = dataReader.GetString(1);
if (!dataReader.IsDBNull(2))
{
workFlowButtons.Ico = dataReader.GetString(2);
}
if (!dataReader.IsDBNull(3))
{
workFlowButtons.Script = dataReader.GetString(3);
}
if (!dataReader.IsDBNull(4))
{
workFlowButtons.Note = dataReader.GetString(4);
}
workFlowButtons.Sort = dataReader.GetInt32(5);
workFlowButtonsList.Add(workFlowButtons);
}
return(workFlowButtonsList);
}
protected void Page_Load(object sender, EventArgs e)
{
RoadFlow.Platform.WorkFlowButtons bworkFlowButtons = new RoadFlow.Platform.WorkFlowButtons();
RoadFlow.Data.Model.WorkFlowButtons workFlowButton = null;
string id = Request.QueryString["id"];
string title = string.Empty;
string ico = string.Empty;
string script = string.Empty;
string note = string.Empty;
Guid buttionID;
if (id.IsGuid(out buttionID))
{
workFlowButton = bworkFlowButtons.Get(buttionID);
}
string oldXML = workFlowButton.Serialize();
if (IsPostBack)
{
title = Request.Form["Title1"];
ico = Request.Form["Ico"];
script = Request.Form["Script"];
note = Request.Form["Note"];
bool isAdd = !id.IsGuid();
if (workFlowButton == null)
{
workFlowButton = new RoadFlow.Data.Model.WorkFlowButtons();
workFlowButton.ID = Guid.NewGuid();
workFlowButton.Sort = bworkFlowButtons.GetMaxSort();
}
workFlowButton.Ico = ico.IsNullOrEmpty() ? null : ico.Trim();
workFlowButton.Note = note.IsNullOrEmpty() ? null : note.Trim();
workFlowButton.Script = script.IsNullOrEmpty() ? null : script;
workFlowButton.Title = title.Trim();
if (isAdd)
{
bworkFlowButtons.Add(workFlowButton);
RoadFlow.Platform.Log.Add("添加了流程按钮", workFlowButton.Serialize(), RoadFlow.Platform.Log.Types.流程相关);
}
else
{
bworkFlowButtons.Update(workFlowButton);
RoadFlow.Platform.Log.Add("修改了流程按钮", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, workFlowButton.Serialize());
}
bworkFlowButtons.ClearCache();
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "new RoadUI.Window().reloadOpener();alert('保存成功!');new RoadUI.Window().close();", true);
}
if (workFlowButton != null)
{
this.Title1.Value = workFlowButton.Title;
this.Ico.Value = workFlowButton.Ico;
this.Script.Value = workFlowButton.Script;
this.Note.Value = workFlowButton.Note;
}
}
public ActionResult Edit(FormCollection collection)
{
RoadFlow.Platform.WorkFlowButtons bworkFlowButtons = new RoadFlow.Platform.WorkFlowButtons();
RoadFlow.Data.Model.WorkFlowButtons workFlowButton = null;
string id = Request.QueryString["id"];
string title = string.Empty;
string ico = string.Empty;
string script = string.Empty;
string note = string.Empty;
Guid buttionID;
if (id.IsGuid(out buttionID))
{
workFlowButton = bworkFlowButtons.Get(buttionID);
}
string oldXML = workFlowButton.Serialize();
if (collection != null)
{
title = Request.Form["Title"];
ico = Request.Form["Ico"];
script = Request.Form["Script"];
note = Request.Form["Note"];
bool isAdd = !id.IsGuid();
if (workFlowButton == null)
{
workFlowButton = new RoadFlow.Data.Model.WorkFlowButtons();
workFlowButton.ID = Guid.NewGuid();
workFlowButton.Sort = bworkFlowButtons.GetMaxSort();
}
workFlowButton.Ico = ico.IsNullOrEmpty() ? null : ico.Trim();
workFlowButton.Note = note.IsNullOrEmpty() ? null : note.Trim();
workFlowButton.Script = script.IsNullOrEmpty() ? null : script;
workFlowButton.Title = title.Trim();
if (isAdd)
{
bworkFlowButtons.Add(workFlowButton);
RoadFlow.Platform.Log.Add("添加了流程按钮", workFlowButton.Serialize(), RoadFlow.Platform.Log.Types.流程相关);
}
else
{
bworkFlowButtons.Update(workFlowButton);
RoadFlow.Platform.Log.Add("修改了流程按钮", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, workFlowButton.Serialize());
}
bworkFlowButtons.ClearCache();
ViewBag.Script = "new RoadUI.Window().reloadOpener();alert('保存成功!');new RoadUI.Window().close();";
}
return(View(workFlowButton == null ? new RoadFlow.Data.Model.WorkFlowButtons() : workFlowButton));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowButtons实体类</param>
public int Update(RoadFlow.Data.Model.WorkFlowButtons model)
{
string sql = @"UPDATE WorkFlowButtons SET
Title=@Title,Ico=@Ico,Script=@Script,Note=@Note,Sort=@Sort
WHERE ID=@ID" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@Title", SqlDbType.NVarChar, 1000)
{
Value = model.Title
},
model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@Ico", SqlDbType.VarChar, 500)
{
Value = model.Ico
},
model.Script == null ? new SqlParameter("@Script", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Script", SqlDbType.VarChar, -1)
{
Value = model.Script
},
model.Note == null ? new SqlParameter("@Note", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.VarChar, -1)
{
Value = model.Note
},
new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = model.Sort
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowButtons实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.WorkFlowButtons model)
{
string sql = @"INSERT INTO WorkFlowButtons
(ID,Title,Ico,Script,Note,Sort)
VALUES(@ID,@Title,@Ico,@Script,@Note,@Sort)" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@Title", SqlDbType.NVarChar, 1000)
{
Value = model.Title
},
model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@Ico", SqlDbType.VarChar, 500)
{
Value = model.Ico
},
model.Script == null ? new SqlParameter("@Script", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Script", SqlDbType.VarChar, -1)
{
Value = model.Script
},
model.Note == null ? new SqlParameter("@Note", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.VarChar, -1)
{
Value = model.Note
},
new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = model.Sort
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowButtons实体类</param>
public int Update(RoadFlow.Data.Model.WorkFlowButtons model)
{
string sql = @"UPDATE WorkFlowButtons SET
Title=:Title,Ico=:Ico,Script=:Script,Note=:Note,Sort=:Sort
WHERE ID=:ID" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":Title", OracleDbType.NVarchar2, 1000)
{
Value = model.Title
},
model.Ico == null ? new OracleParameter(":Ico", OracleDbType.Varchar2, 500)
{
Value = DBNull.Value
} : new OracleParameter(":Ico", OracleDbType.Varchar2, 500)
{
Value = model.Ico
},
model.Script == null ? new OracleParameter(":Script", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":Script", OracleDbType.Clob)
{
Value = model.Script
},
model.Note == null ? new OracleParameter(":Note", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":Note", OracleDbType.Clob)
{
Value = model.Note
},
new OracleParameter(":Sort", OracleDbType.Int32)
{
Value = model.Sort
},
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowButtons实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.WorkFlowButtons model)
{
string sql = @"INSERT INTO WorkFlowButtons
(ID,Title,Ico,Script,Note,Sort)
VALUES(:ID,:Title,:Ico,:Script,:Note,:Sort)" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
},
new OracleParameter(":Title", OracleDbType.NVarchar2, 1000)
{
Value = model.Title
},
model.Ico == null ? new OracleParameter(":Ico", OracleDbType.Varchar2, 500)
{
Value = DBNull.Value
} : new OracleParameter(":Ico", OracleDbType.Varchar2, 500)
{
Value = model.Ico
},
model.Script == null ? new OracleParameter(":Script", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":Script", OracleDbType.Clob)
{
Value = model.Script
},
model.Note == null ? new OracleParameter(":Note", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":Note", OracleDbType.Clob)
{
Value = model.Note
},
new OracleParameter(":Sort", OracleDbType.Int32)
{
Value = model.Sort
}
};
return(dbHelper.Execute(sql, parameters));
}
public string Delete()
{
RoadFlow.Platform.WorkFlowButtons workFlowButtons1 = new RoadFlow.Platform.WorkFlowButtons();
string str1 = this.Request.Form["ids"];
char[] chArray = new char[1] {
','
};
foreach (string str2 in str1.Split(chArray))
{
Guid test;
if (str2.IsGuid(out test))
{
RoadFlow.Data.Model.WorkFlowButtons workFlowButtons2 = workFlowButtons1.Get(test, false);
if (workFlowButtons2 != null)
{
workFlowButtons1.Delete(test);
RoadFlow.Platform.Log.Add("删除了流程按钮", workFlowButtons2.Serialize(), RoadFlow.Platform.Log.Types.流程相关, "", "", (RoadFlow.Data.Model.Users)null);
}
}
}
workFlowButtons1.ClearCache();
return("删除成功!");
}
public int Update(RoadFlow.Data.Model.WorkFlowButtons model)
{
string sql = "UPDATE workflowbuttons SET \r\n\t\t\t\tTitle=@Title,Ico=@Ico,Script=@Script,Note=@Note,Sort=@Sort\r\n\t\t\t\tWHERE ID=@ID";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[6];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@Title", MySqlDbType.Text, -1);
mySqlParameter1.Value = (object)model.Title;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2;
if (model.Ico != null)
{
MySqlParameter mySqlParameter3 = new MySqlParameter("@Ico", MySqlDbType.Text, -1);
mySqlParameter3.Value = (object)model.Ico;
mySqlParameter2 = mySqlParameter3;
}
else
{
mySqlParameter2 = new MySqlParameter("@Ico", MySqlDbType.Text, -1);
mySqlParameter2.Value = (object)DBNull.Value;
}
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter4;
if (model.Script != null)
{
MySqlParameter mySqlParameter3 = new MySqlParameter("@Script", MySqlDbType.LongText, -1);
mySqlParameter3.Value = (object)model.Script;
mySqlParameter4 = mySqlParameter3;
}
else
{
mySqlParameter4 = new MySqlParameter("@Script", MySqlDbType.LongText, -1);
mySqlParameter4.Value = (object)DBNull.Value;
}
mySqlParameterArray[index3] = mySqlParameter4;
int index4 = 3;
MySqlParameter mySqlParameter5;
if (model.Note != null)
{
MySqlParameter mySqlParameter3 = new MySqlParameter("@Note", MySqlDbType.LongText, -1);
mySqlParameter3.Value = (object)model.Note;
mySqlParameter5 = mySqlParameter3;
}
else
{
mySqlParameter5 = new MySqlParameter("@Note", MySqlDbType.LongText, -1);
mySqlParameter5.Value = (object)DBNull.Value;
}
mySqlParameterArray[index4] = mySqlParameter5;
int index5 = 4;
MySqlParameter mySqlParameter6 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11);
mySqlParameter6.Value = (object)model.Sort;
mySqlParameterArray[index5] = mySqlParameter6;
int index6 = 5;
MySqlParameter mySqlParameter7 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36);
mySqlParameter7.Value = (object)model.ID;
mySqlParameterArray[index6] = mySqlParameter7;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public ActionResult Edit(FormCollection collection)
{
RoadFlow.Platform.WorkFlowButtons workFlowButtons = new RoadFlow.Platform.WorkFlowButtons();
RoadFlow.Data.Model.WorkFlowButtons model = (RoadFlow.Data.Model.WorkFlowButtons)null;
string str1 = this.Request.QueryString["id"];
string empty1 = string.Empty;
string empty2 = string.Empty;
string empty3 = string.Empty;
string empty4 = string.Empty;
string empty5 = string.Empty;
Guid test;
if (str1.IsGuid(out test))
{
model = workFlowButtons.Get(test, false);
}
string oldXML = model.Serialize();
if (collection != null)
{
string str2 = this.Request.Form["Title"];
string str3 = this.Request.Form["Ico"];
string str4 = this.Request.Form["Script"];
string str5 = this.Request.Form["Note"];
string str6 = this.Request.Form["Sort"];
int num = !str1.IsGuid() ? 1 : 0;
if (model == null)
{
model = new RoadFlow.Data.Model.WorkFlowButtons();
model.ID = Guid.NewGuid();
model.Sort = workFlowButtons.GetMaxSort();
}
model.Ico = str3.IsNullOrEmpty() ? (string)null : str3.Trim();
model.Note = str5.IsNullOrEmpty() ? (string)null : str5.Trim();
model.Script = str4.IsNullOrEmpty() ? (string)null : str4;
model.Title = str2.Trim();
model.Sort = !str6.IsInt() ? workFlowButtons.GetMaxSort() : str6.ToInt();
if (num != 0)
{
workFlowButtons.Add(model);
RoadFlow.Platform.Log.Add("添加了流程按钮", model.Serialize(), RoadFlow.Platform.Log.Types.流程相关, "", "", (RoadFlow.Data.Model.Users)null);
}
else
{
workFlowButtons.Update(model);
RoadFlow.Platform.Log.Add("修改了流程按钮", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, model.Serialize(), (RoadFlow.Data.Model.Users)null);
}
workFlowButtons.ClearCache();
// ISSUE: reference to a compiler-generated field
if (WorkFlowButtonsController.\u003C\u003Eo__3.\u003C\u003Ep__0 == null)
{
// ISSUE: reference to a compiler-generated field
WorkFlowButtonsController.\u003C\u003Eo__3.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Script", typeof(WorkFlowButtonsController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType | CSharpArgumentInfoFlags.Constant, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj = WorkFlowButtonsController.\u003C\u003Eo__3.\u003C\u003Ep__0.Target((CallSite)WorkFlowButtonsController.\u003C\u003Eo__3.\u003C\u003Ep__0, this.ViewBag, "new RoadUI.Window().reloadOpener();alert('保存成功!');new RoadUI.Window().close();");
}
if (model == null)
{
model = new RoadFlow.Data.Model.WorkFlowButtons();
model.Sort = workFlowButtons.GetMaxSort();
}
return((ActionResult)this.View((object)model));
}
public int Update(RoadFlow.Data.Model.WorkFlowButtons model)
{
string sql = "UPDATE WorkFlowButtons SET \r\n\t\t\t\tTitle=@Title,Ico=@Ico,Script=@Script,Note=@Note,Sort=@Sort\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] sqlParameterArray = new SqlParameter[6];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@Title", SqlDbType.NVarChar, 1000);
sqlParameter1.Value = (object)model.Title;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2;
if (model.Ico != null)
{
SqlParameter sqlParameter3 = new SqlParameter("@Ico", SqlDbType.VarChar, 500);
sqlParameter3.Value = (object)model.Ico;
sqlParameter2 = sqlParameter3;
}
else
{
sqlParameter2 = new SqlParameter("@Ico", SqlDbType.VarChar, 500);
sqlParameter2.Value = (object)DBNull.Value;
}
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter4;
if (model.Script != null)
{
SqlParameter sqlParameter3 = new SqlParameter("@Script", SqlDbType.VarChar, -1);
sqlParameter3.Value = (object)model.Script;
sqlParameter4 = sqlParameter3;
}
else
{
sqlParameter4 = new SqlParameter("@Script", SqlDbType.VarChar, -1);
sqlParameter4.Value = (object)DBNull.Value;
}
sqlParameterArray[index3] = sqlParameter4;
int index4 = 3;
SqlParameter sqlParameter5;
if (model.Note != null)
{
SqlParameter sqlParameter3 = new SqlParameter("@Note", SqlDbType.VarChar, -1);
sqlParameter3.Value = (object)model.Note;
sqlParameter5 = sqlParameter3;
}
else
{
sqlParameter5 = new SqlParameter("@Note", SqlDbType.VarChar, -1);
sqlParameter5.Value = (object)DBNull.Value;
}
sqlParameterArray[index4] = sqlParameter5;
int index5 = 4;
SqlParameter sqlParameter6 = new SqlParameter("@Sort", SqlDbType.Int, -1);
sqlParameter6.Value = (object)model.Sort;
sqlParameterArray[index5] = sqlParameter6;
int index6 = 5;
SqlParameter sqlParameter7 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter7.Value = (object)model.ID;
sqlParameterArray[index6] = sqlParameter7;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.WorkFlowButtons model)
{
return(this.dataWorkFlowButtons.Update(model));
}
public int Add(RoadFlow.Data.Model.WorkFlowButtons model)
{
return(this.dataWorkFlowButtons.Add(model));
}
public int Update(RoadFlow.Data.Model.WorkFlowButtons model)
{
string sql = "UPDATE WorkFlowButtons SET \r\n\t\t\t\tTitle=:Title,Ico=:Ico,Script=:Script,Note=:Note,Sort=:Sort\r\n\t\t\t\tWHERE ID=:ID";
OracleParameter[] oracleParameterArray = new OracleParameter[6];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":Title", OracleDbType.NVarchar2, 1000);
oracleParameter1.Value = (object)model.Title;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2;
if (model.Ico != null)
{
OracleParameter oracleParameter3 = new OracleParameter(":Ico", OracleDbType.Varchar2, 500);
oracleParameter3.Value = (object)model.Ico;
oracleParameter2 = oracleParameter3;
}
else
{
oracleParameter2 = new OracleParameter(":Ico", OracleDbType.Varchar2, 500);
oracleParameter2.Value = (object)DBNull.Value;
}
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter4;
if (model.Script != null)
{
OracleParameter oracleParameter3 = new OracleParameter(":Script", OracleDbType.Clob);
oracleParameter3.Value = (object)model.Script;
oracleParameter4 = oracleParameter3;
}
else
{
oracleParameter4 = new OracleParameter(":Script", OracleDbType.Clob);
oracleParameter4.Value = (object)DBNull.Value;
}
oracleParameterArray[index3] = oracleParameter4;
int index4 = 3;
OracleParameter oracleParameter5;
if (model.Note != null)
{
OracleParameter oracleParameter3 = new OracleParameter(":Note", OracleDbType.Clob);
oracleParameter3.Value = (object)model.Note;
oracleParameter5 = oracleParameter3;
}
else
{
oracleParameter5 = new OracleParameter(":Note", OracleDbType.Clob);
oracleParameter5.Value = (object)DBNull.Value;
}
oracleParameterArray[index4] = oracleParameter5;
int index5 = 4;
OracleParameter oracleParameter6 = new OracleParameter(":Sort", OracleDbType.Int32);
oracleParameter6.Value = (object)model.Sort;
oracleParameterArray[index5] = oracleParameter6;
int index6 = 5;
OracleParameter oracleParameter7 = new OracleParameter(":ID", OracleDbType.Varchar2, 40);
oracleParameter7.Value = (object)model.ID;
oracleParameterArray[index6] = oracleParameter7;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
