📄 form4.cs
字号:
this.menuItem1,
this.menuItem2,
this.menuItem3,
this.menuItem6,
this.menuItem4,
this.menuItem5});
//
// menuItem1
//
this.menuItem1.Index = 0;
this.menuItem1.OwnerDraw = true;
this.menuItem1.Text = "增加";
this.menuItem1.DrawItem += new System.Windows.Forms.DrawItemEventHandler(this.menuItem1_DrawItem);
this.menuItem1.Click += new System.EventHandler(this.menuItem1_Click);
this.menuItem1.MeasureItem += new System.Windows.Forms.MeasureItemEventHandler(this.menuItem1_MeasureItem);
//
// menuItem2
//
this.menuItem2.Index = 1;
this.menuItem2.OwnerDraw = true;
this.menuItem2.Text = "修改";
this.menuItem2.DrawItem += new System.Windows.Forms.DrawItemEventHandler(this.menuItem2_DrawItem);
this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
this.menuItem2.MeasureItem += new System.Windows.Forms.MeasureItemEventHandler(this.menuItem2_MeasureItem);
//
// menuItem3
//
this.menuItem3.Index = 2;
this.menuItem3.OwnerDraw = true;
this.menuItem3.Text = "删除";
this.menuItem3.DrawItem += new System.Windows.Forms.DrawItemEventHandler(this.menuItem3_DrawItem);
this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
this.menuItem3.MeasureItem += new System.Windows.Forms.MeasureItemEventHandler(this.menuItem3_MeasureItem);
//
// menuItem6
//
this.menuItem6.Index = 3;
this.menuItem6.OwnerDraw = true;
this.menuItem6.Text = "-";
this.menuItem6.DrawItem += new System.Windows.Forms.DrawItemEventHandler(this.menuItem6_DrawItem);
this.menuItem6.MeasureItem += new System.Windows.Forms.MeasureItemEventHandler(this.menuItem6_MeasureItem);
//
// menuItem4
//
this.menuItem4.Index = 4;
this.menuItem4.OwnerDraw = true;
this.menuItem4.Text = "查询相关";
this.menuItem4.DrawItem += new System.Windows.Forms.DrawItemEventHandler(this.menuItem4_DrawItem);
this.menuItem4.Click += new System.EventHandler(this.menuItem4_Click);
this.menuItem4.MeasureItem += new System.Windows.Forms.MeasureItemEventHandler(this.menuItem4_MeasureItem);
//
// menuItem5
//
this.menuItem5.Index = 5;
this.menuItem5.OwnerDraw = true;
this.menuItem5.Text = "退出";
this.menuItem5.DrawItem += new System.Windows.Forms.DrawItemEventHandler(this.menuItem5_DrawItem);
this.menuItem5.Click += new System.EventHandler(this.menuItem5_Click);
this.menuItem5.MeasureItem += new System.Windows.Forms.MeasureItemEventHandler(this.menuItem5_MeasureItem);
//
// button1
//
this.button1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button1.Location = new System.Drawing.Point(8, 16);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(72, 24);
this.button1.TabIndex = 0;
this.button1.Text = "查询";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button2.Location = new System.Drawing.Point(8, 232);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(72, 24);
this.button2.TabIndex = 0;
this.button2.Text = "退出";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// pictureBox1
//
this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
this.pictureBox1.Location = new System.Drawing.Point(8, 8);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(160, 40);
this.pictureBox1.TabIndex = 1;
this.pictureBox1.TabStop = false;
//
// groupBox1
//
this.groupBox1.Controls.Add(this.tabControl1);
this.groupBox1.Location = new System.Drawing.Point(8, 48);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(512, 320);
this.groupBox1.TabIndex = 2;
this.groupBox1.TabStop = false;
//
// Form4
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(528, 374);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.pictureBox1);
this.Name = "Form4";
this.Text = "进仓管理";
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
this.panel1.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.groupBox1.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
//DataConn dc=new DataConn ();
int num;
private void button1_Click(object sender, System.EventArgs e)
{
searchall a=new searchall();
a.search("select id as 进仓单代码,name as 进仓单名称,dtime as 进仓时间 ,cpid as 商品ID,cpsl as 数量 ,cpbz as 备注 from jc",this.dataGrid1);
}
private void button2_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void button3_Click(object sender, System.EventArgs e)
{
}
//menuItem1
private void menuItem1_MeasureItem(object sender, System.Windows.Forms.MeasureItemEventArgs e)
{//设置菜单项"显示名车图片"的显示区域
e.ItemHeight=25;
e.ItemWidth=85;
}
private void menuItem1_DrawItem(object sender, System.Windows.Forms.DrawItemEventArgs e)
{
//引用类库
drawmenu.drawmenu d =new drawmenu.drawmenu();
//d.DrawItem(sender,e," 增加",10.0F,10.0F);
d.Draw(sender,e," 增加",10.0F,10.0F,Color.MistyRose,Color.Black,Color.NavajoWhite,Color.DarkCyan);
//引用类库
}
//menuItem2
private void menuItem2_MeasureItem(object sender, System.Windows.Forms.MeasureItemEventArgs e)
{//设置菜单项"显示名车图片"的显示区域
e.ItemHeight=25;
e.ItemWidth=85;
}
private void menuItem2_DrawItem(object sender, System.Windows.Forms.DrawItemEventArgs e)
{
//引用类库
drawmenu.drawmenu d =new drawmenu.drawmenu();
//d.DrawItem(sender,e," 修改",10.0F,35.0F);
d.Draw(sender,e," 修改",10.0F,35.0F,Color.MistyRose,Color.Black,Color.NavajoWhite,Color.DarkCyan);
//引用类库
}
//menuItem3
private void menuItem3_MeasureItem(object sender, System.Windows.Forms.MeasureItemEventArgs e)
{//设置菜单项"显示名车图片"的显示区域
e.ItemHeight=25;
e.ItemWidth=85;
}
private void menuItem3_DrawItem(object sender, System.Windows.Forms.DrawItemEventArgs e)
{
//引用类库
drawmenu.drawmenu d =new drawmenu.drawmenu();
//d.DrawItem(sender,e," 删除",10.0F,60.0F);
d.Draw(sender,e," 删除",10.0F,60.0F,Color.MistyRose,Color.Black,Color.NavajoWhite,Color.DarkCyan);
//引用类库
}
//menuItem4
private void menuItem4_MeasureItem(object sender, System.Windows.Forms.MeasureItemEventArgs e)
{//设置菜单项"显示名车图片"的显示区域
e.ItemHeight=25;
e.ItemWidth=85;
}
private void menuItem4_DrawItem(object sender, System.Windows.Forms.DrawItemEventArgs e)
{
//引用类库
drawmenu.drawmenu d =new drawmenu.drawmenu();
//d.DrawItem(sender,e," 查询相关",10.0F,85.0F);
d.Draw(sender,e," 查询相关",10.0F,85.0F,Color.MistyRose,Color.Black,Color.NavajoWhite,Color.DarkCyan);
//引用类库
}
//menuItem6
private void menuItem6_MeasureItem(object sender, System.Windows.Forms.MeasureItemEventArgs e)
{
e.ItemHeight=1;
e.ItemWidth=85;
}
private void menuItem6_DrawItem(object sender, System.Windows.Forms.DrawItemEventArgs e)
{
Graphics g=e.Graphics;
//g.FillRectangle(new SolidBrush(Color.DarkOrange),e.Bounds.Left+30,e.Bounds.Top,75,1);
g.FillRectangle(new SolidBrush(Color.Lime),e.Bounds.Left+28,e.Bounds.Top,65,1);
g.FillRectangle(new SolidBrush(Color.NavajoWhite),e.Bounds.Left,e.Bounds.Top,23,1);
}
//menuItem5
private void menuItem5_MeasureItem(object sender, System.Windows.Forms.MeasureItemEventArgs e)
{//设置菜单项"显示名车图片"的显示区域
e.ItemHeight=25;
e.ItemWidth=85;
}
private void menuItem5_DrawItem(object sender, System.Windows.Forms.DrawItemEventArgs e)
{
//引用类库
drawmenu.drawmenu d =new drawmenu.drawmenu();
//d.DrawItem(sender,e," 返回",10.0F,110.0F);
d.Draw(sender,e," 退出",10.0F,110.0F,Color.MistyRose,Color.Black,Color.NavajoWhite,Color.DarkCyan);
//引用类库
}
private void dataGrid1_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
{
DataGrid myGrid = (DataGrid) sender;
System.Windows.Forms.DataGrid.HitTestInfo hti;
hti = myGrid.HitTest(e.X, e.Y);
//int Column=this.dataGrid1.CurrentCell.ColumnNumber;
//int Row=this.dataGrid1.CurrentCell.RowNumber;
//string myValue=this.dataGrid1[hti.Row,0].ToString();
//this.textBox1.Text=myValue;
this.textBox1.Text =this.dataGrid1[hti.Row,0].ToString();
this.textBox2.Text =this.dataGrid1[hti.Row,1].ToString();
this.textBox3.Text =this.dataGrid1[hti.Row,2].ToString();
this.textBox4.Text =this.dataGrid1[hti.Row,3].ToString();
this.textBox5.Text =this.dataGrid1[hti.Row,4].ToString();
this.textBox6.Text =this.dataGrid1[hti.Row,5].ToString();
}
private void dataGrid1_MouseLeave(object sender, System.Windows.Forms.MouseEventArgs e)
{
}
private void menuItem5_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void menuItem1_Click(object sender, System.EventArgs e)
{
num=1;
panel1.Visible=true;
this.label7.Text="增加数据";
this.textBox1.Text="";
}
private void button4_Click(object sender, System.EventArgs e)
{
panel1.Visible=false;
}
public void search()
{
searchall a=new searchall();
a.search("select id as 进仓单代码,name as 进仓单名称,dtime as 进仓时间 ,cpid as 商品ID,cpsl as 数量 ,cpbz as 备注 from jc",this.dataGrid1);
}
private void button6_Click(object sender, System.EventArgs e)
{
//panel1.Visible=false;
switch (num)
{
case 0:
case 2:
//修改纪录
if(this.textBox1.Text.Length<1|this.textBox2.Text.Length<1|this.textBox3.Text.Length<1|this.textBox4.Text.Length<1)
{
MessageBox.Show("进仓单ID,进仓单名称,进仓日期,产品数量为必填项！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
else
{
searchall a=new searchall();
a.change("UPDATE jc SET id='"+this.textBox1.Text+"',name='"+this.textBox2.Text+"',dtime='"+this.textBox3.Text+"',cpid='"+this.textBox4.Text+"',cpsl='"+this.textBox5.Text+"',cpbz='"+this.textBox6.Text+"'WHERE id='"+this.textBox1.Text+" '","jc");
search();
panel1.Visible=false;
}
break;
case 1:
//增加纪录
if(this.textBox1.Text.Length<1|this.textBox2.Text.Length<1|this.textBox3.Text.Length<1|this.textBox4.Text.Length<1)
{
MessageBox.Show("进仓单ID,进仓单名称,进仓日期,产品数量为必填项！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
else
{
searchall a=new searchall();
a.add("INSERT INTO jc(id,name,dtime,cpid,cpsl,cpbz)VALUES('"+this.textBox1.Text+"','"+this.textBox2.Text+"','"+this.textBox3.Text+"','"+this.textBox4.Text+"','"+this.textBox5.Text+"','"+this.textBox6.Text+"')");
search();
panel1.Visible=false;
}
break;
case 3:
//删除纪录
if(this.textBox1.Text.Length<1)
{
MessageBox.Show("没有填写进仓单ID！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
return;
}
else
{
searchall a=new searchall();
a.delect("DELETE FROM jc WHERE id='"+this.textBox1.Text+"'");
search();
panel1.Visible=false;
}
break;
}
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
num=2;
panel1.Visible=true;
this.textBox1.Enabled=false;
this.label7.Text="修改数据";
}
private void menuItem3_Click(object sender, System.EventArgs e)
{
num=3;
panel1.Visible=true;
this.label7.Text="删除数据";
this.textBox2.Enabled=false;
this.textBox3.Enabled=false;
this.textBox4.Enabled=false;
this.textBox5.Enabled=false;
this.textBox6.Enabled=false;
}
private void menuItem4_Click(object sender, System.EventArgs e)
{
panel1.Visible=false;
ck a=new ck();
a.MdiParent=this.MdiParent;
a.Show();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -