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
	}
}