/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.V_Company model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into V_Company(");
strSql.Append("AreaCode,areaname,companycode,companyname,CompanyType,CompanyIndustry,CompanyAddress,CompanyPhone,CompanyLegal,CompanyLegalNo,CompanyIsStop,是否运维,town,Street,remark,UpdateTime,UpdatePerson,AreaID)");
strSql.Append(" values (");
strSql.Append("@AreaCode,@areaname,@companycode,@companyname,@CompanyType,@CompanyIndustry,@CompanyAddress,@CompanyPhone,@CompanyLegal,@CompanyLegalNo,@CompanyIsStop,@是否运维,@town,@Street,@remark,@UpdateTime,@UpdatePerson,@AreaID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AreaCode", SqlDbType.NVarChar, 15),
new SqlParameter("@areaname", SqlDbType.NVarChar, 255),
new SqlParameter("@companycode", SqlDbType.NVarChar, 255),
new SqlParameter("@companyname", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyType", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyIndustry", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyAddress", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyPhone", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyLegal", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyLegalNo", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyIsStop", SqlDbType.Bit, 1),
new SqlParameter("@是否运维", SqlDbType.VarChar, 2),
new SqlParameter("@town", SqlDbType.NVarChar, 255),
new SqlParameter("@Street", SqlDbType.NVarChar, 255),
new SqlParameter("@remark", SqlDbType.NVarChar, 255),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", SqlDbType.NVarChar, 255),
new SqlParameter("@AreaID", SqlDbType.Int, 4)
};
parameters[0].Value = model.AreaCode;
parameters[1].Value = model.areaname;
parameters[2].Value = model.companycode;
parameters[3].Value = model.companyname;
parameters[4].Value = model.CompanyType;
parameters[5].Value = model.CompanyIndustry;
parameters[6].Value = model.CompanyAddress;
parameters[7].Value = model.CompanyPhone;
parameters[8].Value = model.CompanyLegal;
parameters[9].Value = model.CompanyLegalNo;
parameters[10].Value = model.CompanyIsStop;
parameters[11].Value = model.是否运维;
parameters[12].Value = model.town;
parameters[13].Value = model.Street;
parameters[14].Value = model.remark;
parameters[15].Value = model.UpdateTime;
parameters[16].Value = model.UpdatePerson;
parameters[17].Value = model.AreaID;
object obj = DbBaseHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.T_OperatedLevel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_OperatedLevel(");
strSql.Append("ID,Name)");
strSql.Append(" values (");
strSql.Append("@ID,@Name)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Name;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_OperatedLevel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_OperatedLevel set ");
strSql.Append("ID=@ID,");
strSql.Append("Name=@Name");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Name;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.T_StationGeneSet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_StationGeneSet(");
strSql.Append("PointCode,GeneCode,DevCode,isStop,DayNum,StandardValue,DayMaxValue,DayMinValue,ChangeType,ChangeRate,Multiple,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG)");
strSql.Append(" values (");
strSql.Append("@PointCode,@GeneCode,@DevCode,@isStop,@DayNum,@StandardValue,@DayMaxValue,@DayMinValue,@ChangeType,@ChangeRate,@Multiple,@ExcelServerRCID,@ExcelServerRN,@ExcelServerCN,@ExcelServerRC1,@ExcelServerWIID,@ExcelServerRTID,@ExcelServerCHG)");
SqlParameter[] parameters =
{
new SqlParameter("@PointCode", SqlDbType.NVarChar, 50),
new SqlParameter("@GeneCode", SqlDbType.NVarChar, 50),
new SqlParameter("@DevCode", SqlDbType.NVarChar, 50),
new SqlParameter("@isStop", SqlDbType.Bit, 1),
new SqlParameter("@DayNum", SqlDbType.Int, 4),
new SqlParameter("@StandardValue", SqlDbType.Float, 8),
new SqlParameter("@DayMaxValue", SqlDbType.Float, 8),
new SqlParameter("@DayMinValue", SqlDbType.Float, 8),
new SqlParameter("@ChangeType", SqlDbType.NVarChar, 50),
new SqlParameter("@ChangeRate", SqlDbType.Float, 8),
new SqlParameter("@Multiple", SqlDbType.Decimal, 9),
new SqlParameter("@ExcelServerRCID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerCN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerRC1", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerWIID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRTID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerCHG", SqlDbType.Int, 4)
};
parameters[0].Value = model.PointCode;
parameters[1].Value = model.GeneCode;
parameters[2].Value = model.DevCode;
parameters[3].Value = model.isStop;
parameters[4].Value = model.DayNum;
parameters[5].Value = model.StandardValue;
parameters[6].Value = model.DayMaxValue;
parameters[7].Value = model.DayMinValue;
parameters[8].Value = model.ChangeType;
parameters[9].Value = model.ChangeRate;
parameters[10].Value = model.Multiple;
parameters[11].Value = model.ExcelServerRCID;
parameters[12].Value = model.ExcelServerRN;
parameters[13].Value = model.ExcelServerCN;
parameters[14].Value = model.ExcelServerRC1;
parameters[15].Value = model.ExcelServerWIID;
parameters[16].Value = model.ExcelServerRTID;
parameters[17].Value = model.ExcelServerCHG;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.T_Contractor model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Contractor(");
strSql.Append("ContractorID,CompanyCode,Name,cellphone,telephone,remark,qq,email,fax,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,RecordFlag)");
strSql.Append(" values (");
strSql.Append("@ContractorID,@CompanyCode,@Name,@cellphone,@telephone,@remark,@qq,@email,@fax,@ExcelServerRCID,@ExcelServerRN,@ExcelServerCN,@ExcelServerRC1,@ExcelServerWIID,@ExcelServerRTID,@ExcelServerCHG,@RecordFlag)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ContractorID", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255),
new SqlParameter("@Name", SqlDbType.NVarChar, 255),
new SqlParameter("@cellphone", SqlDbType.NVarChar, 255),
new SqlParameter("@telephone", SqlDbType.NVarChar, 255),
new SqlParameter("@remark", SqlDbType.NVarChar, 255),
new SqlParameter("@qq", SqlDbType.NVarChar, 255),
new SqlParameter("@email", SqlDbType.NVarChar, 255),
new SqlParameter("@fax", SqlDbType.NVarChar, 255),
new SqlParameter("@ExcelServerRCID", SqlDbType.NVarChar, 255),
new SqlParameter("@ExcelServerRN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerCN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerRC1", SqlDbType.NVarChar, 255),
new SqlParameter("@ExcelServerWIID", SqlDbType.NVarChar, 255),
new SqlParameter("@ExcelServerRTID", SqlDbType.NVarChar, 255),
new SqlParameter("@ExcelServerCHG", SqlDbType.Int, 4),
new SqlParameter("@RecordFlag", SqlDbType.NVarChar, 25)
};
parameters[0].Value = model.ContractorID;
parameters[1].Value = model.CompanyCode;
parameters[2].Value = model.Name;
parameters[3].Value = model.cellphone;
parameters[4].Value = model.telephone;
parameters[5].Value = model.remark;
parameters[6].Value = model.qq;
parameters[7].Value = model.email;
parameters[8].Value = model.fax;
parameters[9].Value = model.ExcelServerRCID;
parameters[10].Value = model.ExcelServerRN;
parameters[11].Value = model.ExcelServerCN;
parameters[12].Value = model.ExcelServerRC1;
parameters[13].Value = model.ExcelServerWIID;
parameters[14].Value = model.ExcelServerRTID;
parameters[15].Value = model.ExcelServerCHG;
parameters[16].Value = model.RecordFlag;
object obj = DbBaseHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.T_Geneset model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Geneset(");
strSql.Append("genename,genecode,genecodeExpand,geneT212,unit,m_decimal,DataType,ZS,remark,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,GeneType)");
strSql.Append(" values (");
strSql.Append("@genename,@genecode,@genecodeExpand,@geneT212,@unit,@m_decimal,@DataType,@ZS,@remark,@ExcelServerRCID,@ExcelServerRN,@ExcelServerCN,@ExcelServerRC1,@ExcelServerWIID,@ExcelServerRTID,@ExcelServerCHG,@GeneType)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@genename", SqlDbType.NVarChar, 255),
new SqlParameter("@genecode", SqlDbType.NVarChar, 50),
new SqlParameter("@genecodeExpand", SqlDbType.NVarChar, 50),
new SqlParameter("@geneT212", SqlDbType.NVarChar, 50),
new SqlParameter("@unit", SqlDbType.VarChar, 50),
new SqlParameter("@m_decimal", SqlDbType.Int, 4),
new SqlParameter("@DataType", SqlDbType.Int, 4),
new SqlParameter("@ZS", SqlDbType.Bit, 1),
new SqlParameter("@remark", SqlDbType.NVarChar, 500),
new SqlParameter("@ExcelServerRCID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerCN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerRC1", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerWIID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRTID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerCHG", SqlDbType.Int, 4),
new SqlParameter("@GeneType", SqlDbType.Int, 4)
};
parameters[0].Value = model.genename;
parameters[1].Value = model.genecode;
parameters[2].Value = model.genecodeExpand;
parameters[3].Value = model.geneT212;
parameters[4].Value = model.unit;
parameters[5].Value = model.m_decimal;
parameters[6].Value = model.DataType;
parameters[7].Value = model.ZS;
parameters[8].Value = model.remark;
parameters[9].Value = model.ExcelServerRCID;
parameters[10].Value = model.ExcelServerRN;
parameters[11].Value = model.ExcelServerCN;
parameters[12].Value = model.ExcelServerRC1;
parameters[13].Value = model.ExcelServerWIID;
parameters[14].Value = model.ExcelServerRTID;
parameters[15].Value = model.ExcelServerCHG;
parameters[16].Value = model.GeneType;
object obj = DbBaseHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.T_Area model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Area(");
strSql.Append("AreaCode,AreaName,province,city,distinguish,town,remark,reportno,realtimeaddress,historyaddress,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG)");
strSql.Append(" values (");
strSql.Append("@AreaCode,@AreaName,@province,@city,@distinguish,@town,@remark,@reportno,@realtimeaddress,@historyaddress,@ExcelServerRCID,@ExcelServerRN,@ExcelServerCN,@ExcelServerRC1,@ExcelServerWIID,@ExcelServerRTID,@ExcelServerCHG)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AreaCode", SqlDbType.NVarChar, 15),
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@province", SqlDbType.NVarChar, 50),
new SqlParameter("@city", SqlDbType.NVarChar, 50),
new SqlParameter("@distinguish", SqlDbType.NVarChar, 50),
new SqlParameter("@town", SqlDbType.NVarChar, 50),
new SqlParameter("@remark", SqlDbType.NVarChar, 255),
new SqlParameter("@reportno", SqlDbType.NVarChar, 50),
new SqlParameter("@realtimeaddress", SqlDbType.NVarChar, 100),
new SqlParameter("@historyaddress", SqlDbType.NVarChar, 100),
new SqlParameter("@ExcelServerRCID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerCN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerRC1", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerWIID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRTID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerCHG", SqlDbType.Int, 4)
};
parameters[0].Value = model.AreaCode;
parameters[1].Value = model.AreaName;
parameters[2].Value = model.province;
parameters[3].Value = model.city;
parameters[4].Value = model.distinguish;
parameters[5].Value = model.town;
parameters[6].Value = model.remark;
parameters[7].Value = model.reportno;
parameters[8].Value = model.realtimeaddress;
parameters[9].Value = model.historyaddress;
parameters[10].Value = model.ExcelServerRCID;
parameters[11].Value = model.ExcelServerRN;
parameters[12].Value = model.ExcelServerCN;
parameters[13].Value = model.ExcelServerRC1;
parameters[14].Value = model.ExcelServerWIID;
parameters[15].Value = model.ExcelServerRTID;
parameters[16].Value = model.ExcelServerCHG;
object obj = DbBaseHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.T_EquipmentParts model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_EquipmentParts(");
strSql.Append("Partsid,PartsName,PartsModel,PartsType,PartsUnit,PartStockData,PartsSurplusData,PartsCode,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,Price,Remark)");
strSql.Append(" values (");
strSql.Append("@Partsid,@PartsName,@PartsModel,@PartsType,@PartsUnit,@PartStockData,@PartsSurplusData,@PartsCode,@ExcelServerRCID,@ExcelServerRN,@ExcelServerCN,@ExcelServerRC1,@ExcelServerWIID,@ExcelServerRTID,@ExcelServerCHG,@Price,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@Partsid", SqlDbType.Int, 4),
new SqlParameter("@PartsName", SqlDbType.NVarChar, 50),
new SqlParameter("@PartsModel", SqlDbType.NVarChar, 50),
new SqlParameter("@PartsType", SqlDbType.NVarChar, 50),
new SqlParameter("@PartsUnit", SqlDbType.NVarChar, 50),
new SqlParameter("@PartStockData", SqlDbType.Int, 4),
new SqlParameter("@PartsSurplusData", SqlDbType.Int, 4),
new SqlParameter("@PartsCode", SqlDbType.NVarChar, 50),
new SqlParameter("@ExcelServerRCID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerCN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerRC1", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerWIID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRTID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerCHG", SqlDbType.Int, 4),
new SqlParameter("@Price", SqlDbType.Float, 8),
new SqlParameter("@Remark", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.Partsid;
parameters[1].Value = model.PartsName;
parameters[2].Value = model.PartsModel;
parameters[3].Value = model.PartsType;
parameters[4].Value = model.PartsUnit;
parameters[5].Value = model.PartStockData;
parameters[6].Value = model.PartsSurplusData;
parameters[7].Value = model.PartsCode;
parameters[8].Value = model.ExcelServerRCID;
parameters[9].Value = model.ExcelServerRN;
parameters[10].Value = model.ExcelServerCN;
parameters[11].Value = model.ExcelServerRC1;
parameters[12].Value = model.ExcelServerWIID;
parameters[13].Value = model.ExcelServerRTID;
parameters[14].Value = model.ExcelServerCHG;
parameters[15].Value = model.Price;
parameters[16].Value = model.Remark;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_Supplier model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Supplier set ");
strSql.Append("SupplierName=@SupplierName,");
strSql.Append("Address=@Address,");
strSql.Append("Phone=@Phone,");
strSql.Append("Remark=@Remark,");
strSql.Append("ExcelServerRCID=@ExcelServerRCID,");
strSql.Append("ExcelServerRN=@ExcelServerRN,");
strSql.Append("ExcelServerCN=@ExcelServerCN,");
strSql.Append("ExcelServerRC1=@ExcelServerRC1,");
strSql.Append("ExcelServerWIID=@ExcelServerWIID,");
strSql.Append("ExcelServerRTID=@ExcelServerRTID,");
strSql.Append("ExcelServerCHG=@ExcelServerCHG");
strSql.Append(" where SupplierId=@SupplierId ");
SqlParameter[] parameters =
{
new SqlParameter("@SupplierName", SqlDbType.NVarChar, 255),
new SqlParameter("@Address", SqlDbType.NVarChar, 255),
new SqlParameter("@Phone", SqlDbType.NVarChar, 20),
new SqlParameter("@Remark", SqlDbType.NVarChar, 255),
new SqlParameter("@ExcelServerRCID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerCN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerRC1", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerWIID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRTID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerCHG", SqlDbType.Int, 4),
new SqlParameter("@SupplierId", SqlDbType.Int, 4)
};
parameters[0].Value = model.SupplierName;
parameters[1].Value = model.Address;
parameters[2].Value = model.Phone;
parameters[3].Value = model.Remark;
parameters[4].Value = model.ExcelServerRCID;
parameters[5].Value = model.ExcelServerRN;
parameters[6].Value = model.ExcelServerCN;
parameters[7].Value = model.ExcelServerRC1;
parameters[8].Value = model.ExcelServerWIID;
parameters[9].Value = model.ExcelServerRTID;
parameters[10].Value = model.ExcelServerCHG;
parameters[11].Value = model.SupplierId;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <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 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 bool Add(Maticsoft.Model.T_Instrument model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Instrument(");
strSql.Append("InstrumentID,InstrumentName,InstrumentModel,InstrumentType,SupplierId,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG,KingdeeId,InnerId,Remark)");
strSql.Append(" values (");
strSql.Append("@InstrumentID,@InstrumentName,@InstrumentModel,@InstrumentType,@SupplierId,@ExcelServerRCID,@ExcelServerRN,@ExcelServerCN,@ExcelServerRC1,@ExcelServerWIID,@ExcelServerRTID,@ExcelServerCHG,@KingdeeId,@InnerId,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@InstrumentID", SqlDbType.Int, 4),
new SqlParameter("@InstrumentName", SqlDbType.NVarChar, 255),
new SqlParameter("@InstrumentModel", SqlDbType.NVarChar, 100),
new SqlParameter("@InstrumentType", SqlDbType.NVarChar, 50),
new SqlParameter("@SupplierId", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerRCID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerCN", SqlDbType.Int, 4),
new SqlParameter("@ExcelServerRC1", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerWIID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerRTID", SqlDbType.NVarChar, 20),
new SqlParameter("@ExcelServerCHG", SqlDbType.Int, 4),
new SqlParameter("@KingdeeId", SqlDbType.NVarChar, 20),
new SqlParameter("@InnerId", SqlDbType.NVarChar, 20),
new SqlParameter("@Remark", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.InstrumentID;
parameters[1].Value = model.InstrumentName;
parameters[2].Value = model.InstrumentModel;
parameters[3].Value = model.InstrumentType;
parameters[4].Value = model.SupplierId;
parameters[5].Value = model.ExcelServerRCID;
parameters[6].Value = model.ExcelServerRN;
parameters[7].Value = model.ExcelServerCN;
parameters[8].Value = model.ExcelServerRC1;
parameters[9].Value = model.ExcelServerWIID;
parameters[10].Value = model.ExcelServerRTID;
parameters[11].Value = model.ExcelServerCHG;
parameters[12].Value = model.KingdeeId;
parameters[13].Value = model.InnerId;
parameters[14].Value = model.Remark;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <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 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 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 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(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 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 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 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 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 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 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 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 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 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 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 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 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 bool Exists(int SupplierId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from T_Supplier");
strSql.Append(" where SupplierId=@SupplierId ");
SqlParameter[] parameters =
{
new SqlParameter("@SupplierId", SqlDbType.Int, 4)
};
parameters[0].Value = SupplierId;
return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
}
