public static User[] GetAPPCustomerListByWechatMsgID(int WechatMsgID)
{
var msg_project_list = Wechat_MsgProject.GetWechat_MsgProjectList(WechatMsgID);
if (msg_project_list.Length == 0)
{
return(new User[] { });
}
List <string> conditions = new List <string>();
foreach (var msg_project in msg_project_list)
{
conditions.Add("[AllParentID] like '%," + msg_project.ProjectID + ",%'");
}
string cmdtext = "select * from [User] where [UserID] in (select [UserID] from [Mall_UserProject] where isnull([IsDisable],0)=0 and [ProjectID] in (select ID from [Project] where [isParent]=0 and (" + string.Join(" or ", conditions.ToArray()) + ")))";
var list = GetList <User>(cmdtext, new List <SqlParameter>()).ToArray();
return(list);
}
public static User[] GetAPPUserListByWechatMsgID(int WechatMsgID)
{
var msg_project_list = Wechat_MsgProject.GetWechat_MsgProjectList(WechatMsgID);
if (msg_project_list.Length == 0)
{
return(new User[] { });
}
List <string> conditions = new List <string>();
List <string> cmdlist = new List <string>();
foreach (var msg_project in msg_project_list)
{
cmdlist.Add("[AllParentID] like '%," + msg_project.ProjectID + ",%'");
}
conditions.Add("([UserID] in (select [UserID] from [UserRoles] where [RoleID] in (select [RoleID] from [RoleProject] where [ProjectID] in (select ID from [Project] where " + string.Join(" or ", cmdlist.ToArray()) + "))) or [UserID] in (select [UserID] from [RoleProject] where [ProjectID] in (select ID from [Project] where " + string.Join(" or ", cmdlist.ToArray()) + ")))");
string cmdtext = "select * from [User] where " + string.Join(" and ", conditions.ToArray());
var list = GetList <User>(cmdtext, new List <SqlParameter>()).ToArray();
return(list);
}