qianding.cs

进销存管理系统软件

			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(48, 16);
			this.label6.TabIndex = 5;
			this.label6.Text = "总金额:";
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(88, 24);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(48, 16);
			this.label5.TabIndex = 4;
			this.label5.Text = "总金额:";
			// 
			// textBox4
			// 
			this.textBox4.Location = new System.Drawing.Point(560, 16);
			this.textBox4.Name = "textBox4";
			this.textBox4.TabIndex = 3;
			this.textBox4.Text = "";
			// 
			// textBox3
			// 
			this.textBox3.Location = new System.Drawing.Point(306, 50);
			this.textBox3.Name = "textBox3";
			this.textBox3.TabIndex = 2;
			this.textBox3.Text = "textBox3";
			// 
			// textBox2
			// 
			this.textBox2.Location = new System.Drawing.Point(336, 16);
			this.textBox2.Name = "textBox2";
			this.textBox2.TabIndex = 1;
			this.textBox2.Text = "";
			// 
			// tatol_sum
			// 
			this.tatol_sum.Location = new System.Drawing.Point(144, 16);
			this.tatol_sum.Name = "tatol_sum";
			this.tatol_sum.TabIndex = 0;
			this.tatol_sum.Text = "";
			// 
			// qianding
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(712, 316);
			this.Controls.Add(this.groupBox2);
			this.Controls.Add(this.dataGrid1);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.toolBar1);
			this.Name = "qianding";
			this.Text = "进货单";
			this.Load += new System.EventHandler(this.qianding_Load);
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.groupBox2.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion


		private void DataGridStateControl()
		{
		 DataTable newTable=new DataTable();
		newTable.Columns.Add("货号",typeof(string));
        newTable.Columns.Add("数量",typeof(decimal));
        newTable.Columns.Add("单价",typeof(decimal));
		newTable.Columns.Add("品名",typeof(string));
        newTable.Columns.Add("单位",typeof(string));
        newTable.Columns.Add("金额",typeof(decimal),"数量*单价");
       newTable.Columns.Add("税率",typeof(decimal));
        newTable.Columns.Add("不含税率",typeof(decimal),"金额/1.17");
        newTable.Columns.Add("税额",typeof(decimal),"金额-不含税率");

       
        this.dataGrid1.DataSource=newTable;
       newTable.Rows.Add(newTable.NewRow());

		DataGridTableStyle ts=new DataGridTableStyle();
		DataGridTextBoxColumn asBoxColumn;
		ts.AllowSorting=false;
        ts.AlternatingBackColor=Color.LightGray;
        ts.MappingName=newTable.TableName;
        int nows=newTable.Columns.Count;
			for (int i=1;i<nows;i++)
			{
		asBoxColumn = new DataGridTextBoxColumn();
        asBoxColumn.MappingName=newTable.Columns[i].ColumnName;
        asBoxColumn.HeaderText=newTable.Columns[i].ColumnName;
        asBoxColumn.NullText="";
         asBoxColumn.Format="n";
          ts.GridColumnStyles.Add(asBoxColumn);
			}

        this.dataGrid1.TableStyles.Add(ts);


		}

		private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			if (e.Button.ToolTipText=="保存")
			{
				this.savedata();
			}
			if (e.Button.ToolTipText=="除去")
			{
			}
			if (e.Button.ToolTipText=="打印")
			{
				this.clickedPrintIcon();

			}
		}

		private void clickedPrintIcon()
		{
			CrystalReport dy=new CrystalReport();
			dy.ShowDialog();
		}

		private void qianding_Load(object sender, System.EventArgs e)
		{
			this.textday.Text=System.DateTime.Today.ToShortDateString();
			this.people.Text=login.struser;
			string sqlname="select distinct 姓名 from 用户清单";
			DataTable tempdatatable=link.selectdata(sqlname);
			for (int i=0;i<tempdatatable.Rows.Count;i++)
			{
				this.txt_people.Items.Add(tempdatatable.Rows[i][0]);
				this.txt_people.SelectedIndex=0;
			}
		}


		private void gonghuo_cmd(object sender,System.EventArgs e)
		{
			htadd_ht ht=new htadd_ht(false);
			ht.takedatareadonyl(true);
			ht.ShowDialog();
			setTextData();
			DataGridStateControl();
		}
		private void setTextData()
		{
			this.gonghuo.IntegralHeight=false;
			this.gonghuo.DroppedDown = false;
			this.gonghuo.Items[0]=inputdataempty[0];
	        this.gonghuo.SelectedIndex=0;
			this.txt_gonghuo.Text=inputdataempty[1];
			this.gonghuo.IntegralHeight = true;
		}
			
			
		private  void setwardata()
			{
          dataGrid1[dataGrid1.CurrentCell.RowNumber,0]=inputdataemptyy[0];
          dataGrid1[dataGrid1.CurrentCell.RowNumber,4]=inputdataemptyy[1];
		  dataGrid1[dataGrid1.CurrentCell.RowNumber,5]=inputdataemptyy[2];


			}
	
		private void gonghuo_return(object sendet,System.Windows.Forms.KeyEventArgs e)
		{
          this.txt_gonghuo.Text="";
          string strsearch=this.txt_gonghuo.Text;
          string sqlname="select * from 供货商号,名称 from 供货商清单 where 名称='"+strsearch+"'";
          DataTable tempDataTable=this.link.selectdata(sqlname);
			if(tempDataTable.Rows.Count>0)
			{
				inputdataempty[0]=tempDataTable.Rows[0][0].ToString().Trim();
				inputdataempty[1]=tempDataTable.Rows[1][0].ToString().Trim();
                this.setTextData();
			}
			
		}
		private void gonghuo_onclick(object sender,System.EventArgs e)

		{
			if (this.dataGrid1.CurrentCell.ColumnNumber==0)
			{
				htadd_ht ht=new htadd_ht(false);
				ht.ShowDialog();
				this.setwardata();

			}


		}

		private void dataGrid1_CurrentCellChanged(object sender, System.EventArgs e)
		{
		
         this.sum();
		}

		private void sum()
		{
         
		int introwsum=this.dataGrid1.CurrentCell.RowNumber;
		 string shuliang=this.dataGrid1[introwsum,1].ToString();
         string price=this.dataGrid1[introwsum,2].ToString();
         string totalprice=this.dataGrid1[introwsum,5].ToString();
			if(shuliang!=""&& price!="" && totalprice!="")
			{
		this.dataGrid1.CurrentCell=new DataGridCell(introwsum+1,0);
			}
			decimal inttotalcount=0;


		//object  obj = newTable.Compute("SUM (金额)","");
	//		if (obj.GetType().ToString()!="System.DBNull")
	//		{
	//			inttotalcount=(decimal)this.newTable.Compute("sum(金额)","");
		//	}
     
          this.tatol_sum.Text=inttotalcount.ToString("N");

		}

      

		private void savedata()
		{
			try
			{
               string sql="delect 进货单明细";
				this.link.UpdateDataBase(sql);
				sql="delect 进货单";
				this.link.UpdateDataBase(sql);
				int intmaxStocknumber=0;
				sql="select * from 进货单";
				DataTable intstocknumber=this.link.selectdata(sql);
				for(int i=1;i<intstocknumber.Rows.Count;i++)

				{
					if (intmaxStocknumber<System.Int32.Parse(intstocknumber.Rows[i][0].ToString()))
					{

						intmaxStocknumber=System.Int32.Parse(intstocknumber.Rows[i][0].ToString());
					}
				}


				for(int row=0;row<this.newTable.Rows.Count;row++)

				{
					if(this.newTable.Rows[row][0].ToString()=="")
					{
						sql="delect * from 进货单 where 编号='"+intmaxStocknumber+"'";
						this.link.UpdateDataBase(sql);
						break;


					}
					else
					{
						intmaxStocknumber++;
						string id=this.gonghuo.Items[0].ToString().Trim();
						string opname=this.txt_gonghuo.Text.Trim();
						string sysname=this.txt_gonghuo.SelectedText.Trim();
						string textday=this.textday.Text.ToString();
						string people=this.people.Text.ToString().Trim();
						string sqlname="('"+intmaxStocknumber+"','"+id+"','"+textday+"','"+people+"','"+opname+"')";
						sql="insert 进货单(编号,供货商品,进货日期,业务员,制单人) values" + sqlname;
						this.link.UpdateDataBase(sql);


					}


				}
				MessageBox.Show("数据保存成功!","信息");
			}
			catch
			{
				MessageBox.Show("数据保存失败,请确认所有信息输入完整且正确!","提示");
				return;
	
			}

			}
		

		}
}