private void Query() { string strWhere = ""; if (txt_Sdoc_No.Text.Trim() != string.Empty)//单据号 { strWhere += string.Format(" AND a.S_Doc_NO='{0}'", txt_Sdoc_No.Text.Trim()); } if (txt_MaterialCode.Text.Trim() != string.Empty)//料号 { strWhere += string.Format(" AND b.MaterialCode = '{0}'", txt_MaterialCode.Text.Trim()); } strWhere += string.Format(" AND a.Create_Time >=convert(datetime,'{0}')", dtp_CreateTimeMin.Text.Trim()); strWhere += string.Format(" AND a.Create_Time <=convert(datetime,'{0}')", dtp_CreateTimeMax.Text.Trim()); if (dgv_Detail.DataSource != null)//查询退料单据前先把物料SN信息删除 { DataTable dt = (DataTable)dgv_Detail.DataSource; dt.Rows.Clear(); dgv_Detail.DataSource = dt; } DataTable dtSDocMatr = Bll_Bllb_StorageDoc_tbsd.Query(strWhere); dgv_Material.DataSource = dtSDocMatr; }
private void FrmMaterialMoveAdd_Load(object sender, EventArgs e) { string strSql = string.Format(" select Storage_SN,Storage_Name from T_Bllb_Storage_tbs"); DataTable dt_Storage = NMS.QueryDataTable(PubUtils.uContext, strSql); cbo_SourceStorage.DataSource = dt_Storage; cbo_SourceStorage.DisplayMember = "Storage_Name"; cbo_SourceStorage.ValueMember = "Storage_SN"; string strTarget = string.Format(" select Storage_SN,Storage_Name from T_Bllb_Storage_tbs"); DataTable dt_TargetS = NMS.QueryDataTable(PubUtils.uContext, strTarget); cbo_TargetStorage.DataSource = dt_TargetS; cbo_TargetStorage.DisplayMember = "Storage_Name"; cbo_TargetStorage.ValueMember = "Storage_SN"; txt_DOC_NO.Text = Bll_Bllb_StorageDoc_tbsd.Get_MaterialMove_Doc(); if (_IsAddOrEdit) { txt_DOC_NO.Text = Doc.S_Doc_NO; //单据号 cbo_SourceStorage.Text = Doc.Source_Storage; //原仓库 cbo_TargetStorage.Text = Doc.Target_Storage; //目的仓库 txt_memo.Text = Doc.Memo; //备注 string materialCode = DocM.MaterialCode; //料号 //string strWhere = string.Format("Where b.S_Doc_NO ='{0}' AND Storage_SN='{1}' AND a.MaterialCode='{2}'", txt_DOC_NO.Text.Trim(), cbo_SourceStorage.SelectedValue, materialCode); ////dt_MaterialMove = Bll_Bllb_StorageDocMaterial_tsdm.Select(strWhere); //DataTable dt = Bll_Bllb_StorageDocMaterial_tsdm.Select(strWhere); // if (dt.Rows.Count > 0) //{ // dgv_MaterialMoveAdd.DataSource = dt; // dgv_MaterialMoveAdd.ClearSelection(); //} //else //{ // string strcmd = string.Format("S_Doc_NO='{0}' AND MaterialCode='{1}'", txt_DOC_NO.Text.Trim(),materialCode); // dt_MaterialMove = Bll_Bllb_StorageDocMaterial_tsdm.Query(strcmd); // dgv_MaterialMoveAdd.DataSource = dt_MaterialMove; // dgv_MaterialMoveAdd.ClearSelection(); //} string strcmd = string.Format("S_Doc_NO='{0}' ", txt_DOC_NO.Text.Trim()); dt_MaterialMove = Bll_Bllb_StorageDocMaterial_tsdm.Query(strcmd); dgv_MaterialMoveAdd.DataSource = dt_MaterialMove; dgv_MaterialMoveAdd.ClearSelection(); txt_DOC_NO.ReadOnly = true; cbo_SourceStorage.Enabled = false; cbo_TargetStorage.Enabled = false; txt_memo.ReadOnly = true; GetQty(); } }
private void Query() { string strWhere = ""; if (txt_DocNO.Text != string.Empty) { strWhere += string.Format(" AND a.S_Doc_NO='{0}'", txt_DocNO.Text.Trim());//单据号 } if (txt_MaterialCode.Text != string.Empty) { strWhere += string.Format(" AND b.MaterialCode='{0}'", txt_MaterialCode.Text.Trim());//料号 } DataTable dt_MaterialDoc = Bll_Bllb_StorageDoc_tbsd.QueryMaterialDoc(strWhere); dgv_MaterialDoc.DataSource = dt_MaterialDoc; }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_del_Click(object sender, EventArgs e) { if (dgv_MaterialDoc.CurrentRow == null || dgv_MaterialDoc.CurrentRow.Index == -1) { new PubUtils().ShowNoteNGMsg("请选中行", 2, grade.OrdinaryError); return; } if (!DocEdit()) { return; } if (MsgBox.Question("确定要删除?") == DialogResult.OK) { Bll_Bllb_StorageDoc_tbsd.Delete(string.Format(" where S_Doc_NO='{0}'", dgv_MaterialDoc.CurrentRow.Cells["S_Doc_NO"].Value.ToString())); Query(); new PubUtils().ShowNoteOKMsg("删除成功"); } }
/// <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_Sdoc_No.Text != string.Empty)//单据号 { strWhere += string.Format(" AND SD.S_Doc_NO='{0}'", txt_Sdoc_No.Text.Trim()); } if (cbo_MaterialCode.Text != string.Empty)//料号 { strWhere += string.Format(" AND M.MaterialCode = '{0}'", cbo_MaterialCode.Text.Trim()); } if (cbo_DocType.SelectedValue.ToString() != string.Empty) { strWhere += string.Format(" AND SD.S_Doc_Type='{0}'", cbo_DocType.SelectedValue.ToString()); } else { DataTable dt = (DataTable)S_Doc_Type.DataSource; string str = string.Empty; foreach (DataRow dr in dt.Rows) { str += str == string.Empty ? "'" + dr["DICT_CODE"].ToString() + "'" : ",'" + dr["DICT_CODE"].ToString() + "'"; } strWhere += string.Format(" AND SD.S_Doc_Type in ({0})", str); } if (cmb_Line.SelectedValue.ToString() != string.Empty)//线别 { strWhere += string.Format(" AND SD.PLCode='{0}'", cmb_Line.SelectedValue.ToString()); } if (cbo_StorageSN.SelectedValue.ToString() != string.Empty) { strWhere += string.Format(" AND S.Storage_SN='{0}'", cbo_StorageSN.SelectedValue.ToString()); } strWhere += string.Format(" AND SD.Create_Time >=convert(datetime,'{0}')", dtp_CreateTimeMin.Text.Trim()); strWhere += string.Format(" AND SD.Create_Time <=convert(datetime,'{0}')", dtp_CreateTimeMax.Text.Trim()); dtSDoc = Bll_Bllb_StorageDoc_tbsd.Query(strWhere); dgv_SDoc_NO.DataSource = dtSDoc; dtSDoDetail.Clear(); new PubUtils().ShowNoteOKMsg("查询成功!"); }
private void btn_ok_Click(object sender, EventArgs e) { T_Bllb_StorageDoc_tbsd SC = new T_Bllb_StorageDoc_tbsd(); T_Bllb_StorageDocMaterial_tsdm SCD = new T_Bllb_StorageDocMaterial_tsdm(); bool isSucess = false; if (_IsAddOrEdit == false)//新增 { if (txt_DOC_NO.Text != string.Empty) { SC.S_Doc_NO = txt_DOC_NO.Text.Trim();//单据号 } if (cbo_SourceStorage.SelectedValue.ToString() != string.Empty) { SC.Source_Storage = cbo_SourceStorage.SelectedValue.ToString();//原仓库 } if (cbo_TargetStorage.SelectedValue.ToString() != string.Empty) { SC.Target_Storage = cbo_TargetStorage.SelectedValue.ToString();//目的仓库 } if (txt_memo.Text != string.Empty) { SC.Memo = txt_memo.Text.Trim();//备注 } if (cbo_SourceStorage.SelectedValue.ToString() == cbo_TargetStorage.SelectedValue.ToString()) { new PubUtils().ShowNoteNGMsg("原仓库不能跟目的仓库相同", 2, grade.OrdinaryError); return; } lstMaterial.Clear(); foreach (DataGridViewRow row in dgv_MaterialMoveAdd.Rows) { if (!ValiMaterialCode(row)) { return; } SCD.S_Doc_NO = txt_DOC_NO.Text.Trim(); SCD.RowNumber = SqlInput.ChangeNullToInt(row.Cells["RowNumber"].Value, 0); //行号 SCD.MaterialCode = SqlInput.ChangeNullToString(row.Cells["MaterialCode"].Value); //料号 row.Cells["StorageQTY"].Value = Bll_Bllb_StockInfo_tbsi.GetQty(cbo_SourceStorage.SelectedValue.ToString(), SqlInput.ChangeNullToString(row.Cells["MaterialCode"].Value)); SCD.QTY = SqlInput.ChangeNullToInt(row.Cells["StorageQTY"].Value, 0); //库存量 SCD.Plan_Qty = SqlInput.ChangeNullToInt(row.Cells["Plan_Qty"].Value, 0); //计划数量 lstMaterial.Add(SCD); SCD = new T_Bllb_StorageDocMaterial_tsdm(); } if (lstMaterial.Count > 0) { if (Bll_Bllb_StorageDoc_tbsd.InsertDoc(SC)) { isSucess = Bll_Bllb_StorageDocMaterial_tsdm.InsertMaterial(lstMaterial); } } } else//修改 { lstMaterial.Clear(); foreach (DataGridViewRow row in dgv_MaterialMoveAdd.Rows) { if (!ValiMaterialCode(row)) { return; } SCD.S_Doc_NO = txt_DOC_NO.Text.Trim(); SCD.RowNumber = SqlInput.ChangeNullToInt(row.Cells["RowNumber"].Value, 0); //行号 SCD.MaterialCode = SqlInput.ChangeNullToString(row.Cells["MaterialCode"].Value); //料号 row.Cells["StorageQTY"].Value = Bll_Bllb_StockInfo_tbsi.GetQty(cbo_SourceStorage.SelectedValue.ToString(), SqlInput.ChangeNullToString(row.Cells["MaterialCode"].Value)); SCD.QTY = SqlInput.ChangeNullToInt(row.Cells["StorageQTY"].Value, 0); //库存量 SCD.Plan_Qty = SqlInput.ChangeNullToInt(row.Cells["Plan_Qty"].Value, 0); //计划数量 lstMaterial.Add(SCD); SCD = new T_Bllb_StorageDocMaterial_tsdm(); } if (lstMaterial.Count > 0) { string strWhere = string.Format("S_Doc_NO ='{0}'", txt_DOC_NO.Text.Trim()); if (Bll_Bllb_StorageDocMaterial_tsdm.DeleteMaterial(strWhere)) { isSucess = Bll_Bllb_StorageDocMaterial_tsdm.InsertMaterial(lstMaterial); } } } if (isSucess) { new PubUtils().ShowNoteOKMsg("保存成功!"); this.result = DialogResult.OK; this.Close(); } }