public int Update(RoadFlow.Data.Model.WorkCalendar model)
{
string sql = "UPDATE WorkCalendar SET \r\n\t\t\t\tWHERE WorkDate=:WorkDate";
OracleParameter[] oracleParameterArray = new OracleParameter[1];
int index = 0;
OracleParameter oracleParameter = new OracleParameter("@WorkDate", OracleDbType.Date);
oracleParameter.Value = (object)model.WorkDate;
oracleParameterArray[index] = oracleParameter;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.WorkCalendar model)
{
string sql = "INSERT INTO WorkCalendar\r\n\t\t\t\t(WorkDate) \r\n\t\t\t\tVALUES(:WorkDate)";
OracleParameter[] oracleParameterArray = new OracleParameter[1];
int index = 0;
OracleParameter oracleParameter = new OracleParameter("@WorkDate", OracleDbType.Date);
oracleParameter.Value = (object)model.WorkDate;
oracleParameterArray[index] = oracleParameter;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.WorkCalendar model)
{
string sql = "UPDATE workcalendar SET \r\n\t\t\t\t\r\n\t\t\t\tWHERE WorkDate=@WorkDate";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[1];
int index = 0;
MySqlParameter mySqlParameter = new MySqlParameter("@WorkDate", MySqlDbType.Date, -1);
mySqlParameter.Value = (object)model.WorkDate;
mySqlParameterArray[index] = mySqlParameter;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.WorkCalendar model)
{
string sql = "INSERT INTO workcalendar\r\n\t\t\t\t(WorkDate) \r\n\t\t\t\tVALUES(@WorkDate)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[1];
int index = 0;
MySqlParameter mySqlParameter = new MySqlParameter("@WorkDate", MySqlDbType.Date, -1);
mySqlParameter.Value = (object)model.WorkDate;
mySqlParameterArray[index] = mySqlParameter;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.WorkCalendar model)
{
return(this.dataWorkCalendar.Update(model));
}
public int Add(RoadFlow.Data.Model.WorkCalendar model)
{
return(this.dataWorkCalendar.Add(model));
}
