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));
}
