DAL中方法参数很多怎么办

niuniuhuang 2009-05-04 05:18:28

正在做个系统，在DAL里面写查询方法是感觉很不爽，有些查询有很多参数，结果调用查询方法一行都写不完，看起来有点累，大家是怎样解决这个问题的

...全文

197 24 打赏收藏转发到动态举报

写回复

用AI写文章

24 条回复

切换为时间正序

请发表友善的回复…

发表回复

WizardWu 2009-05-05

打赏
举报

List<string>
传一个动态数组即可

takako_mu 2009-05-05

打赏
举报

使用Model類.可以將多個參數放如Model中.

一方晴空 2009-05-05

打赏
举报

参数多，很正常……

lanlan520 2009-05-05

打赏
举报

用实体类!!!!!

lzzz999 2009-05-05

打赏
举报

codesmith用这个生成！~

ssnhjt 2009-05-05

打赏
举报

简单点实体类对象 Model 就搞定，用不着那么多参数

wuyq11 2009-05-04

打赏
举报

传递实体类List<T>或通过反射实现属性取值，还可通过ORM实现实体类与数据库关联。复杂操作用存储过程

春天的气息 2009-05-04

打赏
举报

传个Model呀！

gyouyang 2009-05-04

打赏
举报

为什么不传 Model？？？？？？干嘛传那么多的参数...传个Model多好啊...

蓝海D鱼 2009-05-04

打赏
举报

可以换一种查询方法，此为偶的独门秘笈





    private DataTable ExecuteDataTable(string SqlStr, Hashtable SqlParameters,CommandType temType)

    {



        String getConnectionString = "Application Name=sss;Initial Catalog=DEVDB;Data Source=10.3.1.218;User ID=sa;password=sa;Pooling=True";

        SqlConnection sqlConn = new SqlConnection(getConnectionString);

        SqlCommand sqlCmd = new SqlCommand(SqlStr);

        SqlDataAdapter sqlDA =new SqlDataAdapter();

        DataTable dtSql = new DataTable();      

        try

        {

            sqlConn.Open();

            sqlCmd.Connection = sqlConn;

            sqlCmd.CommandType = temType;

            if (SqlParameters != null)

            {

                IDictionaryEnumerator hsEnum = SqlParameters.GetEnumerator();

                while (hsEnum.MoveNext())

                {

                    sqlCmd.Parameters.AddWithValue(hsEnum.Key.ToString(), hsEnum.Value);

                }

            }

            sqlDA.SelectCommand = sqlCmd;

            sqlDA.Fill(dtSql);

            return dtSql;

        }

        catch (Exception exExact)

        {

            string error = exExact.Message;

            throw new Exception(error, exExact);

        }

        finally

        {

            sqlConn.Close();

        }

    }





    protected void Button2_Click(object sender, EventArgs e)

    {

        Hashtable htParam = new Hashtable();

               htParam.Add("@Language", "Chi");

  

      htParam.Add("@CurrencyCode", "RMB");

      htParam.Add("@CurrencyUnit", "1.0");

      htParam.Add("@Region", "42");

        string sqlstr = "spr_Channellist";

        DataTable mytable = ExecuteDataTable(sqlstr, htParam, CommandType.StoredProcedure);

        this.GridView1.DataSource = mytable;

        GridView1.DataBind();





    }









    private String ExecuteDataValue(string SqlStr, Hashtable SqlParameters)

    {



        String getConnectionString = "Application Name=IPTV;Initial Catalog=IPTVDEVDB;Data Source=10.3.1.218;User ID=sa;password=sa;Pooling=True";

        SqlConnection sqlConn = new SqlConnection(getConnectionString);

        SqlCommand sqlCmd = new  SqlCommand(SqlStr);

        string strRtrn ;

        try

        {

            sqlConn.Open();         

            sqlCmd.Connection = sqlConn;

            sqlCmd.CommandType = CommandType.Text;

            if(SqlParameters != null) 

            {

                IDictionaryEnumerator hsEnum = SqlParameters.GetEnumerator();

                while(hsEnum.MoveNext())

                {

                    sqlCmd.Parameters.AddWithValue(hsEnum.Key.ToString(), hsEnum.Value);

                }

            }



             strRtrn = Convert.ToString(sqlCmd.ExecuteScalar());

             return strRtrn;

        }

        catch(Exception exExact)

        {

            string error = exExact.Message;

            throw new Exception(error, exExact);

        }

        finally

        {

            sqlConn.Close();

        }

    }





    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

    {

        GridView1.PageIndex = e.NewPageIndex;

        OleDbConnection conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + Server.MapPath("") + "\\CODEDB.mdb");

        string sql = "select * from Code ";

        OleDbDataAdapter oda = new OleDbDataAdapter(sql, conn);

        DataSet ds = new DataSet();



        oda.Fill(ds);

        this.GridView1.DataSource = ds.Tables[0];

        GridView1.DataBind();

    }