Пример #1
0
        protected void BtnQueryddUnfinish_Click(object sender, EventArgs e)
        {
            HideOthers();
            GVYPDetail.Visible = false;
            GVDD.Visible       = true;

            string userid = Request.QueryString["userid"].Trim();
            String sql    = String.Format("select *,ROW_NUMBER() OVER(ORDER BY YFID asc) as SerialN  from (select * from" +
                                          " (select YFID Y, USERID u from ZYF_QT_YFPZ where USERID = '{0}')" +
                                          "as a inner join (select YFID, YFKCID T from ZYF_JG_YFKC)as b " +
                                          "on a.Y = b.YFID inner join(select * from ZYF_QT_DD where DDFinish = 0)" +
                                          "as c on b.T = c.YFKCID inner join(select YPID m, YPName from ZYF_JG_YP) as e " +
                                          "on c.YPID = e.m)as d where d.USERID = '{1}'", Request.QueryString["userid"].ToString(), DDLDD.Text);
            SqlHelper shr = new SqlHelper();

            if (DDLDD.Text.ToString() == "")
            {
                BindDDLDD();
            }
            else
            {
                DataTable dt = shr.Query(sql);
                GVDD.DataSource = dt;
                GVDD.DataBind();
            }
            //合理性检测
            LBLYPRightCheck.Visible = true;
            LBLYPRightCheck.Text    = "此用户订单无异常状况";
            shr.CloseConn();
        }
Пример #2
0
        private void BANDDD()
        {
            DataTable dt = zdService.SELECT_CRM_ZDADD_ED();

            GVDD.DataSource = dt;
            GVDD.DataBind();
        }
Пример #3
0
        protected void GVDD_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            GVCalendar.PageIndex = e.NewPageIndex;
            string sql = string.Format("select DDID,USERID,YPName,c.YPID,DDNum,DDPrice,SerialN,DDFinish from(" +
                                       "select YFID from ZYF_QT_YFPZ where USERID = '{0}') as a " +
                                       "inner join(select* from ZYF_JG_YFKC )as b " +
                                       "on a.YFID = b.YFID inner join(select*, ROW_NUMBER() OVER(ORDER BY YFKCID asc) as SerialN  from ZYF_QT_DD)as c " +
                                       "on b.YFKCID = c.YFKCID inner join(select YPID, YPName from ZYF_JG_YP)as d " +
                                       "on c.YPID = d.YPID", Request.QueryString["userid"].Trim());
            SqlHelper shr = new SqlHelper();
            DataTable dt  = shr.Query(sql);

            GVDD.DataSource = dt;
            GVDD.DataBind();
            shr.CloseConn();
        }
Пример #4
0
        protected void BtnQueryddAll_Click(object sender, EventArgs e)
        {
            GVDD.Visible       = true;
            GVYPDetail.Visible = false;
            //--pz - yfkcid - dduser
            string sql = string.Format("select DDID,USERID,YPName,c.YPID,DDNum,DDPrice,SerialN,DDFinish from(" +
                                       "select YFID from ZYF_QT_YFPZ where USERID = '{0}') as a " +
                                       "inner join(select* from ZYF_JG_YFKC )as b " +
                                       "on a.YFID = b.YFID inner join(select*, ROW_NUMBER() OVER(ORDER BY YFKCID asc) as SerialN  from ZYF_QT_DD)as c " +
                                       "on b.YFKCID = c.YFKCID inner join(select YPID, YPName from ZYF_JG_YP)as d " +
                                       "on c.YPID = d.YPID", Request.QueryString["userid"].Trim());
            SqlHelper shr = new SqlHelper();
            DataTable dt  = shr.Query(sql);

            GVDD.DataSource = dt;
            GVDD.DataBind();
            shr.CloseConn();
            HideOthers();
            GVDD.Visible = true;
        }
Пример #5
0
        public void BindGVDD()
        {
            string bindgvdd = string.Format("select *,ROW_NUMBER() OVER(ORDER BY DDID asc) as SerialN from " +
                                            "(select * from ZYF_QT_DD where USERID = '{0}' AND DDFinish = 0) as aaa " +
                                            "inner join(select YPID, YPName from ZYF_JG_YP) as bbb on aaa.YPID = bbb.YPID", Request.QueryString["userid"].Trim());
            SqlHelper shr = new SqlHelper();
            DataTable dt  = shr.Query(bindgvdd);

            if (dt.Rows.Count <= 0)
            {
                Label3.Visible = true;
                Label3.Text    = "您暂时没有订单,请重新预约";
            }
            else
            {
                Label3.Visible = true;
                Label3.Text    = "预约成功!";
            }

            shr.CloseConn();
            GVDD.DataSource = dt;
            GVDD.DataBind();
        }
Пример #6
0
        protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
        {
            if (TreeView1.SelectedValue == "查询总订单")
            {
                GVDD.Visible       = true;
                GVYPDetail.Visible = false;

                string sql = string.Format("select * from (select *, " +
                                           "ROW_NUMBER() OVER(ORDER BY DDID asc) as SerialN from ZYF_QT_DD WHERE USERID like" +
                                           "  '{0}') as aa inner join(select YPName, YPID from ZYF_JG_YP)as bb on aa.YPID =" +
                                           " bb.YPID", Request.QueryString["userid"].Trim());
                SqlHelper shr = new SqlHelper();
                DataTable dt  = shr.Query(sql);
                shr.CloseConn();
                GVDD.DataSource = dt;
                GVDD.DataBind();
            }
            else if (TreeView1.SelectedValue == "添加药品")
            {
                HideOthers();
                UpdatePanel1.Visible = true;
            }
            else if (TreeView1.SelectedValue == "新建日程")
            {
                HideOthers();
                PanelAddCal.Visible = true;
            }
            else if (TreeView1.SelectedValue == "修改日程")
            {
                HideOthers();
                PanelFork.Visible = true;
            }
            else if (TreeView1.SelectedValue == "退出")
            {
                Response.Redirect("~/ZYFLogin.aspx");
            }
        }