frmmoney.cs

采用C#和SQL Server 2000开发 功能比较全面的图书馆管理系统

			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@应罚金额", System.Data.SqlDbType.Money, 8, "应罚金额"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@实收金额", System.Data.SqlDbType.Money, 8, "实收金额"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否交款", System.Data.SqlDbType.Bit, 1, "是否交款"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"));
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT 罚款编号, 期刊编号, 读者编号, 罚款日期, 应罚金额, 实收金额, 是否交款, 备注 FROM 期刊罚款";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE 期刊罚款 SET 罚款编号 = @罚款编号, 期刊编号 = @期刊编号, 读者编号 = @读者编号, 罚款日期 = @罚款日期, 应罚金额 = @应罚金额, 实收金额 = @实收金额, 是否交款 = @是否交款, 备注 = @备注 WHERE (罚款编号 = @Original_罚款编号) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (实收金额 = @Original_实收金额 OR @Original_实收金额 IS NULL AND 实收金额 IS NULL) AND (应罚金额 = @Original_应罚金额 OR @Original_应罚金额 IS NULL AND 应罚金额 IS NULL) AND (是否交款 = @Original_是否交款 OR @Original_是否交款 IS NULL AND 是否交款 IS NULL) AND (期刊编号 = @Original_期刊编号 OR @Original_期刊编号 IS NULL AND 期刊编号 IS NULL) AND (罚款日期 = @Original_罚款日期 OR @Original_罚款日期 IS NULL AND 罚款日期 IS NULL) AND (读者编号 = @Original_读者编号 OR @Original_读者编号 IS NULL AND 读者编号 IS NULL); SELECT 罚款编号, 期刊编号, 读者编号, 罚款日期, 应罚金额, 实收金额, 是否交款, 备注 FROM 期刊罚款 WHERE (罚款编号 = @罚款编号)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@罚款编号", System.Data.SqlDbType.Int, 4, "罚款编号"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@期刊编号", System.Data.SqlDbType.VarChar, 50, "期刊编号"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@读者编号", System.Data.SqlDbType.VarChar, 20, "读者编号"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@罚款日期", System.Data.SqlDbType.DateTime, 4, "罚款日期"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@应罚金额", System.Data.SqlDbType.Money, 8, "应罚金额"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@实收金额", System.Data.SqlDbType.Money, 8, "实收金额"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否交款", System.Data.SqlDbType.Bit, 1, "是否交款"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_罚款编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "罚款编号", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "备注", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_实收金额", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "实收金额", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_应罚金额", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "应罚金额", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否交款", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否交款", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_期刊编号", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "期刊编号", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_罚款日期", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "罚款日期", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_读者编号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "读者编号", System.Data.DataRowVersion.Original, null));
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// frmMoney
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
			this.ClientSize = new System.Drawing.Size(506, 294);
			this.Controls.Add(this.GroupBox1);
			this.Name = "frmMoney";
			this.Controls.SetChildIndex(this.dgdList, 0);
			this.Controls.SetChildIndex(this.GroupBox1, 0);
			((System.ComponentModel.ISupportInitialize)(this.dgdList)).EndInit();
			this.GroupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		public override void Prepare()
		{
			this.Text = "图书罚款";
			Label1.Text = "读者编号";
			Label2.Text = "读者条码";
			Label3.Text = "图书编号";
			ToolBar1.Visible = false;
			dgdList.Dock = DockStyle.Fill;
		}

		public override void LoadData()
		{			
			string strFilter;
			if ( txbOne.Text.Trim().Length == 0 )
			{
				if ( txbTwo.Text.Trim().Length == 0 )
				{
					if ( txbThree.Text.Trim().Length == 0 )
						strFilter = "";
					else
					{
						strFilter = "where 图书编号 like '";
						strFilter += txbThree.Text.Trim() + "%'";
					}
				}
				else
				{
					strFilter = "where 读者条码 like '";
					strFilter += txbTwo.Text.Trim() + "%'";
					if ( txbThree.Text.Trim().Length != 0 )
						strFilter += " and 图书编号 like '" + txbThree.Text.Trim() + "%'";
				}
			}
			else
			{
				strFilter = "where 读者编号 like '" + txbOne.Text.Trim() + "%'";
				if ( txbTwo.Text.Trim().Length != 0 )
				{
					strFilter += " and 读者条码 like '" + txbTwo.Text.Trim() + "%'";
					if ( txbThree.Text.Trim().Length != 0 )
						strFilter += " and 图书编号 like '" + txbThree.Text.Trim() + "%'";
				}
				else
				{
					if ( txbThree.Text.Trim().Length != 0 )
						strFilter += " and 图书编号 like '" + txbThree.Text.Trim() + "%'";
				}						
			}
			if ( strFilter.Length == 0 )
				strFilter = " where 是否交款=0 ";
			else
				strFilter = " and 是否交款=0 ";
			dataSet11.Clear();
			sqlConnection1.ConnectionString = DataBase.sConn;
			sqlDataAdapter1.SelectCommand.CommandText = "select * from 图书罚款 " + strFilter;
			sqlDataAdapter1.Fill( dataSet11 );
			dtData = dataSet11.Tables[ "图书罚款" ];
			bmData = this.BindingContext[ dataSet11, "图书罚款" ];
			if ( bmData.Count != 0 )
				bmData.Position = 0;
		}

		public override void SetDataGrid()
		{
			LoadData();
			DataGridTableStyle ts = new DataGridTableStyle();
			DataGridTextBoxColumn aCol;
			int numCols = dtData.Columns.Count;
			for ( int i = 0; i < numCols; i ++ )
			{
				aCol = new DataGridTextBoxColumn();
				aCol.MappingName = dtData.Columns[ i ].ColumnName;
				aCol.HeaderText = dtData.Columns[ i ].ColumnName;
				aCol.NullText = "";
				aCol.ReadOnly = true;
				ts.GridColumnStyles.Add( aCol );
			}
			ts.AlternatingBackColor = Color.LightGray;
			ts.AllowSorting = false;
			ts.MappingName = dtData.TableName;
			dgdList.TableStyles.Clear();
			dgdList.TableStyles.Add( ts );
			DataView dv = dtData.DefaultView;
			dv.AllowNew = false;
			dv.AllowDelete = false;
			dgdList.DataSource = dv;
			bmData = this.BindingContext[ dataSet11, "图书罚款" ];
			lblCount.Text = "记录数:" + dtData.Rows.Count.ToString();
		}

		private void btnSubmit_Click(object sender, System.EventArgs e)
		{
			DataBase db = new DataBase();
			// 更新图书惩罚表
			string strSQL = "";
			strSQL = "update 图书罚款 set 是否交款=1 where 罚款编号=";
			strSQL += dtData.Rows[ bmData.Position ][ "罚款编号" ].ToString().Trim();
			db.RunDelOrInsSQL( strSQL );
			db.Dispose();
			LoadData();
			dgdList.DataSource = dtData.DefaultView;
		}
	}
}