private void button2_Click(object sender, EventArgs e)
{
DBUtility.ExecuteSQL($"update stock_out set stock_out_checked = 1,stock_out_pay = {double.Parse(textBox3.Text) * double.Parse(textBox4.Text)} where stock_in_id2 = '{comboBox2.SelectedItem.ToString()}'");
MessageBox.Show("确认成功");
UpdateInfo();
}
/// <summary>
/// Add
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
DBUtility.ExecuteSQL($"insert into STAFF_TYPE select right('0'+cast(max([Staff_type_id])+1 as varchar),2),'{textBox1.Text}' from STAFF_TYPE ");
ShowData();
}
public Product()
{
InitializeComponent();
data = DBUtility.GetData("SELECT Product_ID 编号,Product_Name 名称,Product_tally 单位 , Product_Weight 重量 , Product_Long 长度 ,Product_Hgih 高度 , Product_Wide 宽度 , Product_Temperature 保存温度 , Product_humidity 保存湿度 FROM[WMS].[dbo].[Product]");
dataGridView1.DataSource = data;
}
/// <summary>
/// select data
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
data = DBUtility.GetData($"SELECT Product_ID 编号,Product_Name 名称,Product_tally 单位 , Product_Weight 重量 , Product_Long 长度 ,Product_Hgih 高度 , Product_Wide 宽度 , Product_Temperature 保存温度 , Product_humidity 保存湿度 FROM [WMS].[dbo].[Product] where Product_ID like '%{textBox1.Text}%' and Product_Name like '%{textBox2.Text}%' and Product_tally like '%{textBox3.Text}%' and Product_Weight like '%{textBox4.Text}%' and Product_Long like '%{textBox5.Text}%' and Product_Hgih like '%{textBox6.Text}%' and Product_Wide like '%{textBox7.Text}%' ");
dataGridView1.DataSource = data;
}
private void ShowData()
{
data = DBUtility.GetData("SELECT [WareType_ID] 种类编号 ,[Waretype_Name] 种类名称 ,[Waretype_Tem_controlable] 可控温 ,[Waretype_Hum_controlable] 可控湿 ,[Waretype_Max_tem] 最高温度 ,[Waretype_Min_tem] 最低温度 ,[Waretype_Max_hum] 最高湿度 ,[Waretype_Min_hum] 最低湿度 FROM [WMS].[dbo].[WareAreaType]");
dataGridView1.DataSource = data;
}
private void ShowData()
{
data = DBUtility.GetData("SELECT [WareArea_ID] 区域编号,[Warehouse_Name] 主仓库名称 ,[Waretype_Name] 仓库类别 ,[WareArea_Floor] 层数 ,[WareArea_High] 高度 ,[WareArea_Wide] 宽度 ,[WareArea_Long] 长度 ,[WareArea_MaxWeight] 最大承重 ,[WareArea_Cost] 花费 ,[WareArea_NowTem] 当前温度 ,[WareArea_NowHum] 当前湿度 ,[Last_check_date] 最后检查时间 FROM [WMS].[dbo].[WareArea] a, WareAreaType b, WareHouse c where a.Warehouse_ID = c.Warehouse_ID and a.WareType_ID = b.WareType_ID");
dataGridView1.DataSource = data;
}
public CustomerMain(string email)
{
ID = DBUtility.GetData($"select customer_id from customer where customer_email = '{email}'").Rows[0][0].ToString();
Email = email;
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
DBUtility.ExecuteSQL($"Update warearea set last_check_date = getdate() where wareArea_id ='{comboBox1.SelectedItem.ToString()}' ");
MessageBox.Show("巡检成功");
}
private void ShowData()
{
data = DBUtility.GetData("SELECT [Warehouse_ID] 仓库编号 ,[Warehouse_Name] 仓库名 FROM [WMS].[dbo].[WareHouse]");
dataGridView1.DataSource = data;
}
/// <summary>
/// update
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
DBUtility.ExecuteSQL($"update [WMS].[dbo].[WareHouse] set Warehouse_Name = '{textBox2.Text}' where Warehouse_ID = '{textBox1.Text}' ");
ShowData();
}
/// <summary>
/// insert
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
DBUtility.ExecuteSQL($"insert into [WMS].[dbo].[WareHouse] select right('0000000000'+cast(max(Warehouse_ID)+1 as varchar),10),'{textBox2.Text}' from [WMS].[dbo].[WareHouse] ");
ShowData();
}
private void button1_Click(object sender, EventArgs e)
{
data = DBUtility.GetData($" select WareArea_ID 仓储区域号,a.Ware_detail_owner 货主,a.Product_ID 商品编号 ,b.Product_Name 商品名,a.Ware_detail_number 数量 from Ware_Detail a , Product b where a.Product_ID = b.Product_ID and b.Product_Name like '%{textBox1.Text}%' and a.Ware_detail_owner like '%{textBox2.Text}%' and WareArea_ID like '%{textBox3.Text}%'");
dataGridView1.DataSource = data;
}
public StockStaff()
{
InitializeComponent();
data = DBUtility.GetData(" select WareArea_ID 仓储区域号,a.Ware_detail_owner 货主,a.Product_ID 商品编号 ,b.Product_Name 商品名,a.Ware_detail_number 数量 from Ware_Detail a , Product b where a.Product_ID = b.Product_ID ");
dataGridView1.DataSource = data;
}