public static void Update()
{
SystemAreaCode.Update();
List <SystemOrgRegionVM> Regionlist = new List <SystemOrgRegionVM>();
DataTable dt = DB.GetDataTable("SELECT ID,[OrgID],[RegionID] FROM [dbo].[R_RegionAndOrg]", "ConnDB");
EntityS.FillModel(Regionlist, dt);
SystemOrgRegion.dictOrgRegion = Regionlist.OrderBy(item => item.OrgID)
.GroupBy(item => item.OrgID)
.ToDictionary(IGrouping => IGrouping.Key, IGrouping => IGrouping.ToList());
dt.Dispose();
List <SystemOrgRegionCountyVM> Countylist = new List <SystemOrgRegionCountyVM>();
dt = DB.GetDataTable(" SELECT [id] ,[OrgID] ,[CountyID] FROM [dbo].[R_RegionCountyAndOrg] ", "ConnDB");
EntityS.FillModel(Countylist, dt);
SystemOrgRegion.dictOrgCounty = Countylist.OrderBy(item => item.OrgID)
.GroupBy(item => item.OrgID)
.ToDictionary(IGrouping => IGrouping.Key, IGrouping => IGrouping.ToList());
dt.Dispose();
List <SystemRegionSettingVM> Settinglist = new List <SystemRegionSettingVM>();
dt = DB.GetDataTable(" SELECT [RegionID] , [CountyID] ,[TownID] ,[VillageID],SettingID FROM [dbo].[R_RegionSetting] ", "ConnDB");
EntityS.FillModel(Settinglist, dt);
SystemOrgRegion.dictRegionSetting = Settinglist.OrderBy(item => item.RegionID)
.GroupBy(item => item.RegionID)
.ToDictionary(IGrouping => IGrouping.Key, IGrouping => IGrouping.ToList());
dt.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
base.AllowHttpMethod("POST");
base.DisableTop(true);
ViewPower = base.GetPower(PowerList[0]);
UpdatePower = base.GetPower(PowerList[1]);
if (this.IsPostBack == false)
{
var codes = SystemCode.dict["CodeM_SchoolCode_EnableState"];
ddEnState.Items.Add(new ListItem("請選擇", "0"));
foreach (var item in codes)
{
ddEnState.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString()));
}
ddEnState.SelectedValue = "0";
CountyJson = JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
TownJson = JsonConvert.SerializeObject(SystemAreaCode.GetTownList(County));
VillageJson = JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Town));
}
}
/// <summary>
/// 轄區所屬Village
/// </summary>
/// <param name="OrgID"></param>
/// <param name="TownID"></param>
/// <returns></returns>
public static List <SystemAreaCodeVM> GetRegionVillageList(int OrgID, int TownID)
{
SystemOrgVM OrgVM = SystemOrg.GetVM(OrgID);
List <SystemAreaCodeVM> list = SystemAreaCode.GetVillageList(TownID);
if (OrgVM.OrgLevel == 4) //衛生所
{
List <int> RegionVillageIDs = new List <int>();
List <SystemOrgRegionVM> RegionList = GetOrgRegion(OrgID);
foreach (SystemOrgRegionVM r in RegionList)
{
if (SystemOrgRegion.dictRegionSetting.ContainsKey(r.RegionID))
{
RegionVillageIDs.AddRange(dictRegionSetting[r.RegionID].Select(l => l.VillageID).Distinct());
}
}
list = list.Where(ac => RegionVillageIDs.Contains(ac.ID)).ToList();
}
return(list);
}
/// <summary>
/// 轄區所屬County
/// </summary>
/// <param name="OrgID"></param>
/// <returns></returns>
public static List <SystemAreaCodeVM> GetRegionCountyList(int OrgID)
{
List <SystemAreaCodeVM> list = SystemAreaCode.GetCountyList();
SystemOrgVM OrgVM = SystemOrg.GetVM(OrgID);
//判斷是哪種level
if (OrgVM.OrgLevel == 4) //衛生所
{
List <int> RegionCountyIDs = new List <int>();
List <SystemOrgRegionVM> RegionList = GetOrgRegion(OrgID);
foreach (SystemOrgRegionVM r in RegionList)
{
List <SystemRegionSettingVM> SettingList = GetOrgRegionSetting(r.RegionID);
foreach (SystemRegionSettingVM s in SettingList)
{
RegionCountyIDs.Add(s.CountyID);
}
}
list = list.Where(ac => RegionCountyIDs.Contains(ac.ID)).ToList();
}
else
if (OrgVM.OrgLevel == 3 || OrgVM.OrgLevel == 2) //衛生局 管制中心
{
List <SystemOrgRegionCountyVM> CountyList = GetOrgRegionCounty(OrgID);
List <int> RegionCountyIDs = new List <int>();
foreach (SystemOrgRegionCountyVM rc in CountyList)
{
RegionCountyIDs.Add(rc.CountyID);
}
list = list.Where(ac => RegionCountyIDs.Contains(ac.ID)).ToList();
}
//level 1全部
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
ViewPower = base.GetPower(PowerList[0]);
UpdatePower = base.GetPower(PowerList[1]);
base.AllowHttpMethod("GET", "POST");
base.DisableTop(true);
base.BodyClass = "class='bodybg'";
int.TryParse(Request["i"], out ID);
if (ID == 0)
{
string script = "<script>alert('資料取得失敗');history.go(-1);</script>";
Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false);
return;
}
if (UpdatePower.HasPower == false)
{
tbAddress.Enabled = false;
tbTel.Enabled = false;
tbVaccine.Enabled = false;
ddAgState.Enabled = false;
//tbDepartment.Enabled = false;
}
if (this.IsPostBack == false)
{
DataSet ds = new DataSet();
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
using (SqlCommand cmd = new SqlCommand("dbo.usp_ParameterM_xGetAgencyByID", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AgencyInfoID", ID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(ds);
}
}
}
AgencyInfoVM VM = new AgencyInfoVM();
List <AddVaccineVM> list = new List <AddVaccineVM>();
EntityS.FillModel(VM, ds.Tables[0]);
EntityS.FillModel(list, ds.Tables[1]);
var dict = SystemCode.GetDict("LocationSettingM_Divisions");
StateListAry = JsonConvert.SerializeObject(dict);
var codes = SystemCode.dict["ParameterM_LocationSetting_AgencyState"];
ddAgState.Items.Add(new ListItem("請選擇", "0"));
foreach (var item in codes)
{
ddAgState.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString()));
}
ddAgState.SelectedValue = VM.AgencyState.ToString();
lblBsState.Text = VM.BusinessStateString;
//tbDepartment.Text = VM.Department;
County = VM.AgencyCounty;
Town = VM.AgencyTown;
Village = VM.AgencyVillage;
tbAddress.Text = VM.AgencyAddress;
tbTel.Text = VM.AgencyPhoneNumber;
tbSchedule.Text = VM.InoculationSchedule;
lblName.Text = VM.AgencyName;
lblCode.Text = VM.AgencyCode;
tbOrg.Text = VM.OrgName;
hfOrgID.Value = VM.OrgID.ToString();
//tbDepartment.Text = VM.Department;
tbVaccine.Text = string.Join(",", list.Select(item => item.VaccineCName));
tbOther = VM.DepartmentOther;
switch (VM.ReportingType)
{
case 1:
rb1.Checked = true;
break;
case 2:
rb2.Checked = true;
break;
case 3:
rb3.Checked = true;
break;
}
if (VM.IsSimpleFlu == false)
{
rbB1.Checked = true;
}
else
{
rbB2.Checked = true;
}
tbOtherIDs = VM.DepartmentIDs;
CountyJson = JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
TownJson = JsonConvert.SerializeObject(SystemAreaCode.GetTownList(County));
VillageJson = JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Town));
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.AllowHttpMethod("POST");
base.DisableTop(true);
int pgNow;
int pgSize;
int CountyID = 0;
int TownID = 0;
string BirthDateS;
string BirthDateE;
string CaseName;
string CaseIdNo;
string SearchReason;
string SearchConditions = "";
int SearcResultCount = 0;
int IsSearch = 0;
int SearchKind = 3;
BirthDateS = Request.Form["BirthDateS"] ?? "";
BirthDateE = Request.Form["BirthDateE"] ?? "";
if (BirthDateS != "")
{
try
{
//BirthDateS = Convert.ToDateTime(BirthDateS).ToString("yyyyMMdd");
BirthDateS = TaiwanYear.ToDateTime(BirthDateS).ToString("yyyyMMdd");
}
catch {
BirthDateS = "";
}
}
if (BirthDateE != "")
{
try
{
// BirthDateE = Convert.ToDateTime(BirthDateE).ToString("yyyyMMdd");
BirthDateE = TaiwanYear.ToDateTime(BirthDateE).ToString("yyyyMMdd");
}
catch
{
BirthDateE = "";
}
}
CaseName = Request.Form["CaseName"] ?? "";
CaseIdNo = Request.Form["CaseIdNo"] ?? "";
int.TryParse(Request.Form["pgNow"], out pgNow);
int.TryParse(Request.Form["pgSize"], out pgSize);
int.TryParse(Request.Form["CountyID"], out CountyID);
int.TryParse(Request.Form["TownID"], out TownID);
int.TryParse(Request.Form["IsSearch"], out IsSearch);
SearchReason = Request.Form["SearchReason"] ?? "";
List <UserProfileListVM> list = new List <UserProfileListVM>();
PageVM rtn = new PageVM();
DataSet ds = new DataSet();
try
{
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
using (SqlCommand cmd = new SqlCommand("dbo.usp_CaseUser_xGetUserList", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pgNow", pgNow == 0 ? 1 : pgNow);
cmd.Parameters.AddWithValue("@pgSize", pgSize == 0 ? 10 : pgSize);
cmd.Parameters.AddWithValue("@BirthDateS", BirthDateS);
cmd.Parameters.AddWithValue("@BirthDateE", BirthDateE);
cmd.Parameters.AddWithValue("@CaseName", CaseName);
cmd.Parameters.AddWithValue("@CaseIdNo", CaseIdNo);
cmd.Parameters.AddWithValue("@CountyID", CountyID);
cmd.Parameters.AddWithValue("@TownID", TownID);
//cmd.Parameters.AddWithValue("@IsSearch", IsSearch);
//cmd.Parameters.AddWithValue("@SearchReason", SearchReason);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(ds);
}
}
}
SearcResultCount = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
EntityS.FillModel(list, ds.Tables[0]);
EntityS.FillModel(rtn, ds.Tables[1]);
}
catch
{
}
finally {
//記下查詢紀錄
if (IsSearch == 1)
{
if (CaseName != "")
{
SearchConditions += "姓名：" + CaseName;
}
if (CaseIdNo != "")
{
SearchConditions += "身份證號：" + CaseIdNo;
}
if (BirthDateS != "")
{
SearchConditions += "生日起日：" + BirthDateS;
}
if (BirthDateE != "")
{
SearchConditions += "生日迄日：" + BirthDateE;
}
if (CountyID != 0)
{
SearchConditions += "戶籍縣市：" + SystemAreaCode.GetName(CountyID);
}
if (TownID != 0)
{
SearchConditions += "戶籍鄉鎮：" + SystemAreaCode.GetName(TownID);
}
Session["SearchID"] = Convert.ToInt32(DBUtil.DBOp("ConnDB", " exec [dbo].[usp_CaseUser_xAddSearchLog] {0}, {1}, {2} ,{3} ,{4}", new string[] { AuthServer.GetLoginUser().ID.ToString(), SearchConditions, SearchReason, SearcResultCount.ToString(), SearchKind.ToString() }, NSDBUtil.CmdOpType.ExecuteScalar));
}
}
rtn.message = list;
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn));
Response.End();
}
protected void CompareCaseUser()
{
string Col = "";
if (Session["ModifiedCaseToCheck"] != null)
{
//欲修改資料
m = (CaseUserProfile)Session["ModifiedCaseToCheck"];
//原資料
c = new CaseUserProfile(m.CaseID);
foreach (PropertyInfo prop in c.GetType().GetProperties())
{
string ValBefore = Convert.ToString(GetProperty(c, prop.Name));
string ValAfter = Convert.ToString(GetProperty(m, prop.Name));
if (ValBefore != ValAfter)
{
Col += prop.Name + ",";
}
//取得有變動的屬性
}
#region MyRegion
//if (m.BirthDate != c.BirthDate) Col += GetPropertyName(() => c.BirthDate) + ",";
//if (m.IdNo != c.IdNo) Col += GetPropertyName(() => c.IdNo) + ",";
//if (m.PassportNo != c.PassportNo) Col += GetPropertyName(() => c.PassportNo) + ",";
//if (m.ResNo != c.ResNo) Col += GetPropertyName(() => c.ResNo) + ",";
//if (m.ChName != c.ChName) Col += GetPropertyName(() => c.ChName) + ",";
//if (m.Gender != c.Gender) Col += GetPropertyName(() => c.Gender) + ",";
//if (m.HouseNo != c.HouseNo) Col += GetPropertyName(() => c.HouseNo) + ",";
//if (m.ResCounty != c.ResCounty) Col += GetPropertyName(() => c.ResCounty) + ",";
//if (m.ResTown != c.ResTown) Col += GetPropertyName(() => c.ResTown) + ",";
//if (m.PregWeek != c.PregWeek) Col += GetPropertyName(() => c.PregWeek) + ",";
//if (m.BirthNum != c.BirthNum) Col += GetPropertyName(() => c.BirthNum) + ",";
//if (m.BirthSeq != c.BirthSeq) Col += GetPropertyName(() => c.BirthSeq) + ",";
//if (m.BirthWeight != c.BirthWeight) Col += GetPropertyName(() => c.BirthWeight) + ",";
//if (m.BirthPlace != c.BirthPlace) Col += GetPropertyName(() => c.BirthPlace) + ",";
//if (m.Deliver != c.Deliver) Col += GetPropertyName(() => c.Deliver) + ",";
//if (m.DeliverOrg != c.DeliverOrg) Col += GetPropertyName(() => c.DeliverOrg) + ",";
//if (m.MarryStatus != c.MarryStatus) Col += GetPropertyName(() => c.MarryStatus) + ",";
//if (m.ResVillage != c.ResVillage) Col += GetPropertyName(() => c.ResVillage) + ",";
//if (m.ResAddr != c.ResAddr) Col += GetPropertyName(() => c.ResAddr) + ",";
//if (m.ResNei != (c.ResNei == "0" ? "" : c.ResNei)) Col += GetPropertyName(() => c.ResNei) + ",";
//if (m.EnName != c.EnName) Col += GetPropertyName(() => c.EnName) + ",";
//if (m.OtherNo != c.OtherNo) Col += GetPropertyName(() => c.OtherNo) + ",";
#endregion
//這些欄位需要上傳file
//再去看哪些需要 uploadfile
if (Col != "")
{
#region 再去看哪些需要 uploadfile
DataTable dt = (DataTable)DBUtil.DBOp("ConnDB"
, " SELECT NiisFieldName , ID, FieldDiscription, FileToCheck,SystemCodeKey FROM C_CaseCheck_FieldCheck where NiisFieldName in (select data from dbo.fn_slip_str({0},',') ) "
, new string[] { Col }
, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
string ViewBefore = Convert.ToString(GetProperty(c, r["NiisFieldName"].ToString()));
string ViewAfter = Convert.ToString(GetProperty(m, r["NiisFieldName"].ToString()));
string ValBefore = Convert.ToString(GetProperty(c, r["NiisFieldName"].ToString()));
string ValAfter = Convert.ToString(GetProperty(m, r["NiisFieldName"].ToString()));
string SystemCodeKey = r["SystemCodeKey"].ToString();
if (SystemCodeKey != "")
{
if (SystemCodeKey.Contains("County") || SystemCodeKey.Contains("Town") || SystemCodeKey.Contains("Village"))
{
ViewBefore = SystemAreaCode.GetName(Convert.ToInt32(Convert.ToString(GetProperty(c, r["NiisFieldName"].ToString()))));
ViewAfter = SystemAreaCode.GetName(Convert.ToInt32(Convert.ToString(GetProperty(m, r["NiisFieldName"].ToString()))));
}
else
{
int iViewBefore = 0;
int.TryParse(Convert.ToString(GetProperty(c, r["NiisFieldName"].ToString())), out iViewBefore);
int iViewAfter = 0;
int.TryParse(Convert.ToString(GetProperty(m, r["NiisFieldName"].ToString())), out iViewAfter);
ViewBefore = SystemCode.GetName(r["SystemCodeKey"].ToString(), iViewBefore);
ViewAfter = SystemCode.GetName(r["SystemCodeKey"].ToString(), iViewAfter);
}
}
CheckFieldVM cf = new CheckFieldVM();
cf.ID = Convert.ToInt32(r["ID"]);
cf.FieldName = r["NiisFieldName"].ToString();
cf.FieldDiscription = r["FieldDiscription"].ToString();
cf.ValBefore = ValBefore;
cf.ValAfter = ValAfter;
cf.ViewBefore = ViewBefore;
cf.ViewAfter = ViewAfter;
cf.FileCheck = r["FileToCheck"].ToString();
CheckFieldVMList.Add(cf);
//變成一個list 之後好操作
}
}
#endregion
}
}
if (Col == "" || CheckFieldVMList.Count == 0)
{
Response.Redirect("UserProfileList.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.AllowHttpMethod("POST");
base.DisableTop(true);
ViewPower = base.GetPower(PowerList[0]);
UpdatePower = base.GetPower(PowerList[1]);
ElementarySchoolID = GetNumber <int>("i");
if (ElementarySchoolID == 0)
{
IsValid = false;
string script = "<script>alert('資料取得失敗');history.go(-1);</script>";
Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false);
return;
}
if (this.IsPostBack == false)
{
uc1.TableName = "O_OrgLog";
uc1.WhereDict = new Dictionary <string, object>()
{
{ "@OrgID", ID }
};
DataTable dt = GetDataTable("ConnDB", "dbo.usp_CodeM_xGetElementarySchoolByID"
, new Dictionary <string, object>()
{
{ "@ElementarySchoolID", ElementarySchoolID }
});
SchoolCodeVM VM = new SchoolCodeVM();
EntityS.FillModel(VM, dt);
tbName.Text = VM.SchoolName;
tbCode.Text = VM.SchoolCode;
tbTel.Text = VM.SchoolPhoneNumber;
tbAddress.Text = VM.SchoolAddress;
County = VM.SchoolCounty;
Town = VM.SchoolTown;
Village = VM.SchoolVillage;
CountyName = SystemAreaCode.GetName(VM.SchoolCounty);
TownName = SystemAreaCode.GetName(VM.SchoolTown);
VillageName = SystemAreaCode.GetName(VM.SchoolVillage);
var codes = SystemCode.dict["CodeM_SchoolCode_EnableState"];
ddEnState.Items.Add(new ListItem("請選擇", "0"));
foreach (var item in codes)
{
ddEnState.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString()));
}
ddEnState.SelectedValue = VM.EnableState.ToString();
CountyJson = JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
TownJson = JsonConvert.SerializeObject(SystemAreaCode.GetTownList(County));
VillageJson = JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Town));
}
}
protected new void Page_Load(object sender, EventArgs e)
{
base.AllowHttpMethod("POST");
base.DisableTop(true);
ViewPower = base.GetPower(PowerList[0]);
UpdatePower = base.GetPower(PowerList[1]);
//if (UpdatePower.HasPower)
//{
// form1.DefaultButton = "btnSave";
//}
ID = GetNumber <int>("i");
ContractID = GetNumber <int>("i2");
if (ID == 0)
{
IsValid = false;
string script = "<script>alert('資料取得失敗');history.go(-1);</script>";
Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false);
return;
}
if (UpdatePower.HasPower == false)
{
tbAddress.Enabled = false;
tbTel.Enabled = false;
tbVaccine.Enabled = false;
ddlAgState.Enabled = false;
//tbDepartment.Enabled = false;
}
if (this.IsPostBack == false)
{
uc1.TableName = "O_OrgLog";
uc1.WhereDict = new Dictionary <string, object>()
{
{ "@OrgID", ID }
};
DataSet ds = MSDB.GetDataSet("ConnDB", "dbo.usp_ParameterM_xGetAgencyByID"
, new Dictionary <string, object>()
{
{ "@AgencyInfoID", ID }
});
AgencyInfoVM VM = new AgencyInfoVM();
List <AddVaccineVM> list = new List <AddVaccineVM>();
OrgContractVM VM2 = new OrgContractVM();
List <DayTimeVM> ddListIn = new List <DayTimeVM>();
List <DayTimeVM> ddListOut = new List <DayTimeVM>();
EntityS.FillModel(VM, ds.Tables[0]);
EntityS.FillModel(list, ds.Tables[1]);
EntityS.FillModel(VM2, ds.Tables[2]);
EntityS.FillModel(ddListIn, ds.Tables[3]);
foreach (var item in ddListIn)
{
DayTimeVM inVM = new DayTimeVM();
inVM.ID = item.ID;
inVM.Monday = item.Monday;
inVM.Tuesday = item.Tuesday;
inVM.Wednesday = item.Wednesday;
inVM.Thursday = item.Thursday;
inVM.Friday = item.Friday;
inVM.Saturday = item.Saturday;
inVM.Sunday = item.Sunday;
inVM.TimeAry = new List <Dictionary <string, string> >();
foreach (DataRow dr in ds.Tables[4].Rows)
{
if (item.ID == Convert.ToInt32(dr["BusinesssDayID"].ToString()))
{
Dictionary <string, string> ssee = new Dictionary <string, string>();
ssee.Add("ss", dr["StartTime"].ToString().Substring(0, 5));
ssee.Add("ee", dr["StartTime"].ToString().Substring(0, 5));
inVM.TimeAry.Add(ssee);
}
}
ddListOut.Add(inVM);
}
if (ddListOut.Count > 0)
{
ddListOutAry = JsonConvert.SerializeObject(ddListOut);
}
if (VM2.ID > 0)
{
ContractID = VM2.ID;
tbDateStart.Text = VM2.ContractStart.ToShortTaiwanDate();
tbDateEnd.Text = VM2.ContractEnd.ToShortTaiwanDate();
tbDateStop.Text = VM2.ContractStop.ToShortTaiwanDate();
if (tbDateStart.Text.Length == 0)
{
tbDateStart.Text = DateTime.Now.ToShortTaiwanDate();
}
}
var dict = SystemCode.GetDict("LocationSettingM_Divisions");
StateListAry = JsonConvert.SerializeObject(dict);
var codes = SystemCode.dict["ParameterM_LocationSetting_AgencyState"];
ddlAgState.Items.Add(new ListItem("請選擇", ""));
foreach (var item in codes)
{
ddlAgState.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString()));
}
ddlAgState.SelectedValue = VM.AgencyState.ToString();
AgencyState = VM.AgencyState.ToString();
lblBsState.Text = VM.BusinessStateString;
//tbDepartment.Text = VM.Department;
County = VM.AgencyCounty;
Town = VM.AgencyTown;
Village = VM.AgencyVillage;
CountyName = SystemAreaCode.GetName(VM.AgencyCounty);
TownName = SystemAreaCode.GetName(VM.AgencyTown);
VillageName = SystemAreaCode.GetName(VM.AgencyVillage);
tbAddress.Text = VM.AgencyAddress;
tbTelZone.Text = VM.PhoneAreaCode;
tbTel.Text = VM.AgencyPhoneNumber;
tbSchedule.Text = VM.InoculationSchedule;
ddlAgencyCate.SelectedValue = VM.AgencyCate.ToString();
lblName.Text = VM.AgencyName;
lblCode.Text = VM.AgencyCode;
tbOrg.Text = VM.OrgName;
hfOrgID.Value = VM.OrgID.ToString();
//tbDepartment.Text = VM.Department;
tbVaccine.Text = string.Join(",", list.Select(item => item.VaccineCName));
tbOther = VM.DepartmentOther;
switch (VM.ReportingType)
{
case 1:
rb1.Checked = true;
break;
case 2:
rb2.Checked = true;
break;
case 3:
rb3.Checked = true;
break;
case 4:
rb4.Checked = true;
break;
}
if (VM.IsSimpleFlu == false)
{
rbB1.Checked = true;
}
else
{
rbB2.Checked = true;
}
tbOtherIDs = VM.DepartmentIDs;
CountyJson = JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
TownJson = JsonConvert.SerializeObject(SystemAreaCode.GetTownList(County));
VillageJson = JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Town));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//long Process_MemoryStart = 0;
//long Process_MemoryEnd = 0;
//System.Diagnostics.Process MyProcess = System.Diagnostics.Process.GetCurrentProcess();
//Process_MemoryStart = MyProcess.PrivateMemorySize64;
//Response.Write(Process_MemoryStart);
//Console.WriteLine(Process_MemoryStart);
//Console.WriteLine(GC.GetTotalMemory(true).ToString());
SystemCode.Update();
SystemRole.Update();
SystemRoleOrg.Update();
SystemAreaCode.Update();
//Process_MemoryEnd = MyProcess.PrivateMemorySize64;
//Response.Write(Process_MemoryEnd);
//Console.WriteLine(Process_MemoryEnd);
//HomeUrlVM vm =new HomeUrlVM();
//vm.PageUrl = "/System/CodeM/CodeSetting.aspx";
//vm.date = DateTime.Now;
//string s = JsonConvert.SerializeObject(vm);
//s=QueryStringEncryptToolS.Encrypt(s);
//s = HttpUtility.UrlEncode(s);
//Response.Write(s);
//Response.End();
//HomeUrlSecret secret = new HomeUrlSecret();
//secret.RedirectUrl = "Home";
//string s=JsonConvert.SerializeObject(secret);
//UrlParameterEncryptT EncryptT = new UrlParameterEncryptT();
//UrlParameterDecryptT DecryptT = new UrlParameterDecryptT();
//s = EncryptT.GetOutSecretJsonWithEncrypt(secret);
//string ss = s;
//int cc = s.Length;
//Response.Write(s);
//Response.Write("<br/>");
//Response.Write(s.Length);
//s = HttpUtility.UrlEncode(s);
//Response.Write("<br/>");
//Response.Write(s);
//Response.Write("<br/>");
//Response.Write(s.Length);
//Response.Write("<br/>");
//string a = Request["o"]??"";
//int b = 0;
//int.TryParse(Request["c"] ?? "0", out b);
//HomeUrlSecret secret2 = new HomeUrlSecret();
//secret2 = DecryptT.GetUrlSecret<HomeUrlSecret>(ss, TimeSpan.FromDays(1), cc);
//if(secret2.IsValid==true)
// Response.Write("2Checksum驗證成功");
//else
// Response.Write("2Checksum驗證失敗");
//Response.End();
}
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 BindData()
{
DataSet ds = new DataSet();
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
using (SqlCommand cmd = new SqlCommand("dbo.usp_CaseUser_xGetCaseUser", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CaseID", CaseID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(ds);
}
}
}
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
BirthDate.Text = dt.Rows[0]["BirthDateSimple"].ToString();
tbIdNo.Text = dt.Rows[0]["IdNo"].ToString();
tbPassportNo.Text = dt.Rows[0]["PassportNo"].ToString();
tbResNo.Text = dt.Rows[0]["ResNo"].ToString();
tbOtherNo.Text = dt.Rows[0]["OtherNo"].ToString();
tbName.Text = dt.Rows[0]["ChName"].ToString();
tbEngName.Text = dt.Rows[0]["EnName"].ToString();
ddlGender.SelectedValue = dt.Rows[0]["Gender"].ToString();
tbHouseNo.Text = dt.Rows[0]["HouseNo"].ToString();
ddlONationality.SelectedValue = dt.Rows[0]["ONationality"].ToString();
foreach (string s in dt.Rows[0]["Language"].ToString().Split(','))
{
foreach (ListItem i in cblLang.Items)
{
if (i.Value == s)
{
i.Selected = true;
}
}
}
;
foreach (string s in dt.Rows[0]["Capacity"].ToString().Split(','))
{
foreach (ListItem i in cblCapacity.Items)
{
if (i.Value == s)
{
i.Selected = true;
}
}
}
;
CountyInival = dt.Rows[0]["ConCounty"].ToString();
TownAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetTownList(Convert.ToInt32(dt.Rows[0]["ConCounty"])));
TownInival = dt.Rows[0]["ConTown"].ToString();
VillageAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Convert.ToInt32(dt.Rows[0]["ConTown"])));
VillageInival = dt.Rows[0]["ConVillage"].ToString();
ResCountyInival = dt.Rows[0]["ResCounty"].ToString();
ResTownAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetTownList(Convert.ToInt32(dt.Rows[0]["ConCounty"])));
ResTownInival = dt.Rows[0]["ResTown"].ToString();
ResVillageAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Convert.ToInt32(dt.Rows[0]["ConTown"])));
ResVillageInival = dt.Rows[0]["ResVillage"].ToString();
//if (SystemAreaCode.dict.ContainsKey("County"))
//{
// List<SystemAreaCodeVM> SystemAreaCodeList = SystemAreaCode.dict["County"];
// ddlResCounty.Items.Clear();
// ddlResCounty.Items.Add(new ListItem("縣市", ""));
// foreach (SystemAreaCodeVM sc in SystemAreaCodeList)
// ddlResCounty.Items.Add(new ListItem(sc.AreaName, sc.ID.ToString()));
// ddlResCounty.SelectedValue = dt.Rows[0]["ResCounty"].ToString();
//}
//if (SystemAreaCode.dict.ContainsKey("Town"))
//{
// List<SystemAreaCodeVM> SystemAreaCodeList = SystemAreaCode.dict["Town"];
// ddlResTown.Items.Clear();
// ddlResTown.Items.Add(new ListItem("鄉鎮市區", ""));
// foreach (SystemAreaCodeVM sc in SystemAreaCodeList)
// ddlResTown.Items.Add(new ListItem(sc.AreaName, sc.ID.ToString()));
// ddlResTown.SelectedValue = dt.Rows[0]["ResTown"].ToString();
//}
tbArea.Text = "";
tbPregWeek.Text = dt.Rows[0]["PregWeek"].ToString();
tbBirthNum.Text = dt.Rows[0]["BirthNum"].ToString();
tbBirthSeq.Text = dt.Rows[0]["BirthSeq"].ToString();
tbBirthWeight.Text = dt.Rows[0]["BirthWeight"].ToString();
ddlBirthPlace.SelectedValue = dt.Rows[0]["BirthPlace"].ToString();
ddlDeliver.SelectedValue = dt.Rows[0]["Deliver"].ToString();
tbDeliverOrg.Text = dt.Rows[0]["DeliverOrg"].ToString();
ddlMarryStatus.SelectedValue = dt.Rows[0]["MarryStatus"].ToString();
tbEduLevel.Text = dt.Rows[0]["EduLevel"].ToString();
tbElemSchool.Text = dt.Rows[0]["ElemSchool"].ToString();
tbOccupation.Text = dt.Rows[0]["Occupation"].ToString();
tbEduLevel.Text = dt.Rows[0]["EduLevel"].ToString();
tbEduLevel.Text = dt.Rows[0]["EduLevel"].ToString();
//cmd.Parameters.AddWithValue("@TelDayArea", "03");
//cmd.Parameters.AddWithValue("@TelDayNo", "12345678");
//cmd.Parameters.AddWithValue("@TelDayExt", "90");
//cmd.Parameters.AddWithValue("@TelNightArea", "03");
//cmd.Parameters.AddWithValue("@TelNightNo", "12345678");
//cmd.Parameters.AddWithValue("@TelNightExt", "90");
tbResAddr.Text = dt.Rows[0]["ResAddr"].ToString();
tbConAddr.Text = dt.Rows[0]["ConAddr"].ToString();
tbBirthMulti.Text = dt.Rows[0]["BirthMulti"].ToString();
tbTelDayArea.Text = dt.Rows[0]["TelDayArea"].ToString();
tbTelDayNo.Text = dt.Rows[0]["TelDayNo"].ToString();
tbTelDayExt.Text = dt.Rows[0]["TelDayExt"].ToString();
tbTelNightArea.Text = dt.Rows[0]["TelNightArea"].ToString();
tbTelNightNo.Text = dt.Rows[0]["TelNightNo"].ToString();
tbTelNightExt.Text = dt.Rows[0]["TelNightExt"].ToString();
tbImmiType.Text = SystemCode.GetName("CaseUser_ImmiType", Convert.ToInt32(dt.Rows[0]["ImmiType"]));
ltBirthDate.Text = dt.Rows[0]["BirthDateSimple"].ToString();
ltIdNo.Text = dt.Rows[0]["IdNo"].ToString();
ltName.Text = dt.Rows[0]["ChName"].ToString();
ltGender.Text = ddlGender.SelectedItem.Text;
MainContactInival = Convert.ToString(DBUtil.DBOp("ConnDB", " select isnull((SELECT top 1 [ContactID] FROM [dbo].[C_CaseUserContact] where [LogicDel]=0 and [CaseID]={0} and [IsMain]=1),0) ", new string[] { CaseID.ToString() }, NSDBUtil.CmdOpType.ExecuteScalar));
CaseIDdiv.Controls.Add(GetControlFromTag(CaseID.ToString()));
BindComment();
BindContact();
BindMobile();
BindEmail();
}
}
protected void Page_Init(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BirthDate.Attributes.Add("onclick", "WdatePicker({ dateFmt: 'yyyMMdd', lang: 'zh-tw' })");
BirthDateImg.Attributes.Add("onclick", "WdatePicker({ el:'" + BirthDate.ClientID + "',dateFmt: 'yyyMMdd', lang: 'zh-tw' })");
// SystemCode.UpdateSystemCode();
if (SystemCode.dict.ContainsKey("CaseUser_ONationality"))
{
List <SystemCodeVM> SystemCodeList = SystemCode.dict["CaseUser_ONationality"];
foreach (SystemCodeVM sc in SystemCodeList)
{
ddlONationality.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString()));
}
}
if (SystemCode.dict.ContainsKey("CaseUser_Language"))
{
List <SystemCodeVM> SystemCodeList = SystemCode.dict["CaseUser_Language"];
foreach (SystemCodeVM sc in SystemCodeList)
{
cblLang.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString()));
}
}
if (SystemCode.dict.ContainsKey("CaseUser_Capacity"))
{
List <SystemCodeVM> SystemCodeList = SystemCode.dict["CaseUser_Capacity"];
foreach (SystemCodeVM sc in SystemCodeList)
{
cblCapacity.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString()));
}
}
// SystemAreaCode.Update();
#region 戶籍地址
//ddlResCounty.Items.Add(new ListItem("請選擇縣市", "0"));
//ddlResCounty.Enabled = false;
//ddlResTown.Items.Add(new ListItem("鄉鎮市區", "0"));
//ddlResTown.Enabled = false;
//ddlResVillage.Items.Add(new ListItem("村里", "0"));
//ddlResVillage.Enabled = false;
#endregion
#region 聯絡地址
CountyAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
// List<SystemAreaCodeVM> CityList = SystemAreaCode.GetCountyList();
ddlConCounty.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlConCounty.Attributes.Add("ng-change", "SelectConCountyChange()");
ddlConCounty.Attributes.Add("ng-model", "VM.SelectCounty");
ddlConCounty.Attributes.Add("class", "ConCounty");
ddlConCounty.Items[0].Attributes.Add("ng-repeat", "option in VM.CountyAry");
// foreach (SystemAreaCodeVM sc in CityList) ddlConCounty.Items.Add(new ListItem(sc.AreaName, sc.ID.ToString()));
ddlConTown.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlConTown.Attributes.Add("class", "ConTown");
ddlConTown.Attributes.Add("ng-change", "SelectConTownChange()");
ddlConTown.Attributes.Add("ng-model", "VM.SelectTown");
ddlConTown.Items[0].Attributes.Add("ng-repeat", "option in VM.TownAry");
ddlConVillage.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlConVillage.Attributes.Add("class", "ConVillage");
ddlConVillage.Attributes.Add("ng-model", "VM.SelectVillage");
ddlConVillage.Items[0].Attributes.Add("ng-repeat", "option in VM.VillageAry");
#endregion
#region 戶籍地址
ResCountyAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
ddlResCounty.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlResCounty.Attributes.Add("ng-change", "SelectResCountyChange()");
ddlResCounty.Attributes.Add("ng-model", "VM.SelectResCounty");
ddlResCounty.Attributes.Add("class", "ResCounty");
ddlResCounty.Items[0].Attributes.Add("ng-repeat", "option in VM.ResCountyAry");
ddlResTown.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlResTown.Attributes.Add("class", "ResTown");
ddlResTown.Attributes.Add("ng-change", "SelectResTownChange()");
ddlResTown.Attributes.Add("ng-model", "VM.SelectResTown");
ddlResTown.Items[0].Attributes.Add("ng-repeat", "option in VM.ResTownAry");
ddlResVillage.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlResVillage.Attributes.Add("class", "ResVillage");
ddlResVillage.Attributes.Add("ng-model", "VM.SelectResVillage");
ddlResVillage.Items[0].Attributes.Add("ng-repeat", "option in VM.ResVillageAry");
#endregion
}
}
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
{
}
}
}
protected void BindData()
{
CaseUserProfile c = new CaseUserProfile(CaseID);
if (c.CaseID > 0)
{
BirthDate.Text = c.BirthDate;
tbIdNo.Text = c.IdNo;
tbPassportNo.Text = c.PassportNo;
tbResNo.Text = c.ResNo;
tbOtherNo.Text = c.OtherNo;
tbName.Text = c.ChName;
tbEngName.Text = c.EnName;
ddlGender.SelectedValue = c.Gender.ToString();
tbHouseNo.Text = c.HouseNo;
ddlONationality.SelectedValue = c.ONationality.ToString();
foreach (string s in c.Language)
{
foreach (ListItem i in cblLang.Items)
{
if (i.Value == s)
{
i.Selected = true;
}
}
}
;
foreach (string s in c.Capacity)
{
for (int i = 1; i <= 4; i++)
{
CheckBoxList cblist = (CheckBoxList)form1.FindControl("cblCapacity_" + i.ToString());
foreach (ListItem li in cblist.Items)
{
if (li.Value == s)
{
li.Selected = true;
}
}
;
}
}
CountyInival = c.ConCounty.ToString();
TownAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetTownList(Convert.ToInt32(c.ConCounty)));
TownInival = c.ConTown.ToString();
VillageAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Convert.ToInt32(c.ConTown)));
VillageInival = c.ConVillage.ToString();
ResCountyInival = c.ResCounty.ToString();
ResTownAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetTownList(Convert.ToInt32(c.ResCounty)));
ResTownInival = c.ResTown.ToString();
ResVillageAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Convert.ToInt32(c.ResTown)));
ResVillageInival = c.ResVillage.ToString();
tbArea.Text = "";
tbPregWeek.Text = c.PregWeek.ToString();
tbBirthNum.Text = c.BirthNum.ToString();
tbBirthSeq.Text = c.BirthSeq.ToString();
tbBirthWeight.Text = c.BirthWeight.ToString();
ddlBirthPlace.SelectedValue = c.BirthPlace.ToString();
ddlDeliver.SelectedValue = c.Deliver.ToString();
tbDeliverOrg.Text = c.DeliverOrg;
ddlMarryStatus.SelectedValue = c.MarryStatus;
tbEduLevel.Text = c.EduLevel;
tbElemSchool.Text = c.ElemSchool;
tbOccupation.Text = c.Occupation;
tbEduLevel.Text = c.EduLevel;
tbResAddr.Text = c.ResAddr;
tbConAddr.Text = c.ConAddr;
tbResNei.Text = (c.ResNei == 0 ? "":c.ResNei.ToString());
tbConNei.Text = (c.ConNei == 0 ? "" : c.ConNei.ToString());
ddlBirthMulti.SelectedValue = c.BirthMulti.ToString();
tbTelDayArea.Text = c.TelDayArea;
tbTelDayNo.Text = c.TelDayNo;
tbTelDayExt.Text = c.TelDayExt;
tbTelNightArea.Text = c.TelNightArea;
tbTelNightNo.Text = c.TelNightNo;
tbTelNightExt.Text = c.TelNightExt;
tbImmiType.Text = c.ImmiTypeName;
tbArea.Text = c.RegionName;
ltBirthDate.Text = c.BirthDate;
ltIdNo.Text = c.IdNo;
ltName.Text = c.ChName;
ltGender.Text = Server.HtmlEncode(ddlGender.SelectedItem.Text);
ltAgeTip.Text = c.AgeTip;
// MainContactInival = Convert.ToString(DBUtil.DBOp("ConnDB", " select isnull((SELECT top 1 [ContactID] FROM [dbo].[C_CaseUserContact] where [LogicDel]=0 and [CaseID]={0} and [IsMain]=1),0) ", new string[] { CaseID.ToString() }, NSDBUtil.CmdOpType.ExecuteScalar));
// MainContactInival = c.MainContactCaseID.ToString();
MainContactInival = Convert.ToString(DBUtil.DBOp("ConnDB", " select isnull((SELECT top 1 [ContactID] FROM [dbo].[C_CaseUserContact] where [LogicDel]=0 and [CaseID]={0} and [IsMain]=1),0) ", new string[] { CaseID.ToString() }, NSDBUtil.CmdOpType.ExecuteScalar));
CaseIDdiv.Controls.Add(GetControlFromTag(CaseID.ToString()));
string MobileFormat = "<div class=\"MobileDetail\"><input name=\"tbMobileNo_{0}\" type=\"text\" value=\"{1}\" class=\"text03 tbMobile\" /><a onclick =\"javascript:void(0);\" class=\"DelMobile\"><img src=\"/images/icon_del.png\" /></a><a onclick =\"javascript:void(0);\" class=\"AddMobile\"><img src=\"/images/icon_increase.png\" /></a></div>";
foreach (UserMobile um in c.Mobiles)
{
MobileDIV.Controls.Add(GetControlFromTag(string.Format(MobileFormat, um.ID, um.Mobile)));
}
string EmailFormat = "<div class=\"EmailDetail\"><input name=\"tbEmail_{0}\" type=\"text\" value=\"{1}\" class=\"text03 tbEmail\" /><a onclick =\"javascript:void(0);\" class=\"DelEmail\"><img src=\"/images/icon_del.png\" /></a><a onclick =\"javascript:void(0);\" class=\"AddEmail\"><img src=\"/images/icon_increase.png\" /></a></div>";
foreach (UserEmail ue in c.Emails)
{
EmailDIV.Controls.Add(GetControlFromTag(string.Format(EmailFormat, ue.ID, ue.Email)));
}
//info
ltCreateInfo.Text = c.CreateInfo;
ltModifyInfo.Text = c.ModifyInfo;
//李小明 - 衛生福利部疾病管制署 - 104/5/19 14:23:45
}
}
protected void Page_Init(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
int.TryParse(Request.Form["i"], out CaseID);
BirthDate.Attributes.Add("onclick", "WdatePicker({ dateFmt: 'yyyMMdd', lang: 'zh-tw' })");
BirthDateImg.Attributes.Add("onclick", "WdatePicker({ el:'" + BirthDate.ClientID + "',dateFmt: 'yyyMMdd', lang: 'zh-tw' })");
SystemCodeControl.ServerSelect(ref ddlONationality, "CaseUser_ONationality");
SystemCodeControl.ServerCheckBox(ref cblLang, "CaseUser_Language");
cblLang.Attributes.Add("style", "display:inline-block;");
SystemCodeControl.ServerSelect(ref ddlBirthMulti, "CaseUser_BirthMulti");
SystemCodeControl.ServerSelect(ref ddlGender, "CaseUser_Gender");
//身份別有4種
DataTable CapDt = (DataTable)DBUtil.DBOp("ConnDB", "SELECT [ID] ,[CapacityCate] ,[TypeName] ,[bCanEdit] FROM [dbo].[C_CaseUserCapacity_Type] order by [CapacityCate] ,[ID]", new string[] { }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
foreach (DataRow r in CapDt.Rows)
{
CheckBoxList cblist = (CheckBoxList)form1.FindControl("cblCapacity_" + r["CapacityCate"].ToString());
ListItem li = new ListItem(r["TypeName"].ToString(), r["ID"].ToString());
li.Enabled = Convert.ToBoolean(r["bCanEdit"]);
if (li.Enabled || CaseID > 0)
{
cblist.Items.Add(li);
}
if (cblist.Items.Count > 0 || CaseID > 0)
{
form1.FindControl("tr_cblCapacity_" + r["CapacityCate"].ToString()).Visible = true;
}
}
#region 聯絡地址
CountyAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
ddlConCounty.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlConCounty.Attributes.Add("ng-change", "SelectConCountyChange()");
ddlConCounty.Attributes.Add("ng-model", "VM.SelectCounty");
ddlConCounty.Attributes.Add("class", "ConCounty");
ddlConCounty.Items[0].Attributes.Add("ng-repeat", "option in VM.CountyAry");
ddlConTown.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlConTown.Attributes.Add("class", "ConTown");
ddlConTown.Attributes.Add("ng-change", "SelectConTownChange()");
ddlConTown.Attributes.Add("ng-model", "VM.SelectTown");
ddlConTown.Items[0].Attributes.Add("ng-repeat", "option in VM.TownAry");
ddlConVillage.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlConVillage.Attributes.Add("class", "ConVillage");
ddlConVillage.Attributes.Add("ng-model", "VM.SelectVillage");
ddlConVillage.Items[0].Attributes.Add("ng-repeat", "option in VM.VillageAry");
#endregion
#region 戶籍地址
ResCountyAry = Newtonsoft.Json.JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
ddlResCounty.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlResCounty.Attributes.Add("ng-change", "SelectResCountyChange()");
ddlResCounty.Attributes.Add("ng-model", "VM.SelectResCounty");
ddlResCounty.Attributes.Add("class", "ResCounty");
ddlResCounty.Items[0].Attributes.Add("ng-repeat", "option in VM.ResCountyAry");
ddlResTown.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlResTown.Attributes.Add("class", "ResTown");
ddlResTown.Attributes.Add("ng-change", "SelectResTownChange()");
ddlResTown.Attributes.Add("ng-model", "VM.SelectResTown");
ddlResTown.Items[0].Attributes.Add("ng-repeat", "option in VM.ResTownAry");
ddlResVillage.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
ddlResVillage.Attributes.Add("class", "ResVillage");
ddlResVillage.Attributes.Add("ng-model", "VM.SelectResVillage");
ddlResVillage.Items[0].Attributes.Add("ng-repeat", "option in VM.ResVillageAry");
#endregion
ddlMainContact.Items.Add(new ListItem("{{option.N}}", "{{option.I}}"));
//ddlMainContact.Attributes.Add("ng-change", "SelectConCountyChange()");
ddlMainContact.Attributes.Add("ng-model", "VM.SelectMainContact");
ddlMainContact.Attributes.Add("class", "SelectMainContact");
ddlMainContact.Items[0].Attributes.Add("ng-repeat", "option in VM.MainContactAry");
// ddlMainContact.Items[0].Attributes.Add("selected", "{{ option.S == '1' ? 'selected' : '' }}");
//ltDDLCommentKind.Text = HtmlSelect("","ddlCommentKind", "CaseUser_RemarkType", "");
}
}
