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