public static int GetCount()
{
var sql = "select count(1) from " + AppSettings.TableSearch;
var row = DbUtility.GetDataRow(sql, AppSettings.ConnStr);
return(ConvertUtility.ToInt(row[0]));
}
public static int GetHandlerCount()
{
var sql = "select count(1) from " + AppSettings.TableSearch + " where status =1 or status=-1";
var row = DbUtility.GetDataRow(sql, AppSettings.ConnStr);
return(ConvertUtility.ToInt(row[0]));
}
public DataRow GetDataRow(int buildId)
{
string funMsg = "function: GetDataRow(int buildId)" + FileUtility.NewLine + _classMsg;
var strSql = new StringBuilder();
strSql.Append(
"select CentaBuildId,centaest,cestcode,centabldg,cblgcode,lpt_x,lpt_y,usage,c_estate,e_estate,c_phase,e_phase,c_property,e_property,pc_addr1,pc_addr2,pe_addr,opdate,unit_cnt,x_cnt,y_cnt,scp_id,scp_c,scp_e,scp_mkt,nmark,o_estateid,o_bldgid,estateid,buildingid,address,moddate,pc_street1,pc_street2,pe_street1,pe_street2,pc_stno1,pc_stno2,ppt_rank,org_cenblg,org_cenest,need_clear,x_axis,x_axis2,y_axis,y_axis2,cblk_key ");
strSql.Append(" FROM [centabldg] ");
strSql.Append(" where CentaBuildId=@buildId ");
SqlParameter[] parameters =
{
new SqlParameter("@buildId", SqlDbType.Int, 4)
};
parameters[0].Value = buildId;
return(DbUtility.GetDataRow(strSql.ToString(), AppSettings.DbConn, parameters));
}
public static DataRow GetOrder()
{
var sql = "select top 1 * from " + AppSettings.TableSearch + " where status is null or status=0";
return(DbUtility.GetDataRow(sql.ToString(), AppSettings.ConnStr));
}
