/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ClassLibrary1.Model.TcqType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TcqType(");
strSql.Append("Tcqguid,Tcqid,TcqName)");
strSql.Append(" values (");
strSql.Append("@Tcqguid,@Tcqid,@TcqName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Tcqguid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Tcqid", SqlDbType.Int, 4),
new SqlParameter("@TcqName", SqlDbType.VarChar, 255)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.Tcqid;
parameters[2].Value = model.TcqName;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
//string rows=DbHelperSql.GetSingleGUID(strSql.ToString(),parameters);
//if (rows == "")
//{
// return Guid.Empty;
//}
//else
//{
// return Guid.Parse(rows.ToString());
//}
}
public bool Exists(string partNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from ResponseInfo");
strSql.Append(" where ");
strSql.Append(" PartNo ='" + partNo + "' ");
return(DbHelperSql.Exists(strSql.ToString()));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(Guid TeacherUuid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Teacher");
strSql.Append(" where TeacherUuid=@TeacherUuid ");
SqlParameter[] parameters =
{
new SqlParameter("@TeacherUuid", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = TeacherUuid;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(Guid PublicityTypeUUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from PublicityType");
strSql.Append(" where PublicityTypeUUID=@PublicityTypeUUID ");
SqlParameter[] parameters =
{
new SqlParameter("@PublicityTypeUUID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = PublicityTypeUUID;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from HFile");
strSql.Append(" where FileID=@FileID");
SqlParameter[] parameters =
{
new SqlParameter("@FileID", SqlDbType.Int, 4)
};
parameters[0].Value = FileID;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from UnifiedAddressLibraryUserInfo");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from CreditCardBehavior");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Student");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(Guid SystemIconUUID, int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from SystemIcon");
strSql.Append(" where SystemIconUUID=@SystemIconUUID and ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@SystemIconUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = SystemIconUUID;
parameters[1].Value = ID;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(Guid HotelRoomUuid, int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from HotelRoom");
strSql.Append(" where HotelRoomUuid=@HotelRoomUuid and ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@HotelRoomUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = HotelRoomUuid;
parameters[1].Value = ID;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ClassLibrary1.Model.TcqInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TcqInfo(");
strSql.Append("Guid,detectorCode,detectorName,mainframeId,buildingId,detectorAddr,orgId,detectorType,ifcsSystemType,partunitloopCode,channelNo,hardwareVersion,softwareVersion,personId,minalarmValue,maxalarmValue,deviceRange,basalArea,maxHeight,registerTime,registerStatus,detectorRunBigStatus,detectorRunSmallStatus,producerId,produceDate,runDate,serviceLimit,mapType,gpsX3d,gpsY3d,gpsZ3d,planId,planX,planY,platformCode,recordCode,communicationId,hostSim,protocolType,firePartition,systemAddress,analogValueTypeId)");
strSql.Append(" values (");
strSql.Append("@Guid,@detectorCode,@detectorName,@mainframeId,@buildingId,@detectorAddr,@orgId,@detectorType,@ifcsSystemType,@partunitloopCode,@channelNo,@hardwareVersion,@softwareVersion,@personId,@minalarmValue,@maxalarmValue,@deviceRange,@basalArea,@maxHeight,@registerTime,@registerStatus,@detectorRunBigStatus,@detectorRunSmallStatus,@producerId,@produceDate,@runDate,@serviceLimit,@mapType,@gpsX3d,@gpsY3d,@gpsZ3d,@planId,@planX,@planY,@platformCode,@recordCode,@communicationId,@hostSim,@protocolType,@firePartition,@systemAddress,@analogValueTypeId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@detectorCode", SqlDbType.VarChar, 255),
new SqlParameter("@detectorName", SqlDbType.VarChar, 255),
new SqlParameter("@mainframeId", SqlDbType.VarChar, 255),
new SqlParameter("@buildingId", SqlDbType.VarChar, 255),
new SqlParameter("@detectorAddr", SqlDbType.VarChar, 255),
new SqlParameter("@orgId", SqlDbType.VarChar, 255),
new SqlParameter("@detectorType", SqlDbType.VarChar, 255),
new SqlParameter("@ifcsSystemType", SqlDbType.VarChar, 255),
new SqlParameter("@partunitloopCode", SqlDbType.VarChar, 255),
new SqlParameter("@channelNo", SqlDbType.VarChar, 255),
new SqlParameter("@hardwareVersion", SqlDbType.VarChar, 255),
new SqlParameter("@softwareVersion", SqlDbType.VarChar, 255),
new SqlParameter("@personId", SqlDbType.VarChar, 255),
new SqlParameter("@minalarmValue", SqlDbType.VarChar, 255),
new SqlParameter("@maxalarmValue", SqlDbType.VarChar, 255),
new SqlParameter("@deviceRange", SqlDbType.VarChar, 255),
new SqlParameter("@basalArea", SqlDbType.VarChar, 255),
new SqlParameter("@maxHeight", SqlDbType.VarChar, 255),
new SqlParameter("@registerTime", SqlDbType.VarChar, 255),
new SqlParameter("@registerStatus", SqlDbType.VarChar, 255),
new SqlParameter("@detectorRunBigStatus", SqlDbType.VarChar, 255),
new SqlParameter("@detectorRunSmallStatus", SqlDbType.VarChar, 255),
new SqlParameter("@producerId", SqlDbType.VarChar, 255),
new SqlParameter("@produceDate", SqlDbType.VarChar, 255),
new SqlParameter("@runDate", SqlDbType.VarChar, 255),
new SqlParameter("@serviceLimit", SqlDbType.VarChar, 255),
new SqlParameter("@mapType", SqlDbType.VarChar, 255),
new SqlParameter("@gpsX3d", SqlDbType.VarChar, 255),
new SqlParameter("@gpsY3d", SqlDbType.VarChar, 255),
new SqlParameter("@gpsZ3d", SqlDbType.VarChar, 255),
new SqlParameter("@planId", SqlDbType.VarChar, 255),
new SqlParameter("@planX", SqlDbType.VarChar, 255),
new SqlParameter("@planY", SqlDbType.VarChar, 255),
new SqlParameter("@platformCode", SqlDbType.VarChar, 255),
new SqlParameter("@recordCode", SqlDbType.VarChar, 255),
new SqlParameter("@communicationId", SqlDbType.VarChar, 255),
new SqlParameter("@hostSim", SqlDbType.VarChar, 255),
new SqlParameter("@protocolType", SqlDbType.VarChar, 255),
new SqlParameter("@firePartition", SqlDbType.VarChar, 255),
new SqlParameter("@systemAddress", SqlDbType.VarChar, 255),
new SqlParameter("@analogValueTypeId", SqlDbType.VarChar, 1)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.detectorCode;
parameters[2].Value = model.detectorName;
parameters[3].Value = model.mainframeId;
parameters[4].Value = model.buildingId;
parameters[5].Value = model.detectorAddr;
parameters[6].Value = model.orgId;
parameters[7].Value = model.detectorType;
parameters[8].Value = model.ifcsSystemType;
parameters[9].Value = model.partunitloopCode;
parameters[10].Value = model.channelNo;
parameters[11].Value = model.hardwareVersion;
parameters[12].Value = model.softwareVersion;
parameters[13].Value = model.personId;
parameters[14].Value = model.minalarmValue;
parameters[15].Value = model.maxalarmValue;
parameters[16].Value = model.deviceRange;
parameters[17].Value = model.basalArea;
parameters[18].Value = model.maxHeight;
parameters[19].Value = model.registerTime;
parameters[20].Value = model.registerStatus;
parameters[21].Value = model.detectorRunBigStatus;
parameters[22].Value = model.detectorRunSmallStatus;
parameters[23].Value = model.producerId;
parameters[24].Value = model.produceDate;
parameters[25].Value = model.runDate;
parameters[26].Value = model.serviceLimit;
parameters[27].Value = model.mapType;
parameters[28].Value = model.gpsX3d;
parameters[29].Value = model.gpsY3d;
parameters[30].Value = model.gpsZ3d;
parameters[31].Value = model.planId;
parameters[32].Value = model.planX;
parameters[33].Value = model.planY;
parameters[34].Value = model.platformCode;
parameters[35].Value = model.recordCode;
parameters[36].Value = model.communicationId;
parameters[37].Value = model.hostSim;
parameters[38].Value = model.protocolType;
parameters[39].Value = model.firePartition;
parameters[40].Value = model.systemAddress;
parameters[41].Value = model.analogValueTypeId;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
//string rows=DbHelperSql.GetSingleGUID(strSql.ToString(),parameters);
//if (rows == "")
//{
// return Guid.Empty;
//}
//else
//{
// return Guid.Parse(rows.ToString());
//}
}
