private string ChackEmpCard(string mEmpID )//现在是一个参数，我需要的是3个参数进行比较
        {
            string retValue = string.Empty;


           

            try
            {
                if (EmpDate == null || EmpDate.Rows.Count < 1)
                {
                    if (EmpDate == null)
                    {
                        EmpDate = new DataTable();
                    }

                    System.Data.SqlClient.SqlConnection SqlConn = new System.Data.SqlClient.SqlConnection(YC.DataSets.ConnectConfig.ConnectionString);
                    System.Data.SqlClient.SqlCommand SqlCmd = new System.Data.SqlClient.SqlCommand();

                    SqlCmd.CommandText = "Select " +
                                         "      A.EmployeeID, " +
                                         "      A.EmployeeStrID, " +
                                         "      B.CardID, " +
                                         "      B.CardStatusIDXF " +   
                                         "From  " +
                                         "      TC_Employee AS A  " +
                                         "      LEFT OUTER JOIN TC_Card AS B On A.CardID = B.CardID ";

                    SqlCmd.Connection = SqlConn;

                    SqlConn.Open();

                    System.Data.SqlClient.SqlDataAdapter SqlDa = new System.Data.SqlClient.SqlDataAdapter(SqlCmd);

                    SqlDa.Fill(EmpDate);

                    if (SqlConn.State == System.Data.ConnectionState.Open)
                    {
                        SqlConn.Close();
                    }

                    if (EmpDate == null || EmpDate.Rows.Count < 1)
                    {
                        return "取得人员信息失败";
                    }
                }

                DataRow[] dr = EmpDate.Select("EmployeeID = " + mEmpID );
                DataRow[] na = EmpDate.Select("EmpolyeeName=" + name);
                DataRow[] ty = EmpDate.Select("CardTypeid=" + type);

                if (dr.Length < 1)
                {
                    retValue = "库中无此人";
                }
                
              
            }
            catch
            {
                retValue = "取得人员信息失败";
            }

            return retValue;
        }