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; }