protected void Report_DataBind(object sender, StoreRefreshDataEventArgs e)
 {
     try
     {
         if (TxtVIPNo.Text.Trim().Length <= 0)
         {
             X.MessageBox.Alert("提醒", "请输入VIP卡号！").Show();
             return;
         }
         //CJ_DevelopHelper.SqlConn_Str = ConfigurationManager.AppSettings["DBRetail"];
         CJ_DevelopHelper.SqlConn_Str = ConfigurationManager.AppSettings["F22"];
         string sql = "select vipid,vipname,centum,pcentum from vip_user where vipcode='{0}'";
         CJ_DevelopHelper.SqlStr = String.Format(sql, TxtVIPNo.Text.Trim().Replace("'", "").Replace("--", ""));
         DataTable dt = CJ_DevelopHelper.SQL_ReturnDateTable;
         string cardno = "";
         if (dt.Rows.Count == 1)
         {
             lbInfo.Html = " &nbsp;&nbsp;&nbsp;&nbsp;姓名:<font color=red>" + dt.Rows[0]["vipname"].ToString()
                        + "</font>  &nbsp;&nbsp;&nbsp;&nbsp;总积分:<font color=red>" + dt.Rows[0]["centum"].ToString()
                        + "</font>  &nbsp;&nbsp;&nbsp;&nbsp;上季积分:<font color=red>" + dt.Rows[0]["pcentum"].ToString() + "</font>";
             cardno = dt.Rows[0]["vipid"].ToString();
         }
         else
         {
             X.MessageBox.Alert("提醒", "VIP卡号不正确，请检查，找到"+dt.Rows.Count.ToString()+"条记录！").Show();
             return;
         }
         RetailStore.DataSource = GetRecordByProc(cardno);
         RetailStore.DataBind();
     }
     catch (Exception error)
     {
         X.MessageBox.Alert("异常", error.Message).Show();
     }
 }

 protected void Report_DataBind(object sender, StoreRefreshDataEventArgs e)
 {
     try
     {
         if (Request["shopid"] == null) return;
         //订单销售连接串
         CJ_DevelopHelper.SqlConn_Str = ConfigurationManager.AppSettings["DBRetail"];
         string sql = "select retailid,setdate,znums,zxsums,zssums,FCalcSums,zxsums-zssums as yhsum,s_sums,vipcode,s_name,x_name,crdate,cr_name,comment,sure,chk_sure,depotid from d_Retail ";
         string condition = "where depotid='" + Request["shopid"].ToString().Replace("'", "").Replace("--", "") + "' ";
         //单号
         if (TxtRetailNo.Text.Trim().Length > 0)
         {
             condition += " and retailid='" + TxtRetailNo.Text.Trim().Replace("'", "").Replace("--", "") + "' ";
             X.Js.AddScript("retailno='" + TxtRetailNo.Text.Trim().Replace("'", "").Replace("--", "") + "';#{RetailSubStore}.reload();");
         }
         //开始结束如期
         if (DTStart.SelectedValue != null)
             condition += " and setdate>='" + DTStart.SelectedValue.ToString() + "' ";
         if (DTEnd.SelectedValue != null)
             condition += " and setdate<='" + DTEnd.SelectedValue.ToString() + "' ";
         //状态
         condition += CboState.Value.ToString();
         CJ_DevelopHelper.SqlStr = sql + condition;
         DataTable dt = CJ_DevelopHelper.SQL_ReturnDateTable;
         RetailStore.DataSource = dt;
         RetailStore.DataBind();
     }
     catch (Exception error)
     {
         X.MessageBox.Alert("异常", error.Message).Show();
     }
 }

 //绑定Grid
 protected void Y_GBCode_DataBind(object sender, StoreRefreshDataEventArgs e)
 {
     e.Total = int.Parse(WMSFactory.Y_GBCode.GetTotalCount(e.Parameters[Y_GBCode_Filter.ParamPrefix], ""));
     IList<Y_GBCode> list = WMSFactory.Y_GBCode.FindAllByPage(e.Start, e.Limit, 1, e.Parameters[Y_GBCode_Filter.ParamPrefix], "");
     Y_GBCode_MainStore.DataSource = list;
     Y_GBCode_MainStore.DataBind();
 }

        protected void RefreshLogLines(object sender, StoreRefreshDataEventArgs e)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
            CommonDomain provider = new CommonDomain();

            List<object> data = new List<object>();
            string[] lines = File.ReadAllLines(string.Format("c:\\Logs\\Advance\\{0}", listFilesSelect.Value.ToString()));
            int lineIndex = 0;
            foreach (string line in lines)
            {
                LogLine logLine = new LogLine(line);
                data.Add(new
                {
                    evTime = logLine.Time.ToString("HH:mm:ss"),
                    evUser = provider.Users.Single(us => us.ID == logLine.UserID).Name,
                    evLevel = logLine.Level,
                    evObject = logLine.Object,
                    evAction = logLine.Action,
                    evIndex = lineIndex
                });
                ++lineIndex;
            }
            logLinesStore.DataSource = data;
            logLinesStore.DataBind();
        }

 protected void RefreshItems(object sender, StoreRefreshDataEventArgs e)
 {
     int id  = int.Parse(PaymentId.Text);
         var items = ObjectContext.DisbursementItems.Where(entity => entity.PaymentId == id).ToList();
         OtherDisbursementItems.DataSource = items;
         OtherDisbursementItems.DataBind();
 }

 protected void filesStore_RefreshData(object sender, StoreRefreshDataEventArgs e)
 {
     int nodeID = Convert.ToInt32(e.Parameters["node"]);
     FileType type = e.Parameters.Any(p => p.Name == "type") ? (FileType) Enum.Parse(typeof(FileType), e.Parameters["type"], true) : FileType.Both;
     ContentItem contentItem = Engine.Persister.Get(nodeID);
     filesStore.DataSource = GetFiles(contentItem, type);
     filesStore.DataBind();
 }

 //绑定Grid
 protected void Y_StyleFoundation_DataBind(object sender, StoreRefreshDataEventArgs e)
 {
     e.Total = int.Parse(WMSFactory.Y_StyleFoundation.GetTotalCount(e.Parameters[Y_StyleFoundation_Filter.ParamPrefix], ""));
     IList<Y_StyleFoundation> list = WMSFactory.Y_StyleFoundation.FindAllByPage(e.Start, e.Limit, 1, e.Parameters[Y_StyleFoundation_Filter.ParamPrefix], "");
     Session["cond"] = e.Parameters[Y_StyleFoundation_Filter.ParamPrefix];
     Y_StyleFoundation_MainStore.DataSource = list;
     Y_StyleFoundation_MainStore.DataBind();
 }

 protected void Shops_DataBind(object sender, StoreRefreshDataEventArgs e)
 {
     string condition = Server.HtmlEncode(TxtSearch.Text.Trim().Replace("'", ""));
     if (condition.Trim().Length > 0)
         condition = " depotid like '%" + condition + "%' or d_name like '%" + condition + "%'";
     e.Total = int.Parse(GetTotalCount(condition));
     Shops_MainStore.DataSource = GetShops(e.Limit.ToString(), e.Start.ToString(), condition);
     Shops_MainStore.DataBind();
 }

    protected void Report_DataBind(object sender, StoreRefreshDataEventArgs e)
    {
        try
        {
            //if (TxtVIPNo.Text.Trim().Length <= 0)
            //{
            //    X.MessageBox.Alert("提醒", "请输入VIP卡号！").Show();
            //    return;
            //}
            string strTempWhere = "";
            string StrVipNo = TxtVIPNo.Text.Trim();//VIP卡号
            string StrVipPhone = TxtVIPPhone.Text.Trim();//手机
            string StrVipName = TxtVIPName.Text.Trim();//姓名
            if (StrVipNo == "" && StrVipPhone == "" && StrVipName == "")
            {
                strTempWhere = "";
            }
            else
            {
                if (StrVipNo != "")
                {
                    strTempWhere += " AND vipcode='" + StrVipNo + "' ";
                }
                if (StrVipPhone != "")
                {
                    strTempWhere += " AND mobtel='" + StrVipPhone + "' ";
                }
                if (StrVipName != "")
                {
                    strTempWhere += " AND vipname='" + StrVipName + "' ";
                }
            }


            string sql = @"SELECT   CONVERT(VARCHAR(10), crdate, 21) crdate,vipsex, vipcode , vipname , vipstate , centum , pcentum , mobtel ,  CONVERT(VARCHAR(10), vipbirth, 21) vipbirth , 
                                  tz_name , vipoccupation , vipid , FBuyID ,  CONVERT(VARCHAR(10), viplastdate, 21) viplastdate , lastSums,vip_photo , add_province 
                                  , vipadd ,  vipname , vipsex , Employeeid , tz_name , mobtel ,  CONVERT(VARCHAR(10), vipbirth, 21) vipbirth , vipoccupation , FBuyID  
                                  , add_city , vipadd , vip_communi , vipgrab , viplove , vipbrand1 , vipbrand2 , vipbrand3 , stature , vip_body , vip_skin , vippaper 
                                  , vip_cosmetic , vip_drink , vipcolor , vip_news , vip_gift
                          FROM    vip_user WITH(NOLOCK) WHERE  ISNULL(vipid,'') != '' and  depotid = '{0}'";
            DevelopHelper.SqlStr = String.Format(sql + strTempWhere, depotid);
            DataTable dt = DevelopHelper.SQL_ReturnDateTable;
            if (dt.Rows.Count < 1)
            {
                X.MessageBox.Alert("提醒", "请检查条件！").Show();
                return;
            }
            VIPStore.DataSource = dt;
            VIPStore.DataBind();
        }
        catch (Exception error)
        {
            X.MessageBox.Alert("异常", error.Message).Show();
        }
    }

 protected void Report_DataBind(object sender, StoreRefreshDataEventArgs e)
 {
     if (Request["shopid"] == null) return;
     CJ_DevelopHelper.SqlConn_Str = ConfigurationManager.AppSettings["F22"];
     CJ_DevelopHelper.SqlStr = "select depotid from j_user where userid='" + Request["shopid"].ToString() + "'";
     DataTable dt = CJ_DevelopHelper.SQL_ReturnDateTable;
     if (dt.Rows.Count <= 0) return;
     CJ_DevelopHelper.SqlStr = "select xl 系列,stycolorid 款式,get_date 上货日期,nums 销售,k_num 库存 from T_skctopsale_message where depotid1='" + dt.Rows[0][0].ToString() + "' and nums=0 order by xl desc";
     Report_MainStore.DataSource = CJ_DevelopHelper.SQL_ReturnDateTable;
     Report_MainStore.DataBind();
 }

        protected void storeSPDayReport_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            List<SPDayReportWrapper> spDayReports = SPDayReportWrapper.CaculateReport(System.DateTime.Now.Date,this.Client);

            storeSPDayReport.DataSource = spDayReports;
            storeSPDayReport.DataBind();

 
            this.lblTotalDownTotalCount.Text = spDayReports.Sum(p => p.DownTotalCount).ToString();
            this.lblTotalDownSycnSuccess.Text = spDayReports.Sum(p => p.DownSycnSuccess).ToString();
            this.lblTotalDownSycnFailed.Text = spDayReports.Sum(p => p.DownSycnFailed).ToString();
 
        }

 protected void RefreshPlanesDeCuentas(object sender, StoreRefreshDataEventArgs e)
 {
     try
     {
         IList planes = Admin.ObtenerPlanesDeCuentas(CodEmpresa, CodEjercicio);
         StorePlanes.DataSource = planes;
         StorePlanes.DataBind();
     }
     catch (Exception ex)
     {
         IU.UIHelper.MostrarExcepcionSimple(ex, "Error al intentar actualizar listados");
     }
 }

 protected void AddEstadosNotaSt_Refresh(object sender, StoreRefreshDataEventArgs e)
 {
     try
     {
         EstadoNotaDePesoLogic estadologic = new EstadoNotaDePesoLogic();
         this.AddEstadosNotaSt.DataSource = estadologic.GetEstadosIniciales();
         this.AddEstadosNotaSt.DataBind();
     }
     catch (Exception ex)
     {
         log.Fatal("Error fatal al obtener estados de nota de peso para agregar.", ex);
         throw;
     }
 }

    //绑定Grid
    protected void d_Move_DataBind(object sender, StoreRefreshDataEventArgs e)
    {
        if (string.IsNullOrEmpty(Request["userid"])) return;
        string condition = "shjjdepotid is not null and shjjdepotid!='' and setcr_name='" + WMSFactory.d_Move.GetCurUser(Request["userid"]) + "' ";
        if (this.TxtMoveId.Text.Trim().Length > 0)
            condition += string.Format("and moveid like '%{0}%' ", Server.HtmlEncode(TxtMoveId.Value.ToString().Replace("'", "")));
        if (DateFrom.SelectedValue != null)
            condition += "and setcr_date>='" + ((DateTime)DateFrom.SelectedValue).ToString("yyyy-MM-dd") + "' ";
        if (DateEnd.SelectedValue != null)
            condition += "and setcr_date<='" + ((DateTime)DateEnd.SelectedValue).ToString("yyyy-MM-dd") + " 23:59:59' ";

        IList<d_Move> list = WMSFactory.d_Move.FindByCondition(condition);
        d_Move_MainStore.DataSource = list;
        d_Move_MainStore.DataBind();
    }

 protected void PrestamosSt_Reload(object sender, StoreRefreshDataEventArgs e)
 {
     try
     {
         TiposPrestamoLogic prestamo = new TiposPrestamoLogic();
         var store1 = this.PrestamosGridP.GetStore();
         store1.DataSource = prestamo.getData();
         store1.DataBind();
     }
     catch (Exception ex)
     {
         log.Fatal("Error fatal al cargar tipos de prestamo.", ex);
         throw;
     }
 }

        protected void storeSPDayReport_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            List<SPDayReportWrapper> spDayReports = SPDayReportWrapper.QueryReport(dfStart.SelectedDate, dfStart.SelectedDate);

            storeSPDayReport.DataSource = spDayReports;
            storeSPDayReport.DataBind();

            this.lblTotalTotalCount.Text = spDayReports.Sum(p => p.TotalCount).ToString();
            this.lblTotalTotalSuccessCount.Text = spDayReports.Sum(p => p.TotalSuccessCount).ToString();
            this.lblTotalInterceptCount.Text = spDayReports.Sum(p => p.InterceptCount).ToString();
            this.lblTotalDownTotalCount.Text = spDayReports.Sum(p => p.DownTotalCount).ToString();
            this.lblTotalDownSycnSuccess.Text = spDayReports.Sum(p => p.DownSycnSuccess).ToString();
            this.lblTotalDownSycnFailed.Text = spDayReports.Sum(p => p.DownSycnFailed).ToString();
            this.lblTotalDownNotSycn.Text = spDayReports.Sum(p => p.DownNotSycn).ToString();
        }

        protected void FormatKeysSt_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            try
            {
                string formatKey = this.EditLlaveTxt.Text;
                PlantillaLogic plantillalogic = new PlantillaLogic();

                this.FormatKeysSt.DataSource = plantillalogic.GetFormatKeys(formatKey);
                this.FormatKeysSt.DataBind();
            }
            catch (Exception ex)
            {
                log.Fatal("Error fatal al cargar llaves de formato para plantilla de notificacion.", ex);
                throw;
            }
        }

        /**
        public override List<string> UserTypesAllowed
        {
            get
            {
                List<string> allowed = new List<string>();
                allowed.Add("Super Admin");
                allowed.Add("Teller");
                allowed.Add("Admin");
                return allowed;
            }
        }
        **/
        protected void RefreshData(object sender, StoreRefreshDataEventArgs e)
        {
            DateTime today = DateTime.Now.Date;
            lblCurrentDate.Text = today.ToString("MMMM dd, yyyy");
            var queryList = CreateQuery(today);
            decimal total = 0;
            foreach (var item in queryList)
            {
                total = total + item.Amount;
            }

            lblTotalAmount.Text = "Total Amount: " + total.ToString("N");
            lblTotalNumberOfCheques.Text = "Total Number of Checks Received: " + queryList.Count().ToString();

            this.ChequesReportStore.DataSource = queryList.Take(e.Limit).Skip(e.Start);
            this.ChequesReportStore.DataBind();
        }

        protected void RefreshData(object sender, StoreRefreshDataEventArgs e)
        {
            DateTime startDate = DateTime.Parse(hdnDate.Value.ToString());
            var endDate = dtEndDate.SelectedDate;

            lblStartDate.Text = startDate.ToString("MMMM yyyy");
            lblEndDate.Text = string.Empty;

            var queryList = CreateQuery(startDate, endDate).OrderBy(entity => entity.CheckDate);
            decimal total = queryList.Sum(entity => entity.CheckAmount);

            lblTotalAmount.Text = "Total Amount: " + total.ToString("N");
            //lblTotalNumberOfCheques.Text = "Total Number of Checks Received: " + queryList.Count().ToString();

            ChequesReportStore.DataSource = queryList;
            ChequesReportStore.DataBind();
        }

        protected void PrivilegiosDeRolSt_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            try
            {
                int rol_id = string.IsNullOrEmpty(this.EditIdTxt.Text) ? 0 : Convert.ToInt32(this.EditIdTxt.Text);

                RolLogic rollogic = new RolLogic();
                int priv_id = string.IsNullOrEmpty(this.f_PRIV_ID.Text) ? 0 : Convert.ToInt32(this.f_PRIV_ID.Text);
                this.PrivilegiosDeRolSt.DataSource = rollogic.GetPrivilegios(rol_id, priv_id, this.f_PRIV_NOMBRE.Text, this.f_PRIV_LLAVE.Text);
                this.PrivilegiosDeRolSt.DataBind();
            }
            catch (Exception ex)
            {
                log.Fatal("Error fatal al cargar privilegios de rol.", ex);
                throw;
            }
        }