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