/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
ItemGBRule rule = new ItemGBRule();
gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag"));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定挂板
/// </summary>
private void BindGrid()
{
ItemGBRule rule = new ItemGBRule();
DataTable dt = rule.RShow(" AND MainID=" + HTDataID + " ORDER BY Seq", ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定卡片
/// </summary>
void BindGridCard()
{
ItemGBRule rule = new ItemGBRule();
DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("VendorName", "'' VendorName"));
cardView1.GridControl.DataSource = dt;
cardView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
ItemGBRule rule = new ItemGBRule();
DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("VendorName", "'' VendorName"));
if (chkVendor.Checked)
{
SetGridView(dt);
}
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 快速查询(回车即检索)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtName_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter)
{
if (chkSM.Checked)
{
if (txtGBCode.Text.Trim() == "")
{
this.ShowMessage("请输入挂板编码！");
return;
}
string GBCodeStr = txtGBCodeStr.Text.Trim();
if (GBCodeStr != "")
{
GBCodeStr += ",";
}
GBCodeStr += SysString.ToDBString(txtGBCode.Text.Trim());
txtGBCodeStr.Text = GBCodeStr;
ItemGBRule rule = new ItemGBRule();
DataTable dt = rule.RShow(" AND GBCode IN (" + txtGBCodeStr.Text.Trim() + ")", ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "1 SelectFlag").Replace("VendorName", "'' VendorName"));
if (chkVendor.Checked)
{
SetGridView(dt);
}
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
txtGBCode.Text = "";
txtGBCode.Focus();
}
else
{
GetCondtion();
BindGrid();
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
//private string GetColorName(string p_ColorNum)
//{
// string ColorName = "";
// string sql = "SELECT ColorName FROM Data_ItemColorDts WHERE MainID=" + SysString.ToDBString(m_ID);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// DataTable dt = SysUtils.Fill(sql);
// if (dt.Rows.Count > 0)
// {
// ColorName = SysConvert.ToString(dt.Rows[0][0]);
// }
// return ColorName;
//}
//private string GetColorNum(string p_ColorName)
//{
// string ColorNum = "";
// string sql = "SELECT ColorNum FROM Data_ItemColorDts WHERE MainID=" + SysString.ToDBString(m_ID);
// sql += " AND ColorName=" + SysString.ToDBString(p_ColorName);
// DataTable dt = SysUtils.Fill(sql);
// if (dt.Rows.Count > 0)
// {
// ColorNum = SysConvert.ToString(dt.Rows[0][0]);
// }
// return ColorNum;
//}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
ItemGBRule rule = new ItemGBRule();
ItemGB entity = GetItemGB();
if (m_DID == 0)
{
rule.RAdd(entity);
m_DID = entity.ID;
}
else
{
rule.RUpdate(entity);
}
this.ShowInfoMessage("保存成功！");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void btnScanPrint_Click(object sender, EventArgs e)
{
try
{
string tempstr = " AND ItemCode IN (" + txtShow.Text.Trim() + ")";
ItemGBRule rule = new ItemGBRule();
DataTable dt = rule.RShow(tempstr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "1 SelectFlag").Replace("VendorName", "'' VendorName"));
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
DataTable dt2 = rule.RShow(tempstr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "1 SelectFlag").Replace("VendorName", "'' VendorName"));
cardView1.GridControl.DataSource = dt2;
cardView1.GridControl.Show();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
