public JsonResult GetCommentList(MvcAdapter.QueryBuilder qb) { string type = CommentType.Posting.ToString(); MvcAdapter.GridData gridData = entities.Set <S_D_Comment>().Where(c => c.Type == type && c.IsTemplate == "1").WhereToGridData(qb); return(Json(gridData)); }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { var qyid = GetQueryString("QyID"); var result = entities.Set <QyAccountPassToken>().Where(c => c.QyID == qyid).WhereToGridData(qb); return(Json(result)); }
public JsonResult GetList(MvcAdapter.QueryBuilder qb, string read, string attachment, string system) { string sql = ""; if (Config.Constant.IsOracleDb) { string whereRead = read == "T" ? " and FirstViewTime is null" : ""; string whereAttach = attachment == "T" ? " and nvl(AttachFileIDs,'') <> '' " : ""; string whereSystem = system == "T" ? " and nvl(IsSystemMsg,'') <> '1' " : ""; sql = string.Format(@" select S_S_MsgBody.ID,S_S_MsgReceiver.ID as ReceiverID,S_S_MsgBody.ParentID,S_S_MsgBody.TYPE,S_S_MsgBody.Title,substr(nvl(S_S_MsgBody.ContentText,''),0,50) as ContentText ,S_S_MsgBody.AttachFileIDs,S_S_MsgBody.LinkUrl,S_S_MsgBody.IsSystemMsg,S_S_MsgBody.SendTime,S_S_MsgBody.SenderID ,S_S_MsgBody.SenderName,S_S_MsgBody.ReceiverIDs,S_S_MsgBody.ReceiverNames,(case when FirstViewTime is null then 0 else 1 end) as AlreadyRead,S_S_MsgBody.Importance from S_S_MsgReceiver join S_S_MsgBody on S_S_MsgBody.ID = MsgBodyID where UserID='{0}' and S_S_MsgReceiver.IsDeleted='0' {1} {2} {3} ", FormulaHelper.UserID, whereRead, whereAttach, whereSystem); } else { string whereRead = read == "T" ? " and FirstViewTime is null" : ""; string whereAttach = attachment == "T" ? " and isnull(AttachFileIDs,'') <> '' " : ""; string whereSystem = system == "T" ? " and isnull(IsSystemMsg,'') <> '1' " : ""; sql = string.Format(@" select S_S_MsgBody.ID,S_S_MsgReceiver.ID as ReceiverID,S_S_MsgBody.ParentID,S_S_MsgBody.[Type],S_S_MsgBody.Title,substring(isnull(S_S_MsgBody.ContentText,''),0,50) as ContentText ,S_S_MsgBody.AttachFileIDs,S_S_MsgBody.LinkUrl,S_S_MsgBody.IsSystemMsg,S_S_MsgBody.SendTime,S_S_MsgBody.SenderID ,S_S_MsgBody.SenderName,S_S_MsgBody.ReceiverIDs,S_S_MsgBody.ReceiverNames,AlreadyRead=case when FirstViewTime is null then 0 else 1 end,S_S_MsgBody.Importance from S_S_MsgReceiver join S_S_MsgBody on S_S_MsgBody.ID = MsgBodyID where UserID='{0}' and S_S_MsgReceiver.IsDeleted='0' {1} {2} {3} ", FormulaHelper.UserID, whereRead, whereAttach, whereSystem); } return(Json(SQLHelper.CreateSqlHelper("Base").ExecuteGridData(sql, qb))); }
public override JsonResult GetTree(MvcAdapter.QueryBuilder qb) { string sql = "select * from {0} WITH(NOLOCK) "; qb.PageSize = 0; DataTable dtTmpl = this.InstraDB.ExecuteDataTable(String.Format("select * from {0} WITH(NOLOCK) where 1!=1", this.TableName)); foreach (string key in Request.QueryString.Keys) { if (string.IsNullOrEmpty(key)) { continue; } if ("ID,FullID,FULLID,TmplCode,IsPreView,_winid,_t".Split(',').Contains(key) || key.StartsWith("$")) { continue; } if (dtTmpl.Columns.Contains(key)) { qb.Add(key, QueryMethod.In, Request[key]); } ; } this.BeforeGetTree(qb); var dt = this.InstraDB.ExecuteDataTable(String.Format(sql, this.TableName), qb); this.AfterGetTree(dt, qb); return(Json(dt)); }
// // GET: /ShortMsg/CollectMsg/ public JsonResult GetList(MvcAdapter.QueryBuilder qb, string attachment) { string sql = ""; if (Config.Constant.IsOracleDb) { string whereAttach = attachment == "T" ? " and nvl(AttachFileIDs,'') <> '' " : ""; sql = string.Format(@" select S_S_MsgBody.ID,S_S_MsgReceiver.ID as ReceiverID,S_S_MsgBody.ParentID,S_S_MsgBody.TYPE,S_S_MsgBody.Title,substr(nvl(S_S_MsgBody.ContentText,''),0,50) as ContentText ,S_S_MsgBody.AttachFileIDs,S_S_MsgBody.LinkUrl,S_S_MsgBody.IsSystemMsg,S_S_MsgBody.SendTime,S_S_MsgReceiver.DeleteTime,S_S_MsgBody.SenderID ,S_S_MsgBody.SenderName,S_S_MsgBody.ReceiverIDs,S_S_MsgBody.ReceiverNames,S_S_MsgBody.Importance from S_S_MsgReceiver join S_S_MsgBody on S_S_MsgBody.ID = MsgBodyID where UserID='{0}' and S_S_MsgReceiver.IsDeleted='0' and S_S_MsgReceiver.IsCollect='1' {1} union all select ID,ID as ReceiverID,ParentID,[Type],Title,substring(isnull(ContentText,''),0,50),AttachFileIDs,LinkUrl,IsSystemMsg,SendTime, DeleteTime,SenderID,SenderName,ReceiverIDs,ReceiverNames,Importance from S_S_MsgBody where SenderID='{0}' and IsDeleted='0' and IsCollect='1' {1} ", FormulaHelper.UserID, whereAttach); } else { string whereAttach = attachment == "T" ? " and isnull(AttachFileIDs,'') <> '' " : ""; sql = string.Format(@" select S_S_MsgBody.ID,S_S_MsgReceiver.ID as ReceiverID,S_S_MsgBody.ParentID,S_S_MsgBody.[Type],S_S_MsgBody.Title,substring(isnull(S_S_MsgBody.ContentText,''),0,50) as ContentText ,S_S_MsgBody.AttachFileIDs,S_S_MsgBody.LinkUrl,S_S_MsgBody.IsSystemMsg,S_S_MsgBody.SendTime,S_S_MsgReceiver.DeleteTime,S_S_MsgBody.SenderID ,S_S_MsgBody.SenderName,S_S_MsgBody.ReceiverIDs,S_S_MsgBody.ReceiverNames,S_S_MsgBody.Importance from S_S_MsgReceiver join S_S_MsgBody on S_S_MsgBody.ID = MsgBodyID where UserID='{0}' and S_S_MsgReceiver.IsDeleted='0' and S_S_MsgReceiver.IsCollect='1' {1} union all select ID,ID as ReceiverID,ParentID,[Type],Title,substring(isnull(ContentText,''),0,50),AttachFileIDs,LinkUrl,IsSystemMsg,SendTime, DeleteTime,SenderID,SenderName,ReceiverIDs,ReceiverNames,Importance from S_S_MsgBody where SenderID='{0}' and IsDeleted='0' and IsCollect='1' {1} ", FormulaHelper.UserID, whereAttach); } return(Json(SQLHelper.CreateSqlHelper("Base").ExecuteGridData(sql, qb))); }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { var mpid = GetQueryString("MpID"); var result = entities.Set <MpSelfArticle>().Where(c => c.MpID == mpid && c.IsDelete == 0).WhereToGridData(qb); return(Json(result)); }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { var RPID = GetQueryString("RPID"); var result = entities.Set <MpRedPacketLog>().Where(c => c.RPID == RPID).WhereToGridData(qb); return(Json(result)); }
/// <summary> /// /// </summary> /// <param name="qb"></param> /// <param name="important">重要度</param> /// <param name="urgency">紧急性</param> /// <returns></returns> public JsonResult GetAlarmList(MvcAdapter.QueryBuilder qb, string important, string urgency, string type) { /*不支持默认多个排序 * IQueryable<S_S_Alarm> data = entities.Set<S_S_Alarm>().Where(p => p.OwnerID == FormulaHelper.UserID && (string.IsNullOrEmpty(p.IsDelete) == true || p.IsDelete != "1")); * if (!string.IsNullOrEmpty(important)) * data = data.Where(p => p.Important == important); * if (!string.IsNullOrEmpty(urgency)) * data = data.Where(p => p.Urgency == urgency); * * if (!string.IsNullOrEmpty(type)) * { * if (type.ToLower() == "last")//最新 * data = data.Where(p => p.DeadlineTime >= DateTime.Now); * else if (type.ToLower() == "history")//历史 * data = data.Where(p => p.DeadlineTime < DateTime.Now); * } * return Json(data.WhereToGridData(qb)); */ string sql = string.Format(@"SELECT * FROM S_S_Alarm WHERE OwnerID='{0}' AND (IsDelete is null OR IsDelete='0')", FormulaHelper.UserID); if (!string.IsNullOrEmpty(important)) { sql += string.Format(" AND (Important ='{0}') ", important); } if (!string.IsNullOrEmpty(urgency)) { sql += string.Format(" AND (Urgency ='{0}') ", urgency); } if (!string.IsNullOrEmpty(type)) { if (Config.Constant.IsOracleDb == false) { if (type.ToLower() == "last")//最新 { sql += string.Format(" AND (DeadlineTime >='{0}') ", DateTime.Now); } else if (type.ToLower() == "history")//历史 { sql += string.Format(" AND (DeadlineTime <'{0}') ", DateTime.Now); } } else { if (type.ToLower() == "last")//最新 { sql += string.Format(" AND (DeadlineTime >sysdate)"); } else if (type.ToLower() == "history")//历史 { sql += string.Format(" AND (DeadlineTime < sysdate) "); } } } var data = SQLHelper.CreateSqlHelper("Base").ExecuteGridData(sql, qb); return(Json(data)); }
public JsonResult GetListView(MvcAdapter.QueryBuilder qb) { string status = PostingStatus.Complete.ToString(); IQueryable <S_D_Incoming> query = entities.Set <S_D_Incoming>().Where(c => c.Status == status); MvcAdapter.GridData gridData = query.WhereToGridData(qb); return(Json(gridData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetUserParamList(MvcAdapter.QueryBuilder qb) { string sql = @"select * from S_M_Parameter with(nolock) where Expression is not null and Expression<> '' and Expression like '%{" + this.GetQueryString("Code") + "}%'"; var db = SQLHelper.CreateSqlHelper(ConnEnum.Base); var data = db.ExecuteGridData(sql, qb); return(Json(data)); }
public JsonResult GetList(MvcAdapter.QueryBuilder qb) { var projectInfoID = this.GetQueryString("ProjectInfoID"); var wbsType = WBSNodeType.SubProject.ToString(); var list = this.BusinessEntities.Set <S_W_WBS>().Where(d => d.ProjectInfoID == projectInfoID && d.WBSType == wbsType).OrderBy(d => d .SortIndex).ToList(); return(Json(list)); }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { var statePush = qb.Items.FirstOrDefault(a => a.Field == "State"); if (statePush == null) { qb.Add("State", Formula.QueryMethod.In, "Published"); } return(base.GetList(qb)); }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { var cbsType = this.Request["CBSType"]; if (!string.IsNullOrEmpty(cbsType)) { qb.Add("CBSType", Formula.QueryMethod.Equal, cbsType); } return(base.GetList(qb)); }
public JsonResult GetSelectorList(MvcAdapter.QueryBuilder qb) { string sql = @"select * from S_M_Parameter where (ParentID is null or ParentID='') and ParamType in ('" + ArgumentType.CalArg.ToString() + "','" + ArgumentType.DynCalArg.ToString() + "')"; var db = SQLHelper.CreateSqlHelper(ConnEnum.Base); var data = db.ExecuteGridData(sql, qb); return(Json(data)); }
public JsonResult AskTask(string taskUserID, string insTaskID, MvcAdapter.QueryBuilder qb) { SQLHelper sqlHelper = SQLHelper.CreateSqlHelper("Workflow"); string sql = string.Format(@"select ID,ExecUserID,ExecUserName, case when patindex('%|%',ExecComment) > 0 then substring(ExecComment,1,patindex('%|%',ExecComment) - 1) else ExecComment end as ExecComment, case when patindex('%|%',ExecComment) > 0 then substring(ExecComment,patindex('%|%',ExecComment)+1,len(ExecComment)) else ExecComment end as AskComment ,convert(varchar(16),ExecTime,20) as ExecTime from S_WF_InsTaskExec where TaskUserID='{0}' and InsTaskID='{1}' and Type='Ask'", taskUserID, insTaskID); return(Json(sqlHelper.ExecuteGridData(sql, qb))); }
public override JsonResult GetTree(MvcAdapter.QueryBuilder qb) { string fullID = this.GetQueryString("FullID"); var sql = @"SELECT * FROM S_EP_DefineCBSNode WHERE FullID LIKE '{0}%' AND FULLID!='{0}' and ID not in (select childCBSNode.ID from S_EP_DefineCBSNode parentCBSNode inner join S_EP_DefineCBSNode childCBSNode on childCBSNode.FullID LIKE parentCBSNode.FullID + '%' AND childCBSNode.FULLID != parentCBSNode.FullID where parentCBSNode.FullID LIKE '{0}%' AND parentCBSNode.FULLID!='{0}' and parentCBSNode.BudgetUnit = 'true')"; var data = this.InstraDB.ExecuteDataTable(String.Format(sql, fullID)); return(Json(data)); }
public JsonResult GetPrjRoleList(MvcAdapter.QueryBuilder qb) { if (string.IsNullOrEmpty(ProjectBaseConfig)) { return(Json("")); } SQLHelper sqlHelpr = SQLHelper.CreateSqlHelper(ConnEnum.InfrasBaseConfig); string sql = string.Format(@"select ID='{0}'+RoleCode,Code=RoleCode,Name=RoleName from S_D_RoleDefine", ConnEnum.InfrasBaseConfig.ToString()); var dt = sqlHelpr.ExecuteDataTable(sql, (SearchCondition)qb); return(Json(dt)); }
public JsonResult GetOrgRoleList(MvcAdapter.QueryBuilder qb) { string sql = string.Format("select ID,Code,Name,Type,Description from S_A_Role where GroupID='{0}' and Type='OrgRole'", Request["GroupID"]); if (string.IsNullOrEmpty(Request["GroupID"])) { sql = "select ID,Code,Name,Type,Description from S_A_Role where Type='OrgRole'"; } SQLHelper sqlHelper = SQLHelper.CreateSqlHelper("Base"); return(Json(sqlHelper.ExecuteDataTable(sql, (SearchCondition)qb))); }
public JsonResult GetListView(MvcAdapter.QueryBuilder qb) { string status = PostingStatus.Complete.ToString(); IQueryable <S_D_Posting> query = entities.Set <S_D_Posting>().Where(c => c.Status == status); string companyDeptID = GetQueryString("CompanyDeptID"); UserInfo user = FormulaHelper.GetUserInfo(); string userID = user.UserID; if (!string.IsNullOrEmpty(companyDeptID)) { query = query.Where(c => c.CompanyDeptID == companyDeptID); } MvcAdapter.GridData gridData = query.WhereToGridData(qb); return(Json(gridData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetEngineeringRoleList(MvcAdapter.QueryBuilder qb) { if (string.IsNullOrEmpty(Infrastructure)) { return(Json("")); } SQLHelper sqlHelpr = SQLHelper.CreateSqlHelper(ConnEnum.Infrastructure); string sql = string.Format(@"select ID='{0}'+RoleCode,Code=RoleCode,Name=RoleName from S_T_RoleDefine", ConnEnum.Infrastructure.ToString()); qb.SortField = "SortIndex"; qb.SortOrder = "asc"; var dt = sqlHelpr.ExecuteDataTable(sql, (SearchCondition)qb); return(Json(dt)); }
public JsonResult GetRefList(MvcAdapter.QueryBuilder qb) { string sql = @"select S_M_Parameter.*, isnull(UseParam,0) as UseParam from S_M_Parameter with(nolock) left join (select count(ID) as UseParam,Name,Code,ID from ( select Code,Name,ID from S_M_Parameter with(nolock) where ParamType in ('InputArg','RefArg') and (ParentID is null or ParentID='')) TableInfo inner join (select Expression from S_M_Parameter with(nolock) where ParamType='CalArg' ) CalParam on CalParam.Expression like '%{'+TableInfo.Code+'}%' group by Name,Code,ID) UserCountTable on S_M_Parameter.ID=UserCountTable.ID where ParamType in ('" + ArgumentType.InputArg.ToString() + "','" + ArgumentType.RefArg.ToString() + "') and (ParentID is null or ParentID='')"; var db = SQLHelper.CreateSqlHelper(ConnEnum.Base); var data = db.ExecuteGridData(sql, qb); return(Json(data)); }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { string sourceID = this.Request["SourceID"]; if (string.IsNullOrEmpty(sourceID)) { return(base.GetList(qb)); } else { var result = entities.Set <V_S_W_AttendanceEditLog>().Where(c => c.SourceID == sourceID).WhereToGridData(qb); return(Json(result)); } }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { var mpid = GetQueryString("MpID"); var groupid = GetQueryString("GroupID"); if (!string.IsNullOrEmpty(groupid)) { var result = entities.Set <MpFans>().Where(c => c.MpID == mpid && c.GroupID == groupid && c.IsFans == "1").WhereToGridData(qb); return(Json(result)); } else { var result = entities.Set <MpFans>().Where(c => c.MpID == mpid && c.IsFans == "1").WhereToGridData(qb); return(Json(result)); } }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { var modeID = this.GetQueryString("ModeID"); var list = this.entities.Set <S_T_AuditMode>().Where(d => d.ProjectModeID == modeID).ToList(); if (list.Count == 0) { var phaseList = this.entities.Set <S_D_WBSAttrDefine>().Where(d => d.Type == "Phase") .Select(d => new { AttrID = d.ID, ProjectModeID = modeID, PhaseValue = d.Code, PhaseName = d.Name, AuditMode = "OneByTwo", d.SortIndex }) .OrderBy(d => d.SortIndex).ToList(); return(Json(phaseList)); } else { return(Json(list)); } }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { var qbPublicationType = string.Empty; foreach (var item in qb.Items) { if (item.Field == "PublicationType") { qbPublicationType = item.Value.ToString(); } } var publicationType = EnumBaseHelper.GetEnumDef("Project.PublicationType").EnumItem.ToList(); var specifications = EnumBaseHelper.GetEnumDef("Project.BorderSize").EnumItem.ToList(); var publishPrices = this.entities.Set <S_CAD_PublishPrice>().ToList(); if (!string.IsNullOrEmpty(qbPublicationType)) { publicationType = publicationType.Where(a => a.Name.Contains(qbPublicationType)).ToList(); } var list = new List <Dictionary <string, object> >(); foreach (var type in publicationType) { var item = new Dictionary <string, object>(); item.Add("PublicationType", type.Code); foreach (var specification in specifications) { var price = publishPrices.FirstOrDefault(a => a.PublicationType == type.Code && a.Specification == specification.Code); if (price == null) { item.Add(specification.Code, 0); } else { item.Add(specification.Code, price.Price); } } list.Add(item); } return(Json(list)); }
public JsonResult GetSysRoleList(MvcAdapter.QueryBuilder qb) { if (!string.IsNullOrEmpty(Request["CorpID"])) { qb.Add("CorpID", Formula.QueryMethod.In, Request["CorpID"]); } string sql = string.Format("select ID,Code,case when '{1}'='EN' then isnull(NameEN,Name) else Name end as Name,Type,Description,CorpID from S_A_Role where GroupID='{0}' and Type='SysRole'", Request["GroupID"], FormulaHelper.GetCurrentLGID()); if (string.IsNullOrEmpty(Request["GroupID"])) { sql = string.Format("select ID,Code,case when '{0}'='EN' then isnull(NameEN,Name) else Name end as Name,Type,Description,CorpID from S_A_Role where Type='SysRole'", FormulaHelper.GetCurrentLGID()); } SQLHelper sqlHelper = SQLHelper.CreateSqlHelper("Base"); return(Json(sqlHelper.ExecuteDataTable(sql, (SearchCondition)qb))); }
public JsonResult GetList(MvcAdapter.QueryBuilder qb) { var data = this.entities.Set <S_I_ProjectInfo>().WhereToGridData(qb); return(Json(data)); }
public override JsonResult GetList(MvcAdapter.QueryBuilder qb) { var result = entities.Set <MpAccount>().Where(c => c.IsDelete == 0).WhereToGridData(qb); return(Json(result)); }
public JsonResult GetMyFeedbackList(MvcAdapter.QueryBuilder qb) { var data = entities.Set <S_H_Feedback>().Where(p => p.CreateUserID == Formula.FormulaHelper.UserID).WhereToGridData(qb); return(Json(data)); }
public JsonResult GetListFlow(MvcAdapter.QueryBuilder qb) { MvcAdapter.GridData gridData = entities.Set <S_D_Posting>().Where(c => !string.IsNullOrEmpty(c.InsFlowID)).WhereToGridData(qb); return(Json(gridData)); }