/// <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_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 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 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 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 bool Update(Maticsoft.Model.T_GeneType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_GeneType set ");
strSql.Append("ID=@ID,");
strSql.Append("TypeName=@TypeName,");
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 ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@TypeName", 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)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.TypeName;
parameters[2].Value = model.ExcelServerRCID;
parameters[3].Value = model.ExcelServerRN;
parameters[4].Value = model.ExcelServerCN;
parameters[5].Value = model.ExcelServerRC1;
parameters[6].Value = model.ExcelServerWIID;
parameters[7].Value = model.ExcelServerRTID;
parameters[8].Value = model.ExcelServerCHG;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.T_Supplier model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Supplier(");
strSql.Append("SupplierId,SupplierName,Address,Phone,Remark,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG)");
strSql.Append(" values (");
strSql.Append("@SupplierId,@SupplierName,@Address,@Phone,@Remark,@ExcelServerRCID,@ExcelServerRN,@ExcelServerCN,@ExcelServerRC1,@ExcelServerWIID,@ExcelServerRTID,@ExcelServerCHG)");
SqlParameter[] parameters =
{
new SqlParameter("@SupplierId", SqlDbType.Int, 4),
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)
};
parameters[0].Value = model.SupplierId;
parameters[1].Value = model.SupplierName;
parameters[2].Value = model.Address;
parameters[3].Value = model.Phone;
parameters[4].Value = model.Remark;
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;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string PointIDlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_StationInformation ");
strSql.Append(" where PointID in (" + PointIDlist + ") ");
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string Partsidlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_EquipmentParts ");
strSql.Append(" where Partsid in (" + Partsidlist + ") ");
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string IDlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_Contractor ");
strSql.Append(" where ID in (" + IDlist + ") ");
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.T_GeneType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_GeneType(");
strSql.Append("ID,TypeName,ExcelServerRCID,ExcelServerRN,ExcelServerCN,ExcelServerRC1,ExcelServerWIID,ExcelServerRTID,ExcelServerCHG)");
strSql.Append(" values (");
strSql.Append("@ID,@TypeName,@ExcelServerRCID,@ExcelServerRN,@ExcelServerCN,@ExcelServerRC1,@ExcelServerWIID,@ExcelServerRTID,@ExcelServerCHG)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@TypeName", 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)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.TypeName;
parameters[2].Value = model.ExcelServerRCID;
parameters[3].Value = model.ExcelServerRN;
parameters[4].Value = model.ExcelServerCN;
parameters[5].Value = model.ExcelServerRC1;
parameters[6].Value = model.ExcelServerWIID;
parameters[7].Value = model.ExcelServerRTID;
parameters[8].Value = model.ExcelServerCHG;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from V_Station2 ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int Partsid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_EquipmentParts ");
strSql.Append(" where Partsid=@Partsid ");
SqlParameter[] parameters =
{
new SqlParameter("@Partsid", SqlDbType.Int, 4)
};
parameters[0].Value = Partsid;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_Contractor ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string PointCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_StationInformation ");
strSql.Append(" where PointCode=@PointCode ");
SqlParameter[] parameters =
{
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20)
};
parameters[0].Value = PointCode;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int SupplierId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_Supplier ");
strSql.Append(" where SupplierId=@SupplierId ");
SqlParameter[] parameters =
{
new SqlParameter("@SupplierId", SqlDbType.Int, 4)
};
parameters[0].Value = SupplierId;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string CompanyCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_Company ");
strSql.Append(" where CompanyCode=@CompanyCode ");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255)
};
parameters[0].Value = CompanyCode;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.V_StationDevGene model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update V_StationDevGene set ");
strSql.Append("AreaName=@AreaName,");
strSql.Append("PointID=@PointID,");
strSql.Append("PointName=@PointName,");
strSql.Append("MnCode=@MnCode,");
strSql.Append("geneID=@geneID,");
strSql.Append("genename=@genename,");
strSql.Append("unit=@unit,");
strSql.Append("geneT212=@geneT212,");
strSql.Append("InstrumentID=@InstrumentID,");
strSql.Append("InstrumentName=@InstrumentName,");
strSql.Append("InstrumentModel=@InstrumentModel,");
strSql.Append("InstallDate=@InstallDate,");
strSql.Append("DevCode=@DevCode,");
strSql.Append("isStop=@isStop,");
strSql.Append("DayNum=@DayNum,");
strSql.Append("RangeDown=@RangeDown,");
strSql.Append("RangeUp=@RangeUp,");
strSql.Append("StandardMinValue=@StandardMinValue,");
strSql.Append("StandardMaxValue=@StandardMaxValue,");
strSql.Append("DayMinValue=@DayMinValue,");
strSql.Append("DayMaxValue=@DayMaxValue,");
strSql.Append("ChangeType=@ChangeType,");
strSql.Append("ChangeRate=@ChangeRate,");
strSql.Append("DetectionPrinciple=@DetectionPrinciple,");
strSql.Append("HasZs=@HasZs,");
strSql.Append("HasPf=@HasPf,");
strSql.Append("IsJudgeStandard=@IsJudgeStandard,");
strSql.Append("DecimalPlaces=@DecimalPlaces,");
strSql.Append("Sort=@Sort,");
strSql.Append("PointUses=@PointUses,");
strSql.Append("PointCode=@PointCode");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@MnCode", SqlDbType.NVarChar, 20),
new SqlParameter("@geneID", SqlDbType.Int, 4),
new SqlParameter("@genename", SqlDbType.NVarChar, 255),
new SqlParameter("@unit", SqlDbType.VarChar, 50),
new SqlParameter("@geneT212", SqlDbType.NVarChar, 50),
new SqlParameter("@InstrumentID", SqlDbType.NVarChar, 50),
new SqlParameter("@InstrumentName", SqlDbType.NVarChar, 255),
new SqlParameter("@InstrumentModel", SqlDbType.NVarChar, 50),
new SqlParameter("@InstallDate", SqlDbType.DateTime),
new SqlParameter("@DevCode", SqlDbType.NVarChar, 50),
new SqlParameter("@isStop", SqlDbType.Bit, 1),
new SqlParameter("@DayNum", SqlDbType.Int, 4),
new SqlParameter("@RangeDown", SqlDbType.Decimal, 9),
new SqlParameter("@RangeUp", SqlDbType.Decimal, 9),
new SqlParameter("@StandardMinValue", SqlDbType.Decimal, 9),
new SqlParameter("@StandardMaxValue", SqlDbType.Decimal, 9),
new SqlParameter("@DayMinValue", SqlDbType.Decimal, 9),
new SqlParameter("@DayMaxValue", SqlDbType.Decimal, 9),
new SqlParameter("@ChangeType", SqlDbType.NVarChar, 50),
new SqlParameter("@ChangeRate", SqlDbType.Float, 8),
new SqlParameter("@DetectionPrinciple", SqlDbType.NVarChar, 255),
new SqlParameter("@HasZs", SqlDbType.Bit, 1),
new SqlParameter("@HasPf", SqlDbType.Bit, 1),
new SqlParameter("@IsJudgeStandard", SqlDbType.Bit, 1),
new SqlParameter("@DecimalPlaces", SqlDbType.Int, 4),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@PointUses", SqlDbType.Bit, 1),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20)
};
parameters[0].Value = model.AreaName;
parameters[1].Value = model.PointID;
parameters[2].Value = model.PointName;
parameters[3].Value = model.MnCode;
parameters[4].Value = model.geneID;
parameters[5].Value = model.genename;
parameters[6].Value = model.unit;
parameters[7].Value = model.geneT212;
parameters[8].Value = model.InstrumentID;
parameters[9].Value = model.InstrumentName;
parameters[10].Value = model.InstrumentModel;
parameters[11].Value = model.InstallDate;
parameters[12].Value = model.DevCode;
parameters[13].Value = model.isStop;
parameters[14].Value = model.DayNum;
parameters[15].Value = model.RangeDown;
parameters[16].Value = model.RangeUp;
parameters[17].Value = model.StandardMinValue;
parameters[18].Value = model.StandardMaxValue;
parameters[19].Value = model.DayMinValue;
parameters[20].Value = model.DayMaxValue;
parameters[21].Value = model.ChangeType;
parameters[22].Value = model.ChangeRate;
parameters[23].Value = model.DetectionPrinciple;
parameters[24].Value = model.HasZs;
parameters[25].Value = model.HasPf;
parameters[26].Value = model.IsJudgeStandard;
parameters[27].Value = model.DecimalPlaces;
parameters[28].Value = model.Sort;
parameters[29].Value = model.PointUses;
parameters[30].Value = model.PointCode;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.V_StationDevGene model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into V_StationDevGene(");
strSql.Append("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(" values (");
strSql.Append("@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)");
SqlParameter[] parameters =
{
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@MnCode", SqlDbType.NVarChar, 20),
new SqlParameter("@geneID", SqlDbType.Int, 4),
new SqlParameter("@genename", SqlDbType.NVarChar, 255),
new SqlParameter("@unit", SqlDbType.VarChar, 50),
new SqlParameter("@geneT212", SqlDbType.NVarChar, 50),
new SqlParameter("@InstrumentID", SqlDbType.NVarChar, 50),
new SqlParameter("@InstrumentName", SqlDbType.NVarChar, 255),
new SqlParameter("@InstrumentModel", SqlDbType.NVarChar, 50),
new SqlParameter("@InstallDate", SqlDbType.DateTime),
new SqlParameter("@DevCode", SqlDbType.NVarChar, 50),
new SqlParameter("@isStop", SqlDbType.Bit, 1),
new SqlParameter("@DayNum", SqlDbType.Int, 4),
new SqlParameter("@RangeDown", SqlDbType.Decimal, 9),
new SqlParameter("@RangeUp", SqlDbType.Decimal, 9),
new SqlParameter("@StandardMinValue", SqlDbType.Decimal, 9),
new SqlParameter("@StandardMaxValue", SqlDbType.Decimal, 9),
new SqlParameter("@DayMinValue", SqlDbType.Decimal, 9),
new SqlParameter("@DayMaxValue", SqlDbType.Decimal, 9),
new SqlParameter("@ChangeType", SqlDbType.NVarChar, 50),
new SqlParameter("@ChangeRate", SqlDbType.Float, 8),
new SqlParameter("@DetectionPrinciple", SqlDbType.NVarChar, 255),
new SqlParameter("@HasZs", SqlDbType.Bit, 1),
new SqlParameter("@HasPf", SqlDbType.Bit, 1),
new SqlParameter("@IsJudgeStandard", SqlDbType.Bit, 1),
new SqlParameter("@DecimalPlaces", SqlDbType.Int, 4),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@PointUses", SqlDbType.Bit, 1),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20)
};
parameters[0].Value = model.AreaName;
parameters[1].Value = model.PointID;
parameters[2].Value = model.PointName;
parameters[3].Value = model.MnCode;
parameters[4].Value = model.geneID;
parameters[5].Value = model.genename;
parameters[6].Value = model.unit;
parameters[7].Value = model.geneT212;
parameters[8].Value = model.InstrumentID;
parameters[9].Value = model.InstrumentName;
parameters[10].Value = model.InstrumentModel;
parameters[11].Value = model.InstallDate;
parameters[12].Value = model.DevCode;
parameters[13].Value = model.isStop;
parameters[14].Value = model.DayNum;
parameters[15].Value = model.RangeDown;
parameters[16].Value = model.RangeUp;
parameters[17].Value = model.StandardMinValue;
parameters[18].Value = model.StandardMaxValue;
parameters[19].Value = model.DayMinValue;
parameters[20].Value = model.DayMaxValue;
parameters[21].Value = model.ChangeType;
parameters[22].Value = model.ChangeRate;
parameters[23].Value = model.DetectionPrinciple;
parameters[24].Value = model.HasZs;
parameters[25].Value = model.HasPf;
parameters[26].Value = model.IsJudgeStandard;
parameters[27].Value = model.DecimalPlaces;
parameters[28].Value = model.Sort;
parameters[29].Value = model.PointUses;
parameters[30].Value = model.PointCode;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_StationInformation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_StationInformation set ");
strSql.Append("CompanyCode=@CompanyCode,");
strSql.Append("PointName=@PointName,");
strSql.Append("PointUses=@PointUses,");
strSql.Append("PointType=@PointType,");
strSql.Append("OperatedLevel=@OperatedLevel,");
strSql.Append("OperatedCenter=@OperatedCenter,");
strSql.Append("OperatedGroup=@OperatedGroup,");
strSql.Append("Director=@Director,");
strSql.Append("RouterIP=@RouterIP,");
strSql.Append("DataIP=@DataIP,");
strSql.Append("VedioIP=@VedioIP,");
strSql.Append("LineNo=@LineNo,");
strSql.Append("Vlan=@Vlan,");
strSql.Append("NetOperator=@NetOperator,");
strSql.Append("NetType=@NetType,");
strSql.Append("remark=@remark,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("UpdatePerson=@UpdatePerson,");
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("MnCode=@MnCode,");
strSql.Append("OutletNo=@OutletNo,");
strSql.Append("PassTime=@PassTime,");
strSql.Append("PointCode1=@PointCode1,");
strSql.Append("EnvirLevel=@EnvirLevel,");
strSql.Append("IsPatrol=@IsPatrol,");
strSql.Append("IsContract=@IsContract,");
strSql.Append("CompanyID=@CompanyID,");
strSql.Append("Longitude=@Longitude,");
strSql.Append("latitude=@latitude,");
strSql.Append("frequency=@frequency,");
strSql.Append("Pointaddress=@Pointaddress,");
strSql.Append("PointCodeB=@PointCodeB,");
strSql.Append("Controlsystem=@Controlsystem,");
strSql.Append("Treatmentprocess=@Treatmentprocess");
strSql.Append(" where PointID=@PointID");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 20),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointUses", SqlDbType.Bit, 1),
new SqlParameter("@PointType", SqlDbType.Int, 4),
new SqlParameter("@OperatedLevel", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedCenter", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedGroup", SqlDbType.NVarChar, 20),
new SqlParameter("@Director", SqlDbType.NVarChar, 50),
new SqlParameter("@RouterIP", SqlDbType.NVarChar, 255),
new SqlParameter("@DataIP", SqlDbType.NVarChar, 255),
new SqlParameter("@VedioIP", SqlDbType.NVarChar, 255),
new SqlParameter("@LineNo", SqlDbType.NVarChar, 50),
new SqlParameter("@Vlan", SqlDbType.NVarChar, 20),
new SqlParameter("@NetOperator", SqlDbType.NVarChar, 20),
new SqlParameter("@NetType", SqlDbType.NVarChar, 20),
new SqlParameter("@remark", SqlDbType.NVarChar, 255),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", 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("@MnCode", SqlDbType.NVarChar, 20),
new SqlParameter("@OutletNo", SqlDbType.NVarChar, 20),
new SqlParameter("@PassTime", SqlDbType.DateTime),
new SqlParameter("@PointCode1", SqlDbType.NVarChar, 20),
new SqlParameter("@EnvirLevel", SqlDbType.NVarChar, 50),
new SqlParameter("@IsPatrol", SqlDbType.Bit, 1),
new SqlParameter("@IsContract", SqlDbType.Bit, 1),
new SqlParameter("@CompanyID", SqlDbType.Int, 4),
new SqlParameter("@Longitude", SqlDbType.NVarChar, 50),
new SqlParameter("@latitude", SqlDbType.NVarChar, 50),
new SqlParameter("@frequency", SqlDbType.Int, 4),
new SqlParameter("@Pointaddress", SqlDbType.NVarChar, 255),
new SqlParameter("@PointCodeB", SqlDbType.NVarChar, 50),
new SqlParameter("@Controlsystem", SqlDbType.NVarChar, 50),
new SqlParameter("@Treatmentprocess", SqlDbType.NVarChar, 50),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20),
new SqlParameter("@PointID", SqlDbType.Int, 4)
};
parameters[0].Value = model.CompanyCode;
parameters[1].Value = model.PointName;
parameters[2].Value = model.PointUses;
parameters[3].Value = model.PointType;
parameters[4].Value = model.OperatedLevel;
parameters[5].Value = model.OperatedCenter;
parameters[6].Value = model.OperatedGroup;
parameters[7].Value = model.Director;
parameters[8].Value = model.RouterIP;
parameters[9].Value = model.DataIP;
parameters[10].Value = model.VedioIP;
parameters[11].Value = model.LineNo;
parameters[12].Value = model.Vlan;
parameters[13].Value = model.NetOperator;
parameters[14].Value = model.NetType;
parameters[15].Value = model.remark;
parameters[16].Value = model.UpdateTime;
parameters[17].Value = model.UpdatePerson;
parameters[18].Value = model.ExcelServerRCID;
parameters[19].Value = model.ExcelServerRN;
parameters[20].Value = model.ExcelServerCN;
parameters[21].Value = model.ExcelServerRC1;
parameters[22].Value = model.ExcelServerWIID;
parameters[23].Value = model.ExcelServerRTID;
parameters[24].Value = model.ExcelServerCHG;
parameters[25].Value = model.MnCode;
parameters[26].Value = model.OutletNo;
parameters[27].Value = model.PassTime;
parameters[28].Value = model.PointCode1;
parameters[29].Value = model.EnvirLevel;
parameters[30].Value = model.IsPatrol;
parameters[31].Value = model.IsContract;
parameters[32].Value = model.CompanyID;
parameters[33].Value = model.Longitude;
parameters[34].Value = model.latitude;
parameters[35].Value = model.frequency;
parameters[36].Value = model.Pointaddress;
parameters[37].Value = model.PointCodeB;
parameters[38].Value = model.Controlsystem;
parameters[39].Value = model.Treatmentprocess;
parameters[40].Value = model.PointCode;
parameters[41].Value = model.PointID;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_StationNet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_StationNet set ");
strSql.Append("RouterIP=@RouterIP,");
strSql.Append("RouterPort=@RouterPort,");
strSql.Append("RounterUser=@RounterUser,");
strSql.Append("RounterPws=@RounterPws,");
strSql.Append("DataIP=@DataIP,");
strSql.Append("DataPort=@DataPort,");
strSql.Append("DataUser=@DataUser,");
strSql.Append("DataPws=@DataPws,");
strSql.Append("VedioIP=@VedioIP,");
strSql.Append("VideoPort=@VideoPort,");
strSql.Append("VidioID=@VidioID,");
strSql.Append("VideoUser=@VideoUser,");
strSql.Append("VideoPws=@VideoPws,");
strSql.Append("LineNo=@LineNo,");
strSql.Append("Vlan=@Vlan,");
strSql.Append("NetOperator=@NetOperator,");
strSql.Append("NetType=@NetType,");
strSql.Append("PW=@PW,");
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 PointID=@PointID ");
SqlParameter[] parameters =
{
new SqlParameter("@RouterIP", SqlDbType.NVarChar, 50),
new SqlParameter("@RouterPort", SqlDbType.NVarChar, 50),
new SqlParameter("@RounterUser", SqlDbType.NVarChar, 50),
new SqlParameter("@RounterPws", SqlDbType.NVarChar, 50),
new SqlParameter("@DataIP", SqlDbType.NVarChar, 50),
new SqlParameter("@DataPort", SqlDbType.NVarChar, 50),
new SqlParameter("@DataUser", SqlDbType.NVarChar, 50),
new SqlParameter("@DataPws", SqlDbType.NVarChar, 50),
new SqlParameter("@VedioIP", SqlDbType.NVarChar, 50),
new SqlParameter("@VideoPort", SqlDbType.NVarChar, 50),
new SqlParameter("@VidioID", SqlDbType.NVarChar, 50),
new SqlParameter("@VideoUser", SqlDbType.NVarChar, 50),
new SqlParameter("@VideoPws", SqlDbType.NVarChar, 50),
new SqlParameter("@LineNo", SqlDbType.NVarChar, 50),
new SqlParameter("@Vlan", SqlDbType.NVarChar, 50),
new SqlParameter("@NetOperator", SqlDbType.NVarChar, 50),
new SqlParameter("@NetType", SqlDbType.NVarChar, 50),
new SqlParameter("@PW", SqlDbType.NVarChar, 25),
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("@PointID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RouterIP;
parameters[1].Value = model.RouterPort;
parameters[2].Value = model.RounterUser;
parameters[3].Value = model.RounterPws;
parameters[4].Value = model.DataIP;
parameters[5].Value = model.DataPort;
parameters[6].Value = model.DataUser;
parameters[7].Value = model.DataPws;
parameters[8].Value = model.VedioIP;
parameters[9].Value = model.VideoPort;
parameters[10].Value = model.VidioID;
parameters[11].Value = model.VideoUser;
parameters[12].Value = model.VideoPws;
parameters[13].Value = model.LineNo;
parameters[14].Value = model.Vlan;
parameters[15].Value = model.NetOperator;
parameters[16].Value = model.NetType;
parameters[17].Value = model.PW;
parameters[18].Value = model.ExcelServerRCID;
parameters[19].Value = model.ExcelServerRN;
parameters[20].Value = model.ExcelServerCN;
parameters[21].Value = model.ExcelServerRC1;
parameters[22].Value = model.ExcelServerWIID;
parameters[23].Value = model.ExcelServerRTID;
parameters[24].Value = model.ExcelServerCHG;
parameters[25].Value = model.PointID;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_Contractor model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Contractor set ");
strSql.Append("ContractorID=@ContractorID,");
strSql.Append("CompanyCode=@CompanyCode,");
strSql.Append("Name=@Name,");
strSql.Append("cellphone=@cellphone,");
strSql.Append("telephone=@telephone,");
strSql.Append("remark=@remark,");
strSql.Append("qq=@qq,");
strSql.Append("email=@email,");
strSql.Append("fax=@fax,");
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("RecordFlag=@RecordFlag");
strSql.Append(" where ID=@ID");
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),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
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;
parameters[17].Value = model.ID;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_DevGeneSet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_DevGeneSet set ");
strSql.Append("PointID=@PointID,");
strSql.Append("DevCode=@DevCode,");
strSql.Append("GeneID=@GeneID,");
strSql.Append("isStop=@isStop,");
strSql.Append("DayNum=@DayNum,");
strSql.Append("RangeUp=@RangeUp,");
strSql.Append("RangeDown=@RangeDown,");
strSql.Append("StandardMaxValue=@StandardMaxValue,");
strSql.Append("StandardMinValue=@StandardMinValue,");
strSql.Append("IsJudgeStandard=@IsJudgeStandard,");
strSql.Append("DayMaxValue=@DayMaxValue,");
strSql.Append("DayMinValue=@DayMinValue,");
strSql.Append("ChangeType=@ChangeType,");
strSql.Append("ChangeRate=@ChangeRate,");
strSql.Append("DetectionPrinciple=@DetectionPrinciple,");
strSql.Append("HasZs=@HasZs,");
strSql.Append("HasPf=@HasPf,");
strSql.Append("DecimalPlaces=@DecimalPlaces,");
strSql.Append("Sort=@Sort,");
strSql.Append("RecordFlag=@RecordFlag,");
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 ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@DevCode", SqlDbType.NVarChar, 50),
new SqlParameter("@GeneID", SqlDbType.Int, 4),
new SqlParameter("@isStop", SqlDbType.Bit, 1),
new SqlParameter("@DayNum", SqlDbType.Int, 4),
new SqlParameter("@RangeUp", SqlDbType.Decimal, 9),
new SqlParameter("@RangeDown", SqlDbType.Decimal, 9),
new SqlParameter("@StandardMaxValue", SqlDbType.Decimal, 9),
new SqlParameter("@StandardMinValue", SqlDbType.Decimal, 9),
new SqlParameter("@IsJudgeStandard", SqlDbType.Bit, 1),
new SqlParameter("@DayMaxValue", SqlDbType.Decimal, 9),
new SqlParameter("@DayMinValue", SqlDbType.Decimal, 9),
new SqlParameter("@ChangeType", SqlDbType.NVarChar, 50),
new SqlParameter("@ChangeRate", SqlDbType.Float, 8),
new SqlParameter("@DetectionPrinciple", SqlDbType.NVarChar, 255),
new SqlParameter("@HasZs", SqlDbType.Bit, 1),
new SqlParameter("@HasPf", SqlDbType.Bit, 1),
new SqlParameter("@DecimalPlaces", SqlDbType.Int, 4),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@RecordFlag", SqlDbType.NVarChar, 25),
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("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.PointID;
parameters[1].Value = model.DevCode;
parameters[2].Value = model.GeneID;
parameters[3].Value = model.isStop;
parameters[4].Value = model.DayNum;
parameters[5].Value = model.RangeUp;
parameters[6].Value = model.RangeDown;
parameters[7].Value = model.StandardMaxValue;
parameters[8].Value = model.StandardMinValue;
parameters[9].Value = model.IsJudgeStandard;
parameters[10].Value = model.DayMaxValue;
parameters[11].Value = model.DayMinValue;
parameters[12].Value = model.ChangeType;
parameters[13].Value = model.ChangeRate;
parameters[14].Value = model.DetectionPrinciple;
parameters[15].Value = model.HasZs;
parameters[16].Value = model.HasPf;
parameters[17].Value = model.DecimalPlaces;
parameters[18].Value = model.Sort;
parameters[19].Value = model.RecordFlag;
parameters[20].Value = model.ExcelServerRCID;
parameters[21].Value = model.ExcelServerRN;
parameters[22].Value = model.ExcelServerCN;
parameters[23].Value = model.ExcelServerRC1;
parameters[24].Value = model.ExcelServerWIID;
parameters[25].Value = model.ExcelServerRTID;
parameters[26].Value = model.ExcelServerCHG;
parameters[27].Value = model.ID;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_Company model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Company set ");
strSql.Append("AreaCode=@AreaCode,");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("CompanyType=@CompanyType,");
strSql.Append("CompanyIndustry=@CompanyIndustry,");
strSql.Append("CompanyPhone=@CompanyPhone,");
strSql.Append("CompanyLegal=@CompanyLegal,");
strSql.Append("CompanyLegalNo=@CompanyLegalNo,");
strSql.Append("CompanyAddress=@CompanyAddress,");
strSql.Append("Town=@Town,");
strSql.Append("Street=@Street,");
strSql.Append("CompanyIsStop=@CompanyIsStop,");
strSql.Append("remark=@remark,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("UpdatePerson=@UpdatePerson,");
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("contrator=@contrator,");
strSql.Append("AreaID=@AreaID,");
strSql.Append("Longitude=@Longitude,");
strSql.Append("latitude=@latitude");
strSql.Append(" where CompanyID=@CompanyID");
SqlParameter[] parameters =
{
new SqlParameter("@AreaCode", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyType", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyIndustry", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyPhone", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyLegal", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyLegalNo", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyAddress", SqlDbType.NVarChar, 255),
new SqlParameter("@Town", SqlDbType.NVarChar, 255),
new SqlParameter("@Street", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyIsStop", SqlDbType.Bit, 1),
new SqlParameter("@remark", SqlDbType.NVarChar, 255),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", 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("@contrator", SqlDbType.NVarChar, 100),
new SqlParameter("@AreaID", SqlDbType.Int, 4),
new SqlParameter("@Longitude", SqlDbType.Decimal, 9),
new SqlParameter("@latitude", SqlDbType.Decimal, 9),
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyID", SqlDbType.Int, 4)
};
parameters[0].Value = model.AreaCode;
parameters[1].Value = model.CompanyName;
parameters[2].Value = model.CompanyType;
parameters[3].Value = model.CompanyIndustry;
parameters[4].Value = model.CompanyPhone;
parameters[5].Value = model.CompanyLegal;
parameters[6].Value = model.CompanyLegalNo;
parameters[7].Value = model.CompanyAddress;
parameters[8].Value = model.Town;
parameters[9].Value = model.Street;
parameters[10].Value = model.CompanyIsStop;
parameters[11].Value = model.remark;
parameters[12].Value = model.UpdateTime;
parameters[13].Value = model.UpdatePerson;
parameters[14].Value = model.ExcelServerRCID;
parameters[15].Value = model.ExcelServerRN;
parameters[16].Value = model.ExcelServerCN;
parameters[17].Value = model.ExcelServerRC1;
parameters[18].Value = model.ExcelServerWIID;
parameters[19].Value = model.ExcelServerRTID;
parameters[20].Value = model.ExcelServerCHG;
parameters[21].Value = model.contrator;
parameters[22].Value = model.AreaID;
parameters[23].Value = model.Longitude;
parameters[24].Value = model.latitude;
parameters[25].Value = model.CompanyCode;
parameters[26].Value = model.CompanyID;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.T_StationNet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_StationNet(");
strSql.Append("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(" values (");
strSql.Append("@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)");
SqlParameter[] parameters =
{
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@RouterIP", SqlDbType.NVarChar, 50),
new SqlParameter("@RouterPort", SqlDbType.NVarChar, 50),
new SqlParameter("@RounterUser", SqlDbType.NVarChar, 50),
new SqlParameter("@RounterPws", SqlDbType.NVarChar, 50),
new SqlParameter("@DataIP", SqlDbType.NVarChar, 50),
new SqlParameter("@DataPort", SqlDbType.NVarChar, 50),
new SqlParameter("@DataUser", SqlDbType.NVarChar, 50),
new SqlParameter("@DataPws", SqlDbType.NVarChar, 50),
new SqlParameter("@VedioIP", SqlDbType.NVarChar, 50),
new SqlParameter("@VideoPort", SqlDbType.NVarChar, 50),
new SqlParameter("@VidioID", SqlDbType.NVarChar, 50),
new SqlParameter("@VideoUser", SqlDbType.NVarChar, 50),
new SqlParameter("@VideoPws", SqlDbType.NVarChar, 50),
new SqlParameter("@LineNo", SqlDbType.NVarChar, 50),
new SqlParameter("@Vlan", SqlDbType.NVarChar, 50),
new SqlParameter("@NetOperator", SqlDbType.NVarChar, 50),
new SqlParameter("@NetType", SqlDbType.NVarChar, 50),
new SqlParameter("@PW", SqlDbType.NVarChar, 25),
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.PointID;
parameters[1].Value = model.RouterIP;
parameters[2].Value = model.RouterPort;
parameters[3].Value = model.RounterUser;
parameters[4].Value = model.RounterPws;
parameters[5].Value = model.DataIP;
parameters[6].Value = model.DataPort;
parameters[7].Value = model.DataUser;
parameters[8].Value = model.DataPws;
parameters[9].Value = model.VedioIP;
parameters[10].Value = model.VideoPort;
parameters[11].Value = model.VidioID;
parameters[12].Value = model.VideoUser;
parameters[13].Value = model.VideoPws;
parameters[14].Value = model.LineNo;
parameters[15].Value = model.Vlan;
parameters[16].Value = model.NetOperator;
parameters[17].Value = model.NetType;
parameters[18].Value = model.PW;
parameters[19].Value = model.ExcelServerRCID;
parameters[20].Value = model.ExcelServerRN;
parameters[21].Value = model.ExcelServerCN;
parameters[22].Value = model.ExcelServerRC1;
parameters[23].Value = model.ExcelServerWIID;
parameters[24].Value = model.ExcelServerRTID;
parameters[25].Value = model.ExcelServerCHG;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.V_Station2 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update V_Station2 set ");
strSql.Append("AreaName=@AreaName,");
strSql.Append("CompanyCode=@CompanyCode,");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("PointCode=@PointCode,");
strSql.Append("PointCode1=@PointCode1,");
strSql.Append("PointName=@PointName,");
strSql.Append("PointUses=@PointUses,");
strSql.Append("是否运维=@是否运维,");
strSql.Append("IsPatrol=@IsPatrol,");
strSql.Append("是否巡检=@是否巡检,");
strSql.Append("IsContract=@IsContract,");
strSql.Append("是否合同=@是否合同,");
strSql.Append("PointType=@PointType,");
strSql.Append("Name=@Name,");
strSql.Append("OutletNo=@OutletNo,");
strSql.Append("PassTime=@PassTime,");
strSql.Append("EnvirLevel=@EnvirLevel,");
strSql.Append("OperatedLevel=@OperatedLevel,");
strSql.Append("OperatedCenter=@OperatedCenter,");
strSql.Append("OperatedGroup=@OperatedGroup,");
strSql.Append("Director=@Director,");
strSql.Append("MnCode=@MnCode,");
strSql.Append("RouterIP=@RouterIP,");
strSql.Append("DataIP=@DataIP,");
strSql.Append("VedioIP=@VedioIP,");
strSql.Append("LineNo=@LineNo,");
strSql.Append("Vlan=@Vlan,");
strSql.Append("NetOperator=@NetOperator,");
strSql.Append("NetType=@NetType,");
strSql.Append("remark=@remark,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("UpdatePerson=@UpdatePerson,");
strSql.Append("CompanyID=@CompanyID,");
strSql.Append("PointID=@PointID,");
strSql.Append("AreaCode=@AreaCode,");
strSql.Append("PointCodeB=@PointCodeB,");
strSql.Append("frequency=@frequency,");
strSql.Append("latitude=@latitude,");
strSql.Append("Longitude=@Longitude,");
strSql.Append("Pointaddress=@Pointaddress");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20),
new SqlParameter("@PointCode1", SqlDbType.NVarChar, 20),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointUses", SqlDbType.Bit, 1),
new SqlParameter("@是否运维", SqlDbType.VarChar, 4),
new SqlParameter("@IsPatrol", SqlDbType.Bit, 1),
new SqlParameter("@是否巡检", SqlDbType.VarChar, 6),
new SqlParameter("@IsContract", SqlDbType.Bit, 1),
new SqlParameter("@是否合同", SqlDbType.VarChar, 2),
new SqlParameter("@PointType", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
new SqlParameter("@OutletNo", SqlDbType.NVarChar, 20),
new SqlParameter("@PassTime", SqlDbType.DateTime),
new SqlParameter("@EnvirLevel", SqlDbType.NVarChar, 50),
new SqlParameter("@OperatedLevel", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedCenter", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedGroup", SqlDbType.NVarChar, 20),
new SqlParameter("@Director", SqlDbType.NVarChar, 50),
new SqlParameter("@MnCode", SqlDbType.NVarChar, 20),
new SqlParameter("@RouterIP", SqlDbType.NVarChar, 255),
new SqlParameter("@DataIP", SqlDbType.NVarChar, 255),
new SqlParameter("@VedioIP", SqlDbType.NVarChar, 255),
new SqlParameter("@LineNo", SqlDbType.NVarChar, 50),
new SqlParameter("@Vlan", SqlDbType.NVarChar, 20),
new SqlParameter("@NetOperator", SqlDbType.NVarChar, 20),
new SqlParameter("@NetType", SqlDbType.NVarChar, 20),
new SqlParameter("@remark", SqlDbType.NVarChar, 255),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyID", SqlDbType.Int, 4),
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@AreaCode", SqlDbType.NVarChar, 15),
new SqlParameter("@PointCodeB", SqlDbType.NVarChar, 50),
new SqlParameter("@frequency", SqlDbType.Int, 4),
new SqlParameter("@latitude", SqlDbType.NVarChar, 50),
new SqlParameter("@Longitude", SqlDbType.NVarChar, 50),
new SqlParameter("@Pointaddress", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.AreaName;
parameters[1].Value = model.CompanyCode;
parameters[2].Value = model.CompanyName;
parameters[3].Value = model.PointCode;
parameters[4].Value = model.PointCode1;
parameters[5].Value = model.PointName;
parameters[6].Value = model.PointUses;
parameters[7].Value = model.是否运维;
parameters[8].Value = model.IsPatrol;
parameters[9].Value = model.是否巡检;
parameters[10].Value = model.IsContract;
parameters[11].Value = model.是否合同;
parameters[12].Value = model.PointType;
parameters[13].Value = model.Name;
parameters[14].Value = model.OutletNo;
parameters[15].Value = model.PassTime;
parameters[16].Value = model.EnvirLevel;
parameters[17].Value = model.OperatedLevel;
parameters[18].Value = model.OperatedCenter;
parameters[19].Value = model.OperatedGroup;
parameters[20].Value = model.Director;
parameters[21].Value = model.MnCode;
parameters[22].Value = model.RouterIP;
parameters[23].Value = model.DataIP;
parameters[24].Value = model.VedioIP;
parameters[25].Value = model.LineNo;
parameters[26].Value = model.Vlan;
parameters[27].Value = model.NetOperator;
parameters[28].Value = model.NetType;
parameters[29].Value = model.remark;
parameters[30].Value = model.UpdateTime;
parameters[31].Value = model.UpdatePerson;
parameters[32].Value = model.CompanyID;
parameters[33].Value = model.PointID;
parameters[34].Value = model.AreaCode;
parameters[35].Value = model.PointCodeB;
parameters[36].Value = model.frequency;
parameters[37].Value = model.latitude;
parameters[38].Value = model.Longitude;
parameters[39].Value = model.Pointaddress;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_Instrument model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Instrument set ");
strSql.Append("InstrumentID=@InstrumentID,");
strSql.Append("InstrumentName=@InstrumentName,");
strSql.Append("InstrumentModel=@InstrumentModel,");
strSql.Append("InstrumentType=@InstrumentType,");
strSql.Append("SupplierId=@SupplierId,");
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("KingdeeId=@KingdeeId,");
strSql.Append("InnerId=@InnerId,");
strSql.Append("Remark=@Remark");
strSql.Append(" where ");
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 bool Add(Maticsoft.Model.V_Station2 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into V_Station2(");
strSql.Append("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(" values (");
strSql.Append("@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)");
SqlParameter[] parameters =
{
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20),
new SqlParameter("@PointCode1", SqlDbType.NVarChar, 20),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointUses", SqlDbType.Bit, 1),
new SqlParameter("@是否运维", SqlDbType.VarChar, 4),
new SqlParameter("@IsPatrol", SqlDbType.Bit, 1),
new SqlParameter("@是否巡检", SqlDbType.VarChar, 6),
new SqlParameter("@IsContract", SqlDbType.Bit, 1),
new SqlParameter("@是否合同", SqlDbType.VarChar, 2),
new SqlParameter("@PointType", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
new SqlParameter("@OutletNo", SqlDbType.NVarChar, 20),
new SqlParameter("@PassTime", SqlDbType.DateTime),
new SqlParameter("@EnvirLevel", SqlDbType.NVarChar, 50),
new SqlParameter("@OperatedLevel", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedCenter", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedGroup", SqlDbType.NVarChar, 20),
new SqlParameter("@Director", SqlDbType.NVarChar, 50),
new SqlParameter("@MnCode", SqlDbType.NVarChar, 20),
new SqlParameter("@RouterIP", SqlDbType.NVarChar, 255),
new SqlParameter("@DataIP", SqlDbType.NVarChar, 255),
new SqlParameter("@VedioIP", SqlDbType.NVarChar, 255),
new SqlParameter("@LineNo", SqlDbType.NVarChar, 50),
new SqlParameter("@Vlan", SqlDbType.NVarChar, 20),
new SqlParameter("@NetOperator", SqlDbType.NVarChar, 20),
new SqlParameter("@NetType", SqlDbType.NVarChar, 20),
new SqlParameter("@remark", SqlDbType.NVarChar, 255),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyID", SqlDbType.Int, 4),
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@AreaCode", SqlDbType.NVarChar, 15),
new SqlParameter("@PointCodeB", SqlDbType.NVarChar, 50),
new SqlParameter("@frequency", SqlDbType.Int, 4),
new SqlParameter("@latitude", SqlDbType.NVarChar, 50),
new SqlParameter("@Longitude", SqlDbType.NVarChar, 50),
new SqlParameter("@Pointaddress", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.AreaName;
parameters[1].Value = model.CompanyCode;
parameters[2].Value = model.CompanyName;
parameters[3].Value = model.PointCode;
parameters[4].Value = model.PointCode1;
parameters[5].Value = model.PointName;
parameters[6].Value = model.PointUses;
parameters[7].Value = model.是否运维;
parameters[8].Value = model.IsPatrol;
parameters[9].Value = model.是否巡检;
parameters[10].Value = model.IsContract;
parameters[11].Value = model.是否合同;
parameters[12].Value = model.PointType;
parameters[13].Value = model.Name;
parameters[14].Value = model.OutletNo;
parameters[15].Value = model.PassTime;
parameters[16].Value = model.EnvirLevel;
parameters[17].Value = model.OperatedLevel;
parameters[18].Value = model.OperatedCenter;
parameters[19].Value = model.OperatedGroup;
parameters[20].Value = model.Director;
parameters[21].Value = model.MnCode;
parameters[22].Value = model.RouterIP;
parameters[23].Value = model.DataIP;
parameters[24].Value = model.VedioIP;
parameters[25].Value = model.LineNo;
parameters[26].Value = model.Vlan;
parameters[27].Value = model.NetOperator;
parameters[28].Value = model.NetType;
parameters[29].Value = model.remark;
parameters[30].Value = model.UpdateTime;
parameters[31].Value = model.UpdatePerson;
parameters[32].Value = model.CompanyID;
parameters[33].Value = model.PointID;
parameters[34].Value = model.AreaCode;
parameters[35].Value = model.PointCodeB;
parameters[36].Value = model.frequency;
parameters[37].Value = model.latitude;
parameters[38].Value = model.Longitude;
parameters[39].Value = model.Pointaddress;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.V_StationDev model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update V_StationDev set ");
strSql.Append("SortId=@SortId,");
strSql.Append("AreaName=@AreaName,");
strSql.Append("CompanyCode=@CompanyCode,");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("PointCode=@PointCode,");
strSql.Append("PointName=@PointName,");
strSql.Append("Name=@Name,");
strSql.Append("OperatedLevel=@OperatedLevel,");
strSql.Append("InstrumentID=@InstrumentID,");
strSql.Append("InstrumentName=@InstrumentName,");
strSql.Append("InstrumentModel=@InstrumentModel,");
strSql.Append("InstrumentType=@InstrumentType,");
strSql.Append("InstallDate=@InstallDate,");
strSql.Append("DevCode=@DevCode,");
strSql.Append("DetectionPrinciple=@DetectionPrinciple,");
strSql.Append("RangeLow=@RangeLow,");
strSql.Append("RangeUp=@RangeUp,");
strSql.Append("Protocol=@Protocol,");
strSql.Append("TransmissionType=@TransmissionType,");
strSql.Append("DevStatus=@DevStatus,");
strSql.Append("Remark=@Remark,");
strSql.Append("RecordFlag=@RecordFlag,");
strSql.Append("PointID=@PointID");
strSql.Append(" where StationDevID=@StationDevID");
SqlParameter[] parameters =
{
new SqlParameter("@SortId", SqlDbType.Int, 4),
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 50),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
new SqlParameter("@OperatedLevel", SqlDbType.NVarChar, 20),
new SqlParameter("@InstrumentID", SqlDbType.NVarChar, 50),
new SqlParameter("@InstrumentName", SqlDbType.NVarChar, 255),
new SqlParameter("@InstrumentModel", SqlDbType.NVarChar, 50),
new SqlParameter("@InstrumentType", SqlDbType.NVarChar, 50),
new SqlParameter("@InstallDate", SqlDbType.DateTime),
new SqlParameter("@DevCode", SqlDbType.NVarChar, 50),
new SqlParameter("@DetectionPrinciple", SqlDbType.NVarChar, 50),
new SqlParameter("@RangeLow", SqlDbType.Float, 8),
new SqlParameter("@RangeUp", SqlDbType.Float, 8),
new SqlParameter("@Protocol", SqlDbType.NVarChar, 50),
new SqlParameter("@TransmissionType", SqlDbType.NVarChar, 50),
new SqlParameter("@DevStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 255),
new SqlParameter("@RecordFlag", SqlDbType.NVarChar, 25),
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@StationDevID", SqlDbType.Int, 4)
};
parameters[0].Value = model.SortId;
parameters[1].Value = model.AreaName;
parameters[2].Value = model.CompanyCode;
parameters[3].Value = model.CompanyName;
parameters[4].Value = model.PointCode;
parameters[5].Value = model.PointName;
parameters[6].Value = model.Name;
parameters[7].Value = model.OperatedLevel;
parameters[8].Value = model.InstrumentID;
parameters[9].Value = model.InstrumentName;
parameters[10].Value = model.InstrumentModel;
parameters[11].Value = model.InstrumentType;
parameters[12].Value = model.InstallDate;
parameters[13].Value = model.DevCode;
parameters[14].Value = model.DetectionPrinciple;
parameters[15].Value = model.RangeLow;
parameters[16].Value = model.RangeUp;
parameters[17].Value = model.Protocol;
parameters[18].Value = model.TransmissionType;
parameters[19].Value = model.DevStatus;
parameters[20].Value = model.Remark;
parameters[21].Value = model.RecordFlag;
parameters[22].Value = model.PointID;
parameters[23].Value = model.StationDevID;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}