128 lines
4.5 KiB
C#
128 lines
4.5 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Data;
|
|
using WMS.Model.Base;
|
|
using WMS.IData.ISystemManage;
|
|
using WMS.IData;using Oracle.ManagedDataAccess.Client;
|
|
using WMS.Common;
|
|
using WMS.DBUtility;
|
|
using WMS.Model.SystemManage;
|
|
|
|
|
|
namespace WMS.SqlServerData.SystemManageData
|
|
{
|
|
/// <summary>
|
|
/// 数据访问类:T_BASE_FUNCTIONROLE
|
|
/// </summary>
|
|
public partial class FunctionRoleData:IFunctionRole
|
|
{
|
|
#region BasicMethod
|
|
|
|
/// <summary>
|
|
/// 增加一条数据
|
|
/// </summary>
|
|
public void Add(FunctionRoleModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("insert into T_BASE_FUNCTIONROLE(");
|
|
strSql.Append("ID,FUN_ID,ROLE_ID,USER_ID,MENU_ID)");
|
|
strSql.Append(" values (");
|
|
strSql.Append(":ID,:FUN_ID,:ROLE_ID,:USER_ID,:MENU_ID)");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":ID", OracleDbType.Decimal),
|
|
new OracleParameter(":FUN_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":ROLE_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":USER_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":MENU_ID",OracleDbType.Varchar2)};
|
|
parameters[0].Value = model.ID;
|
|
parameters[1].Value = model.FUN_ID;
|
|
parameters[2].Value = model.ROLE_ID;
|
|
parameters[3].Value = model.USER_ID;
|
|
parameters[4].Value = model.MENU_ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(),parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新一条数据
|
|
/// </summary>
|
|
public void Update(FunctionRoleModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("update T_BASE_FUNCTIONROLE set ");
|
|
strSql.Append("ID=:ID,");
|
|
strSql.Append("FUN_ID=:FUN_ID,");
|
|
strSql.Append("USER_ID=:USER_ID,");
|
|
strSql.Append("MENU_ID=:MENU_ID");
|
|
strSql.Append(" where ");
|
|
strSql.Append("ROLE_ID=:ROLE_ID");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":ID", OracleDbType.Decimal),
|
|
new OracleParameter(":FUN_ID",OracleDbType.Varchar2,20),
|
|
new OracleParameter(":USER_ID",OracleDbType.Varchar2,20),
|
|
new OracleParameter(":MENU_ID",OracleDbType.Varchar2,20),
|
|
new OracleParameter(":ROLE_ID",OracleDbType.Varchar2,20)};
|
|
parameters[0].Value = model.ID;
|
|
parameters[1].Value = model.FUN_ID;
|
|
parameters[2].Value = model.USER_ID;
|
|
parameters[3].Value = model.MENU_ID;
|
|
parameters[4].Value = model.ROLE_ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除一条数据
|
|
/// </summary>
|
|
public void Delete(FunctionRoleModel model)
|
|
{
|
|
//该表无主键信息，请自定义主键/条件字段
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("delete from T_BASE_FUNCTIONROLE ");
|
|
strSql.Append(" where ");
|
|
strSql.Append(" ROLE_ID=:ROLE_ID and MENU_ID=:MENU_ID and FUN_ID=:FUN_ID");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":ROLE_ID",OracleDbType.Varchar2,20),
|
|
new OracleParameter(":MENU_ID",OracleDbType.Varchar2,20),
|
|
new OracleParameter(":FUN_ID",OracleDbType.Varchar2,20),
|
|
};
|
|
parameters[0].Value = model.ROLE_ID;
|
|
parameters[1].Value = model.MENU_ID;
|
|
parameters[2].Value = model.FUN_ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获得数据列表
|
|
/// </summary>
|
|
public DataTable GetList(FunctionRoleModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("select t.ID,");
|
|
strSql.Append("t.FUN_ID,");
|
|
strSql.Append("e.FUN_DICTORY FUN_DICTORY,");
|
|
strSql.Append("t.ROLE_ID,");
|
|
strSql.Append("t.USER_ID,");
|
|
strSql.Append("t.MENU_ID, ");
|
|
strSql.Append("a.MENU_NAME MENU_NAME");
|
|
strSql.Append(" FROM T_BASE_FUNCTIONROLE t");
|
|
strSql.Append(" LEFT JOIN t_Base_Functioninfo e ON e.FUN_ID = t.FUN_ID and e.MENU_ID = t.MENU_ID");
|
|
strSql.Append(" LEFT JOIN t_base_menu a ON a.MENU_ID = t.MENU_ID");
|
|
strSql.Append(" where 1=1 ");
|
|
if(!string.IsNullOrEmpty(model.ROLE_ID))
|
|
{
|
|
strSql.Append(" and t.ROLE_ID ='" + model.ROLE_ID + "'");
|
|
}
|
|
if (!string.IsNullOrEmpty(model.MENU_ID))
|
|
{
|
|
strSql.Append(" and t.MENU_ID ='" + model.MENU_ID + "'");
|
|
}
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|
}
|
|
#endregion BasicMethod
|
|
}
|
|
}
|
|
|