/// <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); } }