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