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