public Tuple <DateTime, DateTime, DateTime, DateTime> GetWorkAmPmTime(DateTime date)
{
Tuple <DateTime, DateTime, DateTime, DateTime> tuple = (Tuple <DateTime, DateTime, DateTime, DateTime>)null;
List <RoadFlow.Data.Model.WorkTime> yearFromCache = this.GetYearFromCache(date.Year);
RoadFlow.Data.Model.WorkTime workTime1 = (RoadFlow.Data.Model.WorkTime)null;
foreach (RoadFlow.Data.Model.WorkTime workTime2 in yearFromCache)
{
if (date >= workTime2.Date1 && date <= workTime2.Date2)
{
workTime1 = workTime2;
break;
}
}
if (workTime1 == null)
{
return(tuple);
}
DateTime dateTime1 = (date.ToDateString() + " " + workTime1.AmTime1).ToDateTime();
DateTime dateTime2 = (date.ToDateString() + " " + workTime1.AmTime2).ToDateTime();
DateTime dateTime3 = (date.ToDateString() + " " + workTime1.PmTime1).ToDateTime();
DateTime dateTime4 = (date.ToDateString() + " " + workTime1.PmTime2).ToDateTime();
DateTime dateTime5 = dateTime2;
DateTime dateTime6 = dateTime3;
DateTime dateTime7 = dateTime4;
return(new Tuple <DateTime, DateTime, DateTime, DateTime>(dateTime1, dateTime5, dateTime6, dateTime7));
}
public int Update(RoadFlow.Data.Model.WorkTime model)
{
string sql = "UPDATE WorkTime SET \r\n\t\t\t\tYear=@Year,Date1=@Date1,Date2=@Date2,AmTime1=@AmTime1,AmTime2=@AmTime2,PmTime1=@PmTime1,PmTime2=@PmTime2\r\n\t\t\t\tWHERE ID=@ID";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[8];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@Year", MySqlDbType.Int32);
mySqlParameter1.Value = (object)model.Year;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@Date1", MySqlDbType.DateTime);
mySqlParameter2.Value = (object)model.Date1;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@Date2", MySqlDbType.DateTime);
mySqlParameter3.Value = (object)model.Date2;
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter4 = new MySqlParameter("@AmTime1", MySqlDbType.VarChar, 50);
mySqlParameter4.Value = (object)model.AmTime1;
mySqlParameterArray[index4] = mySqlParameter4;
int index5 = 4;
MySqlParameter mySqlParameter5 = new MySqlParameter("@AmTime2", MySqlDbType.VarChar, 50);
mySqlParameter5.Value = (object)model.AmTime2;
mySqlParameterArray[index5] = mySqlParameter5;
int index6 = 5;
MySqlParameter mySqlParameter6 = new MySqlParameter("@PmTime1", MySqlDbType.VarChar, 50);
mySqlParameter6.Value = (object)model.PmTime1;
mySqlParameterArray[index6] = mySqlParameter6;
int index7 = 6;
MySqlParameter mySqlParameter7 = new MySqlParameter("@PmTime2", MySqlDbType.VarChar, 50);
mySqlParameter7.Value = (object)model.PmTime2;
mySqlParameterArray[index7] = mySqlParameter7;
int index8 = 7;
MySqlParameter mySqlParameter8 = new MySqlParameter("@ID", MySqlDbType.VarChar, 50);
mySqlParameter8.Value = (object)model.ID;
mySqlParameterArray[index8] = mySqlParameter8;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.WorkTime model)
{
string sql = "INSERT INTO WorkTime\r\n\t\t\t\t(ID,Year,Date1,Date2,AmTime1,AmTime2,PmTime1,PmTime2) \r\n\t\t\t\tVALUES(@ID,@Year,@Date1,@Date2,@AmTime1,@AmTime2,@PmTime1,@PmTime2)";
SqlParameter[] sqlParameterArray = new SqlParameter[8];
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("@Year", SqlDbType.Int, -1);
sqlParameter2.Value = (object)model.Year;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Date1", SqlDbType.DateTime, 8);
sqlParameter3.Value = (object)model.Date1;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4 = new SqlParameter("@Date2", SqlDbType.DateTime, 8);
sqlParameter4.Value = (object)model.Date2;
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter5 = new SqlParameter("@AmTime1", SqlDbType.VarChar, 50);
sqlParameter5.Value = (object)model.AmTime1;
sqlParameterArray[index5] = sqlParameter5;
int index6 = 5;
SqlParameter sqlParameter6 = new SqlParameter("@AmTime2", SqlDbType.VarChar, 50);
sqlParameter6.Value = (object)model.AmTime2;
sqlParameterArray[index6] = sqlParameter6;
int index7 = 6;
SqlParameter sqlParameter7 = new SqlParameter("@PmTime1", SqlDbType.VarChar, 50);
sqlParameter7.Value = (object)model.PmTime1;
sqlParameterArray[index7] = sqlParameter7;
int index8 = 7;
SqlParameter sqlParameter8 = new SqlParameter("@PmTime2", SqlDbType.VarChar, 50);
sqlParameter8.Value = (object)model.PmTime2;
sqlParameterArray[index8] = sqlParameter8;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.WorkTime model)
{
string sql = "UPDATE WorkTime SET \r\n\t\t\t\tYear=:Year,Date1=:Date1,Date2=:Date2,AmTime1=:AmTime1,AmTime2=:AmTime2,PmTime1=:PmTime1,PmTime2=:PmTime2\r\n\t\t\t\tWHERE ID=:ID";
OracleParameter[] oracleParameterArray = new OracleParameter[8];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":Year", OracleDbType.Varchar2, 50);
oracleParameter1.Value = (object)model.Year;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":Date1", OracleDbType.Date);
oracleParameter2.Value = (object)model.Date1;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":Date2", OracleDbType.Date);
oracleParameter3.Value = (object)model.Date2;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":AmTime1", OracleDbType.Varchar2, 50);
oracleParameter4.Value = (object)model.AmTime1;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":AmTime2", OracleDbType.Varchar2, 50);
oracleParameter5.Value = (object)model.AmTime2;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6 = new OracleParameter(":PmTime1", OracleDbType.Varchar2, 50);
oracleParameter6.Value = (object)model.PmTime1;
oracleParameterArray[index6] = oracleParameter6;
int index7 = 6;
OracleParameter oracleParameter7 = new OracleParameter(":PmTime2", OracleDbType.Varchar2, 50);
oracleParameter7.Value = (object)model.PmTime2;
oracleParameterArray[index7] = oracleParameter7;
int index8 = 7;
OracleParameter oracleParameter8 = new OracleParameter(":ID", OracleDbType.Varchar2, 50);
oracleParameter8.Value = (object)model.ID;
oracleParameterArray[index8] = oracleParameter8;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.WorkTime model)
{
string sql = "INSERT INTO WorkTime\r\n\t\t\t\t(ID,Year,Date1,Date2,AmTime1,AmTime2,PmTime1,PmTime2) \r\n\t\t\t\tVALUES(:ID,:Year,:Date1,:Date2,:AmTime1,:AmTime2,:PmTime1,:PmTime2)";
OracleParameter[] oracleParameterArray = new OracleParameter[8];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2, 50);
oracleParameter1.Value = (object)model.ID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":Year", OracleDbType.Int32);
oracleParameter2.Value = (object)model.Year;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":Date1", OracleDbType.Date);
oracleParameter3.Value = (object)model.Date1;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":Date2", OracleDbType.Date);
oracleParameter4.Value = (object)model.Date2;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":AmTime1", OracleDbType.Varchar2, 50);
oracleParameter5.Value = (object)model.AmTime1;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6 = new OracleParameter(":AmTime2", OracleDbType.Varchar2, 50);
oracleParameter6.Value = (object)model.AmTime2;
oracleParameterArray[index6] = oracleParameter6;
int index7 = 6;
OracleParameter oracleParameter7 = new OracleParameter(":PmTime1", OracleDbType.Varchar2, 50);
oracleParameter7.Value = (object)model.PmTime1;
oracleParameterArray[index7] = oracleParameter7;
int index8 = 7;
OracleParameter oracleParameter8 = new OracleParameter(":PmTime2", OracleDbType.Varchar2, 50);
oracleParameter8.Value = (object)model.PmTime2;
oracleParameterArray[index8] = oracleParameter8;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.WorkTime model)
{
return(this.dataWorkTime.Update(model));
}
public int Add(RoadFlow.Data.Model.WorkTime model)
{
return(this.dataWorkTime.Add(model));
}
