/// <summary> /// 导出EXCEL /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExport_Click(object sender, EventArgs e) { try { string filepath = string.Empty; SaveFileDialog sd = new SaveFileDialog(); sd.Title = "保存EXECL文件"; sd.Filter = "*.xls|*.xls"; sd.FilterIndex = 1; if (sd.ShowDialog() != DialogResult.OK) { return; } filepath = sd.FileName; if (File.Exists(filepath)) { File.Delete(filepath); } string strWhere = "Where 1=1"; if (txt_Doc_NO.Text != string.Empty) { strWhere += string.Format(" AND a.S_Doc_NO='{0}'", txt_Doc_NO.Text); } if (txt_MaterialCode.Text != string.Empty) { strWhere += string.Format(" AND a.MaterialCode='{0}'", txt_MaterialCode.Text.Trim()); } if (txt_SerialNumber.Text != string.Empty) { strWhere += string.Format(" AND a.SerialNumber='{0}'", txt_SerialNumber.Text); } if (cbo_Type.SelectedValue.ToString() != string.Empty) { strWhere += string.Format(" AND TYPE_NAME='{0}'", cbo_Type.SelectedValue.ToString()); } DataTable dt_all = T_Bllb_StorageDocDetail_tbsdd_DAL.QueryALL(strWhere); Common.Helper.ExcelHelper.TableToExcel(dt_all, filepath); new PubUtils().ShowNoteOKMsg("导出成功"); } catch { new PubUtils().ShowNoteNGMsg("导出失败", 2, grade.OrdinaryError); } }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_query_Click(object sender, EventArgs e) { string strWhere = " Where 1=1"; if (txt_Doc_NO.Text != string.Empty) { strWhere += string.Format(" AND a.S_Doc_NO='{0}'", txt_Doc_NO.Text.Trim());//单据号 } if (txt_MaterialCode.Text != string.Empty) { strWhere += string.Format(" AND a.MaterialCode='{0}'", txt_MaterialCode.Text.Trim());//料号 } if (txt_SerialNumber.Text != string.Empty) { strWhere += string.Format(" AND a.SerialNumber='{0}'", txt_SerialNumber.Text.Trim());//类型 } if (cbo_Type.SelectedValue.ToString() != string.Empty) { strWhere += string.Format(" ANd TYPE_NAME='{0}'", cbo_Type.SelectedValue.ToString()); } DataTable dt = T_Bllb_StorageDocDetail_tbsdd_DAL.Query(strWhere); dgv_barCode.DataSource = dt; }