public bool ProductionOrderExists(int saleBranchNo, int saleNo) { _authorization.CheckUserActivity(ProductionOrdersCoveringSalesUserActivityCode); return(_dataConnection.GetItem( (r) => (r.GetInt32(0) != 0), "select Sign(Count(*)) from SALES s, DEPTS d where (s.SALE_BRANCH_CODE = d.DEPT_CODE) and (d.CUSTOM_CODE = :SALE_BRANCH_NO) and (s.SALE_NO = :SALE_NO)", new SqlDataParameter("SALE_BRANCH_NO", saleBranchNo), new SqlDataParameter("SALE_NO", saleNo))); }
private Product GetProduct(string sql, params SqlDataParameter[] parameters) { return(_dataConnection.GetItem(ReadProduct, sql, parameters)); }