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