debtbillsearchform.cs

超市管理系统的完整版文档

			}

			if(enddate != "")
			{
			    sql = sql + "  and AddTime<='"+enddate+"'";
			}
			
		   //get data
         	SqlConnection conn = DBUtil.GetConnection();
			conn.Open();
			SqlCommand cmd = new SqlCommand(sql, conn);
			SqlDataReader reader = cmd.ExecuteReader();

			clearDebtList();
            
           //show data to grid
			System.Data.DataRow datarow;
			while (reader.Read())
			{
				datarow = m_debtListDataTable.NewRow();
				datarow[0] = reader["SaleNo"];
				datarow[1] = reader["GuestName"];
				datarow[2] = reader["LackMoney"];
				if( System.Convert.ToInt32(reader["ClearFlag"].ToString()) == 1)
				{
					datarow[3] = "已结算";
				}
				else{
				    datarow[3] = "未结算";
				}
				datarow[4] = reader["UserName"];
				datarow[5] = reader["Addtime"];
				datarow[6] = reader["ClearTime"];

				m_debtListDataTable.Rows.Add(datarow);
			}
			
			//close data conn
			conn.Close();


			if(m_debtListDataTable.Rows.Count > 0 )
			{
				string saleno = m_debtListDataTable.Rows[0][0].ToString();
				string status = m_debtListDataTable.Rows[0][3].ToString();
				string guestName = m_debtListDataTable.Rows[0][1].ToString();
				BillInfoQuery(saleno, status , guestName);
			}
		
		}



		private void BillInfoQuery( string saleno, string status,string guestname)
		{  
            string sql ="select * from SaleRecord,Goods  where SaleRecord.GoodsID=Goods.GoodsID and SaleNo='"+saleno+"'";	

			SqlConnection conn = DBUtil.GetConnection();
			conn.Open();
			SqlCommand cmd = new SqlCommand(sql, conn);
			SqlDataReader reader = cmd.ExecuteReader();

			clearDebtInfo();

			System.Data.DataRow datarow;
			while (reader.Read())
			{
				datarow = m_debtInfoDataTable.NewRow();
				datarow[0] = reader["GoodsCode"];
				datarow[1] = reader["GoodsName"];
				datarow[2] = reader["SalePrice"];
				datarow[3] = reader["SaleNumber"];;
				datarow[4] = reader["Unit"];
			    double tm = System.Convert.ToDouble(reader["SalePrice"].ToString()) *System.Convert.ToDouble(reader["SaleNumber"].ToString());
				datarow[5] = tm.ToString();
			
				m_debtInfoDataTable.Rows.Add(datarow);
			}
			
			conn.Close();
		    m_debtGrid.CaptionText = "欠单信息: 欠单号:" + saleno + " 客户:" + guestname + "  状态:" + status;
		}

		private void DebtBillSearchForm_Load(object sender, System.EventArgs e)
		{

            DebtBillQuery("","","",true);
		      
		}

		private void m_debtListGrid_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
		{
           
		
		}

		private void m_debtListGrid_CurrentCellChanged(object sender, System.EventArgs e)
		{
			int curidx = m_debtListGrid.CurrentRowIndex;
			if(pre_row_pos != curidx)
			{
				DataView billDataView;
				billDataView = (DataView) m_debtListGrid.DataSource;
				string saleno = billDataView.Table.Rows[curidx][0].ToString();
				string status = billDataView.Table.Rows[curidx][3].ToString();
				string guestname = billDataView.Table.Rows[curidx][1].ToString();
             
                pre_row_pos = curidx;
			    BillInfoQuery(saleno, status , guestname);
						
			}
		}

		private void m_allDebt_Click(object sender, System.EventArgs e)
		{
		    DebtBillQuery("","","",true);
		}

		private void m_query_Click(object sender, System.EventArgs e)
		{   
          
              Query();
		}


		private void Query()
		{
			string guestname, starttime,endtime;
			bool clearflag = false;
			if(this.m_chkGuestName.Checked)
			{
				guestname = m_guestName.Text.Replace("'","");
				if(guestname=="")
				{
					MessageBox.Show("客户名不能为空！");
					return;
				
				}
			}
			else
			{
				guestname = "";
			}

			if(this.m_chkStartTime.Checked)
			{
				starttime = m_startTime.Text.Replace("'","");
				if(starttime=="")
				{
					MessageBox.Show("起始时间不能为空！");
					return;
				
				}
				try
				{
					System.Convert.ToDateTime(starttime).ToString("s");
				
				}
				catch(System.FormatException ex)
				{
				
					MessageBox.Show("起始时间格式不正确！");
					return;
				   
				}


			}
			else
			{
				starttime = "";
			}
			if(this.m_chkEndDate.Checked)
			{
				endtime = m_endTime.Text.Replace("'","");
				if(endtime=="")
				{
					MessageBox.Show("结束时间不能为空！");
					return;
				}
				try
				{
					System.Convert.ToDateTime(endtime).ToString("s");
				
				}
				catch(System.FormatException ex)
				{			
					MessageBox.Show("结束时间格式不正确！");
					return;				   
				}

			}
			else
			{
				endtime = "";
			}

			if(this.m_chkbox.Checked)
			{
				clearflag = true;
			}
           
		 
			DebtBillQuery(guestname,starttime,endtime,clearflag);
		
		}
		private void m_chkGuestName_CheckedChanged(object sender, System.EventArgs e)
		{
			if(this.m_chkGuestName.Checked)
			{
			     this.m_guestName.Enabled = true;
			}
			else
			{
			     this.m_guestName.Enabled = false;
			}
		}

		private void m_chkStartTime_CheckedChanged(object sender, System.EventArgs e)
		{
			if(m_chkStartTime.Checked)
			{
			   this.m_startTime.Enabled = true;
			}
			else{
			   this.m_startTime.Enabled = false;
			}
		}

		private void m_chkEndDate_CheckedChanged(object sender, System.EventArgs e)
		{
			if (m_chkEndDate.Checked)
			{
				this.m_endTime.Enabled = true;
			}
			else{
			   this.m_endTime.Enabled = false;
			}
		}

		private void m_clearDebt_Click(object sender, System.EventArgs e)
		{
				int curidx = m_debtListGrid.CurrentRowIndex;
				DataView billDataView;
				billDataView = (DataView) m_debtListGrid.DataSource;

				if( billDataView.Table.Rows.Count >0)
				{ 
					string saleno = billDataView.Table.Rows[curidx][0].ToString();
					string stuts =  billDataView.Table.Rows[curidx][3].ToString();
					if(stuts =="已结算")
					{
					   MessageBox.Show("当前欠单已结算！");
						return;
					
					}
					if(DialogResult.Yes==MessageBox.Show(this, "确定结算欠单:"+saleno, "提醒", MessageBoxButtons.YesNo))
					{   

						SqlConnection conn = DBUtil.GetConnection();
						SqlCommand command = new SqlCommand ("",conn);
						command.Connection.Open();

						string sql = "update DebtBill set ClearFlag='1', ClearTime=GetDate(), OperatorID="+employeeId.ToString()+  
							" where saleno='" + saleno + "'" ;

						command.CommandText = sql;
						int row2 = command.ExecuteNonQuery(); 
						conn.Close();
					}
				}
				else{
				   MessageBox.Show("当前无欠单");
					return;
				}
			Query();
		}

		private void clearDebtList()
		{	
			if(m_debtListDataTable.Rows.Count > 0)
			{
			   m_debtListDataTable.Rows.Clear();
			}
             clearDebtInfo();

		}
		private void clearDebtInfo()
		{
			if(m_debtInfoDataTable.Rows.Count > 0)
			{
				m_debtInfoDataTable.Rows.Clear();
			}	
		}

		private void m_startTime_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
		{
			if (e.KeyChar != 13 && e.KeyChar != 8&& e.KeyChar !='-' && e.KeyChar!=22 && (e.KeyChar < '0'|| e.KeyChar > '9'))
			{				
				e.Handled = true;
			}
		}

		private void m_endTime_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
		{
			if (e.KeyChar != 13 && e.KeyChar != 8&& e.KeyChar !='-' && e.KeyChar!=22 && (e.KeyChar < '0'|| e.KeyChar > '9'))
			{				
				e.Handled = true;
			}
		}
		
	}
}