public int Update(RoadFlow.Data.Model.AppLibraryButtons model)
{
string sql = "UPDATE AppLibraryButtons SET \r\n\t\t\t\tName=@Name,Events=@Events,Ico=@Ico,Sort=@Sort,Note=@Note\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] sqlParameterArray = new SqlParameter[6];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@Name", SqlDbType.NVarChar, 100);
sqlParameter1.Value = (object)model.Name;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@Events", SqlDbType.VarChar, 5000);
sqlParameter2.Value = (object)model.Events;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3;
if (model.Ico != null)
{
SqlParameter sqlParameter4 = new SqlParameter("@Ico", SqlDbType.VarChar, 5000);
sqlParameter4.Value = (object)model.Ico;
sqlParameter3 = sqlParameter4;
}
else
{
sqlParameter3 = new SqlParameter("@Ico", SqlDbType.VarChar, 5000);
sqlParameter3.Value = (object)DBNull.Value;
}
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter5 = new SqlParameter("@Sort", SqlDbType.Int, -1);
sqlParameter5.Value = (object)model.Sort;
sqlParameterArray[index4] = sqlParameter5;
int index5 = 4;
SqlParameter sqlParameter6;
if (model.Note != null)
{
SqlParameter sqlParameter4 = new SqlParameter("@Note", SqlDbType.NVarChar, 1000);
sqlParameter4.Value = (object)model.Note;
sqlParameter6 = sqlParameter4;
}
else
{
sqlParameter6 = new SqlParameter("@Note", SqlDbType.NVarChar, 1000);
sqlParameter6.Value = (object)DBNull.Value;
}
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 Add(RoadFlow.Data.Model.AppLibraryButtons model)
{
string sql = "INSERT INTO AppLibraryButtons\r\n\t\t\t\t(ID,Name,Events,Ico,Sort,Note) \r\n\t\t\t\tVALUES(@ID,@Name,@Events,@Ico,@Sort,@Note)";
SqlParameter[] sqlParameterArray = new SqlParameter[6];
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, 100);
sqlParameter2.Value = (object)model.Name;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Events", SqlDbType.VarChar, 5000);
sqlParameter3.Value = (object)model.Events;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4;
if (model.Ico != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@Ico", SqlDbType.VarChar, 5000);
sqlParameter5.Value = (object)model.Ico;
sqlParameter4 = sqlParameter5;
}
else
{
sqlParameter4 = new SqlParameter("@Ico", SqlDbType.VarChar, 5000);
sqlParameter4.Value = (object)DBNull.Value;
}
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter6 = new SqlParameter("@Sort", SqlDbType.Int, -1);
sqlParameter6.Value = (object)model.Sort;
sqlParameterArray[index5] = sqlParameter6;
int index6 = 5;
SqlParameter sqlParameter7;
if (model.Note != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@Note", SqlDbType.NVarChar, 1000);
sqlParameter5.Value = (object)model.Note;
sqlParameter7 = sqlParameter5;
}
else
{
sqlParameter7 = new SqlParameter("@Note", SqlDbType.NVarChar, 1000);
sqlParameter7.Value = (object)DBNull.Value;
}
sqlParameterArray[index6] = sqlParameter7;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.AppLibraryButtons model)
{
string sql = "INSERT INTO applibrarybuttons(ID,Name,Events,Ico,Sort,Note) VALUES(@ID,@Name,@Events,@Ico,@Sort,@Note)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[6];
MySqlParameter mySqlParameter1 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36);
mySqlParameter1.Value = (object)model.ID;
mySqlParameterArray[0] = mySqlParameter1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@Name", MySqlDbType.VarChar, 50);
mySqlParameter2.Value = (object)model.Name;
mySqlParameterArray[1] = mySqlParameter2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@Events", MySqlDbType.Text, -1);
mySqlParameter3.Value = (object)model.Events;
mySqlParameterArray[2] = mySqlParameter3;
MySqlParameter mySqlParameter4;
if (model.Ico != null)
{
MySqlParameter mySqlParameter5 = new MySqlParameter("@Ico", MySqlDbType.Text, -1);
mySqlParameter5.Value = (object)model.Ico;
mySqlParameter4 = mySqlParameter5;
}
else
{
mySqlParameter4 = new MySqlParameter("@Ico", MySqlDbType.Text, -1);
mySqlParameter4.Value = (object)DBNull.Value;
}
mySqlParameterArray[3] = mySqlParameter4;
MySqlParameter mySqlParameter6 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11);
mySqlParameter6.Value = (object)model.Sort;
mySqlParameterArray[4] = mySqlParameter6;
MySqlParameter mySqlParameter7;
if (model.Note != null)
{
MySqlParameter mySqlParameter5 = new MySqlParameter("@Note", MySqlDbType.Text, -1);
mySqlParameter5.Value = (object)model.Note;
mySqlParameter7 = mySqlParameter5;
}
else
{
mySqlParameter7 = new MySqlParameter("@Note", MySqlDbType.Text, -1);
mySqlParameter7.Value = (object)DBNull.Value;
}
mySqlParameterArray[5] = mySqlParameter7;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
