?? frmwglook.cs
字號:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace SMS.LookandSum
{
public partial class frmWGLook : Form
{
public frmWGLook()
{
InitializeComponent();
}
private int G_int_Lnum;
private int G_int_Mnum;
SMS.BaseClass.DataCon datacon = new SMS.BaseClass.DataCon();
private void frmWGLook_Load(object sender, EventArgs e)
{
dgvWGInfo.Controls.Add(hScrollBar1);
SqlDataReader sqlread = datacon.getread("select GoodsLeast,GoodsMost from tb_GoodsInfo");
if (sqlread.Read())
{
G_int_Lnum = Convert.ToInt32(sqlread["GoodsLeast"].ToString().Trim());
G_int_Mnum = Convert.ToInt32(sqlread["GoodsMost"].ToString().Trim());
}
sqlread.Close();
DataSet myds = datacon.getds("select GoodsID as 貨物編號,GoodsName as 貨物名稱,"
+ "StoreName as 倉庫名稱,GoodsSpec as 貨物規格,GoodsUnit as 計量單位,"
+ "GoodsNum as 貨物數量,GoodsInPrice as 進貨價格,GoodsOutPrice as 出貨價格,"
+ "GoodsLeast as 庫存下線,GoodsMost as 庫存上線,Editer as 修改人,EditDate as 修改日期 from tb_GoodsInfo"
+ " where GoodsNum<=" + G_int_Lnum + " or GoodsNum>=" + G_int_Mnum + "", "tb_GoodsInfo");
dgvWGInfo.DataSource = myds.Tables[0];
}
private void btnLook_Click(object sender, EventArgs e)
{
try
{
if (txtLKWord.Text.Trim() == "")
{
frmWGLook_Load(sender, e);
}
else
{
SqlDataReader sqlread = datacon.getread("select GoodsLeast,GoodsMost from tb_GoodsInfo "
+ "where GoodsName like '%" + txtLKWord.Text.Trim() + "%'");
if (sqlread.Read())
{
if (cboxLCondition.Text.Trim() == "庫存下線")
{
DataSet myds = datacon.getds("select GoodsID as 貨物編號,GoodsName as 貨物名稱,"
+ "StoreName as 倉庫名稱,GoodsSpec as 貨物規格,GoodsUnit as 計量單位,"
+ "GoodsNum as 貨物數量,GoodsInPrice as 進貨價格,GoodsOutPrice as 出貨價格,"
+ "GoodsLeast as 庫存下線,GoodsMost as 庫存上線,Editer as 修改人,EditDate as 修改日期"
+ " from tb_GoodsInfo where GoodsName like '%" + txtLKWord.Text.Trim()
+ "%' and GoodsNum<=" + Convert.ToInt32(sqlread["GoodsLeast"].ToString().Trim()) + "", "tb_GoodsInfo");
dgvWGInfo.DataSource = myds.Tables[0];
}
else
{
DataSet myds = datacon.getds("select GoodsID as 貨物編號,GoodsName as 貨物名稱,"
+ "StoreName as 倉庫名稱,GoodsSpec as 貨物規格,GoodsUnit as 計量單位,"
+ "GoodsNum as 貨物數量,GoodsInPrice as 進貨價格,GoodsOutPrice as 出貨價格,"
+ "GoodsLeast as 庫存下線,GoodsMost as 庫存上線,Editer as 修改人,EditDate as 修改日期"
+ " from tb_GoodsInfo where GoodsName like '%" + txtLKWord.Text.Trim()
+ "%' and GoodsNum>=" + Convert.ToInt32(sqlread["GoodsMost"].ToString().Trim()) + "", "tb_GoodsInfo");
dgvWGInfo.DataSource = myds.Tables[0];
}
}
sqlread.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnExit_Click(object sender, EventArgs e)
{
this.Close();
}
private void frmWGLook_FormClosed(object sender, FormClosedEventArgs e)
{
this.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -