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
{
}
}
