Example #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        tMember mb = Session[CDKey.LOGINUSER] as tMember;



        if (Page.IsPostBack == false)
        {
            var in3Services = from c in db.tCalendar
                              join s in db.tServices on c.fIdServices equals s.fIdServices
                              where c.fIdMember == id && c.fDate < DateTime.Now.Date
                              select new
            {
                finName = s.fName,
                finDate = c.fDate.Value.Month.ToString() + "月" + c.fDate.Value.Day.ToString() + "日",
                fidSer  = s.fIdServices
            };
            DllOverTime.DataSource = in3Services;
            DllOverTime.DataBind();

            var disc = (from d in db.tDiscussion
                        where d.fIdMember == id
                        orderby d.fSendTime descending
                        select new
            {
                ftitle = d.fTitle,
                ftime = d.fSendTime
            }).Take(3);
            DLDis.DataSource = disc;
            DLDis.DataBind();

            var discR = (from r in db.tDiscussionReply
                         join d in db.tDiscussion on r.tMember equals d.tMember
                         where r.fIdMember == id
                         orderby r.fSendTime descending
                         select new
            {
                ftitle = d.fTitle,
                ftime = r.fSendTime
            }).Take(3);
            DLDisR.DataSource = discR;
            DLDisR.DataBind();
        }
    }
    public void inPageLoad()
    {
        tMember mb = Session[CDKey.LOGINUSER] as tMember;

        if (Session[CDKey.LOGINUSER] == null)
        {
            Response.Redirect("Login.aspx");
        }
        else
        {
            tMember member = (tMember)Session[CDKey.LOGINUSER];
            //p.ProcessLetterMsg(member, lblLetter);

            id = mb.fIdMember;
        }


        if (Page.IsPostBack == false)
        {
            //抓取服務進度
            var inServices = from c in db.tCalendar
                             join s in db.tServices on c.fIdServices equals s.fIdServices
                             where c.fIdMember == id && c.fDate > DateTime.Now.Date && c.fAccepted.Equals("True")
                             select new
            {
                finName = s.fName,
                finDate = c.fDate.Value.Month.ToString() + "月" + c.fDate.Value.Day.ToString() + "日"
            };
            DLNotYetTime.DataSource = inServices;
            DLNotYetTime.DataBind();

            var in2Services = from c in db.tCalendar
                              join s in db.tServices on c.fIdServices equals s.fIdServices
                              where c.fIdMember == id && c.fDate == DateTime.Now.Date && c.fAccepted.Equals("True")
                              select new
            {
                finName = s.fName,
                finDate = c.fDate.Value.Month.ToString() + "月" + c.fDate.Value.Day.ToString() + "日"
            };
            DllSameTime.DataSource = in2Services;
            DllSameTime.DataBind();

            var in3Services = from c in db.tCalendar
                              join s in db.tServices on c.fIdServices equals s.fIdServices
                              where c.fIdMember == id && c.fDate < DateTime.Now.Date && c.fAccepted.Equals("True") && c.fOK == null
                              select new
            {
                finName = s.fName,
                finDate = c.fDate.Value.Month.ToString() + "月" + c.fDate.Value.Day.ToString() + "日",
                fidSer  = s.fIdServices
            };
            DllOverTime.DataSource = in3Services;
            DllOverTime.DataBind();

            var in4Services = from c in db.tCalendar
                              join s in db.tServices on c.fIdServices equals s.fIdServices
                              join e in db.tEvaluation on s.fIdServices equals e.fidServices
                              where c.fIdMember == id && e.fidMember == id && c.fDate < DateTime.Now.Date && e.fStar != null && c.fAccepted.Equals("True")
                              select new
            {
                finName = s.fName,
                finDate = c.fDate.Value.Month.ToString() + "月" + c.fDate.Value.Day.ToString() + "日",
                fidStar = e.fStar
            };
            DataList1.DataSource = in4Services;
            DataList1.DataBind();

            var in5Services = from c in db.tCalendar
                              join s in db.tServices on c.fIdServices equals s.fIdServices
                              where c.fIdMember == id && c.fAccepted.Equals("False")
                              select new
            {
                finName = s.fName,
                finDate = c.fDate.Value.Month.ToString() + "月" + c.fDate.Value.Day.ToString() + "日"
            };
            DLLnotAccepted.DataSource = in5Services;
            DLLnotAccepted.DataBind();

            //抓取喜歡的店家
            var likeStores = from c in db.tCollection
                             join m in db.tMember on c.fIdStores equals m.fIdMember
                             where c.fIdMember == id
                             select new
            {
                flikeStoreName  = m.fName,
                flikeStorePhoto = m.fPhoto,
                fStore          = c.fIdStores
            };

            DLLikeStores.DataSource = likeStores;
            DLLikeStores.DataBind();
            //抓取收藏的服務

            /*  var linqlikeServices = from l in db.tLIkeServices
             *                       join m in db.tMember on l.fidStores equals m.fIdMember
             *                       join se in db.tServices on l.fidServices equals se.fIdServices
             *                       join s in db.tServicesPic on l.fidServices equals s.fIdServices
             *                       join g in db.tGalleryPhoto on s.fIdPhoto equals g.fIdPhoto
             *                       where l.fidMember == id
             *                       select new
             *                       {
             *                           fStore=l.fidStores,
             *                           fServices=l.fidServices,
             *                           fLikeServiceName = se.fName,
             *                           fLikeServicePhoto = g.fPhoto
             *                       };*/


            var qqq = from l in db.tLIkeServices
                      join se in db.tServices on l.fidServices equals se.fIdServices
                      join s in db.tServicesPic on l.fidServices equals s.fIdServices
                      join g in db.tGalleryPhoto on s.fIdPhoto equals g.fIdPhoto
                      join st in db.tMember on se.fIdStores equals st.fIdMember
                      where l.fidMember == id
                      select new
            {
                fStore            = st.fIdMember,
                fServices         = l.fidServices,
                fLikeServiceName  = se.fName,
                fLikeServicePhoto = g.fPhoto
            };



            DLLikeServices.DataSource = qqq;
            DLLikeServices.DataBind();
            //喜歡店家數量
            var likeStoreCount = from c in db.tCollection
                                 where c.fIdMember == id
                                 select c.fIdCollectionStores;
            int countstore = likeStoreCount.Count();
            if (countstore == 0)
            {
                lblLikestore.Text = "尚未加入喜歡的店家";
            }
            else
            {
                lblLikestore.Text = "您有 " + countstore + " 個喜歡的店家";
            }
            //收藏服務數量
            var likeServicesCount = from l in db.tLIkeServices
                                    where l.fidMember == id
                                    select l.fidLIkeServices;
            int countLikeServices = likeServicesCount.Count();
            if (countLikeServices == 0)
            {
                lblLikeServices.Text = "尚未有收藏的服務";
            }
            else
            {
                lblLikeServices.Text = "您有 " + countLikeServices + " 個收藏的服務";
            }
            //顯示行程數量
            var cale = from c in db.tCalendar
                       where c.fIdMember == id && c.fDate > DateTime.Now.Date && c.fAccepted.Equals("True")
                       select new
            {
                fcount = c.fIdCalendar
            };
            int caleCount = cale.Count();
            if (caleCount == 0)
            {
                lblNew.Text = "尚無未開始行程";
            }
            else
            {
                lblNew.Text = "您有 " + caleCount + " 個未開始行程";
            }

            //顯示基本資料
            var table = from m in db.tMember
                        where m.fIdMember == id
                        select m;
            foreach (tMember o in table)
            {
                txtName.Text    = o.fName;
                txtPhone.Text   = o.fPhone;
                txtAddress.Text = o.fAddress;
                txtEmail.Text   = o.fEmail;

                imgPic2.ImageUrl = o.fPhoto;
                imgPic.ImageUrl  = o.fPhoto;
                lblUserName.Text = "準新人:" + o.fName;
            }
            //前3筆發文討論
            var disc = (from d in db.tDiscussion
                        where d.fIdMember == id
                        orderby d.fSendTime descending
                        select  new
            {
                fidtit = d.fIdTitle,
                ftitle = d.fTitle,
                ftime = d.fSendTime
            }).Take(20);
            DLDis.DataSource = disc;
            DLDis.DataBind();
            //前3筆回文
            var discR = (from r in db.tDiscussionReply
                         join d in db.tDiscussion on r.fIdTitle equals d.fIdTitle
                         where r.fIdMember == id
                         orderby r.fSendTime descending
                         select new {
                fcon = r.fContent,
                fidtit = d.fIdTitle,
                ftitle = d.fTitle,
                ftime = r.fSendTime
            }).Take(20);
            DLDisR.DataSource = discR;
            DLDisR.DataBind();
            //我的詢價
            var Askp = (from a in db.tAskPrice
                        where a.fIdMember == id
                        orderby a.fSendTime descending
                        select new
            {
                fidtit = a.fIdTitle,
                ftitle = a.fTitle,
                ftime = a.fSendTime
            }).Take(20);
            DLAskP.DataSource = Askp;
            DLAskP.DataBind();
        }
    }
Example #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        tMember mb = Session[CDKey.LOGINUSER] as tMember;

        if (Session[CDKey.LOGINUSER] == null)
        {
            Response.Redirect("Login.aspx");
        }
        else
        {
            tMember member = (tMember)Session[CDKey.LOGINUSER];
            //p.ProcessLetterMsg(member, lblLetter);
            id = mb.fIdMember;
        }
        if (Page.IsPostBack == false)
        {
            //我的方案


            //我的作品跟方案
            fludatalist();

            var table3 = from s in db.tStores
                         //join m in db.tMember on s.fIdStores equals m.fIdMember
                         where s.fIdStores == id
                         select s;
            var table2 = from m in db.tMember
                         // join s in db.tStores on s.fIdStores equals m.fIdMember
                         where m.fIdMember == id
                         select m;

            foreach (tStores o in table3)
            {
                txtDescription.Text = o.fDescription;
                txtMobilePhone.Text = o.fMobilePhone;
                txtLine.Text        = o.fLineId;
                if (!string.IsNullOrEmpty(o.fHoliday))
                {
                    if (o.fHoliday.Contains('%'))
                    {
                        char     delimiterChars = '%';
                        string[] words          = o.fHoliday.Split(delimiterChars);
                        DWHoliday.Text  = words[0];
                        txtHoliday.Text = words[1];
                    }
                    else
                    {
                    }
                }
                if (!string.IsNullOrEmpty(o.fOpeningTime))
                {
                    if (o.fOpeningTime.Contains('-'))
                    {
                        char     delimiterChars3 = '-';
                        string[] words3          = o.fOpeningTime.Split(delimiterChars3);
                        OpTime1.Text = words3[0];
                        OpTime2.Text = words3[1];
                    }
                    else
                    {
                    }
                }
            }

            foreach (tMember o in table2)
            {
                if (!string.IsNullOrEmpty(o.fAddress))
                {
                    if (o.fAddress.Contains("^"))
                    {
                        char     delimiterChars2 = '^';
                        string[] words2          = o.fAddress.Split(delimiterChars2);
                        DWCity.Text     = words2[0];
                        txtAddress.Text = words2[1];
                    }
                    else
                    {
                        txtAddress.Text = o.fAddress;
                    }
                }
                else
                {
                }
                txtEmail.Text    = o.fEmail;
                txtPhone.Text    = o.fPhone;
                txtStore.Text    = o.fName;
                lblUserName.Text = o.fName;
                imgPic.ImageUrl  = o.fPhoto;
                imgPic2.ImageUrl = o.fPhoto;
                //lblUserName.Text = o.fName;
            }
            var disc = (from d in db.tDiscussion
                        where d.fIdMember == id
                        orderby d.fSendTime descending
                        select new
            {
                fidtit = d.fIdTitle,
                ftitle = d.fTitle,
                ftime = d.fSendTime
            }).Take(20);
            DLDis.DataSource = disc;
            DLDis.DataBind();
            //前3筆回文

            var discR = (from r in db.tDiscussionReply
                         join d in db.tDiscussion on r.fIdTitle equals d.fIdTitle
                         where r.fIdMember == id
                         orderby r.fSendTime descending
                         select new
            {
                fcon = r.fContent,
                fidtit = d.fIdTitle,
                ftitle = d.fTitle,
                ftime = r.fSendTime
            }).Take(20);
            DLDisR.DataSource = discR;
            DLDisR.DataBind();
            //我的報價
            var anser = (from a in db.tAskPrice
                         join ap in db.tAnswerPrice on a.fIdTitle equals ap.fIdTitle
                         where ap.fIdStore == id
                         orderby ap.fSendTime descending
                         select new
            {
                fidtit = a.fIdTitle,
                ftitle = a.fTitle,
                ftime = a.fSendTime,
                fcon = ap.fContent
            }).Take(20);
            DLAsk.DataSource = anser;
            DLAsk.DataBind();
        }
        tMember loginUser = Session[CDKey.LOGINUSER] as tMember;

        if (!IsPostBack)
        {
            //載入行事曆未接受確認之下拉式選單Items
            var calendarItems = from c in db.tCalendar
                                join s in db.tServices on c.fIdServices equals s.fIdServices
                                where loginUser.fIdMember == c.fIdStores && c.fAccepted == false
                                select new { servicename = s.fName, calendarid = c.fIdCalendar };
            if (calendarItems.Count() > 0)
            {
                DropDownList1.DataSource     = calendarItems;
                DropDownList1.DataTextField  = "servicename";
                DropDownList1.DataValueField = "calendarid";
                DropDownList1.DataBind();
            }
            DropDownList1.Items.Insert(0, "--請選擇--");
        }
    }