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_TEAM
	/// </summary>
    public partial class TeamData : ITeam
	{
		#region  BasicMethod

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public void Add(TeamModel model)
		{
            //暂时维护 工作类型
            model.WORK_TYPE = "WORK_TYPE";
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into T_SYS_TEAM(");
            strSql.Append("TEAM_ID,TEAM_NAME,TEAM_MASTER,REMARK,PY_NAME,WORK_TYPE,DEP_ID)");
			strSql.Append(" values (");
            strSql.Append(":TEAM_ID,:TEAM_NAME,:TEAM_MASTER,:REMARK,:PY_NAME,:WORK_TYPE,:DEP_ID)");
			OracleParameter[] parameters = {
					new OracleParameter(":TEAM_ID",OracleDbType.Varchar2,50),
					new OracleParameter(":TEAM_NAME",OracleDbType.Varchar2,50),
					new OracleParameter(":TEAM_MASTER",OracleDbType.Varchar2,50),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":PY_NAME",OracleDbType.Varchar2,50),
                   new OracleParameter(":WORK_TYPE",OracleDbType.Varchar2,50),
                   new OracleParameter(":DEP_ID",OracleDbType.Varchar2,50),
                                           };
			parameters[0].Value = model.TEAM_ID;
			parameters[1].Value = model.TEAM_NAME;
			parameters[2].Value = model.TEAM_MASTER;
			parameters[3].Value = model.REMARK;
			parameters[4].Value = model.PY_NAME;
            parameters[5].Value = model.WORK_TYPE;
            parameters[6].Value = model.DEP_ID;

            SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
		}
		/// <summary>
		/// 更新一条数据
		/// </summary>
		public void Update(TeamModel model)
        {
            model.WORK_TYPE = "WORK_TYPE";
            StringBuilder strSql=new StringBuilder();
			strSql.Append("update T_SYS_TEAM set ");
			strSql.Append("TEAM_NAME=:TEAM_NAME,");
			strSql.Append("TEAM_MASTER=:TEAM_MASTER,");
			strSql.Append("REMARK=:REMARK,");
			strSql.Append("PY_NAME=:PY_NAME,");
            strSql.Append("WORK_TYPE=:WORK_TYPE,");
            strSql.Append("DEP_ID=:DEP_ID");
			strSql.Append(" where TEAM_ID=:TEAM_ID ");
			OracleParameter[] parameters = {
					new OracleParameter(":TEAM_NAME",OracleDbType.Varchar2,50),
					new OracleParameter(":TEAM_MASTER",OracleDbType.Varchar2,50),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":PY_NAME",OracleDbType.Varchar2,50),
                   new OracleParameter(":WORK_TYPE",OracleDbType.Varchar2,50),
					new OracleParameter(":DEP_ID",OracleDbType.Varchar2,50),
					new OracleParameter(":TEAM_ID",OracleDbType.Varchar2,50)};
			parameters[0].Value = model.TEAM_NAME;
			parameters[1].Value = model.TEAM_MASTER;
			parameters[2].Value = model.REMARK;
			parameters[3].Value = model.PY_NAME;
            parameters[4].Value = model.WORK_TYPE;
            parameters[5].Value = model.DEP_ID;
            parameters[6].Value = model.TEAM_ID;

            SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
		}

		/// <summary>
		/// 删除一条数据
		/// </summary>
        public void Delete(TeamModel model)
		{
			
			StringBuilder strSql=new StringBuilder();
			strSql.Append("delete from T_SYS_TEAM ");
			strSql.Append(" where TEAM_ID=:TEAM_ID ");
			OracleParameter[] parameters = {
					new OracleParameter(":TEAM_ID",OracleDbType.Varchar2)			};
            parameters[0].Value = model.TEAM_ID;
            SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
		}

		/// <summary>
		/// 获得数据列表
		/// </summary>
        public DataTable GetList(TeamModel model)
		{
			StringBuilder strSql=new StringBuilder();
            strSql.Append("select ");
            strSql.Append("t.TEAM_ID,");
            strSql.Append("t.TEAM_NAME,");
            strSql.Append("t.TEAM_MASTER,");
            strSql.Append("b.NAME as TEAM_MASTER_NAME,");
            strSql.Append("t.REMARK,");
            strSql.Append("t.PY_NAME,");
            strSql.Append("t.WORK_TYPE,");
            strSql.Append("t.DEP_ID,");
            strSql.Append("c.COM_NAME DEP_NAME");
			strSql.Append(" FROM T_SYS_TEAM t");
            strSql.Append(" LEFT JOIN T_BASE_USERINFO b ON  b.USER_ID = t.TEAM_MASTER");
            strSql.Append(" LEFT JOIN t_Base_Company c ON  c.COM_ID = t.DEP_ID");
            strSql.Append(" where 1=1 ");
            if (!string.IsNullOrEmpty(model.TEAM_ID))
            {
                strSql.Append(" and  t.TEAM_ID ='" + model.TEAM_ID + "'");
            }
            if (!string.IsNullOrEmpty(model.TEAM_NAME))
            {
                strSql.Append(" and  t.TEAM_NAME like '%" + model.TEAM_NAME + "%'");
            }
            strSql.Append(" order by t.TEAM_ID");
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
		}
		#endregion  BasicMethod
	}
}