crystalreport.cs

进销存管理系统软件

			this.sqlConnection1.ConnectionString = "workstation id=SERVER;packet size=4096;integrated security=SSPI;initial catalog=j" +
				"xcbook;persist security info=False";
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT 货号, 条码, 拼音编码, 品名, 规格, 单位, 产地, 类别, 进货价, 销售价1, 销售价2, 最低售价 FROM 商品清单";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = "INSERT INTO 商品清单(货号, 条码, 拼音编码, 品名, 规格, 单位, 产地, 类别, 进货价, 销售价1, 销售价2, 最低售价) VALUES " +
				"(@货号, @条码, @拼音编码, @品名, @规格, @单位, @产地, @类别, @进货价, @销售价1, @销售价2, @最低售价); SELECT 货号" +
				", 条码, 拼音编码, 品名, 规格, 单位, 产地, 类别, 进货价, 销售价1, 销售价2, 最低售价 FROM 商品清单 WHERE (货号 = @货号)" +
				"";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@货号", System.Data.SqlDbType.VarChar, 14, "货号"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@条码", System.Data.SqlDbType.VarChar, 14, "条码"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼音编码", System.Data.SqlDbType.VarChar, 40, "拼音编码"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@品名", System.Data.SqlDbType.VarChar, 80, "品名"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@规格", System.Data.SqlDbType.VarChar, 40, "规格"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位", System.Data.SqlDbType.VarChar, 6, "单位"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@产地", System.Data.SqlDbType.VarChar, 50, "产地"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类别", System.Data.SqlDbType.VarChar, 20, "类别"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@进货价", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "进货价", System.Data.DataRowVersion.Current, null));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@销售价1", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "销售价1", System.Data.DataRowVersion.Current, null));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@销售价2", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "销售价2", System.Data.DataRowVersion.Current, null));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@最低售价", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "最低售价", System.Data.DataRowVersion.Current, null));
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE 商品清单 SET 货号 = @货号, 条码 = @条码, 拼音编码 = @拼音编码, 品名 = @品名, 规格 = @规格, 单位 = @单位, 产地 = @产地, 类别 = @类别, 进货价 = @进货价, 销售价1 = @销售价1, 销售价2 = @销售价2, 最低售价 = @最低售价 WHERE (货号 = @Original_货号) AND (产地 = @Original_产地 OR @Original_产地 IS NULL AND 产地 IS NULL) AND (单位 = @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) AND (销售价1 = @Original_销售价1 OR @Original_销售价1 IS NULL AND 销售价1 IS NULL) AND (销售价2 = @Original_销售价2 OR @Original_销售价2 IS NULL AND 销售价2 IS NULL); SELECT 货号, 条码, 拼音编码, 品名, 规格, 单位, 产地, 类别, 进货价, 销售价1, 销售价2, 最低售价 FROM 商品清单 WHERE (货号 = @货号)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@货号", System.Data.SqlDbType.VarChar, 14, "货号"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@条码", System.Data.SqlDbType.VarChar, 14, "条码"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼音编码", System.Data.SqlDbType.VarChar, 40, "拼音编码"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@品名", System.Data.SqlDbType.VarChar, 80, "品名"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@规格", System.Data.SqlDbType.VarChar, 40, "规格"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位", System.Data.SqlDbType.VarChar, 6, "单位"));
			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.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "进货价", System.Data.DataRowVersion.Current, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@销售价1", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "销售价1", System.Data.DataRowVersion.Current, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@销售价2", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "销售价2", System.Data.DataRowVersion.Current, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@最低售价", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "最低售价", System.Data.DataRowVersion.Current, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_货号", System.Data.SqlDbType.VarChar, 14, 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.VarChar, 6, 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, 80, 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, 40, 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.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "最低售价", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_条码", System.Data.SqlDbType.VarChar, 14, 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));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_规格", System.Data.SqlDbType.VarChar, 40, 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.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "进货价", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_销售价1", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "销售价1", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_销售价2", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "销售价2", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM 商品清单 WHERE (货号 = @Original_货号) AND (产地 = @Original_产地 OR @Original_产地 IS NULL AND 产地 IS NULL) AND (单位 = @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) AND (销售价1 = @Original_销售价1 OR @Original_销售价1 IS NULL AND 销售价1 IS NULL) AND (销售价2 = @Original_销售价2 OR @Original_销售价2 IS NULL AND 销售价2 IS NULL)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_货号", System.Data.SqlDbType.VarChar, 14, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "货号", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.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.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位", System.Data.SqlDbType.VarChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_品名", System.Data.SqlDbType.VarChar, 80, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "品名", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_拼音编码", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "拼音编码", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_最低售价", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "最低售价", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_条码", System.Data.SqlDbType.VarChar, 14, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "条码", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.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));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_规格", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "规格", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_进货价", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "进货价", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_销售价1", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "销售价1", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_销售价2", System.Data.SqlDbType.Decimal, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(28)), ((System.Byte)(6)), "销售价2", System.Data.DataRowVersion.Original, null));
			// 
			// dataset21
			// 
			this.dataset21.DataSetName = "Dataset2";
			this.dataset21.Locale = new System.Globalization.CultureInfo("en-US");
			// 
			// CrystalReport
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(728, 363);
			this.Controls.Add(this.crystalReportViewer1);
			this.Name = "CrystalReport";
			this.Text = "打印预览";
			this.Load += new System.EventHandler(this.CrystalReport_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataset21)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void CrystalReport_Load(object sender, System.EventArgs e)
		{
			sqlDataAdapter1.Fill(this.dataset21);
			CrystalReport1 rpt=new CrystalReport1();
			rpt.SetDataSource(this.dataset21.Tables[0]);
			crystalReportViewer1.ReportSource=rpt;
		}
	}
}