/// <summary> /// 更新一条数据 /// </summary> public bool Update(Parking.Core.Model.UP_DATA_INTERACTION_PERMISSIONS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UP_DATA_INTERACTION_PERMISSIONS set "); strSql.Append("SERVICE_NAME=@SERVICE_NAME,"); strSql.Append("AUTHENTICATION_CODE=@AUTHENTICATION_CODE,"); strSql.Append("SERVICE_REMARK=@SERVICE_REMARK,"); strSql.Append("SEND_TYPE_COLLECTION=@SEND_TYPE_COLLECTION,"); strSql.Append("SERVICE_STATUS=@SERVICE_STATUS,"); strSql.Append("START_FLAG=@START_FLAG"); strSql.Append(" where SERVICE_CODE=@SERVICE_CODE "); SqlParameter[] parameters = { new SqlParameter("@SERVICE_NAME", SqlDbType.VarChar, 50), new SqlParameter("@AUTHENTICATION_CODE", SqlDbType.VarChar, 50), new SqlParameter("@SERVICE_REMARK", SqlDbType.VarChar, 1000), new SqlParameter("@SEND_TYPE_COLLECTION", SqlDbType.VarChar, 1000), new SqlParameter("@SERVICE_STATUS", SqlDbType.Int, 4), new SqlParameter("@START_FLAG", SqlDbType.Int, 4), new SqlParameter("@SERVICE_CODE", SqlDbType.VarChar, 50) }; parameters[0].Value = model.SERVICE_NAME; parameters[1].Value = model.AUTHENTICATION_CODE; parameters[2].Value = model.SERVICE_REMARK; parameters[3].Value = model.SEND_TYPE_COLLECTION; parameters[4].Value = model.SERVICE_STATUS; parameters[5].Value = model.START_FLAG; parameters[6].Value = model.SERVICE_CODE; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Parking.Core.Model.UP_DATA_INTERACTION_PERMISSIONS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UP_DATA_INTERACTION_PERMISSIONS("); strSql.Append("SERVICE_CODE,SERVICE_NAME,AUTHENTICATION_CODE,SERVICE_REMARK,SEND_TYPE_COLLECTION,SERVICE_STATUS,START_FLAG)"); strSql.Append(" values ("); strSql.Append("@SERVICE_CODE,@SERVICE_NAME,@AUTHENTICATION_CODE,@SERVICE_REMARK,@SEND_TYPE_COLLECTION,@SERVICE_STATUS,@START_FLAG)"); SqlParameter[] parameters = { new SqlParameter("@SERVICE_CODE", SqlDbType.VarChar, 50), new SqlParameter("@SERVICE_NAME", SqlDbType.VarChar, 50), new SqlParameter("@AUTHENTICATION_CODE", SqlDbType.VarChar, 50), new SqlParameter("@SERVICE_REMARK", SqlDbType.VarChar, 1000), new SqlParameter("@SEND_TYPE_COLLECTION", SqlDbType.VarChar, 1000), new SqlParameter("@SERVICE_STATUS", SqlDbType.Int, 4), new SqlParameter("@START_FLAG", SqlDbType.Int, 4) }; parameters[0].Value = model.SERVICE_CODE; parameters[1].Value = model.SERVICE_NAME; parameters[2].Value = model.AUTHENTICATION_CODE; parameters[3].Value = model.SERVICE_REMARK; parameters[4].Value = model.SEND_TYPE_COLLECTION; parameters[5].Value = model.SERVICE_STATUS; parameters[6].Value = model.START_FLAG; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Parking.Core.Model.UP_DATA_INTERACTION_PERMISSIONS DataRowToModel(DataRow row) { Parking.Core.Model.UP_DATA_INTERACTION_PERMISSIONS model = new Parking.Core.Model.UP_DATA_INTERACTION_PERMISSIONS(); if (row != null) { if (row["SERVICE_CODE"] != null) { model.SERVICE_CODE = row["SERVICE_CODE"].ToString(); } if (row["SERVICE_NAME"] != null) { model.SERVICE_NAME = row["SERVICE_NAME"].ToString(); } if (row["AUTHENTICATION_CODE"] != null) { model.AUTHENTICATION_CODE = row["AUTHENTICATION_CODE"].ToString(); } if (row["SERVICE_REMARK"] != null) { model.SERVICE_REMARK = row["SERVICE_REMARK"].ToString(); } if (row["SEND_TYPE_COLLECTION"] != null) { model.SEND_TYPE_COLLECTION = row["SEND_TYPE_COLLECTION"].ToString(); } if (row["SERVICE_STATUS"] != null && row["SERVICE_STATUS"].ToString() != "") { model.SERVICE_STATUS = int.Parse(row["SERVICE_STATUS"].ToString()); } if (row["START_FLAG"] != null && row["START_FLAG"].ToString() != "") { model.START_FLAG = int.Parse(row["START_FLAG"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Parking.Core.Model.UP_DATA_INTERACTION_PERMISSIONS GetModel(string SERVICE_CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SERVICE_CODE,SERVICE_NAME,AUTHENTICATION_CODE,SERVICE_REMARK,SEND_TYPE_COLLECTION,SERVICE_STATUS,START_FLAG from UP_DATA_INTERACTION_PERMISSIONS "); strSql.Append(" where SERVICE_CODE=@SERVICE_CODE "); SqlParameter[] parameters = { new SqlParameter("@SERVICE_CODE", SqlDbType.VarChar, 50) }; parameters[0].Value = SERVICE_CODE; Parking.Core.Model.UP_DATA_INTERACTION_PERMISSIONS model = new Parking.Core.Model.UP_DATA_INTERACTION_PERMISSIONS(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }