📄 searchfrm.cs
字号:
"S 出售",
"H 出租"});
this.g_type.Location = new System.Drawing.Point(53, 9);
this.g_type.Name = "g_type";
this.g_type.Size = new System.Drawing.Size(69, 20);
this.g_type.TabIndex = 32;
this.g_type.Text = "S 出售";
this.g_type.SelectedIndexChanged += new System.EventHandler(this.g_type_SelectedIndexChanged);
//
// label1
//
this.label1.Location = new System.Drawing.Point(18, 17);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(35, 17);
this.label1.TabIndex = 31;
this.label1.Text = "类型";
//
// order_from
//
this.order_from.Location = new System.Drawing.Point(456, 9);
this.order_from.Name = "order_from";
this.order_from.Size = new System.Drawing.Size(122, 21);
this.order_from.TabIndex = 46;
this.order_from.Text = "";
//
// label8
//
this.label8.Location = new System.Drawing.Point(412, 17);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(52, 17);
this.label8.TabIndex = 44;
this.label8.Text = "供货商";
//
// searchbtn
//
this.searchbtn.Location = new System.Drawing.Point(491, 34);
this.searchbtn.Name = "searchbtn";
this.searchbtn.Size = new System.Drawing.Size(85, 25);
this.searchbtn.TabIndex = 63;
this.searchbtn.Text = "查询";
this.searchbtn.Click += new System.EventHandler(this.searchbtn_Click);
//
// dataGrid1
//
this.dataGrid1.CaptionVisible = false;
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(34, 56);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.PreferredColumnWidth = 100;
this.dataGrid1.PreferredRowHeight = 15;
this.dataGrid1.ReadOnly = true;
this.dataGrid1.RowHeaderWidth = 20;
this.dataGrid1.Size = new System.Drawing.Size(552, 164);
this.dataGrid1.TabIndex = 64;
this.dataGrid1.CurrentCellChanged += new System.EventHandler(this.dataGrid1_CurrentCellChanged);
//
// button1
//
this.button1.Location = new System.Drawing.Point(350, 353);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(83, 25);
this.button1.TabIndex = 65;
this.button1.Text = "删除";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// goods_type
//
this.goods_type.Items.AddRange(new object[] {
"VCD",
"CD",
"DVD",
"磁带"});
this.goods_type.Location = new System.Drawing.Point(499, 250);
this.goods_type.Name = "goods_type";
this.goods_type.Size = new System.Drawing.Size(79, 20);
this.goods_type.TabIndex = 68;
this.goods_type.Text = "VCD";
//
// label16
//
this.label16.Location = new System.Drawing.Point(464, 258);
this.label16.Name = "label16";
this.label16.Size = new System.Drawing.Size(35, 18);
this.label16.TabIndex = 67;
this.label16.Text = "介质";
//
// addnumstr
//
this.addnumstr.Location = new System.Drawing.Point(528, 302);
this.addnumstr.Name = "addnumstr";
this.addnumstr.Size = new System.Drawing.Size(48, 21);
this.addnumstr.TabIndex = 69;
this.addnumstr.Text = "";
this.addnumstr.TextChanged += new System.EventHandler(this.addnumstr_TextChanged);
//
// label17
//
this.label17.Location = new System.Drawing.Point(448, 310);
this.label17.Name = "label17";
this.label17.Size = new System.Drawing.Size(70, 17);
this.label17.TabIndex = 70;
this.label17.Text = "增加库存";
//
// addbtn
//
this.addbtn.Location = new System.Drawing.Point(456, 327);
this.addbtn.Name = "addbtn";
this.addbtn.Size = new System.Drawing.Size(122, 25);
this.addbtn.TabIndex = 71;
this.addbtn.Text = "增加";
this.addbtn.Click += new System.EventHandler(this.addbtn_Click);
//
// turnback
//
this.turnback.Location = new System.Drawing.Point(175, 353);
this.turnback.Name = "turnback";
this.turnback.Size = new System.Drawing.Size(83, 25);
this.turnback.TabIndex = 72;
this.turnback.Text = "设为待退";
this.turnback.Click += new System.EventHandler(this.turnback_Click);
//
// turnin
//
this.turnin.Location = new System.Drawing.Point(263, 353);
this.turnin.Name = "turnin";
this.turnin.Size = new System.Drawing.Size(83, 25);
this.turnin.TabIndex = 73;
this.turnin.Text = "取消待退";
this.turnin.Click += new System.EventHandler(this.turnin_Click);
//
// searchFrm
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(594, 380);
this.Controls.Add(this.turnin);
this.Controls.Add(this.turnback);
this.Controls.Add(this.addbtn);
this.Controls.Add(this.label17);
this.Controls.Add(this.addnumstr);
this.Controls.Add(this.goods_type);
this.Controls.Add(this.label16);
this.Controls.Add(this.button1);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.searchbtn);
this.Controls.Add(this.cancelbtn);
this.Controls.Add(this.inputbtn);
this.Controls.Add(this.info);
this.Controls.Add(this.label15);
this.Controls.Add(this.publish);
this.Controls.Add(this.label13);
this.Controls.Add(this.author);
this.Controls.Add(this.label14);
this.Controls.Add(this.hire_price);
this.Controls.Add(this.label12);
this.Controls.Add(this.member_price);
this.Controls.Add(this.label11);
this.Controls.Add(this.goods_price);
this.Controls.Add(this.label10);
this.Controls.Add(this.order_time);
this.Controls.Add(this.label9);
this.Controls.Add(this.order_price);
this.Controls.Add(this.label7);
this.Controls.Add(this.order_num);
this.Controls.Add(this.label6);
this.Controls.Add(this.bar_code);
this.Controls.Add(this.label5);
this.Controls.Add(this.g_code);
this.Controls.Add(this.label4);
this.Controls.Add(this.g_name);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.department);
this.Controls.Add(this.g_type);
this.Controls.Add(this.label1);
this.Controls.Add(this.order_from);
this.Controls.Add(this.label8);
this.Name = "searchFrm";
this.Text = "库存查询";
this.Load += new System.EventHandler(this.searchFrm_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private static string Db_Type="";
private static string NowID="";
private static DataSet Rds=null;
private static int KCNumber=0,DTNumber=0;
private void searchbtn_Click(object sender, System.EventArgs e)
{
string GoodsType=g_type.Text;
string DepartMent=department.Text;
string BarCode=bar_code.Text;
string GoodsCode=g_code.Text;
string GoodsName=g_name.Text;
string OrderFrom=order_from.Text;
string OrderTime=order_time.Text;
Db_Type=(GoodsType+" ").Substring(0,1).Trim();
if(Db_Type=="")
{
MessageBox.Show("请选择租售类型");
}
else
{
string AddSql="";
if(BarCode!="") AddSql=" and BarCode like '%"+BarCode+"%'";
if(GoodsCode!="") AddSql+=" and GoodsCode like '%"+GoodsCode+"%'";
if(GoodsName!="") AddSql+=" and GoodsName like '%"+GoodsName+"%'";
if(OrderFrom!="") AddSql+=" and OrderFrom like '%"+OrderFrom+"%'";
if(OrderTime!="") AddSql+=" and OrderTime like '%"+OrderTime+"%'";
SqlDataAdapter sda=new SqlDataAdapter("select top 100 ID,DepartMent,GoodsName,GoodsCode,GoodsType,BarCode,OrderFrom,OrderTime,KCNum,DTNum from Goods_"+Db_Type+" where DepartMent like '%"+DepartMent+"%' "+AddSql+" Order by ID desc",FPara.connStr);
DataSet ds=new DataSet();
sda.Fill(ds,"search");
dataGrid1.DataSource=ds.Tables["search"].DefaultView;
Rds=ds;
dataGrid1.SetDataBinding(ds, "search");
}
}
private void dataGrid1_CurrentCellChanged(object sender,System.EventArgs e)
{
NowID=dataGrid1[dataGrid1.CurrentCell.RowNumber,0].ToString().Trim();
if(Db_Type!="")
{
SqlDataReader sdr=FPara.SqlReader("select top 1 * from Goods_"+Db_Type+" where ID="+NowID,FPara.connStr);
if(sdr!=null)
{
if(sdr.Read())
{
department.Text=sdr["Department"].ToString();
g_name.Text=sdr["GoodsName"].ToString();
g_code.Text=sdr["GoodsCode"].ToString();
goods_type.Text=sdr["GoodsType"].ToString();
order_num.Text=sdr["OrderNum"].ToString();
order_price.Text=sdr["OrderPrice"].ToString();
bar_code.Text=sdr["BarCode"].ToString();
order_from.Text=sdr["OrderFrom"].ToString();
order_time.Text=sdr["OrderTime"].ToString();
goods_price.Text=sdr["GoodsPrice"].ToString();
member_price.Text=sdr["MemberPrice"].ToString();
hire_price.Text=sdr["HirePrice"].ToString();
author.Text=sdr["Author"].ToString();
publish.Text=sdr["Publish"].ToString();
info.Text=sdr["Info"].ToString();
if(sdr["KCNum"].ToString()!="")KCNumber=int.Parse(sdr["KCNum"].ToString());
if(sdr["DTNum"].ToString()!="")DTNumber=int.Parse(sdr["DTNum"].ToString());
}
sdr.Close();
}
}
}
private void g_type_SelectedIndexChanged(object sender, System.EventArgs e)
{
g_name.Text="";
g_code.Text="";
order_num.Text="";
order_price.Text="";
goods_type.Text="";
bar_code.Text="";
goods_price.Text="";
member_price.Text="";
hire_price.Text="";
author.Text="";
publish.Text="";
info.Text="";
}
private void cancelbtn_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, System.EventArgs e)
{
if((Db_Type!="")&&(NowID!=""))
{
string DelStr=FPara.SqlCmd("delete from Goods_"+Db_Type+" where ID="+NowID,FPara.connStr);
if(DelStr!=null)
{
MessageBox.Show("操作失败，请联系管理员");
}
else{
MessageBox.Show("该数据已删除");
}
}
}
private void inputbtn_Click(object sender, System.EventArgs e)
{
if((Db_Type!="")&&(NowID!=""))
{
int HirePriceNum=0;
if(hire_price.Text!="")
{
try
{
HirePriceNum=int.Parse(hire_price.Text.ToString());
}
catch(Exception ex){}
}
string DelStr=FPara.SqlCmd("update Goods_"+Db_Type+" set GoodsName='"+g_name.Text+"',GoodsCode='"+g_code.Text+"',GoodsType='"+goods_type.Text+"',OrderNum="+order_num.Text+",OrderPrice="+order_price.Text+",BarCode='"+bar_code.Text+"',OrderFrom='"+order_from.Text+"',OrderTime='"+order_time.Text+"',GoodsPrice="+goods_price.Text+",MemberPrice="+member_price.Text+",HirePrice="+HirePriceNum+",Author='"+author.Text+"',Publish='"+publish.Text+"',Info='"+info.Text+"' where ID="+NowID,FPara.connStr);
if(DelStr!=null)
{
MessageBox.Show("操作失败，请检查所输入的信息"+DelStr);
}
else
{
MessageBox.Show("修改成功");
}
}
}
private void turnback_Click(object sender, System.EventArgs e)
{
string TurnBackStr=FPara.SqlCmd("update Goods_"+Db_Type+" set KCNum=0,DTNum="+(KCNumber+DTNumber)+" where ID="+NowID,FPara.connStr);
if(TurnBackStr==null)
{
MessageBox.Show("已经改为“待退”");
}
else{
MessageBox.Show("修改出错，库存没有修改，请联系管理员修改");
}
}
private void turnin_Click(object sender, System.EventArgs e)
{
string TurnBackStr=FPara.SqlCmd("update Goods_"+Db_Type+" set DTNum=0,KCNum="+(KCNumber+DTNumber)+" where ID="+NowID,FPara.connStr);
if(TurnBackStr==null)
{
MessageBox.Show("待退取消");
}
else
{
MessageBox.Show("修改出错，库存没有修改，请联系管理员修改");
}
}
private void addbtn_Click(object sender, System.EventArgs e)
{
int AddNumber=0;
try
{
AddNumber=int.Parse(addnumstr.Text);
if(AddNumber>0){
string TurnBackStr=FPara.SqlCmd("update Goods_"+Db_Type+" set KCNum="+(KCNumber+AddNumber)+",OrderNum="+(int.Parse(order_num.Text.ToString())+AddNumber)+",Info=Info+'/"+String.Format("{0:yyyy-MM-dd}",System.DateTime.Today)+"增加库存"+AddNumber+"' where ID="+NowID,FPara.connStr);
if(TurnBackStr==null)
{
MessageBox.Show("增加成功");
}
else
{
MessageBox.Show(TurnBackStr+"修改出错，库存没有修改，请联系管理员修改"+"update Goods_"+Db_Type+" set KCNum="+(KCNumber+AddNumber)+",OrderNum="+(int.Parse(order_num.Text.ToString())+AddNumber)+",Info+='/"+String.Format("{0:yyyy-MM-dd}",System.DateTime.Today)+"增加库存"+AddNumber+"' where ID="+NowID);
}
}
}
catch(Exception ex){
if(ex!=null)MessageBox.Show("增加的数量不符合");
}
}
private void searchFrm_Load(object sender, System.EventArgs e)
{
}
private void addnumstr_TextChanged(object sender, System.EventArgs e)
{
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -