C# (CSharp) DMLService.J_ReturnNoOfRows示例

示例#1

 private void mnuOnlineOfflineCodeDeliveryBilling_Click(object sender, EventArgs e)
 {
     strSQL = "SELECT COUNT(*) FROM MST_ITEM WHERE ONLINE_FLAG = 1 ";
     if (dmlService.J_ReturnNoOfRows(strSQL, J_QueryType.DirectQuery) == 0)
     {
         cmnService.J_UserMessage("No Item tagged for billing");
         return;
     }
     //--
     strSQL = "SELECT COUNT(*) FROM MST_ITEM WHERE DEFAULT_ITEM_ONLINE_OFFLINE_BILLING = 1 ";
     if (dmlService.J_ReturnNoOfRows(strSQL, J_QueryType.DirectQuery) == 0)
     {
         cmnService.J_UserMessage("No default Item tagged for billing");
         return;
     }
     //--
     cmnService.J_ShowChildForm(new TrnOnlineOffflineInvoiceEntry(), this, "Online/Offline Code Delivery Billing");
 }