public Tuple <DateTime, DateTime, DateTime, DateTime> GetWorkAmPmTime(DateTime date) { Tuple <DateTime, DateTime, DateTime, DateTime> result = null; List <RoadFlow.Data.Model.WorkTime> yearFromCache = GetYearFromCache(date.Year); RoadFlow.Data.Model.WorkTime workTime = null; foreach (RoadFlow.Data.Model.WorkTime item5 in yearFromCache) { if (date >= item5.Date1 && date <= item5.Date2) { workTime = item5; break; } } if (workTime == null) { return(result); } DateTime item = (date.ToDateString() + " " + workTime.AmTime1).ToDateTime(); DateTime item2 = (date.ToDateString() + " " + workTime.AmTime2).ToDateTime(); DateTime item3 = (date.ToDateString() + " " + workTime.PmTime1).ToDateTime(); DateTime item4 = (date.ToDateString() + " " + workTime.PmTime2).ToDateTime(); return(new Tuple <DateTime, DateTime, DateTime, DateTime>(item, item2, item3, item4)); }
private List <RoadFlow.Data.Model.WorkTime> DataReaderToList(OracleDataReader dataReader) { List <RoadFlow.Data.Model.WorkTime> list = new List <RoadFlow.Data.Model.WorkTime>(); RoadFlow.Data.Model.WorkTime workTime = null; while (((DbDataReader)dataReader).Read()) { workTime = new RoadFlow.Data.Model.WorkTime(); workTime.ID = ((DbDataReader)dataReader).GetGuid(0); workTime.Year = ((DbDataReader)dataReader).GetInt32(1); workTime.Date1 = ((DbDataReader)dataReader).GetDateTime(2); workTime.Date2 = ((DbDataReader)dataReader).GetDateTime(3); workTime.AmTime1 = ((DbDataReader)dataReader).GetString(4); workTime.AmTime2 = ((DbDataReader)dataReader).GetString(5); workTime.PmTime1 = ((DbDataReader)dataReader).GetString(6); workTime.PmTime2 = ((DbDataReader)dataReader).GetString(7); list.Add(workTime); } return(list); }
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"; SqlParameter[] parameter = new SqlParameter[8] { new SqlParameter("@Year", SqlDbType.Int, -1) { Value = model.Year }, new SqlParameter("@Date1", SqlDbType.DateTime, 8) { Value = model.Date1 }, new SqlParameter("@Date2", SqlDbType.DateTime, 8) { Value = model.Date2 }, new SqlParameter("@AmTime1", SqlDbType.VarChar, 50) { Value = model.AmTime1 }, new SqlParameter("@AmTime2", SqlDbType.VarChar, 50) { Value = model.AmTime2 }, new SqlParameter("@PmTime1", SqlDbType.VarChar, 50) { Value = model.PmTime1 }, new SqlParameter("@PmTime2", SqlDbType.VarChar, 50) { Value = model.PmTime2 }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(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)"; SqlParameter[] parameter = new SqlParameter[8] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Year", SqlDbType.Int, -1) { Value = model.Year }, new SqlParameter("@Date1", SqlDbType.DateTime, 8) { Value = model.Date1 }, new SqlParameter("@Date2", SqlDbType.DateTime, 8) { Value = model.Date2 }, new SqlParameter("@AmTime1", SqlDbType.VarChar, 50) { Value = model.AmTime1 }, new SqlParameter("@AmTime2", SqlDbType.VarChar, 50) { Value = model.AmTime2 }, new SqlParameter("@PmTime1", SqlDbType.VarChar, 50) { Value = model.PmTime1 }, new SqlParameter("@PmTime2", SqlDbType.VarChar, 50) { Value = model.PmTime2 } }; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.WorkTime model) { //IL_0017: Unknown result type (might be due to invalid IL or missing references) //IL_001c: Unknown result type (might be due to invalid IL or missing references) //IL_002d: Expected O, but got Unknown //IL_002e: Expected O, but got Unknown //IL_0037: Unknown result type (might be due to invalid IL or missing references) //IL_003c: Unknown result type (might be due to invalid IL or missing references) //IL_004d: Expected O, but got Unknown //IL_004e: Expected O, but got Unknown //IL_0057: Unknown result type (might be due to invalid IL or missing references) //IL_005c: Unknown result type (might be due to invalid IL or missing references) //IL_006d: Expected O, but got Unknown //IL_006e: Expected O, but got Unknown //IL_0079: Unknown result type (might be due to invalid IL or missing references) //IL_007e: Unknown result type (might be due to invalid IL or missing references) //IL_008a: Expected O, but got Unknown //IL_008b: Expected O, but got Unknown //IL_0096: Unknown result type (might be due to invalid IL or missing references) //IL_009b: Unknown result type (might be due to invalid IL or missing references) //IL_00a7: Expected O, but got Unknown //IL_00a8: Expected O, but got Unknown //IL_00b3: Unknown result type (might be due to invalid IL or missing references) //IL_00b8: Unknown result type (might be due to invalid IL or missing references) //IL_00c4: Expected O, but got Unknown //IL_00c5: Expected O, but got Unknown //IL_00d0: Unknown result type (might be due to invalid IL or missing references) //IL_00d5: Unknown result type (might be due to invalid IL or missing references) //IL_00e1: Expected O, but got Unknown //IL_00e2: Expected O, but got Unknown //IL_00ed: Unknown result type (might be due to invalid IL or missing references) //IL_00f2: Unknown result type (might be due to invalid IL or missing references) //IL_0103: Expected O, but got Unknown //IL_0104: Expected O, but got Unknown 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[] obj = new OracleParameter[8]; OracleParameter val = new OracleParameter(":Year", 126, 50); ((DbParameter)val).Value = model.Year; obj[0] = val; OracleParameter val2 = new OracleParameter(":Date1", 106); ((DbParameter)val2).Value = model.Date1; obj[1] = val2; OracleParameter val3 = new OracleParameter(":Date2", 106); ((DbParameter)val3).Value = model.Date2; obj[2] = val3; OracleParameter val4 = new OracleParameter(":AmTime1", 126, 50); ((DbParameter)val4).Value = model.AmTime1; obj[3] = val4; OracleParameter val5 = new OracleParameter(":AmTime2", 126, 50); ((DbParameter)val5).Value = model.AmTime2; obj[4] = val5; OracleParameter val6 = new OracleParameter(":PmTime1", 126, 50); ((DbParameter)val6).Value = model.PmTime1; obj[5] = val6; OracleParameter val7 = new OracleParameter(":PmTime2", 126, 50); ((DbParameter)val7).Value = model.PmTime2; obj[6] = val7; OracleParameter val8 = new OracleParameter(":ID", 126, 50); ((DbParameter)val8).Value = model.ID; obj[7] = val8; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkTime model) { //IL_0017: Unknown result type (might be due to invalid IL or missing references) //IL_001c: Unknown result type (might be due to invalid IL or missing references) //IL_002d: Expected O, but got Unknown //IL_002e: Expected O, but got Unknown //IL_0037: Unknown result type (might be due to invalid IL or missing references) //IL_003c: Unknown result type (might be due to invalid IL or missing references) //IL_004d: Expected O, but got Unknown //IL_004e: Expected O, but got Unknown //IL_0057: Unknown result type (might be due to invalid IL or missing references) //IL_005c: Unknown result type (might be due to invalid IL or missing references) //IL_006d: Expected O, but got Unknown //IL_006e: Expected O, but got Unknown //IL_0077: Unknown result type (might be due to invalid IL or missing references) //IL_007c: Unknown result type (might be due to invalid IL or missing references) //IL_008d: Expected O, but got Unknown //IL_008e: Expected O, but got Unknown //IL_0099: Unknown result type (might be due to invalid IL or missing references) //IL_009e: Unknown result type (might be due to invalid IL or missing references) //IL_00aa: Expected O, but got Unknown //IL_00ab: Expected O, but got Unknown //IL_00b6: Unknown result type (might be due to invalid IL or missing references) //IL_00bb: Unknown result type (might be due to invalid IL or missing references) //IL_00c7: Expected O, but got Unknown //IL_00c8: Expected O, but got Unknown //IL_00d3: Unknown result type (might be due to invalid IL or missing references) //IL_00d8: Unknown result type (might be due to invalid IL or missing references) //IL_00e4: Expected O, but got Unknown //IL_00e5: Expected O, but got Unknown //IL_00f0: Unknown result type (might be due to invalid IL or missing references) //IL_00f5: Unknown result type (might be due to invalid IL or missing references) //IL_0101: Expected O, but got Unknown //IL_0102: Expected O, but got Unknown 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[] obj = new OracleParameter[8]; OracleParameter val = new OracleParameter(":ID", 126, 50); ((DbParameter)val).Value = model.ID; obj[0] = val; OracleParameter val2 = new OracleParameter(":Year", 112); ((DbParameter)val2).Value = model.Year; obj[1] = val2; OracleParameter val3 = new OracleParameter(":Date1", 106); ((DbParameter)val3).Value = model.Date1; obj[2] = val3; OracleParameter val4 = new OracleParameter(":Date2", 106); ((DbParameter)val4).Value = model.Date2; obj[3] = val4; OracleParameter val5 = new OracleParameter(":AmTime1", 126, 50); ((DbParameter)val5).Value = model.AmTime1; obj[4] = val5; OracleParameter val6 = new OracleParameter(":AmTime2", 126, 50); ((DbParameter)val6).Value = model.AmTime2; obj[5] = val6; OracleParameter val7 = new OracleParameter(":PmTime1", 126, 50); ((DbParameter)val7).Value = model.PmTime1; obj[6] = val7; OracleParameter val8 = new OracleParameter(":PmTime2", 126, 50); ((DbParameter)val8).Value = model.PmTime2; obj[7] = val8; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.WorkTime model) { return(dataWorkTime.Update(model)); }
public int Add(RoadFlow.Data.Model.WorkTime model) { return(dataWorkTime.Add(model)); }
public int Update(RoadFlow.Data.Model.WorkTime model) { //IL_0014: Unknown result type (might be due to invalid IL or missing references) //IL_0019: Unknown result type (might be due to invalid IL or missing references) //IL_002a: Expected O, but got Unknown //IL_002b: Expected O, but got Unknown //IL_0034: Unknown result type (might be due to invalid IL or missing references) //IL_0039: Unknown result type (might be due to invalid IL or missing references) //IL_004a: Expected O, but got Unknown //IL_004b: Expected O, but got Unknown //IL_0054: Unknown result type (might be due to invalid IL or missing references) //IL_0059: Unknown result type (might be due to invalid IL or missing references) //IL_006a: Expected O, but got Unknown //IL_006b: Expected O, but got Unknown //IL_0079: Unknown result type (might be due to invalid IL or missing references) //IL_007e: Unknown result type (might be due to invalid IL or missing references) //IL_008a: Expected O, but got Unknown //IL_008b: Expected O, but got Unknown //IL_0099: Unknown result type (might be due to invalid IL or missing references) //IL_009e: Unknown result type (might be due to invalid IL or missing references) //IL_00aa: Expected O, but got Unknown //IL_00ab: Expected O, but got Unknown //IL_00b9: Unknown result type (might be due to invalid IL or missing references) //IL_00be: Unknown result type (might be due to invalid IL or missing references) //IL_00ca: Expected O, but got Unknown //IL_00cb: Expected O, but got Unknown //IL_00d9: Unknown result type (might be due to invalid IL or missing references) //IL_00de: Unknown result type (might be due to invalid IL or missing references) //IL_00ea: Expected O, but got Unknown //IL_00eb: Expected O, but got Unknown //IL_00f9: Unknown result type (might be due to invalid IL or missing references) //IL_00fe: Unknown result type (might be due to invalid IL or missing references) //IL_010f: Expected O, but got Unknown //IL_0110: Expected O, but got Unknown 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[] obj = new MySqlParameter[8]; MySqlParameter val = new MySqlParameter("@Year", 3); ((DbParameter)val).Value = model.Year; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@Date1", 12); ((DbParameter)val2).Value = model.Date1; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@Date2", 12); ((DbParameter)val3).Value = model.Date2; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@AmTime1", 253, 50); ((DbParameter)val4).Value = model.AmTime1; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@AmTime2", 253, 50); ((DbParameter)val5).Value = model.AmTime2; obj[4] = val5; MySqlParameter val6 = new MySqlParameter("@PmTime1", 253, 50); ((DbParameter)val6).Value = model.PmTime1; obj[5] = val6; MySqlParameter val7 = new MySqlParameter("@PmTime2", 253, 50); ((DbParameter)val7).Value = model.PmTime2; obj[6] = val7; MySqlParameter val8 = new MySqlParameter("@ID", 253, 50); ((DbParameter)val8).Value = model.ID; obj[7] = val8; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkTime model) { //IL_001a: Unknown result type (might be due to invalid IL or missing references) //IL_001f: Unknown result type (might be due to invalid IL or missing references) //IL_0030: Expected O, but got Unknown //IL_0031: Expected O, but got Unknown //IL_0039: Unknown result type (might be due to invalid IL or missing references) //IL_003e: Unknown result type (might be due to invalid IL or missing references) //IL_004f: Expected O, but got Unknown //IL_0050: Expected O, but got Unknown //IL_0059: Unknown result type (might be due to invalid IL or missing references) //IL_005e: Unknown result type (might be due to invalid IL or missing references) //IL_006f: Expected O, but got Unknown //IL_0070: Expected O, but got Unknown //IL_0079: Unknown result type (might be due to invalid IL or missing references) //IL_007e: Unknown result type (might be due to invalid IL or missing references) //IL_008f: Expected O, but got Unknown //IL_0090: Expected O, but got Unknown //IL_009e: Unknown result type (might be due to invalid IL or missing references) //IL_00a3: Unknown result type (might be due to invalid IL or missing references) //IL_00af: Expected O, but got Unknown //IL_00b0: Expected O, but got Unknown //IL_00be: Unknown result type (might be due to invalid IL or missing references) //IL_00c3: Unknown result type (might be due to invalid IL or missing references) //IL_00cf: Expected O, but got Unknown //IL_00d0: Expected O, but got Unknown //IL_00de: Unknown result type (might be due to invalid IL or missing references) //IL_00e3: Unknown result type (might be due to invalid IL or missing references) //IL_00ef: Expected O, but got Unknown //IL_00f0: Expected O, but got Unknown //IL_00fe: Unknown result type (might be due to invalid IL or missing references) //IL_0103: Unknown result type (might be due to invalid IL or missing references) //IL_010f: Expected O, but got Unknown //IL_0110: Expected O, but got Unknown 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)"; MySqlParameter[] obj = new MySqlParameter[8]; MySqlParameter val = new MySqlParameter("@ID", 253, 50); ((DbParameter)val).Value = model.ID; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@Year", 3); ((DbParameter)val2).Value = model.Year; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@Date1", 12); ((DbParameter)val3).Value = model.Date1; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@Date2", 12); ((DbParameter)val4).Value = model.Date2; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@AmTime1", 253, 50); ((DbParameter)val5).Value = model.AmTime1; obj[4] = val5; MySqlParameter val6 = new MySqlParameter("@AmTime2", 253, 50); ((DbParameter)val6).Value = model.AmTime2; obj[5] = val6; MySqlParameter val7 = new MySqlParameter("@PmTime1", 253, 50); ((DbParameter)val7).Value = model.PmTime1; obj[6] = val7; MySqlParameter val8 = new MySqlParameter("@PmTime2", 253, 50); ((DbParameter)val8).Value = model.PmTime2; obj[7] = val8; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }