Пример #1
0
        private void LoadDataGrid()
        {
            try
            {
                RoomStrategyBuilder sb = new RoomStrategyBuilder("V_ROOM");

                string ProjectCode = this.txtProjectCode.Value;
                if (ProjectCode != "")
                {
                    sb.AddStrategy(new Strategy(RoomStrategyName.ProjectCode, ProjectCode));
                }

                if (this.tbSearchRoom.Visible)
                {
                    ((SearchRoom)this.tbSearchRoom).AddSearch(sb);
                }

                sb.AddOrder("BuildingName", true);
                sb.AddOrder("ChamberCode", true);
                sb.AddOrder("FloorIndex", true);
                sb.AddOrder("RoomName", true);

                string sql = sb.BuildMainQueryString();

                QueryAgent qa     = new QueryAgent();
                EntityData entity = qa.FillEntityData("V_ROOM", sql);
                qa.Dispose();

                dgList.Columns[2].FooterText = entity.CurrentTable.Rows.Count.ToString() + " 条";
                dgList.Columns[5].FooterText = BLL.MathRule.SumColumn(entity.CurrentTable, "BuildArea").ToString("0.####");
                dgList.DataSource            = entity;
                dgList.DataBind();
                entity.Dispose();
            }
            catch (Exception ex)
            {
                ApplicationLog.WriteLog(this.ToString(), ex, "");
                Response.Write(Rms.Web.JavaScript.Alert(true, "初始化页面出错:" + ex.Message));
            }
        }
Пример #2
0
        private void LoadDataGridFromBuilding(string BuildingCode)
        {
            try
            {
                //检查是否可修改
                string hint = BLL.ProductRule.CanModifyRoomArea(BuildingCode);
                if (hint != "")
                {
                    Response.Write(Rms.Web.JavaScript.Alert(true, hint));
                    Response.Write(Rms.Web.JavaScript.WinClose(true));
                    return;
                }

                RoomStrategyBuilder sb = new RoomStrategyBuilder("V_ROOM");

                sb.AddStrategy(new Strategy(RoomStrategyName.ProjectCode, this.txtProjectCode.Value));
                sb.AddStrategy(new Strategy(RoomStrategyName.BuildingCode, BuildingCode));

                sb.AddOrder("BuildingName", true);
                sb.AddOrder("ChamberCode", true);
                sb.AddOrder("FloorIndex", true);
                sb.AddOrder("RoomName", true);

                string sql = sb.BuildMainQueryString();

                QueryAgent qa     = new QueryAgent();
                EntityData entity = qa.FillEntityData("V_ROOM", sql);
                qa.Dispose();

                BindDataGrid(entity.CurrentTable);
                entity.Dispose();
            }
            catch (Exception ex)
            {
                ApplicationLog.WriteLog(this.ToString(), ex, "");
                Response.Write(Rms.Web.JavaScript.Alert(true, "初始化页面出错:" + ex.Message));
            }
        }
Пример #3
0
        private void LoadDataGrid(bool isEmpty)
        {
            try
            {
                RoomStrategyBuilder sb = new RoomStrategyBuilder("V_ROOM");

                if (isEmpty)
                {
                    sb.AddStrategy(new Strategy(RoomStrategyName.False));
                }

                string ProjectCode = this.txtProjectCode.Value;
                if (ProjectCode != "")
                {
                    sb.AddStrategy(new Strategy(RoomStrategyName.ProjectCode, ProjectCode));
                }

                if (ProjectCode == "")
                {
                    if (this.tbSearchRoomAll.Visible)
                    {
                        ((SearchRoomAll)this.tbSearchRoomAll).AddSearch(sb);
                    }
                }
                else
                {
                    if (this.tbSearchRoom.Visible)
                    {
                        ((SearchRoom)this.tbSearchRoom).AddSearch(sb);
                    }
                }

                //排序
                string sortsql = BLL.GridSort.GetSortSQL(ViewState);
                if (sortsql == "")
                {
                    //缺省排序
                    if (ProjectCode == "")
                    {
                        sb.AddOrder("ProjectName", true);
                    }

                    sb.AddOrder("BuildingName", true);
                    sb.AddOrder("ChamberCode", true);
                    sb.AddOrder("FloorIndex", true);
                    sb.AddOrder("RoomName", true);
                }

                string sql = sb.BuildMainQueryString();

                if (sortsql != "")
                {
                    //点列标题排序
                    sql = sql + " order by " + sortsql;
                }

                QueryAgent qa     = new QueryAgent();
                EntityData entity = qa.FillEntityData("V_ROOM", sql);
                qa.Dispose();

                string[]  arrField = { "BuildArea", "Cost", "TotalPayMoney" };
                decimal[] arrSum   = BLL.MathRule.SumColumn(entity.CurrentTable, arrField);

                ViewState["SumCount"]         = entity.CurrentTable.Rows.Count.ToString() + "套";
                ViewState["SumBuildArea"]     = BLL.StringRule.BuildShowNumberString(arrSum[0]);
                ViewState["SumCost"]          = BLL.StringRule.BuildShowNumberString(arrSum[1]);
                ViewState["SumTotalPayMoney"] = BLL.StringRule.BuildShowNumberString(arrSum[2]);

                dgList.DataSource = entity;
                dgList.DataBind();

                if (this.GridPagination1.Visible)
                {
                    this.GridPagination1.RowsCount = entity.CurrentTable.Rows.Count.ToString();
                }

                entity.Dispose();

                SetSelectRoomCode();

                //显示工具栏
                if (entity.HasRecord())
                {
                    this.trToolBar.Style["display"] = "";
                }
                else
                {
                    this.trToolBar.Style["display"] = "none";
                }
            }
            catch (Exception ex)
            {
                ApplicationLog.WriteLog(this.ToString(), ex, "");
                Response.Write(Rms.Web.JavaScript.Alert(true, "初始化页面出错:" + ex.Message));
            }
        }