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