public static DataTable ProductList()
    {
        DASpr daspr = new DASpr();

        DataTable DTab = daspr.ProductList();

        return(DTab);
    }
    public static DataTable ProductName(string storecode)
    {
        DASpr daspr = new DASpr();

        DataTable DTab = daspr.ProductName(storecode);

        return(DTab);
    }
    public static long SprdetailsInsert(BOSpr objsprdtls)
    {
        DASpr daspr = new DASpr();

        return(Convert.ToInt64(daspr.In_Spr_details(objsprdtls)));
    }
    public static long SprInsert(BOSpr objspr)
    {
        DASpr daspr = new DASpr();

        return(Convert.ToInt64(daspr.InsertData(objspr)));
    }