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 btn_save_Click(object sender, EventArgs e) { if (dgv_doc.Rows.Count == 0) { MsgBox.Error("记录行为0,无需保存!"); return; } List <T_Bllb_StorageDoc_tbsd> List_tbsd = new List <T_Bllb_StorageDoc_tbsd>(); T_Bllb_StorageDoc_tbsd model_tbsd = new T_Bllb_StorageDoc_tbsd(); model_tbsd.S_Doc_NO = dtDoc.Rows[0]["S_Doc_NO"].ToString(); model_tbsd.Source_Storage = dtDoc.Rows[0]["Source_Storage"].ToString(); model_tbsd.S_Doc_Type = dtDoc.Rows[0]["S_Doc_Type"].ToString(); model_tbsd.Creator = PubUtils.uContext.UserID; List_tbsd.Add(model_tbsd); List <T_Bllb_StorageDocMaterial_tsdm> List_tbdm = new List <T_Bllb_StorageDocMaterial_tsdm>(); T_Bllb_StorageDocMaterial_tsdm model_tsdm = new T_Bllb_StorageDocMaterial_tsdm(); foreach (DataRow dr in dtDoc.Rows) { model_tsdm.S_Doc_NO = dr["S_Doc_NO"].ToString(); model_tsdm.MaterialCode = dr["MaterialCode"].ToString(); model_tsdm.Plan_Qty = Convert.ToInt32(dr["Quantity"].ToString()); List_tbdm.Add(model_tsdm); model_tsdm = new T_Bllb_StorageDocMaterial_tsdm(); } if (BLL_Bllb_StorageDoc_tbsd.SaveStorageDoc(List_tbsd, List_tbdm)) { model_tbsd = new T_Bllb_StorageDoc_tbsd(); this.DialogResult = DialogResult.OK; } this.Close(); }
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 DataBind() { dtType = BLL_Bllb_StorageDoc_tbsd.QueryDocType("where TYPE_CODE in('18','19')");//暂时只有发料单 DataRow dr = dtType.NewRow(); dr["TYPE_NAME"] = string.Empty; dr["TYPE_CODE"] = "-1"; dtType.Rows.InsertAt(dr, 0); cbo_Type.DataSource = dtType; cbo_Type.DisplayMember = "TYPE_NAME"; cbo_Type.ValueMember = "TYPE_CODE"; cbo_Type.SelectedIndex = 0; }
private void dgv_StorageMaterial_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgv_StorageMaterial.CurrentCell == null || dgv_StorageMaterial.CurrentCell.RowIndex == -1) { return; } dgvStorageDetail.DataSource = null; string queryWhere = string.Format(@" where a.S_Doc_NO='{0}' and a.MaterialCode='{1}'", SqlInput.ChangeNullToString(dgv_StorageMaterial.Rows[dgv_StorageMaterial.CurrentCell.RowIndex].Cells[S_Doc_NO_Material.Name].Value), SqlInput.ChangeNullToString(dgv_StorageMaterial.Rows[dgv_StorageMaterial.CurrentCell.RowIndex].Cells[MaterialCode.Name].Value)); dtStorageDetail = BLL_Bllb_StorageDoc_tbsd.QueryStorageDetail(queryWhere); dgvStorageDetail.DataSource = dtStorageDetail; }
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; } }
private void cbo_Type_SelectionChangeCommitted(object sender, EventArgs e) { txtDocNO.Text = string.Empty; string var_head = string.Empty; if (cbo_Type.SelectedValue.ToString() == "-1") { return; } if (dtType.Rows.Count > 0) { var_head = (from h in dtType.AsEnumerable() where h.Field <string>("TYPE_CODE") == cbo_Type.SelectedValue.ToString() select h.Field <string>("TYPE_HEAD")).Distinct().ToList().FirstOrDefault(); } if (cbo_Type.SelectedValue.ToString() != "-1") { DataTable dtFlow = BLL_Bllb_StorageDoc_tbsd.GetStorageDocFlow(cbo_Type.SelectedValue.ToString(), var_head.Trim()); txtDocNO.Text = string.Format("{0}{1}", var_head.Trim(), dtFlow.Rows[0]["flow"].ToString()); } }
private void DataBindType() { dtType = BLL_Bllb_StorageDoc_tbsd.QueryDocType(string.Empty); DataRow dr = dtType.NewRow(); dr["TYPE_NAME"] = string.Empty; dr["TYPE_CODE"] = "-1"; dtType.Rows.InsertAt(dr, 0); cbo_Type.DataSource = dtType; cbo_Type.DisplayMember = "TYPE_NAME"; cbo_Type.ValueMember = "TYPE_CODE"; cbo_Type.SelectedIndex = 0; S_Doc_Type.DataSource = dtType; S_Doc_Type.DisplayMember = "TYPE_NAME"; S_Doc_Type.ValueMember = "TYPE_CODE"; //DataTable dtUser = user_bll.Select(); //Creator.DataSource = dtUser; //Creator.DisplayMember = "UserName"; //Creator.ValueMember = "UserID"; //Creator_Detail.DataSource = dtUser; //Creator_Detail.DisplayMember = "UserName"; //Creator_Detail.ValueMember = "UserID"; }
private void QueryData() { try { StringBuilder strbild = new StringBuilder(" where a.S_Doc_Type IN('18','19') "); if (!string.IsNullOrEmpty(txt_Doc_NO.Text.Trim())) { strbild.AppendFormat(" and a.S_Doc_NO='{0}'", txt_Doc_NO.Text.Trim()); } if (!string.IsNullOrEmpty(dtp_TimeMin.Text.Trim())) { strbild.AppendFormat(" and a.Create_Time>=CONVERT(DATETIME,'{0}')", dtp_TimeMin.Text.Trim()); } if (cbo_Type.SelectedValue.ToString() != "-1") { strbild.AppendFormat(" and a.S_Doc_Type='{0}'", cbo_Type.SelectedValue.ToString()); } if (!string.IsNullOrEmpty(dtp_TimeMax.Text.Trim())) { strbild.AppendFormat(" and a.Create_Time<=CONVERT(DATETIME,'{0}')", dtp_TimeMax.Text.Trim()); } if (!string.IsNullOrEmpty(txtBeforeDoc.Text.Trim())) { strbild.AppendFormat(" and a.Before_Doc_No='{0}'", txtBeforeDoc.Text.Trim()); } dt_StorageDoc = BLL_Bllb_StorageDoc_tbsd.QueryData(strbild.ToString()); dgv_StorageDoc.DataSource = dt_StorageDoc; dgv_StorageMaterial.DataSource = null; dgvStorageDetail.DataSource = null; } catch { CIT.Client.MsgBox.Error("请输入正确的时间格式=>yyyy-mm-dd"); return; } }
private void InsertToTempDgv() { string msg = string.Empty; if (!ValidateInput(out msg)) { MsgBox.Error(msg); return; } string head = BLL_Bllb_POMain_tbpm.GetDoctypeHead(cbo_TypeCode.SelectedValue.ToString()).Rows[0]["TYPE_HEAD"].ToString().Trim(); string flow = BLL_Bllb_StorageDoc_tbsd.GetFlow(cbo_TypeCode.SelectedValue.ToString(), head).Rows[0][1].ToString(); string pocode = head + flow; DataRow dr = dtDoc.NewRow(); dr["S_Doc_NO"] = pocode; dr["Source_Storage"] = cmbStorage.SelectedValue.ToString(); dr["S_Doc_Type"] = cbo_TypeCode.SelectedValue.ToString(); dr["EmployeeCode"] = PubUtils.uContext.UserID; dr["MaterialCode"] = txtMaterialCode.Text.Trim(); dr["Quantity"] = txtQuantity.Text.Trim(); dtDoc.Rows.Add(dr); txtMaterialCode.Clear(); txtQuantity.Clear(); }