testdataset.designer.cs

社区管理系统

            this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@贷方数目", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, 0, 0, "贷方数目", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@总计", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, 0, 0, "总计", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@日期", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "日期", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@账款状态", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "账款状态", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.UpdateCommand = new System.Data.SqlClient.SqlCommand();
            this._adapter.UpdateCommand.Connection = this.Connection;
            this._adapter.UpdateCommand.CommandText = @"UPDATE [dbo].[账款信息] SET [账款类别] = @账款类别, [账款名称] = @账款名称, [账款号码] = @账款号码, [借方数目] = @借方数目, [贷方数目] = @贷方数目, [总计] = @总计, [日期] = @日期, [账款状态] = @账款状态 WHERE (((@IsNull_账款类别 = 1 AND [账款类别] IS NULL) OR ([账款类别] = @Original_账款类别)) AND ((@IsNull_账款名称 = 1 AND [账款名称] IS NULL) OR ([账款名称] = @Original_账款名称)) AND ([账款号码] = @Original_账款号码) AND ((@IsNull_借方数目 = 1 AND [借方数目] IS NULL) OR ([借方数目] = @Original_借方数目)) AND ((@IsNull_贷方数目 = 1 AND [贷方数目] IS NULL) OR ([贷方数目] = @Original_贷方数目)) AND ((@IsNull_总计 = 1 AND [总计] IS NULL) OR ([总计] = @Original_总计)) AND ((@IsNull_日期 = 1 AND [日期] IS NULL) OR ([日期] = @Original_日期)) AND ((@IsNull_账款状态 = 1 AND [账款状态] IS NULL) OR ([账款状态] = @Original_账款状态)));
SELECT 账款类别, 账款名称, 账款号码, 借方数目, 贷方数目, 总计, 日期, 账款状态 FROM 账款信息 WHERE (账款号码 = @账款号码)";
            this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@账款类别", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "账款类别", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@账款名称", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "账款名称", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@账款号码", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "账款号码", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@借方数目", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, 0, 0, "借方数目", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@贷方数目", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, 0, 0, "贷方数目", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@总计", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, 0, 0, "总计", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@日期", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "日期", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@账款状态", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "账款状态", System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_账款类别", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "账款类别", System.Data.DataRowVersion.Original, true, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_账款类别", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "账款类别", System.Data.DataRowVersion.Original, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_账款名称", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "账款名称", System.Data.DataRowVersion.Original, true, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_账款名称", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "账款名称", System.Data.DataRowVersion.Original, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_账款号码", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "账款号码", System.Data.DataRowVersion.Original, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_借方数目", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "借方数目", System.Data.DataRowVersion.Original, true, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_借方数目", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, 0, 0, "借方数目", System.Data.DataRowVersion.Original, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_贷方数目", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "贷方数目", System.Data.DataRowVersion.Original, true, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_贷方数目", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, 0, 0, "贷方数目", System.Data.DataRowVersion.Original, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_总计", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "总计", System.Data.DataRowVersion.Original, true, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_总计", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, 0, 0, "总计", System.Data.DataRowVersion.Original, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_日期", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "日期", System.Data.DataRowVersion.Original, true, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_日期", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "日期", System.Data.DataRowVersion.Original, false, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_账款状态", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "账款状态", System.Data.DataRowVersion.Original, true, null, "", "", ""));
            this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_账款状态", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "账款状态", System.Data.DataRowVersion.Original, false, null, "", "", ""));
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        private void InitConnection() {
            this._connection = new System.Data.SqlClient.SqlConnection();
            this._connection.ConnectionString = global::CaiWuControlLibrary1.Properties.Settings.Default.testConnectionString;
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        private void InitCommandCollection() {
            this._commandCollection = new System.Data.SqlClient.SqlCommand[1];
            this._commandCollection[0] = new System.Data.SqlClient.SqlCommand();
            this._commandCollection[0].Connection = this.Connection;
            this._commandCollection[0].CommandText = "SELECT 账款类别, 账款名称, 账款号码, 借方数目, 贷方数目, 总计, 日期, 账款状态 FROM dbo.账款信息";
            this._commandCollection[0].CommandType = System.Data.CommandType.Text;
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
        public virtual int Fill(testDataSet.账款信息DataTable dataTable) {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if ((this.ClearBeforeFill == true)) {
                dataTable.Clear();
            }
            int returnValue = this.Adapter.Fill(dataTable);
            return returnValue;
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public virtual testDataSet.账款信息DataTable GetData() {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            testDataSet.账款信息DataTable dataTable = new testDataSet.账款信息DataTable();
            this.Adapter.Fill(dataTable);
            return dataTable;
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        public virtual int Update(testDataSet.账款信息DataTable dataTable) {
            return this.Adapter.Update(dataTable);
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        public virtual int Update(testDataSet dataSet) {
            return this.Adapter.Update(dataSet, "账款信息");
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        public virtual int Update(System.Data.DataRow dataRow) {
            return this.Adapter.Update(new System.Data.DataRow[] {
                        dataRow});
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        public virtual int Update(System.Data.DataRow[] dataRows) {
            return this.Adapter.Update(dataRows);
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
        public virtual int Delete(string Original_账款类别, string Original_账款名称, long Original_账款号码, System.Nullable<double> Original_借方数目, System.Nullable<double> Original_贷方数目, System.Nullable<double> Original_总计, System.Nullable<System.DateTime> Original_日期, string Original_账款状态) {
            if ((Original_账款类别 == null)) {
                this.Adapter.DeleteCommand.Parameters[0].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[1].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.DeleteCommand.Parameters[0].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[1].Value = ((string)(Original_账款类别));
            }
            if ((Original_账款名称 == null)) {
                this.Adapter.DeleteCommand.Parameters[2].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[3].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.DeleteCommand.Parameters[2].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[3].Value = ((string)(Original_账款名称));
            }
            this.Adapter.DeleteCommand.Parameters[4].Value = ((long)(Original_账款号码));
            if ((Original_借方数目.HasValue == true)) {
                this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[6].Value = ((double)(Original_借方数目.Value));
            }
            else {
                this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[6].Value = System.DBNull.Value;
            }
            if ((Original_贷方数目.HasValue == true)) {
                this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[8].Value = ((double)(Original_贷方数目.Value));
            }
            else {
                this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[8].Value = System.DBNull.Value;
            }
            if ((Original_总计.HasValue == true)) {
                this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[10].Value = ((double)(Original_总计.Value));
            }
            else {
                this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[10].Value = System.DBNull.Value;
            }
            if ((Original_日期.HasValue == true)) {
                this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[12].Value = ((System.DateTime)(Original_日期.Value));
            }
            else {
                this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[12].Value = System.DBNull.Value;
            }
            if ((Original_账款状态 == null)) {
                this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[14].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[14].Value = ((string)(Original_账款状态));
            }
            System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
            if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open) 
                        != System.Data.ConnectionState.Open)) {
                this.Adapter.DeleteCommand.Connection.Open();
            }
            try {
                int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
                return returnValue;
            }
            finally {
                if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
                    this.Adapter.DeleteCommand.Connection.Close();
                }
            }
        }
        
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
        public virtual int Insert(string 账款类别, string 账款名称, long 账款号码, System.Nullable<double> 借方数目, System.Nullable<double> 贷方数目, System.Nullable<double> 总计, System.Nullable<System.DateTime> 日期, string 账款状态) {
            if ((账款类别 == null)) {
                this.Adapter.InsertCommand.Parameters[0].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.InsertCommand.Parameters[0].Value = ((string)(账款类别));
            }
            if ((账款名称 == null)) {
                this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.InsertCommand.Parameters[1].Value = ((string)(账款名称));
            }
            this.Adapter.InsertCommand.Parameters[2].Value = ((long)(账款号码));
            if ((借方数目.HasValue == true)) {
                this.Adapter.InsertCommand.Parameters[3].Value = ((double)(借方数目.Value));
            }
            else {
                this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
            }
            if ((贷方数目.HasValue == true)) {
                this.Adapter.InsertCommand.Parameters[4].Value = ((double)(贷方数目.Value));
            }
            else {
                this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
            }
            if ((总计.HasValue == true)) {
                this.Adapter.InsertCommand.Parameters[5].Value = ((double)(总计.Value));
            }
            else {
                this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
            }
            if ((日期.HasValue == true)) {
                this.Adapter.InsertCommand.Parameters[6].Value = ((System.DateTime)(日期.Value));
            }
            else {
                this.Adapter.InsertCommand.Par