public CaseUserProfile(int CaseUserID) : base()
{
DataTable dt = (DataTable)DBUtil.DBOp("ConnDB",
"dbo.usp_CaseUser_xGetCaseUserWithMother {0}",
new string[] { CaseUserID.ToString() },
NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
SystemCode.Update();
SystemAreaCode.Update();
if (dt.Rows.Count > 0)
{
CaseID = CaseUserID;
BirthDate = dt.Rows[0]["BirthDateSimple"].ToString();
IdNo = dt.Rows[0]["IdNo"].ToString();
PassportNo = dt.Rows[0]["PassportNo"].ToString();
ResNo = dt.Rows[0]["ResNo"].ToString();
OtherNo = dt.Rows[0]["OtherNo"].ToString();
Name = dt.Rows[0]["ChName"].ToString();
EngName = dt.Rows[0]["EnName"].ToString();
Gender = dt.Rows[0]["Gender"].ToString();
GenderName = SystemCode.GetName("CaseUser_Gender", Convert.ToInt32(Gender));
HouseNo = dt.Rows[0]["HouseNo"].ToString();
ONationality = dt.Rows[0]["ONationality"].ToString();
Language = dt.Rows[0]["Language"].ToString().Split(',');
foreach (string s in Language)
{
if (s != "")
{
LanguageName += SystemCode.GetName("CaseUser_Language", Convert.ToInt32(s)) + ",";
}
}
LanguageName = (LanguageName != null ? LanguageName.TrimEnd(',') :"");
Capacity = dt.Rows[0]["Capacity"].ToString().Split(',');
foreach (string s in Capacity)
{
if (s != "")
{
CapacityName += SystemCode.GetName("CaseUser_Capacity", Convert.ToInt32(s)) + ",";
}
}
CapacityName = (CapacityName != null ? CapacityName.TrimEnd(',') : "");
ConCounty = dt.Rows[0]["ConCounty"].ToString();
if (ConCounty != "")
{
ConCountyName = SystemAreaCode.GetName(Convert.ToInt32(dt.Rows[0]["ConCounty"]));
}
ConTown = dt.Rows[0]["ConTown"].ToString();
if (ConTown != "")
{
ConTownName = SystemAreaCode.GetName(Convert.ToInt32(dt.Rows[0]["ConTown"]));
}
ConVillage = dt.Rows[0]["ConVillage"].ToString();
if (ConVillage != "")
{
ConVillageName = SystemAreaCode.GetName(Convert.ToInt32(dt.Rows[0]["ConVillage"]));
}
ConAddr = dt.Rows[0]["ConAddr"].ToString();
ResCounty = dt.Rows[0]["ResCounty"].ToString();
if (ResCounty != "")
{
ConCountyName = SystemAreaCode.GetName(Convert.ToInt32(dt.Rows[0]["ResCounty"]));
}
ResTown = dt.Rows[0]["ResTown"].ToString();
if (ResTown != "")
{
ResTownName = SystemAreaCode.GetName(Convert.ToInt32(dt.Rows[0]["ResTown"]));
}
ResVillage = dt.Rows[0]["ResVillage"].ToString();
if (ResVillage != "")
{
ResVillageName = SystemAreaCode.GetName(Convert.ToInt32(dt.Rows[0]["ResVillage"]));
}
ResAddr = dt.Rows[0]["ResAddr"].ToString();
MotherName = dt.Rows[0]["MotherName"].ToString();
MotherIdNo = dt.Rows[0]["MotherIdNo"].ToString();
MotherBirthDate = dt.Rows[0]["MotherBirthDateSimple"].ToString();
// PregWeek = dt.Rows[0]["PregWeek"].ToString();
// BirthNum = dt.Rows[0]["BirthNum"].ToString();
// BirthSeq = dt.Rows[0]["BirthSeq"].ToString();
//BirthWeight = dt.Rows[0]["BirthWeight"].ToString();
//BirthPlace = dt.Rows[0]["BirthPlace"].ToString();
// Deliver = dt.Rows[0]["Deliver"].ToString();
// DeliverOrg = dt.Rows[0]["DeliverOrg"].ToString();
// MarryStatus = dt.Rows[0]["MarryStatus"].ToString();
// EduLevel = dt.Rows[0]["EduLevel"].ToString();
// ElemSchool = dt.Rows[0]["ElemSchool"].ToString();
//Occupation = dt.Rows[0]["Occupation"].ToString();
// EduLevel = dt.Rows[0]["EduLevel"].ToString();
//EduLevel = dt.Rows[0]["EduLevel"].ToString();
// ResAddr = dt.Rows[0]["ResAddr"].ToString();
// BirthMulti = dt.Rows[0]["BirthMulti"].ToString();
}
}
protected void SetAttr(DataTable dt)
{
if (dt.Rows.Count > 0)
{
int iGender, iONationality, iImmiType
, iConCounty, iConTown, iConVillage, iConNei
, iResCounty, iResTown, iResVillage, iResNei
, iPregWeek, iBirthNum, iBirthSeq, iBirthWeight
, iBirthPlace, iDeliver, iBirthMulti
, iRegionID, iMainContactCaseID;
CaseID = Convert.ToInt32(dt.Rows[0]["CaseID"]);
BirthDate = dt.Rows[0]["BirthDateSimple"].ToString();
IdNo = dt.Rows[0]["IdNo"].ToString();
PassportNo = dt.Rows[0]["PassportNo"].ToString();
ResNo = dt.Rows[0]["ResNo"].ToString();
OtherNo = dt.Rows[0]["OtherNo"].ToString();
ChName = dt.Rows[0]["ChName"].ToString();
EnName = dt.Rows[0]["EnName"].ToString();
HouseNo = dt.Rows[0]["HouseNo"].ToString();
Language = dt.Rows[0]["Language"].ToString().Split(',');
foreach (string s in Language)
{
if (s != "")
{
LanguageName += SystemCode.GetName("CaseUser_Language", Convert.ToInt32(s)) + ",";
}
}
LanguageName = (LanguageName != null ? LanguageName.TrimEnd(',') : "");
Capacity = dt.Rows[0]["Capacity"].ToString().Split(',');
foreach (string s in Capacity)
{
if (s != "")
{
CapacityName += SystemCode.GetName("CaseUser_Capacity", Convert.ToInt32(s)) + ",";
}
}
CapacityName = (CapacityName != null ? CapacityName.TrimEnd(',') : "");
TelDayArea = dt.Rows[0]["TelDayArea"].ToString();
TelDayNo = dt.Rows[0]["TelDayNo"].ToString();
TelDayExt = dt.Rows[0]["TelDayExt"].ToString();
TelNightArea = dt.Rows[0]["TelNightArea"].ToString();
TelNightNo = dt.Rows[0]["TelNightNo"].ToString();
TelNightExt = dt.Rows[0]["TelNightExt"].ToString();
ConAddr = dt.Rows[0]["ConAddr"].ToString();
ResAddr = dt.Rows[0]["ResAddr"].ToString();
DeliverOrg = dt.Rows[0]["DeliverOrg"].ToString();
MarryStatus = dt.Rows[0]["MarryStatus"].ToString();
ElemSchool = dt.Rows[0]["ElemSchool"].ToString();
Occupation = dt.Rows[0]["Occupation"].ToString();
EduLevel = dt.Rows[0]["EduLevel"].ToString();
BirthPlaceOther = dt.Rows[0]["BirthPlaceOther"].ToString();
int.TryParse(dt.Rows[0]["ONationality"].ToString(), out iONationality);
int.TryParse(dt.Rows[0]["ImmiType"].ToString(), out iImmiType);
int.TryParse(dt.Rows[0]["Gender"].ToString(), out iGender);
int.TryParse(dt.Rows[0]["ConCounty"].ToString(), out iConCounty);
int.TryParse(dt.Rows[0]["ConTown"].ToString(), out iConTown);
int.TryParse(dt.Rows[0]["ConVillage"].ToString(), out iConVillage);
int.TryParse(dt.Rows[0]["ConNei"].ToString(), out iConNei);
int.TryParse(dt.Rows[0]["ResCounty"].ToString(), out iResCounty);
int.TryParse(dt.Rows[0]["ResTown"].ToString(), out iResTown);
int.TryParse(dt.Rows[0]["ResVillage"].ToString(), out iResVillage);
int.TryParse(dt.Rows[0]["ResNei"].ToString(), out iResNei);
int.TryParse(dt.Rows[0]["PregWeek"].ToString(), out iPregWeek);
int.TryParse(dt.Rows[0]["BirthNum"].ToString(), out iBirthNum);
int.TryParse(dt.Rows[0]["BirthSeq"].ToString(), out iBirthSeq);
int.TryParse(dt.Rows[0]["BirthWeight"].ToString(), out iBirthWeight);
int.TryParse(dt.Rows[0]["BirthPlace"].ToString(), out iBirthPlace);
int.TryParse(dt.Rows[0]["Deliver"].ToString(), out iDeliver);
int.TryParse(dt.Rows[0]["BirthMulti"].ToString(), out iBirthMulti);
int.TryParse(dt.Rows[0]["RegionID"].ToString(), out iRegionID);
int.TryParse(dt.Rows[0]["MainContactID"].ToString(), out iMainContactCaseID);
ONationality = iONationality;
ImmiType = iImmiType;
Gender = iGender;
ConCounty = iConCounty;
ConTown = iConTown;
ConVillage = iConVillage;
ConNei = iConNei;
ResCounty = iResCounty;
ResTown = iResTown;
ResVillage = iResVillage;
ResNei = iResNei;
PregWeek = iPregWeek;
BirthNum = iBirthNum;
BirthSeq = iBirthSeq;
BirthWeight = iBirthWeight;
BirthPlace = iBirthPlace;
Deliver = iDeliver;
BirthMulti = iBirthMulti;
RegionID = iRegionID;
MainContactCaseID = iMainContactCaseID;
// RegionName = dt.Rows[0]["RegionName"].ToString();
// SystemRegion.Update();
RegionName = SystemRegion.GetName(RegionID);
ImmiTypeName = SystemCode.GetName("CaseUser_ImmiType", ImmiType);
GenderName = SystemCode.GetName("CaseUser_Gender", Gender);
ConCountyName = SystemAreaCode.GetName(ConCounty);
ConTownName = SystemAreaCode.GetName(ConTown);
ConVillageName = SystemAreaCode.GetName(ConVillage);
ResCountyName = SystemAreaCode.GetName(ResCounty);
ResTownName = SystemAreaCode.GetName(ResTown);
ResVillageName = SystemAreaCode.GetName(ResVillage);
if (dt.Columns.Contains("CreateInfo"))
{
CreateInfo = dt.Rows[0]["CreateInfo"].ToString();
}
if (dt.Columns.Contains("ModifyInfo"))
{
ModifyInfo = dt.Rows[0]["ModifyInfo"].ToString();
}
if (dt.Columns.Contains("MotherName"))
{
MotherName = dt.Rows[0]["MotherName"].ToString();
}
if (dt.Columns.Contains("MotherIdNo"))
{
MotherIdNo = dt.Rows[0]["MotherIdNo"].ToString();
}
if (dt.Columns.Contains("MotherBirthDateSimple"))
{
MotherBirthDate = dt.Rows[0]["MotherBirthDateSimple"].ToString();
}
GetMobiles();
GetEmails();
try
{
AgeCalculatorT AgeCal = new AgeCalculatorT();
DateTime b = new DateTime();
DateTime.TryParse(dt.Rows[0]["BirthDate"].ToString(), out b);
AgeTip = AgeCal.GetAge(b);
}
catch
{
}
}
}
