public static JsonJqGridData ConvertFlexGridToJqGrid(JsonFlexiGridData data,PageView view,string columns)
{
JsonJqGridData returndata = new JsonJqGridData {page=view.PageIndex+1,records=view.RecordCount };
returndata.total = view.RecordCount / view.PageSize + 1;
returndata.rows = new List<JqGridRow>();
if (data.total>0 && data.rows != null && data.rows.Count > 0)
{
string[] Column = columns.Split(',');
int length = Column.Length;
foreach (FlexiGridRow row in data.rows)
{
JqGridRow r = new JqGridRow();
r.id = row.id;
r.cell = new List<object>();
var o = new { id="",value="" };
for (int i = 0; i < length; i++)
{
//r.cell.Add(Column[i]);
//r.cell.Add(":");
r.cell.Add(row.cell[i]);
}
returndata.rows.Add(r);
}
}
return returndata;
}
public void Save(PageView currentPage, string controlPlaceId, ControlData[] data)
{
if(_connectionString!=string.Empty)
{
SqlContext context = new SqlContext();
context.ConnectionString=_connectionString;
try
{
context.BeginTransaction();
//delete all controls in control place
SqlHelper.ExecuteNonQuery(context,CommandType.StoredProcedure,"page_ControlPropertiesDeleteAllInControlPlace",
new SqlParameter("@PageUID",currentPage.Id),new SqlParameter("@ControlPlaceID",controlPlaceId));
//add new controls from array "data"
for(int i=0;i<data.Length;i++)
{
SqlHelper.ExecuteNonQuery(context,CommandType.StoredProcedure,"page_ControlPropertiesInsertInControlPlace",
new SqlParameter("@PageUID",currentPage.Id),
new SqlParameter("@ControlPlaceID",controlPlaceId),
new SqlParameter("@ControlIndex",i),
new SqlParameter("@ControlUID",data[i].ControlUID),
new SqlParameter("@ControlProperties",data[i].Settings));
}
context.Commit();
}
catch
{
context.Rollback();
throw;
}
}//if(_connectionString!=string.Empty)
}
//
// GET: /Reg/
public ActionResult RegUser()
{
PageView view =new PageView();
view.PageIndex = 0;
view.PageSize = 35;
view.RecordCount = 0;
JsonFlexiGridData data = Bo.BoFactory.GetSMC_UnitBo.QueryUnitByUnitCode(view, "");
List<SelectListItem> unitList = new List<SelectListItem>();
foreach (FlexiGridRow r in data.rows)
{
SelectListItem u = new SelectListItem();
u.Value =r.cell[0];
u.Text = r.cell[1];
unitList.Add(u);
}
List<SelectListItem> genderList = new List<SelectListItem>();
genderList.Add(new SelectListItem { Text = "男", Value = "male" });
genderList.Add(new SelectListItem { Text = "女", Value = "female" });
ViewData["Unit_ID"] = unitList;
ViewData["UL_Gender"] = genderList;
return View();
}
public HttpResponseMessage Print(RequestData request)
{
Opts.AppName = "Viewer";
Opts.FileName = request.fileName;
Opts.FolderName = request.folderName;
Opts.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
try
{
if (Opts.FolderName.Contains(".."))
{
throw new Exception("Break-in attempt");
}
var doc = new Document(Opts.WorkingFileName);
var lst = new PageView[doc.Pages.Count];
for (int i = 0; i < doc.Pages.Count; i++)
{
lst[i] = PreparePageView(doc, i + 1);
}
return(Request.CreateResponse(HttpStatusCode.OK, lst));
}
catch (Exception ex)
{
return(ExceptionResponse(ex));
}
}
public virtual void Process()
{
var ctl = CreateControllerInstance();
try
{
var ret = InvokeAction(ctl);
if (ret is IView)
{
((IView)ret).Render();
}
else if (ret == null || (string)ret == "")
{
var view = new PageView(Action.ViewName, ctl, Controller);
view.Render();
}
else
{
HttpContextHandler.Instance.Redirect((string)ret, false);
}
}
catch (ThreadAbortException)
{
throw;
}
catch (Exception ex)
{
OnException(ex, ctl);
}
}
public void Reset()
{
// home button tapped
view.SelectionView.ChangeSelecion(null, SelectionChangedType.Clear, false);
if (explorationViewModel.ViewStatus.SelectedCount > 0)
{
// exploration view에서 올라가 있는 것 다 제거
foreach (PageView pageView in ExplorationViewModel.SelectedPageViews)
{
view.ExplorationView.RemoveNonTopPage(pageView);
}
// exploration view model 에서 선택된 page view 다 지움
ExplorationViewModel.SelectedPageViews.Clear();
// 빈 view status로 반영
ViewStatus emptyViewStatus = new ViewStatus();
// 현재 preview에 해당하는 page view를 비어있게
PageView topPageView = view.ExplorationView.TopPageView;
PageViewModel topPageViewModel = topPageView.ViewModel;
topPageViewModel.ViewStatus = emptyViewStatus;
topPageViewModel.State = PageViewModel.PageViewState.Empty;
topPageView.ReflectState();
ReflectAll(emptyViewStatus, ReflectReason.Reset);
}
}
public ActionResult GetLogInfo(FormCollection form)
{
JsonFlexiGridData data = null;
PageView view = new PageView(form);
data = BoFactory.GetVersionTrackBo.GetLogInfoList(view);
return Json(data);
}
public static PageVersion UpdatePage(IScribeDatabase database, User user, PageView view, Action <PageView> action, ApprovalStatus status = ApprovalStatus.None, bool published = false)
{
var service = new ScribeService(database, null, GetSearchService(), user);
action(view);
service.SavePage(view);
database.SaveChanges();
switch (status)
{
case ApprovalStatus.Approved:
service.UpdatePage(new PageUpdate {
Id = view.Id, Type = PageUpdateType.Approve
});
break;
case ApprovalStatus.Rejected:
service.UpdatePage(new PageUpdate {
Id = view.Id, Type = PageUpdateType.Reject
});
break;
}
if (published)
{
service.UpdatePage(new PageUpdate {
Id = view.Id, Type = PageUpdateType.Publish
});
}
database.SaveChanges();
return(database.PageVersions.OrderByDescending(x => x.PageId == view.Id).First());
}
/// <summary>
/// 获取答卷列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public override async Task <RpcResult <APaperListRsp> > QueryAPaperListAsync(QueryAPaperReq request)
{
var res = new RpcResult <APaperListRsp>();
res.Data = new APaperListRsp();
var view = new PageView(request.Page, request.Rp);
var plist = await this._apaperRepo.QueryAPaperList(request.Qtext, request.QpaperId, request.CheckRole?request.Identity : "", view);
res.Data.Total = view.PageIndex == 0 ? plist.Total : -1;
if (plist != null && plist.DataList != null && plist.DataList.Count > 0)
{
foreach (var apaper in plist.DataList)
{
res.Data.List.Add(new DTOAPaper()
{
ApaperId = apaper.PaperId,
CreateTime = apaper.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
QpaperId = apaper.QpaperId,
UserId = apaper.UserId,
QpaperSubject = apaper.QpaperSubject ?? "",
QpaperUserId = apaper.QpaperUserId ?? "",
Remark = apaper.Remark
});
}
}
return(res);
}
public JsonFlexiGridData QueryApplicationCategoryList(PageView view)
{
string column = "*";
string sql = "select * from ApplicationCategory ";
return(base.QueryDataForFlexGridByPager(column, string.Format("({0}) as temp", sql), view.OrderBy.ToString(), "seq", string.Empty, view));
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="T">查询类型</typeparam>
/// <param name="options">分页查询条件</param>
/// <returns>返回PageView<T></returns>
public static PageView <T> GetPageList <T>(PageSearchOptions options)
{
const string pageProcedureName = "Proc_GetPageData";
//构造参数，存储过程固定
var p = new DynamicParameters();
p.Add("TableName", options.TableName);
p.Add("PrimaryKey", options.PrimaryKey);
p.Add("Fields", options.Fields);
p.Add("Condition", options.Condition);
p.Add("CurrentPage", options.PageIndex);
p.Add("PageSize", options.PageSize);
p.Add("Sort", options.Sort);
p.Add("RecordCount", dbType: DbType.Int32, direction: ParameterDirection.Output);
var pageData = new PageView <T>(options.PageIndex, options.PageSize);
if (HasDangerousContents(options.Condition))
{
return(pageData);
}
pageData.List = DBHelper.Query <T>(pageProcedureName, p, CommandType.StoredProcedure);
pageData.TotalCount = p.Get <int>("RecordCount");
return(pageData);
}
/// <summary>
/// 分页查询单表
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="view"></param>
/// <param name="where">userid=1 and username='******'</param>
/// <param name="param"></param>
/// <param name="sqlOrder">排序字段 包含Order by </param>
/// <returns></returns>
protected Task <PagedList <T> > SimplePagedQueryAsync <T>(PageView view, string where, object param, string sqlOrder) where T : BaseEntity
{
string sqlColumns = GetAllColumns <T>();
string sqlTable = GetTableName <T>();
return(PagedQueryAsync <T>(view, sqlColumns, sqlTable, where, param, sqlOrder));
}
public PagedList <EMPLOYEE> QueryEmpList(EmpInfoSearch search, PageView view)
{
int deptId = search.GroupID;
List <int> deptIds = new List <int>();
//获取所有大区、区域、门店
if (deptId > 0)
{
deptIds.Add(deptId);
var groups = _groupRepo.GetRecursiveAllByParentID(deptId);
List <int> groupIds = groups.Select(m => m.ID).ToList();
if (groupIds.Count > 0)
{
deptIds.AddRange(groupIds);
}
}
//else
//{
// groupIds.Add(deptId);
//}
//var stores = _storeRepo.GetByGroupID(groupIds.ToArray());
//if (stores.Count > 0)
//{
// var storeIds = stores.Select(m => m.ID).ToList();
// deptIds.AddRange(storeIds);
//}
return(_empRepo.QueryList(deptIds.ToArray(), search, view));
}
/// <summary>
/// 分页查询列表
/// </summary>
/// <typeparam name="T">返回列表的实体对象类型</typeparam>
/// <param name="view">分页查询信息</param>
/// <param name="sqlColumns">查询的字符串</param>
/// <param name="sqlTable">查询的表，可以为多表，即From后面 where之前的内容</param>
/// <param name="sqlCondition">查询条件 Where 后面的部分.</param>
/// <param name="param">查询实体值得实体对象.</param>
/// <param name="sqlOrder">排序字段 包含Order by.</param>
/// <returns>返回分页信息，当查询为第一页时 返回总记录数</returns>
protected PagedList <T> PagedQuery <T>(PageView view, string sqlColumns, string sqlTable, string sqlCondition, object param, string sqlOrder)
{
PagedList <T> pList = new PagedList <T>();
var totalCount = -1;
if (view.PageIndex == 1 || view.IsFirstQueryTotal == false)
{
string totalSql = string.Format(" select count(1) from {0} where 1=1 {1} ;", sqlTable, sqlCondition);
totalCount = ExecuteScalar <int>(totalSql, param);
}
//if (string.IsNullOrEmpty(sqlOrder))
//{
// sqlOrder = " ORDER BY " + sqlPk;
//}
int pageStartIndex = view.PageSize * (view.PageIndex - 1);
int currentPageCount = view.PageSize;
string sql = string.Format(" select {0} from {1} where 1=1 {2} {3} limit {4},{5} ;", sqlColumns, sqlTable, sqlCondition, sqlOrder, pageStartIndex, currentPageCount);
pList.DataList = Query <T>(sql, param);
pList.Total = (int)totalCount;
pList.PageIndex = view.PageIndex;
pList.PageSize = view.PageSize;
return(pList);
}
/// <summary>
/// 分页查询列表
/// </summary>
/// <typeparam name="T">返回列表的实体对象类型</typeparam>
/// <param name="view">分页查询信息</param>
/// <param name="sqlColumns">查询的字符串</param>
/// <param name="sqlTable">查询的表，可以为多表，即From后面 where之前的内容</param>
/// <param name="sqlCondition">查询条件 Where 后面的部分.</param>
/// <param name="param">查询实体值得实体对象.</param>
/// <param name="sqlPk">该条查询的唯一键.</param>
/// <param name="sqlOrder">排序字段 包含Order by.</param>
/// <returns>返回分页信息，当查询为第一页时 返回总记录数</returns>
public PagedList <T> PagedQuery <T>(PageView view, string sqlColumns, string sqlTable, string sqlCondition, object param, string sqlPk, string sqlOrder)
{
PagedList <T> pList = new PagedList <T>();
long totalCount = -1;
if (view.PageIndex == 0)
{
string totalSql = string.Format(" select count(1) from {0} where 1=1 {1} ;", sqlTable, sqlCondition);
totalCount = Get <long>(totalSql, param);
}
if (string.IsNullOrEmpty(sqlOrder))
{
sqlOrder = " ORDER BY " + sqlPk;
}
int pageStartIndex = view.PageSize * view.PageIndex;
int currentPageCount = view.PageSize;
string sql = string.Format(" select {0} from {1} where 1=1 {2} {3} limit {4},{5} ;", sqlColumns, sqlTable, sqlCondition, sqlOrder, pageStartIndex, currentPageCount);
pList.DataList = Query <T>(sql, param);
pList.Total = (int)totalCount;
pList.PageIndex = view.PageIndex;
pList.PageSize = view.PageSize;
return(pList);
}
private async Task <IActionResult> ReadPageTaggedAsync(long tenantId, long pageId, string tags)
{
IPageContext context = await GetPageContextAsync(tenantId, pageId, tags);
PageView pageView = await _pageViewService.ReadPageViewAsync(tenantId, pageId);
Dictionary <long, ElementPartialView> elements = new Dictionary <long, ElementPartialView>();
foreach (PageViewZone pageViewZone in pageView.PageViewZones)
{
foreach (PageViewZoneElement pageViewZoneElement in pageViewZone.PageViewZoneElements)
{
if (!elements.ContainsKey(pageViewZoneElement.ElementId))
{
elements.Add(pageViewZoneElement.ElementId, await GetElementPartialViewAsync(tenantId, pageViewZoneElement.ElementTypeId, pageViewZoneElement.ElementId, context));
}
}
}
PageViewModel viewModel = new PageViewModel
{
View = pageView,
Elements = elements
};
return(View("Read", viewModel));
}
//查询粉丝发送给商户的消息记录
public PagedList <CUST_MSG_RECORD_EX> QueryFansMessagesN(PageView view, string toUserName, bool?isStar, bool?isReturn, string searchText)
{
StringBuilder sqlWhere = new StringBuilder(" AND cmr.State = 0");
sqlWhere.Append(string.Format(" AND cmr.FROMUSERNAME not in (select FROMUSERNAME from Emp_Cust)"));
if (!string.IsNullOrEmpty(toUserName))
{
sqlWhere.Append(string.Format(" AND cmr.TOUSERNAME ='******'", toUserName));
}
if (isStar.HasValue)
{
sqlWhere.Append(string.Format(" AND cmr.IS_STAR = '{0}'", isStar.Value));
}
if (isReturn.HasValue)
{
if (isReturn.Value)
{
sqlWhere.Append(string.Format(" AND cmr.IS_RETURN = '{0}'", isReturn.Value));
}
else
{
sqlWhere.Append(string.Format(" AND (cmr.IS_RETURN = '{0}' or cmr.IS_RETURN IS NULL)", isReturn.Value));
}
}
if (!string.IsNullOrEmpty(searchText))
{
sqlWhere.Append(string.Format(" AND cf.NAME LIKE '%{0}%' ", searchText));
}
return(base.PageGet <CUST_MSG_RECORD_EX>(view, @" cf.NAME as Fname,cf.IMAGE,cmr.*",
"[WXCUST_MSG_RECORD] cmr LEFT JOIN [WXCUST_FANS] cf ON cmr.FROMUSERNAME = cf.FROMUSERNAME", sqlWhere.ToString(), "cmr.ID", "ORDER BY cmr.CREATE_DATE DESC"));
}
void ReleaseDesignerOutlets()
{
if (CatView != null)
{
CatView.Dispose();
CatView = null;
}
if (PageView != null)
{
PageView.Dispose();
PageView = null;
}
if (PreviousButton != null)
{
PreviousButton.Dispose();
PreviousButton = null;
}
if (NextButton != null)
{
NextButton.Dispose();
NextButton = null;
}
}
public static void ChangeView(PageView page, Frame frame)
{
ConnectionView.Visibility = Visibility.Hidden;
ImportView.Visibility = Visibility.Hidden;
ExportView.Visibility = Visibility.Hidden;
Page displayPage;
switch (page)
{
case PageView.Import:
ImportView.Visibility = Visibility.Visible;
displayPage = ImportView;
break;
case PageView.Connection:
ConnectionView.Visibility = Visibility.Visible;
displayPage = ConnectionView;
break;
case PageView.Export:
ExportView.Visibility = Visibility.Visible;
displayPage = ExportView;
break;
default:
ConnectionView.Visibility = Visibility.Visible;
displayPage = ConnectionView;
break;
}
frame.Content = displayPage;
}
public void PageView(PageView reg)
{
TimeStamp stamp = new TimeStamp();
reg.Day = stamp.Day;
reg.Hour = stamp.Hour;
reg.Minute = stamp.Minute;
reg.Second = stamp.Second;
reg.Month = stamp.Month;
reg.Quarter = stamp.Quarter;
reg.Year = stamp.Year;
reg.Week = stamp.Week;
reg.Timestamp = stamp.Stamp;
reg.Session = APIContext.Current.Session;
reg.WidgetAPIKeyId = APIContext.Current.WidgetToken != null ? APIContext.Current.WidgetToken.APIKeyId : (long?)null;
Task.Factory.StartNew(() =>
{
using (var context = ContextFactory.AnalyticsContext)
{
context.PageViews.AddObject(reg);
context.SaveChanges();
}
});
}
private void detailPage()
{
//Frame rootFrame = Window.Current.Content as Frame;
PageView.Navigate(typeof(DetailPage));
VisualStateChange();
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
Frame rootFrame = Window.Current.Content as Frame;
DataService.ReadFileAsync();
Windows.UI.Core.SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility =
Windows.UI.Core.AppViewBackButtonVisibility.Collapsed;
if (e.NavigationMode != NavigationMode.New)
{
if (ApplicationData.Current.LocalSettings.Values.ContainsKey("selected"))
{
foreach (var item in ViewModel.AllItems)
{
if (item.id == (string)ApplicationData.Current.LocalSettings.Values["selected"])
{
ViewModel.selectedItem = item;
}
}
}
if (ApplicationData.Current.LocalSettings.Values.ContainsKey("pageNavigationState"))
{
PageView.SetNavigationState((string)ApplicationData.Current.LocalSettings.Values["pageNavigationState"]);
}
ApplicationData.Current.LocalSettings.Values.Remove("selected");
ApplicationData.Current.LocalSettings.Values.Remove("pageNavigationState");
}
}
private void newPage()
{
//Frame rootFrame = Window.Current.Content as Frame;
PageView.Navigate(typeof(NewPage));
ViewModel.selectedItem = null;
VisualStateChange();
}
public JsonFlexiGridData QueryClientTypeList(PageView view)
{
string column = "*";
string sql = "select * from ClientType";
return(base.QueryDataForFlexGridByPager(column, string.Format("({0}) as temp", sql), view.OrderBy.ToString(), "ClientType", string.Empty, view));
}
private void Init()
{
InitToolData();
InitToolImageState();
InitBoxImageState();
_pageView = transform.GetComponentInParent <PageView>();
if (null != _btnClick)
{
_btnClick.OnClick.AddListener(OnClickEvent);
}
if (!_raycastCamera)
{
_raycastCamera = Camera.main;
}
if (true == _isBackKeepTop)
{
_markDragBackEffect = _backEffect;
_markDragBackDuring = _backDuring;
}
DragValidCheckEvent += OnDragValidCheck;
}
/// <summary>
/// 分页获取问卷列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public override async Task <RpcResult <QPaperListRsp> > QueryQPaperListAsync(QueryQPaperReq request)
{
var res = new RpcResult <QPaperListRsp>();
res.Data = new QPaperListRsp();
var userId = request.CheckRole ? request.Identity : String.Empty;
var view = new PageView(request.Page, request.Rp);
var plist = await this._qpaperRepo.QueryQPaperList(Utility.ClearSafeStringParma(request.Query), userId, view);
res.Data.Total = view.PageIndex == 0 ? plist.Total : -1;
if (plist != null && plist.DataList != null && plist.DataList.Count > 0)
{
foreach (var qpaper in plist.DataList)
{
res.Data.List.Add(new DTOQPaper()
{
QpaperId = qpaper.QpaperId,
Subject = qpaper.Subject,
Description = qpaper.Description,
ApaperCount = qpaper.ApaperCount,
StartTime = qpaper.StartTime.HasValue ? qpaper.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss") : "",
EndTime = qpaper.EndTime.HasValue ? qpaper.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss") : ""
});
}
}
return(res);
}
/// <summary>
/// 按角色、单位、上级权限ID查询权限,Upper_FN_ID为0则查询顶级权限
/// </summary>
/// <param name="view"></param>
/// <param name="Role_ID"></param>
/// <param name="Unit_ID"></param>
/// <param name="Upper_FN_ID"></param>
/// <returns></returns>
public JsonFlexiGridData QueryFunctions(PageView view, int Role_ID, int Unit_ID, int Upper_FN_ID)
{
//select f.* from [dbo].[SMC_FunctionRole] fr join [dbo].[SMC_Functions] f
//on fr.FN_ID = f.FN_ID where fr.Role_ID = '' and f.Unit_ID='' and f.Upper_FN_ID = '' Orderby F.FN_ID DESC
string column = @"f.*";
string sWhere = "";
if (Role_ID > 0)
{
sWhere = string.Format(" AND fr.Role_ID = '{0}'", Role_ID);
}
if (Unit_ID > 0)
{
sWhere += string.Format(" AND f.Unit_ID = '{0}'", Unit_ID);
}
if (Upper_FN_ID > 0)
{
sWhere += string.Format(" AND F.Upper_FN_ID = '{0}'", Upper_FN_ID);
}
else
{
sWhere += " AND F.Upper_FN_ID IS NULL ";
}
return(base.QueryDataForFlexGridByPager(column, @" [dbo].[SMC_FunctionRole] fr join [dbo].[SMC_Functions] f
on fr.FN_ID = f.FN_ID ", view.OrderBy.ToString(), "F.FN_ID DESC", sWhere, view));
}
/// <summary>
/// 查询操作日志
/// </summary>
/// <param name="view">分页信息</param>
/// <param name="qtext">查询日志内容</param>
/// <param name="optype">操作类别</param>
/// <param name="logtyp">日志类别</param>
/// <returns></returns>
public PagedList <Log> QueryOperLog(PageView view, string qtext, string optype, LogType logtype)
{
// 过滤字符
qtext = Utility.ClearSafeStringParma(qtext);
optype = Utility.ClearSafeStringParma(optype);
return(logRepository.QueryOperLog(view, qtext, optype, logtype));
}
public JsonResult List(EmpSearch search, FormCollection form)
{
PageView view = new PageView(form);
if (search == null)
{
search = new EmpSearch();
}
search.FirstTime = form["FirstTime"];
search.EndTime = form["EndTime"];
search.DeptId = form["DeptId"];
search.StoreName = form["StoreName"];
List <string> deptIdList = new List <string>();
if (deptTree == null)
{
setDeptTree();
}
List <EMPLOYEE_EX> pList = _service.QueryEmplReport(search);
string colkey = form["colkey"];
string colsinfo = form["colsinfo"];
JsonQTable fdata = JsonQTable.ConvertFromList <EMPLOYEE_EX>(pList, colkey, colsinfo.Split(','));
return(Json(fdata));
}
/// <summary>
/// Kthe ne shqip te gjitha deklarimet qe jane ne anglisht te crystalReportViewer1
/// </summary>
private void RifreskoRaportin()
{
foreach (Control child in this.crystalReportViewer1.Controls)
{
if (child is CrystalDecisions.Windows.Forms.PageView)
{
PageView child1 = child as PageView;
foreach (Control child2 in child1.Controls)
{
if (child2 is System.Windows.Forms.TabControl)
{
foreach (Control child3 in child2.Controls)
{
DocumentControl child4 = child3 as DocumentControl;
if (child4 != null)
{
child4.Text = "Raporti Kryesor";
}
}
}
}
}
else if (child is System.Windows.Forms.StatusBar)
{
StatusBar status = child as StatusBar;
status.Panels[0].Text = status.Panels[0].Text.Replace("Current Page No:", "Numri i faqes korrente");
status.Panels[1].Text = status.Panels[1].Text.Replace("Total Page No:", "Numri total i faqeve:");
status.Panels[2].Text = status.Panels[2].Text.Replace("Zoom Factor:", "Shkalla e zmadhimit:");
}
}
}
public JsonResult OrgUserList(string OrgCode, FormCollection form)
{
string colkey = form["colkey"];
string colsinfo = form["colsinfo"];
if (string.IsNullOrEmpty(colkey))
{
throw new ArgumentNullException("colkey", "主键表示没有传递，请在前台js中配置");
}
if (string.IsNullOrEmpty(colsinfo))
{
throw new ArgumentNullException("colsinfo", "列信息不能为空，请在前台js中配置");
}
int pageIndex = Convert.ToInt32(form["page"]);
int pageSize = Convert.ToInt32(form["rp"]);
PageView view = new PageView();
view.PageIndex = pageIndex - 1;
view.PageSize = pageSize;
PagedList <UserInfo> pageList = sysManageService.QueryOrgUserList(view, OrgCode);
var data = JsonFlexiGridData.ConvertFromPagedList(pageList, colkey, colsinfo.Split(','));
return(Json(data));
}
public JsonResult RoleUserRelationList(FormCollection form)
{
string colkey = form["colkey"];
string colsinfo = form["colsinfo"];
int roleId = Convert.ToInt32(form["RoleID"]);
//TODO：验证是否能管理这个角色
string qtext = form["qtext"];
if (string.IsNullOrEmpty(colkey))
{
throw new ArgumentNullException("colkey", "主键表示没有传递，请在前台js中配置");
}
if (string.IsNullOrEmpty(colsinfo))
{
throw new ArgumentNullException("colsinfo", "列信息不能为空，请在前台js中配置");
}
int pageIndex = Convert.ToInt32(form["page"]);
int pageSize = Convert.ToInt32(form["rp"]);
PageView view = new PageView();
view.PageIndex = pageIndex - 1;
view.PageSize = pageSize;
PagedList <UserInfo> pageList = sysManageService.QueryRoletUserList(view, roleId, qtext);
var data = JsonFlexiGridData.ConvertFromPagedList(pageList, colkey, colsinfo.Split(','));
return(Json(data));
}
public JsonResult LogList(FormCollection form)
{
int pageIndex = Convert.ToInt32(form["page"]);
int pageSize = Convert.ToInt32(form["rp"]);
PageView view = new PageView();
view.PageIndex = pageIndex - 1;
view.PageSize = pageSize;
string colkey = form["colkey"];
string colsinfo = form["colsinfo"];
string qtext = form["QText"];
string optype = form["OperateCode"];
LogType logtype = LogType.None;
switch (form["LogType"])
{
case "0":
logtype = LogType.Debug;
break;
case "1":
logtype = LogType.Trace;
break;
case "2":
logtype = LogType.Error;
break;
}
ILogService service = ObjectFactory.GetInstance <ILogService>();
PagedList <Log> plist = service.QueryOperLog(view, qtext, optype, logtype);
JsonFlexiGridData fdata = JsonFlexiGridData.ConvertFromPagedList <Log>(plist, colkey, colsinfo.Split(','));
return(Json(fdata));
}
public PagedResults <FileView> GetFiles(PagedRequest request = null)
{
var query = _database.Files.Where(x => !x.IsDeleted);
request = request ?? new PagedRequest();
request.Cleanup();
if (!string.IsNullOrWhiteSpace(request.Filter))
{
query = request.FilterValues?.Any() == true
? query.Where(request.Filter, request.FilterValues)
: query.Where(request.Filter);
}
query = query.OrderBy(string.IsNullOrWhiteSpace(request.Order) ? "Name" : request.Order);
return(GetPagedResults(query, request, x => new FileView
{
Id = x.Id,
ModifiedOn = x.ModifiedOn,
Name = x.Name,
NameForLink = PageView.ConvertTitleForLink(x.Name),
Size = x.Size / 1024 + " kb",
Type = x.Type
}));
}
public JsonResult QueryUser(FormCollection form)
{
JsonFlexiGridData data = null;
PageView view = new PageView(form);
data = SBO.QueryUser(view);
return Json(data);
}
public ActionResult GetUserInfo(FormCollection form, string UserStatus)
{
JsonFlexiGridData data = null;
PageView view = new PageView(form);
SearchConfig search = new SearchConfig();
search.status = UserStatus;
data = BoFactory.GetVersionTrackBo.GetUserInfo(view, search);
return Json(data);
}
public virtual JsonFlexiGridData QueryMonitorConfig(PageView view)
{
try
{
return MonitorConfigDao.QueryMonitorConfig(view);
}
catch (DalException ex)
{
throw new BOException("获取插件相关所有信息出错", ex);
}
}
public virtual JsonFlexiGridData QueryPushNotificationList(PageView view)
{
try
{
return dao.QueryPushNotificationList(view);
}
catch (DalException ex)
{
throw new BOException("查询推送日志出错", ex);
}
}
public JsonResult QueryDeviceBindList(FormCollection form)
{
JsonFlexiGridData data = new JsonFlexiGridData();
PageView view = new PageView(form);
try
{
data = BoFactory.GetVersionTrackBo.QueryDeviceBindList(view);
}
catch { }
return Json(data);
}
public JsonResult QueryApplyDeviceBindList(FormCollection form)
{
string unit_id = "";
if (!this.IsSystemManager)
{
unit_id = this.CurrentUser.UnitCode;
}
JsonFlexiGridData data = new JsonFlexiGridData();
PageView view = new PageView(form);
try
{
data = BoFactory.GetVersionTrackBo.QueryApplyDeviceBindList(view);
}
catch { }
string columns = "operate,UserUid,DeviceId,Ip,Status,ApplyTime,Description,ID";
var returnValue = ConvertJsonGrid.ConvertFlexGridToJqGrid(data, view, columns);
var d= Json(returnValue);
return d;
}
public ControlData[] Load(PageView currentPage, string controlPlaceId)
{
ArrayList retVal=new ArrayList();
if(_connectionString!=string.Empty)
{
SqlContext context = new SqlContext();
context.ConnectionString=this.ConnectionString;
using(IDataReader reader = SqlHelper.ExecuteReader(context,CommandType.StoredProcedure,"page_ControlPropertiesSelectAllInControlPlace",
new SqlParameter("@PageUID",currentPage.Id),
new SqlParameter("@ControlPlaceID",controlPlaceId)))
{
while(reader.Read())
{
retVal.Add(new ControlData(reader.GetString(1),
reader.GetString(2)));
}//while(reader.Read())
}//using(IDataReader reader = SqlHelper.ExecuteReader(context,CommandType.StoredProcedure,"page_ControlsSelectAllInControlPlace",
}//if(_connectionString!=string.Empty)
return (ControlData[])retVal.ToArray(typeof(ControlData));
}
public ActionResult GetMiansInfo(FormCollection form)
{
ViewData["clientType"] = Request.QueryString["type"];
JsonFlexiGridData data = null;
PageView view = new PageView(form);
data = BoFactory.GetVersionTrackBo.QueryMiansInfo(view);
return Json(data);
}
public ActionResult MainGlobalInfoManage()
{
JsonFlexiGridData data = null;
PageView view = new PageView();
view.CurrentUserId = null;
view.PageIndex = 0;
view.PageSize = 15;
view.RecordCount = 0;
data = BoFactory.GetVersionTrackBo.QueryMiansInfo(view);
//int i = data.rows.Count;
if (data.rows!=null)
return RedirectToAction("MainInfoManage");//��������id,��ת�������-���������
else
return RedirectToAction("UpdateGlobalConfigInfo");//��������id,����ȫ�����ù������
}
public JsonResult QueryPcExtList(FormCollection form)
{
JsonFlexiGridData data = new JsonFlexiGridData();
PageView view = new PageView(form);
string uid = HttpContext.User.Identity.Name;
Dictionary<string, string> r = BoFactory.GetSMC_UserListBo.GetUnitByUL_UID(uid);
string unitcode = "";
if (r != null)
{
foreach (KeyValuePair<string, string> p in r)
{
unitcode = p.Value;
}
}
data = BoFactory.GetVersionTrackBo.QueryPackageExtList(view,"PC", unitcode);
return Json(data);
}
public virtual JsonFlexiGridData QueryPackageAsyncResultList(PageView pageview, string sync_bat_no, string sync_time_start, string sync_time_end, string sync_status, string packageName)
{
try
{
return SMC_PackageExtSyncToOutsideDao.QueryPackageAsyncResultList(pageview, sync_bat_no, sync_time_start, sync_time_end, sync_status, packageName);
}
catch (DalException ex)
{
throw new BOException("查询包的同步结果出错", ex);
}
}
private void BindData(bool needToBind)
{
pageView = new PageView(false, PageViewType.Static, string.Empty, this.Page, MetaClassName);
mc = MetaClass.Load(MetaClassName);
if (ObjectId > 0)
obj = MetaDataWrapper.LoadMetaObject(ObjectId, MetaClassName);
if (obj == null)
obj = MetaDataWrapper.NewMetaObject(ObjectId, MetaClassName);
GenerateMainTable();
LoadControls(needToBind);
wasBound = true;
}
public ActionResult GetUnitListByUnitCode(FormCollection form, string unit_id)
{
JsonFlexiGridData data = null;
PageView view = new PageView(form);
data = BoFactory.GetSMC_UnitBo.QueryUnitByUnitCode(view, unit_id);
return Json(data);
}
public ActionResult GetVersionTrackList(FormCollection form, string id)
{
JsonFlexiGridData data = null;
PageView view = new PageView(form);
SearchVersionTrack search = new SearchVersionTrack();
search.PluginCode = id;
data = BoFactory.GetVersionTrackBo.QueryVersionTrackInfo(view, search);
return Json(data);
}
public virtual JsonFlexiGridData QueryBUAUserAsyncToInsideResultList(PageView pageview, string sync_bat_no, string sync_time_start, string sync_time_end, string sync_status, string userName)
{
try
{
return SMC_BUAUserSyncToInsideDao.QueryBUAUserAsyncToInsideResultList(pageview, sync_bat_no, sync_time_start, sync_time_end, sync_status, userName);
}
catch (DalException ex)
{
throw new BOException("查询包的同步结果出错", ex);
}
}
public void AddToPageView(PageView pageView)
{
base.AddObject("PageView", pageView);
}
public static PageView CreatePageView(int pageViewId, string viewed, global::System.TimeSpan timeSpentOnPage)
{
PageView pageView = new PageView();
pageView.PageViewId = pageViewId;
pageView.Viewed = viewed;
pageView.TimeSpentOnPage = timeSpentOnPage;
return pageView;
}
public ActionResult DelRole(int role_id)
{
JsonReturnMessages data = new JsonReturnMessages() { IsSuccess = true, Msg = "操作成功" };
SMC_Role role = BoFactory.GetSMC_RoleBo.Get(role_id);
if (role != null)
{
//判断是否被关联引用
PageView view = new PageView();
view.PageIndex = 0;
view.PageSize = 15;
var rel=BoFactory.GetSMC_UserListBo.QueryUserListHasRole(view, role_id);
if (rel.total > 0)
{
data.IsSuccess = false;
data.Msg = "角色已经分配给用户，请先取消分配关系!";
return Json(data);
}
else
{
if (BoFactory.GetSMC_FunctionRoleBo.IsFuncAssigned(role_id))
{
data.IsSuccess = false;
data.Msg = "角色已经分配了权限，请先取消分配关系!";
return Json(data);
}
}
}
else
{
data.IsSuccess = false;
data.Msg = "角色不存在";
}
if (role != null)
{
//BoFactory.GetSMC_UserListBo.DeleteByRoleID(role_id);
BoFactory.GetSMC_RoleBo.Delete(role);
}
return Json(data);
}
public ActionResult DelUnit(string unit_id)
{
JsonReturnMessages data = new JsonReturnMessages() { IsSuccess = true, Msg = "操作成功" };
SMC_Unit unit = BoFactory.GetSMC_UnitBo.Get(unit_id);
if (unit != null)
{
//判断是否被关联引用
PageView view = new PageView();
view.PageIndex = 0;
view.PageSize = 15;
//看是否有下级组织机构
var units = BoFactory.GetSMC_UnitBo.QueryUnitByUpperUnitCode(view,unit_id);
if (units.total > 0)
{
data.IsSuccess = false;
data.Msg = "该组织存在下级组织，请先删除下级组织后再执行此操作!";
return Json(data);
}
var rel = BoFactory.GetSMC_RoleBo.QueryRolesByUnitID(view,unit_id);
if (rel.total > 0)
{
data.IsSuccess = false;
data.Msg = "有角色的组织不能删除，请先删除组织下的角色后再执行此操作!";
return Json(data);
}
else
{
rel = BoFactory.GetSMC_UserListBo.QueryUserListByUnitID(view,unit_id);
if (rel.total > 0)
{
data.IsSuccess = false;
data.Msg = "有用户的组织不能删除，请先删除组织下的用户后再执行此操作!";
return Json(data);
}
}
}
else
{
data.IsSuccess = false;
data.Msg = "组织不存在";
}
try
{
//从同意授权
Beyondbit.BUA.Client.IOrgService os = Beyondbit.BUA.Client.ServiceFactory.Instance().GetOrgService();
os.DelOrg(unit_id);
}
catch (Exception e)
{
//ata.IsSuccess = false;
//data.Msg = e.Message;
}
if (unit != null)
{
BoFactory.GetSMC_UnitBo.Delete(unit);
}
return Json(data);
}
public ActionResult GetFunctionListByUpperFNID(FormCollection form, string upper_fn_id)
{
JsonFlexiGridData data = null;
PageView view = new PageView(form);
int _upper_fn_id = 0;
if (upper_fn_id != null)
{
_upper_fn_id = int.Parse(upper_fn_id);
}
data = BoFactory.GetSMC_FunctionsBo.QueryFunctionByUpperFNID(view, _upper_fn_id);
return Json(data);
}
public ActionResult GetConfigInfo(FormCollection form)
{
JsonFlexiGridData data = null;
PageView view = new PageView(form);
data = BoFactory.GetMonitorBO.QueryMonitorConfig(view);
return Json(data);
}
public virtual JsonFlexiGridData QueryNeedImportedPackageList(PageView view)
{
try
{
Package4AIDao dao = new Package4AIDao(AppConfig.statisticDBKey);
return dao.QueryNeedImportedPackageList(view);
}
catch (DalException ex)
{
throw new BOException("查询包的同步信息出错", ex);
}
}
public JsonResult GetVersionTrackList(FormCollection form)
{
JsonFlexiGridData data = null;
PageView view = new PageView(form);
SearchVersionTrack search = new SearchVersionTrack();
search.PluginCode = Common.Entities.Constants.MianPluginId.ToString();
data = BoFactory.GetVersionTrackBo.QueryVersionTrackInfo(view, search);
return Json(data);
}
private PageView BuildPageViewContents(int gId)
{
PageView pageView = new PageView();
StringBuilder returnString = new StringBuilder();
string str = "";
CateNewsBSO catenewsBSO = new CateNewsBSO();
CateNewsGroupBSO catenewsGroupBSO = new CateNewsGroupBSO();
CateNewsGroup cateGroup = catenewsGroupBSO.GetCateNewsGroupByGroupCate(gId);
if (cateGroup.IsPage == true)
catenewsBSO.MenuJqueryCateGroupUrl(returnString, 0, Language.language, "", gId, ResolveUrl("~/") + "CategoryPages/" + gId + "/", "/default.aspx");
else
catenewsBSO.MenuJqueryCateGroupUrl(returnString, 0, Language.language, "", gId, ResolveUrl("~/") + "Category/" + gId + "/", "/default.aspx");
//str = "<div id='menu'>" + returnString.ToString() + "</div>";
str = "<div style='position:absolute;left:" + cateGroup.Position + "px;white-space: nowrap;'><div id='menu'>" + returnString.ToString() + "</div></div>";
pageView.Controls.Add(new LiteralControl(str));
return pageView;
}
public JsonResult QueryPushNotificationList(FormCollection form)
{
JsonFlexiGridData data = new JsonFlexiGridData();
PageView view = new PageView(form);
data = BoFactory.GetPushManageBO.QueryPushNotificationList(view);
return Json(data);
}
public ActionResult GetUnitListByUpperUnitCode(FormCollection form, string upper_unit_id)
{
JsonFlexiGridData data = null;
PageView view = new PageView(form);
bool isSystemManager = BoFactory.GetVersionTrackBo.IsSystemManager(this.User.Identity.Name);
if (isSystemManager)
data = BoFactory.GetSMC_UnitBo.QueryUnitByUpperUnitCode(view, upper_unit_id);
else
{
//单位管理员只看自己单位列表
string Unit_ID = BoFactory.GetSMC_UserListBo.GetUnitIdByUID(this.User.Identity.Name);
data = BoFactory.GetSMC_UnitBo.QueryUnitByUpperUnitCodeWithSelfUnit(view, upper_unit_id, Unit_ID);
}
ViewData["unit_id"] = upper_unit_id;
return Json(data, JsonRequestBehavior.AllowGet);
}
