public string getCalendarInfo() { rAjaxGetData<ApplyCalendar> rAjaxResult = new rAjaxGetData<ApplyCalendar>(); try { ApplyCalendar calObj = null; var getLogic = openLogic(); using (db0 = getLogic.getDB0) { //參數:取得申請日期最大期限 int get_N_Max = (int)getLogic.getParmValue(ParmDefine.bufferNorth_Max); int get_S_Max = (int)getLogic.getParmValue(ParmDefine.bufferSouth_Max); int get_Apply_Max_Day = get_N_Max >= get_S_Max ? get_N_Max : get_S_Max; //參數:取得申請人數最大上限 int get_N_num = (int)getLogic.getParmValue(ParmDefine.N_Max_joinnum); int get_S_num = (int)getLogic.getParmValue(ParmDefine.S_Max_joinnum); DateTime setWorkFistDay = DateTime.Now.AddDays(15);//提前七天才可申請 DateTime setWokrLastDay = setWorkFistDay.AddDays(get_Apply_Max_Day); var item_apply = db0.Apply .Where(x => x.event_strattime != null && (DateTime)x.event_strattime >= setWorkFistDay && (DateTime)x.event_strattime <= setWokrLastDay && (x.audit_state == CodeSheet.audit_state.notaudit.Code || x.audit_state == CodeSheet.audit_state.pass.Code)) .Select(x => new { x.apply_id, x.event_strattime, x.event_area, x.join_num, x.audit_state }).ToList(); //加ToList 強制把資料先讀取出來。 var item_calendar = db0.CalendarDate .Where(x => x.set_date >= setWorkFistDay && x.set_date <= setWokrLastDay) .Select(x => new { x.calendardate_id, x.set_date, x.state, x.eventarea_code }).ToList(); #region 日期UI資料排列處理 var getCalendarFirstDay = setWorkFistDay.WeekFirstDay(); var getCalendarLastDay = setWokrLastDay.WeekLastDay(); var getDateSection = (getCalendarLastDay - getCalendarFirstDay).TotalDays + 1; calObj = new ApplyCalendar() { year = DateTime.Now.Year, month = DateTime.Now.Month }; List<WeekObject> wObj = new List<WeekObject>(); WeekObject weekObject = null; List<DayObject> dObj = new List<DayObject>(); for (int i = 0; i < getDateSection; i++) { var setDayObj = getCalendarFirstDay.AddDays(i); if (setDayObj.DayOfWeek == DayOfWeek.Sunday) //遇到星期日 要製作新的Week物件 { if (dObj.Count() > 0) //製作Week物件時 要將之前的資料取出來,但第一排第一天這時是不會有日期資料 { weekObject.dayInfo = dObj.ToArray(); dObj.Clear(); wObj.Add(weekObject); } weekObject = new WeekObject(); //產生新的week物件 } int getNCount = item_apply.Where(x => ((DateTime)x.event_strattime).Year == setDayObj.Year && ((DateTime)x.event_strattime).Month == setDayObj.Month && ((DateTime)x.event_strattime).Day == setDayObj.Day && (x.audit_state == CodeSheet.audit_state.notaudit.Code || x.audit_state == CodeSheet.audit_state.pass.Code) && x.event_area == CodeSheet.apply_area.bufferNorth.Code.CInt()) .Sum(x => x.join_num); int getSCount = item_apply.Where(x => ((DateTime)x.event_strattime).Year == setDayObj.Year && ((DateTime)x.event_strattime).Month == setDayObj.Month && ((DateTime)x.event_strattime).Day == setDayObj.Day && (x.audit_state == CodeSheet.audit_state.notaudit.Code || x.audit_state == CodeSheet.audit_state.pass.Code) && x.event_area == CodeSheet.apply_area.bufferSouth.Code.CInt()) .Sum(x => x.join_num); var NDayState = item_calendar.Where(x => x.set_date.Year == setDayObj.Year && x.set_date.Month == setDayObj.Month && x.set_date.Day == setDayObj.Day && x.eventarea_code == CodeSheet.apply_area.bufferNorth.Code.CInt()); var SDayState = item_calendar.Where(x => x.set_date.Year == setDayObj.Year && x.set_date.Month == setDayObj.Month && x.set_date.Day == setDayObj.Day && x.eventarea_code == CodeSheet.apply_area.bufferSouth.Code.CInt()); int Nstate = 0; int Sstate = 0; if (NDayState.Any()) { Nstate = 1; } if (SDayState.Any()) { Sstate = 1; } dObj.Add(new DayObject() { apply_date = setDayObj, isNowMonth = (setDayObj >= setWorkFistDay && setDayObj <= setWokrLastDay), EventAreaNorth = new ApplyInfo() { code = CodeSheet.apply_area.bufferNorth.Code.CInt(), left_available = get_N_num - getNCount, dayState = Nstate }, EventAreaSouth = new ApplyInfo() { code = CodeSheet.apply_area.bufferSouth.Code.CInt(), left_available = get_S_num - getSCount, dayState = Sstate }, }); } if (dObj.Count() > 0) { weekObject.dayInfo = dObj.ToArray(); dObj.Clear(); wObj.Add(weekObject); } calObj.weekInfo = wObj.ToArray(); rAjaxResult.data = calObj; #endregion } rAjaxResult.result = true; return defJSON(rAjaxResult); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.message = ex.Message; return defJSON(rAjaxResult); } }
public string getOptionInfo(int apply_area_id) { rAjaxGetData<IList<DayObject>> rAjaxResult = new rAjaxGetData<IList<DayObject>>(); DateTime setWorkFistDay = DateTime.Now.AddDays(15);//提前七天才可申請 try { var getLogic = openLogic(); using (db0 = getLogic.getDB0) { //參數:取得申請日期最大期限 int get_Max_Days = 0; //參數:取得申請人數最大上限 int get_Max_num = 0; if (apply_area_id == CodeSheet.apply_area.bufferNorth.Code.CInt()) { get_Max_Days = (int)getLogic.getParmValue(ParmDefine.bufferNorth_Max); get_Max_num = (int)getLogic.getParmValue(ParmDefine.N_Max_joinnum); } if (apply_area_id == CodeSheet.apply_area.bufferSouth.Code.CInt()) { get_Max_Days = (int)getLogic.getParmValue(ParmDefine.bufferSouth_Max); get_Max_num = (int)getLogic.getParmValue(ParmDefine.N_Max_joinnum); } DateTime setWokrLastDay = setWorkFistDay.AddDays(get_Max_Days); var item_apply = db0.Apply .Where(x => x.event_strattime != null && (DateTime)x.event_strattime >= setWorkFistDay && (DateTime)x.event_strattime <= setWokrLastDay && (x.audit_state == CodeSheet.audit_state.notaudit.Code || x.audit_state == CodeSheet.audit_state.pass.Code) && x.event_area == apply_area_id) .Select(x => new { x.apply_id, x.event_strattime, x.event_area, x.join_num, x.audit_state }).ToList(); //加ToList 強制把資料先讀取出來。 var item_calendar = db0.CalendarDate .Where(x => x.set_date >= setWorkFistDay && x.set_date <= setWokrLastDay) .Select(x => new { x.calendardate_id, x.set_date, x.state, x.eventarea_code }).ToList(); #region 日期UI資料排列處理 var getDateSection = (setWokrLastDay - setWorkFistDay).TotalDays + 1; IList<DayObject> dObj = new List<DayObject>(); for (int i = 0; i < getDateSection; i++) { int getCount = 0; Boolean state = true; var setDayObj = setWorkFistDay.AddDays(i); if (apply_area_id == CodeSheet.apply_area.bufferNorth.Code.CInt()) { getCount = item_apply.Where(x => ((DateTime)x.event_strattime).ToString("yyyyMMdd") == setDayObj.ToString("yyyyMMdd") && x.event_area == CodeSheet.apply_area.bufferNorth.Code.CInt() && (x.audit_state == CodeSheet.audit_state.notaudit.Code || x.audit_state == CodeSheet.audit_state.pass.Code)) .Sum(x => x.join_num); var getstate = item_calendar.Where(x => x.set_date.Year == setDayObj.Year && x.set_date.Month == setDayObj.Month && x.set_date.Day == setDayObj.Day && x.eventarea_code == CodeSheet.apply_area.bufferNorth.Code.CInt()); if (getstate.Any()) { state = false; } if (state) { dObj.Add(new DayObject() { apply_date = DateTime.Parse(setDayObj.ToOnlyStandardDate()), EventAreaWork = new ApplyInfo() { code = CodeSheet.apply_area.bufferNorth.Code.CInt(), left_available = get_Max_num - getCount } }); } } if (apply_area_id == CodeSheet.apply_area.bufferSouth.Code.CInt()) { getCount = item_apply.Where(x => ((DateTime)x.event_strattime).ToString("yyyyMMdd") == setDayObj.ToString("yyyyMMdd") && x.event_area == CodeSheet.apply_area.bufferSouth.Code.CInt() && (x.audit_state == CodeSheet.audit_state.notaudit.Code || x.audit_state == CodeSheet.audit_state.pass.Code) ).Sum(x => x.join_num); var getstate = item_calendar.Where(x => x.set_date.Year == setDayObj.Year && x.set_date.Month == setDayObj.Month && x.set_date.Day == setDayObj.Day && x.eventarea_code == CodeSheet.apply_area.bufferSouth.Code.CInt()); if (getstate.Any()) { state = false; } if (state) { dObj.Add(new DayObject() { apply_date = setDayObj, EventAreaWork = new ApplyInfo() { code = CodeSheet.apply_area.bufferSouth.Code.CInt(), left_available = get_Max_num - getCount } }); } } } rAjaxResult.data = dObj; #endregion } rAjaxResult.result = true; return defJSON(rAjaxResult); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.message = ex.Message; return defJSON(rAjaxResult); } }
public async Task<string> aj_MasterGet(string sn) { var item = await roleManager.FindByIdAsync(sn); var r = new rAjaxGetData<IdentityRole>() { data = item }; return defJSON(r); }
public IHttpActionResult GetCheckApply([FromUri]q_Apply_Detail_Evaporate q) { using (db0 = getDB0()) { string user_id = string.Empty; if (q.user_id == null) { user_id = this.UserId; } else { user_id = q.user_id; } rAjaxGetData<m_Apply> r = new rAjaxGetData<m_Apply>(); r.hasData = db0.Apply.Any(x => x.y == allowApplyYear && x.userid == this.UserId); if (r.hasData) { var md = db0.Apply .Where(x => x.y == allowApplyYear && x.userid == this.UserId) .Select(x => new m_Apply() { apply_id = x.apply_id, doc_date = x.doc_date, doc_gender = x.doc_gender, doc_name = x.doc_name, doc_rank = x.doc_rank, doc_tel = x.doc_tel, mng_gender = x.mng_gender, mng_name = x.mng_name, mng_rank = x.mng_rank, mng_tel = x.mng_tel, y = x.y, userid = x.userid, start_date = x.start_date, end_date = x.end_date }).FirstOrDefault(); var mds = db0.Apply_Detail_Evaporate.Where(x => x.apply_id == md.apply_id) .Select(x => new m_Apply_Detail_Evaporate() { equipment_id = x.equipment_id, equipment_sn = x.Equipment_Chiller.equipment_sn, apply_detail_evaporate_id = x.apply_detail_evaporate_id, td_set = x.td_set, td_value_01 = x.td_value_01, td_value_02 = x.td_value_02, td_value_03 = x.td_value_03, td_value_04 = x.td_value_04, td_value_05 = x.td_value_05, td_value_06 = x.td_value_06, td_value_07 = x.td_value_07, td_value_08 = x.td_value_08, td_value_09 = x.td_value_09, td_value_10 = x.td_value_10, td_value_11 = x.td_value_11, td_value_12 = x.td_value_12, abnormal_01 = x.abnormal_01, abnormal_02 = x.abnormal_02, abnormal_03 = x.abnormal_03, abnormal_04 = x.abnormal_04, abnormal_05 = x.abnormal_05, abnormal_06 = x.abnormal_06, abnormal_07 = x.abnormal_07, abnormal_08 = x.abnormal_08, abnormal_09 = x.abnormal_09, abnormal_10 = x.abnormal_10, abnormal_11 = x.abnormal_11, abnormal_12 = x.abnormal_12 }); var nds = db0.Apply_Detail_Condenser.Where(x => x.apply_id == md.apply_id) .Select(x => new m_Apply_Detail_Condenser() { equipment_id = x.equipment_id, equipment_sn = x.Equipment_Chiller.equipment_sn, apply_detail_condenser_id = x.apply_detail_condenser_id, td_set = x.td_set, td_value_01 = x.td_value_01, td_value_02 = x.td_value_02, td_value_03 = x.td_value_03, td_value_04 = x.td_value_04, td_value_05 = x.td_value_05, td_value_06 = x.td_value_06, td_value_07 = x.td_value_07, td_value_08 = x.td_value_08, td_value_09 = x.td_value_09, td_value_10 = x.td_value_10, td_value_11 = x.td_value_11, td_value_12 = x.td_value_12, abnormal_01 = x.abnormal_01, abnormal_02 = x.abnormal_02, abnormal_03 = x.abnormal_03, abnormal_04 = x.abnormal_04, abnormal_05 = x.abnormal_05, abnormal_06 = x.abnormal_06, abnormal_07 = x.abnormal_07, abnormal_08 = x.abnormal_08, abnormal_09 = x.abnormal_09, abnormal_10 = x.abnormal_10, abnormal_11 = x.abnormal_11, abnormal_12 = x.abnormal_12 }); md.apply_Detail_Evaporate = mds.ToList(); md.apply_Detail_Condenser = nds.ToList(); r.data = md; } else { r.message = allowApplyYear + "年度尚未申報"; } return Ok<rAjaxGetData<m_Apply>>(r); }; }
/// <summary> /// 2016/3/15 將負載調控改為同表二、表三方式 /// </summary> /// <param name="q"></param> /// <returns></returns> public IHttpActionResult GetQueryLoadingYear([FromUri]q_Apply_Detail_Loading q) { #region 連接BusinessLogicLibary資料庫並取得資料 rAjaxGetData<Apply_Detail_Loading> r = new rAjaxGetData<Apply_Detail_Loading>(); using (db0 = getDB0()) { var getUserIdCK = this.UserId; string getUserId = this.UserId == null ? q.user_id : this.UserId; r.data = db0.Apply_Detail_Loading .Where(x => x.y == q.y && x.equipment_id == q.equipment_chiller_id).FirstOrDefault(); r.hasData = r.data == null ? false : true; if (!r.hasData) r.message = "查無資料"; return Ok<rAjaxGetData<Apply_Detail_Loading>>(r); } #endregion }
public IHttpActionResult GetCheckMonthAverage() { using (db0 = getDB0()) { rAjaxGetData<IList<m_Apply_Detail_Condenser>> r = new rAjaxGetData<IList<m_Apply_Detail_Condenser>>(); r.hasData = db0.Apply_Detail_Condenser.Any(x => x.y == allowApplyYear && x.userid == this.UserId); if (r.hasData) { r.data = db0.Apply_Detail_Condenser .Where(x => x.y == allowApplyYear && x.userid == this.UserId) .Select(x => new m_Apply_Detail_Condenser() { equipment_id = x.equipment_id, equipment_sn = x.Equipment_Chiller.equipment_sn, td_value_01 = x.td_value_01, td_value_02 = x.td_value_02, td_value_03 = x.td_value_03, td_value_04 = x.td_value_04, td_value_05 = x.td_value_05, td_value_06 = x.td_value_06, td_value_07 = x.td_value_07, td_value_08 = x.td_value_08, td_value_09 = x.td_value_09, td_value_10 = x.td_value_10, td_value_11 = x.td_value_11, td_value_12 = x.td_value_12 }) .OrderBy(x => x.equipment_id).ToList(); } else { r.message = allowApplyYear + "年度尚未申報"; } return Ok<rAjaxGetData<IList<m_Apply_Detail_Condenser>>>(r); }; }
public async Task<IHttpActionResult> Get(string sn) { var item = await roleManager.FindByIdAsync(sn); var r = new rAjaxGetData<IdentityRole>() { data = item }; return Ok(r); }