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