private List <RoadFlow.Data.Model.Menu> DataReaderToList(OracleDataReader dataReader)
{
List <RoadFlow.Data.Model.Menu> menuList = new List <RoadFlow.Data.Model.Menu>();
while (dataReader.Read())
{
RoadFlow.Data.Model.Menu menu = new RoadFlow.Data.Model.Menu();
menu.ID = dataReader.GetString(0).ToGuid();
menu.ParentID = dataReader.GetString(1).ToGuid();
if (!dataReader.IsDBNull(2))
{
menu.AppLibraryID = new Guid?(dataReader.GetString(2).ToGuid());
}
menu.Title = dataReader.GetString(3);
if (!dataReader.IsDBNull(4))
{
menu.Params = dataReader.GetString(4);
}
if (!dataReader.IsDBNull(5))
{
menu.Ico = dataReader.GetString(5);
}
menu.Sort = dataReader.GetInt32(6);
if (!dataReader.IsDBNull(7))
{
menu.IcoColor = dataReader.GetString(7);
}
menuList.Add(menu);
}
return(menuList);
}
public ActionResult Body(FormCollection collection)
{
RoadFlow.Platform.AppLibrary appLibrary1 = new RoadFlow.Platform.AppLibrary();
RoadFlow.Platform.Menu menu = new RoadFlow.Platform.Menu();
RoadFlow.Data.Model.Menu model = (RoadFlow.Data.Model.Menu)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;
string empty6 = string.Empty;
Guid id1;
ref Guid local = ref id1;
public int Add(RoadFlow.Data.Model.Menu model)
{
string sql = "INSERT INTO menu\r\n\t\t\t\t(ID,ParentID,AppLibraryID,Title,Params,Ico,Sort,IcoColor) \r\n\t\t\t\tVALUES(@ID,@ParentID,@AppLibraryID,@Title,@Params,@Ico,@Sort,@IcoColor)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[8];
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("@ParentID", MySqlDbType.VarChar, 36);
mySqlParameter2.Value = (object)model.ParentID;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3;
if (model.AppLibraryID.HasValue)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@AppLibraryID", MySqlDbType.VarChar, 36);
mySqlParameter4.Value = (object)model.AppLibraryID;
mySqlParameter3 = mySqlParameter4;
}
else
{
mySqlParameter3 = new MySqlParameter("@AppLibraryID", MySqlDbType.VarChar, 36);
mySqlParameter3.Value = (object)DBNull.Value;
}
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter5 = new MySqlParameter("@Title", MySqlDbType.Text, -1);
mySqlParameter5.Value = (object)model.Title;
mySqlParameterArray[index4] = mySqlParameter5;
int index5 = 4;
MySqlParameter mySqlParameter6;
if (model.Params != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@Params", MySqlDbType.Text, -1);
mySqlParameter4.Value = (object)model.Params;
mySqlParameter6 = mySqlParameter4;
}
else
{
mySqlParameter6 = new MySqlParameter("@Params", MySqlDbType.Text, -1);
mySqlParameter6.Value = (object)DBNull.Value;
}
mySqlParameterArray[index5] = mySqlParameter6;
int index6 = 5;
MySqlParameter mySqlParameter7;
if (model.Ico != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@Ico", MySqlDbType.Text, -1);
mySqlParameter4.Value = (object)model.Ico;
mySqlParameter7 = mySqlParameter4;
}
else
{
mySqlParameter7 = new MySqlParameter("@Ico", MySqlDbType.Text, -1);
mySqlParameter7.Value = (object)DBNull.Value;
}
mySqlParameterArray[index6] = mySqlParameter7;
int index7 = 6;
MySqlParameter mySqlParameter8 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11);
mySqlParameter8.Value = (object)model.Sort;
mySqlParameterArray[index7] = mySqlParameter8;
int index8 = 7;
MySqlParameter mySqlParameter9;
if (model.IcoColor != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@IcoColor", MySqlDbType.VarChar, 50);
mySqlParameter4.Value = (object)model.IcoColor;
mySqlParameter9 = mySqlParameter4;
}
else
{
mySqlParameter9 = new MySqlParameter("@IcoColor", MySqlDbType.VarChar, 50);
mySqlParameter9.Value = (object)DBNull.Value;
}
mySqlParameterArray[index8] = mySqlParameter9;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.Menu model)
{
string sql = "INSERT INTO Menu\r\n\t\t\t\t(ID,ParentID,AppLibraryID,Title,Params,Ico,Sort,IcoColor) \r\n\t\t\t\tVALUES(:ID,:ParentID,:AppLibraryID,:Title,:Params,:Ico,:Sort,:IcoColor)";
OracleParameter[] oracleParameterArray = new OracleParameter[8];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2);
oracleParameter1.Value = (object)model.ID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":ParentID", OracleDbType.Varchar2);
oracleParameter2.Value = (object)model.ParentID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3;
if (model.AppLibraryID.HasValue)
{
OracleParameter oracleParameter4 = new OracleParameter(":AppLibraryID", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.AppLibraryID;
oracleParameter3 = oracleParameter4;
}
else
{
oracleParameter3 = new OracleParameter(":AppLibraryID", OracleDbType.Varchar2);
oracleParameter3.Value = (object)DBNull.Value;
}
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter5 = new OracleParameter(":Title", OracleDbType.Varchar2);
oracleParameter5.Value = (object)model.Title;
oracleParameterArray[index4] = oracleParameter5;
int index5 = 4;
OracleParameter oracleParameter6;
if (model.Params != null)
{
OracleParameter oracleParameter4 = new OracleParameter(":Params", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.Params;
oracleParameter6 = oracleParameter4;
}
else
{
oracleParameter6 = new OracleParameter(":Params", OracleDbType.Varchar2);
oracleParameter6.Value = (object)DBNull.Value;
}
oracleParameterArray[index5] = oracleParameter6;
int index6 = 5;
OracleParameter oracleParameter7;
if (model.Ico != null)
{
OracleParameter oracleParameter4 = new OracleParameter(":Ico", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.Ico;
oracleParameter7 = oracleParameter4;
}
else
{
oracleParameter7 = new OracleParameter(":Ico", OracleDbType.Varchar2);
oracleParameter7.Value = (object)DBNull.Value;
}
oracleParameterArray[index6] = oracleParameter7;
int index7 = 6;
OracleParameter oracleParameter8 = new OracleParameter(":Sort", OracleDbType.Int32);
oracleParameter8.Value = (object)model.Sort;
oracleParameterArray[index7] = oracleParameter8;
int index8 = 7;
OracleParameter oracleParameter9;
if (model.IcoColor != null)
{
OracleParameter oracleParameter4 = new OracleParameter(":IcoColor", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.IcoColor;
oracleParameter9 = oracleParameter4;
}
else
{
oracleParameter9 = new OracleParameter(":IcoColor", OracleDbType.Varchar2);
oracleParameter9.Value = (object)DBNull.Value;
}
oracleParameterArray[index8] = oracleParameter9;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.Menu model)
{
string sql = "INSERT INTO Menu\r\n\t\t\t\t(ID,ParentID,AppLibraryID,Title,Params,Ico,Sort,IcoColor) \r\n\t\t\t\tVALUES(@ID,@ParentID,@AppLibraryID,@Title,@Params,@Ico,@Sort,@IcoColor)";
SqlParameter[] sqlParameterArray = new SqlParameter[8];
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("@ParentID", SqlDbType.UniqueIdentifier, -1);
sqlParameter2.Value = (object)model.ParentID;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3;
if (model.AppLibraryID.HasValue)
{
SqlParameter sqlParameter4 = new SqlParameter("@AppLibraryID", SqlDbType.UniqueIdentifier, -1);
sqlParameter4.Value = (object)model.AppLibraryID;
sqlParameter3 = sqlParameter4;
}
else
{
sqlParameter3 = new SqlParameter("@AppLibraryID", SqlDbType.UniqueIdentifier, -1);
sqlParameter3.Value = (object)DBNull.Value;
}
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter5 = new SqlParameter("@Title", SqlDbType.NVarChar, 1000);
sqlParameter5.Value = (object)model.Title;
sqlParameterArray[index4] = sqlParameter5;
int index5 = 4;
SqlParameter sqlParameter6;
if (model.Params != null)
{
SqlParameter sqlParameter4 = new SqlParameter("@Params", SqlDbType.VarChar, 5000);
sqlParameter4.Value = (object)model.Params;
sqlParameter6 = sqlParameter4;
}
else
{
sqlParameter6 = new SqlParameter("@Params", SqlDbType.VarChar, 5000);
sqlParameter6.Value = (object)DBNull.Value;
}
sqlParameterArray[index5] = sqlParameter6;
int index6 = 5;
SqlParameter sqlParameter7;
if (model.Ico != null)
{
SqlParameter sqlParameter4 = new SqlParameter("@Ico", SqlDbType.VarChar, 500);
sqlParameter4.Value = (object)model.Ico;
sqlParameter7 = sqlParameter4;
}
else
{
sqlParameter7 = new SqlParameter("@Ico", SqlDbType.VarChar, 500);
sqlParameter7.Value = (object)DBNull.Value;
}
sqlParameterArray[index6] = sqlParameter7;
int index7 = 6;
SqlParameter sqlParameter8 = new SqlParameter("@Sort", SqlDbType.Int, -1);
sqlParameter8.Value = (object)model.Sort;
sqlParameterArray[index7] = sqlParameter8;
int index8 = 7;
SqlParameter sqlParameter9;
if (model.IcoColor != null)
{
SqlParameter sqlParameter4 = new SqlParameter("@IcoColor", SqlDbType.VarChar, 50);
sqlParameter4.Value = (object)model.IcoColor;
sqlParameter9 = sqlParameter4;
}
else
{
sqlParameter9 = new SqlParameter("@IcoColor", SqlDbType.VarChar, 50);
sqlParameter9.Value = (object)DBNull.Value;
}
sqlParameterArray[index8] = sqlParameter9;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}