curriculum_design/SaleRecords.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/********************************************
 *			 Made by MeiZhaoRui				*
 *			 2014年04月25日 更新				*
 *******************************************/

using System;
using System.Data;
using System.Windows.Forms;
using System.Threading;

namespace curriculum_design
{
	public partial class SaleRecords : Form
	{
		DataSet ds;
		public SaleRecords()
		{
			InitializeComponent();
		}

		private void bt_find_Click(object sender, EventArgs e)
		{
			string select = string.Format("proc_select_SaleRecord_to_SaleRecords '{0}','{1}','{2}'", dtp_time.Text, tb_username.Text.Trim(), tb_SaleId.Text.Trim());
			new Thread(() =>
			{
				ds = Program.sqlManage.GetDataSet(select);
				if (ds.Tables[1].Rows.Count > 0)
				{
					Invoke(new Action(() =>
					{
						tb_username.Items.Clear();
						for (int i = 0; i < ds.Tables[1].Rows.Count; ++i)
						{
							tb_username.Items.Add(ds.Tables[1].Rows[i][0].ToString());
						}
						dataGridView1.Rows.Clear();

						ProgressForm pf = new ProgressForm();
						pf.Show();
						int n = 100 / ds.Tables[0].Rows.Count;
						pf.Step = n;
						for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)
						{
							pf.PerformStep();
							int index = this.dataGridView1.Rows.Add();
							for (int j = 0; j < ds.Tables[0].Columns.Count; ++j)
							{
								dataGridView1.Rows[index].Cells[j].Value = ds.Tables[0].Rows[i][j].ToString().Trim();
							}
						}
						pf.PauseClose();
					}));
				}
				else
					Invoke(new Action(() =>
					{
						MsgBox.ShowExclamation("当日没有记录！");
					}));
			}).Start();
		}