Esempio n. 1
0
    public clsCustomer GetData(string custcode)
    {
        clsCustomer objcustomer;

        myDB        = new DBHelper();
        objcustomer = new clsCustomer();
        sSQL        = objcustomer.DispDataCode(custcode);
        SqlDataReader sDr = myDB.GetFromReader(sSQL);

        sDr.Read();
        if (sDr.HasRows)
        {
            objcustomer.CustCode  = Convert.ToInt32(sDr["CustCode"].ToString());
            objcustomer.CustName  = sDr["CustName"].ToString();
            objcustomer.UserName  = sDr["UserName"].ToString();
            objcustomer.Address   = sDr["Address"].ToString();
            objcustomer.Telephone = sDr["Telephone"].ToString();
            objcustomer.Mobile    = sDr["Mobile"].ToString();
            objcustomer.Email     = sDr["Email"].ToString();
        }
        return(objcustomer);
    }