using System;
using CoreSavingLibrary;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using CoreSavingLibrary.WcfNShrlon;
using CoreSavingLibrary.WcfNCommon;
using Sybase.DataWindow;
using DataLibrary;
using System.Threading;
namespace Saving.Applications.shrlon.w_sheet_markconference2_ctrl
{
    public partial class test1 : System.Web.UI.UserControl
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            
        }


        protected void Button3_Click(object sender, EventArgs e)
        {
        }
        public string getdataconference() {
            //string sql = @"SELECT * FROM MBMARKCONFERENCE WHERE member_no = '00191138'";
            string sql = @"SELECT  MBMEMBMASTER.MEMB_NAME ,  MBUCFPRENAME.PRENAME_DESC ,  MBUCFMEMBGROUP.MEMBGROUP_DESC , MBMARKCONFERENCE.CONFERENCE_FLAG ,   MBMARKCONFERENCE.CONFERENCE_DATE ,  MBMEMBMASTER.MEMB_SURNAME ,  MBMARKCONFERENCE.CONFERENCE_MARK ,  MBMEMBMASTER.MEMBGROUP_CODE ,  MBMARKCONFERENCE.MEMBER_NO ,  MBMARKCONFERENCE.SEQ_NO ,  MBMARKCONFERENCE.ACCOUNT_YEAR FROM MBMARKCONFERENCE ,  MBMEMBMASTER ,  MBUCFPRENAME , MBUCFMEMBGROUP  WHERE ( MBMEMBMASTER.MEMBER_NO = MBMARKCONFERENCE.MEMBER_NO (+)) and ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE ) and  ( MBUCFMEMBGROUP.MEMBGROUP_CODE = MBMEMBMASTER.MEMBGROUP_CODE ) and  ( ( MBMARKCONFERENCE.ACCOUNT_YEAR = '2555' ) and ( MBMARKCONFERENCE.SEQ_NO = 1 ) and   ( MBMEMBMASTER.MEMBGROUP_CODE = '014'  ) )  ";

            Sdt dt2 = WebUtil.QuerySdt(sql);
            int i = 1;
            string htmlStr = "";
            while (dt2.Next())
            {
                string CONFERENCE_DATE = dt2.GetString("CONFERENCE_DATE");
                CONFERENCE_DATE = DateTime.Now.ToString("dd/mm/yyyy");
           
                htmlStr += 
                    "<tr>"
                    + "<td>" + i + "</td>"
                    + "<td>" + dt2.GetString("member_no") +"</td>"
                    + "<td>" + dt2.GetString("MEMB_NAME") + "</td>"
                    + "<td>" + dt2.GetString("MEMBGROUP_CODE") + dt2.GetString("MEMBGROUP_DESC") + "</td>"
                    + "<td>" + dt2.GetString("SEQ_NO") + "</td>"
                    + "<td>" + CONFERENCE_DATE + "</td>"
                    + "<td>" + "<input type='radio' style='text-align: center;'>" + "</td>"
                    + "<td>" + "<input type='radio' style='text-align: center;'>" + "</td>"
                    + "<td>" + "<input type='radio' style='text-align: center;'>" + "</td>"
                    + "<td>" + dt2.GetString("CONFERENCE_MARK") + "</td>"
                    + "<td>" + dt2.GetString("ACCOUNT_YEAR") + "</td>"
                    +"</tr>"
                    ;
                i++;
            }
            return htmlStr;
        }
    }
}