如何使用三层架构获得价值 [英] how to get value using three tier architecture

问题描述

所有这里我的问题是



i我正在使用3层架构，如何从datareader获得价值



我的代码



DAL：

all here my problem is

i am using 3 tier architecture, how to get value from datareader

my code

DAL:

public SqlDataReader SQLDR(string sqlDRparam)
{
   con = new SqlConnection(constr);
   con.Open();
   cmd = new SqlCommand(sqlDRparam, con);
   dr = cmd.ExecuteReader();
   if (dr.Read())
   {
      string strcid = dr["cid"].ToString();
      string strtxtcusnum = dr["mob"].ToString();
      string strtxtcomname = dr["compname"].ToString();
      string strcusname = dr["contname"].ToString();
   }
   dr.Close();
   return dr;
}

BAL：

BAL:

public SqlDataReader SQLDR(string sqlDRparam)
{
   try
   {
      return ncd.SQLDR(sqlDRparam);
   }
   catch
   {
      throw;
   }
}

UI：

UI:

string customername = e.CommandArgument.ToString();
string qry = "select cus.cid, cus.branchid, cus.mob, cus.contname, cus.dept, cus.mail, cuscre.compname, cuscre.location from CustContacts_TB cus inner join CustCreate_TB cuscre on cus.cid=cuscre.cid and cus.branchid=cuscre.branchid where cus.contname='" + customername + "'";
string id=txtcusid.Text;
string cnum=txtcusnumber.Text;
string compname=txtcompname.Text;
string cname=txtcusname.Text;
try
{
   ncb.SQLDR(qry);
}
catch
{
}

如何获得UI部分的DAL值...？



感谢您的建议

how to get DAL value to UI part...?

thanks for your advice

推荐答案

更改您的DAL方法

Change your DAL method

public List<user> SQLDR(string sqlDRparam)
{
    con = new SqlConnection(constr);
    con.Open();
    cmd = new SqlCommand(sqlDRparam, con);
    dr = cmd.ExecuteReader();
    List<user> listUser = new List<user>();
    if (dr.Read())
    {
        User u = new User();
        u.strcid = dr["cid"].ToString();
        u.strtxtcusnum = dr["mob"].ToString();
        u.strtxtcomname = dr["compname"].ToString();
        u.strcusname = dr["contname"].ToString();
        listUser.Add(u);
    }
    dr.Close();
    return listUser;
}

对象层类

Object Layer Class

public class User
{
    public string strcid { get; set; }
    public string strtxtcusnum { get; set; }
    public string strtxtcomname { get; set; }
    public string strcusname { get; set; }
}

把BAL方法放到这样的东西

Put BAL method something like this

public List<user> SQLDR(string sqlDRparam)
    {
        try
        {
            return ncd.SQLDR(sqlDRparam);
        }
        catch
        {
            throw;
        }
    }  

获取UI类中的数据

Get the data in UI class

List<user> listuser= ncb.SQLDR(qry); 

嗨......

http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-architecture-in_17.html [ ^ ]

http://www.c-sharpcorner.com/UploadFile/4d9083/create-and-implement-3-tier-architecture-in-Asp-Net/ [ ^ ]

了解C＃中的3层架构 [ ^ ]

谢谢你。

Hi....
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-architecture-in_17.html[^]
http://www.c-sharpcorner.com/UploadFile/4d9083/create-and-implement-3-tier-architecture-in-Asp-Net/[^]
Understand 3- Tier Architecture in C#[^]
Thank u.

这篇关于如何使用三层架构获得价值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！