private void QueryData() { StringBuilder strwhereBuilder = new StringBuilder(" where 1=1 "); if (!string.IsNullOrEmpty(txt_S_Doc_NO.Text.Trim())) { strwhereBuilder.AppendFormat(" and S_Doc_NO ='{0}'", txt_S_Doc_NO.Text.Trim()); } if (cbo_S_Doc_NO_Type.SelectedValue.ToString() != "-1") { strwhereBuilder.AppendFormat(" and S_Doc_Type='{0}'", cbo_S_Doc_NO_Type.SelectedValue.ToString()); } if (!string.IsNullOrEmpty(txt_LotNo.Text.Trim())) { strwhereBuilder.AppendFormat(" and LotNo='{0}' ", txt_LotNo.Text.Trim()); } if (!string.IsNullOrEmpty(txt_PO.Text.Trim())) { strwhereBuilder.AppendFormat(" and PO='{0}' ", txt_PO.Text.Trim()); } if (!string.IsNullOrEmpty(txt_Arrival_NO.Text.Trim())) { strwhereBuilder.AppendFormat(" and Arrival_NO='{0}' ", txt_Arrival_NO.Text.Trim()); } DataTable dt_Doc_Tbsd = BLL_Bllb_StorageDoc_tbsd.Query(strwhereBuilder.ToString()); dgv_Doc_Tbsd.DataSource = dt_Doc_Tbsd; }
private void tol_del_Click(object sender, EventArgs e) { if (dgv_DocCollect.CurrentCell == null || dgv_DocCollect.CurrentCell.RowIndex == -1) { new PubUtils().ShowNoteNGMsg("请先选中行", 2, grade.OrdinaryError); return; } DataGridViewRow dgvr = dgv_DocCollect.Rows[dgv_DocCollect.CurrentCell.RowIndex]; string s_doc_no = SqlInput.ChangeNullToString(dgvr.Cells["S_Doc_NO"].Value); DataTable dt = BLL_Bllb_StorageDoc_tbsd.Query("where S_Doc_NO='" + s_doc_no + "'"); if (dt.Rows.Count > 0) { if (SqlInput.ChangeNullToString(dt.Rows[0]["Status"]) != "1") { new PubUtils().ShowNoteNGMsg("仅开立中的单据可以删除!", 2, grade.OrdinaryError); return; } } if (BLL_Bllb_StorageDoc_tbsd.Delete("where S_Doc_NO='" + s_doc_no + "'") == true) { Query(); new PubUtils().ShowNoteOKMsg("删除成功"); } }
private void btnSave_Click(object sender, EventArgs e) { if (dgvData.Rows.Count == 0) { new CIT.MES.PubUtils().ShowNoteNGMsg("记录行为零,无需保存", 2, CIT.MES.grade.OrdinaryError); return; } while (true)//校验单据是否已被占用 { if (BLL_Bllb_StorageDoc_tbsd.Query(string.Format(" WHERE S_Doc_NO='{0}'", txtDocNO.Text.Trim())).Rows.Count > 0) { cbo_Type_SelectionChangeCommitted(null, null); continue; } else { break; } } var stroage_doc = new T_Bllb_StorageDoc_tbsd() { S_Doc_NO = txtDocNO.Text.Trim(), S_Doc_Type = cbo_Type.SelectedValue.ToString(), Creator = PubUtils.uContext.UserID, Before_Doc_NO = txtBeforeDoc.Text.Trim(), PLCode = _PLCode, WoCode = _WoCode, SfcNo = _SfcNo, Source_Storage = "SAA003" }; var listStorageMaterial = (from u in dtScan.AsEnumerable() select new T_Bllb_StorageDocMaterial_tsdm() { MaterialCode = u.Field <string>("MaterialCode"), S_Doc_NO = txtDocNO.Text.Trim(), Plan_Qty = Convert.ToInt32(u.Field <string>("QTY")), RowNumber = Convert.ToInt32(u.Field <string>("RowNumber")) }).Distinct().ToList(); if (BLL_Bllb_StorageDoc_tbsd.InsertFinishStorageDoc(stroage_doc, listStorageMaterial)) { this.DialogResult = DialogResult.OK; this.Close(); } else { new PubUtils().ShowNoteNGMsg("开立单据失败", 2, grade.OrdinaryError); return; } }