/// <summary>对象实体绑定数据 /// /// </summary> /// <param name="dataReader">IDataReader对象</param> /// <returns>返回实体对象</returns> public Nikita.Assist.CodeMaker.Model.Sys_Roles ReaderBind(IDataReader dataReader) { Nikita.Assist.CodeMaker.Model.Sys_Roles model = new Nikita.Assist.CodeMaker.Model.Sys_Roles(); object ojb; ojb = dataReader["KeyId"]; if (ojb != null && ojb != DBNull.Value) { model.KeyId = int.Parse(ojb.ToString()); } model.RoleName = dataReader["RoleName"].ToString(); ojb = dataReader["Sortnum"]; if (ojb != null && ojb != DBNull.Value) { model.Sortnum = int.Parse(ojb.ToString()); } model.Remark = dataReader["Remark"].ToString(); ojb = dataReader["isDefault"]; if (ojb != null && ojb != DBNull.Value) { model.isDefault = int.Parse(ojb.ToString()); } return(model); }
/// <summary>增加一条数据 /// /// </summary> /// <param name="model">实体对象</param> /// <returns>返回新增实体ID</returns> public int Add(Nikita.Assist.CodeMaker.Model.Sys_Roles model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Roles("); strSql.Append("RoleName, Sortnum, Remark, isDefault )"); strSql.Append(" values ("); strSql.Append("@RoleName, @Sortnum, @Remark, @isDefault )"); strSql.Append(";select @@IDENTITY"); DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo(); h.CreateCommand(strSql.ToString()); if (model.RoleName == null) { h.AddParameter("@RoleName", DBNull.Value); } else { h.AddParameter("@RoleName", model.RoleName); } if (model.Sortnum == null) { h.AddParameter("@Sortnum", DBNull.Value); } else { h.AddParameter("@Sortnum", model.Sortnum); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.isDefault == null) { h.AddParameter("@isDefault", DBNull.Value); } else { h.AddParameter("@isDefault", model.isDefault); } int intResult; string strObj = h.ExecuteScalar(); if (!int.TryParse(strObj, out intResult)) { return(0); } return(intResult); }
/// <summary>更新一条数据 /// /// </summary> /// <param name="model">实体对象</param> /// <returns>返回受影响的行数</returns> public bool Update(Nikita.Assist.CodeMaker.Model.Sys_Roles model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Roles set "); strSql.Append("RoleName=@RoleName, Sortnum=@Sortnum, Remark=@Remark, isDefault=@isDefault "); strSql.Append(" where KeyId=@KeyId "); DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo(); h.CreateCommand(strSql.ToString()); if (model.KeyId == null) { h.AddParameter("@KeyId", DBNull.Value); } else { h.AddParameter("@KeyId", model.KeyId); } if (model.RoleName == null) { h.AddParameter("@RoleName", DBNull.Value); } else { h.AddParameter("@RoleName", model.RoleName); } if (model.Sortnum == null) { h.AddParameter("@Sortnum", DBNull.Value); } else { h.AddParameter("@Sortnum", model.Sortnum); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.isDefault == null) { h.AddParameter("@isDefault", DBNull.Value); } else { h.AddParameter("@isDefault", model.isDefault); } return(h.ExecuteNonQuery()); }
/// <summary>得到一个对象实体 /// /// </summary> /// <param name="KeyId">主键</param> /// <returns>返回对象实体</returns> public Nikita.Assist.CodeMaker.Model.Sys_Roles GetModel(int KeyId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from Sys_Roles "); strSql.Append(" where KeyId=@KeyId "); DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo(); h.CreateCommand(strSql.ToString()); h.AddParameter("@KeyId", KeyId); Nikita.Assist.CodeMaker.Model.Sys_Roles model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>根据条件得到一个对象实体 /// /// </summary> /// <param name="strCond">条件</param> /// <returns>返回对象实体</returns> public Nikita.Assist.CodeMaker.Model.Sys_Roles GetModelByCond(string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from Sys_Roles "); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo(); h.CreateCommand(strSql.ToString()); Nikita.Assist.CodeMaker.Model.Sys_Roles model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }