public DataTable M_Shiiresaki_Select(M_SHIIRESAKI_Entity M_Shiiresaki_Entity) //Pattern_List_BL { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("@VC_SHIIRESAKI", M_Shiiresaki_Entity.MakerCD); dic.Add("@VM_SHIIRESAKI", M_Shiiresaki_Entity.MakerName); return(SelectData(dic, "M_Shiiresaki_Select")); }
/// <summary> /// bind grid data /// </summary> private void BindGrid() { M_Shiiresaki_Data = new M_SHIIRESAKI_Entity(); M_Shiiresaki_Data.MakerName = txtMakerName.Text; DataTable dt_MakerSearch = new DataTable(); dt_MakerSearch = MakerList_BL.Maker_Select(M_Shiiresaki_Data); dgvMakerSearch.DataSource = dt_MakerSearch; if (dt_MakerSearch.Rows.Count > 0) { dgvMakerSearch.Rows[0].Selected = true; } }
private void DataCD_Validating(object sender, CancelEventArgs e) { TextBox txt = sender as TextBox; int row = dgvM_MakerZaiko.CurrentCell.RowIndex; if (string.IsNullOrWhiteSpace(txt.Text)) { dgvM_MakerZaiko.Rows[row].Cells["colDataName"].Value = string.Empty; return; } mse = new M_SHIIRESAKI_Entity(); mse.MakerCD = txt.Text; DataTable dt = psks0102mbl.M_Shiiresaki_Select(mse); if (dt.Rows.Count > 0) { dgvM_MakerZaiko.Rows[row].Cells["colDataName"].Value = dt.Rows[0]["DataMakerName"].ToString(); if (!string.IsNullOrWhiteSpace(ucMaker.UC_Code)) { dgvM_MakerZaiko.Rows[row].Cells[dgvM_MakerZaiko.Columns["colMakerCD"].Index].Value = ucMaker.UC_Code; dgvM_MakerZaiko.Rows[row].Cells[dgvM_MakerZaiko.Columns["colMakerName"].Index].Value = ucMaker.UC_Name; } if (!string.IsNullOrWhiteSpace(ucBrand.UC_Code)) { dgvM_MakerZaiko.Rows[row].Cells[dgvM_MakerZaiko.Columns["colBrandCD"].Index].Value = ucBrand.UC_Code; dgvM_MakerZaiko.Rows[row].Cells[dgvM_MakerZaiko.Columns["colBrandName"].Index].Value = ucBrand.UC_Name; } CheckRowAdd(dgvM_MakerZaiko.Rows[row]); } else { DSP_MSG("E101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); dgvM_MakerZaiko.Rows[row].Cells["colDataName"].Value = string.Empty; dgvM_MakerZaiko.CurrentCell = dgvM_MakerZaiko[dgvM_MakerZaiko.Columns["colData"].Index, row]; if (lastKeyIsEnter) { SendKeys.Send("+{TAB}"); } else { e.Cancel = true; } } }
public DataTable Maker_Select(M_SHIIRESAKI_Entity M_Shiiresaki_Data) { return(M_Shiiresaki_DL.M_Shiiresaki_Select(M_Shiiresaki_Data)); }
public DataTable M_Shiiresaki_Select(M_SHIIRESAKI_Entity mse) { return(shiiresakiDL.M_Shiiresaki_Select(mse)); }