/// <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; } }