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