public List<Customer> getCustomerV()
        {
            sqlprm.Clear();
            DataTable dtCus = this.sqlOp.executeSPInstantly("OSYS..sp_GetCustomerV", sqlprm);
            Customer cus;
            List<Customer> cusList = new List<Customer>();

            foreach (DataRow row in dtCus.Rows)
            {
                cus = new Customer();
                cus.ID = Convert.ToInt64(row["ID"]);
                cus.GroupID = Convert.ToInt32(row["GroupID"]);
                cus.Name = row["Name"] == null ? null : row["Name"].ToString();
                cus.GroupName = row["GroupName"] == null ? null : row["GroupName"].ToString();
                cus.CustomerNo = row["CustomerNo"] == null ? null : row["CustomerNo"].ToString();
                cus.Address = row["Address"] == null ? null : row["Address"].ToString();
                cus.EMail = row["EMail"] == null ? null : row["EMail"].ToString();
                cus.Phone = row["Phone"] == null ? null : row["Phone"].ToString();
                cus.TaxOfficeName = row["TaxOfficeName"] == null ? null : row["TaxOfficeName"].ToString();
                cus.TaxOfficeNumber = row["TaxOfficeNumber"] == null ? null : row["TaxOfficeNumber"].ToString();
                cusList.Add(cus);
            }
            dtCus.Clear();
            return cusList;
        }
        public List<Customer> getCustomerByGroupID(long groupID)
        {
            sqlprm.Clear();
            sqlprm = new Dictionary<string, object>();
            sqlprm.Add("groupID", groupID);
            DataTable dtCus = this.sqlOp.executeSPInstantly("OSYS..sp_GetCustomerByGroupID", sqlprm);
            Customer cus;
            List<Customer> cusList = new List<Customer>();

            foreach (DataRow row in dtCus.Rows)
            {
                cus = new Customer();
                cus.Name = row["Name"] == null ? null : row["Name"].ToString();
                cus.EMail = row["EMail"] == null ? null : row["EMail"].ToString();
                cus.Phone = row["Phone"] == null ? null : row["Phone"].ToString();

                cusList.Add(cus);
            }
            dtCus.Clear();
            return cusList;
        }