Beispiel #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string    action = Request.Form["action"] ?? "";
        JsonReply jr     = new JsonReply();

        jr.RetCode = 0;
        try
        {
            if (action == "DelVisitFile")
            {
                int VisitFileID;
                int.TryParse(Request.Form["VisitFileID"], out VisitFileID);
                if (Convert.ToInt32(DBUtil.DBOp("ConnDB", " UPDATE [dbo].[C_CaseVisitFile] SET [LogicDel] = 1 WHERE ID={0} ;select @@rowcount "
                                                , new string[] { VisitFileID.ToString() }, 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();
    }
Beispiel #2
0
    int action     = 0; //0 add  2 del
    protected void Page_Load(object sender, EventArgs e)
    {
        int.TryParse(Request.Form["UserID"], out UserID);
        int.TryParse(Request.Form["YearMonth"].ToString().Split('-')[0], out Year);
        int.TryParse(Request.Form["YearMonth"].ToString().Split('-')[1], out Month);
        int.TryParse(Request.Form["SearchKind"], out SearchKind);

        int.TryParse(Request.Form["action"], out action);

        JsonReply r = new JsonReply();

        if (UserID > 0 && Year > 0 && Month > 0 && SearchKind > 0)
        {
            DBUtil.DBOp("ConnDB", " exec [dbo].[usp_SearchCheck_xAddAudit]   {0},{1},{2},{3},{4} "
                        , new string[] { UserID.ToString(), (Year + 1911).ToString(), Month.ToString(), SearchKind.ToString(), action.ToString() }
                        , NSDBUtil.CmdOpType.ExecuteNonQuery);
        }

        r.RetCode = 1;
        r.Content = "ok";

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(r));
        Response.End();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        string    action = Request.Form["action"] ?? "";
        JsonReply jr     = new JsonReply();

        try
        {
            if (action == "IsRepeatNo")
            {
                jr.Content = "repeat";
                jr.RetCode = 0;
                int CaseID;
                int.TryParse(Request.Form["CaseID"], out CaseID);
                string IdNo = Request.Form["IdNo"] ?? "";
                if (Convert.ToInt32(DBUtil.DBOp("ConnDB", " SELECT  count([CaseID])  FROM [dbo].[C_CaseUser] where [CaseID]!={0} and IdNo={1}"
                                                , new string[] { CaseID.ToString(), IdNo }, NSDBUtil.CmdOpType.ExecuteScalar)) == 0)
                {
                    jr.Content = " not repeat";
                    jr.RetCode = 1;
                }
            }
        }
        catch {
            jr.RetCode = 0;
        }

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(jr));
        Response.End();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        // ConnDB
        JsonReply r = new JsonReply();

        DB.ExecuteNonQuery(new SqlCommand("exec dbo.usp_CaseUser_xUpdateMergeCheckList"), "ConnDB");
        r.RetCode = 1;
        r.Content = "ok";

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(r));
        Response.End();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        //base.AllowHttpMethod("POST");

        int CaseID = 0;

        int.TryParse(Request["CaseID"], out CaseID);
        int ContactCaseID = 0;

        int.TryParse(Request["ContactCaseID"], out ContactCaseID);
        StringBuilder sb = new StringBuilder("");

        JsonReply r = new JsonReply();


        SqlCommand cmd = new SqlCommand("dbo.usp_CaseUser_xGetCaseUserContact");

        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@CaseID", CaseID);
        cmd.Parameters.AddWithValue("@ContactCaseID", ContactCaseID);
        r = new JsonReply();

        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.RetCode = 1;
        r.Content = sb.ToString();

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(r));
        Response.End();
    }
    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 Page_Load(object sender, EventArgs e)
    {
        //base.AllowHttpMethod("POST");
        string    action = Request.Form["action"] ?? "";
        JsonReply jr     = new JsonReply();

        try
        {
            if (action == "GetList")
            {
                int CaseID = 0;
                int.TryParse(Request.Form["c"], out CaseID);

                StringBuilder sb = new StringBuilder("");
                sb.Append("<table id=\"Reamrk_TB\">");
                sb.Append("<tr><th style=\"width:200px\">類別</td><th>內容</th><th style=\"width:1%\">維護</th><th  style=\"width:1%\">刪除</th></tr>");

                if (CaseID != 0)
                {
                    DataTable dt = (DataTable)DBUtil.DBOp("ConnDB", "EXECUTE  [dbo].[usp_CaseUser_xGetRemarkList]  {0} ", new string[] { CaseID.ToString() }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
                    foreach (DataRow r in dt.Rows)
                    {
                        sb.AppendFormat("<tr><td style=\"width:200px\">{0}</td><td>{1}</td><td><a href=\"javascript:void(0);\" id=\"ModifyRemark_{2}\" class=\"ModifyRemark\" ><img src=\"/images/icon_maintain.png\"></a></td><td> <a  href=\"javascript:void(0);\"  id=\"DeleteRemark_{2}\" class=\"DeleteRemark\"><img src=\"/images/icon_del01.gif\"></a></td></tr>", r["RemarkType"].ToString(), (Convert.ToInt32(r["FileID"]) > 0 ? "<a href=\"DownloadFileOP.aspx?i=" + r["FileID"].ToString() + "\">" + r["CaseRemark"].ToString() + "</a>" : r["CaseRemark"].ToString()), r["ID"].ToString());
                    }
                }
                sb.Append("</table>");
                jr.Content = sb.ToString();
                jr.RetCode = 1;
            }
            else if (action == "Delete")
            {
                int RemarkID = 0;
                int.TryParse(Request.Form["RemarkID"], out RemarkID);
                if (Convert.ToInt32(DBUtil.DBOp("ConnDB", " Update [C_CaseUserRemark] set LogicDel =1 where ID={0} ;select @@rowcount; ", new string[] { RemarkID.ToString() }, NSDBUtil.CmdOpType.ExecuteScalar)) > 0)
                {
                    ;
                }
                {
                    jr.Content = "刪除成功";
                    jr.RetCode = 1;
                }
            }
            else if (action == "GetRemarkTr")
            {
                int RemarkID = 0;
                int.TryParse(Request.Form["RemarkID"], out RemarkID);
                UserRemark ur = new UserRemark(RemarkID);
                if (ur.RemarkID > 0)
                {
                    jr.Content = string.Format("<tr><td style=\"width:200px\">{0}</td><td>{1}</td><td><a href=\"javascript:void(0);\" id=\"ModifyRemark_{2}\" class=\"ModifyRemark\" ><img src=\"/images/icon_maintain.png\"></a></td><td> <a  href=\"javascript:void(0);\"  id=\"DeleteRemark_{2}\" class=\"DeleteRemark\"><img src=\"/images/icon_del01.gif\"></a></td></tr>", ur.RemarkTypeName, (ur.FileID > 0 ? "<a href=\"DownloadFileOP.aspx?i=" + ur.FileID.ToString() + "\">" + ur.RemarkContent.ToString() + "</a>" : ur.RemarkContent.ToString()), ur.RemarkID.ToString());
                }
                else
                {
                    jr.Content = "";
                }
                jr.RetCode = 1;
            }
        }
        catch (Exception ex)
        {
            jr.Content = "失敗" + ex.Message;
            jr.RetCode = 0;
        }
        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(jr));

        Response.End();
    }
    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();
    }