• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# Data.DataColumnChangeEventArgs类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中System.Data.DataColumnChangeEventArgs的典型用法代码示例。如果您正苦于以下问题:C# DataColumnChangeEventArgs类的具体用法?C# DataColumnChangeEventArgs怎么用?C# DataColumnChangeEventArgs使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



DataColumnChangeEventArgs类属于System.Data命名空间,在下文中一共展示了DataColumnChangeEventArgs类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: ValidateColumn

        void ValidateColumn(object sender, DataColumnChangeEventArgs e)
        {
            if (e.Column.Equals(this.patientidColumn))
            {
                if (Convert.IsDBNull(e.ProposedValue) || ((int)e.ProposedValue < 0))
                {
                    throw new ArgumentException(string.Format("{0} kan inte vara null eller negativt.", e.Column.ColumnName), e.Column.ColumnName);
                }
            }

            if (e.Column.Equals(this.startdatetimeColumn))
            {
                if (Convert.IsDBNull(e.ProposedValue) || (((DateTime)e.ProposedValue).Year == DateTime.MinValue.Year) || (((DateTime)e.ProposedValue).Year == DateTime.MaxValue.Year))
                {
                    throw new ArgumentException(string.Format("{0} är inte ett giltigt datum.", e.Column.ColumnName), "frikortsdatum");
                }
            }

            if (e.Column.Equals(this.titleColumn))
            {
                if (Convert.IsDBNull(e.ProposedValue) || ((string)e.ProposedValue).Length == 0)
                {
                    throw new ArgumentException(string.Format("{0} kan inte vara null eller tom.", e.Column.ColumnName), e.Column.ColumnName);
                }
            }
        }
开发者ID:andersruberg,项目名称:RehabWeb,代码行数:26,代码来源:Rehab.BookingsDataTable.cs


示例2: custTable_ColumnChanging

		private void custTable_ColumnChanging(object sender, DataColumnChangeEventArgs e)
		{
			if (e.Column.ColumnName.ToUpper() == "MIN" && e.ProposedValue is int && (int)e.ProposedValue < 0)
			{
				throw new ApplicationException("Min must be >= 0");
			}
		}
开发者ID:wsrf2009,项目名称:KnxUiEditor,代码行数:7,代码来源:TestDataSetPerformance.cs


示例3: VerifyUnitData

        /// <summary>
        /// todoComment
        /// </summary>
        /// <param name="e"></param>
        /// <param name="AMainDS"></param>
        /// <param name="AVerificationResult"></param>
        /// <returns></returns>
        public static Boolean VerifyUnitData(DataColumnChangeEventArgs e, PartnerEditTDS AMainDS, out TVerificationResult AVerificationResult)
        {
            Boolean ReturnValue;

            AVerificationResult = null;

            if (e.Column.ColumnName == PUnitTable.GetUnitNameDBName())
            {
                VerifyUnitNameChange(e, AMainDS, out AVerificationResult);
            }

            // any verification errors?
            if (AVerificationResult == null)
            {
                ReturnValue = true;
            }
            else
            {
                ReturnValue = false;

                // MessageBox.Show('VerifyUnitData: There was an error!');
            }

            return ReturnValue;
        }
开发者ID:Davincier,项目名称:openpetra,代码行数:32,代码来源:UC_PartnerEdit_CollapsiblePart.cs


示例4: OnColumnChanging

 protected override void OnColumnChanging(DataColumnChangeEventArgs e)
 {
     if (mCanWrite)
     {
         (e.Row as DataRowEx).OnRowChanged();
     }
     base.OnColumnChanging(e);
 }
开发者ID:viticm,项目名称:pap2,代码行数:8,代码来源:DataTableEx.cs


示例5: OnColumnChanging

 protected override void OnColumnChanging(DataColumnChangeEventArgs e)
 {
     if (e.Column.ColumnName == "Age")
     {
         if ((int)e.ProposedValue < 0 || (int)e.ProposedValue > 100)
         {
             e.Row.SetColumnError("Age", "나이는 0 ~ 100 사이여야 합니다.");
         }
         else
         {
             e.Row.SetColumnError("Age", "");
         }
     }
 }
开发者ID:gawallsibya,项目名称:BIT_MFC-CShap-DotNet,代码行数:14,代码来源:ADOTestDataSet.cs


示例6: tblPeople_ColumnChanging

 //* 컬럼 에러 설정
 void tblPeople_ColumnChanging(object sender, DataColumnChangeEventArgs e)
 {
     if (e.Column.ColumnName == "Age")
     {
         if ((int)e.ProposedValue < 0 || (int)e.ProposedValue > 100)
         {
             e.Row.SetColumnError("Age", "나이는 0 ~ 100 사이여야 합니다.");
         }
         else
         {
             e.Row.SetColumnError("Age", "");
         }
     }
 }
开发者ID:gawallsibya,项目名称:BIT_MFC-CShap-DotNet,代码行数:15,代码来源:Form1.cs


示例7: VerifySubscriptionData

        /// <summary>
        /// todoComment
        /// </summary>
        /// <param name="e"></param>
        /// <param name="AVerificationResultCollection"></param>
        /// <param name="AVerificationResult"></param>
        /// <param name="FDataColumnComparedTo"></param>
        /// <returns></returns>
        public static Boolean VerifySubscriptionData(DataColumnChangeEventArgs e,
            TVerificationResultCollection AVerificationResultCollection,
            out TVerificationResult AVerificationResult,
            out DataColumn FDataColumnComparedTo)
        {
            Boolean ReturnValue;

            AVerificationResult = null;
            DataColumn FDataColumnComparedTo2 = null;

            if ((e.Column.ColumnName == PSubscriptionTable.GetDateCancelledDBName())
                || (e.Column.ColumnName == PSubscriptionTable.GetExpiryDateDBName())
                || (e.Column.ColumnName == PSubscriptionTable.GetDateNoticeSentDBName())
                || (e.Column.ColumnName == PSubscriptionTable.GetStartDateDBName())
                || (e.Column.ColumnName == PSubscriptionTable.GetSubscriptionRenewalDateDBName())
                || (e.Column.ColumnName == PSubscriptionTable.GetFirstIssueDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetLastIssueDBName()))
            {
                VerifySubscriptionDates(e, AVerificationResultCollection, out AVerificationResult, out FDataColumnComparedTo2);
            }

            FDataColumnComparedTo = FDataColumnComparedTo2;

            // if (e.Column.Ordinal = (e.Column.Table as PPartnerLocationTable).ColumnEmailAddress.Ordinal) then
            // begin
            // VerifyEMailAddress(e, AVerificationResult);
            // end;
            if ((e.Column.ColumnName == PSubscriptionTable.GetPublicationCopiesDBName())
                || (e.Column.ColumnName == PSubscriptionTable.GetNumberIssuesReceivedDBName())
                || (e.Column.ColumnName == PSubscriptionTable.GetNumberComplimentaryDBName()))
            {
                VerifyInteger(e, out AVerificationResult);
            }

            // any verification errors?
            if (AVerificationResult == null)
            {
                ReturnValue = true;
            }
            else
            {
                ReturnValue = false;
            }

            return ReturnValue;
        }
开发者ID:Davincier,项目名称:openpetra,代码行数:53,代码来源:UC_PartnerSubscription.cs


示例8: BranchTable_ColumnChanged

 static void BranchTable_ColumnChanged(object sender, DataColumnChangeEventArgs e)
 {
     if (e.Column.ColumnName == "Push" && (bool)e.ProposedValue)
     {
         e.Row["Force"] = false;
         e.Row["Delete"] = false;
     }
     if (e.Column.ColumnName == "Force" && (bool)e.ProposedValue)
     {
         e.Row["Push"] = false;
         e.Row["Delete"] = false;
     }
     if (e.Column.ColumnName == "Delete" && (bool)e.ProposedValue)
     {
         e.Row["Push"] = false;
         e.Row["Force"] = false;
     }
 }
开发者ID:adrianoc,项目名称:gitextensions,代码行数:18,代码来源:FormPush.cs


示例9: ValidateColumn

 void ValidateColumn(object sender, DataColumnChangeEventArgs e)
 {
     if(e.Column.Equals(this.UnitPriceColumn))
     {
        if(!Convert.IsDBNull(e.ProposedValue) && (decimal)e.ProposedValue < 0)
        {
           throw new ArgumentException("UnitPrice cannot be less than zero", "UnitPrice");
        }
     }
     else if (e.Column.Equals(this.UnitsInStockColumn) ||
             e.Column.Equals(this.UnitsOnOrderColumn) ||
             e.Column.Equals(this.ReorderLevelColumn))
     {
         if (!Convert.IsDBNull(e.ProposedValue) && (short)e.ProposedValue < 0)
         {
             throw new ArgumentException(string.Format("{0} cannot be less than zero", e.Column.ColumnName), e.Column.ColumnName);
         }
     }
 }
开发者ID:kjeans,项目名称:online-shop,代码行数:19,代码来源:ProductsDataTable.ColumnChanging.cs


示例10: ReceiptDetailColumn_Changing

        private void ReceiptDetailColumn_Changing(object sender, DataColumnChangeEventArgs e)
        {
            if (e.Column == mDataSet.ReceiptDetail.PricePurchaseColumn)
            {
            //  MessageBox.Show(e.ProposedValue.ToString());
            }
           
            if (e.Column == mDataSet.ReceiptDetail.QuantityColumn)
            {
                MDataSet.RemainsRow remainsRow = (e.Row as MDataSet.ReceiptDetailRow).RemainsRow;

                    if (((e.Row as MDataSet.ReceiptDetailRow).Quantity - remainsRow.QuantityRemains) > ((decimal)e.ProposedValue))
                    {
                        MessageBox.Show("Товара уже продано больше!");

                        e.ProposedValue = (e.Row as MDataSet.ReceiptDetailRow).Quantity;
                    }
                    else
                        remainsRow.QuantityRemains += (decimal)e.ProposedValue - (e.Row as MDataSet.ReceiptDetailRow).Quantity;
            }
        }
开发者ID:vpjulia,项目名称:Salvia,代码行数:21,代码来源:MainForm.Data.cs


示例11: VerifyPartnerLocationData

        /// <summary>
        /// todoComment
        /// </summary>
        /// <param name="e"></param>
        /// <param name="AVerificationResultCollection"></param>
        /// <param name="AVerificationResult"></param>
        /// <returns></returns>
        public static Boolean VerifyPartnerLocationData(DataColumnChangeEventArgs e,
            TVerificationResultCollection AVerificationResultCollection,
            out TVerificationResult AVerificationResult)
        {
            Boolean ReturnValue;

            AVerificationResult = null;

            // MessageBox.Show('Verifying DataRow...');
            if ((e.Column.ColumnName == PPartnerLocationTable.GetDateEffectiveDBName())
                || (e.Column.ColumnName == PPartnerLocationTable.GetDateGoodUntilDBName()))
            {
                VerifyDates(e, AVerificationResultCollection, out AVerificationResult);
            }

            if (e.Column.Ordinal == ((PPartnerLocationTable)e.Column.Table).ColumnEmailAddress.Ordinal)
            {
                VerifyEmailAddress(e, out AVerificationResult);
            }

            if (e.Column.Ordinal == ((PPartnerLocationTable)e.Column.Table).ColumnLocationType.Ordinal)
            {
                VerifyLocationType(e, out AVerificationResult);
            }

            // any verification errors?
            if (AVerificationResult == null)
            {
                ReturnValue = true;
            }
            else
            {
                ReturnValue = false;

                // MessageBox.Show('VerifyPartnerLocationData: There was an error!');
            }

            return ReturnValue;
        }
开发者ID:Davincier,项目名称:openpetra,代码行数:46,代码来源:UC_PartnerAddress.cs


示例12: ValidateColumn

        void ValidateColumn(object sender, DataColumnChangeEventArgs e)
        {
            if (e.Column.Equals(this.personnumberColumn))
            {
                if (Convert.IsDBNull(e.ProposedValue) || ((string)e.ProposedValue).Length == 0)
                {
                    throw new ArgumentException(string.Format("{0} kan inte vara null eller tom.", e.Column.ColumnName), "personnumret");
                }
            }

            if (e.Column.Equals(this.freecarddateColumn))
            {
                if (!Convert.IsDBNull(e.ProposedValue))
                {
                    if (((DateTime.Parse((string)e.ProposedValue)).Year == DateTime.MinValue.Year) || ((DateTime.Parse((string)e.ProposedValue)).Year == DateTime.MaxValue.Year))
                    {
                        throw new ArgumentException(string.Format("{0} är inte ett giltigt datum.", e.Column.ColumnName), e.Column.ColumnName);
                    }
                }
            }

            if (e.Column.Equals(this.surnameColumn))
            {
                if (Convert.IsDBNull(e.ProposedValue) || ((string)e.ProposedValue).Length == 0)
                {
                    throw new ArgumentException(string.Format("{0} kan inte vara null eller tom.", e.Column.ColumnName), "efternamnet");
                }
            }

            if (e.Column.Equals(this.firstnameColumn))
            {
                if (Convert.IsDBNull(e.ProposedValue) || ((string)e.ProposedValue).Length == 0)
                {
                    throw new ArgumentException(string.Format("{0} kan inte vara null eller tom.", e.Column.ColumnName), "efternamnet");
                }
            }
        }
开发者ID:andersruberg,项目名称:RehabWeb,代码行数:37,代码来源:Rehab.PatientsDataTable.cs


示例13: myReceiptMasterTable_ColumnChanged

        private void myReceiptMasterTable_ColumnChanged(object sender, DataColumnChangeEventArgs e)
        {
            if (IsColumnChangedDisable())
                return;

            if (System.String.Compare(e.Column.ColumnName, "strDiscountCode", true) == 0 ||
                System.String.Compare(e.Column.ColumnName, "DiscountAmt", true) == 0 ||
                System.String.Compare(e.Column.ColumnName, "mVoucherAmount", true) == 0 ||
                System.String.Compare(e.Column.ColumnName, "mNettAmount", true) == 0 ||
                System.String.Compare(e.Column.ColumnName, "mGSTAmount", true) == 0)
            {
                DisableColumnChanged();

                try
                {
                    RecalculateAll();
                }
                finally
                {
                    EnableColumnChanged();
                }
            }
            else if (System.String.Compare(e.Column.ColumnName, "nSalesPersonID", true) == 0)
            {
                DisableColumnChanged();

                try
                {
                    TblEmployee employee = new TblEmployee();
                    employee.NEmployeeID = ACMS.Convert.ToInt32(myReceiptMasterTable.Rows[0]["nSalesPersonID"]);
                    employee.SelectOne();
                    if (employee.StrEmployeeName.IsNull)
                        e.Row["strSalesPersonName"] = DBNull.Value;
                    else
                        e.Row["strSalesPersonName"] = employee.StrEmployeeName.Value;
                }
                finally
                {
                    EnableColumnChanged();
                }
            }
            else if (System.String.Compare(e.Column.ColumnName, "nTherapistID", true) == 0)
            {
                DisableColumnChanged();

                try
                {
                    TblEmployee employee = new TblEmployee();
                    employee.NEmployeeID = ACMS.Convert.ToInt32(myReceiptMasterTable.Rows[0]["nTherapistID"]);
                    employee.SelectOne();
                    if (employee.StrEmployeeName.IsNull)
                        e.Row["strTherapistName"] = DBNull.Value;
                    else
                        e.Row["strTherapistName"] = employee.StrEmployeeName.Value;
                }
                finally
                {
                    EnableColumnChanged();
                }
            }
            else if (System.String.Compare(e.Column.ColumnName, "strReceiptNo", true) == 0)
            {
                ChangeReceipNo();
            }
        }
开发者ID:kimykunjun,项目名称:test,代码行数:65,代码来源:POS.cs


示例14: myReceiptItemsTable_ColumnChanged

        private void myReceiptItemsTable_ColumnChanged(object sender, DataColumnChangeEventArgs e)
        {
            if (IsColumnChangedDisable())
                return;

            connectionString = (string)ConfigurationSettings.AppSettings["Main.ConnectionString"];
            connection = new SqlConnection(connectionString);
            if (System.String.Compare(e.Column.ColumnName, "strDiscountCode", true) == 0 ||
                System.String.Compare(e.Column.ColumnName, "mUnitPrice", true) == 0 ||
                System.String.Compare(e.Column.ColumnName, "nQuantity", true) == 0 ||
                System.String.Compare(e.Column.ColumnName, "DiscountAmt", true) == 0 )
            {
                DisableColumnChanged();
                //BeginGridUpdate();

                try
                {
                    if (myCategoryID != 11 && myCategoryID != 12)
                    {
                        if (ACMS.Convert.ToInt32(e.Row["nQuantity"]) < 0)
                        {
                            e.Row["nQuantity"] = 0;
                        }
                    }
                    else
                    {
                        string strSQL = "SELECT nQty from tblSCStockRecon where strProductCode='" + e.Row["strCode"] + "' AND strBranchCode='" + myBranchCode + "' ";
                        DataSet _ds = new DataSet();
                        SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "table" }, new SqlParameter("@strSQL", strSQL));
                        if (_ds.Tables["table"].Rows.Count > 0 && e.Row["nQuantity"].ToString() != "")
                        {
                            if (Convert.ToInt16(e.Row["nQuantity"]) > Convert.ToInt16(_ds.Tables["table"].Rows[0]["nQty"]))
                            {
                                MessageBox.Show("Quantity entered greater than stock quantity ( " + _ds.Tables["table"].Rows[0]["nQty"].ToString() + " )", "Warning", MessageBoxButtons.OK);
                                e.Row["nQuantity"] = Convert.ToInt16(_ds.Tables["table"].Rows[0]["nQty"]);
                                return;
                            }
                        }
                        _ds.Dispose();
                    }

                    CalculateSubTotal(e.Row);
                    RecalculateAll();
                }
                finally
                {
                    //EndGridUpdate();
                    EnableColumnChanged();
                }

            }

            else if (System.String.Compare(e.Column.ColumnName, "StrReferenceNo", true) == 0)
            {
                StrReferenceNo = e.Row["StrReferenceNo"].ToString();
            }
        }
开发者ID:kimykunjun,项目名称:test,代码行数:57,代码来源:POS.cs


示例15: m_dtShiftSetting_ColumnChanged

 private void m_dtShiftSetting_ColumnChanged(object sender, DataColumnChangeEventArgs e)
 {
     DirtyData = true;
 }
开发者ID:puentepr,项目名称:thuctapvietinsoft,代码行数:4,代码来源:ShiftSetting.cs


示例16: OnColumnChanging

 protected internal virtual void OnColumnChanging(DataColumnChangeEventArgs e) {
     // intentionally allow exceptions to bubble up.  We haven't committed anything yet.
     Debug.Assert(e != null, "e should not be null");
     if (onColumnChangingDelegate != null) {
         Bid.Trace("<ds.DataTable.OnColumnChanging|INFO> %d#\n", ObjectID);
         onColumnChangingDelegate(this, e);
     }
 }
开发者ID:nlh774,项目名称:DotNetReferenceSource,代码行数:8,代码来源:DataTable.cs


示例17: OnAnyDataColumnChanging

        /// <summary>
        /// todoComment
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public void OnAnyDataColumnChanging(System.Object sender, DataColumnChangeEventArgs e)
        {
            if (!FNoAutoEnableOfSaving)
            {
//TLogging.Log("Column_Changing Event: Column=" + e.Column.ColumnName +
//                "; Column content=" + e.Row[e.Column.ColumnName].ToString() +
//                "; " + e.ProposedValue.ToString());
                SetChangedFlag();
            }
        }
开发者ID:js1987,项目名称:openpetragit,代码行数:15,代码来源:PetraEditForm.cs


示例18: RaiseOnColumnChanging

		internal void RaiseOnColumnChanging (DataColumnChangeEventArgs e)
		{
			OnColumnChanging(e);
		}
开发者ID:shana,项目名称:mono,代码行数:4,代码来源:DataTable.cs


示例19: stringsTable_ColumnChanging

 /// <summary>
 ///     Eventhandler for the datatable of strings
 /// </summary>
 private void stringsTable_ColumnChanging(object sender, DataColumnChangeEventArgs e)
 {
     if (e.Column == e.Column.Table.Columns["Key"])
     {
         DataRow[] foundRows = e.Column.Table.Select("Key='" + e.ProposedValue + "'");
         if (foundRows.Count() > 1
             || (foundRows.Count() == 1 && foundRows[0] != e.Row))
         {
             e.Row["Error"] = true;
             throw new DuplicateNameException(e.Row["Key"].ToString());
         }
         this.Dirty = true;
     }
 }
开发者ID:Mcafee123,项目名称:ResxTranslator,代码行数:17,代码来源:ResourceHolder.cs


示例20: myReceiptPaymentTable_ColumnChanged

        private void myReceiptPaymentTable_ColumnChanged(object sender, DataColumnChangeEventArgs e)
        {
            if (IsColumnChangedDisable())
                return;

            if (System.String.Compare(e.Column.ColumnName, "mAmount", true) == 0)
            {
                DisableColumnChanged();
                //BeginGridUpdate();

                try
                {
                    CalculateOutStanding();
                }
                finally
                {
                    //EndGridUpdate();
                    EnableColumnChanged();
                }
            }
        }
开发者ID:kimykunjun,项目名称:test,代码行数:21,代码来源:POS.cs



注:本文中的System.Data.DataColumnChangeEventArgs类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# Data.DataColumnCollection类代码示例发布时间:2022-05-26
下一篇:
C# Data.DataColumn类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap