public List <WorkingCalendar> GetCalList(int year)
{
List <WorkingCalendar> cal_list = new List <WorkingCalendar>();
string query = "SELECT * FROM MES_WORKCALENDARTIME WHERE WORKDATE LIKE :WORKDATE||'%' ORDER BY WORKDATE,TEAMTYPE";
List <OracleParameter> para_list = new List <OracleParameter>();
para_list.Add(new OracleParameter(":WORKDATE", year));
DataSet ds = dbFactory.ExecuteDataSet(System.Data.CommandType.Text, query, para_list.ToArray());
foreach (DataRow row in ds.Tables[0].Rows)
{
WorkingCalendar cal = new WorkingCalendar();
if (row["ADDWORKTODATE"] != DBNull.Value)
{
cal.Overtime_end = row["ADDWORKTODATE"].ToString();
cal.Overtime_start = row["ADDWORKFROMDATE"].ToString();
}
cal.Team_type = row["TEAMTYPE"].ToString();
cal.Work_date = row["WORKDATE"].ToString();
cal.Work_end = row["WORKTODATE"].ToString();
cal.Work_person = Convert.ToInt32(row["QTY"]);
cal.Work_start = row["WORKFROMDATE"].ToString();
cal.Id = Convert.ToInt32(row["ID"]);
cal_list.Add(cal);
}
return(cal_list);
}
public bool CreateCal(WorkingCalendar cal)
{
bool flag = db.CreateCal(cal);
if (!db.UpdateCalSummary(Convert.ToDateTime(cal.Work_date)
, ((Convert.ToDateTime(cal.Overtime_end) - Convert.ToDateTime(cal.Overtime_start)).TotalMinutes +
(Convert.ToDateTime(cal.Work_end) - Convert.ToDateTime(cal.Work_start)).TotalMinutes) / 60))
{
db.CreateCalSummary(Convert.ToDateTime(cal.Work_date)
, ((Convert.ToDateTime(cal.Overtime_end) - Convert.ToDateTime(cal.Overtime_start)).TotalMinutes +
(Convert.ToDateTime(cal.Work_end) - Convert.ToDateTime(cal.Work_start)).TotalMinutes) / 60);
}
return(flag);
}
public bool UpdateCal(WorkingCalendar cal)
{
string query = "UPDATE MES_WORKCALENDARTIME SET WORKFROMDATE=:WORKFROMDATE,WORKTODATE=:WORKTODATE," +
"QTY=:QTY,ADDWORKFROMDATE=:ADDWORKFROMDATE,ADDWORKTODATE=:ADDWORKTODATE WHERE WORKDATE='" + cal.Work_date + "' AND TEAMTYPE='" + cal.Team_type + "'";
List <OracleParameter> para_list = new List <OracleParameter>();
para_list.Add(new OracleParameter(":WORKFROMDATE", cal.Work_start));
para_list.Add(new OracleParameter(":WORKTODATE", cal.Work_end));
para_list.Add(new OracleParameter(":QTY", cal.Work_person));
para_list.Add(new OracleParameter(":ADDWORKFROMDATE", cal.Overtime_start));
para_list.Add(new OracleParameter(":ADDWORKTODATE", cal.Overtime_end));
return(dbFactory.ExecuteNonQuery(CommandType.Text, query, para_list.ToArray()) > 0);
}
public bool CreateCal(WorkingCalendar cal)
{
string query = "INSERT INTO MES_WORKCALENDARTIME(ID,WORKDATE,TEAMTYPE,WORKFROMDATE,WORKTODATE,QTY,ADDWORKFROMDATE,ADDWORKTODATE)" +
"VALUES(:ID,:WORKDATE,:TEAMTYPE,:WORKFROMDATE,:WORKTODATE,:QTY,:ADDWORKFROMDATE,:ADDWORKTODATE)";
List <OracleParameter> para_list = new List <OracleParameter>();
para_list.Add(new OracleParameter(":ID", this.GetID()));
para_list.Add(new OracleParameter(":WORKDATE", cal.Work_date));
para_list.Add(new OracleParameter(":TEAMTYPE", cal.Team_type));
para_list.Add(new OracleParameter(":WORKFROMDATE", cal.Work_start));
para_list.Add(new OracleParameter(":WORKTODATE", cal.Work_end));
para_list.Add(new OracleParameter(":QTY", cal.Work_person));
para_list.Add(new OracleParameter(":ADDWORKFROMDATE", cal.Overtime_start));
para_list.Add(new OracleParameter(":ADDWORKTODATE", cal.Overtime_end));
return(dbFactory.ExecuteNonQuery(CommandType.Text, query, para_list.ToArray()) > 0);
}
