/// <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);
}
