public List <ClassStudentMapViewEntity> GetSearch(int?classID, string keyString, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format(@"select cs.ID, c.ClassID, c.Code as 'ClassCode', c.Name as 'ClassName', u.ID as 'StudentID', u.Code as 'StudentCode', u.Name as 'StudentName' from ClassStudentMap(nolock) cs inner join UserInfo(nolock) u on u.ID = cs.StudentID and u.valid = 'T' inner join ClassInfo(nolock) c on c.ClassID = cs.ClassID and c.valid = 'T' where cs.valid = 'T' {1} and (c.Code like '%{0}%' or c.Name like '%{0}%' or u.Code like '%{0}%' or u.Name like '%{0}%') ", keyString, classID == null ? "" : " and cs.ClassID = " + classID); DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by cs.ClassID {0}", order), null, offset / pageSize, pageSize, out pageCount, out total); List <ClassStudentMapViewEntity> list = new List <ClassStudentMapViewEntity>(); foreach (DataRow dr in dt.Rows) { ClassStudentMapViewEntity entity = new ClassStudentMapViewEntity(); entity.ID = Ext.ToInt(dr["ID"]); entity.ClassID = Ext.ToInt(dr["ClassID"]); entity.ClassCode = Ext.ToString(dr["ClassCode"]); entity.ClassName = Ext.ToString(dr["ClassName"]); entity.StudentID = Ext.ToInt(dr["StudentID"]); entity.StudentCode = Ext.ToString(dr["StudentCode"]); entity.StudentName = Ext.ToString(dr["StudentName"]); list.Add(entity); } return(list); }
/// <summary> /// 获取列表 /// </summary> public ActionResult GetDataGridJsonV(int?typeX) { SplitPage splitPage = new SplitPage() { Conditions = new Conditions[] { new Conditions() { Key = "isnull(isOK,-1)", Value = typeX.ToStringV() } } }; splitPage.order = "desc"; splitPage.sort = "createDate"; string sqlw = SxSqlHelperBLL.getSqlw(splitPage); int total = 0; System.Data.DataTable dt = new System.Data.DataTable(); SxSqlHelperBLL.getPageDataEasyUi(sqlw, "CR_CreditMoney", splitPage, ref total, ref dt); if (!TB.CheckTB(dt)) { dt = new System.Data.DataTable(); } var jsonData = new { rows = dt, total = total }; return(ToJsonResult(jsonData)); }
public List <SchoolInfoEntity> GetSearch(string keyString, string sort, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format("select * from SchoolInfo(nolock) where valid = 'T' and (code like '%{0}%' or name like '%{0}%')", keyString); DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total); List <SchoolInfoEntity> list = new List <SchoolInfoEntity>(); foreach (DataRow dr in dt.Rows) { SchoolInfoEntity entity = new SchoolInfoEntity(); entity.ID = Ext.ToInt(dr["ID"]); entity.Code = Ext.ToString(dr["Code"]); entity.Name = Ext.ToString(dr["Name"]); entity.Address = Ext.ToString(dr["Address"]); entity.Description = Ext.ToString(dr["Description"]); entity.Remark = Ext.ToString(dr["Remark"]); entity.Company = Ext.ToString(dr["Company"]); entity.Valid = Ext.ToString(dr["Valid"]); entity.CreateTime = Ext.ToDate(dr["CreateTime"]); entity.CreateBy = Ext.ToString(dr["CreateBy"]); entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]); entity.UpdateBy = Ext.ToString(dr["UpdateBy"]); list.Add(entity); } return(list); }
public List <StudentClassHistoryEntity> GetSearch(string sort, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format("select * from StudentClassHistory(nolock) where valid = 'T'"); DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total); List <StudentClassHistoryEntity> list = new List <StudentClassHistoryEntity>(); foreach (DataRow dr in dt.Rows) { StudentClassHistoryEntity entity = new StudentClassHistoryEntity(); entity.ID = Ext.ToInt(dr["ID"]); entity.StudentID = Ext.ToInt(dr["StudentID"]); entity.ArrangeClassID = Ext.ToInt(dr["ArrangeClassID"]); entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]); entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]); entity.Score = Ext.ToIntOrNull(dr["Score"]); entity.IsAttend = Ext.ToString(dr["IsAttend"]); entity.IsPass = Ext.ToString(dr["IsPass"]); entity.Remark = Ext.ToString(dr["Remark"]); entity.Valid = Ext.ToString(dr["Valid"]); entity.CreateTime = Ext.ToDate(dr["CreateTime"]); entity.CreateBy = Ext.ToString(dr["CreateBy"]); entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]); entity.UpdateBy = Ext.ToString(dr["UpdateBy"]); list.Add(entity); } return(list); }
/// <summary> /// 日志列表 /// </summary> public ActionResult GetPageListV1(Pagination pagination, SplitPage splitPage, int?CategoryId) { pagination.sidx = pagination.sort; pagination.sord = pagination.order; pagination.page = (pagination.page <= 0 ? 1 : pagination.page); pagination.rows = (pagination.rows <= 0 ? 0 : pagination.rows); List <Conditions> lisWhere = new List <Conditions>(); if (splitPage.Conditions == null) { lisWhere = new List <Conditions>(); } else { lisWhere = splitPage.Conditions.ToList <Conditions>(); } if (CategoryId.ToInt() > 0) { lisWhere.Add(new Conditions() { Key = "CategoryId", Value = CategoryId.ToStringV() }); } splitPage.Conditions = lisWhere.ToArray(); var data = LogBLL.GetPageListV(pagination, splitPage); var jsonData = new { rows = data, total = pagination.records, }; return(ToJsonResult(jsonData)); }
/// <summary> /// 获取文件信息 /// </summary> public ActionResult GetFileData(string cinvCode, string picStr, string picType) { //含原始文件 SplitPage spPic = new SplitPage(); List <Conditions> listCon = new List <Conditions>(); listCon.Add(new Conditions() { Key = "billType", Value = cinvCode }); listCon.Add(new Conditions() { Key = "category", Value = picStr }); if (!string.IsNullOrEmpty(picType)) { listCon.Add(new Conditions() { Key = "picType", Value = picType }); //1 原始,2 内部,3 工序 } spPic.Conditions = listCon.ToArray(); var attach = attachmentbll.GetList(spPic); return(ToJsonResult(attach)); }
/// <summary> /// 我的提醒列表 /// </summary> /// <param name="splitPage">查询参数</param> /// <param name="usage">使用范围(前台使用)</param> /// <returns>返回分页列表Json</returns> public ActionResult getMyTixing(SplitPage splitPage, string usage) { List <Conditions> lisWhere = new List <Conditions>(); if (splitPage.Conditions == null) { lisWhere = new List <Conditions>(); } else { lisWhere = splitPage.Conditions.ToList <Conditions>(); } lisWhere.Add(new Conditions() { Key = "receiver", Value = OperatorProvider.Provider.Current().UserId }); lisWhere.Add(new Conditions() { Key = "isDelete", Value = "0" }); splitPage.order = "asc"; splitPage.sort = "CreateDate"; splitPage.Conditions = lisWhere.ToArray(); var data = tixingbll.GetMyList(splitPage, usage); return(Content(data.ToJson())); }
public List <ClassInfoEntity> GetSearch(string keyString, string sort, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format("select * from ClassInfo(nolock) where valid = 'T' and (code like '%{0}%' or name like '%{0}%')", keyString); DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total); List <ClassInfoEntity> list = new List <ClassInfoEntity>(); foreach (DataRow dr in dt.Rows) { ClassInfoEntity entity = new ClassInfoEntity(); entity.ClassID = Ext.ToInt(dr["ClassID"]); entity.Code = Ext.ToString(dr["Code"]); entity.Name = Ext.ToString(dr["Name"]); entity.Type = Ext.ToString(dr["Type"]); entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]); entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]); entity.TeacherID = Ext.ToIntOrNull(dr["TeacherID"]); entity.Company = Ext.ToString(dr["Company"]); entity.Department = Ext.ToString(dr["Department"]); entity.Remark = Ext.ToString(dr["Remark"]); entity.Valid = Ext.ToString(dr["Valid"]); entity.CreateTime = Ext.ToDate(dr["CreateTime"]); entity.CreateBy = Ext.ToString(dr["CreateBy"]); entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]); entity.UpdateBy = Ext.ToString(dr["UpdateBy"]); list.Add(entity); } return(list); }
public List <LoginLogEntity> GetSearch(string whereCondition, string sort, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format("select * from LoginLog(nolock) {0}", whereCondition); DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total); List <LoginLogEntity> list = new List <LoginLogEntity>(); foreach (DataRow dr in dt.Rows) { LoginLogEntity entity = new LoginLogEntity(); entity.ID = Ext.ToInt(dr["ID"]); entity.Guid = Ext.ToString(dr["Guid"]); entity.Type = Ext.ToString(dr["Type"]); entity.LoginID = Ext.ToInt(dr["LoginName"]); entity.LoginName = Ext.ToString(dr["LoginName"]); entity.LoginType = Ext.ToString(dr["LoginType"]); entity.Action = Ext.ToString(dr["Action"]); entity.TimeRecord = Ext.ToDateOrNull(dr["TimeRecord"]); entity.Remark = Ext.ToString(dr["Remark"]); entity.MachineID = Ext.ToString(dr["MachineID"]); entity.LoginIP = Ext.ToString(dr["LoginIP"]); entity.LoginIP2 = Ext.ToString(dr["LoginIP2"]); entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]); entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]); entity.CreateTime = Ext.ToDate(dr["CreateTime"]); entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]); list.Add(entity); } return(list); }
/// <summary> /// 获取列表 /// </summary> public ActionResult GetDataGridJsonV(string userID) { SplitPage s = new SplitPage() { Conditions = new Conditions[] { new Conditions() { Key = "userID", Value = userID } } }; s.sort = "CreateDate"; s.order = "desc"; int total = 0; string sqlw = SxSqlHelperBLL.getSqlw(s); System.Data.DataTable dt = new System.Data.DataTable(); SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", s, ref total, ref dt); if (!TB.CheckTB(dt)) { dt = new System.Data.DataTable(); } var jsonData = new { rows = dt, total = total }; return(ToJsonResult(jsonData)); }
public List <ArrangeClassEntity> GetSearch(string sort, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format("select * from ArrangeClass(nolock) where valid = 'T'"); DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total); List <ArrangeClassEntity> list = new List <ArrangeClassEntity>(); foreach (DataRow dr in dt.Rows) { ArrangeClassEntity entity = new ArrangeClassEntity(); entity.ID = Ext.ToInt(dr["ID"]); entity.CurriculumID = Ext.ToInt(dr["CurriculumID"]); entity.ClassID = Ext.ToInt(dr["ClassID"]); entity.ClassRoomID = Ext.ToInt(dr["ClassRoomID"]); entity.TeacherID = Ext.ToInt(dr["TeacherID"]); entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]); entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]); entity.Remark = Ext.ToString(dr["Remark"]); entity.BespeakCount = Ext.ToIntOrNull(dr["BespeakCount"]); entity.AttendCount = Ext.ToIntOrNull(dr["AttendCount"]); entity.PassedCount = Ext.ToIntOrNull(dr["PassedCount"]); entity.Valid = Ext.ToString(dr["Valid"]); entity.CreateTime = Ext.ToDate(dr["CreateTime"]); entity.CreateBy = Ext.ToString(dr["CreateBy"]); entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]); entity.UpdateBy = Ext.ToString(dr["UpdateBy"]); list.Add(entity); } return(list); }
/// <summary> /// 我的待办数量 /// </summary> /// <returns>返回分页列表Json</returns> public ActionResult getMyMissionNum(SplitPage splitPage) { List <Conditions> lisWhere = new List <Conditions>(); if (splitPage.Conditions == null) { lisWhere = new List <Conditions>(); } else { lisWhere = splitPage.Conditions.ToList <Conditions>(); } lisWhere.Add(new Conditions() { Key = "receiver", Value = OperatorProvider.Provider.Current().UserId }); lisWhere.Add(new Conditions() { Key = "isDelete", Value = "0" }); lisWhere.Add(new Conditions() { Key = "completeStatus", Value = "0" }); splitPage.Conditions = lisWhere.ToArray(); var data = missionbll.GetMyList(splitPage); var jsonData = new { missionNum = data.Count() }; return(ToJsonResult(jsonData)); }
/// <summary> /// 我的待办列表 /// </summary> /// <param name="pagination">分页参数</param> /// <param name="splitPage">查询参数</param> /// <param name="usage">使用范围(前台使用)</param> /// <returns>返回分页列表Json</returns> public ActionResult getMyMission(Pagination pagination, SplitPage splitPage, string usage) { pagination.sidx = pagination.sort; pagination.sord = pagination.order; pagination.page = (pagination.page <= 0 ? 1 : pagination.page); pagination.rows = (pagination.rows <= 0 ? 0 : pagination.rows); List <Conditions> lisWhere = new List <Conditions>(); if (splitPage.Conditions == null) { lisWhere = new List <Conditions>(); } else { lisWhere = splitPage.Conditions.ToList <Conditions>(); } //桌面使用 if (!string.IsNullOrEmpty(usage) && usage.Equals("top")) { lisWhere.Add(new Conditions() { Key = "receiver", Value = OperatorProvider.Provider.Current().UserId }); lisWhere.Add(new Conditions() { Key = "isDelete", Value = "0" }); lisWhere.Add(new Conditions() { Key = "completeStatus", Value = "0" }); splitPage.order = "asc"; splitPage.sort = "CreateDate"; splitPage.Conditions = lisWhere.ToArray(); var data = missionbll.GetMyList(pagination, splitPage, usage); return(Content(data.ToJson())); } else { //列表使用 lisWhere.Add(new Conditions() { Key = "receiver", Value = OperatorProvider.Provider.Current().UserId }); lisWhere.Add(new Conditions() { Key = "isDelete", Value = "0" }); splitPage.Conditions = lisWhere.ToArray(); var data = missionbll.GetMyList(pagination, splitPage, usage); var jsonData = new { rows = data, total = pagination.records, }; return(ToJsonResult(jsonData)); } }
/// <summary> /// 获取列表 /// </summary> /// <param name="pagination">分页</param> /// <param name="splitPage">查询对象</param> /// <returns></returns> public ActionResult GetDataGridJsonV2(Pagination pagination, SplitPage splitPage) { pagination.sidx = pagination.sort; pagination.sord = pagination.order; pagination.page = (pagination.page <= 0? 1:pagination.page); pagination.rows = (pagination.rows <= 0? 0:pagination.rows); var data = missionreceiveinfobll.GetPageList(pagination, splitPage); var jsonData = new { rows = data, total = pagination.records, }; return(ToJsonResult(jsonData)); }
/// <summary> /// 获取列表 /// </summary> /// <param name="splitPage">分页参数</param> /// <returns></returns> public ActionResult GetDataGridJson(SplitPage splitPage) { string sqlw = SxSqlHelperBLL.getSqlw(splitPage); int total = 0; System.Data.DataTable dt = new System.Data.DataTable(); SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", splitPage, ref total, ref dt); if (!TB.CheckTB(dt)) { dt = new System.Data.DataTable(); } var jsonData = new { rows = dt, total = total }; return(ToJsonResult(jsonData)); }
public List <UserInfoEntity> GetSearch(string keyString, string type, string sort, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format("select * from UserInfo(nolock) where valid = 'T' {1} and (code like '%{0}%' or name like '%{0}%') ", keyString, string.IsNullOrWhiteSpace(type) ? "" : string.Format(" and Type = '{0}'", type)); DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize + 1, pageSize, out pageCount, out total); List <UserInfoEntity> list = new List <UserInfoEntity>(); foreach (DataRow dr in dt.Rows) { UserInfoEntity entity = new UserInfoEntity(); entity.ID = Ext.ToInt(dr["id"]); entity.Code = Ext.ToString(dr["code"]); entity.Name = Ext.ToString(dr["name"]); entity.Password = Ext.ToString(dr["password"]); entity.Type = Ext.ToString(dr["type"]); entity.Group = Ext.ToString(dr["group"]); entity.Company = Ext.ToString(dr["company"]); entity.Department = Ext.ToString(dr["department"]); entity.PositionID = Ext.ToString(dr["positionID"]); entity.PositionName = Ext.ToString(dr["positionName"]); entity.Sex = Ext.ToString(dr["sex"]); entity.Birthday = Ext.ToDate(dr["birthday"]); entity.Email = Ext.ToString(dr["email"]); entity.Phone = Ext.ToString(dr["phone"]); entity.Address = Ext.ToString(dr["address"]); entity.Valid = Ext.ToString(dr["valid"]); entity.CreateTime = Ext.ToDate(dr["createTime"]); entity.CreateBy = Ext.ToString(dr["createBy"]); entity.UpdateTime = Ext.ToDate(dr["updateTime"]); entity.UpdateBy = Ext.ToString(dr["updateBy"]); list.Add(entity); } return(list); }
protected override void OnNavigatedTo(NavigationEventArgs e) { // Get a pointer to our main page. rootPage = e.Parameter as SplitPage; }
protected override void OnNavigatedTo(NavigationEventArgs e) { // Get a pointer to our main page rootPage = e.Parameter as SplitPage; // init printing RegisterForPrinting(); }
/// <summary> /// Wird aufgerufen, wenn die Anwendung durch den Endbenutzer normal gestartet wird. Weitere Einstiegspunkte /// werden z. B. verwendet, wenn die Anwendung gestartet wird, um eine bestimmte Datei zu öffnen. /// </summary> /// <param name="e">Details über Startanforderung und -prozess.</param> protected override async void OnLaunched(LaunchActivatedEventArgs e) { try { if (!string.IsNullOrEmpty(e.Arguments)) { await new TileAction(e.Arguments).Execute(); Exit(); return; } } catch (Exception ex) { try { Debug.WriteLine(ex); new MessageDialog(ex.ToString()) .ShowAsync(); } catch (Exception ex2) { Debug.WriteLine(ex2); } } SetupHelper(); SplitPage = Window.Current.Content as SplitPage; Frame rootFrame = null; if (SplitPage == null) { SplitPage = new SplitPage(); if (rootFrame == null) { rootFrame = new Frame(); rootFrame.Language = Windows.Globalization.ApplicationLanguages.Languages[0]; rootFrame.NavigationFailed += OnNavigationFailed; if (e.PreviousExecutionState == ApplicationExecutionState.Terminated) { } } SplitPage.DataContext = rootFrame; Window.Current.Content = SplitPage; } //Frame rootFrame = Window.Current.Content as Frame; //// App-Initialisierung nicht wiederholen, wenn das Fenster bereits Inhalte enthält. //// Nur sicherstellen, dass das Fenster aktiv ist. //if (rootFrame == null) { // // Frame erstellen, der als Navigationskontext fungiert und zum Parameter der ersten Seite navigieren // rootFrame = new Frame(); // rootFrame.NavigationFailed += OnNavigationFailed; // if (e.PreviousExecutionState == ApplicationExecutionState.Terminated) { // //TODO: Zustand von zuvor angehaltener Anwendung laden // } // // Den Frame im aktuellen Fenster platzieren // Window.Current.Content = rootFrame; //} if (SplitPage.Content == null) { // Wenn der Navigationsstapel nicht wiederhergestellt wird, zur ersten Seite navigieren // und die neue Seite konfigurieren, indem die erforderlichen Informationen als Navigationsparameter // übergeben werden rootFrame.Navigate(typeof(SplitPage), e.Arguments); } // Sicherstellen, dass das aktuelle Fenster aktiv ist Window.Current.Activate(); }