/// <summary> /// 得到一个对象实体 /// </summary> public ClassLibrary1.Model.TcqInfo GetModel(Guid Guid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 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 from TcqInfo "); strSql.Append(" where Guid=@Guid "); SqlParameter[] parameters = { new SqlParameter("@Guid", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = Guid; ClassLibrary1.Model.TcqInfo model = new ClassLibrary1.Model.TcqInfo(); DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <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()); //} }
/// <summary> /// 得到一个对象实体 /// </summary> public ClassLibrary1.Model.TcqInfo DataRowToModel(DataRow row) { ClassLibrary1.Model.TcqInfo model = new ClassLibrary1.Model.TcqInfo(); if (row != null) { if (row["Guid"] != null && row["Guid"].ToString() != "") { model.Guid = new Guid(row["Guid"].ToString()); } if (row["detectorCode"] != null) { model.detectorCode = row["detectorCode"].ToString(); } if (row["detectorName"] != null) { model.detectorName = row["detectorName"].ToString(); } if (row["mainframeId"] != null) { model.mainframeId = row["mainframeId"].ToString(); } if (row["buildingId"] != null) { model.buildingId = row["buildingId"].ToString(); } if (row["detectorAddr"] != null) { model.detectorAddr = row["detectorAddr"].ToString(); } if (row["orgId"] != null) { model.orgId = row["orgId"].ToString(); } if (row["detectorType"] != null) { model.detectorType = row["detectorType"].ToString(); } if (row["ifcsSystemType"] != null) { model.ifcsSystemType = row["ifcsSystemType"].ToString(); } if (row["partunitloopCode"] != null) { model.partunitloopCode = row["partunitloopCode"].ToString(); } if (row["channelNo"] != null) { model.channelNo = row["channelNo"].ToString(); } if (row["hardwareVersion"] != null) { model.hardwareVersion = row["hardwareVersion"].ToString(); } if (row["softwareVersion"] != null) { model.softwareVersion = row["softwareVersion"].ToString(); } if (row["personId"] != null) { model.personId = row["personId"].ToString(); } if (row["minalarmValue"] != null) { model.minalarmValue = row["minalarmValue"].ToString(); } if (row["maxalarmValue"] != null) { model.maxalarmValue = row["maxalarmValue"].ToString(); } if (row["deviceRange"] != null) { model.deviceRange = row["deviceRange"].ToString(); } if (row["basalArea"] != null) { model.basalArea = row["basalArea"].ToString(); } if (row["maxHeight"] != null) { model.maxHeight = row["maxHeight"].ToString(); } if (row["registerTime"] != null) { model.registerTime = row["registerTime"].ToString(); } if (row["registerStatus"] != null) { model.registerStatus = row["registerStatus"].ToString(); } if (row["detectorRunBigStatus"] != null) { model.detectorRunBigStatus = row["detectorRunBigStatus"].ToString(); } if (row["detectorRunSmallStatus"] != null) { model.detectorRunSmallStatus = row["detectorRunSmallStatus"].ToString(); } if (row["producerId"] != null) { model.producerId = row["producerId"].ToString(); } if (row["produceDate"] != null) { model.produceDate = row["produceDate"].ToString(); } if (row["runDate"] != null) { model.runDate = row["runDate"].ToString(); } if (row["serviceLimit"] != null) { model.serviceLimit = row["serviceLimit"].ToString(); } if (row["mapType"] != null) { model.mapType = row["mapType"].ToString(); } if (row["gpsX3d"] != null) { model.gpsX3d = row["gpsX3d"].ToString(); } if (row["gpsY3d"] != null) { model.gpsY3d = row["gpsY3d"].ToString(); } if (row["gpsZ3d"] != null) { model.gpsZ3d = row["gpsZ3d"].ToString(); } if (row["planId"] != null) { model.planId = row["planId"].ToString(); } if (row["planX"] != null) { model.planX = row["planX"].ToString(); } if (row["planY"] != null) { model.planY = row["planY"].ToString(); } if (row["platformCode"] != null) { model.platformCode = row["platformCode"].ToString(); } if (row["recordCode"] != null) { model.recordCode = row["recordCode"].ToString(); } if (row["communicationId"] != null) { model.communicationId = row["communicationId"].ToString(); } if (row["hostSim"] != null) { model.hostSim = row["hostSim"].ToString(); } if (row["protocolType"] != null) { model.protocolType = row["protocolType"].ToString(); } if (row["firePartition"] != null) { model.firePartition = row["firePartition"].ToString(); } if (row["systemAddress"] != null) { model.systemAddress = row["systemAddress"].ToString(); } if (row["analogValueTypeId"] != null) { model.analogValueTypeId = row["analogValueTypeId"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ClassLibrary1.Model.TcqInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TcqInfo set "); strSql.Append("detectorCode=@detectorCode,"); strSql.Append("detectorName=@detectorName,"); strSql.Append("mainframeId=@mainframeId,"); strSql.Append("buildingId=@buildingId,"); strSql.Append("detectorAddr=@detectorAddr,"); strSql.Append("orgId=@orgId,"); strSql.Append("detectorType=@detectorType,"); strSql.Append("ifcsSystemType=@ifcsSystemType,"); strSql.Append("partunitloopCode=@partunitloopCode,"); strSql.Append("channelNo=@channelNo,"); strSql.Append("hardwareVersion=@hardwareVersion,"); strSql.Append("softwareVersion=@softwareVersion,"); strSql.Append("personId=@personId,"); strSql.Append("minalarmValue=@minalarmValue,"); strSql.Append("maxalarmValue=@maxalarmValue,"); strSql.Append("deviceRange=@deviceRange,"); strSql.Append("basalArea=@basalArea,"); strSql.Append("maxHeight=@maxHeight,"); strSql.Append("registerTime=@registerTime,"); strSql.Append("registerStatus=@registerStatus,"); strSql.Append("detectorRunBigStatus=@detectorRunBigStatus,"); strSql.Append("detectorRunSmallStatus=@detectorRunSmallStatus,"); strSql.Append("producerId=@producerId,"); strSql.Append("produceDate=@produceDate,"); strSql.Append("runDate=@runDate,"); strSql.Append("serviceLimit=@serviceLimit,"); strSql.Append("mapType=@mapType,"); strSql.Append("gpsX3d=@gpsX3d,"); strSql.Append("gpsY3d=@gpsY3d,"); strSql.Append("gpsZ3d=@gpsZ3d,"); strSql.Append("planId=@planId,"); strSql.Append("planX=@planX,"); strSql.Append("planY=@planY,"); strSql.Append("platformCode=@platformCode,"); strSql.Append("recordCode=@recordCode,"); strSql.Append("communicationId=@communicationId,"); strSql.Append("hostSim=@hostSim,"); strSql.Append("protocolType=@protocolType,"); strSql.Append("firePartition=@firePartition,"); strSql.Append("systemAddress=@systemAddress,"); strSql.Append("analogValueTypeId=@analogValueTypeId"); strSql.Append(" where Guid=@Guid "); SqlParameter[] parameters = { 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), new SqlParameter("@Guid", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = model.detectorCode; parameters[1].Value = model.detectorName; parameters[2].Value = model.mainframeId; parameters[3].Value = model.buildingId; parameters[4].Value = model.detectorAddr; parameters[5].Value = model.orgId; parameters[6].Value = model.detectorType; parameters[7].Value = model.ifcsSystemType; parameters[8].Value = model.partunitloopCode; parameters[9].Value = model.channelNo; parameters[10].Value = model.hardwareVersion; parameters[11].Value = model.softwareVersion; parameters[12].Value = model.personId; parameters[13].Value = model.minalarmValue; parameters[14].Value = model.maxalarmValue; parameters[15].Value = model.deviceRange; parameters[16].Value = model.basalArea; parameters[17].Value = model.maxHeight; parameters[18].Value = model.registerTime; parameters[19].Value = model.registerStatus; parameters[20].Value = model.detectorRunBigStatus; parameters[21].Value = model.detectorRunSmallStatus; parameters[22].Value = model.producerId; parameters[23].Value = model.produceDate; parameters[24].Value = model.runDate; parameters[25].Value = model.serviceLimit; parameters[26].Value = model.mapType; parameters[27].Value = model.gpsX3d; parameters[28].Value = model.gpsY3d; parameters[29].Value = model.gpsZ3d; parameters[30].Value = model.planId; parameters[31].Value = model.planX; parameters[32].Value = model.planY; parameters[33].Value = model.platformCode; parameters[34].Value = model.recordCode; parameters[35].Value = model.communicationId; parameters[36].Value = model.hostSim; parameters[37].Value = model.protocolType; parameters[38].Value = model.firePartition; parameters[39].Value = model.systemAddress; parameters[40].Value = model.analogValueTypeId; parameters[41].Value = model.Guid; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }