/// <summary> /// 对象实体绑定数据 /// </summary> public UserPermission.Model.USER_SHARE_PROJECT ReaderBind(IDataReader dataReader) { UserPermission.Model.USER_SHARE_PROJECT model = new UserPermission.Model.USER_SHARE_PROJECT(); object ojb; ojb = dataReader["PROJECTID"]; if (ojb != null && ojb != DBNull.Value) { model.PROJECTID = (decimal)ojb; } model.PROJECTNAME = dataReader["PROJECTNAME"].ToString(); model.APISERVICEKEY = dataReader["APISERVICEKEY"].ToString(); ojb = dataReader["CREATEDATE"]; if (ojb != null && ojb != DBNull.Value) { model.CREATEDATE = (DateTime)ojb; } model.PROJECTREMARK = dataReader["PROJECTREMARK"].ToString(); ojb = dataReader["STATUS"]; if (ojb != null && ojb != DBNull.Value) { model.STATUS = (decimal)ojb; } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(UserPermission.Model.USER_SHARE_PROJECT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into USER_SHARE_PROJECT("); strSql.Append("PROJECTID,PROJECTNAME,APISERVICEKEY,CREATEDATE,PROJECTREMARK,STATUS)"); strSql.Append(" values ("); strSql.Append("@PROJECTID,@PROJECTNAME,@APISERVICEKEY,@CREATEDATE,@PROJECTREMARK,@STATUS)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "PROJECTID", DbType.String, model.PROJECTID); db.AddInParameter(dbCommand, "PROJECTNAME", DbType.String, model.PROJECTNAME); db.AddInParameter(dbCommand, "APISERVICEKEY", DbType.String, model.APISERVICEKEY); db.AddInParameter(dbCommand, "CREATEDATE", DbType.String, model.CREATEDATE); db.AddInParameter(dbCommand, "PROJECTREMARK", DbType.String, model.PROJECTREMARK); db.AddInParameter(dbCommand, "STATUS", DbType.String, model.STATUS); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 得到一个对象实体 /// </summary> public UserPermission.Model.USER_SHARE_PROJECT GetModel(decimal PROJECTID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select PROJECTID,PROJECTNAME,APISERVICEKEY,CREATEDATE,PROJECTREMARK,STATUS from USER_SHARE_PROJECT "); strSql.Append(" where PROJECTID=@PROJECTID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "PROJECTID", DbType.String, PROJECTID); UserPermission.Model.USER_SHARE_PROJECT model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(UserPermission.Model.USER_SHARE_PROJECT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update USER_SHARE_PROJECT set "); strSql.Append("PROJECTNAME=@PROJECTNAME,"); strSql.Append("APISERVICEKEY=@APISERVICEKEY,"); strSql.Append("CREATEDATE=@CREATEDATE,"); strSql.Append("PROJECTREMARK=@PROJECTREMARK,"); strSql.Append("STATUS=@STATUS"); strSql.Append(" where PROJECTID=@PROJECTID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "PROJECTID", DbType.String, model.PROJECTID); db.AddInParameter(dbCommand, "PROJECTNAME", DbType.String, model.PROJECTNAME); db.AddInParameter(dbCommand, "APISERVICEKEY", DbType.String, model.APISERVICEKEY); db.AddInParameter(dbCommand, "CREATEDATE", DbType.String, model.CREATEDATE); db.AddInParameter(dbCommand, "PROJECTREMARK", DbType.String, model.PROJECTREMARK); db.AddInParameter(dbCommand, "STATUS", DbType.String, model.STATUS); db.ExecuteNonQuery(dbCommand); }