protected void btnCheck_Click(object sender, EventArgs e)
{
CaseUserProfile c = GetModifyCase();
c.SimpleUpdate();
SaveEmailMobiles(c.CaseID);
Session["ModifiedCaseToCheck"] = c;
Response.Redirect("UpdateReview.aspx");
}
protected void BindData()
{
string MobileFormat = "<div id=\"MobileDetail\"><input name=\"tbMobileNo_{0}\" type=\"text\" value=\"{1}\" class=\"text02\" /><a onclick =\"javascript:void(0);\" class=\"DelPS\"><img src=\"/images/icon_del.png\" /></a><a onclick =\"javascript:void(0);\" class=\"AddPS\"><img src=\"/images/icon_increase.png\" /></a></div>";
string EmailFormat = "<div id=\"EmailDetail\"><input name=\"tbEmail_{0}\" type=\"text\" value=\"{1}\" class=\"text02\" /><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>";
if (ContactID != 0)
{
UserContact uc = new UserContact(ContactID);
ContactCaseID = uc.ContactCaseID;
CaseID = uc.CaseID;
Session["UserContract_ContactCaseID"] = ContactCaseID;
Session["UserContract_CaseID"] = CaseID;
ddlRS.SelectedValue = uc.RelationShip.ToString();
cbMain.Checked = uc.IsMain;
}
CaseUserProfile c = new CaseUserProfile(ContactCaseID);
if (c.CaseID != 0)
{
ltBirthDate.Text = Server.HtmlEncode(c.BirthDate);
ltIdNo.Text = Server.HtmlEncode(c.IdNo);
ltName.Text = Server.HtmlEncode(c.ChName);
tbTelDayArea.Text = c.TelDayArea;
tbTelDayNo.Text = c.TelDayNo;
tbTelDayExt.Text = c.TelDayExt;
tbTelNightArea.Text = c.TelNightArea;
tbTelNightNo.Text = c.TelNightNo;
tbTelNightExt.Text = c.TelNightExt;
foreach (UserMobile m in c.Mobiles)
{
MobileDIV.Controls.Add(GetControlFromTag(string.Format(MobileFormat, m.ID, m.Mobile)));
}
foreach (UserEmail m in c.Emails)
{
EmailDIV.Controls.Add(GetControlFromTag(string.Format(EmailFormat, m.ID, m.Email)));
}
}
}
protected void BindData()
{
CaseUserProfile c = new CaseUserProfile();
c.GetProfileWithMother(iCaseID);
if (c.CaseID > 0)
{
ltName.Text = c.ChName;
ltBirthDate.Text = c.BirthDate;
ltHouseNo.Text = c.HouseNo;
ltIdNo.Text = c.IdNo;
ltGender.Text = c.GenderName;
ltLang.Text = c.LanguageName;
ltConAddr.Text = c.ConFullAddress;
ltMotherName.Text = c.MotherName;
ltMotherIdNo.Text = c.MotherIdNo;
ltMotherBirthDate.Text = c.MotherBirthDate;
ltCap.Text = c.CapacityName;
ltResAddr.Text = c.ResFullAddress;
ltRegionName.Text = c.RegionName;
}
}
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");
int ContactID = 0;
int.TryParse(Request["ContactID"], out ContactID);
StringBuilder sb = new StringBuilder("");
JsonReply r = new JsonReply();
int ContactCaseID = 0;
int CaseID = 0;
//SqlCommand cmd = new SqlCommand("dbo.usp_CaseUser_xGetCaseUserContact");
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@ContactID", ContactID);
//DataTable dt = DB.GetDataTable(cmd, "ConnDB");
//if (dt.Rows.Count > 0)
//{
// sb.Append("<table>");
// sb.AppendFormat("<tr><td style='width:90px'>{0}</td><td>{1}</td></tr>", "電話(日)：", dt.Rows[0]["TelDayArea"].ToString() + ' ' + dt.Rows[0]["TelDayNo"].ToString() + "分機" + dt.Rows[0]["TelDayExt"].ToString());
// sb.AppendFormat("<tr><td>{0}</td><td>{1}</td></tr>", "電話(夜)：", dt.Rows[0]["TelNightArea"].ToString() + ' ' + dt.Rows[0]["TelNightNo"].ToString() + "分機" + dt.Rows[0]["TelNightExt"].ToString());
// sb.AppendFormat("<tr><td>{0}</td><td>{1}</td></tr>", "行動電話：", BindMobile(ContactCaseID));
// sb.AppendFormat("<tr><td>{0}</td><td>{1}</td></tr>", "電子郵件：", BindEmail(ContactCaseID));
// sb.Append("</table>");
//}
r = new JsonReply();
if (ContactID != 0)
{
UserContact uc = new UserContact(ContactID);
ContactCaseID = uc.ContactCaseID;
CaseID = uc.CaseID;
}
CaseUserProfile c = new CaseUserProfile(ContactCaseID);
if (c.CaseID != 0)
{
sb.Append("<table>");
sb.AppendFormat("<tr><td style='width:90px'>{0}</td><td>{1}</td></tr>", "姓名：", c.ChName);
sb.AppendFormat("<tr><td>{0}</td><td>{1}</td></tr>", "電話(日)：", c.TelDayArea + ' ' + c.TelDayNo + (c.TelDayExt != "" ? "分機" + c.TelDayExt :""));
sb.AppendFormat("<tr><td>{0}</td><td>{1}</td></tr>", "電話(夜)：", c.TelNightArea + ' ' + c.TelNightNo + (c.TelNightExt != "" ? "分機" + c.TelNightExt : ""));
sb.AppendFormat("<tr><td>{0}</td><td style='white-space: pre-wrap;'>{1}</td></tr>", "行動電話：", String.Join("\n", c.Mobiles.Select(m => m.Mobile).ToArray()));
sb.AppendFormat("<tr><td>{0}</td><td style='white-space: pre-wrap;'>{1}</td></tr>", "電子郵件：", String.Join("\n", c.Emails.Select(m => m.Email).ToArray()));
sb.Append("</table>");
//ltBirthDate.Text = c.BirthDate;
//ltIdNo.Text = c.IdNo;
//ltName.Text = c.ChName;
;
}
r.RetCode = 1;
r.Content = sb.ToString();
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(r));
Response.End();
}
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 CaseUserProfile GetModifyCase()
{
string ResCounty = Request[ddlResCounty.ClientID.Replace("_", "$")] ?? "";
string ResTown = Request[ddlResTown.ClientID.Replace("_", "$")] ?? "";
string ResVillage = Request[ddlResVillage.ClientID.Replace("_", "$")] ?? "";
string ConCounty = Request[ddlConCounty.ClientID.Replace("_", "$")] ?? "";
string ConTown = Request[ddlConTown.ClientID.Replace("_", "$")] ?? "";
string ConVillage = Request[ddlConVillage.ClientID.Replace("_", "$")] ?? "";
int iGender, iResCounty, iResTown, iResVillage, iConCounty, iConTown
, iConVillage, iPregWeek, iBirthNum, iBirthSeq, iBirthWeight
, iBirthPlace, iDeliver, iBirthMulti, iResNei, iConNei
, iONationality;
int.TryParse(ddlGender.SelectedValue, out iGender);
int.TryParse(ddlONationality.SelectedValue, out iONationality);
int.TryParse((ResCounty != "" ? ResCounty : "0"), out iResCounty);
int.TryParse((ResTown != "" ? ResTown : "0"), out iResTown);
int.TryParse((ResVillage != "" ? ResVillage : "0"), out iResVillage);
int.TryParse((tbResNei.Text.Trim() == "" ? "0" : tbResNei.Text.Trim()), out iResNei);
int.TryParse((ConCounty != "" ? ConCounty : "0"), out iConCounty);
int.TryParse((ConTown != "" ? ConTown : "0"), out iConTown);
int.TryParse((ConVillage != "" ? ConVillage : "0"), out iConVillage);
int.TryParse((tbConNei.Text.Trim() == "" ? "0" : tbConNei.Text.Trim()), out iConNei);
int.TryParse((tbPregWeek.Text.Trim() == "" ? "0" : tbPregWeek.Text.Trim()), out iPregWeek);
int.TryParse((tbBirthNum.Text.Trim() == "" ? "0" : tbBirthNum.Text.Trim()), out iBirthNum);
int.TryParse((tbBirthSeq.Text.Trim() == "" ? "0" : tbBirthSeq.Text.Trim()), out iBirthSeq);
int.TryParse((tbBirthWeight.Text.Trim() == "" ? "0" : tbBirthWeight.Text.Trim()), out iBirthWeight);
int.TryParse(ddlBirthPlace.SelectedValue, out iBirthPlace);
int.TryParse(ddlBirthMulti.SelectedValue, out iBirthMulti);
int.TryParse(ddlDeliver.SelectedValue, out iDeliver);
CaseUserProfile c = new CaseUserProfile();
c.CaseID = CaseID;
c.BirthDate = BirthDate.Text;
c.IdNo = tbIdNo.Text;
c.PassportNo = tbPassportNo.Text;
c.ResNo = tbResNo.Text;
c.OtherNo = tbOtherNo.Text;
c.ChName = tbName.Text;
c.EnName = tbEngName.Text;
c.Gender = iGender;
c.HouseNo = tbHouseNo.Text;
c.ONationality = iONationality;
c.Language = String.Join(",", cblLang.Items.OfType <ListItem>().Where(r => r.Selected).Select(r => r.Value)).Split(',');
c.Capacity = String.Join(",",
String.Join(",", cblCapacity_1.Items.OfType <ListItem>().Where(r => r.Selected).Select(r => r.Value))
, String.Join(",", cblCapacity_2.Items.OfType <ListItem>().Where(r => r.Selected).Select(r => r.Value))
, String.Join(",", cblCapacity_3.Items.OfType <ListItem>().Where(r => r.Selected).Select(r => r.Value))
, String.Join(",", cblCapacity_4.Items.OfType <ListItem>().Where(r => r.Selected).Select(r => r.Value))
).Split(',');
c.ResCounty = iResCounty;
c.ResTown = iResTown;
c.ResVillage = iResVillage;
c.ResNei = iResNei;
c.ConNei = iConNei;
c.ConCounty = iConCounty;
c.ConTown = iConTown;
c.ConVillage = iConVillage;
c.PregWeek = iPregWeek;
c.BirthNum = iBirthNum;
c.BirthSeq = iBirthSeq;
c.BirthWeight = iBirthWeight;
c.BirthPlace = iBirthPlace;
c.BirthMulti = iBirthMulti;
c.Deliver = iDeliver;
c.DeliverOrg = tbDeliverOrg.Text;
c.MarryStatus = ddlMarryStatus.SelectedValue;
c.EduLevel = tbEduLevel.Text;
c.ElemSchool = tbElemSchool.Text;
c.Occupation = tbOccupation.Text;
c.TelDayArea = tbTelDayArea.Text;
c.TelDayNo = tbTelDayNo.Text;
c.TelDayExt = tbTelDayExt.Text;
c.TelNightArea = tbTelNightArea.Text;
c.TelNightNo = tbTelNightNo.Text;
c.TelNightExt = tbTelNightExt.Text;
c.ResAddr = tbResAddr.Text;
c.ConAddr = tbConAddr.Text;
//電話 email
return(c);
}
protected void btnSave_Click(object sender, EventArgs e)
{
//if (BirthDate.Text.Length == 6)
// BirthDate.Text = "0" + BirthDate.Text;
//string BrithDate = (Convert.ToInt32 (BirthDate.Text.Substring(0, 3))+1911).ToString () + "/" + BirthDate.Text.Substring(3, 2) + "/" + BirthDate.Text.Substring(5, 2) ;
//int ApplyID = 0;
//DataSet ds = new DataSet();
//using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
//{
// string sqlpoName = "dbo.usp_CaseUser_xAddCaseUser";
// if (CaseID != 0) sqlpoName = "dbo.usp_CaseUser_xModifyCaseUser";
// using (SqlCommand cmd = new SqlCommand(sqlpoName, sc))
// {
// cmd.CommandType = CommandType.StoredProcedure;
// if (CaseID != 0)
// cmd.Parameters.AddWithValue("@CaseID", CaseID);
// cmd.Parameters.AddWithValue("@BirthDate", BrithDate);
// cmd.Parameters.AddWithValue("@IdNo", tbIdNo .Text);
// cmd.Parameters.AddWithValue("@PassportNo", tbPassportNo .Text);
// cmd.Parameters.AddWithValue("@ResNo", tbResNo .Text);
// cmd.Parameters.AddWithValue("@OtherNo", tbOtherNo .Text);
// cmd.Parameters.AddWithValue("@ChName", tbName .Text);
// cmd.Parameters.AddWithValue("@EnName", tbEngName .Text);
// cmd.Parameters.AddWithValue("@Gender", ddlGender .SelectedValue);
// cmd.Parameters.AddWithValue("@HouseNo", tbHouseNo .Text);
// cmd.Parameters.AddWithValue("@ONationality", ddlONationality .SelectedValue);
// cmd.Parameters.AddWithValue("@Language", String.Join(",", cblLang.Items.OfType<ListItem>().Where(r => r.Selected) .Select(r => r.Value )));
// // cmd.Parameters.AddWithValue("@Capacity", String.Join(",", cblCapacity.Items.OfType<ListItem>().Where(r => r.Selected).Select(r => r.Value)));
// //全部加起來 到DB再處理 因為 有些身份別是不能改的
// cmd.Parameters.AddWithValue("@Capacity",
// String.Join(",",
// String.Join(",", cblCapacity_1.Items.OfType<ListItem>().Where(r => r.Selected).Select(r => r.Value))
// , String.Join(",", cblCapacity_2.Items.OfType<ListItem>().Where(r => r.Selected).Select(r => r.Value))
// , String.Join(",", cblCapacity_3.Items.OfType<ListItem>().Where(r => r.Selected).Select(r => r.Value))
// , String.Join(",", cblCapacity_4.Items.OfType<ListItem>().Where(r => r.Selected).Select(r => r.Value))
// ) );
// //cmd.Parameters.AddWithValue("@ResCounty", ddlResCounty.SelectedValue );
// //cmd.Parameters.AddWithValue("@ResTown", ddlResTown.SelectedValue);
// //cmd.Parameters.AddWithValue("@ResVillage", ddlResVillage.SelectedValue);
// cmd.Parameters.AddWithValue("@ResCounty", Request[ddlResCounty.ClientID.Replace("_", "$")].ToString());
// cmd.Parameters.AddWithValue("@ResTown", Request[ddlResTown.ClientID.Replace("_", "$")].ToString());
// cmd.Parameters.AddWithValue("@ResVillage", Request[ddlResVillage.ClientID.Replace("_", "$")].ToString());
// cmd.Parameters.AddWithValue("@ConCounty",Request[ddlConCounty.ClientID.Replace("_", "$")].ToString());
// cmd.Parameters.AddWithValue("@ConTown", Request[ddlConTown.ClientID.Replace("_", "$")].ToString());
// cmd.Parameters.AddWithValue("@ConVillage", Request[ddlConVillage.ClientID.Replace("_", "$")].ToString());
// cmd.Parameters.AddWithValue("@PregWeek",tbPregWeek .Text);
// cmd.Parameters.AddWithValue("@BirthNum",tbBirthNum.Text );
// cmd.Parameters.AddWithValue("@BirthSeq",tbBirthSeq.Text );
// cmd.Parameters.AddWithValue("@BirthWeight",tbBirthWeight.Text );
// cmd.Parameters.AddWithValue("@BirthPlace",ddlBirthPlace.SelectedValue );
// cmd.Parameters.AddWithValue("@Deliver",ddlDeliver.SelectedValue );
// cmd.Parameters.AddWithValue("@DeliverOrg",tbDeliverOrg .Text );
// cmd.Parameters.AddWithValue("@MarryStatus",ddlMarryStatus.SelectedValue );
// cmd.Parameters.AddWithValue("@EduLevel", tbEduLevel .Text );
// cmd.Parameters.AddWithValue("@ElemSchool", tbElemSchool .Text );
// cmd.Parameters.AddWithValue("@Occupation", tbOccupation .Text );
// cmd.Parameters.AddWithValue("@ModifyUserID", AuthServer.GetLoginUser().ID);
// cmd.Parameters.AddWithValue("@TelDayArea", tbTelDayArea.Text);
// cmd.Parameters.AddWithValue("@TelDayNo", tbTelDayNo.Text);
// cmd.Parameters.AddWithValue("@TelDayExt", tbTelDayExt.Text);
// cmd.Parameters.AddWithValue("@TelNightArea", tbTelNightArea.Text);
// cmd.Parameters.AddWithValue("@TelNightNo", tbTelNightNo.Text);
// cmd.Parameters.AddWithValue("@TelNightExt", tbTelNightExt.Text);
// cmd.Parameters.AddWithValue("@ResAddr", tbResAddr .Text );
// cmd.Parameters.AddWithValue("@ConAddr",tbConAddr .Text );
// cmd.Parameters.AddWithValue("@BirthMulti", tbBirthMulti.Text );
// cmd.Parameters.AddWithValue("@ResNei", tbResNei.Text);
// cmd.Parameters.AddWithValue("@ConNei", tbConNei.Text);
// try
// {
// using (SqlDataAdapter da = new SqlDataAdapter(cmd))
// {
// sc.Open();
// da.Fill(ds);
// }
// CaseID= Convert.ToInt32(ds.Tables[0].Rows[0][0]);
// }
// catch(Exception ex) {
// Response.Write(ex.StackTrace +ex.Message );
// }
// }
//}
CaseUserProfile c = GetModifyCase();
c.Update();
//電話email 不用審 直接更新
SaveEmailMobiles(c.CaseID);
Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "alert('成功!');location.href='UserProfileList.aspx'", true);
}
protected void Page_Load(object sender, EventArgs e)
{
string action = Request.Form["action"] ?? "";
JsonReply jr = new JsonReply();
try
{
if (action == "GetContactTr")
{
int ContactID;
int.TryParse(Request.Form["ContactID"], out ContactID);
StringBuilder sb = new StringBuilder("");
UserContact uc = new UserContact(ContactID);
CaseUserProfile c = new CaseUserProfile(uc.ContactCaseID);
sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td><a href=\"javascript:void(0);\" id=\"ModifyContact_{5}\" class=\"ModifyContact\" ><img src=\"/images/icon_maintain.png\"></a></td><td> <a href=\"javascript:void(0);\" id=\"DeleteContact_{5}\" class=\"DeleteContact\"><img src=\"/images/icon_del01.gif\"></a></td></tr>", uc.RelationShipName, c.ChName, c.IdNo, c.BirthDate, (uc.IsMain ? "<img src=\"/images/icon_tick.png\" >" : ""), uc.ContactID);
jr.Content = sb.ToString();
jr.RetCode = 1;
}
else if (action == "Delete")
{
int ContactID;
int.TryParse(Request.Form["ContactID"], out ContactID);
UserContact uc = new UserContact(ContactID);
uc.Delete();
jr.Content = "成功";
jr.RetCode = 1;
}
else if (action == "LoadContactList")
{
int CaseID;
int.TryParse(Request.Form["CaseID"], out CaseID);
StringBuilder sb = new StringBuilder("");
sb.Append("<table id=\"Contact_TB\">");
sb.Append("<tr><th scope=\"col\">關係</th><th scope=\"col\">姓名</th><th scope=\"col\">身分證號</th><th scope=\"col\">出生日期</th><th scope=\"col\">主要聯絡人</th><th scope=\"col\" style=\"width:1%\">維護</th><th scope=\"col\" style=\"width:1%\">移除</th></tr>");
DataTable dt = new DataTable();
if (CaseID != 0)
{
dt = (DataTable)DBUtil.DBOp("ConnDB", " exec dbo.usp_CaseUser_xGetCaseUserContactList {0} "
, new string[] { CaseID.ToString() }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
}
else
{
//if (Session["NewCaseContacts"] != null)
//{
// string NewCaseContacts = Session["NewCaseContacts"].ToString();
// dt = (DataTable)DBUtil.DBOp("ConnDB", " exec dbo.usp_CaseUser_xGetCaseUserContactList {0} "
// , new string[] { CaseID.ToString() }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
//}
}
foreach (DataRow r in dt.Rows)
{
sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td><a href=\"javascript:void(0);\" id=\"ModifyContact_{5}\" class=\"ModifyContact\" ><img src=\"/images/icon_maintain.png\"></a></td><td> <a href=\"javascript:void(0);\" id=\"DeleteContact_{5}\" class=\"DeleteContact\"><img src=\"/images/icon_del01.gif\"></a></td></tr>", r["RS"], r["ChName"], r["IdNo"], r["BirthDate"], (r["IsMain"].ToString() == "1" ? "<img src=\"/images/icon_tick.png\" >" : ""), r["ContactID"]);
}
sb.Append("</table>");
jr.Content = sb.ToString();
jr.RetCode = 1;
}
else if (action == "isHaveParent")
{
jr.Content = "無父母";
jr.RetCode = 0;
int CaseID;
int.TryParse(Request.Form["CaseID"], out CaseID);
if (Convert.ToInt32(DBUtil.DBOp("ConnDB", " SELECT count([ContactID]) FROM [dbo].[C_CaseUserContact] where [CaseID]={0} and ([ContactRelationShip]=2 or [ContactRelationShip]=3) and LogicDel=0 "
, new string[] { CaseID.ToString() }, NSDBUtil.CmdOpType.ExecuteScalar)) > 0)
{
jr.Content = "有父或母";
jr.RetCode = 1;
}
}
else if (action == "IsHaveParentWithContactIDs")
{
jr.Content = "無父母";
jr.RetCode = 0;
string ContactIDs = Request.Form["ContactIDs"] ?? "";
if (ContactIDs != "" && Convert.ToInt32(DBUtil.DBOp("ConnDB", " SELECT count([ContactID]) FROM [dbo].[C_CaseUserContact] where exists ( select data from dbo.fn_slip_str({0},',') where data = [ContactID]) and ([ContactRelationShip]=2 or [ContactRelationShip]=3) and LogicDel=0 "
, new string[] { ContactIDs }, NSDBUtil.CmdOpType.ExecuteScalar)) > 0)
{
jr.Content = "有父或母";
jr.RetCode = 1;
}
}
}
catch {
jr.RetCode = 0;
}
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(jr));
Response.End();
}
