100 lines
3.0 KiB
C#
100 lines
3.0 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;
|
|||
|
|
using Oracle.ManagedDataAccess.Client;
|
|||
|
|
|
|||
|
|
namespace WMS.SqlServerData.SystemManageData
|
|||
|
|
{
|
|||
|
|
/// <summary>
|
|||
|
|
/// 数据访问类:T_SYS_TEAMUSER
|
|||
|
|
/// </summary>
|
|||
|
|
public partial class TeamUserData : ITeamUser
|
|||
|
|
{
|
|||
|
|
#region BasicMethod
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 增加一条数据
|
|||
|
|
/// </summary>
|
|||
|
|
public void Add(TeamUserModel model)
|
|||
|
|
{
|
|||
|
|
StringBuilder strSql=new StringBuilder();
|
|||
|
|
strSql.Append("insert into T_SYS_TEAMUSER(");
|
|||
|
|
strSql.Append("TEAM_ID,USER_ID)");
|
|||
|
|
strSql.Append(" values (");
|
|||
|
|
strSql.Append(":TEAM_ID,:USER_ID)");
|
|||
|
|
OracleParameter[] parameters = {
|
|||
|
|
new OracleParameter(":TEAM_ID",OracleDbType.Varchar2),
|
|||
|
|
new OracleParameter(":USER_ID",OracleDbType.Varchar2)};
|
|||
|
|
parameters[0].Value = model.TEAM_ID;
|
|||
|
|
parameters[1].Value = model.USER_ID;
|
|||
|
|
|
|||
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 更新一条数据
|
|||
|
|
/// </summary>
|
|||
|
|
public void Update(TeamUserModel model)
|
|||
|
|
{
|
|||
|
|
StringBuilder strSql=new StringBuilder();
|
|||
|
|
strSql.Append("update T_SYS_TEAMUSER set ");
|
|||
|
|
strSql.Append("TEAM_ID=:TEAM_ID,");
|
|||
|
|
strSql.Append("USER_ID=:USER_ID");
|
|||
|
|
strSql.Append(" where TEAM_ID=:TEAM_ID and USER_ID=:USER_ID ");
|
|||
|
|
OracleParameter[] parameters = {
|
|||
|
|
new OracleParameter(":TEAM_ID",OracleDbType.Varchar2),
|
|||
|
|
new OracleParameter(":USER_ID",OracleDbType.Varchar2)};
|
|||
|
|
parameters[0].Value = model.TEAM_ID;
|
|||
|
|
parameters[1].Value = model.USER_ID;
|
|||
|
|
|
|||
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 删除一条数据
|
|||
|
|
/// </summary>
|
|||
|
|
public void Delete(TeamUserModel model)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
StringBuilder strSql=new StringBuilder();
|
|||
|
|
strSql.Append("delete from T_SYS_TEAMUSER ");
|
|||
|
|
strSql.Append(" where TEAM_ID = '" + model.TEAM_ID + "'");
|
|||
|
|
if (!string.IsNullOrEmpty(model.USER_ID))
|
|||
|
|
{
|
|||
|
|
strSql.Append(" and USER_ID='" + model.USER_ID + "'");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString());
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获得数据列表
|
|||
|
|
/// </summary>
|
|||
|
|
public DataTable GetList(TeamUserModel model)
|
|||
|
|
{
|
|||
|
|
StringBuilder strSql=new StringBuilder();
|
|||
|
|
strSql.Append("select ");
|
|||
|
|
strSql.Append("t.TEAM_ID,");
|
|||
|
|
strSql.Append("t.USER_ID,");
|
|||
|
|
strSql.Append("b.NAME as USER_NAME");
|
|||
|
|
strSql.Append(" FROM T_SYS_TEAMUSER t");
|
|||
|
|
strSql.Append(" LEFT JOIN T_BASE_USERINFO b ON b.USER_ID = t.USER_ID");
|
|||
|
|
strSql.Append(" where 1=1 ");
|
|||
|
|
if (!string.IsNullOrEmpty(model.TEAM_ID))
|
|||
|
|
{
|
|||
|
|
strSql.Append(" and t.TEAM_ID ='" + model.TEAM_ID + "'");
|
|||
|
|
}
|
|||
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|||
|
|
}
|
|||
|
|
#endregion BasicMethod
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|