/// <summary> /// 更新一条数据 /// </summary> public bool Update(LumluxSSYDB.Model.tHostInfoState model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tHostInfoState set "); strSql.Append("sHostInfoGUID=@sHostInfoGUID,"); strSql.Append("iState_Online=@iState_Online,"); strSql.Append("iFlag=@iFlag,"); strSql.Append("sState_Alarm=@sState_Alarm,"); strSql.Append("sMeasureInfoGUID=@sMeasureInfoGUID,"); strSql.Append("sSwitchInfoGUID=@sSwitchInfoGUID,"); strSql.Append("dCreateDate=@dCreateDate,"); strSql.Append("dUpdateTime=@dUpdateTime"); strSql.Append(" where sGUID=@sGUID "); SqlParameter[] parameters = { new SqlParameter("@sHostInfoGUID", SqlDbType.Char, 36), new SqlParameter("@iState_Online", SqlDbType.Int, 4), new SqlParameter("@iFlag", SqlDbType.Int, 4), new SqlParameter("@sState_Alarm", SqlDbType.NVarChar, 100), new SqlParameter("@sMeasureInfoGUID", SqlDbType.NVarChar, 200), new SqlParameter("@sSwitchInfoGUID", SqlDbType.Char, 36), new SqlParameter("@dCreateDate", SqlDbType.DateTime), new SqlParameter("@dUpdateTime", SqlDbType.DateTime), new SqlParameter("@sGUID", SqlDbType.Char, 36) }; parameters[0].Value = model.sHostInfoGUID; parameters[1].Value = model.iState_Online; parameters[2].Value = model.iFlag; parameters[3].Value = model.sState_Alarm; parameters[4].Value = model.sMeasureInfoGUID; parameters[5].Value = model.sSwitchInfoGUID; parameters[6].Value = model.dCreateDate; parameters[7].Value = model.dUpdateTime; parameters[8].Value = model.sGUID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public LumluxSSYDB.Model.tHostInfoState DataRowToModel(DataRow row) { LumluxSSYDB.Model.tHostInfoState model = new LumluxSSYDB.Model.tHostInfoState(); if (row != null) { if (row["sGUID"] != null) { model.sGUID = row["sGUID"].ToString(); } if (row["sHostInfoGUID"] != null) { model.sHostInfoGUID = row["sHostInfoGUID"].ToString(); } if (row["iState_Online"] != null && row["iState_Online"].ToString() != "") { model.iState_Online = int.Parse(row["iState_Online"].ToString()); } if (row["iFlag"] != null && row["iFlag"].ToString() != "") { model.iFlag = int.Parse(row["iFlag"].ToString()); } if (row["sState_Alarm"] != null) { model.sState_Alarm = row["sState_Alarm"].ToString(); } if (row["sMeasureInfoGUID"] != null) { model.sMeasureInfoGUID = row["sMeasureInfoGUID"].ToString(); } if (row["sSwitchInfoGUID"] != null) { model.sSwitchInfoGUID = row["sSwitchInfoGUID"].ToString(); } if (row["dCreateDate"] != null && row["dCreateDate"].ToString() != "") { model.dCreateDate = DateTime.Parse(row["dCreateDate"].ToString()); } if (row["dUpdateTime"] != null && row["dUpdateTime"].ToString() != "") { model.dUpdateTime = DateTime.Parse(row["dUpdateTime"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LumluxSSYDB.Model.tHostInfoState model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tHostInfoState("); strSql.Append("sGUID,sHostInfoGUID,iState_Online,iFlag,sState_Alarm,sMeasureInfoGUID,sSwitchInfoGUID,dCreateDate,dUpdateTime)"); strSql.Append(" values ("); strSql.Append("@sGUID,@sHostInfoGUID,@iState_Online,@iFlag,@sState_Alarm,@sMeasureInfoGUID,@sSwitchInfoGUID,@dCreateDate,@dUpdateTime)"); SqlParameter[] parameters = { new SqlParameter("@sGUID", SqlDbType.Char, 36), new SqlParameter("@sHostInfoGUID", SqlDbType.Char, 36), new SqlParameter("@iState_Online", SqlDbType.Int, 4), new SqlParameter("@iFlag", SqlDbType.Int, 4), new SqlParameter("@sState_Alarm", SqlDbType.NVarChar, 100), new SqlParameter("@sMeasureInfoGUID", SqlDbType.NVarChar, 200), new SqlParameter("@sSwitchInfoGUID", SqlDbType.Char, 36), new SqlParameter("@dCreateDate", SqlDbType.DateTime), new SqlParameter("@dUpdateTime", SqlDbType.DateTime) }; parameters[0].Value = model.sGUID; parameters[1].Value = model.sHostInfoGUID; parameters[2].Value = model.iState_Online; parameters[3].Value = model.iFlag; parameters[4].Value = model.sState_Alarm; parameters[5].Value = model.sMeasureInfoGUID; parameters[6].Value = model.sSwitchInfoGUID; parameters[7].Value = model.dCreateDate; parameters[8].Value = model.dUpdateTime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public LumluxSSYDB.Model.tHostInfoState GetModel(string sGUID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 sGUID,sHostInfoGUID,iState_Online,iFlag,sState_Alarm,sMeasureInfoGUID,sSwitchInfoGUID,dCreateDate,dUpdateTime from tHostInfoState "); strSql.Append(" where sGUID=@sGUID "); SqlParameter[] parameters = { new SqlParameter("@sGUID", SqlDbType.Char, 36) }; parameters[0].Value = sGUID; LumluxSSYDB.Model.tHostInfoState model = new LumluxSSYDB.Model.tHostInfoState(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }