protected virtual string GetFilterStringHistoryTaskTaskTable(YZRequest request, IYZDbProvider provider) { string filter = null; string serialNumLike = null; string processNameLike = null; string ownerAccountLike = null; string agentAccountLike = null; string descriptionLike = null; string taskidEqu = null; string keyword = request.GetString("Keyword", null); if (!String.IsNullOrEmpty(keyword)) { serialNumLike = String.Format("SerialNum LIKE(N'%{0}%')", provider.EncodeText(keyword)); processNameLike = String.Format("ProcessName LIKE(N'%{0}%')", provider.EncodeText(keyword)); ownerAccountLike = String.Format("OwnerAccount LIKE(N'%{0}%')", provider.EncodeText(keyword)); agentAccountLike = String.Format("AgentAccount LIKE(N'%{0}%')", provider.EncodeText(keyword)); descriptionLike = String.Format("Description LIKE(N'%{0}%')", provider.EncodeText(keyword)); if (YZStringHelper.IsNumber(keyword)) { taskidEqu = String.Format("TaskID={0}", keyword); } } string processName = request.GetString("processName", null); string status = request.GetString("status", null); string sn = request.GetString("sn", null); string keywordFilter = null; if (!String.IsNullOrEmpty(processName)) { filter = provider.CombinCond(filter, String.Format("ProcessName=N'{0}'", provider.EncodeText(processName))); } else { keywordFilter = provider.CombinCondOR(keywordFilter, processNameLike); } DateTime date1 = DateTime.MinValue; DateTime date2 = DateTime.MaxValue; date1 = request.GetDateTime("reqStart", DateTime.MinValue); date2 = request.GetDateTime("reqEnd", DateTime.MaxValue); if (date1 != DateTime.MinValue || date2 != DateTime.MaxValue) { filter = provider.CombinCond(filter, provider.GenPeriodCond("CreateAt", date1, date2)); } if (!String.IsNullOrEmpty(status)) { filter = provider.CombinCond(filter, String.Format("State=N'{0}'", status)); } if (!String.IsNullOrEmpty(sn)) { filter = provider.CombinCond(filter, String.Format("SerialNum LIKE(N'%{0}%')", provider.EncodeText(sn))); } else { keywordFilter = provider.CombinCondOR(keywordFilter, serialNumLike); } keywordFilter = provider.CombinCondOR(keywordFilter, ownerAccountLike); keywordFilter = provider.CombinCondOR(keywordFilter, agentAccountLike); keywordFilter = provider.CombinCondOR(keywordFilter, taskidEqu); keywordFilter = provider.CombinCondOR(keywordFilter, descriptionLike); filter = provider.CombinCond(filter, keywordFilter); return(filter); }
protected virtual string GetFilterStringWorklist(YZRequest request, IYZDbProvider provider) { string filter = null; string searchType = request.GetString("SearchType", null); string keyword = request.GetString("Kwd", null); string serialNumLike = null; string processNameLike = null; string ownerAccountLike = null; string agentAccountLike = null; string stepNameLike = null; string descriptionLike = null; string taskidEqu = null; string specProcessName = request.GetString("SpecProcessName", null); if (!String.IsNullOrEmpty(specProcessName)) { string[] processNames = specProcessName.Split(','); string processNameFilter = null; foreach (string processName in processNames) { if (String.IsNullOrEmpty(processName)) { continue; } processNameFilter = provider.CombinCondOR(processNameFilter, String.Format("ProcessName=N'{0}'", provider.EncodeText(processName))); } filter = provider.CombinCond(filter, processNameFilter); } if (!String.IsNullOrEmpty(keyword)) { serialNumLike = String.Format("SerialNum LIKE(N'%{0}%')", provider.EncodeText(keyword)); processNameLike = String.Format("ProcessName LIKE(N'%{0}%')", provider.EncodeText(keyword)); ownerAccountLike = String.Format("OwnerAccount LIKE(N'%{0}%')", provider.EncodeText(keyword)); agentAccountLike = String.Format("AgentAccount LIKE(N'%{0}%')", provider.EncodeText(keyword)); stepNameLike = String.Format("NodeName LIKE(N'%{0}%')", provider.EncodeText(keyword)); descriptionLike = String.Format("Description LIKE(N'%{0}%')", provider.EncodeText(keyword)); if (YZStringHelper.IsNumber(keyword)) { taskidEqu = String.Format("TaskID={0}", keyword); } } if (YZStringHelper.EquName(searchType, "AdvancedSearch")) { string processName = request.GetString("ProcessName", null); string postUserAccount = request.GetString("PostUserAccount", null); string periodType = request.GetString("PostDateType", "").ToLower(); string taskId = request.GetString("TaskID", null); string serialNum = request.GetString("SerialNum", null); string keywordFilter = null; if (!String.IsNullOrEmpty(processName)) { filter = provider.CombinCond(filter, String.Format("ProcessName=N'{0}'", provider.EncodeText(processName))); } else { keywordFilter = provider.CombinCondOR(keywordFilter, processNameLike); } if (!String.IsNullOrEmpty(postUserAccount)) { filter = provider.CombinCond(filter, String.Format("OwnerAccount=N'{0}' OR AgentAccount=N'{0}'", provider.EncodeText(postUserAccount))); } else { keywordFilter = provider.CombinCondOR(keywordFilter, ownerAccountLike); keywordFilter = provider.CombinCondOR(keywordFilter, agentAccountLike); } DateTime date1 = DateTime.MinValue; DateTime date2 = DateTime.MaxValue; if (periodType != "all") { date1 = request.GetDateTime("PostDate1", DateTime.MinValue); date2 = request.GetDateTime("PostDate2", DateTime.MinValue); } if (date1 != DateTime.MinValue) { filter = provider.CombinCond(filter, provider.GenPeriodCond("CreateAt", date1, date2)); } if (!String.IsNullOrEmpty(taskId) && YZStringHelper.IsNumber(taskId)) { filter = provider.CombinCond(filter, String.Format("TaskID={0}", taskId)); } else { keywordFilter = provider.CombinCondOR(keywordFilter, taskidEqu); } if (!String.IsNullOrEmpty(serialNum)) { filter = provider.CombinCond(filter, String.Format("SerialNum LIKE(N'{0}%')", provider.EncodeText(serialNum))); } else { keywordFilter = provider.CombinCondOR(keywordFilter, serialNumLike); } keywordFilter = provider.CombinCondOR(keywordFilter, stepNameLike); keywordFilter = provider.CombinCondOR(keywordFilter, descriptionLike); filter = provider.CombinCond(filter, keywordFilter); } if (YZStringHelper.EquName(searchType, "QuickSearch")) { string processName = request.GetString("ProcessName", null); string keywordFilter = null; if (!String.IsNullOrEmpty(processName)) { filter = provider.CombinCond(filter, String.Format("ProcessName=N'{0}'", provider.EncodeText(processName))); } else { keywordFilter = provider.CombinCondOR(keywordFilter, processNameLike); } keywordFilter = provider.CombinCondOR(keywordFilter, taskidEqu); keywordFilter = provider.CombinCondOR(keywordFilter, serialNumLike); keywordFilter = provider.CombinCondOR(keywordFilter, ownerAccountLike); keywordFilter = provider.CombinCondOR(keywordFilter, agentAccountLike); keywordFilter = provider.CombinCondOR(keywordFilter, stepNameLike); keywordFilter = provider.CombinCondOR(keywordFilter, descriptionLike); filter = provider.CombinCond(filter, keywordFilter); } return(filter); }