www.pudn.com > GoodsReportManage.rar > GoodsFind.cs

using System; 
using System.Collections.Generic; 
using System.ComponentModel; 
using System.Data; 
using System.Drawing; 
using System.Text; 
using System.Windows.Forms; 
 
using GoodsReportManage.ItemClass;  //添加引用 
 
namespace GoodsReportManage.Goods 
{ 
    public partial class GoodsFind : Form 
    { 
        public GoodsFind() 
        { 
            InitializeComponent(); 
        } 
 
        private void GoodsFind_Load(object sender, EventArgs e) 
        { 
 
        } 
 
        SqlBaseClass G_SqlClass = new SqlBaseClass(); 
 
        /// 
 
        /// 在控件中填充选中的DataGridView控件的数据 
        /// 
 
        private void FillControls() 
        { 
            try 
            { 
                if (this.radioButton3.Checked) 
                { 
                    this.labGoodsID.Text = this.dgvGoodsFindInfo[0, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labGoodsName.Text = this.dgvGoodsFindInfo[1, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labGoodsSpec.Text = this.dgvGoodsFindInfo[8, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labNum.Text = this.dgvGoodsFindInfo[4, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labRMoney.Text = this.dgvGoodsFindInfo[10, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labGoodsPrice.Text = this.dgvGoodsFindInfo[6, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labHasPay.Text = this.dgvGoodsFindInfo[11, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                } 
                if (this.radioButton4.Checked) 
                { 
                    this.labGoodsID.Text = this.dgvGoodsFindInfo[1, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labGoodsName.Text = this.dgvGoodsFindInfo[2, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labGoodsSpec.Text = this.dgvGoodsFindInfo[6, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labNum.Text = this.dgvGoodsFindInfo[4, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labRMoney.Text = this.dgvGoodsFindInfo[8, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labGoodsPrice.Text = this.dgvGoodsFindInfo[7, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                    this.labHasPay.Text = this.dgvGoodsFindInfo[9, this.dgvGoodsFindInfo.CurrentCell.RowIndex].Value.ToString(); 
                } 
            } 
            catch { } 
        } 
 
        private void btnSfind_Click(object sender, EventArgs e) 
        { 
            string P_Str_cmdtxt = String.Empty; 
            string P_Str_select = String.Empty; 
            if (this.radioButton3.Checked) 
            { 
                P_Str_select = "GoodsID LIKE '%"+this.txtGoodsID.Text +"%' AND GoodsName LIKE '%"+this.txtGoodsName.Text+"%'"; 
                P_Str_select += " AND GoodsTime BETWEEN '"+this.dtStartTime.Value.ToString("yyyy-MM-dd")+"' AND "; 
                P_Str_select += "'"+this.dtEndTime.Value.ToString("yyyy-MM-dd")+"'"; 
                P_Str_cmdtxt = "SELECT GoodsID as 商品ID,GoodsName as 商品名称,GoodsTime as 进货日期,CompanyName as 供应商名称"; 
                P_Str_cmdtxt += ",GoodsNum as 进货数量,GoodsUnit as 商品单位,GoodsPrice as 商品进价,DepotName as 所属仓库,GoodsSpec as 商品规格"; 
                P_Str_cmdtxt += ",SellPrice as 销售价格,NeedPay as 应付金额,HasPay as 实付金额,Remark as 备注 FROM tb_Goods"; 
                P_Str_cmdtxt += " WHERE "+P_Str_select+""; 
                this.dgvGoodsFindInfo.DataSource = G_SqlClass.GetDs(P_Str_cmdtxt).Tables[0]; 
            } 
            if (this.radioButton4.Checked) 
            { 
                P_Str_select = "GoodsID LIKE '%" + this.txtGoodsID.Text + "%' AND ReGoodsName LIKE '%" + this.txtGoodsName.Text + "%'"; 
                P_Str_select += " AND ReGoodsTime BETWEEN '" + this.dtStartTime.Value.ToString("yyyy-MM-dd") + "' AND "; 
                P_Str_select += "'" + this.dtEndTime.Value.ToString("yyyy-MM-dd") + "'"; 
                P_Str_cmdtxt = "SELECT ReGoodsID as 退货ID,GoodsID as 商品ID,ReGoodsName as 商品名称,ReGoodsTime as 退货日期,ReGoodsNum as 退货数量"; 
                P_Str_cmdtxt += ",ReGoodsUnit as 商品单位,ReGoodsSpec as 商品规格,ReGoodsPrice as 进货价格,NeedPay as 应收金额,HasPay as 实收金额,ReGoodsResult as 退货原因"; 
                P_Str_cmdtxt += " FROM tb_ReGoods WHERE "+P_Str_select+""; 
                this.dgvGoodsFindInfo.DataSource = G_SqlClass.GetDs(P_Str_cmdtxt).Tables[0]; 
            } 
        } 
 
        private void btnCfind_Click(object sender, EventArgs e) 
        { 
            this.txtGoodsName.Text = ""; 
            this.txtGoodsID.Text = ""; 
 
            this.dtEndTime.Value = DateTime.Now; 
            this.dtStartTime.Value = DateTime.Now; 
        } 
 
        private void dgvGoodsFindInfo_CellClick(object sender, DataGridViewCellEventArgs e) 
        { 
            FillControls(); 
        } 
 
        private void radioButton3_CheckedChanged(object sender, EventArgs e) 
        { 
            this.label10.Text = "应付金额"; 
            this.label15.Text = "实付金额"; 
        } 
 
        private void radioButton4_CheckedChanged(object sender, EventArgs e) 
        { 
            this.label10.Text = "应收金额"; 
            this.label15.Text = "实收金额"; 
        } 
    } 
}