wupengdataset.designer.cs

简单的通讯录程序

        public virtual int Fill(wupengDataSet.customDataTable dataTable) {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if ((this.ClearBeforeFill == true)) {
                dataTable.Clear();
            }
            int returnValue = this.Adapter.Fill(dataTable);
            return returnValue;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
        public virtual wupengDataSet.customDataTable GetData() {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            wupengDataSet.customDataTable dataTable = new wupengDataSet.customDataTable();
            this.Adapter.Fill(dataTable);
            return dataTable;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        public virtual int Update(wupengDataSet.customDataTable dataTable) {
            return this.Adapter.Update(dataTable);
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        public virtual int Update(wupengDataSet dataSet) {
            return this.Adapter.Update(dataSet, "custom");
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        public virtual int Update(global::System.Data.DataRow dataRow) {
            return this.Adapter.Update(new global::System.Data.DataRow[] {
                        dataRow});
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        public virtual int Update(global::System.Data.DataRow[] dataRows) {
            return this.Adapter.Update(dataRows);
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
        public virtual int Delete(string Original_name, System.DateTime Original_birth, string Original_sex, string Original_addr, string Original_post, string Original_telphone, string Original_more, string Original_grp) {
            if ((Original_name == null)) {
                throw new global::System.ArgumentNullException("Original_name");
            }
            else {
                this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(Original_name));
            }
            this.Adapter.DeleteCommand.Parameters[1].Value = ((System.DateTime)(Original_birth));
            if ((Original_sex == null)) {
                throw new global::System.ArgumentNullException("Original_sex");
            }
            else {
                this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(Original_sex));
            }
            if ((Original_addr == null)) {
                throw new global::System.ArgumentNullException("Original_addr");
            }
            else {
                this.Adapter.DeleteCommand.Parameters[3].Value = ((string)(Original_addr));
            }
            if ((Original_post == null)) {
                throw new global::System.ArgumentNullException("Original_post");
            }
            else {
                this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_post));
            }
            if ((Original_telphone == null)) {
                throw new global::System.ArgumentNullException("Original_telphone");
            }
            else {
                this.Adapter.DeleteCommand.Parameters[5].Value = ((string)(Original_telphone));
            }
            if ((Original_more == null)) {
                throw new global::System.ArgumentNullException("Original_more");
            }
            else {
                this.Adapter.DeleteCommand.Parameters[6].Value = ((string)(Original_more));
            }
            if ((Original_grp == null)) {
                this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[8].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[8].Value = ((string)(Original_grp));
            }
            global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
            if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open) 
                        != global::System.Data.ConnectionState.Open)) {
                this.Adapter.DeleteCommand.Connection.Open();
            }
            try {
                int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
                return returnValue;
            }
            finally {
                if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
                    this.Adapter.DeleteCommand.Connection.Close();
                }
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
        public virtual int Insert(string name, System.DateTime birth, string sex, string addr, string post, string telphone, string more, string grp) {
            if ((name == null)) {
                throw new global::System.ArgumentNullException("name");
            }
            else {
                this.Adapter.InsertCommand.Parameters[0].Value = ((string)(name));
            }
            this.Adapter.InsertCommand.Parameters[1].Value = ((System.DateTime)(birth));
            if ((sex == null)) {
                throw new global::System.ArgumentNullException("sex");
            }
            else {
                this.Adapter.InsertCommand.Parameters[2].Value = ((string)(sex));
            }
            if ((addr == null)) {
                throw new global::System.ArgumentNullException("addr");
            }
            else {
                this.Adapter.InsertCommand.Parameters[3].Value = ((string)(addr));
            }
            if ((post == null)) {
                throw new global::System.ArgumentNullException("post");
            }
            else {
                this.Adapter.InsertCommand.Parameters[4].Value = ((string)(post));
            }
            if ((telphone == null)) {
                throw new global::System.ArgumentNullException("telphone");
            }
            else {
                this.Adapter.InsertCommand.Parameters[5].Value = ((string)(telphone));
            }
            if ((more == null)) {
                throw new global::System.ArgumentNullException("more");
            }
            else {
                this.Adapter.InsertCommand.Parameters[6].Value = ((string)(more));
            }
            if ((grp == null)) {
                this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.InsertCommand.Parameters[7].Value = ((string)(grp));
            }
            global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
            if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open) 
                        != global::System.Data.ConnectionState.Open)) {
                this.Adapter.InsertCommand.Connection.Open();
            }
            try {
                int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
                return returnValue;
            }
            finally {
                if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
                    this.Adapter.InsertCommand.Connection.Close();
                }
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
        public virtual int Update(
                    string name, 
                    System.DateTime birth, 
                    string sex, 
                    string addr, 
                    string post, 
                    string telphone, 
                    string more, 
                    string grp, 
                    string Original_name, 
                    System.DateTime Original_birth, 
                    string Original_sex, 
                    string Original_addr, 
                    string Original_post, 
                    string Original_telphone, 
                    string Original_more, 
                    string Original_grp) {
            if ((name == null)) {
                throw new global::System.ArgumentNullException("name");
            }
            else {
                this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(name));
            }
            this.Adapter.UpdateCommand.Parameters[1].Value = ((System.DateTime)(birth));
            if ((sex == null)) {
                throw new global::System.ArgumentNullException("sex");
            }
            else {
                this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(sex));
            }
            if ((addr == null)) {
                throw new global::System.ArgumentNullException("addr");
            }
            else {
                this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(addr));
            }
            if ((post == null)) {
                throw new global::System.ArgumentNullException("post");
            }
            else {
                this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(post));
            }
            if ((telphone == null)) {
                throw new global::System.ArgumentNullException("telphone");
            }
            else {
                this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(telphone));
            }
            if ((more == null)) {
                throw new global::System.ArgumentNullException("more");
            }
            else {
                this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(more));
            }
            if ((grp == null)) {