private string BuildSqlPart(string sql, QueryConditionField queryConditionField)
{
switch (queryConditionField)
{
case QueryConditionField.UserId:
if (string.IsNullOrEmpty(_queryCondition.UserId))
return "";
break;
case QueryConditionField.CATEGORY:
if (string.IsNullOrEmpty(_queryCondition.CATEGORY))
return "";
break;
case QueryConditionField.WORKSHOP:
if (string.IsNullOrEmpty(_queryCondition.WORKSHOP))
return "";
break;
case QueryConditionField.Name:
if (string.IsNullOrEmpty(_queryCondition.GroupName))
return "";
break;
case QueryConditionField.Code:
if (string.IsNullOrEmpty(_queryCondition.Code))
return "";
break;
case QueryConditionField.DepartmentCode:
if (string.IsNullOrEmpty(_queryCondition.DepartmentCode))
return "";
break;
case QueryConditionField.EQUIPMENT:
if (string.IsNullOrEmpty(_queryCondition.EQUIPMENT))
return "";
break;
case QueryConditionField.PROTOCOL:
if (string.IsNullOrEmpty(_queryCondition.PROTOCOL))
return "";
break;
case QueryConditionField.ReasonCategory:
if (string.IsNullOrEmpty(_queryCondition.ReasonCategory))
return "";
break;
case QueryConditionField.Resv01:
if (string.IsNullOrEmpty(_queryCondition.Resv01))
return "";
break;
case QueryConditionField.InCondition:
return string.IsNullOrEmpty(_queryCondition.InCondition)
? ""
: string.Format(sql, _queryCondition.InCondition);
case QueryConditionField.NotInCondition:
return string.IsNullOrEmpty(_queryCondition.NotInCondition)
? ""
: string.Format(sql, _queryCondition.NotInCondition);
}
return sql + "@" + queryConditionField;
}
private string BuildSqlPart(string sql, QueryConditionField queryConditionField)
{
switch (queryConditionField)
{
case QueryConditionField.user_name:
if (string.IsNullOrEmpty(_queryCondition.user_name))
{
return("");
}
break;
case QueryConditionField.role_id:
if (string.IsNullOrEmpty(_queryCondition.role_id))
{
return("");
}
break;
case QueryConditionField.status_id:
if (string.IsNullOrEmpty(_queryCondition.status_id))
{
return("");
}
break;
case QueryConditionField.type_name:
if (string.IsNullOrEmpty(_queryCondition.type_name))
{
return("");
}
break;
case QueryConditionField.InCondition:
return(string.IsNullOrEmpty(_queryCondition.InCondition)
? ""
: string.Format(sql, _queryCondition.InCondition));
case QueryConditionField.NotInCondition:
return(string.IsNullOrEmpty(_queryCondition.NotInCondition)
? ""
: string.Format(sql, _queryCondition.NotInCondition));
}
return(sql + "@" + queryConditionField);
}
private string BuildSqlPart(string sql, QueryConditionField queryConditionField)
{
switch (queryConditionField)
{
case QueryConditionField.user_name:
if (string.IsNullOrEmpty(_queryCondition.user_name))
return "";
break;
case QueryConditionField.role_id:
if (string.IsNullOrEmpty(_queryCondition.role_id))
return "";
break;
case QueryConditionField.status_id:
if (string.IsNullOrEmpty(_queryCondition.status_id))
return "";
break;
case QueryConditionField.type_name:
if (string.IsNullOrEmpty(_queryCondition.type_name))
return "";
break;
case QueryConditionField.InCondition:
return string.IsNullOrEmpty(_queryCondition.InCondition)
? ""
: string.Format(sql, _queryCondition.InCondition);
case QueryConditionField.NotInCondition:
return string.IsNullOrEmpty(_queryCondition.NotInCondition)
? ""
: string.Format(sql, _queryCondition.NotInCondition);
}
return sql + "@" + queryConditionField;
}
private string BuildSqlPart(string sql, QueryConditionField queryConditionField)
{
switch (queryConditionField)
{
case QueryConditionField.UserId:
if (string.IsNullOrEmpty(_queryCondition.UserId))
{
return("");
}
break;
case QueryConditionField.CATEGORY:
if (string.IsNullOrEmpty(_queryCondition.CATEGORY))
{
return("");
}
break;
case QueryConditionField.WORKSHOP:
if (string.IsNullOrEmpty(_queryCondition.WORKSHOP))
{
return("");
}
break;
case QueryConditionField.Name:
if (string.IsNullOrEmpty(_queryCondition.GroupName))
{
return("");
}
break;
case QueryConditionField.Code:
if (string.IsNullOrEmpty(_queryCondition.Code))
{
return("");
}
break;
case QueryConditionField.DepartmentCode:
if (string.IsNullOrEmpty(_queryCondition.DepartmentCode))
{
return("");
}
break;
case QueryConditionField.EQUIPMENT:
if (string.IsNullOrEmpty(_queryCondition.EQUIPMENT))
{
return("");
}
break;
case QueryConditionField.PROTOCOL:
if (string.IsNullOrEmpty(_queryCondition.PROTOCOL))
{
return("");
}
break;
case QueryConditionField.ReasonCategory:
if (string.IsNullOrEmpty(_queryCondition.ReasonCategory))
{
return("");
}
break;
case QueryConditionField.Resv01:
if (string.IsNullOrEmpty(_queryCondition.Resv01))
{
return("");
}
break;
case QueryConditionField.InCondition:
return(string.IsNullOrEmpty(_queryCondition.InCondition)
? ""
: string.Format(sql, _queryCondition.InCondition));
case QueryConditionField.NotInCondition:
return(string.IsNullOrEmpty(_queryCondition.NotInCondition)
? ""
: string.Format(sql, _queryCondition.NotInCondition));
}
return(sql + "@" + queryConditionField);
}
