コード例 #1
0
        public void IndexVerificacion()
        {
            StatusMeeting statusMeeting1 = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE);
            StatusMeeting statusMeeting2 = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE_LEGAL);
            StatusCase    sc             = services.statusCasefindByCode(Constants.CASE_STATUS_MEETING);

            using (var db = FactoryConn.GetConn()) {
                var result = db.Query <MeetingTblDto> (
                    "SELECT cs.id_case as 'CaseId',cs.id_folder as 'IdFolder',im.name as 'Name',im.lastname_p as 'LastNameP',im.lastname_m as 'LastNameM',"
                    + " im.birth_date as 'DateBirth', im.gender as 'Gender', csm.status as 'StatusCode', csm.description as 'Description'"
                    + " FROM meeting as me "
                    + " left JOIN case_detention as cs ON me.id_case = cs.id_case "
                    + " left JOIN imputed as im ON im.id_meeting = me.id_meeting "
                    + " left JOIN cat_status_meeting as csm ON csm.id_status = me.id_status "
                    + " WHERE me.id_status in (?,?) "
                    //				+" and me.id_reviewer = 2 "
                    + " AND cs.id_status = ?; ", statusMeeting1.Id, statusMeeting2.Id, sc.Id);



                var temp = new MeetingList {
                    Model = result
                };
                var pagestring = "nada que ver";
                pagestring = temp.GenerateString();
                webView.LoadHtmlString(pagestring);
                db.Close();
            }
        }
コード例 #2
0
        public void MeetingIndex()
        {
            var temp       = new MeetingList();
            var pagestring = "nada que ver";

            pagestring = temp.GenerateString();
            webView.LoadHtmlString(pagestring);
        }
コード例 #3
0
        public void Index()
        {
            init();
            StatusMeeting statusMeeting1 = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE);
            StatusMeeting statusMeeting2 = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE_LEGAL);
            StatusCase    sc             = services.statusCasefindByCode(Constants.CASE_STATUS_MEETING);
            StatusCase    sc1            = services.statusCasefindByCode(Constants.ST_CASE_TABLET_ASSIGNED);

            using (var db = FactoryConn.GetConn()) {
                db.CreateTable <User> ();
                var  usrList  = db.Table <User> ().ToList();
                User reviewer = usrList.FirstOrDefault();
                int  revId    = 0;
                if (reviewer != null && reviewer.Id != 0)
                {
                    revId = reviewer.Id;
                }

                var result = db.Query <MeetingTblDto> (
                    "SELECT cs.id_case as 'CaseId',cs.id_folder as 'IdFolder',im.name as 'Name',im.lastname_p as 'LastNameP',im.lastname_m as 'LastNameM',"
                    + " im.birth_date as 'DateBirth', im.gender as 'Gender', csm.status as 'StatusCode', csm.description as 'Description'"
                    + " FROM meeting as me "
                    + " left JOIN case_detention as cs ON me.id_case = cs.id_case "
                    + " left JOIN imputed as im ON im.id_meeting = me.id_meeting "
                    + " left JOIN cat_status_meeting as csm ON csm.id_status = me.id_status"
                    + " WHERE me.id_status in (?,?) "
                    + " and me.id_reviewer = ? "
                    + " AND cs.id_status in (?,?); ", statusMeeting1.Id, statusMeeting2.Id, revId, sc.Id, sc1.Id);
                var temp = new MeetingList {
                    Model = result
                };
                var pagestring = "nada que ver";
                pagestring = temp.GenerateString();
                webView.LoadHtmlString(pagestring);
                db.Close();
            }
        }