accountdata.cs

会员管理系统

            
            public override DataTable Clone() {
                AccountInfoDataTable cln = ((AccountInfoDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new AccountInfoDataTable();
            }
            
            internal void InitVars() {
                this.columnAccountID = this.Columns["AccountID"];
                this.columnBalance = this.Columns["Balance"];
                this.columnOverDate = this.Columns["OverDate"];
                this.columnAccountType = this.Columns["AccountType"];
                this.columnCalType = this.Columns["CalType"];
                this.columnStatus = this.Columns["Status"];
                this.columnRemark = this.Columns["Remark"];
            }
            
            private void InitClass() {
                this.columnAccountID = new DataColumn("AccountID", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnAccountID);
                this.columnBalance = new DataColumn("Balance", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnBalance);
                this.columnOverDate = new DataColumn("OverDate", typeof(System.DateTime), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnOverDate);
                this.columnAccountType = new DataColumn("AccountType", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnAccountType);
                this.columnCalType = new DataColumn("CalType", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnCalType);
                this.columnStatus = new DataColumn("Status", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnStatus);
                this.columnRemark = new DataColumn("Remark", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnRemark);
                this.Constraints.Add(new UniqueConstraint("AccountDataKey2", new DataColumn[] {
                                this.columnAccountID}, true));
                this.columnAccountID.AllowDBNull = false;
                this.columnAccountID.Unique = true;
                this.columnBalance.AllowDBNull = false;
                this.columnOverDate.AllowDBNull = false;
                this.columnStatus.AllowDBNull = false;
            }
            
            public AccountInfoRow NewAccountInfoRow() {
                return ((AccountInfoRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new AccountInfoRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(AccountInfoRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.AccountInfoRowChanged != null)) {
                    this.AccountInfoRowChanged(this, new AccountInfoRowChangeEvent(((AccountInfoRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.AccountInfoRowChanging != null)) {
                    this.AccountInfoRowChanging(this, new AccountInfoRowChangeEvent(((AccountInfoRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.AccountInfoRowDeleted != null)) {
                    this.AccountInfoRowDeleted(this, new AccountInfoRowChangeEvent(((AccountInfoRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.AccountInfoRowDeleting != null)) {
                    this.AccountInfoRowDeleting(this, new AccountInfoRowChangeEvent(((AccountInfoRow)(e.Row)), e.Action));
                }
            }
            
            public void RemoveAccountInfoRow(AccountInfoRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class AccountInfoRow : DataRow {
            
            private AccountInfoDataTable tableAccountInfo;
            
            internal AccountInfoRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tableAccountInfo = ((AccountInfoDataTable)(this.Table));
            }
            
            public string AccountID {
                get {
                    return ((string)(this[this.tableAccountInfo.AccountIDColumn]));
                }
                set {
                    this[this.tableAccountInfo.AccountIDColumn] = value;
                }
            }
            
            public System.Decimal Balance {
                get {
                    return ((System.Decimal)(this[this.tableAccountInfo.BalanceColumn]));
                }
                set {
                    this[this.tableAccountInfo.BalanceColumn] = value;
                }
            }
            
            public System.DateTime OverDate {
                get {
                    return ((System.DateTime)(this[this.tableAccountInfo.OverDateColumn]));
                }
                set {
                    this[this.tableAccountInfo.OverDateColumn] = value;
                }
            }
            
            public string AccountType {
                get {
                    try {
                        return ((string)(this[this.tableAccountInfo.AccountTypeColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tableAccountInfo.AccountTypeColumn] = value;
                }
            }
            
            public string CalType {
                get {
                    try {
                        return ((string)(this[this.tableAccountInfo.CalTypeColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tableAccountInfo.CalTypeColumn] = value;
                }
            }
            
            public string Status {
                get {
                    return ((string)(this[this.tableAccountInfo.StatusColumn]));
                }
                set {
                    this[this.tableAccountInfo.StatusColumn] = value;
                }
            }
            
            public string Remark {
                get {
                    try {
                        return ((string)(this[this.tableAccountInfo.RemarkColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tableAccountInfo.RemarkColumn] = value;
                }
            }
            
            public bool IsAccountTypeNull() {
                return this.IsNull(this.tableAccountInfo.AccountTypeColumn);
            }
            
            public void SetAccountTypeNull() {
                this[this.tableAccountInfo.AccountTypeColumn] = System.Convert.DBNull;
            }
            
            public bool IsCalTypeNull() {
                return this.IsNull(this.tableAccountInfo.CalTypeColumn);
            }
            
            public void SetCalTypeNull() {
                this[this.tableAccountInfo.CalTypeColumn] = System.Convert.DBNull;
            }
            
            public bool IsRemarkNull() {
                return this.IsNull(this.tableAccountInfo.RemarkColumn);
            }
            
            public void SetRemarkNull() {
                this[this.tableAccountInfo.RemarkColumn] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class AccountInfoRowChangeEvent : EventArgs {
            
            private AccountInfoRow eventRow;
            
            private DataRowAction eventAction;
            
            public AccountInfoRowChangeEvent(AccountInfoRow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public AccountInfoRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class AccountHistoryInfoDataTable : DataTable, System.Collections.IEnumerable {
            
            private DataColumn columnAccountID;
            
            private DataColumn columnBalanceChgType;
            
            private DataColumn columnBalanceChgDate;
            
            private DataColumn columnPayType;
            
            private DataColumn columnCalType;
            
            private DataColumn columnBalanceChgNum;
            
            private DataColumn columnRemark;
            
            internal AccountHistoryInfoDataTable() : 
                    base("AccountHistoryInfo") {
                this.InitClass();
            }
            
            internal AccountHistoryInfoDataTable(DataTable table) : 
                    base(table.TableName) {
                if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
                    this.CaseSensitive = table.CaseSensitive;
                }
                if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
                    this.Locale = table.Locale;
                }
                if ((table.Namespace != table.DataSet.Namespace)) {
                    this.Namespace = table.Namespace;
                }
                this.Prefix = table.Prefix;
                this.MinimumCapacity = table.MinimumCapacity;
                this.DisplayExpression = table.DisplayExpression;
            }
            
            [System.ComponentModel.Browsable(false)]
            public int Count {
                get {
                    return this.Rows.Count;
                }
            }
            
            internal DataColumn AccountIDColumn {
                get {
                    return this.columnAccountID;
                }
            }
            
            internal DataColumn BalanceChgTypeColumn {
                get {
                    return this.columnBalanceChgType;
                }
            }
            
            internal DataColumn BalanceChgDateColumn {
                get {
                    return this.columnBalanceChgDate;
                }