Пример #1
0
        private void BindList()
        {
            #region __________Where语句__________

            strWhere = "  1=1";
            if (SearchName != "")
            {
                strWhere += " and (name like '%" + SearchName + "%')";
            }
            if (brand != "")
            {
                strWhere += " and (brand='" + brand + "')";
            }
            if (protype != "")
            {
                strWhere += " and (protype='" + protype + "')";
            }
            #endregion

            rpt_List.PageLink    = "appplatform.aspx?Search=Yes&SearchName=" + Utils.UrlEncode(SearchName) + "&brand=" + Utils.UrlEncode(brand) + "&protype=" + Utils.UrlEncode(protype);
            rpt_List.PageSize    = 20;
            rpt_List.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_appplatform", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1);

            rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rpt_List, ds.Tables[1]);
        }
Пример #2
0
        private void BindList()
        {
            #region __________Where语句__________

            string strWhere = "  1=1";

            //if (SearchName != "")
            //{
            //    strWhere += " and (PlanName like '%" + SearchName + "%')";
            //}
            //if (starttime != "")
            //{
            //    strWhere += " and (BeginTime>='" + starttime + "')";
            //}
            //if (endtime != "")
            //{
            //    strWhere += " and (BeginTime<='" + endtime + "')";
            //}
            //if (userid > 0)
            //{
            //    strWhere += " and dbo.inArray(" + userid + ",BelongTo)>0";
            //}
            #endregion

            rpt_List.PageLink    = "trainingplanslist.aspx?Search=Yes";
            rpt_List.PageSize    = 15;
            rpt_List.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("TECH_TRAIN_COURSE", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1);

            rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rpt_List, ds.Tables[1]);
        }
Пример #3
0
        private void BindList()
        {
            strWhere = "1=1";
            #region __________Where语句__________
            if (typeid != "")
            {
                strWhere = "  TypeId ='" + typeid + "'";
            }
            else
            {
                strWhere = "  TypeId ='" + PageID + "'";
            }

            if (SearchName != "")
            {
                //strWhere += " and (title like '%" + SearchName + "%')";
            }
            #endregion

            rpt_List.PageLink    = "gglist.aspx?Search=Yes&pageid=" + PageID + "&TypeId=" + typeid + "&SearchName=" + Utils.UrlEncode(SearchName);
            rpt_List.PageSize    = 15;
            rpt_List.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_article", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1);

            rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rpt_List, ds.Tables[1]);
        }
Пример #4
0
        private void BindList()
        {
            strWhere = " 1=1 ";
            #region __________Where语句__________
            if (typeid > 0)
            {
                strWhere += " and N_Type=" + typeid;
            }
            if (SearchName != "")
            {
                strWhere += " and (C_Title like '%" + SearchName + "%')";
            }
            if (teachername != "")
            {
                strWhere += " and (C_Tearcher like '%" + teachername + "%')";
            }
            if (starttime != "")
            {
                strWhere += " and (DT_StartDate>='" + starttime + "')";
            }
            if (endtime != "")
            {
                strWhere += " and (DT_StartDate<='" + endtime + "')";
            }
            #endregion

            rpt_List.PageLink    = "statvote.aspx?Search=Yes&pagesize=" + pagesize + "&TypeId=" + typeid + "&starttime=" + starttime + "&endtime=" + endtime + "&SearchName=" + Utils.UrlEncode(SearchName) + "&teachername=" + Utils.UrlEncode(teachername);
            rpt_List.PageSize    = pagesize;
            rpt_List.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = mw_getlistbypage.GetDataSet_NoCache("mw_votecourse", "*", strWhere, "", "Id DESC", "Id", rpt_List.CurrentPage, rpt_List.PageSize, 1);

            rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rpt_List, ds.Tables[1]);
        }
Пример #5
0
        private string callback       = "";      //回调

        protected void Page_Load(object sender, EventArgs e)
        {
            filesize       = LYRequest.GetInt("filesize", 1024);
            filetype       = LYRequest.GetString("filetype", "image");
            tofilepath     = LYRequest.GetString("filepath", "/UpLoads/");
            recievetxtname = LYRequest.GetString("recievetxtname", "");
            ismultifile    = LYRequest.GetInt("ismultifile", 0);
            callback       = LYRequest.GetString("callback", "");

            int type = LYRequest.GetInt("type", 0);

            if (!IsPostBack)
            {
                if (!chkLogin(type))
                {
                    return;
                }

                if (recievetxtname == "")
                {
                    Lbl_Tip.Text        = "缺少参数recievetxtname";
                    File_Upload.Visible = false;
                    Btn_Submit.Visible  = false;
                }
            }
        }
Пример #6
0
        private void BindData()
        {
            #region __________Where语句__________

            string strWhere = "  1=1";
            //strWhere += " and EndTime>='" + DateTime.Now + "' and BeginTime<='" + DateTime.Now + "'";
            if (typeid != "")
            {
                strWhere += " and PRO_TYPE='" + typeid + "'";
            }
            strWhere += " and ApplierID='" + (CurrentUser != null?CurrentUser.ID:"") + "' ";
            #endregion
            rpt_List.ShowPagenation = false;
            rpt_List.PageLink       = "";
            rpt_List.PageSize       = 100;
            rpt_List.CurrentPage    = LYRequest.GetInt("page", 1);

            /*SELECT p.`NAME`,p.DAYS,p.YEAR_VALUE,p.PLAN_WEEK,p.USER_TYPE,p.USER_ID,a.ApplyTime
             * FROM mw_applyplans AS a INNER JOIN mw_trainingplans AS p ON a.ApplyPlanID = p.ID
             * WHERE p.USER_TYPE = 'teacher'*/
            string table = "mw_applyplans AS a INNER JOIN mw_TrainingPlans AS p ON a.ApplyPlanID = p.ID";

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache(table, "p.ID,p.`NAME`,p.DAYS,p.YEAR_VALUE,p.PLAN_WEEK,p.USER_TYPE,p.UNAME,a.ApplyTime", strWhere, "", "ApplyTime DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 0);
            if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
            {
                DataView dv = ds.Tables[0].DefaultView;
                dv.Sort = "ApplyTime desc";
                DataTable tmptb = dv.ToTable(true, new string[] { "ID", "NAME", "DAYS", "YEAR_VALUE", "PLAN_WEEK" });
                DataTable DT    = new DataTable();
                DT.Columns.Add("ID");
                DT.Columns.Add("PlanName");
                DT.Columns.Add("Teacher");
                DT.Columns.Add("BeginTime");
                DT.Columns.Add("days");
                foreach (DataRow row in tmptb.Rows)
                {
                    var dr = DT.NewRow();
                    dr["ID"]        = row["ID"];
                    dr["PlanName"]  = BaseUi.GetLang(row["NAME"].ToString());
                    dr["days"]      = row["DAYS"];
                    dr["BeginTime"] = row["YEAR_VALUE"] + " 第" + row["PLAN_WEEK"] + "周";
                    dv.RowFilter    = "(ID='" + row["ID"] + "' and USER_TYPE='teacher')";
                    var ts = dv.ToTable();
                    {
                        var sb = new System.Text.StringBuilder();
                        foreach (DataRow item in ts.Rows) //因为所查询的名字可能有多行
                        {
                            sb.Append(item["UNAME"] + " ,");
                        }
                        dr["Teacher"] = sb.ToString().Trim(',');
                    }
                    DT.Rows.Add(dr);
                }
                JBind.BindList(rpt_List, DT);
            }
            //rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
        }
Пример #7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     sysid = LYRequest.GetInt("sysid", 0);
     id    = LYRequest.GetInt("id", 0);
     if (!IsPostBack)
     {
         InitData();
     }
 }
Пример #8
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Id       = MW.Common.LYRequest.GetInt("id", 0);
     parentid = LYRequest.GetInt("parentid", 0);
     if (!IsPostBack)
     {
         InitData();
     }
 }
Пример #9
0
 protected void Page_Load(object sender, EventArgs e)
 {
     SearchName = MW.Common.LYRequest.GetString("SearchName", true);
     sysid      = LYRequest.GetInt("sysid", 0);
     if (!IsPostBack)
     {
         InitData();
         BindList();
     }
 }
Пример #10
0
 protected void Page_Load(object sender, EventArgs e)
 {
     sysid  = LYRequest.GetInt("VoteId", 0);
     voteid = LYRequest.GetInt("id", 0);
     if (!IsPostBack)
     {
         litNum.Text             = bll.GetSum(voteid, sysid).ToString();
         rpt_List.ShowPagenation = false;
         JBind.BindList(rpt_List, CreateTB(voteid, sysid));
     }
 }
Пример #11
0
 protected void Page_Load(object sender, EventArgs e)
 {
     sysid = LYRequest.GetInt("sysid", 0);
     id    = LYRequest.GetInt("id", 0);
     if (!IsPostBack)
     {
         string path = Utils.GetMapPath(MW.BasePage.GetWebPath + "/mw/onlinesurvey/" + id + ".html");
         this.Label3.Text = "引用相对路径: /uploads/文件名 ,若图像|视频等不显示,请参照修改路径";
         InitData(path);
         hidid.Value = id.ToString();
     }
 }
Пример #12
0
 protected void Page_Load(object sender, EventArgs e)
 {
     sysid  = LYRequest.GetInt("VoteId", 0);
     voteid = LYRequest.GetInt("id", 0);
     if (!IsPostBack)
     {
         string code = "";
         string time = "";
         string sta  = tableOne(voteid, sysid, ref code, ref time);
         ExportExcelFile(sta, "vwac_survey_" + voteid + "_" + time + "_" + code);
     }
 }
Пример #13
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack && base.Request["VoteId"] != null && base.Request["id"] != null)
            {
                int sysid  = LYRequest.GetInt("voteid", 0);
                int voteid = LYRequest.GetInt("id", 0);

                rpt_List.ShowPagenation = false;
                JBind.BindList(rpt_List, CreateTB(voteid, sysid));
                litNum.Text = bll.GetSum(voteid, sysid).ToString();
            }
        }
Пример #14
0
 protected void Page_Load(object sender, EventArgs e)
 {
     SearchName  = MW.Common.LYRequest.GetString("SearchName", true);
     teachername = MW.Common.LYRequest.GetString("teachername", true);
     starttime   = MW.Common.LYRequest.GetString("starttime");
     endtime     = MW.Common.LYRequest.GetString("endtime");
     typeid      = LYRequest.GetInt("typeid", 0);
     pagesize    = LYRequest.GetInt("pagesize", 20);
     if (!IsPostBack)
     {
         InitData();
         BindList();
     }
 }
Пример #15
0
        protected void Page_Load(object sender, EventArgs e)
        {
            int    page   = LYRequest.GetInt("page", 1);
            string typeid = LYRequest.GetString("typeid");

            if (typeid == "")
            {
                typeid = "XW";
            }
            if (base.Request["cmd"] != null && base.Request["cmd"] == "list")
            {
                BindData(page, typeid);
            }
        }
Пример #16
0
        private void BindData()
        {
            #region __________Where语句__________

            string strWhere = "  1=1";
            //strWhere += " and EndTime>='" + DateTime.Now + "' and BeginTime<='" + DateTime.Now + "'";
            if (typeid != "")
            {
                strWhere += " and PRO_TYPE='" + typeid + "'";
            }
            #endregion
            rpt_List.ShowPagenation = false;
            rpt_List.PageLink       = "";
            rpt_List.PageSize       = 100;
            rpt_List.CurrentPage    = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_TrainingPlans", "ID,NAME,DAYS,YEAR_VALUE,PLAN_WEEK,USER_TYPE,UNAME", strWhere, "", "YEAR_VALUE DESC,PLAN_WEEK DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 0);
            if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
            {
                DataView  dv    = ds.Tables[0].DefaultView;
                DataTable tmptb = dv.ToTable(true, new string[] { "ID" });
                DataTable DT    = new DataTable();
                DT.Columns.Add("ID");
                DT.Columns.Add("PlanName");
                DT.Columns.Add("Teacher");
                DT.Columns.Add("BeginTime");
                DT.Columns.Add("days");
                foreach (DataRow rowt in tmptb.Rows)
                {
                    var     dr  = DT.NewRow();
                    DataRow row = ds.Tables[0].Select("ID='" + rowt["ID"] + "'")[0];
                    dr["ID"]        = row["ID"];
                    dr["PlanName"]  = BaseUi.GetLang(row["NAME"].ToString());
                    dr["days"]      = row["DAYS"];
                    dr["BeginTime"] = row["YEAR_VALUE"] + " 第" + row["PLAN_WEEK"] + "周";
                    dv.RowFilter    = "(ID='" + row["ID"] + "' and USER_TYPE='teacher')";
                    var ts = dv.ToTable();
                    {
                        var sb = new System.Text.StringBuilder();
                        foreach (DataRow item in ts.Rows) //因为所查询的名字可能有多行
                        {
                            sb.Append(item["UNAME"] + " ");
                        }
                        dr["Teacher"] = sb.ToString();
                    }
                    DT.Rows.Add(dr);
                }
                JBind.BindList(rpt_List, DT);
            }
        }
Пример #17
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Id       = MW.Common.LYRequest.GetInt("id", 0);
            sysid    = LYRequest.GetInt("sysid", 0);
            parentid = LYRequest.GetInt("parentid", 0);
//#warning BasePage.IsPermissions(1)
//            if (!BasePage.IsPermissions(42))
//            {
//                MessageBox.JSLoad(this, "alert('没有权限!!');reloadDlg();");
//                return;
//            }
            if (!IsPostBack)
            {
                InitData();
            }
        }
Пример #18
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Id   = MW.Common.LYRequest.GetString("id");
     type = LYRequest.GetInt("type", 0);
     if (base.Request["cmd"] != null && base.Request["cmd"] == "bm")
     {
         Baoming();
     }
     else
     {
         if (!IsPostBack)
         {
             LoadInit();
         }
     }
 }
Пример #19
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack && base.Request["VoteId"] != null && base.Request["id"] != null)
            {
                int sysid  = LYRequest.GetInt("voteid", 0);
                int voteid = LYRequest.GetInt("id", 0);

                if (!bllcourse.GetStartDate(voteid))
                {
                    Response.Redirect("statreporttmp.aspx?voteid=" + sysid + "&id=" + voteid);
                    Response.End();
                }
                rpt_List.ShowPagenation = false;
                JBind.BindList(rpt_List, CreateTB(voteid, sysid));
                litNum.Text = bllcourse.GetStartDate(voteid) ? bll.GetSum(voteid, sysid).ToString() : bll.GetSum(voteid, sysid).ToString();
            }
        }
Пример #20
0
        private void BindList()
        {
            StringBuilder builder = new StringBuilder(" 1=1  ");

            if (!string.IsNullOrEmpty(this.UserName))
            {
                builder.Append(string.Format(" and C_Title like '%{0}%'", this.UserName));
            }
            rptCustomer.PageLink    = string.Format(MW.BasePage.GetAdminPath + "vwsurvey/_VoteDialog.aspx?hidCtl={0}&txtCtl={1}&UserName={2}&parentDlg={3}", base.Request.QueryString["hidCtl"], base.Request.QueryString["txtCtl"], UserName, parentDlg);
            rptCustomer.PageSize    = 10;
            rptCustomer.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_votesystem", "N_SysId,C_Title", builder.ToString(), "", "N_SysId DESC", "N_SysId", rptCustomer.CurrentPage, rptCustomer.PageSize, 1);

            rptCustomer.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rptCustomer, ds.Tables[1]);
        }
Пример #21
0
        protected void Page_Load(object sender, EventArgs e)
        {
            sysid  = LYRequest.GetInt("VoteId", 0);
            voteid = LYRequest.GetInt("id", 0);
            if (!new B_Votecourse().GetStartDate(voteid))
            {
                Response.Redirect("statresulttmp.aspx?VoteId=" + sysid + "&id=" + voteid);
                Response.End();
            }

            if (!IsPostBack)
            {
                litNum.Text             = bll.GetSum(voteid, sysid).ToString();
                rpt_List.ShowPagenation = false;
                JBind.BindList(rpt_List, CreateTB(voteid, sysid));
            }
        }
Пример #22
0
        protected void Page_Load(object sender, EventArgs e)
        {
            sysid  = LYRequest.GetInt("VoteId", 0);
            voteid = LYRequest.GetInt("id", 0);
            if (!new B_Votecourse().GetStartDate(voteid))
            {
                Response.Redirect("voteexporttmp.aspx?VoteId=" + sysid + "&id=" + voteid);
                Response.End();
            }

            if (!IsPostBack)
            {
                string code = "";
                string time = "";
                string sta  = tableOne(voteid, sysid, ref code, ref time);
                ExportExcelFile(sta, "vwac_survey_" + voteid + "_" + time + "_" + code);
            }
        }
Пример #23
0
        private void BindList()
        {
            #region __________Where语句__________

            strWhere = "  1=1";
            //if (SearchName != "")
            //{
            //    strWhere += " and (PlanName like '%" + SearchName + "%')";
            //}
            #endregion
            rpt_List.PageLink    = string.Format("coursedetail.aspx?hidCtl={0}&txtCtl={1}&UserName={2}", base.Request.QueryString["hidCtl"], base.Request.QueryString["txtCtl"], C_course);
            rpt_List.PageSize    = 7;
            rpt_List.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("TECH_TRAIN_COURSE", "ID,NAME", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1);

            rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rpt_List, ds.Tables[1]);
        }
Пример #24
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Id    = LYRequest.GetInt("id", 0);
            subid = LYRequest.GetInt("subid", 0);
            ntype = LYRequest.GetInt("type", 0);
            sysid = MW.Common.LYRequest.GetInt("sysid", 0);
//#warning BasePage.IsPermissions(1)
//            if (!BasePage.IsPermissions(42))
//            {
//                MessageBox.JSLoad(this, "alert('没有权限!!');reloadDlg();");
//                return;
//            }
            if (!IsPostBack)
            {
                EnableDropList(subid);
                BindRule();
                InitData();
            }
        }
Пример #25
0
        private void BindList()
        {
            #region __________Where语句__________

            strWhere = "  N_SysId=" + sysid;
            if (SearchName != "")
            {
                strWhere += " and (C_SubTitle like '%" + SearchName + "%')";
            }
            #endregion

            rpt_List.PageLink    = "voteunit.aspx?Search=Yes&sysid=" + sysid + "&SearchName=" + Utils.UrlEncode(SearchName);
            rpt_List.PageSize    = 15;
            rpt_List.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_voteunit", "*", strWhere, "", "N_SubId DESC", "N_SubId", rpt_List.CurrentPage, rpt_List.PageSize, 1);

            rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rpt_List, ds.Tables[1]);
        }
Пример #26
0
        private void BindList()
        {
            #region __________Where语句__________

            strWhere = "  1=1";
            if (SearchName != "")
            {
                strWhere += " and (C_Name like '%" + SearchName + "%')";
            }
            #endregion

            rpt_List.PageLink    = "testdriverlist.aspx?Search=Yes%SearchName=" + Utils.UrlEncode(SearchName);
            rpt_List.PageSize    = 15;
            rpt_List.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_testdriver", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1);

            rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rpt_List, ds.Tables[1]);
        }
Пример #27
0
        private void BindList()
        {
            #region __________Where语句__________

            strWhere = "1=1";
            if (SearchName != "")
            {
                strWhere += " and (Chexi like '%" + SearchName + "%')";
            }
            if (Student != "")
            {
                strWhere += " and (Student like '%" + Student + "%')";
            }
            if (Changdi != "")
            {
                strWhere += " and (Changdi like '%" + Changdi + "%')";
            }
            if (CreateTime != "")
            {
                strWhere += " and (CreateTime >= '" + CreateTime + "')";
            }
            if (EndTime != "")
            {
                strWhere += " and (CreateTime <= '" + EndTime + "')";
            }
            #endregion
            //StringBuilder builder = new StringBuilder(MW.BasePage.GetAdminPath + "testdriverpglist.aspx?Search=Yes");
            //builder.Append("&SearchName=" + Utils.UrlEncode(SearchName)).ToString();
            //builder.Append("&Student=" + Utils.UrlEncode(Student)).ToString();
            //builder.Append("&Changdi=" + Utils.UrlEncode(Changdi)).ToString();
            //builder.Append("&CreateTime=" + Utils.UrlEncode(CreateTime)).ToString();
            rpt_List.PageLink = "testdriverpglist.aspx?Search=Yes&SearchName=" + Utils.UrlEncode(SearchName);
            //rpt_List.PageLink = builder.Append("&EndTime=" + Utils.UrlEncode(EndTime)).ToString();
            rpt_List.PageSize    = 10;
            rpt_List.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_testdriverpg", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1);

            rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rpt_List, ds.Tables[1]);
        }
Пример #28
0
        private void BindList()
        {
            StringBuilder builder = new StringBuilder(" ID not in(SELECT tc.ID FROM TECH_TRAIN_COURSE AS tp INNER JOIN mw_tempcode AS tc ON tp.tmpcode = tc.CardNumber WHERE tp.tmpcode IS NOT NULL) ");

            if (!string.IsNullOrEmpty(this.UserName))
            {
                builder.Append(" and (CardNumber like '%" + UserName + "%')");
            }
            if (GroupId > 0)
            {
                builder.Append(string.Format(" and type={0}", this.GroupId));
            }
            rptCustomer.PageLink    = string.Format("tmpcodedialog.aspx?hidCtl={0}&txtCtl={1}&UserName={2}&groupid={3}&parentDlg={4}", base.Request.QueryString["hidCtl"], base.Request.QueryString["txtCtl"], UserName, GroupId, parentDlg);
            rptCustomer.PageSize    = 7;
            rptCustomer.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_tempcode", "ID,CardNumber", builder.ToString(), "", "ID DESC", "ID", rptCustomer.CurrentPage, rptCustomer.PageSize, 1);

            rptCustomer.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rptCustomer, ds.Tables[1]);
        }
Пример #29
0
        private void BindList()
        {
            #region __________Where语句__________

            strWhere = "CId=" + CId + " and chapterid=" + Id;
            //strWhere = "1=1";
            //if (SearchName != "")
            //{
            //    strWhere += " and (C_Name like '%" + SearchName + "%')";
            //}
            #endregion

            rpt_List.PageLink    = "sktitemlist.aspx?Search=Yes&type=" + Type + "&CId=" + CId + "&Id=" + Id + "&SearchName=" + Utils.UrlEncode(SearchName);
            rpt_List.PageSize    = 15;
            rpt_List.CurrentPage = LYRequest.GetInt("page", 1);

            DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_sktitem", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1);

            rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            JBind.BindList(rpt_List, ds.Tables[1]);
        }
Пример #30
0
        protected void Page_Load(object sender, EventArgs e)
        {
            SearchName = MW.Common.LYRequest.GetString("SearchName", true);
            Operator   = LYRequest.GetString("Operator", "");
            Begin_Time = LYRequest.GetString("Begin_Time", "");
            End_Time   = LYRequest.GetString("End_Time", "");
            KeyWord    = LYRequest.GetString("KeyWord", "");
            type       = LYRequest.GetString("type", "");
            id         = LYRequest.GetInt("id", 0);
            re         = LYRequest.GetInt("re", 0);
            rurl       = LYRequest.GetString("rurl", Server.UrlDecode(Request.Url.ToString()));

            if (type == "reset")
            {
                ResetSMS();
            }
            if (!IsPostBack)
            {
                InitData();
                BindList();
            }
        }