/// <summary>
/// 检查数据是否存在
/// </summary>
public bool Exists(WebPlatForm_Module_Relation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from WebPlatForm_Module_Relation where nRoleID=@nRoleID and nModuleID=@nModuleID");
SqlParameter[] parameters =
{
new SqlParameter("nRoleID", model.nRoleID),
new SqlParameter("nModuleID", model.nModuleID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters)) > 0);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebPlatForm_Module_Relation GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select *");
strSql.Append(" from WebPlatForm_Module_Relation where nID=@ID");
SqlParameter[] sqlParams =
{
new SqlParameter("ID", ID)
};
WebPlatForm_Module_Relation model = new WebPlatForm_Module_Relation();
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["nID"].ToString() != "")
{
model.nID = int.Parse(ds.Tables[0].Rows[0]["nID"].ToString());
}
if (ds.Tables[0].Rows[0]["nModuleID"].ToString() != "")
{
model.nModuleID = int.Parse(ds.Tables[0].Rows[0]["nModuleID"].ToString());
}
if (ds.Tables[0].Rows[0]["nRoleID"].ToString() != "")
{
model.nRoleID = int.Parse(ds.Tables[0].Rows[0]["nRoleID"].ToString());
}
model.charRoleMark = ds.Tables[0].Rows[0]["charRoleMark"].ToString();
if (ds.Tables[0].Rows[0]["nTabIndex"].ToString() != "")
{
model.nTabIndex = int.Parse(ds.Tables[0].Rows[0]["nTabIndex"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WebPlatForm_Module_Relation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WebPlatForm_Module_Relation(");
strSql.Append("nModuleID,nRoleID,nTabIndex");
strSql.Append(") values (");
strSql.Append("@nModuleID,@nRoleID,0");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@nModuleID", SqlDbType.Int, 4),
new SqlParameter("@nRoleID", SqlDbType.Int, 4),
new SqlParameter("@nTabIndex", SqlDbType.Int, 4)
};
parameters[0].Value = model.nModuleID;
parameters[1].Value = model.nRoleID;
parameters[2].Value = model.nTabIndex;
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebPlatForm_Module_Relation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WebPlatForm_Module_Relation set ");
strSql.Append(" nModuleID = @nModuleID , ");
strSql.Append(" nRoleID = @nRoleID , ");
strSql.Append(" nTabIndex = @nTabIndex ");
strSql.Append(" where nID=@nID ");
SqlParameter[] parameters =
{
new SqlParameter("@nID", SqlDbType.Int, 4),
new SqlParameter("@nModuleID", SqlDbType.Int, 4),
new SqlParameter("@nRoleID", SqlDbType.Int, 4),
new SqlParameter("@nTabIndex", SqlDbType.Int, 4)
};
parameters[0].Value = model.nID;
parameters[1].Value = model.nModuleID;
parameters[2].Value = model.nRoleID;
parameters[3].Value = model.nTabIndex;
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
