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