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