當前位置: 首頁>>代碼示例>>C#>>正文

C# DataLayer.DatabaseHelper類代碼示例

本文整理匯總了C#中POS.DataLayer.DatabaseHelper類的典型用法代碼示例。如果您正苦於以下問題：C# DatabaseHelper類的具體用法？C# DatabaseHelper怎麽用？C# DatabaseHelper使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。


DatabaseHelper類屬於POS.DataLayer命名空間，在下文中一共展示了DatabaseHelper類的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。

示例1: UpdateTransaction

 public bool UpdateTransaction(PURPurchaseReturnHeader pURPurchaseReturnHeader, PURPurchaseReturnLineCollection pURPurchaseReturnLineCollection)
 {
     oDatabaseHelper = new DatabaseHelper();
     bool ExecutionState = false;
     oDatabaseHelper.BeginTransaction();
     if (UpdateHeader(oDatabaseHelper, pURPurchaseReturnHeader))
     {
         if (DeleteDetails(oDatabaseHelper, (int)pURPurchaseReturnHeader.PurchaseReturnID, (int)pURPurchaseReturnHeader.UpdatedBy))
         {
             foreach (PURPurchaseReturnLine pURPurchaseReturnLine in pURPurchaseReturnLineCollection)
             {
                 if (!InsertDetails(oDatabaseHelper, pURPurchaseReturnLine, (int)pURPurchaseReturnHeader.PurchaseReturnID))
                 {
                     ExecutionState = false;
                     break;
                 }
                 else
                     ExecutionState = true;
             }
             if (ExecutionState)
                 oDatabaseHelper.CommitTransaction();
             else
                 oDatabaseHelper.RollbackTransaction();
         }
         else
             ExecutionState = false;
     }
     else
         ExecutionState = false;
     return ExecutionState;
 }
開發者ID:kimboox44，項目名稱:POS，代碼行數:31，代碼來源:PURPurchaseReturnLine.cs

示例2: SaveTransaction

 public int SaveTransaction(PURPurchaseReturnHeader pURPurchaseReturnHeader, PURPurchaseReturnLineCollection pURPurchaseReturnLineCollection)
 {
     oDatabaseHelper = new DatabaseHelper();
     bool ExecutionState = false;
     int salesReturnHeaderID = -1;
     oDatabaseHelper.BeginTransaction();
     if (InsertHeader(oDatabaseHelper, pURPurchaseReturnHeader, out salesReturnHeaderID))
     {
         foreach (PURPurchaseReturnLine pURPurchaseLine in pURPurchaseReturnLineCollection)
         {
             if (!InsertDetails(oDatabaseHelper, pURPurchaseLine, salesReturnHeaderID))
             {
                 ExecutionState = false;
                 break;
             }
             else
                 ExecutionState = true;
         }
         if (ExecutionState)
             oDatabaseHelper.CommitTransaction();
         else
             oDatabaseHelper.RollbackTransaction();
     }
     return salesReturnHeaderID;
 }
開發者ID:kimboox44，項目名稱:POS，代碼行數:25，代碼來源:PURPurchaseReturnLine.cs

示例3: SelectByUserNameAndPassword

        public static ADUser SelectByUserNameAndPassword(string UserName, string Password)
        {
            DatabaseHelper oDatabaseHelper = new DatabaseHelper();
            bool ExecutionState = false;

            oDatabaseHelper.AddParameter("@UserName", UserName);
            oDatabaseHelper.AddParameter("@Password", Password);

            // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);

            IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_ADUser_SelectUserNameAndPassword", ref ExecutionState);
            if (dr.Read())
            {
                ADUser obj = new ADUser();
                PopulateObjectFromReader(obj, dr);
                dr.Close();
                oDatabaseHelper.Dispose();
                return obj;
            }
            else
            {
                dr.Close();
                oDatabaseHelper.Dispose();
                return null;
            }

        }
開發者ID:kimboox44，項目名稱:POS，代碼行數:28，代碼來源:ADUser.cs

示例4: SaveAndCommitTransaction

 public bool SaveAndCommitTransaction(INVTransferHeader transferHeader, INVTransferLineCollection transferLineCollection)
 {
     oDatabaseHelper = new DatabaseHelper();
     bool ExecutionState = false;
     int transferHeaderID;
     oDatabaseHelper.BeginTransaction();
     if (InsertHeader(oDatabaseHelper, transferHeader, out transferHeaderID))
     {
         foreach (INVTransferLine transferLine in transferLineCollection)
         {
             if (!InsertDetailsAndCommit(oDatabaseHelper, transferLine, transferHeaderID))
             {
                 ExecutionState = false;
                 break;
             }
             else
                 ExecutionState = true;
         }
         if (ExecutionState)
             oDatabaseHelper.CommitTransaction();
         else
             oDatabaseHelper.RollbackTransaction();
     }
     return ExecutionState;
 }
開發者ID:kimboox44，項目名稱:POS，代碼行數:25，代碼來源:INVTransferLine.cs

示例5: UpdateTransaction

 public bool UpdateTransaction(SALSalesReturnHeader sALSalesReturnHeader, SALSalesReturnLineCollection sALSalesReturnLineCollection)
 {
     oDatabaseHelper = new DatabaseHelper();
     bool ExecutionState = false;
     oDatabaseHelper.BeginTransaction();
     if (UpdateHeader(oDatabaseHelper, sALSalesReturnHeader))
     {
         if (DeleteDetails(oDatabaseHelper, (int)sALSalesReturnHeader.SlaesReturnHeaderID, (int)sALSalesReturnHeader.UpdatedBy))
         {
             foreach (SALSalesReturnLine sALSalesReturnLine in sALSalesReturnLineCollection)
             {
                 if (!InsertDetails(oDatabaseHelper, sALSalesReturnLine, (int)sALSalesReturnHeader.SlaesReturnHeaderID))
                 {
                     ExecutionState = false;
                     break;
                 }
                 else
                     ExecutionState = true;
             }
             if (ExecutionState)
                 oDatabaseHelper.CommitTransaction();
             else
                 oDatabaseHelper.RollbackTransaction();
         }
         else
             ExecutionState = false;
     }
     else
         ExecutionState = false;
     oDatabaseHelper.Dispose();
     return ExecutionState;
 }
開發者ID:kimboox44，項目名稱:POS，代碼行數:32，代碼來源:SALSalesReturnLine.cs

示例6: HeaderSearch

        public static PURPurchaseHeaderCollection HeaderSearch(int InventoryID, DateTime FromDate, DateTime ToDate, string SupplierName, string InvoiceNumber)
        {
            DatabaseHelper oDatabaseHelper = new DatabaseHelper();
            bool ExecutionState = false;

            // Pass the specified field and its value to the stored procedure.
            oDatabaseHelper.AddParameter("@InventoryID", InventoryID );
            oDatabaseHelper.AddParameter("@FromDate", FromDate);
            oDatabaseHelper.AddParameter("@ToDate", ToDate );
            if (SupplierName!="")
            {
                oDatabaseHelper.AddParameter("@SupplierName", SupplierName); 
            }
            if (InvoiceNumber != "")
            {
                oDatabaseHelper.AddParameter("@InvoiceNumber", InvoiceNumber);
            }
            // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);

            IDataReader dr = oDatabaseHelper.ExecuteReader("usp_PURPurchaseHeader_SearchByCriteria", ref ExecutionState);
            PURPurchaseHeaderCollection PURPurchaseHeaderCollection = PopulateFromReader(dr);

            dr.Close();
            oDatabaseHelper.Dispose();
            return PURPurchaseHeaderCollection;

        }
開發者ID:kimboox44，項目名稱:POS，代碼行數:28，代碼來源:PURPurchaseHeader.cs

示例7: SaveTransaction

 public int SaveTransaction(SALSalesReturnHeader sALSalesReturnHeader, SALSalesReturnLineCollection sALSalesReturnLineCollection)
 {
     oDatabaseHelper = new DatabaseHelper();
     bool ExecutionState = false;
     int salesReturnHeaderID = -1;
     oDatabaseHelper.BeginTransaction();
     if (InsertHeader(oDatabaseHelper, sALSalesReturnHeader, out salesReturnHeaderID))
     {
         foreach (SALSalesReturnLine sALSalesLine in sALSalesReturnLineCollection)
         {
             if (!InsertDetails(oDatabaseHelper, sALSalesLine, salesReturnHeaderID))
             {
                 ExecutionState = false;
                 break;
             }
             else
                 ExecutionState = true;
         }
         if (ExecutionState)
         {
             oDatabaseHelper.CommitTransaction();
         }
         else
         {
             oDatabaseHelper.RollbackTransaction();
             salesReturnHeaderID = -1;
         }
     }
     oDatabaseHelper.Dispose();
     return salesReturnHeaderID;
 }
開發者ID:kimboox44，項目名稱:POS，代碼行數:31，代碼來源:SALSalesReturnLine.cs

示例8: DeleteTransaction

        public bool DeleteTransaction(int ProductStockID,INVAdjustStockCollection ajustStockCollection)
        {
            oDatabaseHelper = new DatabaseHelper();
            bool ExecutionState = false;

            oDatabaseHelper.BeginTransaction();
            if (DeleteAdjustStock(oDatabaseHelper,ProductStockID))
            {

                foreach (INVAdjustStock adjustStock in ajustStockCollection)
                {
                    if (!InsertDetailsAndCommit(oDatabaseHelper, adjustStock))
                    {
                        ExecutionState = false;
                        break;
                    }
                    else
                        ExecutionState = true;
                }
            }
            else
                ExecutionState = false;
            if (ExecutionState)
                oDatabaseHelper.CommitTransaction();
            else
                oDatabaseHelper.RollbackTransaction();
            return ExecutionState;
        }
開發者ID:kimboox44，項目名稱:POS，代碼行數:28，代碼來源:INVAdjustStock.cs

示例9: InsertGroupRoles

        public static bool InsertGroupRoles(ADGroupRoleCollection aDGroupRoleCollection, int groupID)
        {

            DatabaseHelper oDatabaseHelper = new DatabaseHelper();
            bool ExecutionState = false;
            oDatabaseHelper.BeginTransaction();
            if (Deletelines(oDatabaseHelper, groupID))
            {
                foreach (ADGroupRole groupRole in aDGroupRoleCollection)
                {
                    if (!InsertDetails(oDatabaseHelper, groupRole))
                    {
                        ExecutionState = false;
                        break;
                    }
                    else
                        ExecutionState = true;

                }
                if (ExecutionState)
                    oDatabaseHelper.CommitTransaction();
                else
                    oDatabaseHelper.RollbackTransaction();

            }
            else
                ExecutionState = false;

            oDatabaseHelper.Dispose();
            return ExecutionState;

        }
開發者ID:kimboox44，項目名稱:POS，代碼行數:32，代碼來源:ADGroupRole.cs

示例10: Deletelines

        private static bool Deletelines(DatabaseHelper oDatabaseHelper, int groupID)
        {
            bool ExecutionState = false;
            oDatabaseHelper.AddParameter("@Field", "GroupID");
            oDatabaseHelper.AddParameter("@Value", groupID);
            // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);
            oDatabaseHelper.ExecuteScalar("gsp_ADGroupRole_DeleteByField", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState);

            return ExecutionState;
        }
開發者ID:kimboox44，項目名稱:POS，代碼行數:11，代碼來源:ADGroupRole.cs

示例11: CloseOrder

 public static bool CloseOrder(int SalesHeaderID, int UserID)
 {
     DatabaseHelper oDatabaseHelper = new DatabaseHelper();
     bool ExecutionState = false;
     // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure.
     oDatabaseHelper.AddParameter("@UserID", UserID);
     oDatabaseHelper.AddParameter("@SlaesReturnHeaderID", SalesHeaderID);
     oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);
     oDatabaseHelper.ExecuteScalar("usp_SALSalesReturnHader_CloseOrder", ref ExecutionState);
     oDatabaseHelper.Dispose();
     return ExecutionState;
 }
開發者ID:kimboox44，項目名稱:POS，代碼行數:12，代碼來源:SALSalesReturnHeader.cs

示例12: GetAllProductsForOpenningQuantities

        public static BDProductCollection GetAllProductsForOpenningQuantities(int InventoryID)
        {
            DatabaseHelper oDatabaseHelper = new DatabaseHelper();
            bool ExecutionState = false;

            oDatabaseHelper.AddParameter("@InventoryID", InventoryID);

            IDataReader dr = oDatabaseHelper.ExecuteReader("usp_GetopeningStockLine", ref ExecutionState);
            BDProductCollection BDProductCollection = BDProductBase.PopulateObjectsFromReader(dr);
            dr.Close();
            oDatabaseHelper.Dispose();
            return BDProductCollection;

        }
開發者ID:kimboox44，項目名稱:POS，代碼行數:14，代碼來源:BDProduct.cs

示例13: CloseOrder

 public bool CloseOrder(int INVTransferHeaderID, int UserID, INVTransferLineCollection transferLineCollection)
 {
     oDatabaseHelper = new DatabaseHelper();
     bool ExecutionState = false;
     oDatabaseHelper.BeginTransaction();
     oDatabaseHelper.AddParameter("@UserID", UserID);
     oDatabaseHelper.AddParameter("@INVTransferHeaderID", INVTransferHeaderID);
     oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);
     oDatabaseHelper.ExecuteScalar("usp_INVTransferHader_CloseOrder", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState);
     if (ExecutionState)
         oDatabaseHelper.CommitTransaction();
     else
         oDatabaseHelper.RollbackTransaction();
     oDatabaseHelper.Dispose();
     return ExecutionState;
 }
開發者ID:kimboox44，項目名稱:POS，代碼行數:16，代碼來源:INVTransferHeader.cs

示例14: InsertProductStockBatches

        public  bool InsertProductStockBatches(int userID, INVBatch iNVBatch)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper();
            oDatabaseHelper.AddParameter("@ProductStockID", iNVBatch.ProductStockID);
            oDatabaseHelper.AddParameter("@BatchNumber", iNVBatch.BatchNumber);
            oDatabaseHelper.AddParameter("@ExpiryDate", iNVBatch.ExpiryDate);
            oDatabaseHelper.AddParameter("@Qty", iNVBatch.Qty);

            oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("usp_INVBatch_ProductStockBatch", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;

        }
開發者ID:kimboox44，項目名稱:POS，代碼行數:16，代碼來源:INVBatch.cs

示例15: SearchByriteria

        public static VPurchaseReturnHeaderCollection SearchByriteria(string CustomerName, DateTime FromDate, DateTime ToDate, string InvoiceNumber)
        {
            DatabaseHelper oDatabaseHelper = new DatabaseHelper();
            bool ExecutionState = false;
            oDatabaseHelper.AddParameter("@SupplierName", CustomerName);
            oDatabaseHelper.AddParameter("@FromDate", FromDate);
            oDatabaseHelper.AddParameter("@DateTo", ToDate);
            oDatabaseHelper.AddParameter("@InvoiceNumber", InvoiceNumber);
            oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);

            IDataReader dr = oDatabaseHelper.ExecuteReader("usp_VPurchaseReturnHeader_SearchByCriteria", ref ExecutionState);
            VPurchaseReturnHeaderCollection VPurchaseReturnHeaderCollection = PopulateObjectsFromReader(dr);
            dr.Close();
            oDatabaseHelper.Dispose();
            return VPurchaseReturnHeaderCollection;

        }
開發者ID:kimboox44，項目名稱:POS，代碼行數:17，代碼來源:VPurchaseReturnHeader.cs


注：本文中的POS.DataLayer.DatabaseHelper類示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。