/// 생성자
public SupDutDtlViewMdl(string FTR_CDE, int FTR_IDN)
{
try
{
// 1.상세마스터
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectSupDutDtl");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
SupDutDtl result = new SupDutDtl();
result = BizUtil.SelectObject(param) as SupDutDtl;
//결과를 뷰모델멤버로 매칭
Type dbmodel = result.GetType();
Type model = this.GetType();
//모델프로퍼티 순회
foreach (PropertyInfo prop in model.GetProperties())
{
string propName = prop.Name;
//db프로퍼티 순회
foreach (PropertyInfo dbprop in dbmodel.GetProperties())
{
string colName = dbprop.Name;
var colValue = dbprop.GetValue(result, null);
if (colName.Equals(propName))
{
try { prop.SetValue(this, colValue); } catch (Exception) { }
}
}
Console.WriteLine(propName + " - " + prop.GetValue(this, null));
}
//2.텝1 - 유지보tn
param = new Hashtable();
param.Add("sqlId", "selectChscResSubList");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
this.Tab01List = (List <LinkFmsChscFtrRes>)BizUtil.SelectListObj <LinkFmsChscFtrRes>(param);
//텝4 - 급수전계량기
param = new Hashtable();
param.Add("sqlId", "SelectHydtMetrDtl");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
this.Tab02List = (List <HydtMetrDtl>)BizUtil.SelectListObj <HydtMetrDtl>(param);
}
catch (Exception) { }
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
supDutAddView = values[0] as SupDutAddView;
// cbFTR_CDE = supDutAddView.cbFTR_CDE; //지형지물
cbHJD_CDE = supDutAddView.cbHJD_CDE; //행정동
cbMNG_CDE = supDutAddView.cbMNG_CDE; //관리기관
cbSAA_CDE = supDutAddView.cbSAA_CDE; //관용도
cbJHT_CDE = supDutAddView.cbJHT_CDE; //접합종류
btnBack = supDutAddView.btnBack;
btnSave = supDutAddView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회 - 신규관리번호 채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectSupDutFTR_IDN");
SupDutDtl result = new SupDutDtl();
result = BizUtil.SelectObject(param) as SupDutDtl;
//채번결과 매칭
this.FTR_IDN = result.FTR_IDN;
this.FTR_CDE = "SA002";
this.IST_YMD = Convert.ToDateTime(DateTime.Today).ToString("yyyy-MM-dd");
//공통팝업창 사이즈 변경 1
FmsUtil.popWinView.Height = 280;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//신규 시설물 생성자
public UC_SPLY_LS(string _FTR_CDE) : this()
{
txtFTR_CDE.Text = _FTR_CDE;
//신규관리번호채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectSupDutFTR_IDN");
param.Add("FTR_CDE", "SA001");
SupDutDtl result = BizUtil.SelectObject(param) as SupDutDtl;
//채번결과 매칭
txtFTR_IDN.Text = result.FTR_IDN.ToString();
btnDel.Tag = "Y";//신규채번 플래그
}
// 초기조회
private void InitModel()
{
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectSupDutDtl");
param.Add("FTR_CDE", this.FTR_CDE);
param.Add("FTR_IDN", this.FTR_IDN);
SupDutDtl result = BizUtil.SelectObject(param) as SupDutDtl;
if (result != null)
{
this.FctDtl = result;
}
else
{
//신규등록이면 상세화면표시
if ("Y".Equals(uC_SPLY_LS.btnDel.Tag))
{
uC_SPLY_LS.grid.Visibility = Visibility.Visible; //DB데이터가 없으면 빈페이지표시
}
}
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
supDutDtlView = values[0] as SupDutDtlView;
//cbFTR_CDE = supDutDtlView.cbFTR_CDE; //지형지물
cbHJD_CDE = supDutDtlView.cbHJD_CDE; //행정동
cbMNG_CDE = supDutDtlView.cbMNG_CDE; //관리기관
cbSAA_CDE = supDutDtlView.cbSAA_CDE; //관용도
cbJHT_CDE = supDutDtlView.cbJHT_CDE; //접합종류
cbMOP_CDE = supDutDtlView.cbMOP_CDE; //접합종류
btnBack = supDutDtlView.btnBack;
btnDelete = supDutDtlView.btnDelete;
btnSave = supDutDtlView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회
//DataTable dt = new DataTable();
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectSupDutDtl");
param.Add("FTR_CDE", this.FTR_CDE);
param.Add("FTR_IDN", this.FTR_IDN);
SupDutDtl result = new SupDutDtl();
result = BizUtil.SelectObject(param) as SupDutDtl;
//결과를 뷰모델멤버로 매칭
Type dbmodel = result.GetType();
Type model = this.GetType();
//모델프로퍼티 순회
foreach (PropertyInfo prop in model.GetProperties())
{
string propName = prop.Name;
//db프로퍼티 순회
foreach (PropertyInfo dbprop in dbmodel.GetProperties())
{
string colName = dbprop.Name;
var colValue = dbprop.GetValue(result, null);
if (colName.Equals(propName))
{
try { prop.SetValue(this, colValue); } catch (Exception) { }
}
}
Console.WriteLine(propName + " - " + prop.GetValue(this, null));
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
