private DataTable GetStoreDtlToByPalletId(string sPalletId)
{
string sSql = "select * from V_StoreItemList where nPalletId='" + sPalletId.Trim() + "'";
DataTable tbY = null;
string sErr = "";
tbY = DBFuns.GetDataTableBySql(AppInformation.SvrSocket, false, sSql, "tbStoreDtlTo", 0, 0, "", out sErr);
if (sErr.Trim() != "" && sErr.Trim() != "0")
{
MessageBox.Show(sErr);
}
return(tbY);
}
private void btn_Qry_From_Click(object sender, EventArgs e)
{
StringBuilder sSql = new StringBuilder("select * from V_WARECELLSTATUS where 1=1 ");
#region 获取查询条件
if (cmb_Area_From.Text.Trim() != "" && cmb_Area_From.SelectedValue != null)
{
sSql.Append(" and cAreaId = '" + cmb_Area_From.SelectedValue.ToString() + "'");
}
if (txt_Row_From.Text.Trim() != "")
{
sSql.Append(" and nRow=" + txt_Row_From.Text.Trim());
}
if (txt_Col_From.Text.Trim() != "")
{
sSql.Append(" and nCol=" + txt_Col_From.Text.Trim());
}
if (txt_Layer_From.Text.Trim() != "")
{
sSql.Append(" and nLayer=" + txt_Layer_From.Text.Trim());
}
if (txt_PltId_From.Text.Trim() != "")
{
sSql.Append(" and isnull(nPalletId,' ') like '%" + txt_PltId_From.Text.Trim() + "%'");
}
if (txt_Mat_From.Text.Trim() != "")
{
sSql.Append(" and ( isnull(nPalletId,' ') in ( select distinct nPalletId from V_StoreItemList where (cMNo like '%" + txt_Mat_From.Text.Trim() + "%') or (cMName like '%" + txt_Mat_From.Text.Trim() + "%') or (cPYJM like '%" + txt_Mat_From.Text.Trim() + "%') or (cWBJM like '%" + txt_Mat_From.Text.Trim() + "%') ))");
}
#endregion
DataTable tbPosFrom = null;
string sErr = "";
tbPosFrom = DBFuns.GetDataTableBySql(AppInformation.SvrSocket, false, sSql.ToString(), "PosList", 0, 0, "", out sErr);
if (sErr.Trim() != "" && sErr.Trim() != "0")
{
MessageBox.Show(sErr);
}
bIsOpenPosFrom = false;
bds_Pos_From.DataSource = tbPosFrom;
grd_Pos_From.DataSource = bds_Pos_From;
//MessageBox.Show(bds_Pos_From.Count.ToString());
bIsOpenPosFrom = true;
}
