/// <summary>
/// 룩업컨트롤에 기초코드를 채움니다.
/// </summary>
/// <param name="lookup">룩업컨트롤.</param>
/// <param name="style">구성스타일.</param>
/// <param name="filter">The filter.</param>
public static void FillBasicCode(DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit lookup,
BasicCodeReturnStyle style,
string filter
)
{
try
{
DataTable dt = GetBasicCode(style, filter);
dt.Columns[0].ColumnName = "코드";
dt.Columns[1].ColumnName = "코드명";
lookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
lookup.DataSource = dt;
lookup.DisplayMember = "코드명";
lookup.ValueMember = "코드";
lookup.AutoSearchColumnIndex = 0;
lookup.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
lookup.NullText = "";
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 영업장 룩업컨트롤에 기초코드를 채웁니다.
/// </summary>
/// <param name="lookup">룩업컨트롤.</param>
/// <param name="head">해더값.</param>
/// <param name="style">구성스타일.</param>
/// <example><code>
/// //납부구분
/// BizCommon.BasicCode.FillBasicCode(lupPlanPartitionCode, "A0015", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption);
/// </code></example>
public static void FillFacilityBasicCode(DevExpress.XtraEditors.LookUpEdit lookup,
string head,
BasicCodeReturnStyle style
)
{
try
{
DataTable tmpdt = GetBasicCode(head, style);
tmpdt.Columns[0].ColumnName = "코드";
tmpdt.Columns[1].ColumnName = "코드명";
lookup.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
lookup.Properties.DataSource = tmpdt;
lookup.Properties.DisplayMember = "코드명";
lookup.Properties.ValueMember = "코드";
lookup.Properties.AutoSearchColumnIndex = 0;
if (style == BasicCodeReturnStyle.Default)
{
lookup.EditValue = ((DataTable)(lookup.Properties.DataSource)).Rows.Count >= 1 ?
((DataTable)(lookup.Properties.DataSource)).Rows[0][0].ToString().Trim() :
"";
}
else
{
lookup.EditValue = "";
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 룩업컨트롤에 기초코드를 채움니다.
/// </summary>
/// <param name="lookup">룩업컨트롤.</param>
/// <param name="head">해더값.</param>
/// <param name="style">구성스타일.</param>
/// <param name="selectedVale">초기값지정</param>
/// <example><code>
/// //계약구분
/// BizCommon.BasicCode.FillBasicCode(lupContractCode, "A0011", BizCommon.BasicCode.BasicCodeReturnStyle.Default, "00", BizCommon.BasicCode.LookupSearchStyle.DisplayMember);
/// </code></example>
public static void FillBasicCode(DevExpress.XtraEditors.LookUpEdit lookup,
string head,
BasicCodeReturnStyle style,
string selectedVale,
LookupSearchStyle lupstyle
)
{
try
{
DataTable dt = GetBasicCode(head, style);
dt.Columns[0].ColumnName = "코드";
dt.Columns[1].ColumnName = "코드명";
lookup.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
lookup.Properties.DataSource = dt;
lookup.Properties.DisplayMember = "코드명";
lookup.Properties.ValueMember = "코드";
lookup.Properties.AutoSearchColumnIndex = lupstyle == LookupSearchStyle.DisplayMember ? 1 : 0;
lookup.EditValue = selectedVale;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 룩업컨트롤에 쿼리를 받아 코드성데이타를 채움니다
/// </summary>
/// <param name="lookup">룩업컨트롤</param>
/// <param name="SYS">시스템</param>
/// <param name="CODE_TYPE">코드타입</param>
/// <param name="style">룩업스타일</param>
/// <CODE><SAMPLE>
/// /원장잔액/
/// BizCommon.BasicCodeBO.FillQueryCode(RepositoryItemLookUpEdit, "select code 코드,name 코드명 from sys0110 where sys='ACM' and code_type='88' and use_yn = 'Y' order by code,seq", "코드","코드명", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption);
/// </SAMPLE></CODE>
public static void FillDataTableCode(DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit lookup,
DataTable dtCode,
string ValueName, string DisplayName,
BasicCodeReturnStyle style
)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns[0].ColumnName = ValueName;
dt.Columns[1].ColumnName = DisplayName;
switch (style)
{
case BasicCodeReturnStyle.NullStringCaption:
dt.Rows.Add("", "");
break;
case BasicCodeReturnStyle.SelectStringCaption:
dt.Rows.Add("", "선택하세요");
break;
case BasicCodeReturnStyle.SelectAll:
dt.Rows.Add("%", "전체");
break;
}
//DataSet ds = Cls.DataLayer.DataLayer.ExecuteDataset(Qry, Cls.DataLayer.DataLayer.MessageEncoding.Default);
if (dtCode != null)
{
foreach (DataRow dRow in dtCode.Rows)
{
dt.Rows.Add(new object[] { dRow[ValueName].ToString().Trim(),
dRow[DisplayName].ToString().Trim() });
}
}
lookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
lookup.DataSource = dt;
lookup.DisplayMember = DisplayName;
lookup.ValueMember = ValueName;
lookup.AutoSearchColumnIndex = 0;
lookup.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
lookup.NullText = "";
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 업무코드를 읽어서 룩업컨트롤에 바인딩한다.
/// </summary>
/// <param name="lookup"></param>
/// <param name="style"></param>
public static void FillSysCode(DevExpress.XtraEditors.LookUpEdit lookup, BasicCodeReturnStyle style)
{
try
{
DataSet ds = Cls.DataLayer.DataLayer.ExecuteDataset("SELECT SYS_CODE 코드, SYS_DESC 코드명 FROM SYS9010 WHERE USE_YN = 'Y' ORDER BY SEQ", Cls.DataLayer.DataLayer.MessageEncoding.Default);
DataTable dt = new DataTable();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns[0].ColumnName = "코드";
dt.Columns[1].ColumnName = "코드명";
dt.Rows.Add("", "");
dt.Rows.Add("", "선택하세요");
dt.Rows.Add("%", "전체");
switch (style)
{
case BasicCodeReturnStyle.NullStringCaption:
ds.Tables[0].Rows.InsertAt(dt.Rows[0], 0);
break;
case BasicCodeReturnStyle.SelectStringCaption:
ds.Tables[0].Rows.InsertAt(dt.Rows[1], 0);
break;
case BasicCodeReturnStyle.SelectAll:
ds.Tables[0].Rows.InsertAt(dt.Rows[2], 0);
break;
}
lookup.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
lookup.Properties.DataSource = ds.Tables[0];
lookup.Properties.DisplayMember = "코드명";
lookup.Properties.ValueMember = "코드";
lookup.Properties.AutoSearchColumnIndex = 0;
lookup.EditValue = "";
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 공통코드를 가져옵니다.
/// </summary>
/// <param name="SYS">업무구분.</param>
/// <param name="CODE_TYPE">코드타입.</param>
/// <param name="style">컨트롤에 기본 메세지를 출력할 스타일입니다.</param>
/// <returns>검색된 데이터 테이블</returns>
private static DataTable getBasicCode(string SYS, string CODE_TYPE, BasicCodeReturnStyle style)
{
//DataSet ds = Cls.DataLayer.DataLayer.ExecuteDataset("SELECT CODE 코드, NAME 코드명 FROM SYS0110 WHERE SYS = '" + SYS + "' AND CODE_TYPE ='" + CODE_TYPE + "' AND USE_YN = 'Y' ORDER BY SEQ,CODE", Cls.DataLayer.DataLayer.MessageEncoding.Default);
DataRow[] codeROW = mDataTable_BO.dtSYS0110.Select("SYS = '" + SYS + "' AND CODE_TYPE ='" + CODE_TYPE + "' AND USE_YN = 'Y'", "SEQ,CODE");
DataTable tmpDT = mDataTable_BO.dtSYS0110.Clone();
codeROW.CopyToDataTable(tmpDT, LoadOption.OverwriteChanges);
DataTable dt = new DataTable();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns[0].ColumnName = "코드";
dt.Columns[1].ColumnName = "코드명";
switch (style)
{
case BasicCodeReturnStyle.NullStringCaption:
dt.Rows.Add("", "");
break;
case BasicCodeReturnStyle.SelectStringCaption:
dt.Rows.Add("", "선택하세요");
break;
case BasicCodeReturnStyle.SelectAll:
dt.Rows.Add("%", "전체");
break;
}
foreach (DataRow dRow in tmpDT.Rows)
{
dt.Rows.Add(new object[] { dRow["CODE"].ToString().Trim(),
dRow["NAME"].ToString().Trim() });
}
return(dt);
}
/// <summary>
/// 룩업컨트롤에 기초코드를 채움니다
/// </summary>
/// <param name="lookup">룩업컨트롤</param>
/// <param name="Filter">Filter String</param>
/// <param name="OrderColumn">Sort Order Column</param>
/// <param name="style">룩업스타일</param>
/// <CODE><SAMPLE>
/// /단위/
/// BizCommon.BasicCodeBO.FillBasicCode(lupContractCode, "ALL","05", BizCommon.BasicCodeBO.BasicCodeReturnStyle.SelectStringCaption);
/// </SAMPLE></CODE>
public static void FillBasicCodeFilter(DevExpress.XtraEditors.LookUpEdit lookup,
string Filter, string OrderColumn,
BasicCodeReturnStyle style
)
{
try
{
DataTable dt = getBasicCodeFilter(Filter, OrderColumn, style);
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;
}
}
/// <summary>
/// 기초코드를 가져옵니다.
/// </summary>
/// <param name="head">헤더.</param>
/// <param name="useYnFild">사용여부.</param>
/// <param name="sortFild">소트필드</param>
/// <param name="style"> 기본선택여부.</param>
/// <returns>필터링된 데이터 테이블</returns>
public static DataTable GetBasicCode(string head,
string useYnFild,
string sortFild,
BasicCodeReturnStyle style)
{
try
{
DataTable dt = new DataTable("BasicCode");
dt.Columns.Add("VAL");
dt.Columns.Add("TXT");
string Filter = "HEAD = '" + head + "' AND DETAIL <> ' ' AND " + useYnFild + " = 'Y'";
DataRow[] r = BizCommon.Parm.mDataTable.dtZx010ms.Select(Filter, sortFild);
switch (style)
{
case BasicCodeReturnStyle.NullStringCaption:
dt.Rows.Add(new object[] { "", "" });
break;
case BasicCodeReturnStyle.SelectStringCaption:
dt.Rows.Add(new object[] { "", "선택하세요" });
break;
}
for (int i = 0; i < r.Length; i++)
{
dt.Rows.Add(new object[] { r[i]["DETAIL"].ToString().Trim(),
r[i]["DETAIL_NAME"].ToString().Trim() });
}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 영업장 기초코드를 가져옵니다.
/// </summary>
/// <param name="head">헤더.</param>
/// <param name="style">컨트롤에 기본 메세지를 출력할 스타일입니다.</param>
/// <returns>필터링된 데이터 테이블</returns>
public static DataTable GetBasicCode(string head,
BasicCodeReturnStyle style)
{
try
{
DataTable tmpdt = new DataTable("BasicCode");
tmpdt.Columns.Add("FACILITY_CODE");
tmpdt.Columns.Add("FACILITY_NAME");
string Filter = "FACILITY_TYPE = '" + head + "' AND FACILITY_CODE <> ' ' AND USE_YN = 'Y'";
DataRow[] r = BizCommon.Parm.mDataTable.dtJaa010ms.Select(Filter, "FACILITY_CODE");
switch (style)
{
case BasicCodeReturnStyle.NullStringCaption:
tmpdt.Rows.Add(new object[] { "", "" });
break;
case BasicCodeReturnStyle.SelectStringCaption:
tmpdt.Rows.Add(new object[] { "", "선택하세요" });
break;
}
for (int i = 0; i < r.Length; i++)
{
tmpdt.Rows.Add(new object[] { r[i]["FACILITY_CODE"].ToString().Trim(),
r[i]["FACILITY_NAME"].ToString().Trim() });
}
return(tmpdt);
}
catch (Exception ex)
{
throw ex;
}
}
