private void gv_Large_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (!this.CanFocus) { return; } text_L_vocid.Text = gv_Large.GetFocusedRowCellValue(col대분류VOCID.FieldName).ToString(); text_L_Name.Text = gv_Large.GetFocusedRowCellValue(col대분류.FieldName).ToString(); Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(_strUserID, System.Reflection.MethodBase.GetCurrentMethod()); string strQuery = ""; strQuery += string.Format("SELECT * FROM CESCOEIS.dbo.TB_VOC_TEMPLATE AS A WITH (NOLOCK) " + "WHERE VOCID = '" + text_L_vocid.Text + "'" ); db.Query.QueryString.Append(strQuery); DataSet ds = db.QueryToDataSet(); if (ds == null || ds.Tables[0].Rows.Count < 1) { templateText.Text = ""; return; } templateText.Text = ds.Tables[0].Rows[0]["Template"].ToString(); }
private void setLueCode() { DataSet oDs; Cesco.FW.Global.DBAdapter.DBAdapters oDBAdapters = new Cesco.FW.Global.DBAdapter.DBAdapters(); oDBAdapters.LocalInfo = new Cesco.FW.Global.DBAdapter.LocalInfo(_strUserID, "고객의소리 카테고리"); try { oDBAdapters.Query.QueryString.AppendFormat(@" SELECT Gerlcode AS CODE, Gerldesp AS NAME FROM CESCOEIS.DBO.MKTCGERL WHERE GERLCODE LIKE 'BM%' " ); oDs = oDBAdapters.QueryToDataSet(); lu_M_GubunCode.Properties.DisplayMember = "NAME"; lu_M_GubunCode.Properties.ValueMember = "CODE"; lu_M_GubunCode.Properties.DataSource = oDs.Tables[0]; lu_S_GubunCode.Properties.DisplayMember = "NAME"; lu_S_GubunCode.Properties.ValueMember = "CODE"; lu_S_GubunCode.Properties.DataSource = oDs.Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { } }