public int Update(RoadFlow.Data.Model.MenuUser model)
{
string sql = "UPDATE MenuUser SET \r\n\t\t\t\tMenuID=:MenuID,SubPageID=:SubPageID,Organizes=:Organizes,Users=:Users,Buttons=:Buttons\r\n\t\t\t\tWHERE ID=:ID";
OracleParameter[] oracleParameterArray = new OracleParameter[6];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":MenuID", OracleDbType.Varchar2);
oracleParameter1.Value = (object)model.MenuID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":SubPageID", OracleDbType.Varchar2);
oracleParameter2.Value = (object)model.SubPageID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":Organizes", OracleDbType.Varchar2);
oracleParameter3.Value = (object)model.Organizes;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":Users", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.Users;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5;
if (model.Buttons != null)
{
OracleParameter oracleParameter6 = new OracleParameter(":Buttons", OracleDbType.Varchar2);
oracleParameter6.Value = (object)model.Buttons;
oracleParameter5 = oracleParameter6;
}
else
{
oracleParameter5 = new OracleParameter(":Buttons", OracleDbType.Varchar2);
oracleParameter5.Value = (object)DBNull.Value;
}
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter7 = new OracleParameter(":ID", OracleDbType.Varchar2);
oracleParameter7.Value = (object)model.ID;
oracleParameterArray[index6] = oracleParameter7;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.MenuUser model)
{
string sql = "INSERT INTO MenuUser\r\n\t\t\t\t(ID,MenuID,SubPageID,Organizes,Users,Buttons) \r\n\t\t\t\tVALUES(:ID,:MenuID,:SubPageID,:Organizes,:Users,:Buttons)";
OracleParameter[] oracleParameterArray = new OracleParameter[6];
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(":MenuID", OracleDbType.Varchar2);
oracleParameter2.Value = (object)model.MenuID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":SubPageID", OracleDbType.Varchar2);
oracleParameter3.Value = (object)model.SubPageID;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":Organizes", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.Organizes;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":Users", OracleDbType.Varchar2);
oracleParameter5.Value = (object)model.Users;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6;
if (model.Buttons != null)
{
OracleParameter oracleParameter7 = new OracleParameter(":Buttons", OracleDbType.Varchar2);
oracleParameter7.Value = (object)model.Buttons;
oracleParameter6 = oracleParameter7;
}
else
{
oracleParameter6 = new OracleParameter(":Buttons", OracleDbType.Varchar2);
oracleParameter6.Value = (object)DBNull.Value;
}
oracleParameterArray[index6] = oracleParameter6;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
private List <RoadFlow.Data.Model.MenuUser> DataReaderToList(OracleDataReader dataReader)
{
List <RoadFlow.Data.Model.MenuUser> menuUserList = new List <RoadFlow.Data.Model.MenuUser>();
while (dataReader.Read())
{
RoadFlow.Data.Model.MenuUser menuUser = new RoadFlow.Data.Model.MenuUser();
menuUser.ID = dataReader.GetString(0).ToGuid();
menuUser.MenuID = dataReader.GetString(1).ToGuid();
menuUser.SubPageID = dataReader.GetString(2).ToGuid();
menuUser.Organizes = dataReader.GetString(3);
menuUser.Users = dataReader.GetString(4);
if (!dataReader.IsDBNull(5))
{
menuUser.Buttons = dataReader.GetString(5);
}
menuUserList.Add(menuUser);
}
return(menuUserList);
}
public int Update(RoadFlow.Data.Model.MenuUser model)
{
string sql = "UPDATE MenuUser SET \r\n\t\t\t\tMenuID=@MenuID,SubPageID=@SubPageID,Organizes=@Organizes,Users=@Users,Buttons=@Buttons,Params=@Params\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] sqlParameterArray = new SqlParameter[7];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@MenuID", SqlDbType.UniqueIdentifier, -1);
sqlParameter1.Value = (object)model.MenuID;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@SubPageID", SqlDbType.UniqueIdentifier, -1);
sqlParameter2.Value = (object)model.SubPageID;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Organizes", SqlDbType.VarChar, 100);
sqlParameter3.Value = (object)model.Organizes;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4 = new SqlParameter("@Users", SqlDbType.VarChar, -1);
sqlParameter4.Value = (object)model.Users;
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter5;
if (model.Buttons != null)
{
SqlParameter sqlParameter6 = new SqlParameter("@Buttons", SqlDbType.VarChar, -1);
sqlParameter6.Value = (object)model.Buttons;
sqlParameter5 = sqlParameter6;
}
else
{
sqlParameter5 = new SqlParameter("@Buttons", SqlDbType.VarChar, -1);
sqlParameter5.Value = (object)DBNull.Value;
}
sqlParameterArray[index5] = sqlParameter5;
int index6 = 5;
SqlParameter sqlParameter7;
if (model.Params != null)
{
SqlParameter sqlParameter6 = new SqlParameter("@Params", SqlDbType.VarChar, -1);
sqlParameter6.Value = (object)model.Params;
sqlParameter7 = sqlParameter6;
}
else
{
sqlParameter7 = new SqlParameter("@Params", SqlDbType.VarChar, -1);
sqlParameter7.Value = (object)DBNull.Value;
}
sqlParameterArray[index6] = sqlParameter7;
int index7 = 6;
SqlParameter sqlParameter8 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter8.Value = (object)model.ID;
sqlParameterArray[index7] = sqlParameter8;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.MenuUser model)
{
string sql = "INSERT INTO menuuser\r\n\t\t\t\t(ID,MenuID,SubPageID,Organizes,Users,Buttons,Params) \r\n\t\t\t\tVALUES(@ID,@MenuID,@SubPageID,@Organizes,@Users,@Buttons,@Params)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[7];
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("@MenuID", MySqlDbType.VarChar, 36);
mySqlParameter2.Value = (object)model.MenuID;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@SubPageID", MySqlDbType.VarChar, 36);
mySqlParameter3.Value = (object)model.SubPageID;
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter4 = new MySqlParameter("@Organizes", MySqlDbType.VarChar, 100);
mySqlParameter4.Value = (object)model.Organizes;
mySqlParameterArray[index4] = mySqlParameter4;
int index5 = 4;
MySqlParameter mySqlParameter5 = new MySqlParameter("@Users", MySqlDbType.LongText, -1);
mySqlParameter5.Value = (object)model.Users;
mySqlParameterArray[index5] = mySqlParameter5;
int index6 = 5;
MySqlParameter mySqlParameter6;
if (model.Buttons != null)
{
MySqlParameter mySqlParameter7 = new MySqlParameter("@Buttons", MySqlDbType.LongText, -1);
mySqlParameter7.Value = (object)model.Buttons;
mySqlParameter6 = mySqlParameter7;
}
else
{
mySqlParameter6 = new MySqlParameter("@Buttons", MySqlDbType.LongText, -1);
mySqlParameter6.Value = (object)DBNull.Value;
}
mySqlParameterArray[index6] = mySqlParameter6;
int index7 = 6;
MySqlParameter mySqlParameter8;
if (model.Params != null)
{
MySqlParameter mySqlParameter7 = new MySqlParameter("@Params", MySqlDbType.LongText, -1);
mySqlParameter7.Value = (object)model.Params;
mySqlParameter8 = mySqlParameter7;
}
else
{
mySqlParameter8 = new MySqlParameter("@Params", MySqlDbType.LongText, -1);
mySqlParameter8.Value = (object)DBNull.Value;
}
mySqlParameterArray[index7] = mySqlParameter8;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.MenuUser model)
{
return(this.dataMenuUser.Update(model));
}
public int Add(RoadFlow.Data.Model.MenuUser model)
{
return(this.dataMenuUser.Add(model));
}
