/// <summary>
/// 通过片区获取(分页)楼盘
/// </summary>
/// <param name="scopeId">片区primarykey</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">每页数量</param>
/// <param name="recordCount">总页数</param>
/// <returns></returns>
public DataTable GetEstateByScope(string scopeId, int pageIndex, int pageSize, out int recordCount)
{
string funMsg = "function: GetEstateByScope(string scopeId)" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "sp_getallest";//"spListEstateByScope";
return(DbUtility.GetDataTableByProc(procedureName, _CentaDbConn, out recordCount, new SqlParameter[] {
new SqlParameter {
ParameterName = "@scopeId", SqlDbType = SqlDbType.Char, Value = scopeId
},
new SqlParameter {
ParameterName = "@pageIndex", SqlDbType = SqlDbType.Int, Value = pageIndex
},
new SqlParameter {
ParameterName = "@pageSize", SqlDbType = SqlDbType.Int, Value = pageSize
},
new SqlParameter {
ParameterName = "@recordCount", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output
}
}));
}
catch (Exception ex)
{
string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg;
throw new Exception(exMsg, ex.InnerException);
}
}
/// <summary>
///
/// </summary>
/// <param name="keyword"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public DataTable GetEstateNameByKeyword(string keyword, string type, string code, int pageIndex, int pageSize, out int recordCount)
{
string funMsg = "function: GetEstateNameByKeyword(string keyword, string type, string code, int pageIndex, int pageSize, out int recordCount)" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "spListEstateNameByKeyword";
return(DbUtility.GetDataTableByProc(procedureName, this._CentaDbConn, out recordCount, new SqlParameter[] {
new SqlParameter {
ParameterName = "@keyword", SqlDbType = SqlDbType.NVarChar, Value = keyword
},
new SqlParameter {
ParameterName = "@type", SqlDbType = SqlDbType.NVarChar, Value = type
},
new SqlParameter {
ParameterName = "@code", SqlDbType = SqlDbType.NVarChar, Value = code
},
new SqlParameter {
ParameterName = "@pageIndex", SqlDbType = SqlDbType.Int, Value = pageIndex
},
new SqlParameter {
ParameterName = "@pageSize", SqlDbType = SqlDbType.Int, Value = pageSize
},
new SqlParameter {
ParameterName = "@recordCount", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output
}
}));
}
catch (Exception ex)
{
string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg;
throw new Exception(exMsg, ex.InnerException);
}
}
/// <summary>
///
/// </summary>
/// <param name="buildId"></param>
/// <param name="floor"></param>
/// <param name="room"></param>
/// <returns></returns>
public DataTable GetUnitByBuild(string buildId, string floor, string room)
{
string funMsg = "function: GetUnitByBuild(string buildId, string floor, string room)" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "sp_getallunit_DB";//"spListUnitByBuild";
return(DbUtility.GetDataTableByProc(procedureName, _CentaDbConn, new SqlParameter[] {
new SqlParameter {
ParameterName = "@buildId", SqlDbType = SqlDbType.NVarChar, Value = buildId
},
new SqlParameter {
ParameterName = "@floor", SqlDbType = SqlDbType.NVarChar, Value = floor
},
new SqlParameter {
ParameterName = "@room", SqlDbType = SqlDbType.NVarChar, Value = room
}
}));
}
catch (Exception ex)
{
string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg;
throw new Exception(exMsg, ex.InnerException);
}
}
public DataTable ListComparedBuild(ComparedEstateType comparedEstate, int pageIndex, int pageSize, out int recordCount)
{
string funMsg = "function: ListComparedBuild(ComparedEstateType comparedEstate, int pageIndex, int pageSize, out int recordCount)" + FileUtility.NewLine + _ClassMsg;
try
{
string procedure = "spListComapredBuild";
return(DbUtility.GetDataTableByProc(procedure, this.ConnStr, out recordCount, new SqlParameter[] {
new SqlParameter {
ParameterName = "@estateId", SqlDbType = SqlDbType.VarChar, Value = comparedEstate.EstateId
},
new SqlParameter {
ParameterName = "@framework_EstateId", SqlDbType = SqlDbType.VarChar, Value = comparedEstate.Framework_EstateId
},
new SqlParameter {
ParameterName = "@pageIndex", SqlDbType = SqlDbType.Int, Value = pageIndex
},
new SqlParameter {
ParameterName = "@pageSize", SqlDbType = SqlDbType.Int, Value = pageSize
},
new SqlParameter {
ParameterName = "@recordCount", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output
}
}));
}
catch (Exception ex)
{
throw ex;
}
}
protected DataTable GetDataTable()
{
string funMsg = "Function: GetDataTable()" + FileUtility.NewLine + _ClassMsg;
string procedureName = "spListUserInfo";
try
{
return(DbUtility.GetDataTableByProc(procedureName, _ConnStr));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable ListOrderStatus()
{
string funMsg = "function: ListOrderStatus()" + FileUtility.NewLine + _ClassMsg;
try
{
string procedure = "spListOrderStatus";
return(DbUtility.GetDataTableByProc(procedure, this.ConnStr));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取所有片区
/// </summary>
/// <returns></returns>
public DataTable GetScopes()
{
string funMsg = "function: GetScopes();" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "spListScope";
return(DbUtility.GetDataTableByProc(procedureName, _CentaDbConn));
}
catch (Exception ex)
{
string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg;
throw new Exception(exMsg, ex.InnerException);
}
}
public virtual DataTable ListRoom(string buildId)
{
string funMsg = "Function: ListRoom(string buildId)" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "spListRoom";
return(DbUtility.GetDataTableByProc(procedureName, this.ConnStr, new SqlParameter[] {
new SqlParameter {
ParameterName = "@buildId", SqlDbType = SqlDbType.Char, Value = buildId
}
}));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetCompletedEstate(int banch)
{
string funMsg = "function: GetCompletedEstate(int banch)" + FileUtility.NewLine + _ClassMsg;
try
{
string procedure = "spGetCompletedEstate";
return(DbUtility.GetDataTableByProc(procedure, this.ConnStr, new SqlParameter
{
ParameterName = "@banch",
SqlDbType = SqlDbType.VarChar,
Value = banch
}));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable ListBuildByCm(string agencyCom_EstateId)
{
string funMsg = "function: ListBuildByCm(string agencyCom_EstateId)" + FileUtility.NewLine + _ClassMsg;
try
{
string procedure = "spListBuildByCm";
return(DbUtility.GetDataTableByProc(procedure, this.ConnStr, new SqlParameter
{
ParameterName = "@agencyCom_EstateId",
SqlDbType = SqlDbType.VarChar,
Value = agencyCom_EstateId
}));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable ListOrder(int banch, int orderStatus)
{
string funMsg = "function: ListOrder(int banch, int orderStatus)" + FileUtility.NewLine + _ClassMsg;
try
{
string procedure = "spListOrder";
return(DbUtility.GetDataTableByProc(procedure, this.ConnStr, new SqlParameter[] {
new SqlParameter {
ParameterName = "@banch", SqlDbType = SqlDbType.VarChar, Value = banch
},
new SqlParameter {
ParameterName = "@orderStatus", SqlDbType = SqlDbType.VarChar, Value = orderStatus
},
}));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable ListComparedRoom(ComparedBuildType comparedBuild)
{
string funMsg = "Function: ListComparedRoom(string buildId)" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "spListComparedRoom";
return(DbUtility.GetDataTableByProc(procedureName, this.ConnStr, new SqlParameter[] {
new SqlParameter {
ParameterName = "@buildId", SqlDbType = SqlDbType.VarChar, Value = comparedBuild.BuildId
},
new SqlParameter {
ParameterName = "@framework_BuildId", SqlDbType = SqlDbType.VarChar, Value = comparedBuild.Framework_BuildId
},
}));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="estateId"></param>
/// <param name="buildName"></param>
/// <returns></returns>
public DataTable GetBuildByName(string estateId, string buildName)
{
string funMsg = "function: GetBuild(string estateId, string buildName)" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "spListBuildByName";
return(DbUtility.GetDataTableByProc(procedureName, this._CentaDbConn, new SqlParameter[] {
new SqlParameter {
ParameterName = "@estateId", SqlDbType = SqlDbType.NVarChar, Value = estateId
},
new SqlParameter {
ParameterName = "@buildName", SqlDbType = SqlDbType.NVarChar, Value = buildName
}
}));
}
catch (Exception ex)
{
string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg;
throw new Exception(exMsg, ex.InnerException);
}
}
