/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Partsid,PartsName,PartsModel,PartsType,PartsUnit,PartStockData,PartsSurplusData,PartsCode,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,Price,Remark "); strSql.Append(" FROM T_EquipmentParts "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select PointCode,GeneCode,DevCode,isStop,DayNum,StandardValue,DayMaxValue,DayMinValue,ChangeType,ChangeRate,Multiple,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG "); strSql.Append(" FROM T_StationGeneSet "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,TypeName,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG "); strSql.Append(" FROM T_GeneType "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AreaID,AreaCode,AreaName,province,city,distinguish,town,remark,reportno,realtimeaddress,historyaddress,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG "); strSql.Append(" FROM T_Area "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,Name "); strSql.Append(" FROM T_OperatedLevel "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select InstrumentID,InstrumentName,InstrumentModel,InstrumentType,SupplierId,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,KingdeeId,InnerId,Remark "); strSql.Append(" FROM T_Instrument "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AreaCode,CompanyCode,CompanyName,CompanyType,CompanyIndustry,CompanyPhone,CompanyLegal,CompanyLegalNo,CompanyAddress,Town,Street,CompanyIsStop,remark,UpdateTime,UpdatePerson,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,contrator,CompanyID,AreaID,Longitude,latitude "); strSql.Append(" FROM T_Company "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AreaName,PointID,PointName,MnCode,geneID,genename,unit,geneT212,InstrumentID,InstrumentName,InstrumentModel,InstallDate,DevCode,isStop,DayNum,RangeDown,RangeUp,StandardMinValue,StandardMaxValue,DayMinValue,DayMaxValue,ChangeType,ChangeRate,DetectionPrinciple,HasZs,HasPf,IsJudgeStandard,DecimalPlaces,Sort,PointUses,PointCode "); strSql.Append(" FROM V_StationDevGene "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AreaCode,AreaName,CompanyCode,companyname,PointCode,PointName,envirlevel,operatedlevel,Name,MnCode,RouterIP,DataIP,VedioIP,LineNo,Vlan,NetOperator,NetType,是否运维,是否合同,是否巡检 "); strSql.Append(" FROM V_StationIp "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,PointID,DevCode,GeneID,isStop,DayNum,RangeUp,RangeDown,StandardMaxValue,StandardMinValue,IsJudgeStandard,DayMaxValue,DayMinValue,ChangeType,ChangeRate,DetectionPrinciple,HasZs,HasPf,DecimalPlaces,Sort,RecordFlag,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG "); strSql.Append(" FROM T_DevGeneSet "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ContractorID,CompanyCode,Name,cellphone,telephone,remark,qq,email,fax,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,ID,RecordFlag "); strSql.Append(" FROM T_Contractor "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AreaName,CompanyCode,CompanyName,PointCode,PointCode1,PointName,PointUses,是否运维,IsPatrol,是否巡检,IsContract,是否合同,PointType,Name,OutletNo,PassTime,EnvirLevel,OperatedLevel,OperatedCenter,OperatedGroup,Director,MnCode,RouterIP,DataIP,VedioIP,LineNo,Vlan,NetOperator,NetType,remark,UpdateTime,UpdatePerson,CompanyID,PointID,AreaCode,PointCodeB,frequency,latitude,Longitude,Pointaddress "); strSql.Append(" FROM V_Station2 "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SupplierId,SupplierName,Address,Phone,Remark,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG "); strSql.Append(" FROM T_Supplier "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select CompanyCode,PointCode,PointName,PointUses,PointType,OperatedLevel,OperatedCenter,OperatedGroup,Director,RouterIP,DataIP,VedioIP,LineNo,Vlan,NetOperator,NetType,remark,UpdateTime,UpdatePerson,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,MnCode,OutletNo,PassTime,PointCode1,EnvirLevel,IsPatrol,IsContract,CompanyID,PointID,Longitude,latitude,frequency,Pointaddress,PointCodeB,Controlsystem,Treatmentprocess "); strSql.Append(" FROM T_StationInformation "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SortId,AreaName,CompanyCode,CompanyName,PointCode,PointName,Name,OperatedLevel,InstrumentID,InstrumentName,InstrumentModel,InstrumentType,InstallDate,DevCode,DetectionPrinciple,RangeLow,RangeUp,Protocol,TransmissionType,DevStatus,Remark,StationDevID,RecordFlag,PointID "); strSql.Append(" FROM V_StationDev "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select PointID,RouterIP,RouterPort,RounterUser,RounterPws,DataIP,DataPort,DataUser,DataPws,VedioIP,VideoPort,VidioID,VideoUser,VideoPws,LineNo,Vlan,NetOperator,NetType,PW,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG "); strSql.Append(" FROM T_StationNet "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AreaCode,areaname,companycode,companyname,CompanyType,CompanyIndustry,CompanyAddress,CompanyPhone,CompanyLegal,CompanyLegalNo,CompanyIsStop,是否运维,town,Street,remark,UpdateTime,UpdatePerson,CompanyID,AreaID "); strSql.Append(" FROM V_Company "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select geneID,genename,genecode,genecodeExpand,geneT212,unit,m_decimal,DataType,ZS,remark,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,GeneType "); strSql.Append(" FROM T_Geneset "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select InstrumentID,PointCode,InstallDate,DevCode,DetectionPrinciple,RangeLow,RangeUp,Protocol,TransmissionType,DevStatus,Remark,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,StationDevID,RecordFlag,PointID,Processmetermodel,Inputtime,currentsituation "); strSql.Append(" FROM T_StationDev "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得前几行数据 /// </summary> public DataSet GetList(int Top, string strWhere, string filedOrder) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" ID,Name "); strSql.Append(" FROM T_OperatedLevel "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by " + filedOrder); return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得前几行数据 /// </summary> public DataSet GetList(int Top, string strWhere, string filedOrder) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" PointType,Name,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG "); strSql.Append(" FROM T_StationType "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by " + filedOrder); return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得前几行数据 /// </summary> public DataSet GetList(int Top, string strWhere, string filedOrder) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" SupplierId,SupplierName,Address,Phone,Remark,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG "); strSql.Append(" FROM T_Supplier "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by " + filedOrder); return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_StationGeneSet GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 PointCode,GeneCode,DevCode,isStop,DayNum,StandardValue,DayMaxValue,DayMinValue,ChangeType,ChangeRate,Multiple,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG from T_StationGeneSet "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.T_StationGeneSet model = new Maticsoft.Model.T_StationGeneSet(); DataSet ds = DbBaseHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_GeneType GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,TypeName,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG from T_GeneType "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.T_GeneType model = new Maticsoft.Model.T_GeneType(); DataSet ds = DbBaseHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_OperatedLevel GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Name from T_OperatedLevel "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.T_OperatedLevel model = new Maticsoft.Model.T_OperatedLevel(); DataSet ds = DbBaseHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_Instrument GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 InstrumentID,InstrumentName,InstrumentModel,InstrumentType,SupplierId,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,KingdeeId,InnerId,Remark from T_Instrument "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.T_Instrument model = new Maticsoft.Model.T_Instrument(); DataSet ds = DbBaseHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.V_Station2 GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 AreaName,CompanyCode,CompanyName,PointCode,PointCode1,PointName,PointUses,是否运维,IsPatrol,是否巡检,IsContract,是否合同,PointType,Name,OutletNo,PassTime,EnvirLevel,OperatedLevel,OperatedCenter,OperatedGroup,Director,MnCode,RouterIP,DataIP,VedioIP,LineNo,Vlan,NetOperator,NetType,remark,UpdateTime,UpdatePerson,CompanyID,PointID,AreaCode,PointCodeB,frequency,latitude,Longitude,Pointaddress from V_Station2 "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.V_Station2 model = new Maticsoft.Model.V_Station2(); DataSet ds = DbBaseHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.V_StationDevGene GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 AreaName,PointID,PointName,MnCode,geneID,genename,unit,geneT212,InstrumentID,InstrumentName,InstrumentModel,InstallDate,DevCode,isStop,DayNum,RangeDown,RangeUp,StandardMinValue,StandardMaxValue,DayMinValue,DayMaxValue,ChangeType,ChangeRate,DetectionPrinciple,HasZs,HasPf,IsJudgeStandard,DecimalPlaces,Sort,PointUses,PointCode from V_StationDevGene "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.V_StationDevGene model = new Maticsoft.Model.V_StationDevGene(); DataSet ds = DbBaseHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 分页获取数据列表 /// </summary> public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM ( "); strSql.Append(" SELECT ROW_NUMBER() OVER ("); if (!string.IsNullOrEmpty(orderby.Trim())) { strSql.Append("order by T." + orderby); } else { strSql.Append("order by T.CompanyID desc"); } strSql.Append(")AS Row, T.* from V_Station2 T "); if (!string.IsNullOrEmpty(strWhere.Trim())) { strSql.Append(" WHERE " + strWhere); } strSql.Append(" ) TT"); strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex); return(DbBaseHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.V_StationIp GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 AreaCode,AreaName,CompanyCode,companyname,PointCode,PointName,envirlevel,operatedlevel,Name,MnCode,RouterIP,DataIP,VedioIP,LineNo,Vlan,NetOperator,NetType,是否运维,是否合同,是否巡检 from V_StationIp "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.V_StationIp model = new Maticsoft.Model.V_StationIp(); DataSet ds = DbBaseHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }