public static int GetPBSUnitFloorCount(string PBSUnitCode)
{
int num2;
try
{
int num = 0;
BuildingStrategyBuilder builder = new BuildingStrategyBuilder();
builder.AddStrategy(new Strategy(BuildingStrategyName.PBSUnitCode, PBSUnitCode));
builder.AddOrder("FloorCount", false);
QueryAgent agent = new QueryAgent();
agent.SetTopNumber(1);
string queryString = builder.BuildMainQueryString();
DataTable table = agent.ExecSqlForDataSet(queryString).Tables[0];
if (table.Rows.Count > 0)
{
num = ConvertRule.ToInt(table.Rows[0]["IFloorCount"]);
}
agent.Dispose();
num2 = num;
}
catch (Exception exception)
{
throw exception;
}
return(num2);
}
/// <summary>
/// 按查询条件输出结果集
/// </summary>
/// <param name="sb"></param>
/// <returns></returns>
private DataTable BuildStrategy(BuildingStrategyBuilder sb)
{
try
{
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("Building", sql);
qa.Dispose();
return(entity.CurrentTable);
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadDataGrid()
{
try
{
BuildingStrategyBuilder sb = new BuildingStrategyBuilder();
string ProjectCode = this.txtProjectCode.Value;
if (ProjectCode != "")
{
sb.AddStrategy(new Strategy(BuildingStrategyName.ProjectCode, ProjectCode));
}
sb.AddStrategy(new Strategy(BuildingStrategyName.IsArea, "2"));
sb.AddOrder("BuildingName", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("Building", sql);
qa.Dispose();
//选择多个
if (this.m_Multi == "1")
{
DataRow dr = entity.CurrentTable.NewRow();
dr["BuildingCode"] = -1;
dr["BuildingName"] = "多选楼栋...";
entity.CurrentTable.Rows.InsertAt(dr, 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));
}
}
public static DataTable GetBuildingNoPBSUnit(string ProjectCode)
{
DataTable table2;
try
{
BuildingStrategyBuilder builder = new BuildingStrategyBuilder();
builder.AddStrategy(new Strategy(BuildingStrategyName.ProjectCode, ProjectCode));
builder.AddStrategy(new Strategy(BuildingStrategyName.IsArea, "2"));
builder.AddStrategy(new Strategy(BuildingStrategyName.NullPBSUnit));
builder.AddOrder("BuildingName", true);
QueryAgent agent = new QueryAgent();
string queryString = builder.BuildMainQueryString();
DataTable table = agent.ExecSqlForDataSet(queryString).Tables[0];
agent.Dispose();
table2 = table;
}
catch (Exception exception)
{
throw exception;
}
return(table2);
}
private void LoadDataGrid(bool isEmpty)
{
try
{
BuildingStrategyBuilder sb = new BuildingStrategyBuilder("V_Building");
if (isEmpty)
{
sb.AddStrategy(new Strategy(BuildingStrategyName.False));
}
string ProjectCode = this.txtProjectCode.Value;
if (ProjectCode != "")
{
sb.AddStrategy(new Strategy(BuildingStrategyName.ProjectCode, ProjectCode));
}
if (this.txtSearchProjectCode.Value != "")
{
sb.AddStrategy(new Strategy(BuildingStrategyName.InProjectCode, this.txtSearchProjectCode.Value));
}
if (this.sltSearchProjectStatus.Value != "")
{
sb.AddStrategy(new Strategy(BuildingStrategyName.ProjectStatus, this.sltSearchProjectStatus.Value));
}
if (this.txtSearchBuildingName.Value != "")
{
sb.AddStrategy(new Strategy(BuildingStrategyName.InBuildingName, this.txtSearchBuildingName.Value, "F"));
}
if (this.sltSearchPBSTypeCode.Value != "")
{
sb.AddStrategy(new Strategy(BuildingStrategyName.PBSTypeCodeAllChild, this.sltSearchPBSTypeCode.Value));
}
if (this.txtSearchInvestType.Value != "")
{
sb.AddStrategy(new Strategy(BuildingStrategyName.InInvestType, this.txtSearchInvestType.Value, "F"));
}
//排序
string sortsql = BLL.GridSort.GetSortSQL(ViewState);
if (sortsql == "")
{
//缺省排序
if (ProjectCode == "")
{
sb.AddOrder("ProjectName", true);
}
sb.AddOrder("BuildingName", true);
}
string sql = sb.BuildMainQueryString();
if (sortsql != "")
{
//点列标题排序
sql = sql + " order by " + sortsql;
}
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("V_Building", sql);
qa.Dispose();
string[] arrField = { "HouseArea", "RoomArea", "TotalCost" };
decimal[] arrSum = BLL.MathRule.SumColumn(entity.CurrentTable, arrField);
ViewState["SumCount"] = entity.CurrentTable.Rows.Count.ToString() + "幢";
ViewState["SumHouseArea"] = BLL.StringRule.BuildShowNumberString(arrSum[0]);
ViewState["SumRoomArea"] = BLL.StringRule.BuildShowNumberString(arrSum[1]);
ViewState["SumTotalCost"] = BLL.StringRule.BuildShowNumberString(arrSum[2]);
dgList.DataSource = entity;
dgList.DataBind();
if (this.GridPagination1.Visible)
{
this.GridPagination1.RowsCount = entity.CurrentTable.Rows.Count.ToString();
}
entity.Dispose();
//显示工具栏
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));
}
}
