//_SharePriceText
public string _SharePriceText()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "_SharePriceText");
jGridView.SQL = @"select Code,Text,case Type when 1 then N'متن درخواست خرید' else N'متن درخواست فروش' end As [Type],ClassName from entSharePriceText";
jGridView.Title = "SharePriceText";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("Update", "Update", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._SharePriceTextUpdate", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Report));
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
//_AboutUsTextAndPic
public string _AboutUsTextAndPic()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "_AboutUsTextAndPic");
jGridView.SQL = Entertainment.JAboutUss.GetSqlQuery();
jGridView.Title = "News";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("New", "New", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._AboutUsTextAndPicNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Add));
jGridView.Toolbar.AddButton("Edit", "Edit", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._AboutUsTextAndPicUpdate", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Edit));
jGridView.Actions = new List <JActionsInfo>();
jGridView.Actions.Add(new JActionsInfo("GridItemDblClick", JDomains.JActionEvents.GridItemDblClick, _ConstClassName + "._AboutUsTextAndPicUpdate", null, null));
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
//_BuyRequest
public string _BuyRequest()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "_BuyRequest");
jGridView.SQL = ManagementShares.TransferRequest.JRequests.GetBuyRequestSqlQuery();
jGridView.Title = "BuyRequest";
jGridView.PageOrderByField = "RequestDate desc";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("ChangeStatus", "ChangeStatus", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._BuyRequestChangeStatus", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Report));
jGridView.ClassName = "AndroidWebManagement.JAndroidWebManagement._BuyRequest";
jGridView.ObjectCode = 0;
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
//_Ground
public string _Ground()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "._Ground");
jGridView.SQL = "select * from Android_Ground";
jGridView.PageOrderByField = "Code desc";
jGridView.Title = "Ground";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("New", "New", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._GroundNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Add));
jGridView.Toolbar.AddButton("Edit", "Edit", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._GroundUpdate", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Edit));
jGridView.Actions = new List <JActionsInfo>();
jGridView.Actions.Add(new JActionsInfo("GridItemDblClick", JDomains.JActionEvents.GridItemDblClick, _ConstClassName + "._GroundUpdate", null, null));
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
//_PicGallery
public string _PicGallery()
{
// ArchivedDocuments.JArchiveDocument archive = new ArchivedDocuments.JArchiveDocument(ArchivedDocuments.JConstantArchiveSubjects.ImagesArchiveCode.GetHashCode(), ArchivedDocuments.JConstantArchivePalces.GeneralArchive.GetHashCode());
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "_PicGallery");
jGridView.SQL = Entertainment.JPicGallerys.GetSqlQuery();;
jGridView.Title = "PicGallery";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("New", "New", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._PicGalleryNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Add));
jGridView.Toolbar.AddButton("Edit", "Edit", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._PicGalleryUpdate", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Edit));
jGridView.Actions = new List <JActionsInfo>();
jGridView.Actions.Add(new JActionsInfo("GridItemDblClick", JDomains.JActionEvents.GridItemDblClick, _ConstClassName + "._PicGalleryUpdate", null, null));
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
//_SharePrice
public string _SharePrice()
{
ArchivedDocuments.JArchiveDocument archive = new ArchivedDocuments.JArchiveDocument(ArchivedDocuments.JConstantArchiveSubjects.ImagesArchiveCode.GetHashCode(), ArchivedDocuments.JConstantArchivePalces.GeneralArchive.GetHashCode());
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "_SharePrice");
jGridView.SQL = "select * from SharePrice";
jGridView.Title = "SharePrice";
jGridView.PageOrderByField = "ChangeDate DESC";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("New", "New", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._SharePriceNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Add));
jGridView.Toolbar.AddButton("Edit", "Edit", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._SharePriceUpdate", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Edit));
jGridView.Actions = new List <JActionsInfo>();
jGridView.Actions.Add(new JActionsInfo("GridItemDblClick", JDomains.JActionEvents.GridItemDblClick, _ConstClassName + "._SharePriceUpdate", null, null));
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
public string _News()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "_Newss");
jGridView.SQL = Entertainment.JNewss.GetSqlQuery();
jGridView.Title = "Newss";
jGridView.PageOrderByField = " Code desc ";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("New", "New", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._NewsNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Add));
jGridView.Toolbar.AddButton("Edit", "Edit", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._NewsUpdate", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Edit));
jGridView.Actions = new List <JActionsInfo>();
jGridView.Actions.Add(new JActionsInfo("GridItemDblClick", JDomains.JActionEvents.GridItemDblClick, _ConstClassName + "._NewsUpdate", null, null));
jGridView.ClassName = "AndroidWebManagement.JAndroidWebManagement._Newss";
jGridView.ObjectCode = 0;
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
//_InBox
public string _InBox()
{
ManagementShares.JShareCompany Company = new ManagementShares.JShareCompany(1);
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "_InBox");
jGridView.SQL = @"select ShareMessage.Code, SenderCode, ReceiverCode ,
sps.SharePCode,(select top 1 Name from clsAllPerson where code = ShareMessage .SenderCode) SenderName
,(select top 1 Name from clsAllPerson where code = ShareMessage .ReceiverCode) ReceiverName, sDate,Title, Body
from ShareMessage
left join (select * from SharePCodeSheet where CompanyCode = 1) sps on sps.PersonCode = ShareMessage.SenderCode
where Type = 2 and ReceiverCode in(" + WebClassLibrary.SessionManager.Current.MainFrame.CurrentPersonCode + @"," + Company.PCode + @")";
jGridView.Title = "InBox";
jGridView.PageOrderByField = "sDate Desc";
jGridView.PageSize = 5;
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("Delete", "Delete", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._DeleteSendBoxNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Delete));
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
//PicGalleryCategory
public string _PicGalleryCategory()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "._PicGalleryCategory");
jGridView.SQL = @"SELECT [Code]
,[Name]
,[ArchiveCode]
,[InsertDate]
FROM [EntPicGalleryLvl1]";
jGridView.PageOrderByField = "Code desc";
jGridView.Title = "PicGalleryCategory";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("New", "New", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._PicGalleryCategoryNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Add));
jGridView.Toolbar.AddButton("Edit", "Edit", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._PicGalleryCategoryUpdate", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Edit));
jGridView.Actions = new List <JActionsInfo>();
jGridView.Actions.Add(new JActionsInfo("GridItemDblClick", JDomains.JActionEvents.GridItemDblClick, _ConstClassName + "._PicGalleryCategoryUpdate", null, null));
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
public static string GridShow()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_"));
jGridView.ClassName = _ConstClassName.Replace(".", "_") + "_GridShow";
//jGridView.ContextMenuItems = new List<WebControllers.MainControls.Grid.JContextMenuItem>();
// jGridView.ContextMenuItems.Add(new WebControllers.MainControls.Grid.JContextMenuItem() { Text = "New", Action = new WebClassLibrary.JActionsInfo("Click", WebClassLibrary.JDomains.JActionEvents.MouseClick, _ConstClassName + "._NewDevice", null, null) });
// jGridView.ContextMenuItems.Add(new WebControllers.MainControls.Grid.JContextMenuItem() { Text = "Edit", Action = new WebClassLibrary.JActionsInfo("Click", WebClassLibrary.JDomains.JActionEvents.MouseClick, _ConstClassName + "._DeviceUpdate", null, null) });
jGridView.SQL =
@"SELECT * FROM AVLPerson";
jGridView.Title = "اتومبیل سواری";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
// jGridView.Toolbar.AddButton("New", "New", new WebClassLibrary.JActionsInfo("Click", WebClassLibrary.JDomains.JActionEvents.MouseClick, _ConstClassName + "._NewDevice", null, null), WebClassLibrary.JDomains.Images.GetFullPath(WebClassLibrary.JDomains.Images.ControlImages.Toolbar_Add));
// jGridView.Toolbar.AddButton("Edit", "Edit", new WebClassLibrary.JActionsInfo("Click", WebClassLibrary.JDomains.JActionEvents.MouseClick, _ConstClassName + "._DeviceUpdate", null, null), WebClassLibrary.JDomains.Images.GetFullPath(WebClassLibrary.JDomains.Images.ControlImages.Toolbar_Edit));
jGridView.Actions = new List <WebClassLibrary.JActionsInfo>();
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
//_SendBox
public string _SendBox()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "_SendBox");
jGridView.SQL = @"Select ShareMessage.Code, SenderCode, ReceiverCode, Type ,
(select top 1 Name from clsAllPerson where code = ShareMessage .SenderCode) SenderName ,
s.SharePCode ShareCode,
(select top 1 Name from clsAllPerson where code = ShareMessage .ReceiverCode) ReceiverName,
sDate,Title, Body
from ShareMessage
left join (select PersonCode,MAX(SharepCode)SharepCode from SharePCodeSheet where CompanyCode = 1
group by PersonCode) s on s.PersonCode = ShareMessage.ReceiverCode
where SenderCode =" + WebClassLibrary.SessionManager.Current.MainFrame.CurrentPersonCode;
jGridView.Title = "SendBox";
jGridView.PageOrderByField = "sDate Desc";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
jGridView.Toolbar.AddButton("New", "New", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._SendBoxNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Add));
jGridView.Toolbar.AddButton("Delete", "Delete", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._DeleteSendBoxNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Delete));
jGridView.Toolbar.AddButton("SendToAll", "SendToAll", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._SendToAll", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Menu_Edit));
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
public static string GridShow()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_"));
jGridView.ClassName = _ConstClassName.Replace(".", "_") + "_GridShow";
//jGridView.ContextMenuItems = new List<WebControllers.MainControls.Grid.JContextMenuItem>();
// jGridView.ContextMenuItems.Add(new WebControllers.MainControls.Grid.JContextMenuItem() { Text = "New", Action = new WebClassLibrary.JActionsInfo("Click", WebClassLibrary.JDomains.JActionEvents.MouseClick, _ConstClassName + "._NewDevice", null, null) });
// jGridView.ContextMenuItems.Add(new WebControllers.MainControls.Grid.JContextMenuItem() { Text = "Edit", Action = new WebClassLibrary.JActionsInfo("Click", WebClassLibrary.JDomains.JActionEvents.MouseClick, _ConstClassName + "._DeviceUpdate", null, null) });
//jGridView.SQL =
// @"SELECT * FROM AUTAutomobile ";
jGridView.SQL =
@"SELECT [Code],[ObjectCode],[Label],[Type] FROM AVLObjectList WHERE ClassName='AVL.ObjectList.Object.DefaultObject' AND personCode=" + WebClassLibrary.SessionManager.Current.MainFrame.CurrentUserCode;
jGridView.Title = "شی";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
// jGridView.Toolbar.AddButton("New", "New", new WebClassLibrary.JActionsInfo("Click", WebClassLibrary.JDomains.JActionEvents.MouseClick, _ConstClassName + "._NewDevice", null, null), WebClassLibrary.JDomains.Images.GetFullPath(WebClassLibrary.JDomains.Images.ControlImages.Toolbar_Add));
// jGridView.Toolbar.AddButton("Edit", "Edit", new WebClassLibrary.JActionsInfo("Click", WebClassLibrary.JDomains.JActionEvents.MouseClick, _ConstClassName + "._DeviceUpdate", null, null), WebClassLibrary.JDomains.Images.GetFullPath(WebClassLibrary.JDomains.Images.ControlImages.Toolbar_Edit));
jGridView.Actions = new List <WebClassLibrary.JActionsInfo>();
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}
//_ApartmentsRequest
public string _ApartmentsRequest()
{
WebControllers.MainControls.Grid.JGridView jGridView = new WebControllers.MainControls.Grid.JGridView(_ConstClassName.Replace(".", "_") + "._ApartmentsRequest");
jGridView.SQL = @"SELECT AR.[Code] Code
,AR.[UserCode]
,cap.Name UserName
,(select top 1 SharePCode from SharePCodeSheet where PersonCode = ar.UserCode and CompanyCode = 1 order by Code desc)SharePCode
,AR.[ObjectCode]
,N' پروژه ' + AP.ProjectName + N' طبقه ' +AP.Tabaghe+N' واحد '+AP.ShomareVahed Apartments
,case AR.[Status] when 0 then N'در انتظار پاسخ' when 1 then N'پذیرفته شده' else N'رد شده' end as Status
,AR.[InsertDate]
FROM [dbo].[Andorid_Request] AR
left join clsAllPerson cap on cap.Code = AR.[UserCode]
left join Android_Apartments ap on ap.Code = AR.[ObjectCode]
where [RequestType] = 1";
jGridView.PageOrderByField = "Code desc";
jGridView.Title = "ApartmentsRequest";
jGridView.Toolbar = new WebControllers.MainControls.ToolBar.JToolBar();
//jGridView.Toolbar.AddButton("New", "New", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._ApartmentsNew", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Add));
jGridView.Toolbar.AddButton("Edit", "Edit", new JActionsInfo("Click", JDomains.JActionEvents.MouseClick, _ConstClassName + "._ApartmentsRequestUpdate", null, null), JDomains.Images.GetFullPath(JDomains.Images.ControlImages.Toolbar_Edit));
jGridView.Actions = new List <JActionsInfo>();
jGridView.Actions.Add(new JActionsInfo("GridItemDblClick", JDomains.JActionEvents.GridItemDblClick, _ConstClassName + "._ApartmentsRequestUpdate", null, null));
return(WebClassLibrary.JWebManager.GenerateClientWindow(jGridView.GenerateWindow(true, false, false), true));
}