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