public int Update(RoadFlow.Data.Model.HastenLog model)
{
string sql = "UPDATE HastenLog SET \r\n\t\t\t\tOthersParams=@OthersParams,Users=@Users,Types=@Types,Contents=@Contents,SendUser=@SendUser,SendUserName=@SendUserName,SendTime=@SendTime\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] sqlParameterArray = new SqlParameter[8];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@OthersParams", SqlDbType.VarChar, 5000);
sqlParameter1.Value = (object)model.OthersParams;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@Users", SqlDbType.VarChar, 5000);
sqlParameter2.Value = (object)model.Users;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Types", SqlDbType.VarChar, 500);
sqlParameter3.Value = (object)model.Types;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4 = new SqlParameter("@Contents", SqlDbType.NVarChar, 1000);
sqlParameter4.Value = (object)model.Contents;
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter5 = new SqlParameter("@SendUser", SqlDbType.UniqueIdentifier, -1);
sqlParameter5.Value = (object)model.SendUser;
sqlParameterArray[index5] = sqlParameter5;
int index6 = 5;
SqlParameter sqlParameter6 = new SqlParameter("@SendUserName", SqlDbType.NVarChar, 100);
sqlParameter6.Value = (object)model.SendUserName;
sqlParameterArray[index6] = sqlParameter6;
int index7 = 6;
SqlParameter sqlParameter7 = new SqlParameter("@SendTime", SqlDbType.DateTime, 8);
sqlParameter7.Value = (object)model.SendTime;
sqlParameterArray[index7] = sqlParameter7;
int index8 = 7;
SqlParameter sqlParameter8 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter8.Value = (object)model.ID;
sqlParameterArray[index8] = sqlParameter8;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.HastenLog model)
{
string sql = "UPDATE HastenLog SET \r\n\t\t\t\tOthersParams=:OthersParams,Users=:Users,Types=:Types,Contents=:Contents,SendUser=:SendUser,SendUserName=:SendUserName,SendTime=:SendTime\r\n\t\t\t\tWHERE ID=:ID";
OracleParameter[] oracleParameterArray = new OracleParameter[8];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":OthersParams", OracleDbType.Varchar2);
oracleParameter1.Value = (object)model.OthersParams;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":Users", OracleDbType.Varchar2);
oracleParameter2.Value = (object)model.Users;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":Types", OracleDbType.Varchar2);
oracleParameter3.Value = (object)model.Types;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":Contents", OracleDbType.NVarchar2);
oracleParameter4.Value = (object)model.Contents;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":SendUser", OracleDbType.Varchar2);
oracleParameter5.Value = (object)model.SendUser;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6 = new OracleParameter(":SendUserName", OracleDbType.Varchar2);
oracleParameter6.Value = (object)model.SendUserName;
oracleParameterArray[index6] = oracleParameter6;
int index7 = 6;
OracleParameter oracleParameter7 = new OracleParameter(":SendTime", OracleDbType.Date);
oracleParameter7.Value = (object)model.SendTime;
oracleParameterArray[index7] = oracleParameter7;
int index8 = 7;
OracleParameter oracleParameter8 = new OracleParameter(":ID", OracleDbType.Varchar2);
oracleParameter8.Value = (object)model.ID;
oracleParameterArray[index8] = oracleParameter8;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.HastenLog model)
{
string sql = "UPDATE hastenlog SET \r\n\t\t\t\tOthersParams=@OthersParams,Users=@Users,Types=@Types,Contents=@Contents,SendUser=@SendUser,SendUserName=@SendUserName,SendTime=@SendTime\r\n\t\t\t\tWHERE ID=@ID";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[8];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@OthersParams", MySqlDbType.Text, -1);
mySqlParameter1.Value = (object)model.OthersParams;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@Users", MySqlDbType.Text, -1);
mySqlParameter2.Value = (object)model.Users;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@Types", MySqlDbType.Text, -1);
mySqlParameter3.Value = (object)model.Types;
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter4 = new MySqlParameter("@Contents", MySqlDbType.Text, -1);
mySqlParameter4.Value = (object)model.Contents;
mySqlParameterArray[index4] = mySqlParameter4;
int index5 = 4;
MySqlParameter mySqlParameter5 = new MySqlParameter("@SendUser", MySqlDbType.VarChar, 36);
mySqlParameter5.Value = (object)model.SendUser;
mySqlParameterArray[index5] = mySqlParameter5;
int index6 = 5;
MySqlParameter mySqlParameter6 = new MySqlParameter("@SendUserName", MySqlDbType.VarChar, 50);
mySqlParameter6.Value = (object)model.SendUserName;
mySqlParameterArray[index6] = mySqlParameter6;
int index7 = 6;
MySqlParameter mySqlParameter7 = new MySqlParameter("@SendTime", MySqlDbType.DateTime, -1);
mySqlParameter7.Value = (object)model.SendTime;
mySqlParameterArray[index7] = mySqlParameter7;
int index8 = 7;
MySqlParameter mySqlParameter8 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36);
mySqlParameter8.Value = (object)model.ID;
mySqlParameterArray[index8] = mySqlParameter8;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.HastenLog model)
{
return(this.dataHastenLog.Update(model));
}
public int Add(RoadFlow.Data.Model.HastenLog model)
{
return(this.dataHastenLog.Add(model));
}