?? frmbglook.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 frmBGLook : Form
{
public frmBGLook()
{
InitializeComponent();
}
SMS.BaseClass.DataCon datacon = new SMS.BaseClass.DataCon();
private void frmBGLook_Load(object sender, EventArgs e)
{
dgvBGInfo.Controls.Add(hScrollBar1);
DataSet myds = datacon.getds("select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱,"
+ "GoodsSpec as 貨物規格,GoodsNum as 借出數量,BGDate as 借貨日期,HandlePeople as 經手人,"
+ "BGPeople as 借貨人,BGUnit as 借貨單位,BGRemark as 備注 from tb_BorrowGoods", "tb_BorrowGoods");
dgvBGInfo.DataSource = myds.Tables[0];
}
private void btnLook_Click(object sender, EventArgs e)
{
try
{
if (txtLKWord.Text.Trim() == "")
{
frmBGLook_Load(sender, e);
}
else
{
if (cboxLCondition.Text.Trim() == "借貨編號")
{
DataSet myds = datacon.getds("select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱,"
+ "GoodsSpec as 貨物規格,GoodsNum as 借出數量,BGDate as 借貨日期,HandlePeople as 經手人,"
+ "BGPeople as 借貨人,BGUnit as 借貨單位,BGRemark as 備注 from tb_BorrowGoods where BGID = "
+ txtLKWord.Text.Trim() + "", "tb_BorrowGoods");
dgvBGInfo.DataSource = myds.Tables[0];
}
if (cboxLCondition.Text.Trim() == "借貨日期")
{
string P_str_dtime = txtLKWord.Text.Trim();
DataSet myds = datacon.getds("select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱,"
+ "GoodsSpec as 貨物規格,GoodsNum as 借出數量,BGDate as 借貨日期,HandlePeople as 經手人,"
+ "BGPeople as 借貨人,BGUnit as 借貨單位,BGRemark as 備注 from tb_BorrowGoods"
+ " where year(BGDate)=" + P_str_dtime.Substring(0, 4) + " and month(BGDate)="
+ P_str_dtime.Substring(5, P_str_dtime.Length - 6) + "", "tb_BorrowGoods");
dgvBGInfo.DataSource = myds.Tables[0];
}
if (cboxLCondition.Text.Trim() == "倉庫名稱")
{
DataSet myds = datacon.getds("select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱,"
+ "GoodsSpec as 貨物規格,GoodsNum as 借出數量,BGDate as 借貨日期,HandlePeople as 經手人,"
+ "BGPeople as 借貨人,BGUnit as 借貨單位,BGRemark as 備注 from tb_BorrowGoods where StoreName like '%"
+ txtLKWord.Text.Trim() + "%'", "tb_BorrowGoods");
dgvBGInfo.DataSource = myds.Tables[0];
}
if (cboxLCondition.Text.Trim() == "貨物名稱")
{
DataSet myds = datacon.getds("select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱,"
+ "GoodsSpec as 貨物規格,GoodsNum as 借出數量,BGDate as 借貨日期,HandlePeople as 經手人,"
+ "BGPeople as 借貨人,BGUnit as 借貨單位,BGRemark as 備注 from tb_BorrowGoods where GoodsName like '%"
+ txtLKWord.Text.Trim() + "%'", "tb_BorrowGoods");
dgvBGInfo.DataSource = myds.Tables[0];
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,"提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}
private void btnExit_Click(object sender, EventArgs e)
{
this.Close();
}
private void cboxLCondition_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboxLCondition.Text.Trim() == "借貨日期")
{
label2.Text = "查詢年月份";
}
else
{
label2.Text = "查詢關鍵字";
}
}
private void frmBGLook_FormClosed(object sender, FormClosedEventArgs e)
{
this.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -