コード例 #1
0
    private void RptBind(string _strWhere, string _orderby)
    {
        this.page = AXRequest.GetQueryInt("page", 1);

        if (this.depot_category_id > 0)
        {
            this.ddldepot_category_id.SelectedValue = this.depot_category_id.ToString();
        }
        if (this.depot_id > 0)
        {
            this.ddldepot_id.SelectedValue = this.depot_id.ToString();
        }

        txtNote_no.Text     = this.note_no;
        txtstart_time.Value = this.start_time;
        txtstop_time.Value  = this.stop_time;

        ps_salse_depot bll = new ps_salse_depot();

        this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
        this.rptList.DataBind();

        //this.Literal_go_price.Text = MyConvert(bll.GetTitleSum(_strWhere, "sum(goods_price)"));
        //this.Literal_zongprice.Text = MyConvert(bll.GetTitleSum(_strWhere, "sum(real_price)"));
        //this.Literal_zongprice_sj.Text = MyConvert(bll.GetTitleSum(_strWhere, "sum(quantity)"));
        this.Literal_lrprice.Text = MyConvert(Convert.ToDecimal(bll.GetTitleSum(_strWhere, " sum(real_price*quantity)")) - Convert.ToDecimal(bll.GetTitleSum(_strWhere, "sum(goods_price*quantity)")));
        this.Literal_hj.Text      = MyConvert(Convert.ToDecimal(bll.GetTitleSum(_strWhere, "sum(real_price*quantity)")));

        //绑定页码
        txtPageNum.Text = this.pageSize.ToString();
        string pageUrl = Utils.CombUrlTxt("sales_list.aspx", "depot_category_id={0}&depot_id={1}&start_time={2}&stop_time={3}&note_no={4}&page={5}", this.depot_category_id.ToString(), this.depot_id.ToString(), this.txtstart_time.Value, this.txtstop_time.Value, txtNote_no.Text, "__id__");

        PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
    }
コード例 #2
0
    // 单个删除
    protected void lbtnDelCa_Click(object sender, EventArgs e)
    {
        // 当前点击的按钮
        LinkButton lb   = (LinkButton)sender;
        int        caId = int.Parse(lb.CommandArgument);
        ps_manager bll  = new ps_manager();

        bll.GetModel(caId);
        string title = bll.user_name;

        ps_join_depot bllqd = new ps_join_depot();

        bllqd.user_id = caId;
        ps_salse_depot bllss = new ps_salse_depot();

        bllss.user_id = caId;
        if (!bllqd.ExistsYH() && !bllss.ExistsCZXS())
        {
            bll.Delete(caId);
            mym.AddAdminLog("删除", "删除用户名(账号):" + title + ""); //记录日志
            mym.JscriptMsg(this.Page, " 成功删除用户名(账号):" + title + "", Utils.CombUrlTxt("manager_list.aspx", "status={0}&category_id={1}&depot_id={2}&keywords={3}&page={4}", this.status.ToString(), this.category_id.ToString(), this.depot_id.ToString(), this.keywords, this.page.ToString()), "Success");
        }
        else
        {
            mym.JscriptMsg(this.Page, "系统中有该用户的相关操作记录,不能删除!可以通过修改禁用该用户!", "", "Error");
            return;
        }
    }
コード例 #3
0
    //绑定记录
    public void binddr()
    {
        string         sqlstr    = "";
        string         _strWhere = "";
        ps_salse_depot bll       = new ps_salse_depot();

        if (Convert.ToInt32(Session["DepotID"]) == 0 && Convert.ToInt32(Session["DepotCatID"]) == 0)
        {
            _strWhere = "id>0 ";
        }
        _strWhere = _strWhere + CombSqlTxt(this.depot_category_id, this.depot_id, this.note_no, this.start_time, this.stop_time);

        sqlstr = _strWhere + " order by add_time desc,id desc";
        DataView dv = bll.GetList(sqlstr).Tables[0].DefaultView;

        repCategory.DataSource = dv;
        repCategory.DataBind();

        //合计
        this.Literal_lrprice.Text = MyConvert(Convert.ToDecimal(bll.GetTitleSum(_strWhere, " sum(real_price*quantity)")) - Convert.ToDecimal(bll.GetTitleSum(_strWhere, "sum(goods_price*quantity)")));
        this.Literal_hj.Text      = MyConvert(Convert.ToDecimal(bll.GetTitleSum(_strWhere, "sum(real_price*quantity)")));
    }
コード例 #4
0
    protected void salesTopBind()
    {
        string         _start_time = DateTime.Now.AddDays(-7).ToString("d") + " 00:00:00";
        string         _stop_time  = DateTime.Now.ToString("d") + " 23:59:59";
        ps_salse_depot bll         = new ps_salse_depot();
        string         salesTop    = "";
        DataTable      dt          = bll.GetListSql("select top 10 depot_id,zongprice,zongcount from (select depot_id,sum(real_price*quantity) as zongprice ,count(id) as zongcount from [ps_salse_depot] where  add_time between  '" + DateTime.Parse(_start_time) + "' and '" + DateTime.Parse(_stop_time) + "' group by depot_id) a order by a.zongprice desc").Tables[0];

        foreach (DataRow dr in dt.Rows)
        {
            salesTop = salesTop + new ps_depot().GetTitle(Convert.ToInt32(dr["depot_id"].ToString())) + "   购买金额:" + MyConvert(dr["zongprice"].ToString()) + "    购买量:" + dr["zongcount"].ToString() + ",";
        }

        string    salesTop_price = "";
        DataTable dtp            = bll.GetListSql("select top 10 depot_id,zongprice from (select depot_id,sum(real_price*quantity) as zongprice from [ps_salse_depot] where  add_time between  '" + DateTime.Parse(_start_time) + "' and '" + DateTime.Parse(_stop_time) + "' group by depot_id) a order by a.zongprice desc").Tables[0];

        foreach (DataRow dr in dtp.Rows)
        {
            salesTop_price = salesTop_price + dr["zongprice"].ToString() + ",";
        }

        DataTable dtmy = bll.GetListSql("select top 1 depot_id,zongprice,zongcount from (select depot_id,sum(real_price*quantity) as zongprice ,count(id) as zongcount from [ps_salse_depot] where depot_id=" + Convert.ToInt32(Session["DepotID"]) + " and add_time between  '" + DateTime.Parse(_start_time) + "' and '" + DateTime.Parse(_stop_time) + "' group by depot_id) a order by a.zongprice desc").Tables[0];

        foreach (DataRow dr in dtmy.Rows)
        {
            Lit_mysalse.Text = "<font color=red>" + new ps_depot().GetTitle(Convert.ToInt32(dr["depot_id"].ToString())) + "   购买金额:" + MyConvert(dr["zongprice"].ToString()) + "    购买量:" + dr["zongcount"].ToString() + "</font>";
        }

        XmlDocument xmlDoc = new XmlDocument();

        xmlDoc.Load(Server.MapPath("piedata.xml"));
        //获得节点列表
        XmlNode xmlNode = xmlDoc.DocumentElement.ChildNodes.Item(0);

        xmlNode["pie_num"].InnerText  = Utils.DelLastComma(salesTop_price);
        xmlNode["pie_name"].InnerText = Utils.DelLastComma(salesTop);
        xmlDoc.Save(Server.MapPath("piedata.xml"));
    }