public long InsertPBML_SDM_DODetailRevised(BOPBML_SDM_DODetail dodObj, string doSerialNumber, bool isdoRevised)
        {
            try
            {
                var ht = new Hashtable();

                ht.Add("DONO", dodObj.DONO1);
                ht.Add("ProductCode", dodObj.ProductCode1);
                ht.Add("Quantity", dodObj.Quantity1);
                ht.Add("DiscountQuantity", dodObj.DiscountQuantity1);
                ht.Add("DiscountID", dodObj.DiscountID1);
                ht.Add("Rate", dodObj.Rate1);
                ht.Add("IsDC", dodObj.IsDC1);
                ht.Add("IsIncentive", dodObj.IsIncentive1);
                ht.Add("IncentiveCalculateDate", dodObj.IncentiveCalculateDate1);
                ht.Add("IsActive", dodObj.IsActive1);
                ht.Add("CreatedBy", dodObj.CreatedBy1);
                ht.Add("CreatedDate", dodObj.CreatedDate1);
                ht.Add("UpdatedBy", dodObj.UpdatedBy1);
                ht.Add("UpdatedDate", dodObj.UpdatedDate1);
                ht.Add("DORevisedSerialNumber", doSerialNumber);
                ht.Add("ISDORevised", isdoRevised);

                return(Convert.ToInt64(idbutility.InsertData(ht, "spInsertPBML_SDM_DODetailRevised")));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public long InsertPBML_SDM_DODetail(BOPBML_SDM_DODetail boItem)
        {
            try
            {
                var ht = new Hashtable();

                ht.Add("DONO", boItem.DONO1);
                ht.Add("ProductCode", boItem.ProductCode1);
                ht.Add("Quantity", boItem.Quantity1);
                ht.Add("DiscountQuantity", boItem.DiscountQuantity1);
                ht.Add("DiscountID", boItem.DiscountID1);
                ht.Add("Rate", boItem.Rate1);
                ht.Add("IsDC", boItem.IsDC1);
                ht.Add("IsIncentive", boItem.IsIncentive1);
                ht.Add("IncentiveCalculateDate", boItem.IncentiveCalculateDate1);
                ht.Add("IsActive", boItem.IsActive1);
                ht.Add("CreatedBy", boItem.CreatedBy1);
                ht.Add("CreatedDate", boItem.CreatedDate1);
                ht.Add("UpdatedBy", boItem.UpdatedBy1);
                ht.Add("UpdatedDate", boItem.UpdatedDate1);


                return(Convert.ToInt64(idbutility.InsertData(ht, "spInsertPBML_SDM_DODetail")));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }