public ActionResult Load_MajorModuleMenuOnly() { try { MenuPanel mp = new MenuPanel(); DataSet PrSet = sec.GetMajorModules(); foreach (DataRow dr in PrSet.Tables[0].Rows) { MenuItem me_nu = new MenuItem(); me_nu.ID = "N" + dr["MODULE_CODE"].ToString(); me_nu.Text = dr["MODULE_NAME"].ToString(); string mod_id = dr["MODULE_CODE"].ToString(); me_nu.DirectClickAction = Url.Action("Get_SubModuleForMajorModule", "UserGroupPermission"); me_nu.DirectEvents.Click.ExtraParams.Add(new { moduleid = mod_id }); me_nu.DirectEvents.Click.ExtraParams.Add(new StoreParameter { Name = "txt_UserGroupId", Value = "App.UserGroupId.getValue()", Mode = ParameterMode.Raw }); //me_nu.DirectEvents.Click.ExtraParams.Add(new Parameter("UserGroup_Idx", "UserGroupId.getValue()",ParameterMode.Value )); //me_nu.DirectEvents.Click.ExtraParams.Add(new { UserGroup_Id = "App.UserGroupId.getValue()", ParameterMode.Value }); mp.Menu.Items.Add(me_nu); MenuSeparator m_sp = new MenuSeparator(); mp.Menu.Items.Add(m_sp); } /////----just for test----- ////////for (int i = 100; i <= 130; i++) ////////{ //////// MenuItem menuitem = new MenuItem(); //////// menuitem.ID = "xxs" + i.ToString(); //////// menuitem.Text = "Menu " + i.ToString().ToUpper(); //////// menuitem.Width = 290; //////// menuitem.MinWidth = 290; //////// //menuitem.Cls = "right-nav-menu"; //////// mp.Menu.Items.Add(menuitem); //////// MenuSeparator m_sp = new MenuSeparator(); //////// mp.Menu.Items.Add(m_sp); ////////} return(this.Content(ComponentLoader.ToConfig(mp))); } catch (Exception) { throw; } }
public string Items() { return(ComponentLoader.ToConfig(new List <AbstractComponent>() { new Panel { Title = "Item 1", Icon = Icon.UserBrown }, new Panel { Title = "Item 2", Icon = Icon.UserGray }, new Panel { Title = "Item 3", Icon = Icon.UserGreen } } )); }
public override void ExecuteResult(ControllerContext context) { if (this.component != null) { context.HttpContext.Response.Write(ComponentLoader.ToConfig(this.component)); } else if (this.components != null) { context.HttpContext.Response.Write(ComponentLoader.ToConfig(this.components)); } else { PartialViewResult result = new PartialViewResult(); result.RenderMode = RenderMode.AddTo; result.Config = true; if (this.viewName.IsNotEmpty()) { result.ViewName = this.viewName; } if (this.model != null) { result.Model = this.model; } if (this.viewData != null) { result.ViewData = this.viewData; } if (this.tempData != null) { result.TempData = this.tempData; } result.ExecuteResult(context); context.HttpContext.Response.Write(result.Output); } }
public static string GetGrid(Dictionary <string, string> parameters) { string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["SIA_ConnectionString"].ConnectionString; string JsonRecord = parameters["id"]; Dictionary <string, string>[] GridData = JSON.Deserialize <Dictionary <string, string>[]>(JsonRecord); string asignado; asignado = GridData[0]["asignado"]; string sql_detalle = ""; sql_detalle += " Select us.nombre,wf.correlativo,wf.plan_,wf.asegurado,wf.cantidadsolicitudes,CONVERT(date,wf.ingresado,101) ingresado,wf.estado, "; sql_detalle += " DATEDIFF(DAY,convert(date,ingresado,101),convert(date,getdate(),101)) dias "; sql_detalle += " from wf_seguimiento_95 wf "; sql_detalle += " inner join dbo.Usuarios us on us.usuario=wf.asignado "; sql_detalle += " where wf.area='EMISION' and wf.asignado=@asignado "; SqlConnection con = new SqlConnection(strCon); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 36000; cmd.CommandText = sql_detalle; cmd.Parameters.AddWithValue("@asignado", asignado); cmd.Connection = con; cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable datatable = new DataTable(); da.Fill(datatable); con.Close(); GridPanel grid = new GridPanel { Layout = "FitLayout", RowLines = true, EnableColumnHide = false, Store = { new Store { Model = { new Model { Fields = { new ModelField("nombre"), new ModelField("correlativo"), new ModelField("plan_"), new ModelField("asegurado"), new ModelField("cantidadsolicitudes"), new ModelField("ingresado"), new ModelField("estado"), new ModelField("dias"), } } }, DataSource = datatable } }, ColumnModel = { Columns = { new Column { Text = "Nombre", DataIndex = "nombre", Width = 180 }, new Column { Text = "Referencia", DataIndex = "correlativo", Width = 100 }, new Column { Text = "Plan", DataIndex = "plan_", Width = 100 }, new Column { Text = "Asegurado", DataIndex = "asegurado", Width = 100 }, new Column { Text = "Cant. Solicitudes", DataIndex = "cantidadsolicitudes", Width = 100 }, new Column { Text = "Fecha de Ingreso.", DataIndex = "ingresado", Width = 100 }, new Column { Text = "Tarea", DataIndex = "estado", Width = 300 }, new Column { Text = "Indicador en Dias", DataIndex = "dias", Width = 150 }, } }, }; return(ComponentLoader.ToConfig(grid)); }
public static string GetGrid(Dictionary <string, string> parameters) { string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["SIA_ConnectionString"].ConnectionString; string JsonRecord = parameters["id"]; Dictionary <string, string>[] GridData = JSON.Deserialize <Dictionary <string, string>[]>(JsonRecord); string codigo; codigo = GridData[0]["codigo"]; string sql_detalle = ""; sql_detalle += " SELECT det.codigo, det.req_cod,det.req_nombre,det.area,det.cant_pasos "; sql_detalle += " FROM dbo.requisitos AS re "; sql_detalle += " INNER JOIN dbo.Maestro_Porcentaje_detalle AS det ON det.codigo = @codigo "; sql_detalle += " Where re.codigo = det.codigo "; SqlConnection con = new SqlConnection(strCon); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 36000; cmd.CommandText = sql_detalle; cmd.Parameters.AddWithValue("@codigo", codigo); cmd.Connection = con; cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable datatable = new DataTable(); da.Fill(datatable); con.Close(); GridPanel grid = new GridPanel { Layout = "FitLayout", RowLines = true, ID = "GridPanelConsulta", EnableColumnHide = false, Store = { new Store { Model = { new Model { Fields = { new ModelField("codigo"), new ModelField("req_cod"), new ModelField("req_nombre"), new ModelField("area"), new ModelField("cant_pasos"), } } }, DataSource = datatable } }, ColumnModel = { Columns = { new Column { Text = "codigo", DataIndex = "codigo", Width = 100 }, new Column { Text = "req. Cod.", DataIndex = "req_cod", Width = 100 }, new Column { Text = "Req. Nombre", DataIndex = "req_nombre", Width = 300 }, new Column { Text = "Area", DataIndex = "area", Width = 150 }, new Column { Text = "Puntos", DataIndex = "cant_pasos", Width = 85 }, } }, //Listeners = //{ // //ItemDblClick = { Handler = "var codente = record.data.llave; var url = 'imagen.aspx?codigoente=' + codente; #{Panel2}.getLoader().load({url:url});" }, // //ItemDblClick = { Handler = "#{WindowConsulta}.show()" } // ItemDblClick = { Handler = " OnEvent=RealizarConsulta, Ext.encode(#{GridPanelConsulta}.getRowsValues({selectedOnly:true})" } // //ItemDblClick = { Handler = "Ext.net.Notification.show({iconCls : 'icon-information',pinEvent :'click',title:'123'});" } //} }; return(ComponentLoader.ToConfig(grid)); }
public ActionResult LoadModulesMainMenu() { try { // get group id string userid = User.Identity.Name; sec.Get_GroupId(userid); //GlobalValue.User_GroupID = "G100"; DataTable dt = sec.GetMajorModuleAcessForAUserGroup(GlobalValue.User_GroupID, 0); List <MenuItem> menuitems = new List <MenuItem>(); foreach (DataRow module in dt.Rows) { MenuItem menuitem = new MenuItem(); menuitem.ID = module["ModuleId"].ToString(); menuitem.Text = module["Module_Name"].ToString().ToUpper(); menuitem.Width = 290; menuitem.MinWidth = 290; //menuitem.Cls = "right-nav-menu"; string mod_id = module["ModuleId"].ToString(); switch (mod_id) { case "100": menuitem.Icon = Icon.ServerKey; break; case "101": menuitem.Icon = Icon.FlagGh; break; } ////////menuitem.StyleSpec = "border-color:white;"; ////menuitem.DirectClickAction = "StartUp/GetSubModule"; menuitem.DirectClickAction = Url.Action("GetChildren", "StartUp"); menuitem.DirectEvents.Click.ExtraParams.Add(new { moduleid = module["ModuleId"].ToString() }); //menuitem.DirectEvents.Click.ExtraParams.Add(new Parameter("containerId", "pnlNav")); //menuitem.DirectEvents.Click.ExtraParams.Add(new Parameter("containerId", "App.Viewp")); ////menuitem.DirectEvents.Click.Before = "App.leftnav.removeAll()"; //// menuitem.Icon = Icon.ApplicationOsxDouble; ////menuitem.DirectEvents.Click.Confirmation.ConfirmRequest = true; ////menuitem.DirectEvents.Click.Confirmation.Message = module.ModuleId; menuitems.Add(menuitem); } X.Mask.Hide(); return(this.Content(ComponentLoader.ToConfig(menuitems))); } catch (Exception ex) { X.Mask.Hide(); string sss = ex.ToString(); return(null); } finally { } }
public static string GetGrid(Dictionary <string, string> parameters) { string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["SIA_ConnectionString"].ConnectionString; string JsonRecord = parameters["id"]; Dictionary <string, string>[] GridData = JSON.Deserialize <Dictionary <string, string>[]>(JsonRecord); string codigo; codigo = GridData[0]["codigo"]; string sql_detalle = ""; sql_detalle += " SELECT det.codigo, det.req_cod,det.req_nombre,det.necesario "; sql_detalle += " FROM dbo.requisitos AS re "; sql_detalle += " INNER JOIN dbo.Check_list_detalle AS det ON det.codigo = @codigo "; sql_detalle += " Where re.codigo = det.codigo "; SqlConnection con = new SqlConnection(strCon); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 36000; cmd.CommandText = sql_detalle; cmd.Parameters.AddWithValue("@codigo", codigo); cmd.Connection = con; cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable datatable = new DataTable(); da.Fill(datatable); con.Close(); GridPanel grid = new GridPanel { Layout = "FitLayout", RowLines = true, EnableColumnHide = false, Store = { new Store { Model = { new Model { Fields = { new ModelField("codigo"), new ModelField("req_cod"), new ModelField("req_nombre"), new ModelField("necesario"), } } }, DataSource = datatable } }, ColumnModel = { Columns = { new Column { Text = "codigo", DataIndex = "codigo", Width = 300 }, new Column { Text = "req. Cod.", DataIndex = "req_cod", Width = 300 }, new Column { Text = "Req. Nombre", DataIndex = "req_nombre", Width = 300 }, new CheckColumn { Text = "Necesario", DataIndex = "necesario", }, } } }; return(ComponentLoader.ToConfig(grid)); }
public static string GetGrid(Dictionary <string, string> parameters) { string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["SIA_ConnectionString"].ConnectionString; string JsonRecord = parameters["id"]; Dictionary <string, string>[] GridData = JSON.Deserialize <Dictionary <string, string>[]>(JsonRecord); string correlativo; correlativo = GridData[0]["correlativo"]; string sql_detalle = ""; sql_detalle += " select wf.correlativo, case when ej.recepcion is null then DATEDIFF(DAY,convert(date,ej.ingreso,101),convert(date,getdate(),101)) "; sql_detalle += " else DATEDIFF(DAY,convert(date,ej.ingreso,101),convert(date,ej.recepcion,101)) end as recepcion, "; sql_detalle += " case when ej.analisis is null then DATEDIFF(DAY,convert(date,ej.recepcion,101),convert(date,getdate(),101)) when ej.analisis is null and ej.recepcion is null then 0 "; sql_detalle += " else DATEDIFF(DAY,convert(date,ej.recepcion,101),convert(date,ej.analisis,101)) end as analisis, "; sql_detalle += " case when ej.emision is null then DATEDIFF(DAY,convert(date,ej.analisis,101),convert(date,getdate(),101)) when ej.emision is null and ej.analisis is null then 0 "; sql_detalle += " else DATEDIFF(DAY,convert(date,ej.analisis,101),convert(date,ej.emision,101)) end as emision, "; sql_detalle += " case when ej.firmas is null then DATEDIFF(DAY,convert(date,ej.emision,101),convert(date,getdate(),101)) when ej.firmas is null and ej.emision is null then 0 "; sql_detalle += " else DATEDIFF(DAY,convert(date,ej.emision,101),convert(date,ej.firmas,101)) end as firmas, "; sql_detalle += " case when ej.entrega is null then DATEDIFF(DAY,convert(date,ej.firmas,101),convert(date,getdate(),101)) when ej.entrega is null and ej.firmas is null then 0 "; sql_detalle += " else DATEDIFF(DAY,convert(date,ej.firmas,101),convert(date,ej.entrega,101)) end as entrega, "; sql_detalle += " case when ej.atencion_cliente is null then DATEDIFF(DAY,convert(date,ej.entrega,101),convert(date,getdate(),101)) when ej.atencion_cliente is null and ej.entrega is null then 0 "; sql_detalle += " else DATEDIFF(DAY,convert(date,ej.entrega,101),convert(date,ej.atencion_cliente,101)) end as atencion_cliente, "; sql_detalle += " case when ej.completado is null then 0 "; sql_detalle += " else DATEDIFF(DAY,convert(date,ej.ingreso,101),convert(date,ej.completado,101)) end as completado "; sql_detalle += " from wf_seguimiento_95 wf "; sql_detalle += " inner join dbo. ejecucion ej on ej.correlativo=wf.correlativo "; sql_detalle += " where wf.correlativo = @correlativo "; SqlConnection con = new SqlConnection(strCon); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 36000; cmd.CommandText = sql_detalle; cmd.Parameters.AddWithValue("@correlativo", correlativo); cmd.Connection = con; cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable datatable = new DataTable(); da.Fill(datatable); con.Close(); GridPanel grid = new GridPanel { Layout = "AutoLayout", RowLines = true, EnableColumnHide = false, Store = { new Store { Model = { new Model { Fields = { new ModelField("correlativo"), new ModelField("recepcion"), new ModelField("analisis"), new ModelField("emision"), new ModelField("firmas"), new ModelField("entrega"), new ModelField("atencion_cliente"), new ModelField("completado") } } }, DataSource = datatable } }, ColumnModel = { Columns = { new Column { Text = "correlativo", DataIndex = "correlativo", Width = 100 }, new Column { Text = "Recepcion", DataIndex = "recepcion", Width = 100 }, new Column { Text = "Analisis", DataIndex = "analisis", Width = 100 }, new Column { Text = "Emision", DataIndex = "emision", Width = 100 }, new Column { Text = "Firmas", DataIndex = "firmas", Width = 100 }, new Column { Text = "Entrega", DataIndex = "entrega", Width = 100 }, new Column { Text = "Atencion al Cliente", DataIndex = "atencion_cliente", Width = 180 }, new Column { Text = "Completado", DataIndex = "completado", Width = 100 }, } }, }; return(ComponentLoader.ToConfig(grid)); }
public static string GetGrid(Dictionary <string, string> parameters) { string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["SIA_ConnectionString"].ConnectionString; string JsonRecord = parameters["id"]; Dictionary <string, string>[] GridData = JSON.Deserialize <Dictionary <string, string>[]>(JsonRecord); string correlativo; correlativo = GridData[0]["correlativo"]; string sql_detalle = ""; sql_detalle += " SELECT det.correlativo,det.cod_area,det.req_cod,det.req_nombre,det.descripcion,RTRIM(det.llave) llave "; sql_detalle += " FROM dbo.wf_seguimiento_95 AS re "; sql_detalle += " INNER JOIN dbo.check_list_detalle_recpcion AS det ON det.correlativo = @correlativo "; sql_detalle += " Where re.correlativo = det.correlativo "; SqlConnection con = new SqlConnection(strCon); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 36000; cmd.CommandText = sql_detalle; cmd.Parameters.AddWithValue("@correlativo", correlativo); cmd.Connection = con; cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable datatable = new DataTable(); da.Fill(datatable); con.Close(); GridPanel grid = new GridPanel { Layout = "FitLayout", RowLines = true, EnableColumnHide = false, Store = { new Store { Model = { new Model { Fields = { new ModelField("correlativo"), new ModelField("cod_area"), new ModelField("req_cod"), new ModelField("req_nombre"), new ModelField("descripcion"), new ModelField("llave") } } }, DataSource = datatable } }, ColumnModel = { Columns = { new Column { Text = "correlativo", DataIndex = "correlativo", Width = 100 }, new Column { Text = "cod_area", DataIndex = "cod_area", Width = 100 }, new Column { Text = "req. Cod.", DataIndex = "req_cod", Width = 100 }, new Column { Text = "Req. Nombre", DataIndex = "req_nombre", Width = 300 }, new Column { Text = "descripcion", DataIndex = "descripcion", Width = 300 }, } }, Listeners = { //ItemDblClick = { Handler = "Ext.net.Notification.show({iconCls : 'icon-information',pinEvent :'click',title:record.data.descripcion});" } //ItemDblClick = {Handler = "#{Panel2}.getLoader().load({url: 'imagen.aspx" + "?codigoente=" + "record.data.descripcion'});"} ItemDblClick = { Handler = "var codente = record.data.llave; var url = 'imagen.aspx?codigoente=' + codente; #{Panel2}.getLoader().load({url:url});" }, //ItemClick = { Handler = "var codente = record.data.llave; var url = 'imagen.aspx?codigoente=' + codente; #{Panel2}.getLoader().load({url:url});" } //<iframe name="vipracing" src="http://vipracing.info/channel/opcion-9/frame" width="653" height="410" scrolling="no"></iframe> //ItemDblClick = {Handler = "var url_descrip = record.data.descripcion; #{Panel2}.getLoader().load({url: url_descrip });"} //ItemDblClick = { Handler = "Ext.net.Notification.show({iconCls : 'icon-information',pinEvent :'click',title:record.data.descripcion});" } //ItemDblClick = { Handler = "#{Panel2}.{Toolbar1}.{Panel1}.getLoader().Url = '../files/PROPUESTA.PDF'" } //ItemDblClick = { Handler = "Ext.net.Notification.show({iconCls : 'icon-information',pinEvent :'click',title:record.data.descripcion});" } //ItemDblClick = { Handler = "#{Ext:Panel#Panel2}.{Topbar}.{Ext:Toolbar#Toolbar1}.{Items}.{Ext:Panel#Panel1}.{Ext:Loader#Loader3}.Url = '../files/PROPUESTA.PDF');" } //ItemDblClick = { Handler = "#{Panel2}.{Topbar}.{Toolbar1}.{Items}.{Panel1}.{Loader3}.Url:record.data.descripcion);" } //ItemDblClick = { Handler = "#{WindowVisualizador}.getLoader().url = '../files/318i TwinPower Turbo Luxury (1).pdf')" } //ItemDblClick = { Handler = "#{Loader3}.show('Url=../files/318i TwinPower Turbo Luxury (1).pdf')" }, //ItemDblClick = { Handler = "record.data.descripcion" }, //ItemDblClick = { Handler = "#{Panel2}.getLoader().load({url: 'ver_adjuntos_.aspx'});" } } }; return(ComponentLoader.ToConfig(grid)); }
public string UserControl() { return(ComponentLoader.ToConfig("~/Examples/Loaders/_Shared/Items.ascx")); }