ASP.NET 2.0 C# DAL Multiple Variable Parameters -

-

I am preparing a web app for querying a large database table based on the selection of users of the criteria. In some cases they can know and enter the primary key, second time they want to see the records of the status 'ABC' created in the last 7 days, or records created by 'Fred Smith', where the word 'proposal' 'Is included. The issue is, there can easily be 10 - 20 different variables which they can specify, depending on what they are looking at.

It is quite easy for me to create SQL statement and dynamically apply parameters. Code behind the webpage (aspx.cs) This approach works well.

However, I'm reading on using a BLL & amp; Team (or even that I was just a pulse), but all the examples which have been despised parameters getCategories (like) or a single parameter such as GetProductByID (int productId)

I On the advice, it is on BPL / DAL with 20 variable parameters (for example) with many parameters (this is useful, but it is extremely delicate, especially if a new selection parameter has been added ).

Other ideas about which I have thought about

a) Create a single string parameter, which can be decoded in the law, such as:
string parameters = "datefilled = made; 2011 -03-01; condition = ABC "
BLLGetrecords (PARAM);
(Workforce, but terrible and prone to mistakes)

b) Use a straight or class as parameter, for example Params Status = "ABC";
Parameters.SavedBusur = 23;

(Is there a problem with DAL having access to this structure / class? I have read that DAL should not share any context with those sections which are called it?

Thanks for any suggestions on how you will implement this scenario.

In my projects I am stable I am creating the class DataManager that the data received, such as 

  public static IList & lt all required cars ActionHistoryData & gt; GetActionHistoryList (DATETIME STARTDATE DATETIME, ENDDATE, bool postprocessed) {Return GlobalComponents.DataManagerImpl.GetActionHistoryList (Zero, Null, Null, Null, Null, Null, STARTDATE, ENDDATE, False, Postprocessed, Faucet );} public static ActionHistoryData GetActionHistory (int id) {IList & LT; ActionHistoryData & gt; actionHistoryList = GlobalComponents.DataManagerImpl.GetActionHistoryList (ID, nULL, nULL, nULL, nULL, nULL, nULL, nULL, nULL, nULL, nULL, Zero); CQUtti Verify (! Collection. HistoryList), "[id = 'no action history with {0}' 'id'); CQGUtils.Verify (Akshnlitilistkkount == 1," more than one action returned to history. " ); Return History Historical List [0];}   
 As you see in DB, we have only one stored procedure with many different arguments  GetActionHistoryList  ( ActionHistory  for table data). Dynamic SQLSc in the stored process.  
  `  < p> such approach allows to easily add new filtering requests

Comments

Post a Comment

Popular posts from this blog

qt - switch/case statement in C++ with a QString type -

-
I want to use switch-case in my program but the compiler generates an error. How can I use the switch statement with QString ? The compiler gives me this error: The expression of the switch type 'QString' is invalid My code is as follows : boolStopWord (the word QString) {bool flag = false; Switch (word) {case "the": flag = true; break ; "On" case: flag = true; break ; Case "in": flag = true; break ; Case "your": flag = true; break ; Case "near": flag = true; break ; Case "all": flag = true; break ; Case "this": flag = true; break ; } Return flag; } How do I use the switch statement with a Caststring ? You can not use the switch statement in C ++ language with integral or enum types. You can formally enter the square type of object in the switch statement, but this means that the compiler will look for a user-defined conversion to convert it to an integral or enum type.
Read more

python - sqlite3.OperationalError: near "REFERENCES": syntax error - foreign key creating -

-
I'm trying to create a predefined key after checking the manual and I wrote it: Db.execute ("create table" Table 2 (id, integer primary key, somedata integer) "db.execute" (table creation table 2 does not exist (name text, maintain reference (id) ") and found this: sqlite 3. Operation error: near" references ": syntax error Your second ligne is wrong db.execute ("create table if table does not exist 2 (name text, my_id integer, foreign key (my_id) reference Maintenance (ID)) ") as explained
Read more

Python's equivalent for Ruby's define_method? -

-
What is a Python equivalent for Ruby's define_method , which is the dynamic generation of class methods will allow? (As can be seen in Wikipedia) Functions are first-class objects in Python and assign them The properties of a class or an example can be a way of doing the same thing as a Wikipedia example: colors = {"black": "000", "red": "F00", "green": "0f0", "yellow": "ff0", "blue": "00f", "magenta": "fff", "cyan": "0ff", "white": " FFF "} Class MyStream (ARR): Pass for Name, Code in colors.iteritems (): def _in_colour ( W code = code): return '& lt; Span style = "color:% s" & gt;% s & lt; / Span & gt; ' % (Code, self) setter (histrive, "in_" + name, _in_ color)
Read more