public static void SetFillCode(DevExpress.XtraEditors.LookUpEdit lookup,
System.Data.DataTable dtSource,
string DisplayMember,
string ValueMember,
CaptoinStyle style,
int AutoSearchColumnIndex)
{
try
{
DataTable dt = dtSource.Clone();
DataRow r = dt.NewRow();
if (style == CaptoinStyle.NullString)
{
r[ValueMember] = "";
r[DisplayMember] = "";
dt.Rows.Add(r);
}
else if (style == CaptoinStyle.SelectText)
{
r[ValueMember] = "";
r[DisplayMember] = "선택하세요";
dt.Rows.Add(r);
}
dt.Load(dtSource.CreateDataReader());
lookup.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
lookup.Properties.DataSource = dt;
lookup.Properties.DisplayMember = DisplayMember;
lookup.Properties.ValueMember = ValueMember;
lookup.Properties.AutoSearchColumnIndex = AutoSearchColumnIndex;
if (dt.Rows.Count > 0)
{
lookup.EditValue = dt.Rows[0][ValueMember].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 룩업컨트롤에 기초 데이터를 바인딩 합니다.
/// </summary>
/// <param name="lookup">룩업컨트롤.</param>
/// <param name="dtSource">데이터 테이블</param>
/// <param name="DisplayMember">룩업에 출력될 문자열 값 입니다.</param>
/// <param name="ValueMember">룩업에 바인되는 값 입니다.</param>
/// <param name="style">컨트롤 초기텍스트 스타일 입니다..</param>
/// <example>
/// <code>
/// LookUp.SetFillCode(this.lupCustType,
/// ds.Tables[0],
/// "CUST_TYPE_NAME",
/// "CUST_TYPE_CODE",
/// LookUp.CaptoinStyle.SelectText
/// );
/// </code>^
/// </example>
public static void SetFillCode(DevExpress.XtraEditors.LookUpEdit lookup,
System.Data.DataTable dtSource,
string DisplayMember,
string ValueMember,
CaptoinStyle style)
{
try
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("코드");
dt.Columns.Add("코드명");
if (style == CaptoinStyle.NullString)
{
dt.Rows.Add(new object[] { "", "" });
}
else if (style == CaptoinStyle.SelectText)
{
dt.Rows.Add(new object[] { "", "선택하세요" });
}
foreach (System.Data.DataRow r in dtSource.Rows)
{
dt.Rows.Add(new object[] { r[ValueMember].ToString().Trim(), r[DisplayMember].ToString().Trim() });
}
lookup.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
lookup.Properties.DataSource = dt;
lookup.Properties.DisplayMember = "코드명";
lookup.Properties.ValueMember = "코드";
lookup.Properties.AutoSearchColumnIndex = 0;
lookup.EditValue = "";
}
catch (Exception ex)
{
throw ex;
}
}
