南京本地网站,网站查询访问,怎么投诉网络平台,湖南省建设厅官方网站一、数据库的建立
这里仍使用yy_textile表 在fiber_yy数据库下创建yy_textile表 初始数据库信息
二、页面的完善
登录注册页面我就不演示了#xff0c;前几篇博文也都有介绍
shipment出库管理页面 main_page页面进行功能完善
三、代码实现
shipment出库管理页面
u…一、数据库的建立
这里仍使用yy_textile表 在fiber_yy数据库下创建yy_textile表 初始数据库信息
二、页面的完善
登录注册页面我就不演示了前几篇博文也都有介绍
shipment出库管理页面 main_page页面进行功能完善
三、代码实现
shipment出库管理页面
using System;
using System.IO;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;namespace fiber_yy
{public partial class shipment : Form{private DataSet dsall;public string constr serverCY-20190824RMES;Initial Catalogfiber_yy;User IDsa;pwdbeyond;private SqlDataAdapter mDataAdapter;public login login new login();public shipment(){InitializeComponent();try{string username login.name;MessageBox.Show(username);SqlConnection conn new SqlConnection(constr);conn new SqlConnection(constr);mDataAdapter new SqlDataAdapter(SELECT name AS 纺织品名称,number AS 纺织品品号,warp_density AS 经密度 ,weft_density AS 纬密度,warp_linear_density AS 经纱线密度,weft_linear_density AS 纬纱线密度,material AS 原料成分,square_meter_weight AS 平方米重量,width_of_cloth AS 幅宽,horse_length AS 匹长,organization AS 所用组织,stock AS 库存量 FROM yy_textile, conn);dsall new DataSet();mDataAdapter.Fill(dsall, hard);dataGridView1.DataSource dsall.Tables[hard];}catch{MessageBox.Show(读取失败请检查是否存在该织物);}}private void button1_Click(object sender, EventArgs e){try{SqlConnection conn new SqlConnection(constr);conn new SqlConnection(constr);mDataAdapter new SqlDataAdapter(SELECT name AS 纺织品名称,number AS 纺织品品号,warp_density AS 经密度 ,weft_density AS 纬密度,warp_linear_density AS 经纱线密度,weft_linear_density AS 纬纱线密度,material AS 原料成分,square_meter_weight AS 平方米重量,width_of_cloth AS 幅宽,horse_length AS 匹长,organization AS 所用组织,stock AS 库存量 FROM yy_textile, conn);dsall new DataSet();mDataAdapter.Fill(dsall, hard);dataGridView1.DataSource dsall.Tables[hard];}catch{MessageBox.Show(读取失败);}}private void button2_Click(object sender, EventArgs e)//查看织物信息{try{string number textBox1.Text;byte[] MyData new byte[0];string sql SELECT stock FROM yy_textile WHERE number number ;SqlConnection conn new SqlConnection(constr);SqlCommand cmd new SqlCommand(sql, conn);conn.Open();string account cmd.ExecuteScalar().ToString();int a int.Parse(account);//MessageBox.Show(a.ToString());if (a 100){/*SqlConnection conn1 new SqlConnection(constr);conn1.Open();SqlCommand cmd1 new SqlCommand();cmd1.Connection conn1;cmd1.CommandText select * from yy_textile where number number ;*/SqlConnection conn2 new SqlConnection(constr);conn2 new SqlConnection(constr);mDataAdapter new SqlDataAdapter(SELECT name AS 纺织品名称,number AS 纺织品品号,warp_density AS 经密度 ,weft_density AS 纬密度,warp_linear_density AS 经纱线密度,weft_linear_density AS 纬纱线密度,material AS 原料成分,square_meter_weight AS 平方米重量,width_of_cloth AS 幅宽,horse_length AS 匹长,organization AS 所用组织,stock AS 库存量 FROM yy_textile where number number , conn);dsall new DataSet();mDataAdapter.Fill(dsall, hard);dataGridView1.DataSource dsall.Tables[hard];SqlConnection conn1 new SqlConnection(constr);conn1.Open();SqlCommand cmd1 new SqlCommand();cmd1.Connection conn1;cmd1.CommandText select * from yy_textile where number number ;SqlDataReader sdr cmd1.ExecuteReader();sdr.Read();object o sdr[picture];MyData (byte[])sdr[picture];//读取第一个图片的位流MemoryStream memoryStream null;memoryStream new MemoryStream(MyData);pictureBox1.Image Image.FromStream(memoryStream);//将图片赋给pictureBox1控件MessageBox.Show(读取成功);}else {MessageBox.Show(库存不足100请及时补充);}}catch{MessageBox.Show(读取失败 over);}}private void button3_Click(object sender, EventArgs e)//出库{string time DateTime.Now.ToLocalTime().ToString();try{string sql1;string number this.textBox1.Text;int count int.Parse(textBox2.Text);SqlConnection conn new SqlConnection(constr);conn new SqlConnection(constr);string sql SELECT number FROM yy_textile WHERE number number ;SqlCommand cmd new SqlCommand(sql, conn);conn.Open();string amount cmd.ExecuteScalar().ToString();int a int.Parse(amount);sql1 update yy_textile set stock stock - count where number number ;mDataAdapter new SqlDataAdapter(sql1, conn);dsall new DataSet();mDataAdapter.Fill(dsall, hard);dataGridView1.DataSource dsall.Tables[hard];MessageBox.Show(出库成功);/*string username login.name;MessageBox.Show(username);*/string username ;//SELECT TOP 1 username from yy_user_record order by id descstring sql2 SELECT TOP 1 username from yy_user_record order by id desc;SqlCommand com new SqlCommand(sql2, conn);SqlDataReader read com.ExecuteReader();while (read.Read())//获取yy_user表中的username,sex,phone{//int number Convert.ToInt32(read[username]);//查询列名1的数据,方法为: read(变量名)[列名]; 该方法返回的是object类型username read[username].ToString();MessageBox.Show(username);}read.Close();string INSERT_sql string.Format(INSERT INTO yy_textile_record VALUES ({0},{1},{2},{3}), number, count, username, DateTime.Now.ToLocalTime());SqlCommand INSERT_cmd new SqlCommand(INSERT_sql, conn);int count1 INSERT_cmd.ExecuteNonQuery();if (count1 0){MessageBox.Show(记录纤维出库信息成功);//new main_page().Show();//this.Hide();}else{MessageBox.Show(记录纤维出库信息失败);}read.Close();}catch (Exception ex) { MessageBox.Show(ex.Message); }finally{ }}private void button4_Click(object sender, EventArgs e){this.Hide();new main_page().Show();}}
}
main_page页面
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;namespace fiber_yy
{public partial class main_page : Form{public main_page(){InitializeComponent();}private void button1_Click(object sender, EventArgs e){MessageBox.Show(退出成功);this.Close();new Form1().Show();}private void button2_Click(object sender, EventArgs e){this.Close();new warehousing().Show();}private void button3_Click(object sender, EventArgs e){this.Close();new shipment().Show();}private void button4_Click(object sender, EventArgs e){this.Close();new query().Show();}}
}
四、效果演示
程序运行 注册我就不演示了请参考前几篇博文 从yy_user表中找个账号密码直接用户登录 登录成功 进入系统
演示出库管理功能 检索一下
当库存低于100的时候会提醒且这时候就不能再出库了需要补充织物
