/// 생성자
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;
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);
}
}
