/// <summary> /// 更新一条数据 /// </summary> public bool Update(Parking.Core.Model.PBA_EXTERNAL_DEVICE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PBA_EXTERNAL_DEVICE set "); strSql.Append("DEVICE_NAME=@DEVICE_NAME,"); strSql.Append("DEVICE_TYPE=@DEVICE_TYPE,"); strSql.Append("DEVICE_NUMBER=@DEVICE_NUMBER,"); strSql.Append("IP_ADDRESS=@IP_ADDRESS,"); strSql.Append("PORT=@PORT,"); strSql.Append("CREATE_TIME=@CREATE_TIME,"); strSql.Append("CREATE_USERID=@CREATE_USERID,"); strSql.Append("REMARK=@REMARK"); strSql.Append(" where DEVICE_CODE=@DEVICE_CODE "); SqlParameter[] parameters = { new SqlParameter("@DEVICE_NAME", SqlDbType.VarChar, 50), new SqlParameter("@DEVICE_TYPE", SqlDbType.Int, 4), new SqlParameter("@DEVICE_NUMBER", SqlDbType.Int, 4), new SqlParameter("@IP_ADDRESS", SqlDbType.VarChar, 50), new SqlParameter("@PORT", SqlDbType.Int, 4), new SqlParameter("@CREATE_TIME", SqlDbType.DateTime), new SqlParameter("@CREATE_USERID", SqlDbType.VarChar, 50), new SqlParameter("@REMARK", SqlDbType.VarChar, 500), new SqlParameter("@DEVICE_CODE", SqlDbType.VarChar, 50) }; parameters[0].Value = model.DEVICE_NAME; parameters[1].Value = model.DEVICE_TYPE; parameters[2].Value = model.DEVICE_NUMBER; parameters[3].Value = model.IP_ADDRESS; parameters[4].Value = model.PORT; parameters[5].Value = model.CREATE_TIME; parameters[6].Value = model.CREATE_USERID; parameters[7].Value = model.REMARK; parameters[8].Value = model.DEVICE_CODE; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Parking.Core.Model.PBA_EXTERNAL_DEVICE DataRowToModel(DataRow row) { Parking.Core.Model.PBA_EXTERNAL_DEVICE model = new Parking.Core.Model.PBA_EXTERNAL_DEVICE(); if (row != null) { if (row["DEVICE_CODE"] != null) { model.DEVICE_CODE = row["DEVICE_CODE"].ToString(); } if (row["DEVICE_NAME"] != null) { model.DEVICE_NAME = row["DEVICE_NAME"].ToString(); } if (row["DEVICE_TYPE"] != null && row["DEVICE_TYPE"].ToString() != "") { model.DEVICE_TYPE = int.Parse(row["DEVICE_TYPE"].ToString()); } if (row["DEVICE_NUMBER"] != null && row["DEVICE_NUMBER"].ToString() != "") { model.DEVICE_NUMBER = int.Parse(row["DEVICE_NUMBER"].ToString()); } if (row["IP_ADDRESS"] != null) { model.IP_ADDRESS = row["IP_ADDRESS"].ToString(); } if (row["PORT"] != null && row["PORT"].ToString() != "") { model.PORT = int.Parse(row["PORT"].ToString()); } if (row["CREATE_TIME"] != null && row["CREATE_TIME"].ToString() != "") { model.CREATE_TIME = DateTime.Parse(row["CREATE_TIME"].ToString()); } if (row["CREATE_USERID"] != null) { model.CREATE_USERID = row["CREATE_USERID"].ToString(); } if (row["REMARK"] != null) { model.REMARK = row["REMARK"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Parking.Core.Model.PBA_EXTERNAL_DEVICE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PBA_EXTERNAL_DEVICE("); strSql.Append("DEVICE_CODE,DEVICE_NAME,DEVICE_TYPE,DEVICE_NUMBER,IP_ADDRESS,PORT,CREATE_TIME,CREATE_USERID,REMARK)"); strSql.Append(" values ("); strSql.Append("@DEVICE_CODE,@DEVICE_NAME,@DEVICE_TYPE,@DEVICE_NUMBER,@IP_ADDRESS,@PORT,@CREATE_TIME,@CREATE_USERID,@REMARK)"); SqlParameter[] parameters = { new SqlParameter("@DEVICE_CODE", SqlDbType.VarChar, 50), new SqlParameter("@DEVICE_NAME", SqlDbType.VarChar, 50), new SqlParameter("@DEVICE_TYPE", SqlDbType.Int, 4), new SqlParameter("@DEVICE_NUMBER", SqlDbType.Int, 4), new SqlParameter("@IP_ADDRESS", SqlDbType.VarChar, 50), new SqlParameter("@PORT", SqlDbType.Int, 4), new SqlParameter("@CREATE_TIME", SqlDbType.DateTime), new SqlParameter("@CREATE_USERID", SqlDbType.VarChar, 50), new SqlParameter("@REMARK", SqlDbType.VarChar, 500) }; parameters[0].Value = model.DEVICE_CODE; parameters[1].Value = model.DEVICE_NAME; parameters[2].Value = model.DEVICE_TYPE; parameters[3].Value = model.DEVICE_NUMBER; parameters[4].Value = model.IP_ADDRESS; parameters[5].Value = model.PORT; parameters[6].Value = model.CREATE_TIME; parameters[7].Value = model.CREATE_USERID; parameters[8].Value = model.REMARK; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Parking.Core.Model.PBA_EXTERNAL_DEVICE GetModel(string DEVICE_CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 DEVICE_CODE,DEVICE_NAME,DEVICE_TYPE,DEVICE_NUMBER,IP_ADDRESS,PORT,CREATE_TIME,CREATE_USERID,REMARK from PBA_EXTERNAL_DEVICE "); strSql.Append(" where DEVICE_CODE=@DEVICE_CODE "); SqlParameter[] parameters = { new SqlParameter("@DEVICE_CODE", SqlDbType.VarChar, 50) }; parameters[0].Value = DEVICE_CODE; Parking.Core.Model.PBA_EXTERNAL_DEVICE model = new Parking.Core.Model.PBA_EXTERNAL_DEVICE(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }