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