コード例 #1
0
    public void showCarregi()
    {
        model m = new model();

        m.open();
        DataTable dt = m.multipleTableQuery("carcompany.carcompanyname,cartype.cartype,carmodel.carmodelname,carsubmodel.carsubmodelname,carregi.*", "(((carregi INNER JOIN carcompany ON carregi.carcompanyid=carcompany.carcompanyid)INNER JOIN cartype ON carregi.cartypeid=cartype.cartypeid)INNER JOIN carmodel ON carregi.carmodelid=carmodel.carmodelid)INNER JOIN carsubmodel ON carregi.carsubmodelid=carsubmodel.carsubmodelid", "carregi.isdelete='1'");

        CarRegiRepeater.DataSource = dt;
        CarRegiRepeater.DataBind();
        m.close();
    }
コード例 #2
0
    public void showDept()
    {
        model m = new model();

        m.open();
        DataTable dt = m.show("depttbl");

        CarRegiRepeater.DataSource = dt;
        CarRegiRepeater.DataBind();
        m.close();
    }
コード例 #3
0
    private void showInquirydata()
    {
        model m = new model();

        m.open();
        DataTable dt = m.show("carinquiry");

        CarRegiRepeater.DataSource = dt;
        CarRegiRepeater.DataBind();
        m.close();
    }
コード例 #4
0
    public void showsalesmanName()
    {
        model m = new model();

        m.open();
        DataTable dt = m.multipleTableQuery("salesmantbl.*", "salesmantbl", "salesmantbl.isdelete='1'");

        CarRegiRepeater.DataSource = dt;
        CarRegiRepeater.DataBind();
        m.close();
    }