public JsonResult GetAllModule(int type) { try { //string sql = "select code_id,description from mmview.frcode where category_id='Department'"; DB2DataCatcher <FRCodeModel> CodeCatcher = new DB2DataCatcher <FRCodeModel>("MMVIEW.FRCODE") { Conditions = "where category_id='Department'" }; switch (type) { case 0: break; case 1: CodeCatcher.Conditions += "and description !='IT'"; break; case 2: CodeCatcher.Conditions += "and code_id not in ('IT','WD')"; break; default: //default不处理 break; } var list = CodeCatcher.GetEntities().EntityList; var modules = list.Select(s => new { s.Code_ID, s.Description }); return(Json(new { success = true, modules })); } catch (Exception ex) { return(Json(new { success = false, msg = ex.Message })); } }
public static double GetCount(string title) { DB2DataCatcher <RPTFuncUsage> CountCatcher = new DB2DataCatcher <RPTFuncUsage>("ISTRPT.RPTFuncUsage") { Conditions = string.Format("where privilegeid='{0}'", title) }; var list = CountCatcher.GetEntities().EntityList; double count = list.Any() ? list.First().Usage_Counter : 0; return(count); }
public JsonResult GetEDCTable() { DB2DataCatcher <Rpt_Non_Lot_Edc_Plan> catcher = new DB2DataCatcher <Rpt_Non_Lot_Edc_Plan>("ISTRPT.Rpt_Non_Lot_Edc_Plan"); List <Rpt_Non_Lot_Edc_Plan> list = new List <Rpt_Non_Lot_Edc_Plan>(); catcher.GetEntities(); list = catcher.entities.EntityList.Any() ? catcher.entities.EntityList.ToList() : list; var response = list.Select(s => new { EqpID = s.Eqp_ID, EdcPlan = s.Edc_Plan, s.Period, PeriodType = s.Period_Type, id = s.GetHashCode() }); return(Json(new { success = true, EdcTable = response })); }
// GET: ReqRpt048 public ActionResult Index() { DB2DataCatcher <RPTFuncUsage> CountCatcher = new DB2DataCatcher <RPTFuncUsage>("ISTRPT.RPTFuncUsage") { Conditions = "where privilegeid='RPT000048'" }; var list = CountCatcher.GetEntities().EntityList; double count = list.Any() ? list.First().Usage_Counter : 0; ViewBag.ClickCount = count; return(View()); }