testdataset.designer.cs

社区管理系统

            this._adapter.InsertCommand.Connection = this.Connection;
            this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[设施维护] ([设施编号], [设施名称], [维护人员], [电话], [维护时间], [设施平面图], [维护费用], " +
                "[维护说明]) VALUES (@设施编号, @设施名称, @维护人员, @电话, @维护时间, @设施平面图, @维护费用, @维护说明);\r\nSELECT " +
                "设施编号, 设施名称, 维护人员, 电话, 维护时间, 设施平面图, 维护费用, 维护说明 FROM 设施维护 WHERE (设施编号 = @设施编号)";
            this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
            this._adapter.InsertCommand.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.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.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.InsertCommand.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.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.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.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 (([设施编号] = @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_设施平面图)) 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.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.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.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("@维护费用", 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.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "维护说明", System.Data.DataRowVersion.Current, 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.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("@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.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.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, "", "", ""));
            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.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::ServiceControlLibrary1.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(long Original_设施编号, string Original_设施名称, string Original_维护人员, System.Nullable<long> Original_电话, System.Nullable<System.DateTime> Original_维护时间, string Original_设施平面图, System.Nullable<double> Original_维护费用, string Original_维护说明) {
            this.Adapter.DeleteCommand.Parameters[0].Value = ((long)(Original_设施编号));
            if ((Original_设施名称 == null)) {
                this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[2].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(Original_设施名称));
            }
            if ((Original_维护人员 == null)) {
                this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[4].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_维护人员));
            }
            if ((Original_电话.HasValue == true)) {
                this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[6].Value = ((long)(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 = ((System.DateTime)(Original_维护时间.Value));
            }
            else {
                this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[8].Value = System.DBNull.Value;
            }
            if ((Original_设施平面图 == null)) {
                this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(1));
                this.Adapter.DeleteCommand.Parameters[10].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[10].Value = ((string)(Original_设施平面图));
            }
            if ((Original_维护费用.HasValue == true)) {
                this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(0));
                this.Adapter.DeleteCommand.Parameters[12].Value = ((double)(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(long 设施编号, string 设施名称, string 维护人员, System.Nullable<long> 电话, System.Nullable<System.DateTime> 维护时间, string 设施平面图, System.Nullable<double> 维护费用, string 维护说明) {
            this.Adapter.InsertCommand.Parameters[0].Value = ((long)(设施编号));
            if ((设施名称 == null)) {
                this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.InsertCommand.Parameters[1].Value = ((string)(设施名称));
            }
            if ((维护人员 == null)) {
                this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
            }
            else {
                this.Adapter.InsertCommand.Parameters[2].Value = ((string)(维护人员));
            }
            if ((电话.HasValue == true)) {
                this.Adapter.InsertCommand.Parameters[3].Value = ((long)(电话.Value));
            }
            else {
                this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
            }
            if ((维护时间.HasValue == true)) {
                this.Adapter.InsertCommand.Parameters[4].Value = ((System.DateTime)(维护时间.Value));
            }
            else {
                this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
            }
            if ((设施平面图